2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Date = 10082018 and Hectare = "15E" sorted by Location

View and edit SQL

Suggested facets: Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Quaas, Indifferent

Eating

Tail twitches

  • 0 11

Hectare

  • 15E · 11

Date

  • 10082018 · 11
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
306 -73.96897001002671 40.7775169562765 15E-PM-1008-05 15E PM 10082018 5 Adult Gray   Gray+   Above Ground 20   0 0 0 0 0 sitting 0 1 0 0 0 0 0 0   POINT (-73.9689700100267 40.7775169562765)
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)
2722 -73.96922711321359 40.777528508844 15E-PM-1008-04 15E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692271132136 40.777528508844)
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)
1222 -73.9691420412059 40.777349258213796 15E-PM-1008-03 15E PM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 0 0 1 0   POINT (-73.9691420412059 40.7773492582138)
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)
2020 -73.96914538859642 40.77705240897121 15E-PM-1008-02 15E PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9691453885964 40.7770524089712)
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)
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)
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)

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