2018_Central_Park_Squirrel_Census_-_Squirrel_Data

6 rows where Above Ground Sighter Measurement = 5 and Hectare Squirrel Number = 3 sorted by Climbing

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Chasing, Climbing, Eating, Indifferent, Runs from

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
811 -73.9771695272048 40.772427727626294 7B-AM-1008-03 07B AM 10082018 3 Adult Gray   Gray+   Above Ground 5   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9771695272048 40.7724277276263)
1863 -73.96828305109541 40.7810151087286 19D-PM-1008-03 19D PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White may be same squirrel as #1 - male Above Ground 5 on branch of dead tree 0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9682830510954 40.7810151087286)
201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9592537496995 40.7919271821316)
665 -73.95636612568751 40.796682311450795 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9563661256875 40.7966823114508)
2592 -73.9758128509653 40.7715946097064 7C-PM-1020-03 07C PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9758128509653 40.7715946097064)

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