2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Eating = 1 and Hectare = "15E" sorted by Other Activities

View and edit SQL

Suggested facets: Location, Running, Foraging

Hectare Squirrel Number

Above Ground Sighter Measurement

Hectare

Eating

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
749 -73.96863045815259 40.7773631337117 15E-PM-1008-01 15E PM 10082018 1 Adult Gray   Gray+   Above Ground 4 on fallen tree 1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9686304581526 40.7773631337117)
812 -73.9699675160516 40.7773012642758 15E-PM-1008-07 15E PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9699675160516 40.7773012642758)
1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9692925815903 40.7774506065008)
2139 -73.9697471123497 40.777316338832705 15E-PM-1008-10 15E PM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697471123497 40.777316338832705)
2625 -73.96991885444591 40.7772180370053 15E-PM-1008-09 15E PM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699188544459 40.7772180370053)
2996 -73.970033345821 40.777259393859 15E-PM-1008-08 15E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970033345821 40.777259393859)
2775 -73.96971093983021 40.7776218260789 15E-PM-1008-06 15E PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9697109398302 40.7776218260789)

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