This data as json, CSV (advanced)
Suggested facets: Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Tail twitches, Indifferent, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
980 | 980 | -73.9709817796369 | 40.7773554311586 | 14D-PM-1019-07 | 14D | PM | 10192018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9709817796369 40.7773554311586) | 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 | ||||||
1688 | 1688 | -73.9677593344667 | 40.7763054313195 | 15G-PM-1019-07 | 15G | PM | 10192018 | 7 | Adult | + | Above Ground | 5 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9677593344667 40.7763054313195) | 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 | ||||
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 |
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 );