This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Eating, Tail flags, Tail twitches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 9 | -73.9770718586754 | 40.7729752391435 | 7B-AM-1008-09 | 07B | AM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9770718586754 40.7729752391435) | 19 | 4 | 19 | 13 | ||||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 19 | 4 | 19 | 13 | |||||
141 | 141 | -73.9590992841423 | 40.793758098573 | 35D-PM-1013-09 | 35D | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9590992841423 40.793758098573) | 19 | 4 | 19 | 13 | |||||
146 | 146 | -73.95621174551 | 40.7951044378207 | 38E-AM-1010-09 | 38E | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95621174551 40.7951044378207) | 19 | 4 | 19 | 13 | |||||
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 | |||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9547423290276 40.7899702628835) | 19 | 4 | 19 | 13 | ||||||
556 | 556 | -73.9721670042434 | 40.776085913838 | 13D-PM-1018-09 | 13D | PM | 10182018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9721670042434 40.776085913838) | 19 | 4 | 19 | 13 | |||||
570 | 570 | -73.9745227769788 | 40.7673618284782 | 3F-AM-1006-09 | 03F | AM | 10062018 | 9 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | in grass by light post | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9745227769788 40.76736182847821) | 19 | 4 | 19 | 13 | ||||
611 | 611 | -73.9679399097382 | 40.7742813149957 | 13H-PM-1010-09 | 13H | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.96793990973822 40.7742813149957) | 19 | 4 | 19 | 13 | ||||||
803 | 803 | -73.9697983725608 | 40.7700677022205 | 8I-PM-1013-09 | 08I | PM | 10132018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9697983725608 40.7700677022205) | 19 | 4 | 19 | 13 | |||||
809 | 809 | -73.9633250636501 | 40.7922155082679 | 32A-PM-1013-09 | 32A | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9633250636501 40.7922155082679) | 19 | 4 | 19 | 13 | |||||
949 | 949 | -73.9701596268736 | 40.7702106607329 | 8H-PM-1014-09 | 08H | PM | 10142018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701596268736 40.7702106607329) | 19 | 4 | 19 | 13 | |||||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9803282698463 40.7680809889384) | 19 | 4 | 19 | 13 | ||||
1445 | 1445 | -73.9696196840065 | 40.7836431098335 | 21A-AM-1019-09 | 21A | AM | 10192018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9696196840065 40.7836431098335) | 19 | 4 | 19 | 13 | ||||||
1605 | 1605 | -73.9690362384597 | 40.7767162824413 | 14F-PM-1012-09 | 14F | PM | 10122018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9690362384597 40.7767162824413) | 19 | 4 | 19 | 13 | |||||
2401 | 2401 | -73.972010921173 | 40.7701626919216 | 7G-AM-1010-09 | 07G | AM | 10102018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.972010921173 40.7701626919216) | 19 | 4 | 19 | 13 | ||||||
2492 | 2492 | -73.9801619956135 | 40.7678576697542 | 1B-AM-1012-09 | 01B | AM | 10122018 | 9 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9801619956135 40.7678576697542) | 19 | 4 | 19 | 13 | ||||||
2625 | 2625 | -73.9699188544459 | 40.7772180370053 | 15E-PM-1008-09 | 15E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9699188544459 40.7772180370053) | 19 | 4 | 19 | 13 | ||||||
2787 | 2787 | -73.9765306970303 | 40.7694956875859 | 4D-PM-1008-09 | 04D | PM | 10082018 | 9 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765306970303 40.7694956875859) | 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 | |||||
2978 | 2978 | -73.9688817006443 | 40.7829120321438 | 20B-PM-1013-09 | 20B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9688817006443 40.7829120321438) | 19 | 4 | 19 | 13 | |||||
3003 | 3003 | -73.9698663926657 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698663926657 40.773999710413) | 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 );