2018_Central_Park_Squirrel_Census_-_Squirrel_Data

136 rows where Date = 10082018 and Foraging = 1 sorted by latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 30
  • 1 6

Climbing ✖

  • 0 28
  • 1 8

Foraging ✖

Date ✖

  • 10082018 · 36 ✖
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
749 749 -73.96863045815259 40.7773631337117 15E-PM-1008-01 15E PM 10082018 1 Adult Gray   Gray+   Above Ground 4 on fallen tree 1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9686304581526 40.7773631337117)
1946 1946 -73.9692925815903 40.7774506065008 15E-PM-1008-11 15E PM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9692925815903 40.7774506065008)
2775 2775 -73.96971093983021 40.7776218260789 15E-PM-1008-06 15E PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.9697109398302 40.7776218260789)
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9676539688726 40.7777229934129)
982 982 -73.9676424599715 40.777776610680704 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9676424599715 40.7777766106807)
2415 2415 -73.9683598086625 40.7811150451315 19D-PM-1008-01 19D PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683598086625 40.7811150451315)
2239 2239 -73.9668922014699 40.7823535653774 21D-AM-1008-06 21D AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9668922014699 40.7823535653774)
909 909 -73.9665705456197 40.782355287104394 21D-PM-1008-05 21D PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9665705456197 40.7823552871044)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)
2489 2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 1 0 1 0   POINT (-73.9663168490265 40.7825083721362)
2563 2563 -73.9664536611195 40.7827694131949 21D-AM-1008-03 21D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9664536611195 40.7827694131949)
127 127 -73.96641005044359 40.7828778892276 21D-AM-1008-02 21D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9664100504436 40.7828778892276)
1153 1153 -73.9688523924488 40.7844018035948 22A-AM-1008-02 22A AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688523924488 40.7844018035948)
491 491 -73.9688470831269 40.7844651946415 22A-AM-1008-03 22A AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688470831269 40.7844651946415)
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9694382427984 40.7846350692923)
2015 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)
2690 2690 -73.9572840457971 40.788693337174394 31H-PM-1008-04 31H PM 10082018 4 Adult Gray   Gray+   Above Ground   Also way up 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.95728404579711 40.7886933371744)
342 342 -73.9605966636226 40.788984910863704 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)
2146 2146 -73.95473986848171 40.7896483795302 33I-AM-1008-01 33I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park @ 98th (north) 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9547398684817 40.7896483795302)
1993 1993 -73.9546367558712 40.789840987798 33I-AM-1008-04 33I AM 10082018 4 Adult     +   Above Ground 100   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9546367558712 40.789840987798)
1483 1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   0 0 1 0 1   0 0 0 0 0 0 1 0 nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)
2118 2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2485 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)
1093 1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584106786233 40.7902777556926)
2431 2431 -73.9630054996358 40.790522514702204 30C-PM-1008-01 30C PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9630054996358 40.7905225147022)
1450 1450 -73.9580813119325 40.79055382370421 32F-PM-1008-04 32F PM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9580813119325 40.7905538237042)
672 672 -73.9588708103486 40.790579407884294 32F-PM-1008-05 32F PM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9588708103486 40.7905794078843)
1078 1078 -73.9586591455169 40.790624390130894 32F-PM-1008-06 32F PM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586591455169 40.7906243901309)
28 28 -73.958736593111 40.790852437062604 32F-PM-1008-07 32F PM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958736593111 40.7908524370626)
957 957 -73.9586527721822 40.790883111056104 32F-PM-1008-08 32F PM 10082018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9586527721822 40.7908831110561)
14 14 -73.9582694312289 40.7917367820255 33F-AM-1008-02 33F AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9582694312289 40.7917367820255)
953 953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   1 0 1 0 1   1 1 0 0 0 0 1 0   POINT (-73.9547959269955 40.7925162926273)
1101 1101 -73.95912925497 40.7925530280455 34D-AM-1008-01 34D AM 10082018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 staring at us POINT (-73.95912925497001 40.7925530280455)
821 821 -73.959077668148 40.7926045823346 34D-AM-1008-02 34D AM 10082018 2 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.959077668148 40.7926045823346)
40 40 -73.9535410657077 40.7928711760061 36H-PM-1008-02 36H PM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9535410657077 40.79287117600611)
1432 1432 -73.9632577850183 40.793112839016 33A-AM-1008-01 33A AM 10082018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0 acknowledged POINT (-73.9632577850183 40.793112839016)

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