2018_Central_Park_Squirrel_Census_-_Squirrel_Data

171 rows where Date = 10142018 and Foraging = 1 sorted by Running

✎ View and edit SQL

This data as json, CSV (advanced)

Moans ✖

  • 0 71

Foraging ✖

Date ✖

  • 10142018 · 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
1936 1936 -73.9667911565238 40.779321901098 18F-AM-1014-02 18F AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE In small tree by water 0 0 0 1 1   0 1 0 0 0 0 1 0   POINT (-73.9667911565238 40.77932190109801)
1964 1964 -73.9622859117854 40.788616918696604 29D-AM-1014-06 29D AM 10142018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9622859117854 40.7886169186966)
1980 1980 -73.9686635017966 40.78431767328279 22B-PM-1014-01 22B PM 10142018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.96866350179661 40.7843176732828)
1992 1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9586085843149 40.7946617684536)
2021 2021 -73.95828003055091 40.798947371297395 40B-PM-1014-03 40B PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9582800305509 40.7989473712974)
2022 2022 -73.9719583492187 40.7763434967164 13D-AM-1014-11 13D AM 10142018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719583492187 40.7763434967164)
2027 2027 -73.964449990389 40.7830023160643 22F-PM-1014-04 22F PM 10142018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964449990389 40.7830023160643)
2039 2039 -73.97083718064292 40.7764813666684 14D-AM-1014-14 14D AM 10142018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708371806429 40.7764813666684)
2055 2055 -73.9806928007664 40.768255422025 1A-PM-1014-03 01A PM 10142018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9806928007664 40.768255422025)
2061 2061 -73.9608834102446 40.790624710005005 31D-AM-1014-05 31D AM 10142018 5 Juvenile Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9608834102446 40.790624710005)
2073 2073 -73.9661108248377 40.7891945123815 28A-AM-1014-01 28A AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9661108248377 40.7891945123815)
2096 2096 -73.97089038621759 40.778737067464206 16C-AM-1014-03 16C AM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708903862176 40.7787370674642)
2105 2105 -73.9738723117119 40.7786845612246 14A-AM-1014-01 14A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 foraging?,crossing road 0 0 0 0 0 0 1 1 runs from (dogs) POINT (-73.9738723117119 40.7786845612246)
2108 2108 -73.9702420100291 40.7772720889907 14D-AM-1014-02 14D AM 10142018 2 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.9702420100291 40.7772720889907)
2119 2119 -73.96415843952991 40.7816571644072 21G-AM-1014-01 21G AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9641584395299 40.7816571644072)
2124 2124 -73.97300395815209 40.7730688398468 9E-PM-1014-03 09E PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE underneath a tree 0 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9730039581521 40.7730688398468)
2149 2149 -73.9691845420174 40.7707749899254 9I-AM-1014-03 09I AM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9691845420174 40.7707749899254)
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9684092812839 40.7711445841928)
2196 2196 -73.96233563694321 40.7888693815168 29D-AM-1014-05 29D AM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Rocky area 0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9623356369432 40.7888693815168)
2207 2207 -73.9748943397482 40.770399256427204 6E-AM-1014-01 06E AM 10142018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9748943397482 40.7703992564272)
2216 2216 -73.97351950184459 40.778714727971504 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9735195018446 40.7787147279715)
2234 2234 -73.9734741818047 40.766328451425 3H-PM-1014-03 03H PM 10142018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9734741818047 40.766328451425)
2281 2281 -73.96915208260279 40.77171040377829 10H-AM-1014-06 10H AM 10142018 6   Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691520826028 40.7717104037783)
2286 2286 -73.95544156650821 40.798420141601795 41D-AM-1014-03 41D AM 10142018 3 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9554415665082 40.7984201416018)
2288 2288 -73.9577009571427 40.796126044520996 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   0 0 1 1 1 climbing (down from ~10') 0 0 0 0 0 0 0 1   POINT (-73.9577009571427 40.796126044521)
2312 2312 -73.97658670292259 40.7674304266107 2E-PM-1014-01 02E PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9765867029226 40.7674304266107)
2332 2332 -73.9709797467807 40.776909571067904 14D-AM-1014-07 14D AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9709797467807 40.7769095710679)
2398 2398 -73.95871384837301 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.958713848373 40.7963918051751)
2439 2439 -73.95874591363909 40.7982497351812 40B-PM-1014-05 40B PM 10142018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9587459136391 40.7982497351812)
2464 2464 -73.96913180449691 40.770980197469605 9I-AM-1014-05 09I AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691318044969 40.7709801974696)
2498 2498 -73.9674556940019 40.7875399402461 26A-AM-1014-02 26A AM 10142018 2   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0 could not get close due to fences POINT (-73.9674556940019 40.7875399402461)
2572 2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9719901848577 40.7720525965356)
2645 2645 -73.9584967368893 40.797732034109394 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. 0 0 0 0 0 0 1 0   POINT (-73.9584967368893 40.7977320341094)
2738 2738 -73.9691801791373 40.770927235357206 9I-AM-1014-04 09I AM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9691801791373 40.7709272353572)
2753 2753 -73.96810908249779 40.783827583032796 22B-PM-1014-04 22B PM 10142018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681090824978 40.7838275830328)
2761 2761 -73.96892042580629 40.7712540588951 9I-AM-1014-01 09I AM 10142018 1 Adult Cinnamon Black, White Cinnamon+Black, White Black on body, White Belly, White tail Ground Plane FALSE   0 0 0 0 1 digging deeeep 0 0 0 0 0 0 1 0   POINT (-73.9689204258063 40.7712540588951)
2763 2763 -73.96260656728941 40.788722645116 29D-AM-1014-03 29D AM 10142018 3 Juvenile Gray   Gray+   Above Ground 35 End of tree limb foraging 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9626065672894 40.788722645116)
2773 2773 -73.96259326649559 40.7885379477349 29D-AM-1014-01 29D AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9625932664956 40.7885379477349)
2805 2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711634340673 40.7760553338671)
2832 2832 -73.958607566971 40.7983695505584 40B-PM-1014-04 40B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.958607566971 40.7983695505584)
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)
2846 2846 -73.96615704780291 40.7807271518813 20E-AM-1014-02 20E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9661570478029 40.7807271518813)
2857 2857 -73.9649230271173 40.7821766215675 22F-PM-1014-02 22F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9649230271173 40.7821766215675)
2887 2887 -73.964593167562 40.7780374890066 18H-PM-1014-02 18H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.964593167562 40.7780374890066)
2892 2892 -73.9688070760806 40.777968829417205 16E-AM-1014-06 16E AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688070760806 40.777968829417205)
2901 2901 -73.9735833104203 40.7786318041581 14A-PM-1014-08 14A PM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 new movement flailing arms while foraging 0 0 0 0 0 0 0 1   POINT (-73.9735833104203 40.7786318041581)
2922 2922 -73.97034213914421 40.7773706575356 14D-AM-1014-01 14D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9703421391442 40.7773706575356)
2931 2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9730926233232 40.7781330751738)
2953 2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 eating (in a tree cage thing) 0 0 0 0 0 0 1 0   POINT (-73.9585862117341 40.7986549251083)
2955 2955 -73.97116665233759 40.776151305703394 13D-AM-1014-02 13D AM 10142018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9711666523376 40.7761513057034)
2959 2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 0 avoided people POINT (-73.9747963162162 40.7745023355775)
2967 2967 -73.97132575863719 40.776271961946705 13D-AM-1014-09 13D AM 10142018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9713257586372 40.7762719619467)
3010 3010 -73.9580906814132 40.7948404060484 37D-PM-1014-01 37D PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1 eyes from a safe distance POINT (-73.9580906814132 40.7948404060484)
184 184 -73.9553811810434 40.7970895007931 40E-AM-1014-02 40E AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9553811810434 40.7970895007931)
413 413 -73.96989341826121 40.7708211633861 8H-PM-1014-03 08H PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9698934182612 40.7708211633861)
487 487 -73.9666521094255 40.7842753517648 23C-PM-1014-02 23C PM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE in bushes, then ran across path 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9666521094255 40.7842753517648)
862 862 -73.9626120417397 40.790512635862605 30C-AM-1014-02 30C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE on a rock 1 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9626120417397 40.7905126358626)
1021 1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running (from a dog) 0 0 0 0 0 0 1 0   POINT (-73.97186968288 40.778926988884)
1163 1163 -73.9677096985223 40.7825358361204 21C-AM-1014-02 21C AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 50   1 1 1 0 1   0 1 0 0 0 0 0 0 looked at us from tree POINT (-73.9677096985223 40.7825358361204)
1298 1298 -73.9612900553755 40.791291739186704 32C-AM-1014-01 32C AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9612900553755 40.7912917391867)
1394 1394 -73.95488263914001 40.7959474571251 39F-AM-1014-05 39F AM 10142018 5 Juvenile Cinnamon   Cinnamon+   Above Ground 2 up/down tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.95488263914 40.7959474571251)
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)
2276 2276 -73.9611985783336 40.791604823372005 32C-AM-1014-06 32C AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9611985783336 40.791604823372)
2316 2316 -73.957697363244 40.7997576909042 42A-PM-1014-01 42A PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 up on hind legs looking around 0 0 0 0 0 0 0 0 came to about 10' away then ran off POINT (-73.957697363244 40.7997576909042)
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)
2641 2641 -73.96155167034941 40.790521938835894 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground 1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9615516703494 40.7905219388359)
2655 2655 -73.9659156108069 40.781070981869604 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 0 0   POINT (-73.9659156108069 40.7810709818696)
2707 2707 -73.97431653210991 40.775467467857396 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   1 0 0 1 1   0 0 0 0 0 0 0 0   POINT (-73.9743165321099 40.7754674678574)
2710 2710 -73.9577919365342 40.796085328505896 38C-PM-1014-08 38C PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   1 0 0 0 0 0 0 1   POINT (-73.9577919365342 40.7960853285059)
2758 2758 -73.95420748142959 40.79543222400039 39F-AM-1014-01 39F AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9542074814296 40.7954322240004)
2849 2849 -73.9709912560997 40.77589655951979 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.9709912560997 40.7758965595198)

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