This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1210 | 1210 | -73.9707937464541 | 40.7725282708448 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | false | false | false | false | false | traveling | false | false | false | false | false | false | true | false | POINT (-73.9707937464541 40.7725282708448) | 19 | 4 | 19 | 13 | ||||
255 | 255 | -73.9800669115792 | 40.7676825134384 | 1B-AM-1012-07 | 01B | AM | 10122018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 2 | on tree trunk | false | true | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9800669115792 40.7676825134384) | 19 | 4 | 19 | 13 | |||||
1846 | 1846 | -73.9653311136561 | 40.780193490343 | 19F-PM-1017-07 | 19F | PM | 10172018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9653311136561 40.78019349034301) | 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 | ||||
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 | ||||
668 | 668 | -73.9706903740547 | 40.7726873760687 | 10G-AM-1006-07 | 10G | AM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9706903740547 40.77268737606871) | 19 | 4 | 19 | 13 | ||||||
812 | 812 | -73.9699675160516 | 40.7773012642758 | 15E-PM-1008-07 | 15E | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9699675160516 40.7773012642758) | 19 | 4 | 19 | 13 | ||||||
1207 | 1207 | -73.9594708328732 | 40.791192982895 | 32E-AM-1007-07 | 32E | AM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | on tennis club house roof | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9594708328732 40.791192982895) | 19 | 4 | 19 | 13 | ||||||
1390 | 1390 | -73.9677146741772 | 40.7788231332337 | 17E-AM-1017-07 | 17E | AM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9677146741772 40.7788231332337) | 19 | 4 | 19 | 13 | ||||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1517 | 1517 | -73.970041085185 | 40.7834427580313 | 21A-AM-1019-07 | 21A | AM | 10192018 | 7 | Adult | Gray | Gray+ | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.970041085185 40.783442758031306) | 19 | 4 | 19 | 13 | ||||||
1666 | 1666 | -73.9649465476871 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649465476871 40.7822708362663) | 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 | ||||||
1817 | 1817 | -73.9703076450783 | 40.770158422629 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#8),playing? | false | false | false | false | false | false | true | false | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
2267 | 2267 | -73.9727926335397 | 40.77037055775 | 7F-AM-1008-07 | 07F | AM | 10082018 | 7 | Adult | Gray | Gray+ | Above Ground | 28 | next to the hole of #6 | false | false | false | false | false | standing | false | false | false | false | false | false | true | false | POINT (-73.9727926335397 40.77037055775) | 19 | 4 | 19 | 13 | ||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | together w/ #8 | false | false | false | true | false | false | true | false | POINT (-73.9787771053108 40.76935621227501) | 19 | 4 | 19 | 13 | |||||
2362 | 2362 | -73.9700263936574 | 40.7699335098581 | 7H-PM-1006-07 | 07H | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 15 | false | true | true | false | false | playing w/ #6 | false | false | false | false | false | false | true | false | POINT (-73.9700263936574 40.7699335098581) | 19 | 4 | 19 | 13 | |||||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | lying down | false | false | false | false | false | false | true | false | POINT (-73.9777206733344 40.7668595585487) | 19 | 4 | 19 | 13 | |||||
2780 | 2780 | -73.9700634278 | 40.7784223722453 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700634278 40.7784223722453) | 19 | 4 | 19 | 13 | ||||||
1217 | 1217 | -73.9764850086767 | 40.7737340720562 | 8B-AM-1007-07 | 08B | AM | 10072018 | 7 | Juvenile | Gray | Black | Gray+Black | Above Ground | 8 | false | false | false | true | false | holding nut | false | false | false | false | false | false | true | false | POINT (-73.9764850086767 40.7737340720562) | 19 | 4 | 19 | 13 | ||||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | false | true | false | POINT (-73.9606817053484 40.7917320450401) | 19 | 4 | 19 | 13 | |||||
985 | 985 | -73.9681722244801 | 40.783559826281 | 22B-PM-1014-07 | 22B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | true | false | POINT (-73.9681722244801 40.783559826281) | 19 | 4 | 19 | 13 | |||||
1091 | 1091 | -73.97055600791 | 40.7698499183436 | 7H-AM-1006-07 | 07H | AM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.97055600791 40.7698499183436) | 19 | 4 | 19 | 13 | |||||||
1262 | 1262 | -73.9683345414813 | 40.7779016280345 | 16E-PM-1018-07 | 16E | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9683345414813 40.7779016280345) | 19 | 4 | 19 | 13 | |||||
1338 | 1338 | -73.9716624574422 | 40.7762037110101 | 13D-PM-1018-07 | 13D | PM | 10182018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | true | false | true | false | false | scratching | false | false | false | false | false | false | true | false | POINT (-73.9716624574422 40.7762037110101) | 19 | 4 | 19 | 13 | ||||
1687 | 1687 | -73.9754790964561 | 40.768336388516 | 4E-PM-1008-07 | 04E | PM | 10082018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9754790964561 40.768336388516) | 19 | 4 | 19 | 13 | |||||
1897 | 1897 | -73.97107389601 | 40.7723265810536 | 10F-PM-1019-07 | 10F | PM | 10192018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Same tree (as #6) | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97107389601 40.7723265810536) | 19 | 4 | 19 | 13 | ||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.963209639301 40.7926138443715) | 19 | 4 | 19 | 13 | |||||
1104 | 1104 | -73.9589852989486 | 40.7912720015917 | 33E-AM-1014-07 | 33E | AM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9589852989486 40.7912720015917) | 19 | 4 | 19 | 13 | |||||
25 | 25 | -73.9671130680114 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9671130680114 40.7784859700171) | 19 | 4 | 19 | 13 | |||||
407 | 407 | -73.9787658435198 | 40.7689419765393 | 3B-PM-1007-07 | 03B | PM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | eating loudly <- peanuts w/ shells | false | false | false | false | false | false | true | false | POINT (-73.9787658435198 40.7689419765393) | 19 | 4 | 19 | 13 | ||||
761 | 761 | -73.975062146111 | 40.7723417173451 | 8C-PM-1013-07 | 08C | PM | 10132018 | 7 | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.975062146111 40.7723417173451) | 19 | 4 | 19 | 13 | ||||||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.95916671628011 40.7937602121568) | 19 | 4 | 19 | 13 | ||||
2085 | 2085 | -73.9690551477139 | 40.7823685663196 | 20B-PM-1013-07 | 20B | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9690551477139 40.7823685663196) | 19 | 4 | 19 | 13 | |||||
2104 | 2104 | -73.9622419917579 | 40.794579797904 | 35A-AM-1014-07 | 35A | AM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9622419917579 40.794579797904) | 19 | 4 | 19 | 13 | |||||
2189 | 2189 | -73.9761776424664 | 40.7695941843825 | 5D-PM-1018-07 | 05D | PM | 10182018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9761776424664 40.7695941843825) | 19 | 4 | 19 | 13 | |||||
2304 | 2304 | -73.9715251156965 | 40.774621784862 | 11E-PM-1012-07 | 11E | PM | 10122018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9715251156965 40.774621784862) | 19 | 4 | 19 | 13 | |||||
2482 | 2482 | -73.9805927710872 | 40.7679989116642 | 1B-PM-1019-07 | 01B | PM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9805927710872 40.7679989116642) | 19 | 4 | 19 | 13 | |||||
2713 | 2713 | -73.9687214684206 | 40.7792841720164 | 17D-AM-1008-07 | 17D | AM | 10082018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687214684206 40.7792841720164) | 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 |
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 );