2018_Central_Park_Squirrel_Census_-_Squirrel_Data

6 rows where Approaches = 1, Hectare Squirrel Number = 5 and Highlight Fur Color = "Cinnamon" sorted by Tail flags

View and edit SQL

Suggested facets: Shift, Date, Running, Eating, Foraging, Kuks, Tail flags, Tail twitches, Indifferent

Highlight Fur Color

  • Cinnamon · 6

Hectare Squirrel Number

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
644 -73.97221256300399 40.776131146585705 13C-PM-1019-05 13C PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 1 0   POINT (-73.972212563004 40.7761311465857)
1336 -73.97338200536791 40.76873304735621 5G-PM-1010-05 05G PM 10102018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9733820053679 40.7687330473562)
1366 -73.97115821991021 40.7783674409485 15C-PM-1017-05 15C PM 10172018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 1 1 0 0   POINT (-73.9711582199102 40.7783674409485)
2196 -73.96233563694321 40.7888693815168 29D-AM-1014-05 29D AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rocky area 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9623356369432 40.7888693815168)
2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9690174442945 40.7817617696508)
1174 -73.9682067129876 40.7779911208015 16E-PM-1018-05 16E PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 staring 0 0 0 1 0 1 0 0 approaches (very close) POINT (-73.9682067129876 40.7779911208015)

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.224ms