2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Hectare = "20B" and Highlight Fur Color = "White" sorted by Location

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Location, Running, Chasing, Foraging, Tail flags, Tail twitches, Indifferent, Runs from

Highlight Fur Color

  • White · 11

Hectare

  • 20B · 11
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
1126 -73.97001860010491 40.7826052184658 20B-AM-1007-03 20B AM 10072018 3 Adult Gray White Gray+White   Above Ground     0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9700186001049 40.7826052184658)
17 -73.96950635353329 40.7823507678183 20B-PM-1013-05 20B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9695063535333 40.7823507678183)
69 -73.9689000978955 40.7828364735236 20B-PM-1013-10 20B PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 drank from a pond of rain water 0 0 0 0 0 0 1 0   POINT (-73.9689000978955 40.7828364735236)
902 -73.969105907 40.782047490919204 20B-PM-1013-08 20B PM 10132018 8 Adult Gray White Gray+White (very brown) Ground Plane FALSE   1 0 0 0 0 being chased by dog 0 0 0 0 0 0 0 1   POINT (-73.969105907 40.7820474909192)
2085 -73.9690551477139 40.782368566319604 20B-PM-1013-07 20B PM 10132018 7 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9690551477139 40.7823685663196)
2438 -73.969532160039 40.7822616641357 20B-PM-1013-01 20B PM 10132018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969532160039 40.7822616641357)
2458 -73.969517504176 40.782074134429706 20B-PM-1013-02 20B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.969517504176 40.7820741344297)
2532 -73.9695150319891 40.782613519363 20B-PM-1013-04 20B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 chased a bird carrying massive wad of grass 0 0 0 0 1 0 0 0   POINT (-73.9695150319891 40.782613519363)
2571 -73.9695468150218 40.7821142051746 20B-PM-1013-03 20B PM 10132018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9695468150218 40.7821142051746)
2855 -73.9690832219322 40.782343340985996 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.96908322193221 40.782343340986)
2978 -73.96888170064429 40.7829120321438 20B-PM-1013-09 20B PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9688817006443 40.7829120321438)

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