2018_Central_Park_Squirrel_Census_-_Squirrel_Data

4 rows where Above Ground Sighter Measurement = 15, Highlight Fur Color = "White" and Running = 1 sorted by Date

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Specific Location, Chasing, Climbing, Eating, Indifferent, Runs from

Tail twitches

  • 0 4

Running

Highlight Fur Color

  • White · 4

Above Ground Sighter Measurement

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
1489 -73.9501762527462 40.797553408607705 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9501762527462 40.7975534086077)
1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat 1 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.958719099962 40.7947587726617)
999 -73.980948293606 40.76856888506279 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.980948293606 40.7685688850628)
2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 135.261ms