This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1979 | 1979 | -73.9612759291399 | 40.7930468323219 | 33B-AM-1010-03 | 33B | AM | 10102018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9612759291399 40.7930468323219) | 19 | 4 | 19 | 13 | ||||||
2113 | 2113 | -73.9582904814652 | 40.7905915749564 | 32F-AM-1012-04 | 32F | AM | 10122018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9582904814652 40.7905915749564) | 19 | 4 | 19 | 13 | ||||||
2120 | 2120 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9733905460282 40.7656337147768) | 19 | 4 | 19 | 13 | ||||||
2135 | 2135 | -73.9596251284566 | 40.7916254797561 | 33D-AM-1017-05 | 33D | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9596251284566 40.7916254797561) | 19 | 4 | 19 | 13 | ||||||
2150 | 2150 | -73.9557710118271 | 40.7919161185557 | 34G-PM-1006-01 | 34G | PM | 10062018 | 1 | Adult | Black | Black+ | Skinny, thin tail | Ground Plane | FALSE | false | false | false | false | false | digging | false | false | false | false | false | false | false | false | POINT (-73.9557710118271 40.7919161185557) | 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 | ||||||
2192 | 2192 | -73.9593410965431 | 40.7923134010383 | 33D-AM-1017-08 | 33D | AM | 10172018 | 8 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593410965431 40.7923134010383) | 19 | 4 | 19 | 13 | ||||||
2206 | 2206 | -73.9594446018346 | 40.7917800352042 | 33D-AM-1017-06 | 33D | AM | 10172018 | 6 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | true | true | false | false | false | false | false | true | runs from (ran into hole in tree trunk) | POINT (-73.9594446018346 40.7917800352042) | 19 | 4 | 19 | 13 | |||||
2266 | 2266 | -73.9716402454355 | 40.7665133780672 | 3I-PM-1013-08 | 03I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9716402454355 40.7665133780672) | 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 | ||||||
2284 | 2284 | -73.9730181306326 | 40.7794601322427 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9730181306326 40.7794601322427) | 19 | 4 | 19 | 13 | |||||||
2322 | 2322 | -73.9723677854798 | 40.7667315410871 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9723677854798 40.7667315410871) | 19 | 4 | 19 | 13 | ||||||
2329 | 2329 | -73.9717515173863 | 40.7747999274418 | 11D-PM-1006-04 | 11D | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9717515173863 40.7747999274418) | 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 | ||||||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9729603550254 40.7660215710657) | 19 | 4 | 19 | 13 | |||||
2413 | 2413 | -73.959701727877 | 40.790660026971 | 32E-AM-1007-03 | 32E | AM | 10072018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.959701727877 40.790660026971) | 19 | 4 | 19 | 13 | ||||||
2427 | 2427 | -73.9729297485331 | 40.7673278541438 | 4H-AM-1006-03 | 04H | AM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | met #4 while foraging and briefly tussled | false | false | false | false | false | false | true | false | POINT (-73.9729297485331 40.7673278541438) | 19 | 4 | 19 | 13 | |||||
2449 | 2449 | -73.9599911537509 | 40.7914452542845 | 33D-AM-1017-04 | 33D | AM | 10172018 | 4 | Adult | Black | Black+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9599911537509 40.7914452542845) | 19 | 4 | 19 | 13 | ||||||
2469 | 2469 | -73.9600963639087 | 40.7934962325313 | 34C-AM-1007-01 | 34C | AM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | dog | POINT (-73.9600963639087 40.7934962325313) | 19 | 4 | 19 | 13 | |||||
2535 | 2535 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
2549 | 2549 | -73.972248505758 | 40.7659043693008 | 3I-PM-1013-01 | 03I | PM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.972248505758 40.765904369300806) | 19 | 4 | 19 | 13 | ||||||
2557 | 2557 | -73.9712454251679 | 40.7674262749891 | 5I-PM-1008-02 | 05I | PM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | crossing pavement in front of arsenal | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9712454251679 40.7674262749891) | 19 | 4 | 19 | 13 | |||||
2572 | 2572 | -73.9719901848577 | 40.7720525965356 | 9F-PM-1014-07 | 09F | PM | 10142018 | 7 | Adult | Black | Black+ | !!! | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9719901848577 40.7720525965356) | 19 | 4 | 19 | 13 | |||||
2638 | 2638 | -73.9598973337711 | 40.7933346360478 | 34C-PM-1012-01 | 34C | PM | 10122018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9598973337711 40.7933346360478) | 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 | |||||
2768 | 2768 | -73.9641088172632 | 40.7886555184212 | 28C-AM-1014-01 | 28C | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9641088172632 40.7886555184212) | 19 | 4 | 19 | 13 | ||||||
2773 | 2773 | -73.9625932664956 | 40.7885379477349 | 29D-AM-1014-01 | 29D | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9625932664956 40.7885379477349) | 19 | 4 | 19 | 13 | ||||||
2817 | 2817 | -73.9596445861554 | 40.7971948679007 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
2909 | 2909 | -73.9564478909357 | 40.7976928775417 | 40C-PM-1006-04 | 40C | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9564478909357 40.7976928775417) | 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 );