2018_Central_Park_Squirrel_Census_-_Squirrel_Data

132 rows where Climbing = 1 and Hectare Squirrel Number = 2 sorted by Hectare

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

Climbing ✖

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
147 147 -73.9564023626619 40.7905423546155 33G-AM-1013-02 33G AM 10132018 2 Adult Gray   Gray+   Above Ground 13 shelter in hole in tree 0 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9564023626619 40.7905423546155)
2258 2258 -73.95477850811709 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9547785081171 40.789612183711)
1480 1480 -73.96285255338309 40.793844934501706 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 eating upside down on tree trunk 0 0 0 0 0 0 0 0   POINT (-73.9628525533831 40.7938449345017)
1576 1576 -73.96199851876159 40.79432777435321 34A-AM-1012-02 34A AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9619985187616 40.7943277743532)
2356 2356 -73.9611355303487 40.793069353224 34C-AM-1007-02 34C AM 10072018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611355303487 40.793069353224)
369 369 -73.9596398997228 40.793338695384705 34D-PM-1007-02 34D PM 10072018 2 Adult Black   Black+   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0 cautiously aware POINT (-73.9596398997228 40.7933386953847)
1776 1776 -73.9562350820255 40.7913464147989 34G-PM-1006-02 34G PM 10062018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 1 1 eating bread it found on ground 0 0 0 0 0 0 0 1   POINT (-73.9562350820255 40.7913464147989)
1951 1951 -73.9548431601579 40.7906346271566 34I-PM-1010-02 34I PM 10102018 2 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9548431601579 40.7906346271566)
1949 1949 -73.9605362268777 40.7939470599346 35C-AM-1007-02 35C AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9605362268777 40.7939470599346)
1933 1933 -73.95848243616551 40.7934247634031 35D-PM-1013-02 35D PM 10132018 2 Adult Gray White Gray+White   Above Ground 24   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584824361655 40.7934247634031)
1972 1972 -73.9558370309765 40.7921977208472 35G-AM-1007-02 35G AM 10072018 2 Adult Gray White Gray+White   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9558370309765 40.7921977208472)
1422 1422 -73.9537356145842 40.7917273773486 35I-PM-1006-02 35I PM 10062018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9537356145842 40.7917273773486)
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)
1697 1697 -73.9568610943394 40.7935959584643 36E-PM-1012-02 36E PM 10122018 2 Adult Gray   Gray+   Above Ground 28 on tree branch 0 0 1 0 1 picking acorns off oak tree 0 0 0 0 0 0 1 0   POINT (-73.95686109433942 40.7935959584643)
2194 2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.960898739757 40.7961393097144)
2243 2243 -73.9579967047318 40.7948682042252 37D-PM-1014-02 37D PM 10142018 2 Adult Gray   Gray+   Above Ground 40   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.95799670473181 40.7948682042252)
504 504 -73.95334760207359 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree 1 0 1 0 1   1 0 0 0 0 0 0 1 dogs POINT (-73.9533476020736 40.7933003544685)
1304 1304 -73.9533319519277 40.7933647909449 37H-AM-1018-02 37H AM 10182018 2 Adult Gray   Gray+   Above Ground   Large tree by (fence of the conservatory) about to climb up 0 0 1 0 0   0 0 0 0 0 0 0 0 busy,ready to climb POINT (-73.9533319519277 40.7933647909449)
1613 1613 -73.95992022335359 40.7972599930224 38A-AM-1019-02 38A AM 10192018 2 Adult Gray   Gray+   Above Ground 3   1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9599202233536 40.7972599930224)
680 680 -73.95640114211221 40.7958097849369 38E-AM-1010-02 38E AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0 climbs POINT (-73.95640114211221 40.7958097849369)
156 156 -73.9576589997493 40.7972751877447 39C-PM-1006-02 39C PM 10062018 2 Adult Gray   Gray+   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0 unaware of POINT (-73.95765899974931 40.7972751877447)
2639 2639 -73.9543832609857 40.795355063970106 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks 1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9543832609857 40.7953550639701)
2982 2982 -73.9513477815203 40.7945259614138 39I-PM-1013-02 39I PM 10132018 2 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 1 1 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9513477815203 40.7945259614138)
2968 2968 -73.9587236619579 40.799185018043396 40A-AM-1010-02 40A AM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of park at 108th West 1 0 1 0 0   0 0 0 1 0 0 0 1   POINT (-73.9587236619579 40.7991850180434)
1807 1807 -73.9581366214863 40.7988964092722 40B-PM-1014-02 40B PM 10142018 2 Adult Gray   Gray+   Above Ground 20   0 0 1 0 0   1 1 0 0 0 0 0 1   POINT (-73.9581366214863 40.7988964092722)
1589 1589 -73.9567062023419 40.797482865196 40C-PM-1006-02 40C PM 10062018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9567062023419 40.797482865196)
525 525 -73.952526164386 40.796375924050395 40G-AM-1007-02 40G AM 10072018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 18   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.952526164386 40.7963759240504)
1887 1887 -73.95861842328891 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   0 0 1 0 0 jumping 0 0 0 0 0 0 0 0 stared at me POINT (-73.9586184232889 40.7993153832942)
755 755 -73.9579941847434 40.7991216713328 41B-PM-1014-02 41B PM 10142018 2 Adult Black   Black+   Above Ground 28   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9579941847434 40.7991216713328)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
1064 1064 -73.9540257319561 40.798408619116 42E-PM-1012-02 42E PM 10122018 2 Juvenile Gray Cinnamon Gray+Cinnamon         1 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9540257319561 40.798408619116)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)

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