2018_Central_Park_Squirrel_Census_-_Squirrel_Data

3 rows where Hectare Squirrel Number = 10, Indifferent = 1 and Location = "Above Ground" sorted by Primary Fur Color

View and edit SQL

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging

Location

  • Above Ground · 3

Indifferent

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
399 -73.97634332024009 40.773847349068106 9B-PM-1013-10 09B PM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray "Brown" written in as Primary Above Ground 12   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9763433202401 40.7738473490681)
2177 -73.9758211560957 40.7693422860766 5E-AM-1008-10 05E AM 10082018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up a tree 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9758211560957 40.7693422860766)
2303 -73.9589470461357 40.7912817646361 33E-AM-1014-10 33E AM 10142018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589470461357 40.7912817646361)

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