2018_Central_Park_Squirrel_Census_-_Squirrel_Data

42 rows where Climbing = 1, Eating = 0, Foraging = 1 and Shift = "PM" sorted by Kuks

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Tail twitches ✖

  • 0 36
  • 1 6

Moans ✖

  • 0 41
  • 1 1

Shift ✖

Foraging ✖

Eating ✖

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
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush 0 0 1 0 1   0 0 0 0 0 0 0 1 watching me POINT (-73.9694168118643 40.7728877377977)
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1 runs from the dog POINT (-73.9681917366128 40.7723298813768)
601 601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
625 625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.97642353733221 40.770606513989)
833 833 -73.9741846413977 40.7762518164182 12B-PM-1018-01 12B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE Climbing up rocks 0 0 1 0 1 climbing (up rocks) 0 0 0 0 0 0 0 1   POINT (-73.9741846413977 40.7762518164182)
889 889 -73.96810426129379 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681042612938 40.772331431865)
908 908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
931 931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
1315 1315 -73.9595955824812 40.793304794353396 34D-PM-1007-01 34D PM 10072018 1 Adult Gray White Gray+White   Above Ground 25   0 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9595955824812 40.7933047943534)
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9680522379372 40.772389813511)
1331 1331 -73.9588809150045 40.7847231576181 26I-PM-1010-01 26I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9588809150045 40.7847231576181)
1487 1487 -73.96539465596099 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1 burying the food on ground 0 0 0 0 0 0 0 0 look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)
1564 1564 -73.9703816112358 40.777384606591895 15D-PM-1017-02 15D PM 10172018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703816112358 40.7773846065919)
1568 1568 -73.96810798698209 40.772349408134495 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681079869821 40.7723494081345)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
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)
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)
1857 1857 -73.9728797531377 40.778673314868705 15B-PM-1017-01 15B PM 10172018 1   Gray   Gray+   Above Ground 20 in tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9728797531377 40.7786733148687)
1904 1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684058476942 40.7753959833776)
1918 1918 -73.9632866142841 40.7890043294436 29C-PM-1006-01 29C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0 not too shy POINT (-73.96328661428412 40.78900432944361)
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647318357023 40.7760936175332)
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)
2079 2079 -73.96430251719141 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9643025171914 40.790570391517)
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods 0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.96747266034902 40.7772125619715)
2145 2145 -73.96512504025829 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree 0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9651250402583 40.7812884929069)
2157 2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)
2210 2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699124811406 40.7743016981538)
2448 2448 -73.9668230576555 40.78706372333271 25B-PM-1007-02 25B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9668230576555 40.7870637233327)
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.978199543688 40.7695660563362)
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)
2702 2702 -73.9588339897601 40.7848084865431 26I-PM-1010-06 26I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 tree 0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9588339897601 40.7848084865431)
2727 2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2818 2818 -73.9681664642028 40.77246696819579 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 0 1 runs away from the ball POINT (-73.9681664642028 40.7724669681958)
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9578840941242 40.7955586232429)
2864 2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9761879300037 40.7683918970301)
2934 2934 -73.9561669236168 40.799473743127706 42C-PM-1013-04 42C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9561669236168 40.7994737431277)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)
3012 3012 -73.96137019608979 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1 got threatened by dog (same dog,dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9613701960898 40.7943363227822)
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)
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)
2069 2069 -73.9538377039825 40.798060533496106 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree 0 0 1 0 1   1 0 0 0 0 0 1 0   POINT (-73.9538377039825 40.7980605334961)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)

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