2018_Central_Park_Squirrel_Census_-_Squirrel_Data

4 rows where Date = 10142018, Hectare Squirrel Number = 1, Highlight Fur Color = "Cinnamon" and Tail twitches = 1 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail flags

Tail twitches

Highlight Fur Color

  • Cinnamon · 4

Hectare Squirrel Number

Date

  • 10142018 · 4
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
719 -73.96268812347421 40.7905208345549 30C-AM-1014-01 30C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9626881234742 40.7905208345549)
1015 -73.9720347089273 40.7727750272024 9E-PM-1014-01 09E PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Gathering/digging in grassy area b/w trees 0 0 0 0 1 looked like it was smelling/digging in the ground 0 0 0 0 1 0 1 0 indifferent (was in a grassy area with no humans nearby) POINT (-73.9720347089273 40.7727750272024)
1235 -73.9679686793869 40.7825993867876 21C-AM-1014-01 21C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   1 0 0 0 0 jumping back & forth on tree 0 0 0 1 1 0 1 0   POINT (-73.9679686793869 40.7825993867876)
2016 -73.9589492240754 40.798901118974 40A-PM-1014-01 40A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0 stared & then went back up tree—then ran to different tree POINT (-73.9589492240754 40.798901118974)

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