2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Date = 10132018, Hectare Squirrel Number = 8 and Primary Fur Color = "Gray" sorted by Running

View and edit SQL

Suggested facets: Age, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Tail twitches, Approaches, Indifferent, Runs from

Primary Fur Color

  • Gray · 8

Moans

  • 0 8

Hectare Squirrel Number

Date

  • 10132018 · 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
586 -73.9789126088606 40.7685079149692 2C-PM-1013-08 02C PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9789126088606 40.7685079149692)
839 -73.9615602805554 40.7945662185621 35A-PM-1013-08 35A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9615602805554 40.7945662185621)
924 -73.9591695545875 40.793811636076704 35D-PM-1013-08 35D PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9591695545875 40.7938116360767)
1559 -73.9631648674122 40.7926529617419 32A-PM-1013-08 32A PM 10132018 8 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9631648674122 40.7926529617419)
2437 -73.9619856085821 40.791951652009104 32C-PM-1013-08 32C PM 10132018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9619856085821 40.7919516520091)
2950 -73.9790980124501 40.7685934093915 2B-PM-1013-08 02B PM 10132018 8 Adult Gray White Gray+White   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9790980124501 40.7685934093915)
902 -73.969105907 40.782047490919204 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   1 0 0 0 0 being chased by dog 0 0 0 0 0 0 0 1   POINT (-73.969105907 40.7820474909192)
955 -73.96065706156101 40.79561507441021 36A-PM-1013-08 36A PM 10132018 8   Gray   Gray+   Ground Plane FALSE "FIELD" 1 0 0 0 0 running from #7 0 0 0 0 0 0 0 1   POINT (-73.960657061561 40.7956150744102)

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