2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Chasing = 1, Foraging = 0, Hectare Squirrel Number = 5 and Shift = "PM" sorted by Primary Fur Color

View and edit SQL

Suggested facets: Date, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Quaas, Tail flags, Tail twitches, Indifferent, Runs from

Shift

Hectare Squirrel Number

Foraging

Eating

  • 0 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
360 -73.9672054610151 40.7876519923501 26A-PM-1006-05 26A PM 10062018 5 Adult Gray   Gray+   Above Ground 40   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9672054610151 40.7876519923501)
765 -73.96797780019 40.784762947325795 23B-PM-1012-05 23B PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 chain link fence 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.96797780019 40.7847629473258)
1367 -73.9542684235907 40.7944237164092 38G-PM-1020-05 38G PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 1 0 1 0 0 1 0   POINT (-73.9542684235907 40.7944237164092)
1489 -73.9501762527462 40.797553408607705 42H-PM-1014-05 42H PM 10142018 5 Adult Gray White Gray+White   Above Ground 15   1 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9501762527462 40.7975534086077)
1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0 chasing (#4) 0 0 0 0 0 0 0 1   POINT (-73.9581310602492 40.7960214726964)
1754 -73.9652134469963 40.7803438278765 19F-PM-1017-05 19F PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9652134469963 40.7803438278765)
1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9692563597762 40.770904999952)

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