2018_Central_Park_Squirrel_Census_-_Squirrel_Data

4 rows where Climbing = 1, Hectare Squirrel Number = 7 and Primary Fur Color = "Cinnamon"

View and edit SQL

Suggested facets: Shift, Age, Combination of Primary and Highlight Color, Location, Chasing, Eating, Indifferent

Tail twitches

Foraging

Primary Fur Color

  • Cinnamon · 4

Hectare Squirrel Number

Climbing

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
255 -73.9800669115792 40.767682513438395 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9800669115792 40.7676825134384)
588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9684092812839 40.7711445841928)
2554 -73.9701505245419 40.768998364571 6I-PM-1013-07 06I PM 10132018 7 Adult Cinnamon   Cinnamon+   Above Ground 11   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701505245419 40.768998364571004)

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