2018_Central_Park_Squirrel_Census_-_Squirrel_Data

3 rows where Date = 10202018, Hectare = "12F" and Tail twitches = 0 sorted by Foraging

View and edit SQL

Suggested facets: Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running

Tail twitches

Hectare

Date

  • 10202018 · 3
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
264 -73.9698714743386 40.7743814661685 12F-AM-1020-02 12F AM 10202018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9698714743386 40.7743814661685)
477 -73.97014812002979 40.7751110354034 12F-AM-1020-06 12F AM 10202018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701481200298 40.7751110354034)
2550 -73.96948057455221 40.774355690284295 12F-AM-1020-01 12F AM 10202018 1 Adult Cinnamon White Cinnamon+White   Above Ground 17 Tree 0 0 0 0 0 jumping 0 0 0 0 0 0 0 0   POINT (-73.9694805745522 40.7743556902843)

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