This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Chasing, Climbing, Foraging, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Zip Codes, 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 | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.980919134781 40.7683772453336) | 19 | 4 | 19 | 13 | ||||||
392 | 392 | -73.9802376131034 | 40.7680707516627 | 1B-AM-1012-12 | 01B | AM | 10122018 | 12 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9802376131034 40.7680707516627) | 19 | 4 | 19 | 13 | |||||
1565 | 1565 | -73.9803895322385 | 40.7680730789944 | 1B-AM-1012-13 | 01B | AM | 10122018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9803895322385 40.7680730789944) | 19 | 4 | 19 | 13 | |||||
1716 | 1716 | -73.9797425262459 | 40.7679120246352 | 1B-AM-1012-02 | 01B | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9797425262459 40.7679120246352) | 19 | 4 | 19 | 13 | |||||
2688 | 2688 | -73.9799302952205 | 40.7677207209798 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9799302952205 40.7677207209798) | 19 | 4 | 19 | 13 | |||||
2981 | 2981 | -73.9800094828465 | 40.7677782585639 | 1B-AM-1012-04 | 01B | AM | 10122018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9800094828465 40.7677782585639) | 19 | 4 | 19 | 13 | ||||||
568 | 568 | -73.9799441493404 | 40.7671499997527 | 1C-AM-1012-01 | 01C | AM | 10122018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9799441493404 40.7671499997527) | 12081 | 11 | 4 | 51 | 10 | |||
405 | 405 | -73.9786603147149 | 40.7671937837017 | 1D-AM-1006-09 | 01D | AM | 10062018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9786603147149 40.7671937837017) | 19 | 4 | 19 | 13 | |||||
419 | 419 | -73.9777328709928 | 40.7669087724668 | 1D-AM-1006-02 | 01D | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9777328709928 40.7669087724668) | 19 | 4 | 19 | 13 | |||||
1549 | 1549 | -73.9777978497894 | 40.7668620784309 | 1D-AM-1006-01 | 01D | AM | 10062018 | 1 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | false | POINT (-73.9777978497894 40.7668620784309) | 19 | 4 | 19 | 13 | |||||
1555 | 1555 | -73.9784942525972 | 40.7672600003683 | 1D-AM-1006-06 | 01D | AM | 10062018 | 6 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | tumbling | false | false | false | false | false | false | false | false | POINT (-73.9784942525972 40.7672600003683) | 19 | 4 | 19 | 13 | |||
947 | 947 | -73.9736543790582 | 40.7651444188432 | 1H-AM-1012-02 | 01H | AM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9736543790582 40.7651444188432) | 19 | 4 | 19 | 13 | |||||
1840 | 1840 | -73.9733222531339 | 40.7649975371546 | 1I-PM-1012-01 | 01I | PM | 10122018 | 1 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9733222531339 40.7649975371546) | 19 | 4 | 19 | 13 | ||||
999 | 999 | -73.980948293606 | 40.7685688850628 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.980948293606 40.7685688850628) | 19 | 4 | 19 | 13 | ||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
1260 | 1260 | -73.9811585807616 | 40.768706748732 | 2A-AM-1010-06 | 02A | AM | 10102018 | 6 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | true | false | false | false | chasing #5 | false | false | false | false | false | false | false | false | POINT (-73.9811585807616 40.768706748732) | 19 | 4 | 19 | 13 | |||||
1956 | 1956 | -73.980897497712 | 40.7690578709841 | 2A-PM-1019-02 | 02A | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.980897497712 40.7690578709841) | 19 | 4 | 19 | 13 | |||||
2412 | 2412 | -73.9809446489564 | 40.7685032165879 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9809446489564 40.7685032165879) | 19 | 4 | 19 | 13 | ||||
2777 | 2777 | -73.9810843611086 | 40.7687905493699 | 2A-PM-1019-05 | 02A | PM | 10192018 | 5 | ? | Gray | Gray+ | Above Ground | 50 | in tall planetree | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9810843611086 40.7687905493699) | 19 | 4 | 19 | 13 | |||||
51 | 51 | -73.9801666435401 | 40.7686905339212 | 2B-PM-1013-01 | 02B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | running (with nut) | false | false | false | false | false | false | false | false | POINT (-73.9801666435401 40.7686905339212) | 19 | 4 | 19 | 13 | ||||
1587 | 1587 | -73.9805517765469 | 40.7683044693163 | 2B-PM-1013-05 | 02B | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | climbing fence! | false | false | false | false | false | false | false | false | snuck into bike cart! | POINT (-73.9805517765469 40.7683044693163) | 19 | 4 | 19 | 13 | |||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
2038 | 2038 | -73.9803562137049 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9803562137049 40.7685780990634) | 19 | 4 | 19 | 13 | ||||||
1236 | 1236 | -73.9792039071114 | 40.7678749471267 | 2C-AM-1010-07 | 02C | AM | 10102018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | false | #7 & #8 chased each other up diff tree | false | false | false | false | false | false | false | true | POINT (-73.9792039071114 40.76787494712671) | 19 | 4 | 19 | 13 | ||||
1264 | 1264 | -73.9785353775382 | 40.7674923683184 | 2C-PM-1013-01 | 02C | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785353775382 40.7674923683184) | 19 | 4 | 19 | 13 | |||||
1648 | 1648 | -73.9790263372004 | 40.7683513714892 | 2C-PM-1013-07 | 02C | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9790263372004 40.7683513714892) | 19 | 4 | 19 | 13 | |||||||
674 | 674 | -73.9779811967788 | 40.7675178797546 | 2D-AM-1007-01 | 02D | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9779811967788 40.7675178797546) | 19 | 4 | 19 | 13 | |||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 19 | 4 | 19 | 13 | ||||||
535 | 535 | -73.9772396728545 | 40.7668696411765 | 2E-AM-1010-02 | 02E | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | totally indifferent | POINT (-73.9772396728545 40.7668696411765) | 19 | 4 | 19 | 13 | |||||
885 | 885 | -73.9750463844984 | 40.7666871742836 | 2F-PM-1014-08 | 02F | PM | 10142018 | 8 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9750463844984 40.7666871742836) | 19 | 4 | 19 | 13 | |||||
974 | 974 | -73.9753744539307 | 40.7671162211032 | 2F-PM-1014-12 | 02F | PM | 10142018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97537445393071 40.7671162211032) | 19 | 4 | 19 | 13 | ||||||
1427 | 1427 | -73.9755321998542 | 40.7668311576007 | 2F-PM-1014-01 | 02F | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.97553219985421 40.7668311576007) | 19 | 4 | 19 | 13 | ||||||
1600 | 1600 | -73.9753093777 | 40.7666673897583 | 2F-AM-1006-04 | 02F | AM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Beautiful white puff at the end of its tail | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.97530937770001 40.7666673897583) | 19 | 4 | 19 | 13 | ||||
1682 | 1682 | -73.9759258407288 | 40.7667622711142 | 2F-PM-1014-05 | 02F | PM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9759258407288 40.7667622711142) | 19 | 4 | 19 | 13 | ||||||
2160 | 2160 | -73.975028559002 | 40.7667307335544 | 2F-PM-1014-09 | 02F | PM | 10142018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.975028559002 40.7667307335544) | 19 | 4 | 19 | 13 | |||||
2410 | 2410 | -73.9755192076934 | 40.7664413570796 | 2F-PM-1014-06 | 02F | PM | 10142018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9755192076934 40.7664413570796) | 19 | 4 | 19 | 13 | |||||
2558 | 2558 | -73.9749469566854 | 40.7667805367199 | 2F-PM-1014-10 | 02F | PM | 10142018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9749469566854 40.7667805367199) | 19 | 4 | 19 | 13 | |||||
961 | 961 | -73.9731457102903 | 40.7660255393205 | 2H-AM-1006-03 | 02H | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731457102903 40.7660255393205) | 19 | 4 | 19 | 13 | |||||
1193 | 1193 | -73.9731880656287 | 40.7660026186155 | 2H-AM-1006-01 | 02H | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731880656287 40.7660026186155) | 19 | 4 | 19 | 13 | ||||||
787 | 787 | -73.9725157534356 | 40.7658376729234 | 2I-PM-1006-02 | 02I | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9725157534356 40.7658376729234) | 19 | 4 | 19 | 13 | |||||
1766 | 1766 | -73.972757765574 | 40.7654285510067 | 2I-AM-1006-01 | 02I | AM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.972757765574 40.7654285510067) | 19 | 4 | 19 | 13 | ||||||
1297 | 1297 | -73.9802831706033 | 40.7692763295564 | 3A-AM-1012-02 | 03A | AM | 10122018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Gray & Cinnamon selected as Primary. Black & Cinnamon selected as Highlights. Made executive adjustments. | Above Ground | 1 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9802831706033 40.7692763295564) | 19 | 4 | 19 | 13 | ||||
2385 | 2385 | -73.9787552947847 | 40.7690779628762 | 3B-AM-1010-06 | 03B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9787552947847 40.7690779628762) | 19 | 4 | 19 | 13 | ||||||
2426 | 2426 | -73.9790203973636 | 40.7688837114832 | 3B-AM-1010-02 | 03B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | together w/ #3 | false | false | false | false | false | false | false | true | POINT (-73.9790203973636 40.7688837114832) | 19 | 4 | 19 | 13 | ||||
2776 | 2776 | -73.9789687905912 | 40.7692693139328 | 3B-PM-1007-04 | 03B | PM | 10072018 | 4 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | At fence | true | false | true | true | false | false | false | false | false | true | false | true | true | POINT (-73.9789687905912 40.7692693139328) | 19 | 4 | 19 | 13 | ||||
1325 | 1325 | -73.9775278847897 | 40.7687881061059 | 3C-AM-1007-02 | 03C | AM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9775278847897 40.7687881061059) | 19 | 4 | 19 | 13 | |||||
2905 | 2905 | -73.9784872728213 | 40.7688122603932 | 3C-AM-1007-01 | 03C | AM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9784872728213 40.7688122603932) | 19 | 4 | 19 | 13 | |||||
257 | 257 | -73.9773317054464 | 40.7684035996758 | 3D-AM-1006-03 | 03D | AM | 10062018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | on top [of] a big rock/boulder in the area | true | false | true | false | false | climbing (rock) | false | false | false | false | false | true | false | false | approaches (slightly),wary of humans | POINT (-73.9773317054464 40.76840359967581) | 19 | 4 | 19 | 13 | ||
493 | 493 | -73.9776854797916 | 40.7683102295663 | 3D-AM-1006-04 | 03D | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (boy on bike) | POINT (-73.9776854797916 40.7683102295663) | 19 | 4 | 19 | 13 | ||||
514 | 514 | -73.9768357173861 | 40.7683813358343 | 3D-PM-1010-12 | 03D | PM | 10102018 | 12 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | true | false | false | true | false | true | false | false | false | false | false | false | POINT (-73.9768357173861 40.7683813358343) | 19 | 4 | 19 | 13 | |||||
1293 | 1293 | -73.9775465365348 | 40.7681943707876 | 3D-PM-1010-09 | 03D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9775465365348 40.7681943707876) | 19 | 4 | 19 | 13 | ||||||
1329 | 1329 | -73.9772164524209 | 40.7688399538756 | 3D-AM-1006-06 | 03D | AM | 10062018 | 6 | Gray | Gray+ | Above Ground | 10 | tree | true | false | true | false | false | false | false | false | false | false | false | false | false | did not run from humans,but ran straight to tree & climbed up | POINT (-73.9772164524209 40.7688399538756) | 19 | 4 | 19 | 13 | |||||
1532 | 1532 | -73.9779263114572 | 40.7682681855369 | 3D-PM-1010-08 | 03D | PM | 10102018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9779263114572 40.7682681855369) | 19 | 4 | 19 | 13 | |||||
1763 | 1763 | -73.9768286349595 | 40.7687012827059 | 3D-PM-1010-05 | 03D | PM | 10102018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9768286349595 40.7687012827059) | 19 | 4 | 19 | 13 | ||||||
1913 | 1913 | -73.9774630821854 | 40.7680626674086 | 3D-PM-1010-11 | 03D | PM | 10102018 | 11 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774630821854 40.76806266740861) | 19 | 4 | 19 | 13 | |||||
2245 | 2245 | -73.9774228454023 | 40.7686399839016 | 3D-AM-1006-05 | 03D | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (chased by boy),wary of humans in playground | POINT (-73.9774228454023 40.7686399839016) | 19 | 4 | 19 | 13 | ||||
2280 | 2280 | -73.9767143644151 | 40.7684756941321 | 3D-AM-1006-02 | 03D | AM | 10062018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 25 | tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9767143644151 40.7684756941321) | 19 | 4 | 19 | 13 | ||||
2462 | 2462 | -73.9768544488742 | 40.7680069500977 | 3D-AM-1006-07 | 03D | AM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | false | running (with food in mouth) | false | false | false | false | false | false | true | false | POINT (-73.9768544488742 40.7680069500977) | 19 | 4 | 19 | 13 | ||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 19 | 4 | 19 | 13 | ||
2628 | 2628 | -73.9770439076963 | 40.7685720141731 | 3D-PM-1010-13 | 03D | PM | 10102018 | 13 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9770439076963 40.7685720141731) | 19 | 4 | 19 | 13 | |||||
1199 | 1199 | -73.9756993198381 | 40.7681956641913 | 3E-PM-1008-08 | 03E | PM | 10082018 | 8 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9756993198381 40.7681956641913) | 19 | 4 | 19 | 13 | ||||||
1733 | 1733 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
1059 | 1059 | -73.9749457516921 | 40.7676712372245 | 3F-PM-1013-07 | 03F | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9749457516921 40.7676712372245) | 19 | 4 | 19 | 13 | |||||
1756 | 1756 | -73.9755041276839 | 40.7678213857557 | 3F-AM-1006-13 | 03F | AM | 10062018 | 13 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9755041276839 40.7678213857557) | 19 | 4 | 19 | 13 | |||||
2289 | 2289 | -73.9745800592393 | 40.767356541975 | 3F-AM-1006-08 | 03F | AM | 10062018 | 8 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | close to tall tree & light post | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9745800592393 40.767356541975) | 19 | 4 | 19 | 13 | ||||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97518067271972 40.7671940332258) | 19 | 4 | 19 | 13 | |||||
2811 | 2811 | -73.9756889766089 | 40.7676078308589 | 3F-AM-1006-14 | 03F | AM | 10062018 | 14 | Adult | Gray | White | Gray+White | Above Ground | 12 | true | false | true | false | false | running from dog | false | false | false | false | false | false | false | true | POINT (-73.9756889766089 40.7676078308589) | 19 | 4 | 19 | 13 | ||||
1715 | 1715 | -73.9745709109056 | 40.7672225695415 | 3G-AM-1008-03 | 03G | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | true | false | false | in tree | false | false | false | false | false | false | true | false | POINT (-73.9745709109056 40.7672225695415) | 19 | 4 | 19 | 13 | |||||
1884 | 1884 | -73.9733898487296 | 40.7666975131518 | 3H-PM-1014-02 | 03H | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9733898487296 40.7666975131518) | 19 | 4 | 19 | 13 | |||||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9725700261894 40.7668793330427) | 19 | 4 | 19 | 13 | |||||
562 | 562 | -73.972467515471 | 40.7659131865172 | 3I-PM-1013-05 | 03I | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.972467515471 40.7659131865172) | 19 | 4 | 19 | 13 | |||||
1074 | 1074 | -73.9724657562746 | 40.7658015504376 | 3I-PM-1013-06 | 03I | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9724657562746 40.7658015504376) | 19 | 4 | 19 | 13 | |||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2570 | 2570 | -73.9721064150173 | 40.7667053821991 | 3I-AM-1010-01 | 03I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721064150173 40.7667053821991) | 19 | 4 | 19 | 13 | ||||||
2914 | 2914 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9722053355548 40.7662094993614) | 19 | 4 | 19 | 13 | ||||||
2985 | 2985 | -73.9721159387757 | 40.7660503188637 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9721159387757 40.7660503188637) | 19 | 4 | 19 | 13 | |||||
1954 | 1954 | -73.9794840520702 | 40.7709595369804 | 4A-PM-1007-02 | 04A | PM | 10072018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9794840520702 40.770959536980406) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 19 | 4 | 19 | 13 | |||||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | true | false | false | false | false | running from squirrel #5 | false | false | false | false | false | false | false | false | POINT (-73.9788304714091 40.7696373635315) | 19 | 4 | 19 | 13 | |||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 19 | 4 | 19 | 13 | |||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9773079154219 40.7696506688861) | 19 | 4 | 19 | 13 | |||||
1125 | 1125 | -73.9775735077285 | 40.7692872082165 | 4C-PM-1010-08 | 04C | PM | 10102018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | on stone arch | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9775735077285 40.7692872082165) | 19 | 4 | 19 | 13 | ||||
1567 | 1567 | -73.9774407362587 | 40.7698056129554 | 4C-PM-1010-12 | 04C | PM | 10102018 | 12 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9774407362587 40.7698056129554) | 19 | 4 | 19 | 13 | |||||
1822 | 1822 | -73.9775099290913 | 40.7697609063137 | 4C-PM-1010-14 | 04C | PM | 10102018 | 14 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | true | false | false | false | chasing #15 | false | false | false | false | false | false | false | false | POINT (-73.9775099290913 40.7697609063137) | 19 | 4 | 19 | 13 | ||||
1909 | 1909 | -73.9772070122251 | 40.7694343352509 | 4C-PM-1010-02 | 04C | PM | 10102018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.97720701222511 40.7694343352509) | 19 | 4 | 19 | 13 | |||||
1996 | 1996 | -73.977641787698 | 40.7695830265784 | 4C-PM-1010-10 | 04C | PM | 10102018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.977641787698 40.7695830265784) | 19 | 4 | 19 | 13 | |||||
2107 | 2107 | -73.9772624834791 | 40.7692821918543 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772624834791 40.7692821918543) | 19 | 4 | 19 | 13 | |||||
2574 | 2574 | -73.978199543688 | 40.7695660563362 | 4C-PM-1010-17 | 04C | PM | 10102018 | 17 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | climbed up tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.978199543688 40.7695660563362) | 19 | 4 | 19 | 13 | ||||
2644 | 2644 | -73.9775445441194 | 40.7697096533728 | 4C-PM-1010-13 | 04C | PM | 10102018 | 13 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9775445441194 40.7697096533728) | 19 | 4 | 19 | 13 | |||||
2889 | 2889 | -73.9771646835311 | 40.7693049165084 | 4C-PM-1010-05 | 04C | PM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9771646835311 40.7693049165084) | 19 | 4 | 19 | 13 | |||||
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9765805609072 40.7692807820935) | 19 | 4 | 19 | 13 | ||||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 19 | 4 | 19 | 13 | ||||
1299 | 1299 | -73.9766653663947 | 40.7688767713012 | 4D-AM-1012-01 | 04D | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9766653663947 40.7688767713012) | 19 | 4 | 19 | 13 | |||||
336 | 336 | -73.9757413215621 | 40.7692582758978 | 4E-PM-1008-04 | 04E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | true | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9757413215621 40.7692582758978) | 19 | 4 | 19 | 13 | ||||||
1975 | 1975 | -73.9753291616796 | 40.7687376032936 | 4E-PM-1008-01 | 04E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9753291616796 40.7687376032936) | 19 | 4 | 19 | 13 | |||||
2705 | 2705 | -73.9748962681637 | 40.76787782717 | 4F-PM-1013-02 | 04F | PM | 10132018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9748962681637 40.76787782717) | 19 | 4 | 19 | 13 | |||||
2785 | 2785 | -73.9729105002306 | 40.7672758037086 | 4H-PM-1006-02 | 04H | PM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9729105002306 40.7672758037086) | 19 | 4 | 19 | 13 | |||||
2166 | 2166 | -73.9711178122133 | 40.7672642958437 | 4I-PM-1007-01 | 04I | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9711178122133 40.76726429584371) | 19 | 4 | 19 | 13 | ||||||
2755 | 2755 | -73.9712022111028 | 40.7672504368263 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9712022111028 40.7672504368263) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "Age" TEXT, "Primary Fur Color" TEXT, "Highlight Fur Color" TEXT, "Combination of Primary and Highlight Color" TEXT, "Color notes" TEXT, "Location" TEXT, "Above Ground Sighter Measurement" TEXT, "Specific Location" TEXT, "Running" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );