Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Climbing, Eating, Foraging, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Indifferent
Link | rowid | Longitude | Latitude | Unique_Squirrel_ID | Hectare | Shift | Date | Hectare_Squirrel_Number | Age | Primary_Fur_Color | Highlight_Fur_Color | Combination_of_Primary_and_Highlight_Color | Color_notes | Location | Above_Ground_Sighter_Measurement | Specific_Location | Running | Chasing | Climbing | Eating | Foraging | Other_Activities | Kuks | Quaas | Moans | Tail_flags | Tail_twitches | Approaches | Indifferent | Runs_from | Other_Interactions | Latlong | Zip_Codes | Community_Districts | Borough_Boundaries | City_Council_Districts | Police_Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | -73.9771646835311 | 40.769304916508396 | 4C-PM-1010-05 | 04C | PM | 1010 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
11 | 11 | -73.9686479277215 | 40.7705815354769 | 9I-AM-1014-08 | 09I | AM | 1014 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686479277215 40.7705815354769) | 19 | 4 | 19 | 13 | |||||
13 | 13 | -73.96279043284021 | 40.7939375305761 | 34A-PM-1013-04 | 34A | PM | 1013 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | digging & burying | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9627904328402 40.7939375305761) | 19 | 4 | 19 | 13 | ||||
14 | 14 | -73.968367485157 | 40.7838472644815 | 22B-PM-1014-05 | 22B | PM | 1014 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating (eats with head tilted far to the right (tooth issue?)) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968367485157 40.7838472644815) | 19 | 4 | 19 | 13 | |||||
16 | 16 | -73.97683095561271 | 40.7717803706095 | 6B-AM-1012-01 | 06B | AM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Started in field, crossed busy street, ran up tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9768309556127 40.7717803706095) | 19 | 4 | 19 | 13 | ||||
20 | 20 | -73.9589635326362 | 40.7951748673846 | 37C-AM-1012-02 | 37C | AM | 1012 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon flanks, light band across nose | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | caching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589635326362 40.7951748673846) | 19 | 4 | 19 | 13 | |||
23 | 23 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540652304705 40.7955226178199) | 19 | 4 | 19 | 13 | |||||
31 | 31 | -73.9626120417397 | 40.790512635862605 | 30C-AM-1014-02 | 30C | AM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on a rock | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9626120417397 40.7905126358626) | 19 | 4 | 19 | 13 | ||||
33 | 33 | -73.969628583287 | 40.770406779793205 | 8H-AM-1017-03 | 08H | AM | 1017 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | fence | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.969628583287 40.7704067797932) | 19 | 4 | 19 | 13 | ||||
35 | 35 | -73.96419899145691 | 40.789081044511 | 28B-AM-1007-01 | 28B | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | wresting w/ branch | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9641989914569 40.789081044511) | 19 | 4 | 19 | 13 | ||||
39 | 39 | -73.968807163616 | 40.7812018159499 | 19C-PM-1018-02 | 19C | PM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.968807163616 40.7812018159499) | 19 | 4 | 19 | 13 | |||||
49 | 49 | -73.971213385696 | 40.769872094337 | 7H-AM-1006-04 | 07H | AM | 1006 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971213385696 40.769872094337) | 19 | 4 | 19 | 13 | |||||
52 | 52 | -73.9564215689843 | 40.7957539444068 | 38E-AM-1010-01 | 38E | AM | 1010 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564215689843 40.7957539444068) | 19 | 4 | 19 | 13 | |||||
54 | 54 | -73.9710674928906 | 40.7778757544025 | 15D-PM-1017-06 | 15D | PM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | walking | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | stopped and watched me before slowly moving on | POINT (-73.9710674928906 40.7778757544025) | 19 | 4 | 19 | 13 | |||
55 | 55 | -73.9556817958407 | 40.788852000621 | 32I-AM-1013-02 | 32I | AM | 1013 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | watching me from tree - curious | POINT (-73.9556817958407 40.788852000621) | 19 | 4 | 19 | 13 | ||||
57 | 57 | -73.9714150090362 | 40.7774976423922 | 14C-PM-1006-03 | 14C | PM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9714150090362 40.7774976423922) | 19 | 4 | 19 | 13 | |||||
58 | 58 | -73.9612352611518 | 40.7944813634744 | 35B-AM-1010-02 | 35B | AM | 1010 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | landscaped area | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9612352611518 40.7944813634744) | 19 | 4 | 19 | 13 | ||||
61 | 61 | -73.9810149147578 | 40.7683925377714 | 2A-AM-1010-03 | 02A | AM | 1010 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | on trunk | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9810149147578 40.7683925377714) | 19 | 4 | 19 | 13 | ||||
64 | 64 | -73.976769659152 | 40.7741908010484 | 9A-AM-1013-04 | 09A | AM | 1013 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976769659152 40.7741908010484) | 19 | 4 | 19 | 13 | |||||
67 | 67 | -73.9684657285532 | 40.7840113573723 | 22B-AM-1013-05 | 22B | AM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looked down on me like her imperial subject | POINT (-73.9684657285532 40.7840113573723) | 19 | 4 | 19 | 13 | ||||
70 | 70 | -73.9561103688639 | 40.794914085004 | 37E-AM-1013-03 | 37E | AM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9561103688639 40.794914085004) | 19 | 4 | 19 | 13 | |||||
71 | 71 | -73.970595860252 | 40.7832060751268 | 20A-AM-1010-01 | 20A | AM | 1010 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970595860252 40.7832060751268) | 19 | 4 | 19 | 13 | |||||
73 | 73 | -73.9757215415855 | 40.766820597698604 | 2F-PM-1014-03 | 02F | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757215415855 40.7668205976986) | 19 | 4 | 19 | 13 | |||||
75 | 75 | -73.9743060404813 | 40.7687901781431 | 5F-PM-1007-02 | 05F | PM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9743060404813 40.7687901781431) | 19 | 4 | 19 | 13 | |||||
76 | 76 | -73.9674724790652 | 40.7768771349868 | 15G-PM-1019-01 | 15G | PM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9674724790652 40.7768771349868) | 19 | 4 | 19 | 13 | |||||
81 | 81 | -73.9632646049622 | 40.781740129208295 | 22G-AM-1018-05 | 22G | AM | 1018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9632646049622 40.7817401292083) | 19 | 4 | 19 | 13 | |||||
85 | 85 | -73.97638367403421 | 40.7706121151491 | 5C-AM-1006-06 | 05C | AM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9763836740342 40.7706121151491) | 19 | 4 | 19 | 13 | |||||
87 | 87 | -73.9769887473852 | 40.7707561532949 | 5C-PM-1010-04 | 05C | PM | 1010 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769887473852 40.7707561532949) | 19 | 4 | 19 | 13 | |||||
90 | 90 | -73.9583762071264 | 40.7852226065643 | 27I-PM-1020-03 | 27I | PM | 1020 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging for food; on hind legs | POINT (-73.9583762071264 40.7852226065643) | 19 | 4 | 19 | 13 | ||||
101 | 101 | -73.955710327539 | 40.797451079756705 | 40D-AM-1013-03 | 40D | AM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955710327539 40.7974510797567) | 19 | 4 | 19 | 13 | |||||
102 | 102 | -73.95657388959721 | 40.7900160952624 | 32H-AM-1010-01 | 32H | AM | 1010 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | not sure; walking-stop-walking-stop | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | did seem to observe me for a moment | POINT (-73.9565738895972 40.7900160952624) | 19 | 4 | 19 | 13 | |||
105 | 105 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 1013 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.969345754447 40.7770429650288) | 19 | 4 | 19 | 13 | |||||
112 | 112 | -73.9596505138955 | 40.794036773498796 | 35C-PM-1013-06 | 35C | PM | 1013 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596505138955 40.7940367734988) | 19 | 4 | 19 | 13 | |||||
113 | 113 | -73.9680774548516 | 40.7762491903691 | 14F-PM-1012-01 | 14F | PM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680774548516 40.7762491903691) | 19 | 4 | 19 | 13 | |||||
117 | 117 | -73.9675697600155 | 40.776679741446294 | 15G-PM-1019-06 | 15G | PM | 1019 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | scratching! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675697600155 40.7766797414463) | 19 | 4 | 19 | 13 | ||||
118 | 118 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | 19 | 4 | 19 | 13 | |||
123 | 123 | -73.96908283251791 | 40.781803817227505 | 19C-PM-1018-04 | 19C | PM | 1018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690828325179 40.7818038172275) | 19 | 4 | 19 | 13 | |||||
125 | 125 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4.0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.963911430308 40.7809127228847) | 19 | 4 | 19 | 13 | |||||
129 | 129 | -73.960094705031 | 40.7916066137699 | 33D-AM-1017-01 | 33D | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960094705031 40.7916066137699) | 19 | 4 | 19 | 13 | |||||
141 | 141 | -73.96431539204279 | 40.78208185169571 | 22F-PM-1014-05 | 22F | PM | 1014 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9643153920428 40.7820818516957) | 19 | 4 | 19 | 13 | |||||
144 | 144 | -73.9761527947483 | 40.770960700253895 | 6C-AM-1007-06 | 06C | AM | 1007 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | disappeared when jogger ran by | POINT (-73.9761527947483 40.7709607002539) | 19 | 4 | 19 | 13 | ||||
151 | 151 | -73.9715621134573 | 40.7695918717513 | 7H-AM-1006-02 | 07H | AM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | running (along ground,up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715621134573 40.7695918717513) | 19 | 4 | 19 | 13 | ||||
158 | 158 | -73.9742010726136 | 40.769150169929 | 5F-AM-1007-03 | 05F | AM | 1007 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742010726136 40.769150169929) | 19 | 4 | 19 | 13 | |||||
160 | 160 | -73.959514034869 | 40.789911786416 | 31E-PM-1006-02 | 31E | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | under bushes | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959514034869 40.789911786416) | 19 | 4 | 19 | 13 | ||||
161 | 161 | -73.9693338657183 | 40.775705588453796 | 13F-PM-1008-05 | 13F | PM | 1008 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | tree trunk | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9693338657183 40.7757055884538) | 19 | 4 | 19 | 13 | ||||
164 | 164 | -73.95320745731391 | 40.793466946490796 | 37H-PM-1006-06 | 37H | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532074573139 40.7934669464908) | 19 | 4 | 19 | 13 | ||||
165 | 165 | -73.95828003055091 | 40.798947371297395 | 40B-PM-1014-03 | 40B | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582800305509 40.7989473712974) | 19 | 4 | 19 | 13 | |||||
167 | 167 | -73.9638526062093 | 40.782693848993 | 22F-AM-1007-02 | 22F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | standing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9638526062093 40.782693848993) | 19 | 4 | 19 | 13 | ||||
175 | 175 | -73.9682688752331 | 40.7711934835539 | 9I-PM-1010-06 | 09I | PM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9682688752331 40.7711934835539) | 19 | 4 | 19 | 13 | |||||
176 | 176 | -73.9652921233647 | 40.790440565854 | 29A-PM-1019-01 | 29A | PM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9652921233647 40.790440565854) | 19 | 4 | 19 | 13 | |||||
182 | 182 | -73.9615402629655 | 40.7924082330328 | 33C-AM-1012-02 | 33C | AM | 1012 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon along back & tail | Above Ground | 20.0 | tree branches | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615402629655 40.7924082330328) | 19 | 4 | 19 | 13 | |||
183 | 183 | -73.9801971465604 | 40.7697081749827 | 3A-PM-1017-04 | 03A | PM | 1017 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9801971465604 40.7697081749827) | 19 | 4 | 19 | 13 | |||||
186 | 186 | -73.9710273070712 | 40.776652124615296 | 14D-PM-1019-16 | 14D | PM | 1019 | 16 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9710273070712 40.7766521246153) | 19 | 4 | 19 | 13 | |||||
195 | 195 | -73.9737872335563 | 40.7726586835985 | 8D-PM-1007-01 | 08D | PM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9737872335563 40.7726586835985) | 19 | 4 | 19 | 13 | |||||
210 | 210 | -73.9752965316933 | 40.775253857578896 | 10B-AM-1006-03 | 10B | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
213 | 213 | -73.9691801791373 | 40.770927235357206 | 9I-AM-1014-04 | 09I | AM | 1014 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691801791373 40.7709272353572) | 19 | 4 | 19 | 13 | |||||
216 | 216 | -73.96032682553171 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 1006 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603268255317 40.7900154505092) | 19 | 4 | 19 | 13 | |||||
221 | 221 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 1006 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9706949930717 40.772362045852) | 19 | 4 | 19 | 13 | |||||
227 | 227 | -73.9755569170561 | 40.7668006977526 | 2F-AM-1006-03 | 02F | AM | 1006 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25.0 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9755569170561 40.7668006977526) | 19 | 4 | 19 | 13 | ||||
233 | 233 | -73.9725844658514 | 40.7701092834201 | 7F-PM-1012-02 | 07F | PM | 1012 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | observes | POINT (-73.9725844658514 40.7701092834201) | 19 | 4 | 19 | 13 | ||||
240 | 240 | -73.9554327683595 | 40.7953846381499 | 38E-AM-1010-05 | 38E | AM | 1010 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | interested in my presence | POINT (-73.9554327683595 40.7953846381499) | 19 | 4 | 19 | 13 | ||||
244 | 244 | -73.9770920860805 | 40.769469804008295 | 4C-PM-1010-01 | 04C | PM | 1010 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6.0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9770920860805 40.7694698040083) | 19 | 4 | 19 | 13 | |||||
253 | 253 | -73.9801956082236 | 40.767836440957 | 1B-AM-1012-08 | 01B | AM | 1012 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801956082236 40.767836440957) | 19 | 4 | 19 | 13 | |||||
262 | 262 | -73.97744073625871 | 40.7698056129554 | 4C-PM-1010-12 | 04C | PM | 1010 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9774407362587 40.7698056129554) | 19 | 4 | 19 | 13 | |||||
268 | 268 | -73.9745427984089 | 40.7691848214817 | 5E-AM-1008-03 | 05E | AM | 1008 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9745427984089 40.7691848214817) | 19 | 4 | 19 | 13 | |||||
272 | 272 | -73.9598015842806 | 40.7973522744237 | 38A-PM-1013-03 | 38A | PM | 1013 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598015842806 40.7973522744237) | 19 | 4 | 19 | 13 | |||||
274 | 274 | -73.9733437449715 | 40.778240154836205 | 14B-PM-1014-07 | 14B | PM | 1014 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9733437449715 40.7782401548362) | 19 | 4 | 19 | 13 | |||||
281 | 281 | -73.9632866142841 | 40.7890043294436 | 29C-PM-1006-01 | 29C | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | not too shy | POINT (-73.9632866142841 40.7890043294436) | 19 | 4 | 19 | 13 | ||||
292 | 292 | -73.9601486483164 | 40.7943724108626 | 35C-PM-1013-02 | 35C | PM | 1013 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | approaches (when i crouched down) | POINT (-73.9601486483164 40.7943724108626) | 19 | 4 | 19 | 13 | |||||
300 | 300 | -73.9710547484029 | 40.7723589827074 | 9F-PM-1014-03 | 09F | PM | 1014 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710547484029 40.7723589827074) | 19 | 4 | 19 | 13 | |||||
307 | 307 | -73.9719038949487 | 40.770353349248204 | 7G-AM-1010-05 | 07G | AM | 1010 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719038949487 40.7703533492482) | 19 | 4 | 19 | 13 | |||||
318 | 318 | -73.95486485185579 | 40.7946730924872 | 38F-PM-1013-03 | 38F | PM | 1013 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9548648518558 40.7946730924872) | 19 | 4 | 19 | 13 | |||||
320 | 320 | -73.9693254080548 | 40.77616003271179 | 14F-AM-1007-01 | 14F | AM | 1007 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693254080548 40.7761600327118) | 19 | 4 | 19 | 13 | |||||
322 | 322 | -73.9663168490265 | 40.7825083721362 | 21D-AM-1008-01 | 21D | AM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9663168490265 40.7825083721362) | 19 | 4 | 19 | 13 | |||||
325 | 325 | -73.9705837974358 | 40.775849484967296 | 13E-AM-1017-13 | 13E | AM | 1017 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | on rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9705837974358 40.7758494849673) | 19 | 4 | 19 | 13 | ||||
330 | 330 | -73.95473986848171 | 40.7896483795302 | 33I-AM-1008-01 | 33I | AM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park @ 98th (north) | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547398684817 40.7896483795302) | 19 | 4 | 19 | 13 | ||||
332 | 332 | -73.9701596268736 | 40.7702106607329 | 8H-PM-1014-09 | 08H | PM | 1014 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9701596268736 40.7702106607329) | 19 | 4 | 19 | 13 | |||||
337 | 337 | -73.954595058342 | 40.7956567934304 | 39F-AM-1014-04 | 39F | AM | 1014 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.954595058342 40.7956567934304) | 19 | 4 | 19 | 13 | |||||
341 | 341 | -73.9754709117681 | 40.7681421869407 | 3E-AM-1006-08 | 03E | AM | 1006 | 8 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9754709117681 40.7681421869407) | 19 | 4 | 19 | 13 | |||||
354 | 354 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 1019 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2.0 | Behind fence, tree trunk | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710221361528 40.7724939691584) | 19 | 4 | 19 | 13 | ||
359 | 359 | -73.9773898301093 | 40.770858156205705 | 5B-AM-1008-01 | 05B | AM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | running across ball field 5,near home plate | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9773898301093 40.7708581562057) | 19 | 4 | 19 | 13 | ||||
360 | 360 | -73.95257475169142 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 1017 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9525747516914 40.7977257435263) | 19 | 4 | 19 | 13 | ||||
363 | 363 | -73.9611300905602 | 40.7918743735665 | 32C-PM-1013-07 | 32C | PM | 1013 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9611300905602 40.7918743735665) | 19 | 4 | 19 | 13 | |||||
365 | 365 | -73.98025646852649 | 40.768175909819895 | 2B-AM-1010-05 | 02B | AM | 1010 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9802564685265 40.7681759098199) | 19 | 4 | 19 | 13 | |||||
381 | 381 | -73.97357533521291 | 40.7687061447032 | 5G-PM-1010-04 | 05G | PM | 1010 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9735753352129 40.7687061447032) | 19 | 4 | 19 | 13 | |||||
399 | 399 | -73.9651828383592 | 40.780282094386294 | 19F-PM-1017-06 | 19F | PM | 1017 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9651828383592 40.7802820943863) | 19 | 4 | 19 | 13 | |||||
401 | 401 | -73.9726090882487 | 40.7710199108849 | 7F-AM-1008-14 | 07F | AM | 1008 | 14 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9726090882487 40.7710199108849) | 19 | 4 | 19 | 13 | ||||
403 | 403 | -73.96868007849409 | 40.77667390291379 | 15F-AM-1007-03 | 15F | AM | 1007 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686800784941 40.7766739029138) | 19 | 4 | 19 | 13 | ||||
404 | 404 | -73.9599424115626 | 40.79574725853271 | 37B-AM-1018-05 | 37B | AM | 1018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599424115626 40.7957472585327) | 19 | 4 | 19 | 13 | |||||
405 | 405 | -73.97321932906308 | 40.7748791447746 | 11D-PM-1006-01 | 11D | PM | 1006 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9732193290631 40.7748791447746) | 19 | 4 | 19 | 13 | |||||
409 | 409 | -73.97469348106671 | 40.7659431884158 | 2G-PM-1007-02 | 02G | PM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | burying nut | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746934810667 40.7659431884158) | 19 | 4 | 19 | 13 | ||||
413 | 413 | -73.9721348050673 | 40.7666920046704 | 3H-AM-1008-01 | 03H | AM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8.0 | 0 | 0 | 0 | 0 | 0 | teasing barking dog | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent by not caring about dog | POINT (-73.9721348050673 40.7666920046704) | 19 | 4 | 19 | 13 | |||
421 | 421 | -73.96914249979191 | 40.780542852496 | 18C-AM-1018-02 | 18C | AM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691424997919 40.780542852496) | 19 | 4 | 19 | 13 | |||||
423 | 423 | -73.9811218801005 | 40.7684406206185 | 1A-PM-1014-07 | 01A | PM | 1014 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9811218801005 40.7684406206185) | 19 | 4 | 19 | 13 | |||||
427 | 427 | -73.95656845779891 | 40.79360039404129 | 36F-PM-1012-02 | 36F | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565684577989 40.7936003940413) | 19 | 4 | 19 | 13 | |||||
434 | 434 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 1008 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9753291616796 40.7687376032936) | 19 | 4 | 19 | 13 | |||||
440 | 440 | -73.957138759793 | 40.795592603505504 | 38D-PM-1006-02 | 38D | PM | 1006 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138759793 40.7955926035055) | 19 | 4 | 19 | 13 | |||||
442 | 442 | -73.9787105069657 | 40.7693708133873 | 3B-AM-1010-08 | 03B | AM | 1010 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | together w/ #7 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787105069657 40.7693708133873) | 19 | 4 | 19 | 13 | ||||
461 | 461 | -73.9730027200009 | 40.7798000868804 | 16A-PM-1019-05 | 16A | PM | 1019 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730027200009 40.7798000868804) | 19 | 4 | 19 | 13 | |||||
465 | 465 | -73.9784863123685 | 40.7669225020831 | 1D-AM-1006-08 | 01D | AM | 1006 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 45.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9784863123685 40.7669225020831) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE "2018_Central_Park_Squirrel_Census" ( "Longitude" REAL, "Latitude" REAL, "Unique_Squirrel_ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" INTEGER, "Hectare_Squirrel_Number" INTEGER, "Age" REAL, "Primary_Fur_Color" REAL, "Highlight_Fur_Color" REAL, "Combination_of_Primary_and_Highlight_Color" TEXT, "Color_notes" REAL, "Location" REAL, "Above_Ground_Sighter_Measurement" REAL, "Specific_Location" REAL, "Running" INTEGER, "Chasing" INTEGER, "Climbing" INTEGER, "Eating" INTEGER, "Foraging" INTEGER, "Other_Activities" REAL, "Kuks" INTEGER, "Quaas" INTEGER, "Moans" INTEGER, "Tail_flags" INTEGER, "Tail_twitches" INTEGER, "Approaches" INTEGER, "Indifferent" INTEGER, "Runs_from" INTEGER, "Other_Interactions" REAL, "Latlong" TEXT, "Zip_Codes" REAL, "Community_Districts" INTEGER, "Borough_Boundaries" INTEGER, "City_Council_Districts" INTEGER, "Police_Precincts" INTEGER )