2018_Central_Park_Squirrel_Census_-_Squirrel_Data

71 rows where Date = 10072018, Foraging = 1, Shift = "PM" and Tail twitches = 0 sorted by Climbing

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Other Activities, Tail flags, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

  • 0 63
  • 1 8

Tail twitches ✖

Shift ✖

Moans ✖

  • 0 71

Foraging ✖

Date ✖

  • 10072018 · 71 ✖
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
18 18 -73.9532170504865 40.7919669739962 36I-PM-1007-01 36I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9532170504865 40.7919669739962)
32 32 -73.9576530157255 40.7868659490397 29I-PM-1007-01 29I PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9576530157255 40.7868659490397)
76 76 -73.9530035564643 40.792182245761296 36I-PM-1007-07 36I PM 10072018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9530035564643 40.7921822457613)
190 190 -73.9695507965155 40.7743070423435 12F-PM-1007-04 12F PM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0 stared POINT (-73.96955079651552 40.7743070423435)
192 192 -73.9651654887991 40.7777806006951 17H-PM-1007-02 17H PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9651654887991 40.7777806006951)
302 302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9695176417703 40.7741725190048)
348 348 -73.9542990150586 40.794091530067796 37G-PM-1007-09 37G PM 10072018 9 Adult Cinnamon White Cinnamon+White         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542990150586 40.7940915300678)
398 398 -73.9686737866872 40.773971402373206 12G-PM-1007-06 12G PM 10072018 6   Gray Cinnamon Gray+Cinnamon         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9686737866872 40.7739714023732)
427 427 -73.9589367709165 40.78964653034829 31F-PM-1007-04 31F PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9589367709165 40.7896465303483)
437 437 -73.9793952066038 40.7707837657859 4A-PM-1007-03 04A PM 10072018 3 Adult Gray White Gray+White   Ground Plane FALSE by rock 0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9793952066038 40.77078376578591)
468 468 -73.9780659679557 40.7672382282781 1D-PM-1007-06 01D PM 10072018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9780659679557 40.7672382282781)
475 475 -73.9697855573137 40.7742186391935 12F-PM-1007-05 12F PM 10072018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9697855573137 40.7742186391935)
604 604 -73.9540908513075 40.794201225045 37G-PM-1007-04 37G PM 10072018 4   Cinnamon Gray Cinnamon+Gray gray tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9540908513075 40.794201225045)
831 831 -73.9587712679442 40.7944502501428 36D-PM-1007-02 36D PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9587712679442 40.7944502501428)
881 881 -73.9737872335563 40.7726586835985 8D-PM-1007-01 08D PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9737872335563 40.77265868359851)
901 901 -73.97022281317109 40.7742131587983 12F-PM-1007-12 12F PM 10072018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 0 0 1 going down tree 0 0 0 0 0 0 1 0   POINT (-73.9702228131711 40.7742131587983)
904 904 -73.9531013359625 40.792122355653504 36I-PM-1007-04 36I PM 10072018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9531013359625 40.7921223556535)
912 912 -73.958024711869 40.7938724278575 36D-PM-1007-01 36D PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.958024711869 40.7938724278575)
934 934 -73.9772053786965 40.766390657333204 1E-PM-1007-02 01E PM 10072018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9772053786965 40.7663906573332)
971 971 -73.978392591149 40.7668993398193 1D-PM-1007-04 01D PM 10072018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.978392591149 40.7668993398193)
976 976 -73.9740381194088 40.7675912588173 4G-PM-1007-01 04G PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9740381194088 40.7675912588173)
1063 1063 -73.97503467782809 40.766540440482395 2G-PM-1007-01 02G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9750346778281 40.7665404404824)
1115 1115 -73.9545214613307 40.7943801121036 37G-PM-1007-01 37G PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9545214613307 40.7943801121036)
1117 1117 -73.9693465383617 40.7744996336934 12F-PM-1007-01 12F PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9693465383617 40.7744996336934)
1311 1311 -73.9694169352433 40.774440829385796 12G-PM-1007-03 12G PM 10072018 3   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE bushes 0 0 0 0 1   0 0 0 0 0 0 0 0 friendly POINT (-73.9694169352433 40.7744408293858)
1326 1326 -73.9747288122551 40.7659918747507 2G-PM-1007-03 02G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9747288122551 40.7659918747507)
1404 1404 -73.9700666654946 40.774285704258105 12F-PM-1007-08 12F PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 stared POINT (-73.9700666654946 40.7742857042581)
1513 1513 -73.96624099976421 40.789104293543204 28A-PM-1007-03 28A PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 1 1 chasing #2 took #2 food wrapper and is foraging through it 0 0 0 0 0 0 1 0   POINT (-73.9662409997642 40.7891042935432)
1544 1544 -73.9642111283068 40.77777139853271 18I-PM-1007-07 18I PM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9642111283068 40.7777713985327)
1577 1577 -73.965390623703 40.7807731363782 20F-PM-1007-08 20F PM 10072018 8 Adult Cinnamon White Cinnamon+White white tail/belly Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.965390623703 40.7807731363782)
1616 1616 -73.9642666013207 40.7810384867375 21G-PM-1007-03 21G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.96426660132072 40.7810384867375)
1619 1619 -73.9744555348544 40.772849810635705 8D-PM-1007-03 08D PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray         0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9744555348544 40.7728498106357)
1647 1647 -73.9795585338537 40.768895893226 3B-PM-1007-08 03B PM 10072018 8 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9795585338537 40.768895893226)
1738 1738 -73.967975586222 40.77356830443129 12H-PM-1007-07 12H PM 10072018 7   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE grass field 0 0 0 0 1   0 0 0 0 0 0 0 1 humans POINT (-73.967975586222 40.7735683044313)
1859 1859 -73.96811468301621 40.77367722794121 12H-PM-1007-06 12H PM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681146830162 40.7736772279412)
1875 1875 -73.9527430510248 40.792480795055205 36I-PM-1007-12 36I PM 10072018 12 Juvenile Gray Cinnamon Gray+Cinnamon Tiny! So tiny! Above Ground 2   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9527430510248 40.7924807950552)
1906 1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700066659086 40.7744028820163)
1910 1910 -73.9699876501742 40.774248267675794 12F-PM-1007-06 12F PM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699876501742 40.77424826767581)
2000 2000 -73.9591070579246 40.789677677115705 31F-PM-1007-05 31F PM 10072018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9591070579246 40.7896776771157)
2075 2075 -73.96362349533341 40.7775138547689 18I-PM-1007-06 18I PM 10072018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1 digging 0 0 0 0 0 0 1 0   POINT (-73.9636234953334 40.7775138547689)
2166 2166 -73.9711178122133 40.7672642958437 4I-PM-1007-01 04I PM 10072018 1 Adult Black   Black+   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9711178122133 40.76726429584371)
2184 2184 -73.9694938608335 40.7745700102115 12F-PM-1007-03 12F PM 10072018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694938608335 40.7745700102115)
2257 2257 -73.95431338448 40.7940537582585 37G-PM-1007-08 37G PM 10072018 8 Adult Gray   Gray+         0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.95431338448 40.7940537582585)
2260 2260 -73.9784685928652 40.7669924015341 1D-PM-1007-05 01D PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9784685928652 40.7669924015341)
2305 2305 -73.9679833225379 40.773854709340206 12H-PM-1007-05 12H PM 10072018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9679833225379 40.7738547093402)
2333 2333 -73.9771924901559 40.766672272947105 1E-PM-1007-01 01E PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0 people feeding squirrel POINT (-73.9771924901559 40.7666722729471)
2417 2417 -73.9720323148189 40.772970345961795 10E-PM-1007-01 10E PM 10072018 1 Adult Gray   Gray+   Above Ground 35   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9720323148189 40.7729703459618)
2518 2518 -73.9647219419257 40.781208440293206 20F-PM-1007-03 20F PM 10072018 3 Adult Gray White Gray+White gray on haunches white on tail Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9647219419257 40.7812084402932)
2537 2537 -73.9735533713513 40.7690605609001 5F-PM-1007-05 05F PM 10072018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9735533713513 40.7690605609001)
2564 2564 -73.970996228532 40.7715540712285 9G-PM-1007-02 09G PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.970996228532 40.7715540712285)
2579 2579 -73.96981304525809 40.7745000645436 12F-PM-1007-15 12F PM 10072018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9698130452581 40.7745000645436)
2686 2686 -73.97755714038921 40.766531658519796 1E-PM-1007-03 01E PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775571403892 40.7665316585198)
2695 2695 -73.962800448652 40.7915532640139 31B-PM-1007-03 31B PM 10072018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962800448652 40.7915532640139)
2704 2704 -73.96577644902841 40.781192322928604 20F-PM-1007-10 20F PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9657764490284 40.7811923229286)
2718 2718 -73.9530587825442 40.7919087309222 36I-PM-1007-03 36I PM 10072018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9530587825442 40.7919087309222)
2737 2737 -73.97036835101758 40.774397536395796 12F-PM-1007-10 12F PM 10072018 10 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9703683510176 40.7743975363958)
2760 2760 -73.9701808122548 40.7744632730919 12F-PM-1007-11 12F PM 10072018 11 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9701808122548 40.7744632730919)
2891 2891 -73.9636482556874 40.7775831570186 18I-PM-1007-05 18I PM 10072018 5 Juvenile Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   0 0 0 0 1 jumping crazily / digging hole 0 0 0 0 0 0 1 0   POINT (-73.9636482556874 40.7775831570186)
2943 2943 -73.962534856258 40.7812134517411 22H-PM-1007-01 22H PM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.962534856258 40.7812134517411)
2995 2995 -73.9668442742942 40.7870781042595 25B-PM-1007-01 25B PM 10072018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9668442742942 40.7870781042595)
3001 3001 -73.97755922284159 40.7668485329273 1D-PM-1007-01 01D PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9775592228416 40.7668485329273)
3003 3003 -73.96986639266571 40.773999710413 12F-PM-1007-09 12F PM 10072018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9698663926657 40.773999710413)
3005 3005 -73.96161411525391 40.7921803313341 33C-PM-1007-04 33C PM 10072018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9616141152539 40.7921803313341)
1067 1067 -73.9695305996721 40.774538689695895 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305996721 40.7745386896959)
1609 1609 -73.96390249881229 40.777695306584896 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639024988123 40.7776953065849)
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)
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)
2187 2187 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)
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)
2222 2222 -73.9639048209454 40.777737334555795 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 0 1 1 1 hanging upside down 0 0 0 0 0 0 1 0   POINT (-73.9639048209454 40.7777373345558)
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)

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