2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Climbing = 1 and Hectare = "08I" sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Specific Location, Eating, Foraging, Indifferent, Runs from

Highlight Fur Color

Tail twitches

  • 0 5

Hectare

Climbing

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
1745 -73.9688438058715 40.7703014325728 8I-AM-1006-05 08I AM 10062018 5 Adult Gray White Gray+White   Above Ground 20 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9688438058715 40.7703014325728)
1659 -73.96904988769441 40.7700011818847 8I-AM-1006-07 08I AM 10062018 7 Adult Gray White Gray+White White ring on short tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690498876944 40.7700011818847)
2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.96926766598071 40.7700678919108)
1788 -73.9685567075413 40.7703797723105 8I-AM-1006-10 08I AM 10062018 10 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 bush 0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.96855670754131 40.7703797723105)
700 -73.9691261755936 40.7702929428604 8I-AM-1006-12 08I AM 10062018 12 Adult Gray   Gray+   Above Ground 50 tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691261755936 40.7702929428604)

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