2018_Central_Park_Squirrel_Census_-_Squirrel_Data

218 rows where Date = 10122018 sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 17
  • 1 1
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
2880 2880 -73.9726598256924 40.7707862446236 7F-PM-1012-03 07F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 0 1   POINT (-73.9726598256924 40.7707862446236)
2673 2673 -73.9768867959365 40.7734803954589 8B-PM-1012-01 08B PM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768867959365 40.7734803954589)
60 60 -73.9768674812942 40.7735232648872 8B-PM-1012-02 08B PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hiding in bushes 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768674812942 40.7735232648872)
270 270 -73.9767191629692 40.7730786298701 8B-PM-1012-03 08B PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9767191629692 40.7730786298701)
1031 1031 -73.9766593636657 40.7735708178842 8B-PM-1012-04 08B PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9766593636657 40.7735708178842)
2317 2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
344 344 -73.9759432151552 40.7733240612552 8B-PM-1012-06 08B PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 2 on a bench 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9759432151552 40.7733240612552)
2986 2986 -73.97565337638129 40.7733537881363 8B-PM-1012-07 08B PM 10122018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9756533763813 40.7733537881363)
424 424 -73.9756557086441 40.773296289823996 8B-PM-1012-08 08B PM 10122018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756557086441 40.773296289824)
1850 1850 -73.975809362521 40.773470273783495 8B-PM-1012-09 08B PM 10122018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.975809362521 40.7734702737835)
606 606 -73.9717580228664 40.7715726159383 8F-PM-1012-01 08F PM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.97175802286641 40.7715726159383)
2391 2391 -73.9721497679014 40.771616019938605 8F-PM-1012-02 08F PM 10122018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9721497679014 40.7716160199386)
345 345 -73.9724452296309 40.7715792113505 8F-PM-1012-03 08F PM 10122018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 buried an acorn 0 0 0 0 0 0 1 0   POINT (-73.9724452296309 40.7715792113505)
229 229 -73.97241624297101 40.7714260236636 8F-PM-1012-04 08F PM 10122018 4 Adult Gray   Gray+   Above Ground 6   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.972416242971 40.7714260236636)
447 447 -73.97259060164741 40.7713889729739 8F-PM-1012-05 08F PM 10122018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9725906016474 40.7713889729739)
1350 1350 -73.9727698663722 40.7714335285174 8F-PM-1012-06 08F PM 10122018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9727698663722 40.7714335285174)
2372 2372 -73.9724879969884 40.771098202397 8F-PM-1012-07 08F PM 10122018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 17   0 0 1 0 0 gathering 0 0 0 0 0 0 0 0   POINT (-73.9724879969884 40.771098202397)
1060 1060 -73.97288710611909 40.771298365894395 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9728871061191 40.7712983658944)

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