Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Age, Combination_of_Primary_and_Highlight_Color, Location, Above_Ground_Sighter_Measurement, Chasing, Climbing, Eating, Foraging, Kuks, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Zip_Codes, Community_Districts, City_Council_Districts
Highlight_Fur_Color ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
358 | 358 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
598 | 598 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
1676 | 1676 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
2159 | 2159 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 1017 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2504 | 2504 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 1017 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2578 | 2578 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
2868 | 2868 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 1017 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
3381 | 3381 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 1010 | 7 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
3621 | 3621 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 1017 | 4 | Adult | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
4699 | 4699 | -73.97902633720041 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 1013 | 7 | Adult | Gray | White | Gray+White | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
5182 | 5182 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 1017 | 4 | Gray | Gray+ | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
5527 | 5527 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 1017 | 3 | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
5601 | 5601 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 1012 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
5891 | 5891 | -73.957138794884 | 40.7985389822719 | 40C-AM-1017-03 | 40C | AM | 1017 | 3 | Adult | Gray | White | Gray+White | 1 | 1 | 1 | 0 | 0 | chasing (#4),digging | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138794884 40.7985389822719) | 19 | 4 | 19 | 13 | ||||||
6 | 6 | -73.9772164524209 | 40.768839953875606 | 3D-AM-1006-06 | 03D | AM | 1006 | 6 | Gray | Gray+ | Above Ground | 10.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 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 | ||||
44 | 44 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 1012 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
59 | 59 | -73.9520592496349 | 40.797507629981105 | 42G-PM-1014-03 | 42G | PM | 1014 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | on fence | 1 | 0 | 0 | 0 | 0 | prancing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9520592496349 40.7975076299811) | 19 | 4 | 19 | 13 | |||
74 | 74 | -73.9703169373939 | 40.770065882385396 | 7H-AM-1006-13 | 07H | AM | 1006 | 13 | Adult | Gray | Gray+ | Above Ground | 10.0 | 1 | 0 | 0 | 0 | 0 | running (up tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703169373939 40.7700658823854) | 19 | 4 | 19 | 13 | |||||
88 | 88 | -73.9648626810032 | 40.7804506112843 | 20G-AM-1018-02 | 20G | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 5.0 | Ran up tree | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9648626810032 40.7804506112843) | 19 | 4 | 19 | 13 | |||||
104 | 104 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9579645940414 40.7918613498407) | 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 | |||||
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 | ||||
163 | 163 | -73.96294833745279 | 40.7936809905265 | 33A-PM-1018-03 | 33A | PM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 6.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629483374528 40.7936809905265) | 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 | ||||
185 | 185 | -73.9594986107981 | 40.7840083040604 | 25I-AM-1012-03 | 25I | AM | 1012 | 3 | Adult | Cinnamon | Cinnamon+ | Above Ground | 8.0 | on turn, see map | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594986107981 40.7840083040604) | 19 | 4 | 19 | 13 | |||||
189 | 189 | -73.9658747245917 | 40.77540337375321 | 14I-PM-1018-01 | 14I | PM | 1018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
191 | 191 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 1007 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
245 | 245 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 1010 | 4 | + | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9752915601718 40.7739329570033) | 19 | 4 | 19 | 13 | ||||||||
259 | 259 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 1012 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3.0 | tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
264 | 264 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 1010 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
277 | 277 | -73.96378247566071 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 1007 | 8 | Adult | Gray | Gray+ | Above Ground | 40.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9637824756607 40.7904737110761) | 19 | 4 | 19 | 13 | ||||||
278 | 278 | -73.96810426129379 | 40.772331431865 | 11I-PM-1012-04 | 11I | PM | 1012 | 4 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681042612938 40.772331431865) | 19 | 4 | 19 | 13 | ||||||
304 | 304 | -73.97574132156208 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 1008 | 4 | Adult | Gray | Gray+ | Above Ground | 10.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
344 | 344 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 1006 | 1 | Adult | Black | Black+ | Above Ground | 3.0 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 | |||||
351 | 351 | -73.96715495660659 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 1007 | 1 | Adult | Gray | Gray+ | Above Ground | 180.0 | top of tree | 1 | 0 | 0 | 0 | 0 | jumping between branches | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
386 | 386 | -73.95968653180941 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 1013 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
388 | 388 | -73.97702735535249 | 40.7732399463626 | 8A-AM-1013-03 | 08A | AM | 1013 | 3 | Juvenile | + | Above Ground | 3.0 | fence | 1 | 1 | 1 | 1 | 0 | playing tag together | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9770273553525 40.7732399463626) | 19 | 4 | 19 | 13 | |||||
394 | 394 | -73.96199851876159 | 40.79432777435321 | 34A-AM-1012-02 | 34A | AM | 1012 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10.0 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9619985187616 40.7943277743532) | 19 | 4 | 19 | 13 | ||||
456 | 456 | -73.9503533343658 | 40.7976543603953 | 42H-PM-1014-04 | 42H | PM | 1014 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9503533343658 40.7976543603953) | 12,423 | 18 | 4 | 36 | 18 | ||||
476 | 476 | -73.98108436110859 | 40.768790549369896 | 2A-PM-1019-05 | 02A | PM | 1019 | 5 | ? | Gray | Gray+ | Above Ground | 50.0 | in tall planetree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
485 | 485 | -73.9612854506075 | 40.792083067357105 | 32C-PM-1013-04 | 32C | PM | 1013 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 | |||||||
512 | 512 | -73.97696931406509 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 1006 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9.0 | up a tree | 1 | 0 | 1 | 1 | 1 | digging (?) | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
534 | 534 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 1006 | 2 | Adult | Gray | Gray+ | Above Ground | 2.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
587 | 587 | -73.9707487237344 | 40.7800822831001 | 17B-PM-1012-03 | 17B | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 1 | 1 | 0 | 0 | 0 | 2/3 chasing each other | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9707487237344 40.7800822831001) | 19 | 4 | 19 | 13 | ||||
613 | 613 | -73.9782603348665 | 40.7705790257951 | 5B-PM-1013-06 | 05B | PM | 1013 | 6 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9782603348665 40.7705790257951) | 19 | 4 | 19 | 13 | ||||||
616 | 616 | -73.97716146866159 | 40.770967798324705 | 5C-AM-1006-02 | 05C | AM | 1006 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10.0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9771614686616 40.7709677983247) | 19 | 4 | 19 | 13 | |||||
651 | 651 | -73.9736995552241 | 40.77227125186371 | 8E-PM-1008-02 | 08E | PM | 1008 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 10.0 | in tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9736995552241 40.7722712518637) | 19 | 4 | 19 | 13 | ||||
652 | 652 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 1007 | 2 | Adult | Gray | Gray+ | Above Ground | 30.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
661 | 661 | -73.96316467546471 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 1018 | 2 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
675 | 675 | -73.94984217462209 | 40.7969397424182 | 42I-PM-1014-02 | 42I | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 8.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9498421746221 40.7969397424182) | 19 | 4 | 19 | 13 | |||||
684 | 684 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 1007 | 5 | Adult | Gray | Gray+ | Above Ground | 10.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
726 | 726 | -73.9757001944781 | 40.769499790547 | 5E-AM-1008-09 | 05E | AM | 1008 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2.0 | went up tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9757001944781 40.769499790547) | 19 | 4 | 19 | 13 | ||||
752 | 752 | -73.9647605121306 | 40.780396153151706 | 20G-AM-1018-03 | 20G | AM | 1018 | 3 | Adult | Gray | Gray+ | Above Ground | 12.0 | in tree | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9647605121306 40.7803961531517) | 19 | 4 | 19 | 13 | |||||
762 | 762 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 1008 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9574648097543 40.7892508428622) | 19 | 4 | 19 | 13 | |||||
794 | 794 | -73.9765758043111 | 40.771380315403206 | 6C-AM-1007-03 | 06C | AM | 1007 | 3 | Adult | Gray | White | Gray+White | Above Ground | 8.0 | another tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9765758043111 40.7713803154032) | 19 | 4 | 19 | 13 | ||||
796 | 796 | -73.95488263914001 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 1014 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2.0 | up/down tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
810 | 810 | -73.95595201371721 | 40.7950536287174 | 38E-AM-1010-06 | 38E | AM | 1010 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #7 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9559520137172 40.7950536287174) | 19 | 4 | 19 | 13 | |||
820 | 820 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743509423821 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
845 | 845 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 1019 | 7 | Adult | Gray | Gray+ | Above Ground | 25.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970041085185 40.7834427580313) | 19 | 4 | 19 | 13 | ||||||
864 | 864 | -73.96293834202741 | 40.7889383725489 | 29C-AM-1007-02 | 29C | AM | 1007 | 2 | Adult | Black | Gray | Black+Gray | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9629383420274 40.7889383725489) | 19 | 4 | 19 | 13 | |||||
865 | 865 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 1014 | 7 | Adult | Gray | Gray+ | Above Ground | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
873 | 873 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 1013 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
886 | 886 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 1012 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20.0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670858934045 40.7753505024976) | 19 | 4 | 19 | 13 | |||||
899 | 899 | -73.9789687905912 | 40.769269313932796 | 3B-PM-1007-04 | 03B | PM | 1007 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4.0 | At fence | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
922 | 922 | -73.96863045815259 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 1008 | 1 | Adult | Gray | Gray+ | Above Ground | 4.0 | on fallen tree | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
945 | 945 | -73.975809362521 | 40.773470273783495 | 8B-PM-1012-09 | 08B | PM | 1012 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.975809362521 40.7734702737835) | 19 | 4 | 19 | 13 | |||||
1028 | 1028 | -73.9586077039567 | 40.796189647707706 | 38C-AM-1019-10 | 38C | AM | 1019 | 10 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9586077039567 40.7961896477077) | 19 | 4 | 19 | 13 | |||||
1063 | 1063 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 1012 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10.0 | oak tree at end of ramp from Chess House | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
1066 | 1066 | -73.9769700777377 | 40.772848957496706 | 7B-AM-1008-08 | 07B | AM | 1008 | 8 | Adult | Gray | Gray+ | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
1119 | 1119 | -73.9604083891356 | 40.7910284106931 | 32D-AM-1013-05 | 32D | AM | 1013 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9604083891356 40.7910284106931) | 19 | 4 | 19 | 13 | |||||
1135 | 1135 | -73.96205425147491 | 40.794373172213795 | 34A-AM-1012-01 | 34A | AM | 1012 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | chasing from tree to ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9620542514749 40.7943731722138) | 19 | 4 | 19 | 13 | ||||
1155 | 1155 | -73.9501762527462 | 40.797553408607705 | 42H-PM-1014-05 | 42H | PM | 1014 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9501762527462 40.7975534086077) | 12,423 | 18 | 4 | 36 | 18 | ||||
1161 | 1161 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 1010 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10.0 | on stone arch | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1162 | 1162 | -73.9543832609857 | 40.795355063970106 | 39F-AM-1014-02 | 39F | AM | 1014 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2.0 | rocks | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9543832609857 40.7953550639701) | 19 | 4 | 19 | 13 | ||||
1166 | 1166 | -73.97568897660891 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 1006 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12.0 | 1 | 0 | 1 | 0 | 0 | running from dog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
1171 | 1171 | -73.97190362174459 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | ground & tree | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
1177 | 1177 | -73.958719099962 | 40.7947587726617 | 36C-AM-1014-04 | 36C | AM | 1014 | 4 | Gray | White | Gray+White | Above Ground | 15.0 | Ground then tree to eat | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.958719099962 40.7947587726617) | 19 | 4 | 19 | 13 | |||||
1184 | 1184 | -73.96318185288159 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 1018 | 1 | Adult | Gray | Gray+ | Above Ground | 15.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1203 | 1203 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 1018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1.0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
1221 | 1221 | -73.975565603566 | 40.7738462518304 | 9B-AM-1010-03 | 09B | AM | 1010 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4.0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975565603566 40.7738462518304) | 19 | 4 | 19 | 13 | |||||
1246 | 1246 | -73.9797112925048 | 40.76880467784721 | 2B-PM-1013-09 | 02B | PM | 1013 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
1277 | 1277 | -73.95994199262991 | 40.797277472881106 | 38A-AM-1019-01 | 38A | AM | 1019 | 1 | Adult | Gray | Gray+ | Above Ground | 3.0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9599419926299 40.7972774728811) | 19 | 4 | 19 | 13 | ||||||
1279 | 1279 | -73.95879132892291 | 40.7961707624534 | 38C-AM-1019-11 | 38C | AM | 1019 | 11 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9587913289229 40.7961707624534) | 19 | 4 | 19 | 13 | |||||
1292 | 1292 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 1019 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1303 | 1303 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 1007 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
1366 | 1366 | -73.96220300857941 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 1017 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | ran up a tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
1375 | 1375 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 1006 | 3 | Adult | Gray | Gray+ | Above Ground | 8.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | 19 | 4 | 19 | 13 | |||||
1416 | 1416 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 1012 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2.0 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | 19 | 4 | 19 | 13 | ||
1417 | 1417 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 1010 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | branches | 1 | 1 | 0 | 0 | 0 | chasing and being chased by #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
1427 | 1427 | -73.9722737593623 | 40.768963018754 | 6G-AM-1008-04 | 06G | AM | 1008 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | very long tail | Above Ground | 20.0 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9722737593623 40.768963018754) | 19 | 4 | 19 | 13 | |||
1433 | 1433 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 1012 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20.0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) | 19 | 4 | 19 | 13 | |||||
1460 | 1460 | -73.9547336666137 | 40.7938937756332 | 37G-PM-1007-07 | 37G | PM | 1007 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9547336666137 40.7938937756332) | 19 | 4 | 19 | 13 | |||||
1463 | 1463 | -73.97447264347429 | 40.776729630785 | 12A-PM-1013-03 | 12A | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3.0 | 1 | 0 | 0 | 0 | 0 | chased up a tree by #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9744726434743 40.776729630785) | 19 | 4 | 19 | 13 | |||||
1474 | 1474 | -73.96676944398949 | 40.7779501809095 | 17G-PM-1017-03 | 17G | PM | 1017 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | tree & ground | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9667694439895 40.7779501809095) | 19 | 4 | 19 | 13 | ||||
1485 | 1485 | -73.9645365195454 | 40.778153102126296 | 18H-AM-1018-02 | 18H | AM | 1018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Tree | 1 | 1 | 0 | 0 | 0 | playing? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9645365195454 40.7781531021263) | 19 | 4 | 19 | 13 | ||||
1507 | 1507 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 1010 | 3 | Adult | Gray | Gray+ | Above Ground | 50.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722053355548 40.7662094993614) | 19 | 4 | 19 | 13 | ||||||
1528 | 1528 | -73.97076836215841 | 40.775981556612294 | 13E-AM-1017-11 | 13E | AM | 1017 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on/in log | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9707683621584 40.7759815566123) | 19 | 4 | 19 | 13 | |||||
1574 | 1574 | -73.96862962178929 | 40.771812308875 | 10H-AM-1014-02 | 10H | AM | 1014 | 2 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 6.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686296217893 40.771812308875) | 19 | 4 | 19 | 13 | ||||||
1581 | 1581 | -73.9609704650925 | 40.7938786854735 | 34B-AM-1013-03 | 34B | AM | 1013 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15.0 | 1 | 0 | 1 | 0 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | POINT (-73.9609704650925 40.7938786854735) | 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 )