2018_Central_Park_Squirrel_Census_-_Squirrel_Data

165 rows where Date = 10082018 and Shift = "AM" sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Shift ✖

Quaas ✖

  • 0 65

Date ✖

  • 10082018 · 65 ✖
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
1073 1073 -73.9769742179824 40.772748452182896 7B-AM-1008-07 07B AM 10082018 7 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9769742179824 40.7727484521829)
1094 1094 -73.9773898301093 40.770858156205705 5B-AM-1008-01 05B AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1 running across ball field 5,near home plate 0 0 0 0 0 0 1 0   POINT (-73.9773898301093 40.7708581562057)
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)
1121 1121 -73.9645060433292 40.7768322057794 16I-AM-1008-03 16I AM 10082018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9645060433292 40.7768322057794)
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)
1257 1257 -73.97672475936541 40.772620005419704 7B-AM-1008-15 07B AM 10082018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9767247593654 40.7726200054197)
1266 1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709897849823 40.768627964006)
1274 1274 -73.9745859998733 40.7671634885616 3G-AM-1008-02 03G AM 10082018 2 Adult Gray   Gray+ Big one! Beautiful tail Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9745859998733 40.7671634885616)
1278 1278 -73.9729848996456 40.770714329426106 7F-AM-1008-11 07F AM 10082018 11 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9729848996456 40.7707143294261)
1288 1288 -73.97304542959971 40.77029094543921 7F-AM-1008-05 07F AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE bush 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9730454295997 40.7702909454392)
1290 1290 -73.96681408040659 40.77681001473329 15G-AM-1008-06 15G AM 10082018 6 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9668140804066 40.7768100147333)
1319 1319 -73.9562105506291 40.796699119790894 39D-AM-1008-02 39D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562105506291 40.7966991197909)
1322 1322 -73.97018243765059 40.7763703306736 14E-AM-1008-21 14E AM 10082018 21 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 0 1 0 0 curious,but not expecting food POINT (-73.9701824376506 40.7763703306736)
1364 1364 -73.9726090882487 40.7710199108849 7F-AM-1008-14 07F AM 10082018 14 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9726090882487 40.7710199108849)
1376 1376 -73.97733615807921 40.7729478226715 7B-AM-1008-13 07B AM 10082018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773361580792 40.7729478226715)
1386 1386 -73.9730085729495 40.770893357032705 7F-AM-1008-12 07F AM 10082018 12 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9730085729495 40.7708933570327)
1399 1399 -73.970442878377 40.7763755560359 14E-AM-1008-22 14E AM 10082018 22 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0   POINT (-73.970442878377 40.7763755560359)
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)
1439 1439 -73.9729645190377 40.7723310150843 9E-AM-1008-02 09E AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729645190377 40.7723310150843)
1470 1470 -73.97248065806379 40.771007720613206 7F-AM-1008-15 07F AM 10082018 15 Juvenile Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9724806580638 40.7710077206132)
1521 1521 -73.97239229041192 40.7729164833027 9E-AM-1008-01 09E AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9723922904119 40.7729164833027)
1534 1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695226023739 40.7797527775804)
1563 1563 -73.96762706709958 40.776391443152 15G-AM-1008-04 15G AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9676270670996 40.776391443152)
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)
1602 1602 -73.97288367273491 40.770815850599 7F-AM-1008-10 07F AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9728836727349 40.770815850599)
1638 1638 -73.9770628333002 40.7728567364852 7B-AM-1008-06 07B AM 10082018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9770628333002 40.7728567364852)
1663 1663 -73.96967203626271 40.779185159819704 17D-AM-1008-04 17D AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9696720362627 40.7791851598197)
1664 1664 -73.97291429122029 40.772409114667795 9E-AM-1008-03 09E AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9729142912203 40.7724091146678)
1769 1769 -73.9721086069437 40.7698172190404 6G-AM-1008-06 06G AM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White white at end of tail Ground Plane FALSE grass 0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9721086069437 40.7698172190404)
1834 1834 -73.97390388321558 40.7730354890554 9D-AM-1008-03 09D AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9739038832156 40.7730354890554)
1835 1835 -73.9562068537632 40.796733285323796 39D-AM-1008-01 39D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9562068537632 40.7967332853238)
1883 1883 -73.9568108465086 40.7971727026108 39D-AM-1008-05 39D AM 10082018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.95681084650862 40.7971727026108)
1905 1905 -73.96919687484821 40.776586299619204 14E-AM-1008-14 14E AM 10082018 14 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691968748482 40.7765862996192)
1981 1981 -73.972154069981 40.769012800972206 6G-AM-1008-03 06G AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE grass 0 0 0 1 1   0 0 0 1 0 0 1 0   POINT (-73.972154069981 40.7690128009722)
1990 1990 -73.9774584305147 40.770813398619204 5B-AM-1008-02 05B AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9774584305147 40.7708133986192)
2006 2006 -73.9695641121727 40.7769562886685 14E-AM-1008-03 14E AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 walking 0 0 0 0 0 0 1 0 unaware of POINT (-73.9695641121727 40.7769562886685)
2058 2058 -73.9669017345324 40.776692898707296 15G-AM-1008-01 15G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9669017345324 40.7766928987073)
2091 2091 -73.96761128642859 40.7772792086081 16F-AM-1008-03 16F AM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE road 1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9676112864286 40.7772792086081)
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)
2151 2151 -73.96971787697879 40.77915441024221 17D-AM-1008-03 17D AM 10082018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.96971787697882 40.7791544102422)
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)
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)
2264 2264 -73.97735205827341 40.7708198505781 5B-AM-1008-04 05B AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9773520582734 40.7708198505781)
2268 2268 -73.9590191655172 40.7926139425111 34D-AM-1008-03 34D AM 10082018 3 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9590191655172 40.7926139425111)
2269 2269 -73.9695518341907 40.776214599393704 14E-AM-1008-15 14E AM 10082018 15 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1 walking 0 0 0 0 0 0 1 0   POINT (-73.9695518341907 40.7762145993937)
2271 2271 -73.96739494580959 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9673949458096 40.78262185394961)
2318 2318 -73.967458693983 40.7769922522105 15G-AM-1008-02 15G AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.967458693983 40.7769922522105)
2340 2340 -73.9730284815849 40.7702462529502 7F-AM-1008-04 07F AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE bush 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9730284815849 40.7702462529502)
2355 2355 -73.9728654439465 40.7724853142211 9E-AM-1008-04 09E AM 10082018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9728654439465 40.7724853142211)
2395 2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)
2429 2429 -73.97266996869429 40.770112379122295 7F-AM-1008-01 07F AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE under bench 0 0 0 0 1   0 0 0 1 0 0 1 0   POINT (-73.9726699686943 40.7701123791223)
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)
2619 2619 -73.9739737592602 40.772713047677705 9D-AM-1008-04 09D AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9739737592602 40.7727130476777)
2630 2630 -73.965019827314 40.775986429132296 15I-AM-1008-03 15I AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.965019827314 40.7759864291323)
2665 2665 -73.969784066769 40.77669404054029 14E-AM-1008-11 14E AM 10082018 11 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1 burying 0 0 0 0 0 0 1 0 curious POINT (-73.969784066769 40.7766940405403)
2713 2713 -73.9687214684206 40.779284172016396 17D-AM-1008-07 17D AM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687214684206 40.7792841720164)
2749 2749 -73.972967003211 40.7711848438157 7F-AM-1008-17 07F AM 10082018 17 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 scratching self 0 0 0 0 0 0 0 1   POINT (-73.972967003211 40.7711848438157)
2793 2793 -73.9742847552668 40.7731740123046 9D-AM-1008-02 09D AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9742847552668 40.7731740123046)
2850 2850 -73.9744847446854 40.76924227444 5E-AM-1008-04 05E AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9744847446854 40.76924227444)
2871 2871 -73.9777124331985 40.7704051056666 5B-AM-1008-03 05B AM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9777124331985 40.7704051056666)
2886 2886 -73.9729265300533 40.774176829164205 10D-AM-1008-02 10D AM 10082018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9729265300533 40.7741768291642)
2921 2921 -73.9699573485164 40.7765857838015 14E-AM-1008-10 14E AM 10082018 10 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9699573485164 40.7765857838015)
2925 2925 -73.96721526968341 40.782387458182896 21D-AM-1008-05 21D AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9672152696834 40.7823874581829)
2984 2984 -73.9700158929437 40.7762359066591 14E-AM-1008-18 14E AM 10082018 18 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9700158929437 40.7762359066591)

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