2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Date = 10142018 and Hectare = "09F" sorted by Tail twitches

View and edit SQL

Suggested facets: Primary Fur Color, Combination of Primary and Highlight Color, Running, Eating, Foraging, Tail flags, Indifferent

Tail twitches

  • 0 8

Hectare

Date

  • 10142018 · 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
158 -73.9710991123992 40.77238897266471 9F-PM-1014-02 09F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9710991123992 40.7723889726647)
445 -73.97140573271591 40.7720375135272 9F-PM-1014-04 09F PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9714057327159 40.7720375135272)
735 -73.971379936565 40.7721434941226 9F-PM-1014-05 09F PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.971379936565 40.7721434941226)
877 -73.9710547484029 40.7723589827074 9F-PM-1014-03 09F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710547484029 40.7723589827074)
1965 -73.9719359643975 40.772699885583 9F-PM-1014-01 09F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 he is fed every day by a woman who calls him "chiquita"! he ran right up to her. POINT (-73.9719359643975 40.772699885583)
2047 -73.9721656413591 40.7722869065638 9F-PM-1014-08 09F PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0 turned to face me while eating POINT (-73.9721656413591 40.7722869065638)
2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719901848577 40.7720525965356)
2980 -73.97164145863809 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0 running (from birds) 0 0 0 1 0 0 1 0   POINT (-73.9716414586381 40.771760114722)

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