2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Chasing = 1, Hectare Squirrel Number = 2 and Highlight Fur Color = "Cinnamon, White" sorted by Running

View and edit SQL

Suggested facets: Shift, Date, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail flags, Tail twitches, Indifferent, Runs from

Eating

Approaches

Highlight Fur Color

  • Cinnamon, White · 7

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
230 -73.97314980648721 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9731498064872 40.7659963196581)
629 -73.95737241332641 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 1 0 chasing (#1) 0 0 0 0 0 0 0 1   POINT (-73.9573724133264 40.7980080911115)
1201 -73.97828135384209 40.7715730368712 6A-AM-1006-02 06A AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree 0 1 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.9782813538421 40.7715730368712)
1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9704677007779 40.7786860108302)
1847 -73.9782283921819 40.766793260207706 1D-PM-1007-02 01D PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9782283921819 40.7667932602077)
1576 -73.96199851876159 40.79432777435321 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619985187616 40.7943277743532)

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