2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Climbing = 1, Date = 10082018 and Hectare Squirrel Number = 3 sorted by Kuks

View and edit SQL

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Indifferent

Hectare Squirrel Number

Date

  • 10082018 · 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
279 -73.9550082056509 40.7894521543449 33I-AM-1008-03 33I AM 10082018 3 Adult Gray   Gray+   Above Ground 2 98th @ edge of park 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9550082056509 40.7894521543449)
665 -73.95636612568751 40.796682311450795 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9563661256875 40.7966823114508)
695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
1116 -73.9729847109778 40.774070904960205 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9729847109778 40.7740709049602)
1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.973047824163 40.7700873791211)
1610 -73.9607056611532 40.788978610387105 30E-AM-1008-03 30E AM 10082018 3 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9607056611532 40.7889786103871)
1715 -73.97457091090558 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   1 0 1 0 0 in tree 0 0 0 0 0 0 1 0   POINT (-73.9745709109056 40.7672225695415)
2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! 0 0 1 0 1 throwing down acorns 0 0 0 0 0 0 0 0   POINT (-73.9574365550758 40.7886924675052)
2452 -73.9727323797981 40.766903546395504 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727323797981 40.7669035463955)
2485 -73.9584950620879 40.790277071064295 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584950620879 40.7902770710643)
2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)

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