2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Above Ground Sighter Measurement = 15 and Highlight Fur Color = "Cinnamon, White" sorted by Date

View and edit SQL

Suggested facets: Hectare, Date, Age, Chasing, Climbing, Foraging, Kuks, Indifferent

Tail twitches

  • 0 5

Highlight Fur Color

  • Cinnamon, White · 5

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
260 -73.97843611793199 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree 0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.978436117932 40.7724769242403)
1104 -73.95898529894859 40.7912720015917 33E-AM-1014-07 33E AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9589852989486 40.7912720015917)
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)
2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 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.958932543729 40.7913445531266)
1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)

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