2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Chasing = 1, Date = 10062018 and Hectare Squirrel Number = 2

View and edit SQL

Suggested facets: Shift, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail flags, Approaches, Indifferent, Runs from

Tail twitches

Hectare Squirrel Number

Chasing

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)
503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.95983407835722 40.7915857030295)
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)
1700 -73.965675791028 40.7887310058451 27B-PM-1006-02 27B PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE By large tree chasing #1 0 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965675791028 40.7887310058451)
2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2490 -73.9693876553956 40.7707232748402 8I-AM-1006-02 08I AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9693876553956 40.7707232748402)
2796 -73.96310890114121 40.789191946875 29C-PM-1006-02 29C PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9631089011412 40.789191946875)

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