Data source: NYC Open Data · About: The Squirrel Census
This data as json, CSV (advanced)
Suggested facets: Date, Hectare_Squirrel_Number, Combination_of_Primary_and_Highlight_Color, Color_notes, Location, Above_Ground_Sighter_Measurement, Running, Chasing, Eating, Foraging, Kuks, Quaas, Moans, Tail_flags, Tail_twitches, Approaches, Indifferent, Runs_from, Other_Interactions, Community_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 | |||||
15 | 15 | -73.97673696861709 | 40.7735074437085 | 8B-PM-1012-05 | 08B | PM | 1012 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9767369686171 40.7735074437085) | 19 | 4 | 19 | 13 | |||||
22 | 22 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9618094076328 40.7944097368153) | 19 | 4 | 19 | 13 | |||||
25 | 25 | -73.9655670884957 | 40.7763728890554 | 16H-PM-1014-03 | 16H | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | followed man across bridge | POINT (-73.9655670884957 40.7763728890554) | 19 | 4 | 19 | 13 | ||||
40 | 40 | -73.95667510223359 | 40.799035789744 | 41C-PM-1007-04 | 41C | PM | 1007 | 4 | Adult | Gray | White | Gray+White | Above Ground | 65.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9566751022336 40.799035789744) | 19 | 4 | 19 | 13 | |||||
41 | 41 | -73.9741621946917 | 40.775248147202504 | 11C-PM-1018-01 | 11C | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9741621946917 40.7752481472025) | 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 | |||||
69 | 69 | -73.97797608743551 | 40.769823093658296 | 4C-PM-1010-16 | 04C | PM | 1010 | 16 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9779760874355 40.7698230936583) | 19 | 4 | 19 | 13 | |||||
82 | 82 | -73.9692660977515 | 40.7830532310766 | 21B-PM-1017-01 | 21B | PM | 1017 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | paused to look at me | POINT (-73.9692660977515 40.7830532310766) | 19 | 4 | 19 | 13 | ||||
91 | 91 | -73.95759861613641 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25.0 | Climbing tree | 0 | 0 | 1 | 0 | 0 | climbing (tree) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
116 | 116 | -73.9640989602986 | 40.789929543926505 | 29B-PM-1010-03 | 29B | PM | 1010 | 3 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9640989602986 40.7899295439265) | 19 | 4 | 19 | 13 | |||||
127 | 127 | -73.9798390387307 | 40.7700761090896 | 3A-PM-1017-07 | 03A | PM | 1017 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9798390387307 40.7700761090896) | 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 | |||||
131 | 131 | -73.97149072356758 | 40.774058386152 | 11E-PM-1012-01 | 11E | PM | 1012 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714907235676 40.774058386152) | 19 | 4 | 19 | 13 | |||||
134 | 134 | -73.964593167562 | 40.7780374890066 | 18H-PM-1014-02 | 18H | PM | 1014 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.964593167562 40.7780374890066) | 19 | 4 | 19 | 13 | |||||
149 | 149 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 1012 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564599077179 40.7965185098695) | 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 | |||||
168 | 168 | -73.97346875380642 | 40.769430895922206 | 6F-PM-1008-04 | 06F | PM | 1008 | 4 | Adult | Cinnamon | White | Cinnamon+White | patches of white on haunches | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734687538064 40.7694308959222) | 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 | ||||
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 | |||||
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 | |||||
241 | 241 | -73.9808202088503 | 40.7682921842325 | 1A-PM-1014-02 | 01A | PM | 1014 | 2 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9808202088503 40.7682921842325) | 19 | 4 | 19 | 13 | |||||
242 | 242 | -73.9587179613803 | 40.7992119571657 | 41A-PM-1007-01 | 41A | PM | 1007 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9587179613803 40.7992119571657) | 19 | 4 | 19 | 13 | |||||
256 | 256 | -73.97851333014259 | 40.77182602883379 | 6A-PM-1012-05 | 06A | PM | 1012 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785133301426 40.7718260288338) | 19 | 4 | 19 | 13 | |||||
258 | 258 | -73.9800896621713 | 40.7684379810317 | 2B-PM-1013-03 | 02B | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9800896621713 40.7684379810317) | 19 | 4 | 19 | 13 | |||||
265 | 265 | -73.97041219894871 | 40.7824040236981 | 19A-PM-1013-02 | 19A | PM | 1013 | 2 | Adult | Gray | White | Gray+White | Looks very brown, not like English red squirrels | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9704121989487 40.7824040236981) | 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 | ||||||
279 | 279 | -73.97686527856641 | 40.768483816820705 | 3D-PM-1010-03 | 03D | PM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9768652785664 40.7684838168207) | 19 | 4 | 19 | 13 | |||||
282 | 282 | -73.96511776576759 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 1007 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9651177657676 40.7812408103825) | 19 | 4 | 19 | 13 | ||||
283 | 283 | -73.9631648674122 | 40.7926529617419 | 32A-PM-1013-08 | 32A | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9631648674122 40.7926529617419) | 19 | 4 | 19 | 13 | |||||
284 | 284 | -73.9687933229572 | 40.7788600242549 | 17E-PM-1018-01 | 17E | PM | 1018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9687933229572 40.7788600242549) | 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 | |||||
290 | 290 | -73.9693719015914 | 40.7768710160557 | 14E-PM-1017-02 | 14E | PM | 1017 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | staring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9693719015914 40.7768710160557) | 19 | 4 | 19 | 13 | ||||
293 | 293 | -73.9695468150218 | 40.7821142051746 | 20B-PM-1013-03 | 20B | PM | 1013 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695468150218 40.7821142051746) | 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 | |||||
305 | 305 | -73.9808247660048 | 40.76894088312871 | 2A-PM-1019-01 | 02A | PM | 1019 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | runs from | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9808247660048 40.7689408831287) | 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 | ||||
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 | |||||
345 | 345 | -73.9538377039825 | 40.798060533496106 | 42E-PM-1012-03 | 42E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
347 | 347 | -73.9756557086441 | 40.773296289823996 | 8B-PM-1012-08 | 08B | PM | 1012 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9756557086441 40.773296289824) | 19 | 4 | 19 | 13 | |||||
349 | 349 | -73.95795157569 | 40.7961254697958 | 38C-PM-1014-04 | 38C | PM | 1014 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.95795157569 40.7961254697958) | 19 | 4 | 19 | 13 | |||||
357 | 357 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9790980124501 40.7685934093915) | 19 | 4 | 19 | 13 | |||||
362 | 362 | -73.95890163858891 | 40.7911727679625 | 33E-PM-1012-03 | 33E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9589016385889 40.7911727679625) | 19 | 4 | 19 | 13 | |||||
373 | 373 | -73.9583688637255 | 40.791388958496 | 33E-PM-1012-08 | 33E | PM | 1012 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9583688637255 40.791388958496) | 19 | 4 | 19 | 13 | |||||
378 | 378 | -73.9791085350047 | 40.76770253426329 | 2C-PM-1013-12 | 02C | PM | 1013 | 12 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9791085350047 40.7677025342633) | 19 | 4 | 19 | 13 | |||||
379 | 379 | -73.97509925643621 | 40.7743391883762 | 10B-PM-1014-03 | 10B | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | avoided people | POINT (-73.9750992564362 40.7743391883762) | 19 | 4 | 19 | 13 | ||||
383 | 383 | -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 | |||||
393 | 393 | -73.9589475065438 | 40.7934846881536 | 35D-PM-1013-06 | 35D | PM | 1013 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589475065438 40.7934846881536) | 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 | ||||
417 | 417 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791536183194 40.7672705931866) | 19 | 4 | 19 | 13 | |||||
422 | 422 | -73.9706968708903 | 40.7821499135828 | 19A-PM-1013-06 | 19A | PM | 1013 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706968708903 40.7821499135828) | 19 | 4 | 19 | 13 | |||||
429 | 429 | -73.97864748095141 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 1013 | 4 | Adult | Gray | White | Gray+White | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
432 | 432 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 1013 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9635028497015 40.7928207574906) | 19 | 4 | 19 | 13 | |||||
450 | 450 | -73.954959868822 | 40.7985404965582 | 41D-PM-1014-03 | 41D | PM | 1014 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954959868822 40.7985404965582) | 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 | |||||
478 | 478 | -73.97638947595429 | 40.7705523372364 | 5C-PM-1010-12 | 05C | PM | 1010 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9763894759543 40.7705523372364) | 19 | 4 | 19 | 13 | |||||
522 | 522 | -73.9707542189896 | 40.7717032986885 | 9G-PM-1007-04 | 09G | PM | 1007 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9707542189896 40.7717032986885) | 19 | 4 | 19 | 13 | |||||
527 | 527 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 1013 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | 0 | 0 | 0 | 1 | 1 | watching | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
538 | 538 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 1010 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9776151109912 40.7694681558386) | 19 | 4 | 19 | 13 | |||||
539 | 539 | -73.9557602499712 | 40.7956452424385 | 38E-PM-1014-01 | 38E | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9557602499712 40.7956452424385) | 19 | 4 | 19 | 13 | |||||
599 | 599 | -73.9564724104048 | 40.7936055508162 | 36F-PM-1012-04 | 36F | PM | 1012 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9564724104048 40.7936055508162) | 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 | |||||
605 | 605 | -73.96535757586871 | 40.78053399533721 | 20F-PM-1007-12 | 20F | PM | 1007 | 12 | Adult | Gray | White | Gray+White | Above Ground | 20.0 | in tree | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9653575758687 40.7805339953372) | 19 | 4 | 19 | 13 | ||||
607 | 607 | -73.9569324958684 | 40.7877748374259 | 30I-PM-1006-01 | 30I | PM | 1006 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting there | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9569324958684 40.7877748374259) | 19 | 4 | 19 | 13 | ||||
625 | 625 | -73.9789126088606 | 40.7685079149692 | 2C-PM-1013-08 | 02C | PM | 1013 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9789126088606 40.7685079149692) | 19 | 4 | 19 | 13 | |||||
630 | 630 | -73.9689000978955 | 40.7828364735236 | 20B-PM-1013-10 | 20B | PM | 1013 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | drank from a pond of rain water | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9689000978955 40.7828364735236) | 19 | 4 | 19 | 13 | ||||
634 | 634 | -73.96765297807241 | 40.7823206990549 | 21D-PM-1008-03 | 21D | PM | 1008 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9676529780724 40.7823206990549) | 19 | 4 | 19 | 13 | |||||
663 | 663 | -73.970595381455 | 40.7762912142457 | 13E-PM-1008-05 | 13E | PM | 1008 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.970595381455 40.7762912142457) | 19 | 4 | 19 | 13 | |||||
674 | 674 | -73.9588361742943 | 40.791115225155 | 33E-PM-1012-02 | 33E | PM | 1012 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9588361742943 40.791115225155) | 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 | |||||
689 | 689 | -73.976730206737 | 40.773709213913996 | 8A-PM-1014-01 | 08A | PM | 1014 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 19 | 4 | 19 | 13 | ||||
705 | 705 | -73.9628982772673 | 40.788430480338604 | 28D-PM-1019-01 | 28D | 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.9628982772673 40.7884304803386) | 19 | 4 | 19 | 13 | |||||
713 | 713 | -73.9711617997772 | 40.7761212878075 | 13D-PM-1018-04 | 13D | PM | 1018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711617997772 40.7761212878075) | 19 | 4 | 19 | 13 | ||||
716 | 716 | -73.97772590224409 | 40.76820599079029 | 3D-PM-1010-10 | 03D | PM | 1010 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9777259022441 40.7682059907903) | 19 | 4 | 19 | 13 | |||||
724 | 724 | -73.95498609472341 | 40.79115503283089 | 34H-PM-1006-07 | 34H | PM | 1006 | 7 | Juvenile | Gray | White | Gray+White | white belly | Above Ground | 20.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9549860947234 40.7911550328309) | 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 | |||||
747 | 747 | -73.9720289863666 | 40.7763749561607 | 13C-PM-1019-03 | 13C | PM | 1019 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9720289863666 40.7763749561607) | 19 | 4 | 19 | 13 | |||||
750 | 750 | -73.9713968424625 | 40.774039018852704 | 11E-PM-1012-03 | 11E | PM | 1012 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9713968424625 40.7740390188527) | 19 | 4 | 19 | 13 | |||||
758 | 758 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 1018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9721670042434 40.776085913838) | 19 | 4 | 19 | 13 | |||||
769 | 769 | -73.9767835160078 | 40.767403033048204 | 2E-PM-1014-04 | 02E | PM | 1014 | 4 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 15.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9767835160078 40.7674030330482) | 19 | 4 | 19 | 13 | |||||
780 | 780 | -73.9582850206205 | 40.7978975855555 | 39B-PM-1014-01 | 39B | PM | 1014 | 1 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9582850206205 40.7978975855555) | 19 | 4 | 19 | 13 | ||||
802 | 802 | -73.97514547259979 | 40.770291361572 | 6D-PM-1020-06 | 06D | PM | 1020 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by carousel | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9751454725998 40.770291361572) | 19 | 4 | 19 | 13 | ||||
825 | 825 | -73.956502663005 | 40.788160908881004 | 30I-PM-1006-05 | 30I | PM | 1006 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.956502663005 40.788160908881) | 19 | 4 | 19 | 13 | |||||
832 | 832 | -73.97083010709241 | 40.7820200927465 | 19A-PM-1013-01 | 19A | PM | 1013 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | planting acorns | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9708301070924 40.7820200927465) | 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 | |||||
876 | 876 | -73.9697526733133 | 40.7759529849808 | 13E-PM-1008-09 | 13E | PM | 1008 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9697526733133 40.7759529849808) | 19 | 4 | 19 | 13 | |||||
881 | 881 | -73.9700879096644 | 40.7765899724756 | 14E-PM-1017-05 | 14E | PM | 1017 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9700879096644 40.7765899724756) | 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 | |||||
903 | 903 | -73.9786936992465 | 40.771394367466606 | 5A-PM-1010-02 | 05A | PM | 1010 | 2 | Adult | Gray | White | Gray+White | Above Ground | 50.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9786936992465 40.7713943674666) | 19 | 4 | 19 | 13 | |||||
926 | 926 | -73.9549082481152 | 40.7933537584624 | 36G-PM-1012-01 | 36G | PM | 1012 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | crossing east drive | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9549082481152 40.7933537584624) | 19 | 4 | 19 | 13 | ||||
931 | 931 | -73.9786351029146 | 40.771611416400205 | 6A-PM-1012-06 | 06A | PM | 1012 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9786351029146 40.7716114164002) | 19 | 4 | 19 | 13 | ||||
936 | 936 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 1007 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9793952066038 40.7707837657859) | 19 | 4 | 19 | 13 | ||||
942 | 942 | -73.974515099169 | 40.770065079988605 | 6E-PM-1010-03 | 06E | PM | 1010 | 3 | Adult | Cinnamon | White | Cinnamon+White | white back legs | Ground Plane | FALSE | small open area but w/ 7 large oak trees | 0 | 1 | 0 | 1 | 0 | chasing #4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.974515099169 40.7700650799886) | 19 | 4 | 19 | 13 | ||
950 | 950 | -73.9580111056675 | 40.785433940148295 | 27I-PM-1020-02 | 27I | PM | 1020 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9580111056675 40.7854339401483) | 19 | 4 | 19 | 13 | |||||
960 | 960 | -73.958939037549 | 40.7913193931203 | 33E-PM-1012-04 | 33E | PM | 1012 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.958939037549 40.7913193931203) | 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 | |||||
986 | 986 | -73.96239842629359 | 40.7913900453449 | 31C-PM-1010-03 | 31C | PM | 1010 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9623984262936 40.7913900453449) | 19 | 4 | 19 | 13 | |||||
998 | 998 | -73.9801899519657 | 40.7695777009264 | 3A-PM-1017-02 | 03A | PM | 1017 | 2 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9801899519657 40.7695777009264) | 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 |
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 )