2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Above Ground Sighter Measurement = 15, Hectare Squirrel Number = 3 and Shift = "PM" sorted by Highlight Fur Color

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Tail twitches, Indifferent, Runs from

Shift

Hectare Squirrel Number

Above Ground Sighter Measurement

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
381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   1 0 0 1 0   0 0 0 0 1 0 0 1 ran up tree POINT (-73.959709414696 40.7919745085986)
1018 -73.96953055553921 40.7757541971012 13F-PM-1008-03 13F PM 10082018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305555392 40.7757541971012)
2282 -73.9722056538718 40.7805111762703 17A-PM-1013-03 17A PM 10132018 3 Adult Gray   Gray+   Above Ground 15 tree 0 0 0 0 0 grooming! & scratching 0 0 0 0 0 0 1 0   POINT (-73.9722056538718 40.7805111762703)
2660 -73.97260564119709 40.77934679047429 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9726056411971 40.7793467904743)
1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree 0 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.9594391759139 40.784115697669)
591 -73.95433237868879 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 0 1 0 lying on belly on branch,eating big nut 0 0 0 0 0 0 0 0   POINT (-73.9543323786888 40.7943086530436)
1522 -73.95389705545321 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9538970554532 40.7955196793479)
2912 -73.9632164738341 40.7921270121312 32B-PM-1010-03 32B PM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9632164738341 40.7921270121312)
331 -73.95448101115 40.7954469678857 39F-PM-1006-03 39F PM 10062018 3 Adult Gray White Gray+White   Above Ground 15 lower branch of tree 0 0 0 1 0   0 0 0 0 0 0 0 1 ran up tree when approached POINT (-73.95448101115 40.7954469678857)
2412 -73.98094464895641 40.768503216587895 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9809446489564 40.7685032165879)
2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)

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