2018_Central_Park_Squirrel_Census_-_Squirrel_Data

6 rows where Above Ground Sighter Measurement = 5 and Date = 10132018 sorted by Tail twitches

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Foraging, Indifferent, Runs from

Tail twitches

  • 0 6

Kuks

  • 0 6

Date

  • 10132018 · 6

Above Ground Sighter Measurement

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
135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush 0 0 1 0 1   0 0 0 0 0 0 0 1 watching me POINT (-73.9694168118643 40.7728877377977)
201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
1252 -73.9777998932399 40.770981586533395 5B-PM-1013-02 05B PM 10132018 2 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9777998932399 40.7709815865334)
1507 -73.9699799501516 40.7736576286234 11F-AM-1013-02 11F AM 10132018 2 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699799501516 40.7736576286234)
1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782603348665 40.7705790257951)
1935 -73.9675268877392 40.775040968171794 13H-AM-1013-01 13H AM 10132018 1 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675268877392 40.7750409681718)

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