2018_Central_Park_Squirrel_Census_-_Squirrel_Data

18 rows where Date = 10072018, Hectare Squirrel Number = 3 and Location = "Above Ground" sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number ✖

Date ✖

  • 10072018 · 18 ✖
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 ▼
591 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)
1301 1301 -73.95521466657141 40.7892909102377 32I-PM-1007-03 32I PM 10072018 3 Adult Gray   Gray+ small adult Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9552146665714 40.7892909102377)
561 561 -73.95819824864691 40.7992194575293 41A-PM-1007-03 41A PM 10072018 3 Adult Gray White Gray+White   Above Ground 55   1 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.95819824864691 40.7992194575293)
1425 1425 -73.95862528758559 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586252875856 40.7852027586217)
2388 2388 -73.9604476047877 40.7938014328732 35C-AM-1007-03 35C AM 10072018 3 Adult     +   Above Ground 40   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9604476047877 40.7938014328732)
347 347 -73.96116961447841 40.7816692895155 22I-AM-1007-03 22I AM 10072018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611696144784 40.7816692895155)
1851 1851 -73.9623621412501 40.7814673556041 22H-PM-1007-03 22H PM 10072018 3 Adult Gray White Gray+White   Above Ground 4 chased squirrel #2 away 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9623621412501 40.7814673556041)
1680 1680 -73.9638167248251 40.7776485679354 18I-PM-1007-03 18I PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 25   0 0 1 0 0   0 0 0 0 0 0 0 0 stared at me POINT (-73.9638167248251 40.77764856793541)
480 480 -73.9641293283734 40.7907654006019 30B-AM-1007-03 30B AM 10072018 3 Adult Gray   Gray+   Above Ground 30   1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9641293283734 40.7907654006019)
2034 2034 -73.96991351872971 40.7782354186163 16D-AM-1007-03 16D AM 10072018 3 Adult     + ran away before I could take a good look Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699135187297 40.7782354186163)
1126 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)
1701 1701 -73.9701634768603 40.777869143321794 15D-AM-1007-03 15D AM 10072018 3 Adult Gray   Gray+   Above Ground 10   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9701634768603 40.7778691433218)
2603 2603 -73.97087815045279 40.7724138070355 10F-AM-1007-03 10F AM 10072018 3 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9708781504528 40.7724138070355)
2228 2228 -73.9714045891597 40.771541833397606 9G-AM-1007-03 09G AM 10072018 3 Adult Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.97140458915972 40.7715418333976)
394 394 -73.9719888241794 40.7667681685356 4I-PM-1007-03 04I PM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3 ran to tree 0 0 0 0 0 being chased 0 0 0 0 0 0 0 0   POINT (-73.9719888241794 40.7667681685356)
1796 1796 -73.9765355395622 40.7735653237366 8B-AM-1007-03 08B AM 10072018 3 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97653553956222 40.7735653237366)
1328 1328 -73.9765758043111 40.771380315403206 6C-AM-1007-03 06C AM 10072018 3 Adult Gray White Gray+White   Above Ground 8 another tree 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9765758043111 40.7713803154032)
226 226 -73.97756817314591 40.7676421190309 2D-AM-1007-03 02D AM 10072018 3 Adult Gray   Gray+   Above Ground 100   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9775681731459 40.7676421190309)

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