2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Hectare Squirrel Number = 9, Primary Fur Color = "Cinnamon" and Shift = "PM" sorted by Primary Fur Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail twitches, Approaches, Indifferent

Shift ✖

Primary Fur Color ✖

  • Cinnamon · 10 ✖

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
19 19 -73.9768603630674 40.7702795904962 5C-PM-1010-09 05C PM 10102018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9768603630674 40.7702795904962)
298 298 -73.957342596188 40.7944359654227 37E-PM-1006-09 37E PM 10062018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 0 moseying 0 0 0 0 1 1 0 0   POINT (-73.957342596188 40.7944359654227)
320 320 -73.9684376038582 40.78242750672371 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9684376038582 40.7824275067237)
348 348 -73.9542990150586 40.794091530067796 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542990150586 40.7940915300678)
946 946 -73.96540938440491 40.7806896368469 20F-PM-1007-09 20F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 1 0 0   POINT (-73.9654093844049 40.7806896368469)
1221 1221 -73.9796409671481 40.767904987118605 1C-PM-1013-09 01C PM 10132018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9796409671481 40.7679049871186)
1605 1605 -73.96903623845971 40.7767162824413 14F-PM-1012-09 14F PM 10122018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9690362384597 40.7767162824413)
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9686370726471 40.7780382348833)
2787 2787 -73.9765306970303 40.769495687585895 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765306970303 40.7694956875859)
3003 3003 -73.96986639266571 40.773999710413 12F-PM-1007-09 12F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698663926657 40.773999710413)

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