2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Date = 10172018, Hectare Squirrel Number = 3 and Highlight Fur Color = "Cinnamon" sorted by Specific Location

View and edit SQL

Suggested facets: Shift, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail twitches, Approaches, Indifferent, Runs from

Highlight Fur Color

  • Cinnamon · 8

Hectare Squirrel Number

Date

  • 10172018 · 8
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
232 -73.9624184586031 40.7921524868211 32B-AM-1017-03 32B AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 1 1 approaches (primarily),runs from (initially),follows POINT (-73.9624184586031 40.7921524868211)
786 -73.953296595236 40.7927644594513 36I-AM-1017-03 36I AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon stripe on back Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.953296595236 40.7927644594513)
791 -73.9772635911119 40.7709428872533 6B-PM-1017-03 06B PM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9772635911119 40.7709428872533)
1375 -73.9564741038174 40.7938845572816 36F-AM-1017-03 36F AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon Cinnamon on shoulders Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9564741038174 40.7938845572816)
2747 -73.971314838366 40.774951285041 12E-AM-1017-03 12E AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.971314838366 40.774951285041)
2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.953092053256 40.7982256930243)
2867 -73.969370141813 40.7840721191988 22A-PM-1017-03 22A PM 10172018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.969370141813 40.7840721191988)
2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)

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