Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
These facets timed out: Primary_Fur_Color, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559 | 2559 | -73.96915208260279 | 40.77171040377829 | 10H-AM-1014-06 | 10H | AM | 1014 | 6 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9691520826028 40.7717104037783) | 19 | 4 | 19 | 13 | |||||||
2604 | 2604 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 1006 | 3 | Black | Black+ | Above Ground | 15.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | 19 | 4 | 19 | 13 | ||||||
2628 | 2628 | -73.976798124308 | 40.774131657411296 | 9A-PM-1010-04 | 09A | PM | 1010 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.976798124308 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
2632 | 2632 | -73.9655955841325 | 40.7762063860571 | 15H-PM-1008-04 | 15H | PM | 1008 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of landscape | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655955841325 40.7762063860571) | 19 | 4 | 19 | 13 | |||||
2651 | 2651 | -73.9677779408464 | 40.78674822113489 | 25A-AM-1013-02 | 25A | AM | 1013 | 2 | Gray | Gray+ | Above Ground | 15.0 | BIG TREE | 0 | 1 | 0 | 0 | 0 | chasing #3 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9677779408464 40.7867482211349) | 19 | 4 | 19 | 13 | |||||
2718 | 2718 | -73.95974626120629 | 40.783280114530605 | 25I-PM-1007-06 | 25I | PM | 1007 | 6 | + | Didn't see squirrel size, or colors | Above Ground | 20.0 | up in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9597462612063 40.7832801145306) | 19 | 4 | 19 | 13 | ||||||
2722 | 2722 | -73.9643664403785 | 40.77936707037271 | 19H-AM-1010-01 | 19H | AM | 1010 | 1 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | near base of small tree | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | run from human w/ dog | POINT (-73.9643664403785 40.7793670703727) | 19 | 4 | 19 | 13 | ||||
2753 | 2753 | -73.9681960138614 | 40.7726867422002 | 11H-AM-1010-02 | 11H | AM | 1010 | 2 | Cinnamon | Gray | Cinnamon+Gray | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681960138614 40.7726867422002) | 19 | 4 | 19 | 13 | ||||||||
2756 | 2756 | -73.9730926233232 | 40.7781330751738 | 14B-PM-1014-08 | 14B | PM | 1014 | 8 | Gray | Cinnamon, White | Gray+Cinnamon, White | White belly & stripes on tail, Cinnamon face & stripes on back | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730926233232 40.7781330751738) | 19 | 4 | 19 | 13 | |||||
2771 | 2771 | -73.9553038162633 | 40.7909367783223 | 34H-PM-1006-04 | 34H | PM | 1006 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Elm tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9553038162633 40.7909367783223) | 19 | 4 | 19 | 13 | ||||||
2783 | 2783 | -73.9611118778753 | 40.7952007875354 | 36A-PM-1013-01 | 36A | PM | 1013 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9611118778753 40.7952007875354) | 19 | 4 | 19 | 13 | |||||
2816 | 2816 | -73.97431653210991 | 40.775467467857396 | 11B-PM-1014-07 | 11B | PM | 1014 | 7 | Gray | Gray+ | Above Ground | 10.0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9743165321099 40.7754674678574) | 19 | 4 | 19 | 13 | |||||||
2834 | 2834 | -73.98096101171708 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 1010 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
2848 | 2848 | -73.95651796713192 | 40.7936663940365 | 36F-PM-1012-03 | 36F | PM | 1012 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9565179671319 40.7936663940365) | 19 | 4 | 19 | 13 | ||||||
2854 | 2854 | -73.9674556940019 | 40.7875399402461 | 26A-AM-1014-02 | 26A | AM | 1014 | 2 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | could not get close due to fences | POINT (-73.9674556940019 40.7875399402461) | 19 | 4 | 19 | 13 | |||||
2925 | 2925 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 1014 | 3 | Gray | Gray+ | Above Ground | 10.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9746877519291 40.7761402808083) | 19 | 4 | 19 | 13 | |||||||
2931 | 2931 | -73.9598340783572 | 40.7915857030295 | 33D-PM-1006-02 | 33D | PM | 1006 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9598340783572 40.7915857030295) | 19 | 4 | 19 | 13 | ||||||
2976 | 2976 | -73.9694344956258 | 40.7742869276902 | 12G-PM-1007-01 | 12G | PM | 1007 | 1 | Gray | Gray+ | Above Ground | 40.0 | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9694344956258 40.7742869276902) | 19 | 4 | 19 | 13 | ||||||
2980 | 2980 | -73.96874625660729 | 40.783898987005 | 22B-PM-1014-06 | 22B | PM | 1014 | 6 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10.0 | 0 | 0 | 0 | 0 | 0 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687462566073 40.783898987005) | 19 | 4 | 19 | 13 | |||||
2982 | 2982 | -73.9665572004288 | 40.780434754830296 | 19E-PM-1018-04 | 19E | PM | 1018 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665572004288 40.7804347548303) | 19 | 4 | 19 | 13 | |||||||
3013 | 3013 | -73.9554432393295 | 40.794566905444896 | 37F-PM-1014-01 | 37F | PM | 1014 | 1 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9554432393295 40.7945669054449) | 19 | 4 | 19 | 13 | |||||||
3024 | 3024 | -73.9688574691102 | 40.7837825208444 | 21B-AM-1019-04 | 21B | AM | 1019 | 4 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688574691102 40.7837825208444) | 19 | 4 | 19 | 13 | ||||||||||
3029 | 3029 | -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 | |||||
3037 | 3037 | -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 | |||||
3047 | 3047 | -73.9613351649026 | 40.79098668513571 | 31D-AM-1014-03 | 31D | AM | 1014 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | Undergrowth | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9613351649026 40.7909866851357) | 19 | 4 | 19 | 13 | |||||
3055 | 3055 | -73.9682803241007 | 40.772451055832704 | 11H-AM-1010-04 | 11H | AM | 1010 | 4 | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9682803241007 40.7724510558327) | 19 | 4 | 19 | 13 | ||||||||
3109 | 3109 | -73.9742986032935 | 40.7770454318226 | 13A-PM-1014-04 | 13A | PM | 1014 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9742986032935 40.7770454318226) | 19 | 4 | 19 | 13 | |||||||
3147 | 3147 | -73.9540908513075 | 40.794201225045 | 37G-PM-1007-04 | 37G | PM | 1007 | 4 | Cinnamon | Gray | Cinnamon+Gray | gray tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9540908513075 40.794201225045) | 19 | 4 | 19 | 13 | |||||
3160 | 3160 | -73.9694169352433 | 40.774440829385796 | 12G-PM-1007-03 | 12G | PM | 1007 | 3 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | bushes | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | friendly | POINT (-73.9694169352433 40.7744408293858) | 19 | 4 | 19 | 13 | ||||
3217 | 3217 | -73.96081673001041 | 40.795434868826796 | 36A-PM-1013-05 | 36A | PM | 1013 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608167300104 40.7954348688268) | 19 | 4 | 19 | 13 | |||||
3221 | 3221 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 1006 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | 19 | 4 | 19 | 13 | ||||
3268 | 3268 | -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 | ||||||||
3296 | 3296 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 1013 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
3315 | 3315 | -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 | |||||
3326 | 3326 | -73.9561344937861 | 40.794082388408604 | 37F-PM-1014-03 | 37F | PM | 1014 | 3 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9561344937861 40.7940823884086) | 19 | 4 | 19 | 13 | ||||||||||
3340 | 3340 | -73.9695117797648 | 40.7802675743233 | 18C-PM-1018-07 | 18C | PM | 1018 | 7 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695117797648 40.7802675743233) | 19 | 4 | 19 | 13 | |||||||
3361 | 3361 | -73.9615090149261 | 40.794515017391795 | 35A-PM-1013-09 | 35A | PM | 1013 | 9 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9615090149261 40.7945150173918) | 19 | 4 | 19 | 13 | ||||||
3399 | 3399 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 1014 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20.0 | Ground then up tree | 0 | 0 | 1 | 0 | 0 | chased by a doggo | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
3406 | 3406 | -73.9768617690725 | 40.7741877060705 | 9A-PM-1010-03 | 09A | PM | 1010 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | froze - standing on hind legs for ~10 seconds then scampered off | POINT (-73.9768617690725 40.7741877060705) | 19 | 4 | 19 | 13 | |||||
3408 | 3408 | -73.96113123553481 | 40.79501308639129 | 36A-PM-1013-04 | 36A | PM | 1013 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | ON ROCK NEAR POND | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9611312355348 40.7950130863913) | 19 | 4 | 19 | 13 | ||||
3412 | 3412 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 1017 | 1 | + | Above Ground | 30.0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
3469 | 3469 | -73.9676370985166 | 40.7869888639434 | 25A-AM-1013-01 | 25A | AM | 1013 | 1 | Gray | White | Gray+White | White Belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | staring at me | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9676370985166 40.7869888639434) | 19 | 4 | 19 | 13 | ||||
3485 | 3485 | -73.960300330029 | 40.795347587186896 | 36B-AM-1013-03 | 36B | AM | 1013 | 3 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.960300330029 40.7953475871869) | 19 | 4 | 19 | 13 | |||||||
3497 | 3497 | -73.974420668782 | 40.7749628597465 | 10C-PM-1013-04 | 10C | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974420668782 40.7749628597465) | 19 | 4 | 19 | 13 | ||||||
3519 | 3519 | -73.96855981061279 | 40.7807054868066 | 19D-PM-1008-02 | 19D | PM | 1008 | 2 | + | unknown - cannot see, only hear | Above Ground | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9685598106128 40.7807054868066) | 19 | 4 | 19 | 13 | ||||||||
3534 | 3534 | -73.967975586222 | 40.77356830443129 | 12H-PM-1007-07 | 12H | PM | 1007 | 7 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | grass field | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | humans | POINT (-73.967975586222 40.7735683044313) | 19 | 4 | 19 | 13 | ||||
3553 | 3553 | -73.9565759733611 | 40.7992461674802 | 42C-AM-1007-02 | 42C | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565759733611 40.7992461674802) | 19 | 4 | 19 | 13 | ||||||||||
3565 | 3565 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 1007 | 2 | Gray | Gray+ | Above Ground | in tree | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.969347812694 40.7744098063421) | 19 | 4 | 19 | 13 | |||||||
3569 | 3569 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 1014 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9609692861012 40.790502891247) | 19 | 4 | 19 | 13 | ||||||
3615 | 3615 | -73.9669529835992 | 40.787186415136496 | 25A-AM-1013-05 | 25A | AM | 1013 | 5 | Gray | Gray+ | Ground Plane | FALSE | CROSS BRIDLE - INTO TREE TO AVOID DOGGO | 1 | 0 | 1 | 0 | 0 | d.p.t. | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | calm | POINT (-73.9669529835992 40.7871864151365) | 19 | 4 | 19 | 13 | ||||
3627 | 3627 | -73.9673243699918 | 40.787539295772206 | 26A-AM-1014-01 | 26A | AM | 1014 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | could not get close due to fences | POINT (-73.9673243699918 40.7875392957722) | 19 | 4 | 19 | 13 | |||||
3691 | 3691 | -73.96065706156101 | 40.79561507441021 | 36A-PM-1013-08 | 36A | PM | 1013 | 8 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 1 | 0 | 0 | 0 | 0 | running from #7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960657061561 40.7956150744102) | 19 | 4 | 19 | 13 | |||||
3694 | 3694 | -73.9728797531377 | 40.778673314868705 | 15B-PM-1017-01 | 15B | PM | 1017 | 1 | Gray | Gray+ | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728797531377 40.7786733148687) | 19 | 4 | 19 | 13 | ||||||
3700 | 3700 | -73.95283537022091 | 40.7976456178263 | 41F-PM-1019-02 | 41F | PM | 1019 | 2 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9528353702209 40.7976456178263) | 19 | 4 | 19 | 13 | ||||||||||
3714 | 3714 | -73.96867781674841 | 40.7765625256946 | 14F-PM-1012-04 | 14F | PM | 1012 | 4 | + | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9686778167484 40.7765625256946) | 19 | 4 | 19 | 13 | ||||||||||
3744 | 3744 | -73.9690416961886 | 40.7716618670996 | 10H-AM-1014-05 | 10H | AM | 1014 | 5 | Cinnamon | Cinnamon+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9690416961886 40.7716618670996) | 19 | 4 | 19 | 13 | |||||||
3783 | 3783 | -73.9550627447399 | 40.7910104700332 | 34H-PM-1006-02 | 34H | PM | 1006 | 2 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9550627447399 40.7910104700332) | 19 | 4 | 19 | 13 | |||||||
3800 | 3800 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 1012 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9800094828465 40.7677782585639) | 19 | 4 | 19 | 13 | ||||||
3810 | 3810 | -73.9686737866872 | 40.773971402373206 | 12G-PM-1007-06 | 12G | PM | 1007 | 6 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
3882 | 3882 | -73.9583934264026 | 40.7854742185504 | 27I-AM-1007-02 | 27I | AM | 1007 | 2 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583934264026 40.7854742185504) | 19 | 4 | 19 | 13 | ||||||||||
3894 | 3894 | -73.98054238861499 | 40.768204880479395 | 1B-AM-1012-14 | 01B | AM | 1012 | 14 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980542388615 40.7682048804794) | 19 | 4 | 19 | 13 | ||||||
3902 | 3902 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 1012 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
3940 | 3940 | -73.9532804650089 | 40.7934579333341 | 37H-PM-1006-05 | 37H | PM | 1006 | 5 | + | Above Ground | tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9532804650089 40.7934579333341) | 19 | 4 | 19 | 13 | ||||||||
3941 | 3941 | -73.9680833729772 | 40.774187102511505 | 12H-PM-1007-08 | 12H | PM | 1007 | 8 | + | Above Ground | 7.0 | in tree | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9680833729772 40.7741871025115) | 19 | 4 | 19 | 13 | |||||||
3966 | 3966 | -73.95659058682759 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 1006 | 1 | Gray | Gray+ | Above Ground | in the European Beech | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
3998 | 3998 | -73.9639941227864 | 40.7899152327912 | 29B-PM-1010-02 | 29B | PM | 1010 | 2 | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9639941227864 40.7899152327912) | 19 | 4 | 19 | 13 | ||||||
4005 | 4005 | -73.9566571713254 | 40.798985577543505 | 41C-AM-1017-04 | 41C | AM | 1017 | 4 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566571713254 40.7989855775435) | 19 | 4 | 19 | 13 | |||||||
4034 | 4034 | -73.9677474313377 | 40.7742119240825 | 12H-PM-1007-03 | 12H | PM | 1007 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | peanuts | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9677474313377 40.7742119240825) | 19 | 4 | 19 | 13 | |||||
4040 | 4040 | -73.9533085932603 | 40.793487786107505 | 37H-PM-1006-03 | 37H | PM | 1006 | 3 | + | Above Ground | 43.0 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9533085932603 40.7934877861075) | 19 | 4 | 19 | 13 | |||||||
4049 | 4049 | -73.9576530157255 | 40.7868659490397 | 29I-PM-1007-01 | 29I | PM | 1007 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9576530157255 40.7868659490397) | 19 | 4 | 19 | 13 | ||||||
4071 | 4071 | -73.9587879699956 | 40.7908135158551 | 32F-AM-1012-01 | 32F | AM | 1012 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | made a back-door escape from dog off-leash | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9587879699956 40.7908135158551) | 19 | 4 | 19 | 13 | |||||
4072 | 4072 | -73.9607608482656 | 40.7954687648248 | 36A-PM-1013-06 | 36A | PM | 1013 | 6 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | EDGE OF WOODS | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9607608482656 40.7954687648248) | 19 | 4 | 19 | 13 | |||||
4094 | 4094 | -73.9675637870968 | 40.782388067172796 | 21D-PM-1008-02 | 21D | PM | 1008 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9675637870968 40.7823880671728) | 19 | 4 | 19 | 13 | ||||||
4113 | 4113 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 1007 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9668442742942 40.7870781042595) | 19 | 4 | 19 | 13 | ||||||
4157 | 4157 | -73.9678774314725 | 40.7738535171265 | 12H-PM-1007-04 | 12H | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | 0 | 0 | 0 | 1 | 0 | mushroom | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9678774314725 40.7738535171265) | 19 | 4 | 19 | 13 | |||||||
4188 | 4188 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 1018 | 1 | + | Above Ground | 0 | 0 | 0 | 0 | 0 | unknown | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
4199 | 4199 | -73.953287300494 | 40.793520326789 | 37H-PM-1006-04 | 37H | PM | 1006 | 4 | + | Above Ground | 43.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.953287300494 40.793520326789) | 19 | 4 | 19 | 13 | |||||||
4200 | 4200 | -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 | |||||
4267 | 4267 | -73.9750283794865 | 40.772410192782104 | 8C-PM-1013-08 | 08C | PM | 1013 | 8 | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9750283794865 40.7724101927821) | 19 | 4 | 19 | 13 | ||||||
4293 | 4293 | -73.9735489537928 | 40.76812579115229 | 4G-AM-1006-02 | 04G | AM | 1006 | 2 | Gray | White | Gray+White | Above Ground | 12.0 | tree | 0 | 0 | 0 | 0 | 0 | sitting in tree | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9735489537928 40.7681257911523) | 19 | 4 | 19 | 13 | ||||
4298 | 4298 | -73.9603620122205 | 40.7955965755851 | 36B-AM-1013-02 | 36B | AM | 1013 | 2 | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | didn't see me | POINT (-73.9603620122205 40.7955965755851) | 19 | 4 | 19 | 13 | ||||||
4331 | 4331 | -73.95348783164721 | 40.7978951981698 | 41F-PM-1019-01 | 41F | PM | 1019 | 1 | + | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9534878316472 40.7978951981698) | 19 | 4 | 19 | 13 | ||||||||||
4375 | 4375 | -73.9695745672033 | 40.7791835122147 | 17D-AM-1008-06 | 17D | AM | 1008 | 6 | + | Above Ground | high in tree, couldn't see it, only heard it | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695745672033 40.7791835122147) | 19 | 4 | 19 | 13 | ||||||||
4436 | 4436 | -73.96717867152559 | 40.7867352791232 | 25A-AM-1013-04 | 25A | AM | 1013 | 4 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9671786715256 40.7867352791232) | 19 | 4 | 19 | 13 | ||||||
4479 | 4479 | -73.9602609920814 | 40.7942883045566 | 35C-PM-1013-03 | 35C | PM | 1013 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602609920814 40.7942883045566) | 19 | 4 | 19 | 13 | ||||||
4486 | 4486 | -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 | |||||
4552 | 4552 | -73.9600738985438 | 40.793832879875204 | 35C-PM-1013-08 | 35C | PM | 1013 | 8 | + | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
4573 | 4573 | -73.96077013704429 | 40.7955418990855 | 36A-PM-1013-07 | 36A | PM | 1013 | 7 | Gray | Gray+ | Ground Plane | FALSE | "FIELD" | 0 | 1 | 0 | 0 | 0 | chasing #8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9607701370443 40.7955418990855) | 19 | 4 | 19 | 13 | |||||
4656 | 4656 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 1014 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
4677 | 4677 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 1008 | 1 | Gray | Gray+ | Above Ground | 8.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
4701 | 4701 | -73.9688466874605 | 40.77379115598671 | 12G-PM-1007-05 | 12G | PM | 1007 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9688466874605 40.7737911559867) | 19 | 4 | 19 | 13 | ||||||
4720 | 4720 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 1007 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | 19 | 4 | 19 | 13 | ||||||
4765 | 4765 | -73.96021668769791 | 40.7953811003986 | 36B-AM-1013-04 | 36B | AM | 1013 | 4 | Black | Black+ | Above Ground | 20.0 | Moved 20+ feet high above top of tree limb | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9602166876979 40.7953811003986) | 19 | 4 | 19 | 13 | ||||||
4842 | 4842 | -73.97461330580771 | 40.7760646554109 | 11B-PM-1014-04 | 11B | PM | 1014 | 4 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | jumping | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9746133058077 40.7760646554109) | 19 | 4 | 19 | 13 | ||||||
4866 | 4866 | -73.9558589529608 | 40.789240039494096 | 32H-PM-1006-02 | 32H | PM | 1006 | 2 | Gray | Gray+ | Above Ground | 8.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9558589529608 40.7892400394941) | 19 | 4 | 19 | 13 | |||||||
4979 | 4979 | -73.9679833225379 | 40.773854709340206 | 12H-PM-1007-05 | 12H | PM | 1007 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9679833225379 40.7738547093402) | 19 | 4 | 19 | 13 | ||||||
5007 | 5007 | -73.9601259189134 | 40.795535060905706 | 36B-PM-1013-04 | 36B | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9601259189134 40.7955350609057) | 19 | 4 | 19 | 13 | ||||||
5011 | 5011 | -73.9734108731087 | 40.767605139269705 | 4G-AM-1006-03 | 04G | AM | 1006 | 3 | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734108731087 40.7676051392697) | 19 | 4 | 19 | 13 | ||||||
5029 | 5029 | -73.9586085843149 | 40.7946617684536 | 36C-AM-1014-03 | 36C | AM | 1014 | 3 | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9586085843149 40.7946617684536) | 19 | 4 | 19 | 13 | |||||||
5043 | 5043 | -73.97439905767459 | 40.7768690723163 | 12A-PM-1013-04 | 12A | PM | 1013 | 4 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1.0 | 0 | 1 | 0 | 0 | 0 | chasing #3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9743990576746 40.7768690723163) | 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 )