2018_Central_Park_Squirrel_Census_-_Squirrel_Data

218 rows where Date = 10122018 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 17
  • 1 1

Date ✖

  • 10122018 · 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
340 340 -73.97449608298442 40.7652585501959 1H-AM-1012-01 01H AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 1 first approaches then runs from - he was less than 1 yd. away from me. POINT (-73.9744960829844 40.7652585501959)
328 328 -73.96523572796708 40.781929688714705 21E-PM-1012-02 21E PM 10122018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9652357279671 40.7819296887147)
325 325 -73.96309908232429 40.788576428401605 28D-AM-1012-02 28D AM 10122018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9630990823243 40.7885764284016)
324 324 -73.9587879699956 40.7908135158551 32F-AM-1012-01 32F AM 10122018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1 made a back-door escape from dog off-leash 0 0 0 0 0 0 0 1   POINT (-73.9587879699956 40.7908135158551)
285 285 -73.9691433356733 40.7731708333242 11G-AM-1012-01 11G AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691433356733 40.77317083332421)
270 270 -73.9767191629692 40.7730786298701 8B-PM-1012-03 08B PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9767191629692 40.7730786298701)
267 267 -73.97547422950909 40.769699832724704 5E-PM-1012-02 05E PM 10122018 2 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.9754742295091 40.7696998327247)
255 255 -73.9800669115792 40.767682513438395 1B-AM-1012-07 01B AM 10122018 7 Adult Cinnamon   Cinnamon+   Above Ground 2 on tree trunk 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9800669115792 40.7676825134384)
246 246 -73.9779805668091 40.768093156679704 2D-PM-1012-02 02D PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9779805668091 40.7680931566797)
229 229 -73.97241624297101 40.7714260236636 8F-PM-1012-04 08F PM 10122018 4 Adult Gray   Gray+   Above Ground 6   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.972416242971 40.7714260236636)
221 221 -73.9665709146738 40.7839384318554 22D-PM-1012-04 22D PM 10122018 4 Adult Gray Black, White Gray+Black, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9665709146738 40.7839384318554)
205 205 -73.9564724104048 40.7936055508162 36F-PM-1012-04 36F PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9564724104048 40.7936055508162)
179 179 -73.9646901432328 40.775995869679 15I-PM-1012-03 15I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9646901432328 40.775995869679)
165 165 -73.969058856545 40.776635622697896 14F-PM-1012-06 14F PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.969058856545 40.7766356226979)
142 142 -73.9724063986771 40.7705711897977 7F-PM-1012-01 07F PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9724063986771 40.7705711897977)
125 125 -73.9651601541795 40.7761841788025 15I-PM-1012-07 15I PM 10122018 7 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651601541795 40.7761841788025)
87 87 -73.95414534658171 40.798216222376396 42E-PM-1012-06 42E PM 10122018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9541453465817 40.79821622237641)
60 60 -73.9768674812942 40.7735232648872 8B-PM-1012-02 08B PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE hiding in bushes 0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9768674812942 40.7735232648872)

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