This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | -73.958736593111 | 40.7908524370626 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.958736593111 40.7908524370626) | 19 | 4 | 19 | 13 | ||||||
108 | 108 | -73.9574809028248 | 40.7950013620207 | 37D-PM-1014-04 | 37D | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing (a chipmunk) | false | false | false | false | false | false | false | true | POINT (-73.9574809028248 40.7950013620207) | 19 | 4 | 19 | 13 | |||||
240 | 240 | -73.9767080512177 | 40.7717708794221 | 6B-PM-1017-04 | 06B | PM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767080512177 40.7717708794221) | 19 | 4 | 19 | 13 | |||||
474 | 474 | -73.9540652304705 | 40.7955226178199 | 39G-PM-1013-05 | 39G | PM | 10132018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9540652304705 40.7955226178199) | 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 | |||||
589 | 589 | -73.97826438139 | 40.7717086090782 | 6A-AM-1006-04 | 06A | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | true | false | false | false | curious | POINT (-73.97826438139 40.7717086090782) | 19 | 4 | 19 | 13 | ||||
640 | 640 | -73.9785536529136 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 10122018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9785536529136 40.771618450500206) | 19 | 4 | 19 | 13 | ||||
684 | 684 | -73.9691057326088 | 40.7765973509721 | 14F-PM-1012-07 | 14F | PM | 10122018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9691057326088 40.7765973509721) | 19 | 4 | 19 | 13 | |||||
740 | 740 | -73.9583477850634 | 40.7914073632782 | 33F-PM-1012-06 | 33F | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | true | false | true | true | true | false | false | false | true | false | false | false | POINT (-73.9583477850634 40.7914073632782) | 19 | 4 | 19 | 13 | |||||
750 | 750 | -73.9699672074164 | 40.7774389345748 | 15D-AM-1007-07 | 15D | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | chasing #8 | false | false | false | false | false | false | true | false | POINT (-73.9699672074164 40.7774389345748) | 19 | 4 | 19 | 13 | ||||
762 | 762 | -73.9679291347956 | 40.7846973096665 | 23B-PM-1012-02 | 23B | PM | 10122018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | 2/3 were chasing each other | false | false | false | false | true | false | false | true | POINT (-73.9679291347956 40.7846973096665) | 19 | 4 | 19 | 13 | ||||
763 | 763 | -73.9767455430709 | 40.7717866237826 | 6B-PM-1017-06 | 06B | PM | 10172018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767455430709 40.7717866237826) | 19 | 4 | 19 | 13 | |||||
853 | 853 | -73.9534509627885 | 40.7921084224711 | 36I-AM-1017-07 | 36I | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | chasing (#8),scratching | true | false | false | false | true | false | true | false | POINT (-73.9534509627885 40.7921084224711) | 19 | 4 | 19 | 13 | ||||
874 | 874 | -73.9591957793992 | 40.7949568873453 | 36C-PM-1013-01 | 36C | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9591957793992 40.7949568873453) | 19 | 4 | 19 | 13 | |||||
904 | 904 | -73.9531013359625 | 40.7921223556535 | 36I-PM-1007-04 | 36I | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9531013359625 40.7921223556535) | 19 | 4 | 19 | 13 | ||||||
911 | 911 | -73.9697277998257 | 40.7705198722028 | 8H-AM-1017-01 | 08H | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697277998257 40.7705198722028) | 19 | 4 | 19 | 13 | |||||
957 | 957 | -73.9586527721822 | 40.7908831110561 | 32F-PM-1008-08 | 32F | PM | 10082018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586527721822 40.7908831110561) | 19 | 4 | 19 | 13 | |||||
1009 | 1009 | -73.9636551433178 | 40.7901572818776 | 30B-PM-1019-02 | 30B | PM | 10192018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | true | false | false | true | POINT (-73.9636551433178 40.7901572818776) | 19 | 4 | 19 | 13 | |||||
1040 | 1040 | -73.9702588981432 | 40.776610754288 | 14E-AM-1008-08 | 14E | AM | 10082018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9702588981432 40.776610754288) | 19 | 4 | 19 | 13 | ||||||
1143 | 1143 | -73.9628349778362 | 40.793887005206 | 34A-PM-1013-03 | 34A | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628349778362 40.793887005206) | 19 | 4 | 19 | 13 | |||||
1163 | 1163 | -73.9677096985223 | 40.7825358361204 | 21C-AM-1014-02 | 21C | AM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 50 | true | true | true | false | true | false | true | false | false | false | false | false | false | looked at us from tree | POINT (-73.9677096985223 40.7825358361204) | 19 | 4 | 19 | 13 | ||||
1167 | 1167 | -73.9593244415072 | 40.794964729747 | 36C-PM-1013-03 | 36C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9593244415072 40.794964729747) | 19 | 4 | 19 | 13 | |||||
1321 | 1321 | -73.9699285688296 | 40.7774474015189 | 15D-AM-1007-08 | 15D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing #7 | false | false | false | false | false | false | true | false | POINT (-73.9699285688296 40.7774474015189) | 19 | 4 | 19 | 13 | |||||
1396 | 1396 | -73.9704677007779 | 40.7786860108302 | 16C-PM-1018-02 | 16C | PM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 6 | false | true | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9704677007779 40.7786860108302) | 19 | 4 | 19 | 13 | |||||
1448 | 1448 | -73.9772810073685 | 40.7693577540392 | 4C-PM-1010-03 | 04C | PM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9772810073685 40.7693577540392) | 19 | 4 | 19 | 13 | |||||
1513 | 1513 | -73.9662409997642 | 40.7891042935432 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | true | true | chasing #2 took #2 food wrapper and is foraging through it | false | false | false | false | false | false | true | false | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
1525 | 1525 | -73.9727115915422 | 40.7782929320632 | 14B-PM-1014-02 | 14B | PM | 10142018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9727115915422 40.7782929320632) | 19 | 4 | 19 | 13 | |||||
1601 | 1601 | -73.9544278270221 | 40.7987827316512 | 42D-PM-1013-02 | 42D | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail, Cinnamon feet | Ground Plane | FALSE | false | true | false | false | true | chasing (chased by #1),found a nut,buried it | false | false | false | false | false | false | true | false | POINT (-73.9544278270221 40.7987827316512) | 19 | 4 | 19 | 13 | |||
1700 | 1700 | -73.965675791028 | 40.7887310058451 | 27B-PM-1006-02 | 27B | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | By large tree chasing #1 | false | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965675791028 40.7887310058451) | 19 | 4 | 19 | 13 | |||||
1772 | 1772 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 10122018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690540696008 40.7766014124609) | 19 | 4 | 19 | 13 | |||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9745908987975 40.7655191512308) | 19 | 4 | 19 | 13 | |||||
1910 | 1910 | -73.9699876501742 | 40.7742482676758 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699876501742 40.77424826767581) | 19 | 4 | 19 | 13 | |||||
1959 | 1959 | -73.9707737073771 | 40.7800373465838 | 17B-PM-1012-02 | 17B | PM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | true | true | false | false | true | 2/3 chasing each other | true | true | false | true | true | false | true | false | POINT (-73.9707737073771 40.7800373465838) | 19 | 4 | 19 | 13 | |||||
1971 | 1971 | -73.9591880400132 | 40.7950071252836 | 36C-PM-1013-02 | 36C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | Clearing near bike path (bikes active) | false | true | false | true | true | true | true | false | false | true | false | true | false | POINT (-73.95918804001322 40.7950071252836) | 19 | 4 | 19 | 13 | |||||
2106 | 2106 | -73.9801651470389 | 40.7677698656935 | 1B-AM-1012-05 | 01B | AM | 10122018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9801651470389 40.7677698656935) | 19 | 4 | 19 | 13 | |||||
2118 | 2118 | -73.958369699409 | 40.7902456668332 | 32F-PM-1008-01 | 32F | PM | 10082018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.958369699409 40.7902456668332) | 19 | 4 | 19 | 13 | ||||||
2148 | 2148 | -73.9767317539505 | 40.7717600450632 | 6B-PM-1017-05 | 06B | PM | 10172018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767317539505 40.7717600450632) | 19 | 4 | 19 | 13 | |||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699124811406 40.7743016981538) | 19 | 4 | 19 | 13 | |||||
2328 | 2328 | -73.9678620840741 | 40.784719027304 | 23B-PM-1012-03 | 23B | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | 2/3 were chasing each other | false | false | false | false | true | false | false | true | POINT (-73.96786208407411 40.784719027304) | 19 | 4 | 19 | 13 | ||||
2351 | 2351 | -73.9745818450109 | 40.7654498873627 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9745818450109 40.7654498873627) | 19 | 4 | 19 | 13 | ||||||
2485 | 2485 | -73.9584950620879 | 40.7902770710643 | 32F-PM-1008-03 | 32F | PM | 10082018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9584950620879 40.7902770710643) | 19 | 4 | 19 | 13 | |||||
2513 | 2513 | -73.9767590273554 | 40.7717561807266 | 6B-PM-1017-07 | 06B | PM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9767590273554 40.7717561807266) | 19 | 4 | 19 | 13 | |||||
2591 | 2591 | -73.9786351029146 | 40.7716114164002 | 6A-PM-1012-06 | 06A | PM | 10122018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | elevated ground | false | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9786351029146 40.771611416400205) | 19 | 4 | 19 | 13 | ||||
2633 | 2633 | -73.9776151109912 | 40.7694681558386 | 4C-PM-1010-09 | 04C | PM | 10102018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9776151109912 40.7694681558386) | 19 | 4 | 19 | 13 | |||||
2670 | 2670 | -73.9531041906469 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | true | true | true | false | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | 19 | 4 | 19 | 13 | |||||
2699 | 2699 | -73.9743509423821 | 40.7690043677328 | 5F-AM-1007-02 | 05F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | tree | true | true | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.97435094238212 40.7690043677328) | 19 | 4 | 19 | 13 | |||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | true | false | true | false | true | false | false | true | false | POINT (-73.9543373703455 40.7943889087123) | 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 | |||||
2918 | 2918 | -73.9745152462626 | 40.7655415515908 | 1G-AM-1006-04 | 01G | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | false | true | false | false | true | collecting nest material | false | false | false | false | true | false | true | false | POINT (-73.9745152462626 40.76554155159081) | 19 | 4 | 19 | 13 | ||||||
2955 | 2955 | -73.9711666523376 | 40.7761513057034 | 13D-AM-1014-02 | 13D | AM | 10142018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | true | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9711666523376 40.7761513057034) | 19 | 4 | 19 | 13 | ||||||
2993 | 2993 | -73.9570722262693 | 40.7985706143519 | 40C-AM-1017-04 | 40C | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | true | true | chasing (#3) | false | false | false | false | false | false | true | false | POINT (-73.9570722262693 40.7985706143519) | 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 );