2018_Central_Park_Squirrel_Census_-_Squirrel_Data

6 rows where Hectare Squirrel Number = 13 and Highlight Fur Color = "Cinnamon" sorted by Tail flags

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Combination of Primary and Highlight Color, Running, Eating, Foraging, Tail twitches, Approaches, Indifferent

Highlight Fur Color

  • Cinnamon · 6

Hectare Squirrel Number

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
136 -73.9528682507794 40.792580780830704 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.9528682507794 40.7925807808307)
1376 -73.97733615807921 40.7729478226715 7B-AM-1008-13 07B AM 10082018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773361580792 40.7729478226715)
1565 -73.9803895322385 40.7680730789944 1B-AM-1012-13 01B AM 10122018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9803895322385 40.7680730789944)
1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)
2540 -73.959127912788 40.79211971304029 33E-AM-1014-13 33E AM 10142018 13 Adult Black Cinnamon Black+Cinnamon Cinnamon on the tail Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.959127912788 40.7921197130403)
2932 -73.9705837974358 40.775849484967296 13E-AM-1017-13 13E AM 10172018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on rock 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97058379743581 40.7758494849673)

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 133.142ms