Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Color_notes, Location, Above_Ground_Sighter_Measurement, Specific_Location, Running, Chasing, Eating, Foraging, Other_Activities, Kuks, Quaas, Tail_flags, Tail_twitches, Approaches, Runs_from, Other_Interactions, Community_Districts, City_Council_Districts, Police_Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | -73.97494695668541 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 1014 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
37 | 37 | -73.9555856074105 | 40.7969457685677 | 40E-AM-1014-04 | 40E | AM | 1014 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | on rocks/bushy rocks | 1 | 0 | 0 | 0 | 0 | hiding from bird | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9555856074105 40.7969457685677) | 19 | 4 | 19 | 13 | |||
66 | 66 | -73.9655206571055 | 40.7764851568746 | 16H-PM-1014-02 | 16H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9655206571055 40.7764851568746) | 19 | 4 | 19 | 13 | |||||
130 | 130 | -73.9624296435843 | 40.791320813687 | 31C-PM-1010-02 | 31C | PM | 1010 | 2 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9624296435843 40.791320813687) | 19 | 4 | 19 | 13 | |||||
157 | 157 | -73.97553718499721 | 40.7733561233828 | 9C-PM-1006-02 | 09C | PM | 1006 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755371849972 40.7733561233828) | 19 | 4 | 19 | 13 | |||||
188 | 188 | -73.9756573579063 | 40.7656644063024 | 1G-PM-1010-01 | 01G | PM | 1010 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | too busy eating in his tree | POINT (-73.9756573579063 40.7656644063024) | 19 | 4 | 19 | 13 | ||||
190 | 190 | -73.96967203626271 | 40.779185159819704 | 17D-AM-1008-04 | 17D | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9696720362627 40.7791851598197) | 19 | 4 | 19 | 13 | |||||
201 | 201 | -73.9767100101318 | 40.7675779951996 | 2E-PM-1014-03 | 02E | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767100101318 40.7675779951996) | 19 | 4 | 19 | 13 | |||||
204 | 204 | -73.95661891453521 | 40.7883417969746 | 31H-PM-1008-01 | 31H | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566189145352 40.7883417969746) | 19 | 4 | 19 | 13 | |||||
215 | 215 | -73.9616999731028 | 40.7954126939561 | 36A-AM-1018-02 | 36A | AM | 1018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9616999731028 40.7954126939561) | 19 | 4 | 19 | 13 | ||||
226 | 226 | -73.95848243616551 | 40.7934247634031 | 35D-PM-1013-02 | 35D | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Above Ground | 24.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584824361655 40.7934247634031) | 19 | 4 | 19 | 13 | |||||
263 | 263 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 1013 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9591667162801 40.7937602121568) | 19 | 4 | 19 | 13 | ||||
273 | 273 | -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 | ||||||
310 | 310 | -73.97111769994709 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | Different tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711176999471 40.7724278547281) | 19 | 4 | 19 | 13 | ||||
311 | 311 | -73.97123088643941 | 40.7714534847379 | 9G-AM-1007-04 | 09G | AM | 1007 | 4 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 0 | 0 | grooming | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712308864394 40.7714534847379) | 19 | 4 | 19 | 13 | ||||
342 | 342 | -73.9716271494641 | 40.7796462634184 | 16B-PM-1017-02 | 16B | PM | 1017 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9716271494641 40.7796462634184) | 19 | 4 | 19 | 13 | |||||
377 | 377 | -73.9651796685091 | 40.7785578267586 | 18G-AM-1014-03 | 18G | AM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651796685091 40.7785578267586) | 19 | 4 | 19 | 13 | |||||
385 | 385 | -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 | ||||
411 | 411 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 1007 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | stole (found?) an entire sandwich | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
436 | 436 | -73.9688438058715 | 40.7703014325728 | 8I-AM-1006-05 | 08I | AM | 1006 | 5 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9688438058715 40.7703014325728) | 19 | 4 | 19 | 13 | ||||
446 | 446 | -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 | ||||
448 | 448 | -73.9730284815849 | 40.7702462529502 | 7F-AM-1008-04 | 07F | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | bush | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9730284815849 40.7702462529502) | 19 | 4 | 19 | 13 | ||||
460 | 460 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 1013 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | 19 | 4 | 19 | 13 | |||||
515 | 515 | -73.970804709441 | 40.7758611111219 | 13E-PM-1008-01 | 13E | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.970804709441 40.7758611111219) | 19 | 4 | 19 | 13 | |||||
559 | 559 | -73.9622419917579 | 40.794579797904 | 35A-AM-1014-07 | 35A | AM | 1014 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622419917579 40.794579797904) | 19 | 4 | 19 | 13 | |||||
575 | 575 | -73.9693209851947 | 40.7707450042769 | 8I-AM-1006-01 | 08I | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9693209851947 40.7707450042769) | 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 | ||||
602 | 602 | -73.9715251156965 | 40.774621784862 | 11E-PM-1012-07 | 11E | PM | 1012 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9715251156965 40.774621784862) | 19 | 4 | 19 | 13 | |||||
633 | 633 | -73.9730001080547 | 40.7678719218983 | 4G-AM-1006-05 | 04G | AM | 1006 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | indifferent—was in front of my face (we were on a bridge)! | POINT (-73.9730001080547 40.7678719218983) | 19 | 4 | 19 | 13 | |||
733 | 733 | -73.9754802138871 | 40.773300804411996 | 9C-PM-1006-03 | 09C | PM | 1006 | 3 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9754802138871 40.773300804412) | 19 | 4 | 19 | 13 | |||||
782 | 782 | -73.95423325052309 | 40.793347517143395 | 37G-AM-1014-01 | 37G | AM | 1014 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9542332505231 40.7933475171434) | 19 | 4 | 19 | 13 | ||||
783 | 783 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9617594316752 40.7946803725236) | 19 | 4 | 19 | 13 | |||||
837 | 837 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 1019 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
878 | 878 | -73.9728654439465 | 40.7724853142211 | 9E-AM-1008-04 | 09E | AM | 1008 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728654439465 40.7724853142211) | 19 | 4 | 19 | 13 | |||||
902 | 902 | -73.96459890035891 | 40.778215745915496 | 18H-PM-1014-01 | 18H | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9645989003589 40.7782157459155) | 19 | 4 | 19 | 13 | |||||
935 | 935 | -73.9664669369583 | 40.7774085361976 | 16G-AM-1010-05 | 16G | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9664669369583 40.7774085361976) | 19 | 4 | 19 | 13 | |||||
965 | 965 | -73.9805927710872 | 40.76799891166421 | 1B-PM-1019-07 | 01B | PM | 1019 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9805927710872 40.7679989116642) | 19 | 4 | 19 | 13 | |||||
972 | 972 | -73.9615751148595 | 40.795455123814605 | 36A-AM-1018-01 | 36A | AM | 1018 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | eating (red berries) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9615751148595 40.7954551238146) | 19 | 4 | 19 | 13 | ||||
1007 | 1007 | -73.9722265046794 | 40.7700916895929 | 7G-PM-1018-02 | 07G | PM | 1018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9722265046794 40.7700916895929) | 19 | 4 | 19 | 13 | |||||
1031 | 1031 | -73.9751056714758 | 40.7732060035215 | 8C-PM-1013-03 | 08C | PM | 1013 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9751056714758 40.7732060035215) | 19 | 4 | 19 | 13 | |||||
1067 | 1067 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 1014 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9576094432477 40.7965342664074) | 19 | 4 | 19 | 13 | |||||
1101 | 1101 | -73.95848035139392 | 40.7933802077327 | 35D-PM-1013-01 | 35D | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Above Ground | 12.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584803513939 40.7933802077327) | 19 | 4 | 19 | 13 | |||||
1111 | 1111 | -73.9783366903829 | 40.7668300056094 | 1D-PM-1007-03 | 01D | PM | 1007 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9783366903829 40.7668300056094) | 19 | 4 | 19 | 13 | |||||
1153 | 1153 | -73.9690832219322 | 40.782343340985996 | 20B-PM-1013-06 | 20B | PM | 1013 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9690832219322 40.782343340986) | 19 | 4 | 19 | 13 | |||||
1253 | 1253 | -73.96971787697879 | 40.77915441024221 | 17D-AM-1008-03 | 17D | AM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9697178769788 40.7791544102422) | 19 | 4 | 19 | 13 | |||||
1270 | 1270 | -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 | ||||
1280 | 1280 | -73.96362827608 | 40.780799459524204 | 21G-AM-1014-02 | 21G | AM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | 3.0 | fence | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96362827608 40.7807994595242) | 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 | ||||
1322 | 1322 | -73.97551920769341 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 1014 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9755192076934 40.7664413570796) | 19 | 4 | 19 | 13 | |||||
1339 | 1339 | -73.955516031113 | 40.7923188156277 | 35G-AM-1007-01 | 35G | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.955516031113 40.7923188156277) | 19 | 4 | 19 | 13 | |||||
1344 | 1344 | -73.9598084794625 | 40.797616543450204 | 39A-PM-1014-01 | 39A | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598084794625 40.7976165434502) | 19 | 4 | 19 | 13 | |||||
1400 | 1400 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 1014 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9669432929573 40.779136518298) | 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 | ||||
1478 | 1478 | -73.9693876553956 | 40.7707232748402 | 8I-AM-1006-02 | 08I | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9693876553956 40.7707232748402) | 19 | 4 | 19 | 13 | |||||
1518 | 1518 | -73.968446056806 | 40.785824818871 | 24A-PM-1007-01 | 24A | PM | 1007 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.968446056806 40.785824818871) | 19 | 4 | 19 | 13 | |||||
1536 | 1536 | -73.9564606426367 | 40.788054657260794 | 30I-PM-1006-06 | 30I | PM | 1006 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | ran up tree | POINT (-73.9564606426367 40.7880546572608) | 19 | 4 | 19 | 13 | ||||
1606 | 1606 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 1010 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16.0 | tree | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975198284551 40.7740343763399) | 19 | 4 | 19 | 13 | |||
1631 | 1631 | -73.98077710643099 | 40.7681635726316 | 1A-AM-1007-02 | 01A | AM | 1007 | 2 | Adult | Gray | White | Gray+White | Above Ground | 11.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.980777106431 40.7681635726316) | 19 | 4 | 19 | 13 | |||||
1640 | 1640 | -73.9622050752008 | 40.7886373772305 | 29D-PM-1010-01 | 29D | PM | 1010 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9622050752008 40.7886373772305) | 19 | 4 | 19 | 13 | |||||
1670 | 1670 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 1019 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9804065254162 40.7681481183296) | 19 | 4 | 19 | 13 | |||||
1684 | 1684 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 1014 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728700359494 40.7659842666881) | 19 | 4 | 19 | 13 | |||||
1723 | 1723 | -73.96924722995651 | 40.7722592187215 | 10H-PM-1007-01 | 10H | PM | 1007 | 1 | Adult | Gray | White | Gray+White | dark gray | Above Ground | 15.0 | in tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9692472299565 40.7722592187215) | 19 | 4 | 19 | 13 | |||
1733 | 1733 | -73.9761632586697 | 40.7741085606149 | 9B-PM-1013-05 | 09B | PM | 1013 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9761632586697 40.7741085606149) | 19 | 4 | 19 | 13 | |||||
1764 | 1764 | -73.9566277721581 | 40.7966674587803 | 39D-PM-1012-04 | 39D | PM | 1012 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 10.0 | on tree trunk (descending from height of ~10 ft) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9566277721581 40.7966674587803) | 19 | 4 | 19 | 13 | ||||
1826 | 1826 | -73.9741944367138 | 40.7769889953596 | 13B-PM-1008-01 | 13B | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on railing | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9741944367138 40.7769889953596) | 19 | 4 | 19 | 13 | ||||
1848 | 1848 | -73.9766693184436 | 40.7708879215854 | 6C-PM-1020-01 | 06C | PM | 1020 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | Across Transverse | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766693184436 40.7708879215854) | 19 | 4 | 19 | 13 | ||||
1865 | 1865 | -73.9734644470766 | 40.7782766486921 | 14A-PM-1014-05 | 14A | PM | 1014 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9734644470766 40.7782766486921) | 19 | 4 | 19 | 13 | |||||
1876 | 1876 | -73.9745141185576 | 40.76914797812071 | 5E-AM-1008-01 | 05E | AM | 1008 | 1 | Adult | Gray | White | Gray+White | Above Ground | 2.0 | on a checker table | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9745141185576 40.7691479781207) | 19 | 4 | 19 | 13 | ||||
1879 | 1879 | -73.96711306801141 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 1007 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
1890 | 1890 | -73.9789952029637 | 40.7697758333099 | 4B-AM-1010-03 | 04B | AM | 1010 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 25.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9789952029637 40.7697758333099) | 19 | 4 | 19 | 13 | |||||
1894 | 1894 | -73.9547031549299 | 40.797886753932204 | 41E-PM-1013-01 | 41E | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9547031549299 40.7978867539322) | 19 | 4 | 19 | 13 | |||||
1914 | 1914 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 1019 | 3 | 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.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
1955 | 1955 | -73.9521950056404 | 40.794937340844996 | 39H-PM-1013-01 | 39H | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | 19 | 4 | 19 | 13 | ||||
1960 | 1960 | -73.9729645190377 | 40.7723310150843 | 9E-AM-1008-02 | 09E | AM | 1008 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729645190377 40.7723310150843) | 19 | 4 | 19 | 13 | |||||
1965 | 1965 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 1018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | cleaning | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712550584322 40.7764273475386) | 19 | 4 | 19 | 13 | ||||
1974 | 1974 | -73.9739249209875 | 40.7768528386853 | 13B-PM-1008-02 | 13B | PM | 1008 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9739249209875 40.7768528386853) | 19 | 4 | 19 | 13 | |||||
1987 | 1987 | -73.9687214684206 | 40.779284172016396 | 17D-AM-1008-07 | 17D | AM | 1008 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687214684206 40.7792841720164) | 19 | 4 | 19 | 13 | |||||
1993 | 1993 | -73.9642717435966 | 40.782087049693 | 22F-AM-1007-05 | 22F | AM | 1007 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9642717435966 40.782087049693) | 19 | 4 | 19 | 13 | ||||
1997 | 1997 | -73.9655233748105 | 40.7792737287734 | 18G-AM-1014-01 | 18G | AM | 1014 | 1 | Juvenile | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | looking | POINT (-73.9655233748105 40.7792737287734) | 19 | 4 | 19 | 13 | ||||
2011 | 2011 | -73.9767016963397 | 40.7674012784541 | 2E-PM-1014-02 | 02E | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767016963397 40.7674012784541) | 19 | 4 | 19 | 13 | |||||
2026 | 2026 | -73.96464954504991 | 40.7791203699027 | 19H-PM-1008-01 | 19H | PM | 1008 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646495450499 40.7791203699027) | 19 | 4 | 19 | 13 | |||||
2064 | 2064 | -73.9646023053207 | 40.7810680044024 | 20F-PM-1007-14 | 20F | PM | 1007 | 14 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9646023053207 40.7810680044024) | 19 | 4 | 19 | 13 | |||||
2093 | 2093 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 1018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9761776424664 40.7695941843825) | 19 | 4 | 19 | 13 | |||||
2109 | 2109 | -73.9667206046912 | 40.777999356509795 | 17G-PM-1017-04 | 17G | PM | 1017 | 4 | 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.9667206046912 40.7779993565098) | 19 | 4 | 19 | 13 | ||||
2156 | 2156 | -73.9558370309765 | 40.7921977208472 | 35G-AM-1007-02 | 35G | AM | 1007 | 2 | Adult | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9558370309765 40.7921977208472) | 19 | 4 | 19 | 13 | |||||
2169 | 2169 | -73.9717201378775 | 40.776120280884 | 13D-PM-1018-02 | 13D | PM | 1018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9717201378775 40.776120280884) | 19 | 4 | 19 | 13 | |||||
2277 | 2277 | -73.95623234556741 | 40.7946180656349 | 37E-AM-1013-02 | 37E | AM | 1013 | 2 | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562323455674 40.7946180656349) | 19 | 4 | 19 | 13 | ||||||
2329 | 2329 | -73.9610388059192 | 40.793952935840004 | 34B-PM-1007-01 | 34B | PM | 1007 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9610388059192 40.79395293584) | 19 | 4 | 19 | 13 | |||||
2340 | 2340 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 1013 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9662310606968 40.7747758221226) | 19 | 4 | 19 | 13 | |||||
2375 | 2375 | -73.9657391918196 | 40.776502470347 | 16H-PM-1014-01 | 16H | PM | 1014 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9657391918196 40.776502470347) | 19 | 4 | 19 | 13 | |||||
2409 | 2409 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 1014 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2428 | 2428 | -73.96882712024009 | 40.7809719445309 | 19C-PM-1018-01 | 19C | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9688271202401 40.7809719445309) | 19 | 4 | 19 | 13 | |||||
2503 | 2503 | -73.9787658435198 | 40.768941976539296 | 3B-PM-1007-07 | 03B | PM | 1007 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | eating loudly <- peanuts w/ shells | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9787658435198 40.7689419765393) | 19 | 4 | 19 | 13 | ||||
2532 | 2532 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | seems to be grinding teeth on a piece of material (sounds from grinding) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9716404781264 40.7753181851766) | 19 | 4 | 19 | 13 | ||||
2534 | 2534 | -73.96854290608391 | 40.7724786961619 | 11H-AM-1010-05 | 11H | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9685429060839 40.7724786961619) | 19 | 4 | 19 | 13 | |||||
2606 | 2606 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 1018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720365327715 40.7762329714016) | 19 | 4 | 19 | 13 | |||||
2725 | 2725 | -73.9586214081667 | 40.7937473968735 | 35D-PM-1013-03 | 35D | PM | 1013 | 3 | Juvenile | Gray | White | Gray+White | No Tail! | Above Ground | 2.0 | bench | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9586214081667 40.7937473968735) | 19 | 4 | 19 | 13 | |||
2781 | 2781 | -73.95082755733499 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
2797 | 2797 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 1019 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | 19 | 4 | 19 | 13 | |||||
2803 | 2803 | -73.96657637976071 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 1013 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9665763797607 40.7761316400012) | 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 )