This data as json, CSV (advanced)
Suggested facets: Hectare, Shift, Date, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Other Activities, Kuks, Tail flags, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
813 | 813 | -73.9758959798289 | 40.7694125671679 | 4D-PM-1008-01 | 04D | PM | 10082018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9758959798289 40.7694125671679) | 19 | 4 | 19 | 13 | |||||
925 | 925 | -73.9763116425885 | 40.7688839576487 | 4D-PM-1008-03 | 04D | PM | 10082018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | ran two feet up tree trunk | POINT (-73.9763116425885 40.7688839576487) | 19 | 4 | 19 | 13 | ||||
1775 | 1775 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 10142018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | true | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
1871 | 1871 | -73.9748367344424 | 40.7693513000034 | 5E-PM-1012-06 | 05E | PM | 10122018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | oak tree at end of ramp from Chess House | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9748367344424 40.7693513000034) | 19 | 4 | 19 | 13 | ||||
2647 | 2647 | -73.954499539822 | 40.7949716693686 | 38F-AM-1018-01 | 38F | AM | 10182018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.954499539822 40.7949716693686) | 19 | 4 | 19 | 13 | |||||
150 | 150 | -73.9763430829342 | 40.7686351097159 | 4D-PM-1008-11 | 04D | PM | 10082018 | 11 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | on tree facing downward | false | true | false | false | false | chased #12 | true | false | false | true | false | false | false | true | POINT (-73.9763430829342 40.7686351097159) | 19 | 4 | 19 | 13 | |||
1287 | 1287 | -73.9763236949008 | 40.7686815615335 | 4D-PM-1008-12 | 04D | PM | 10082018 | 12 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 3 | true | false | false | false | false | was chased by # 11 | true | false | false | false | false | false | false | true | POINT (-73.9763236949008 40.7686815615335) | 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 );