Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare_Squirrel_Number, Primary_Fur_Color, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Climbing, Eating, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015 | 3015 | -73.97469187620759 | 40.765523188367794 | 1G-AM-1006-02 | 01G | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
6038 | 6038 | -73.97469187620759 | 40.765523188367794 | 1G-AM-1006-02 | 01G | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30.0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746918762076 40.7655231883678) | 19 | 4 | 19 | 13 | |||||
1122 | 1122 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 19 | 4 | 19 | 13 | ||||||
4145 | 4145 | -73.9745152462626 | 40.76554155159079 | 1G-AM-1006-04 | 01G | AM | 1006 | 4 | Adult | Gray | White | Gray+White | 0 | 1 | 0 | 0 | 1 | collecting nest material | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745152462626 40.7655415515908) | 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 | ||||
3211 | 3211 | -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 | ||||
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 | |||||
4707 | 4707 | -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 | |||||
296 | 296 | -73.9725174868556 | 40.7664248283566 | 3H-PM-1014-07 | 03H | PM | 1014 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9725174868556 40.7664248283566) | 19 | 4 | 19 | 13 | |||||
3319 | 3319 | -73.9725174868556 | 40.7664248283566 | 3H-PM-1014-07 | 03H | PM | 1014 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9725174868556 40.7664248283566) | 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 | |||||
4345 | 4345 | -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 | |||||
1822 | 1822 | -73.97810334484679 | 40.766672406621296 | 1D-AM-1006-03 | 01D | AM | 1006 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9781033448468 40.7666724066213) | 19 | 4 | 19 | 13 | |||||
4845 | 4845 | -73.97810334484679 | 40.766672406621296 | 1D-AM-1006-03 | 01D | AM | 1006 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9781033448468 40.7666724066213) | 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 | |||||
5432 | 5432 | -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 | |||||
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 | |||||
3035 | 3035 | -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 | |||||
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 | |||||
4134 | 4134 | -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 | |||||
238 | 238 | -73.9751625910271 | 40.7671023412885 | 3F-AM-1006-02 | 03F | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9751625910271 40.7671023412885) | 19 | 4 | 19 | 13 | |||||
3261 | 3261 | -73.9751625910271 | 40.7671023412885 | 3F-AM-1006-02 | 03F | AM | 1006 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9751625910271 40.7671023412885) | 19 | 4 | 19 | 13 | |||||
2710 | 2710 | -73.97866031471492 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 1006 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
5733 | 5733 | -73.97866031471492 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 1006 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
2858 | 2858 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | 19 | 4 | 19 | 13 | |||||
5881 | 5881 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 1007 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9780659679557 40.7672382282781) | 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 | |||||
5034 | 5034 | -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 | |||||
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 | |||||
3224 | 3224 | -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 | |||||
1988 | 1988 | -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 | ||||||
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 | ||||||
2418 | 2418 | -73.9743393747021 | 40.767634679832504 | 3F-AM-1006-12 | 03F | AM | 1006 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9743393747021 40.7676346798325) | 19 | 4 | 19 | 13 | |||||
5441 | 5441 | -73.9743393747021 | 40.767634679832504 | 3F-AM-1006-12 | 03F | AM | 1006 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9743393747021 40.7676346798325) | 19 | 4 | 19 | 13 | |||||
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 | |||||
5820 | 5820 | -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 | |||||
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 | |||||
3860 | 3860 | -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 | |||||
287 | 287 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 1019 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | 19 | 4 | 19 | 13 | |||||
3310 | 3310 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 1019 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | 19 | 4 | 19 | 13 | |||||
1213 | 1213 | -73.97368963630059 | 40.767763086262605 | 4G-AM-1006-01 | 04G | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9736896363006 40.7677630862626) | 19 | 4 | 19 | 13 | |||||
4236 | 4236 | -73.97368963630059 | 40.767763086262605 | 4G-AM-1006-01 | 04G | AM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9736896363006 40.7677630862626) | 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 | |||
3656 | 3656 | -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 | |||
1448 | 1448 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807982742225 40.7678795985389) | 19 | 4 | 19 | 13 | |||||
4471 | 4471 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807982742225 40.7678795985389) | 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 | |||||
3988 | 3988 | -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 | |||||
458 | 458 | -73.9801985977846 | 40.768015951170504 | 1B-AM-1012-11 | 01B | AM | 1012 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | fighting w/ pigeons | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801985977846 40.7680159511705) | 19 | 4 | 19 | 13 | ||||
3481 | 3481 | -73.9801985977846 | 40.768015951170504 | 1B-AM-1012-11 | 01B | AM | 1012 | 11 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | fighting w/ pigeons | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801985977846 40.7680159511705) | 19 | 4 | 19 | 13 | ||||
2614 | 2614 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 1019 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
5637 | 5637 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 1019 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | 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 | ||||
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 | ||||
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 | |||||
4693 | 4693 | -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 | |||||
2884 | 2884 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 1012 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
5907 | 5907 | -73.9806805581636 | 40.7681537966505 | 1B-AM-1012-16 | 01B | AM | 1012 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9806805581636 40.7681537966505) | 19 | 4 | 19 | 13 | |||||
2938 | 2938 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | 19 | 4 | 19 | 13 | |||||
5961 | 5961 | -73.98100322064279 | 40.768162563497896 | 1A-AM-1007-01 | 01A | AM | 1007 | 1 | Adult | Gray | White | Gray+White | Above Ground | 7.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9810032206428 40.7681625634979) | 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 | |||||
4654 | 4654 | -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 | |||||
1811 | 1811 | -73.98078982247259 | 40.768215817511 | 1A-PM-1014-04 | 01A | PM | 1014 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807898224726 40.768215817511) | 19 | 4 | 19 | 13 | |||||
4834 | 4834 | -73.98078982247259 | 40.768215817511 | 1A-PM-1014-04 | 01A | PM | 1014 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807898224726 40.768215817511) | 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 | ||||
4937 | 4937 | -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 | ||||
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 | ||||
4315 | 4315 | -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 | ||||
2924 | 2924 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 1007 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9790214253443 40.7686791169776) | 19 | 4 | 19 | 13 | ||||
5947 | 5947 | -73.9790214253443 | 40.7686791169776 | 3B-PM-1007-10 | 03B | PM | 1007 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | hopping | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9790214253443 40.7686791169776) | 19 | 4 | 19 | 13 | ||||
1611 | 1611 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
4634 | 4634 | -73.9809342290598 | 40.7687265606227 | 2A-AM-1010-05 | 02A | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | base of tree with ~ 30 small birds all eating | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.9809342290598 40.7687265606227) | 19 | 4 | 19 | 13 | ||||
1962 | 1962 | -73.9801562527339 | 40.76872673271129 | 2B-AM-1010-01 | 02B | AM | 1010 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
4985 | 4985 | -73.9801562527339 | 40.76872673271129 | 2B-AM-1010-01 | 02B | AM | 1010 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801562527339 40.7687267327113) | 19 | 4 | 19 | 13 | |||||
2721 | 2721 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 19 | 4 | 19 | 13 | |||||
5744 | 5744 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 1019 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | 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 | ||||
5526 | 5526 | -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 | ||||
170 | 170 | -73.972154069981 | 40.769012800972206 | 6G-AM-1008-03 | 06G | AM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.972154069981 40.7690128009722) | 19 | 4 | 19 | 13 | ||||
3193 | 3193 | -73.972154069981 | 40.769012800972206 | 6G-AM-1008-03 | 06G | AM | 1008 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.972154069981 40.7690128009722) | 19 | 4 | 19 | 13 | ||||
2648 | 2648 | -73.9788436368415 | 40.7691104998969 | 3B-AM-1010-05 | 03B | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9788436368415 40.7691104998969) | 19 | 4 | 19 | 13 | |||||
5671 | 5671 | -73.9788436368415 | 40.7691104998969 | 3B-AM-1010-05 | 03B | AM | 1010 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9788436368415 40.7691104998969) | 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 | ||||
4899 | 4899 | -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 | ||||
2193 | 2193 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775079672882 40.7691500357424) | 19 | 4 | 19 | 13 | |||||
5216 | 5216 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 1010 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775079672882 40.7691500357424) | 19 | 4 | 19 | 13 | |||||
2935 | 2935 | -73.97331176635409 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 1008 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733117663541 40.7694584620114) | 19 | 4 | 19 | 13 | ||||
5958 | 5958 | -73.97331176635409 | 40.7694584620114 | 6F-PM-1008-05 | 06F | PM | 1008 | 5 | Adult | Cinnamon | White | Cinnamon+White | white patch | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733117663541 40.7694584620114) | 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 | |||||
5116 | 5116 | -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 | |||||
1263 | 1263 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | 19 | 4 | 19 | 13 | |||||
4286 | 4286 | -73.9771847728747 | 40.769597116498105 | 4C-AM-1006-01 | 04C | AM | 1006 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771847728747 40.7695971164981) | 19 | 4 | 19 | 13 | |||||
441 | 441 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
3464 | 3464 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 1006 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
2257 | 2257 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
5280 | 5280 | -73.9771696835698 | 40.76970111004871 | 4C-AM-1006-04 | 04C | AM | 1006 | 4 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9771696835698 40.7697011100487) | 19 | 4 | 19 | 13 | |||||
578 | 578 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 1006 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | 19 | 4 | 19 | 13 | |||||
3601 | 3601 | -73.9772908667333 | 40.7697207404744 | 4C-AM-1006-05 | 04C | AM | 1006 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 20.0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9772908667333 40.7697207404744) | 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 | |||||
4913 | 4913 | -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 |
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 )