This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, 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 | Lat/Long | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158 | 158 | -73.9710991123992 | 40.7723889726647 | 9F-PM-1014-02 | 09F | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9710991123992 40.7723889726647) | 19 | 4 | 19 | 13 | |||||
330 | 330 | -73.9708969246276 | 40.7767695507462 | 14D-AM-1014-03 | 14D | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9708969246276 40.7767695507462) | 19 | 4 | 19 | 13 | |||||
393 | 393 | -73.9577212629651 | 40.7965525296722 | 38C-PM-1014-06 | 38C | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9577212629651 40.7965525296722) | 19 | 4 | 19 | 13 | |||||
498 | 498 | -73.9669432929573 | 40.779136518298 | 18F-AM-1014-01 | 18F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | Low tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9669432929573 40.779136518298) | 19 | 4 | 19 | 13 | |||||
548 | 548 | -73.9584696083284 | 40.7980121226635 | 39B-PM-1014-03 | 39B | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584696083284 40.7980121226635) | 19 | 4 | 19 | 13 | ||||||
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
719 | 719 | -73.9626881234742 | 40.7905208345549 | 30C-AM-1014-01 | 30C | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9626881234742 40.7905208345549) | 19 | 4 | 19 | 13 | |||||
736 | 736 | -73.9660110060416 | 40.7809990098597 | 20F-AM-1014-01 | 20F | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9660110060416 40.7809990098597) | 19 | 4 | 19 | 13 | |||||
818 | 818 | -73.9608757424052 | 40.7906686504657 | 31D-AM-1014-06 | 31D | AM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9608757424052 40.7906686504657) | 19 | 4 | 19 | 13 | |||||
826 | 826 | -73.9557263533489 | 40.7939505791448 | 37F-PM-1014-02 | 37F | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | LAWN | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.95572635334891 40.7939505791448) | 19 | 4 | 19 | 13 | ||||
842 | 842 | -73.9645147011741 | 40.7772566833799 | 17I-AM-1014-04 | 17I | AM | 10142018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | true | true | false | POINT (-73.9645147011741 40.7772566833799) | 19 | 4 | 19 | 13 | |||||
845 | 845 | -73.9582850206205 | 40.7978975855555 | 39B-PM-1014-01 | 39B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | White belly | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9582850206205 40.7978975855555) | 19 | 4 | 19 | 13 | ||||
878 | 878 | -73.9757215415855 | 40.7668205976986 | 2F-PM-1014-03 | 02F | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757215415855 40.7668205976986) | 19 | 4 | 19 | 13 | |||||
1021 | 1021 | -73.97186968288 | 40.778926988884 | 15B-AM-1014-03 | 15B | AM | 10142018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | true | running (from a dog) | false | false | false | false | false | false | true | false | POINT (-73.97186968288 40.778926988884) | 19 | 4 | 19 | 13 | ||||
1097 | 1097 | -73.9761579527932 | 40.7755877312075 | 10A-PM-1014-02 | 10A | PM | 10142018 | 2 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | in the bushes beneath a tree | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9761579527932 40.7755877312075) | 19 | 4 | 19 | 13 | ||||
1122 | 1122 | -73.9728700359494 | 40.7659842666881 | 3H-PM-1014-05 | 03H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728700359494 40.7659842666881) | 19 | 4 | 19 | 13 | |||||
1223 | 1223 | -73.9591298551111 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9591298551111 40.7919612446005) | 19 | 4 | 19 | 13 | |||||
1255 | 1255 | -73.9717469822209 | 40.7753731930704 | 12D-PM-1014-03 | 12D | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9717469822209 40.7753731930704) | 19 | 4 | 19 | 13 | ||||||
1382 | 1382 | -73.9611274898661 | 40.7915250069086 | 32C-AM-1014-05 | 32C | AM | 10142018 | 5 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9611274898661 40.7915250069086) | 19 | 4 | 19 | 13 | ||||||
1482 | 1482 | -73.9588610195699 | 40.7945269936639 | 36C-AM-1014-02 | 36C | AM | 10142018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | Crossing path | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9588610195699 40.7945269936639) | 19 | 4 | 19 | 13 | ||||
1537 | 1537 | -73.9767220179725 | 40.7753262103123 | 10A-PM-1014-03 | 10A | PM | 10142018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | above my head in tree | false | false | false | true | false | eating (in a tree) | false | false | false | false | false | false | true | false | indifferent (lots of people taking its picture,didn't bother it) | POINT (-73.9767220179725 40.7753262103123) | 12420 | 20 | 4 | 19 | 12 | ||
1603 | 1603 | -73.9545929242174 | 40.7986940168685 | 42D-AM-1014-02 | 42D | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9545929242174 40.7986940168685) | 19 | 4 | 19 | 13 | ||||
1667 | 1667 | -73.9645989003589 | 40.7782157459155 | 18H-PM-1014-01 | 18H | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9645989003589 40.7782157459155) | 19 | 4 | 19 | 13 | |||||
1708 | 1708 | -73.9618486459307 | 40.7946365810826 | 35A-AM-1014-02 | 35A | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9618486459307 40.7946365810826) | 19 | 4 | 19 | 13 | |||||
1739 | 1739 | -73.9639700434449 | 40.7775003050028 | 17I-AM-1014-01 | 17I | AM | 10142018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | Running across fence between statue & swings | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639700434449 40.7775003050028) | 19 | 4 | 19 | 13 | ||||
1771 | 1771 | -73.9750688083336 | 40.7665584681025 | 2F-PM-1014-07 | 02F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9750688083336 40.7665584681025) | 19 | 4 | 19 | 13 | ||||||
1775 | 1775 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 10142018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | true | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
1936 | 1936 | -73.9667911565238 | 40.779321901098 | 18F-AM-1014-02 | 18F | AM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | In small tree by water | false | false | false | true | true | false | true | false | false | false | false | true | false | POINT (-73.9667911565238 40.77932190109801) | 19 | 4 | 19 | 13 | |||||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757673193743 40.766961432261304) | 19 | 4 | 19 | 13 | ||||||
2174 | 2174 | -73.9684092812839 | 40.7711445841928 | 9I-AM-1014-07 | 09I | AM | 10142018 | 7 | Adult | Cinnamon | Cinnamon+ | No real highlight, White tail? | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9684092812839 40.7711445841928) | 19 | 4 | 19 | 13 | |||||
2195 | 2195 | -73.955352152771 | 40.7988549523022 | 42D-AM-1014-01 | 42D | AM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | true | false | true | false | false | false | false | false | true | false | POINT (-73.955352152771 40.7988549523022) | 19 | 4 | 19 | 13 | |||||
2270 | 2270 | -73.9703732649257 | 40.7701979377103 | 8H-PM-1014-04 | 08H | PM | 10142018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97037326492571 40.7701979377103) | 19 | 4 | 19 | 13 | ||||||
2325 | 2325 | -73.9728360875598 | 40.7660637295671 | 3H-PM-1014-04 | 03H | PM | 10142018 | 4 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9728360875598 40.7660637295671) | 19 | 4 | 19 | 13 | |||||
2507 | 2507 | -73.964868521585 | 40.7821064183815 | 22F-PM-1014-01 | 22F | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.964868521585 40.7821064183815) | 19 | 4 | 19 | 13 | |||||
2545 | 2545 | -73.9617594316752 | 40.7946803725236 | 35A-AM-1014-01 | 35A | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9617594316752 40.7946803725236) | 19 | 4 | 19 | 13 | |||||
2580 | 2580 | -73.970795746101 | 40.7704727212299 | 8H-PM-1014-01 | 08H | PM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.970795746101 40.7704727212299) | 19 | 4 | 19 | 13 | |||||
2613 | 2613 | -73.96393252683 | 40.7808289765857 | 21G-AM-1014-04 | 21G | AM | 10142018 | 4 | Adult | Gray | White | Gray+White | Above Ground | 6 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.96393252683 40.7808289765857) | 19 | 4 | 19 | 13 | |||||
2641 | 2641 | -73.9615516703494 | 40.7905219388359 | 31D-AM-1014-04 | 31D | AM | 10142018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | Open ground | true | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9615516703494 40.7905219388359) | 19 | 4 | 19 | 13 | |||||
2645 | 2645 | -73.9584967368893 | 40.7977320341094 | 39B-PM-1014-05 | 39B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. | false | false | false | false | false | false | true | false | POINT (-73.9584967368893 40.7977320341094) | 19 | 4 | 19 | 13 | ||||
2804 | 2804 | -73.9576094432477 | 40.7965342664074 | 38C-PM-1014-07 | 38C | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9576094432477 40.7965342664074) | 19 | 4 | 19 | 13 | |||||
2805 | 2805 | -73.9711634340673 | 40.7760553338671 | 13D-AM-1014-05 | 13D | AM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9711634340673 40.7760553338671) | 19 | 4 | 19 | 13 | |||||
2846 | 2846 | -73.9661570478029 | 40.7807271518813 | 20E-AM-1014-02 | 20E | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9661570478029 40.7807271518813) | 19 | 4 | 19 | 13 | |||||
2916 | 2916 | -73.9517525111679 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
2953 | 2953 | -73.9585862117341 | 40.7986549251083 | 40A-PM-1014-05 | 40A | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | eating (in a tree cage thing) | false | false | false | false | false | false | true | false | POINT (-73.9585862117341 40.7986549251083) | 19 | 4 | 19 | 13 | ||||
2967 | 2967 | -73.9713257586372 | 40.7762719619467 | 13D-AM-1014-09 | 13D | AM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9713257586372 40.7762719619467) | 19 | 4 | 19 | 13 | |||||
2980 | 2980 | -73.9716414586381 | 40.771760114722 | 9F-PM-1014-06 | 09F | PM | 10142018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | running (from birds) | false | false | false | true | false | false | true | false | POINT (-73.9716414586381 40.771760114722) | 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 );