2018_Central_Park_Squirrel_Census_-_Squirrel_Data

4 rows where Highlight Fur Color = "Black, Cinnamon, White", Location = "Above Ground" and Tail twitches = 0 sorted by Tail flags

View and edit SQL

Suggested facets: Hectare Squirrel Number, Age, Above Ground Sighter Measurement, Running, Climbing, Eating, Kuks, Indifferent, Runs from

Tail twitches

Highlight Fur Color

  • Black, Cinnamon, White · 4

Approaches

  • 0 4
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
113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   1 0 0 0 0 flying 0 0 0 0 0 0 0 0   POINT (-73.9700100617602 40.7815739959357)
673 -73.958417813526 40.792730121447605 34E-PM-1006-01 34E PM 10062018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   0 0 0 0 0 sitting and watching on a tree 0 0 0 0 0 0 1 0   POINT (-73.958417813526 40.7927301214476)
1537 -73.97672201797249 40.77532621031229 10A-PM-1014-03 10A PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground   above my head in tree 0 0 0 1 0 eating (in a tree) 0 0 0 0 0 0 1 0 indifferent (lots of people taking its picture,didn't bother it) POINT (-73.9767220179725 40.7753262103123)
1625 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)

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