2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Date = 10132018, Hectare Squirrel Number = 4 and Highlight Fur Color = "White" sorted by Chasing

View and edit SQL

Suggested facets: Shift, Age, Primary Fur Color, Combination of Primary and Highlight Color, Running, Foraging, Tail twitches, Indifferent, Runs from

Highlight Fur Color

  • White · 12

Hectare Squirrel Number

Date

  • 10132018 · 12
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
29 -73.96717867152559 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9671786715256 40.7867352791232)
173 -73.95877018015099 40.793412394152796 35D-PM-1013-04 35D PM 10132018 4 Juvenile Gray White Gray+White         0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.958770180151 40.7934123941528)
375 -73.9752000129992 40.773291812223896 8C-PM-1013-04 08C PM 10132018 4 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9752000129992 40.7732918122239)
1083 -73.9788117755401 40.7707347137469 5B-PM-1013-04 05B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.97881177554011 40.7707347137469)
1146 -73.97943670962741 40.7672720598482 1C-PM-1013-04 01C PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9794367096274 40.7672720598482)
1405 -73.9589371550945 40.7959812504467 37C-PM-1013-04 37C PM 10132018 4 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9589371550945 40.7959812504467)
1585 -73.96113123553481 40.79501308639129 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND 0 0 0 0 0 sitting 0 0 0 0 1 0 1 0   POINT (-73.9611312355348 40.7950130863913)
1961 -73.953664715831 40.7981256393159 41E-PM-1013-04 41E PM 10132018 4 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.953664715831 40.7981256393159)
2014 -73.97864748095141 40.7679715341109 2C-PM-1013-04 02C PM 10132018 4 Adult Gray White Gray+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9786474809514 40.7679715341109)
2349 -73.98003374000399 40.768360829233295 2B-PM-1013-04 02B PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.980033740004 40.7683608292333)
2353 -73.963623175585 40.7927451068919 32A-PM-1013-04 32A PM 10132018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.963623175585 40.7927451068919)
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)

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