2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Date = 10132018 and Hectare Squirrel Number = 10 sorted by Color notes

View and edit SQL

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Indifferent, Runs from

Hectare Squirrel Number

Date

  • 10132018 · 7
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
69 -73.9689000978955 40.7828364735236 20B-PM-1013-10 20B PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 drank from a pond of rain water 0 0 0 0 0 0 1 0   POINT (-73.9689000978955 40.7828364735236)
1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
1852 -73.9792161469158 40.767928543625295 2C-PM-1013-10 02C PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9792161469158 40.7679285436253)
2445 -73.96193040894 40.792045169318 32C-PM-1013-10 32C PM 10132018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96193040894 40.792045169318)
2601 -73.979636950073 40.7677999753976 1C-PM-1013-10 01C PM 10132018 10 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.979636950073 40.7677999753976)
2810 -73.9614659899028 40.7945562907624 35A-PM-1013-10 35A PM 10132018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9614659899028 40.7945562907624)
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)

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