2018_Central_Park_Squirrel_Census_-_Squirrel_Data

208 rows where Date = 10082018 and Eating = 0 sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 56
  • 1 5

Eating ✖

Date ✖

  • 10082018 · 61 ✖
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
2516 2516 -73.96498236876509 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649823687651 40.7763395359636)
2528 2528 -73.96765297807241 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9676529780724 40.7823206990549)
2552 2552 -73.97249477106979 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch 0 0 1 0 0 sitting 0 0 0 0 0 0 1 0   POINT (-73.9724947710698 40.7696619340886)
2557 2557 -73.97124542516791 40.7674262749891 5I-PM-1008-02 05I PM 10082018 2 Adult Black   Black+   Ground Plane FALSE crossing pavement in front of arsenal 1 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9712454251679 40.7674262749891)
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)
2584 2584 -73.9727187453699 40.7669595710626 3H-AM-1008-02 03H AM 10082018 2 Adult Gray   Gray+   Above Ground     0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727187453699 40.7669595710626)
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)
2675 2675 -73.9762227323096 40.768453603768 3E-PM-1008-02 03E PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9762227323096 40.768453603768)
2680 2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 0 0 0 teasing barking dog 0 0 0 0 0 0 1 0 indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)
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)
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)
2722 2722 -73.96922711321359 40.777528508844 15E-PM-1008-04 15E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9692271132136 40.777528508844)
2724 2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)
2786 2786 -73.9683883750097 40.7754344396847 13G-PM-1008-01 13G PM 10082018 1 Juvenile Gray   Gray+   Above Ground 20 willow oak tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683883750097 40.7754344396847)
2787 2787 -73.9765306970303 40.769495687585895 4D-PM-1008-09 04D PM 10082018 9 Adult Cinnamon Gray, White Cinnamon+Gray, White         0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765306970303 40.7694956875859)
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)
2831 2831 -73.9753585157592 40.7698398607941 5E-AM-1008-07 05E AM 10082018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 on fence 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9753585157592 40.7698398607941)
2837 2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9772691210241 40.7690960712994)
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)
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)
2917 2917 -73.9770313887741 40.7724869252099 7B-AM-1008-05 07B AM 10082018 5 Adult Gray   Gray+   Above Ground     0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9770313887741 40.772486925209904)
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9672063784809 40.7826070395665)
2952 2952 -73.9763719445827 40.768955141333706 4D-PM-1008-04 04D PM 10082018 4 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9763719445827 40.7689551413337)
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)
3009 3009 -73.9675637870968 40.782388067172796 21D-PM-1008-02 21D PM 10082018 2   Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9675637870968 40.7823880671728)
84 84 -73.9701824825872 40.776653057929295 14E-AM-1008-09 14E AM 10082018 9 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 0 1   POINT (-73.9701824825872 40.7766530579293)
95 95 -73.9692883970928 40.776855370308205 14E-AM-1008-02 14E AM 10082018 2 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 1 walking 0 0 0 0 0 0 0 1   POINT (-73.9692883970928 40.7768553703082)
98 98 -73.9730277911422 40.771214548882796 7F-AM-1008-16 07F AM 10082018 16 Juvenile Gray   Gray+   Above Ground 2 tree 0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9730277911422 40.7712145488828)
150 150 -73.97634308293419 40.7686351097159 4D-PM-1008-11 04D PM 10082018 11 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3 on tree facing downward 0 1 0 0 0 chased #12 1 0 0 1 0 0 0 1   POINT (-73.9763430829342 40.7686351097159)
219 219 -73.9761209945419 40.768240452890296 3E-PM-1008-03 03E PM 10082018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9761209945419 40.7682404528903)
235 235 -73.97535742799359 40.768321169425704 4E-PM-1008-08 04E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9753574279936 40.7683211694257)
250 250 -73.97267476660019 40.77030226693079 7F-AM-1008-02 07F AM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1 see stories and locations POINT (-73.9726747666002 40.7703022669308)
342 342 -73.9605966636226 40.788984910863704 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)
464 464 -73.96644503991209 40.788784490469496 27A-AM-1008-02 27A 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.9664450399121 40.7887844904695)
491 491 -73.9688470831269 40.7844651946415 22A-AM-1008-03 22A AM 10082018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9688470831269 40.7844651946415)
507 507 -73.9744835563086 40.7729521433235 9D-AM-1008-01 09D AM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 1 0 0 0 1   POINT (-73.9744835563086 40.7729521433235)
696 696 -73.96560981941491 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9656098194149 40.7757643078973)
732 732 -73.9695041366722 40.779787880948206 17D-AM-1008-02 17D AM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695041366722 40.7797878809482)
890 890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree 0 1 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9667755678511 40.7760256836088)
906 906 -73.9664120826015 40.7888022709721 27A-AM-1008-01 27A AM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 1 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.96641208260151 40.7888022709721)
929 929 -73.97386112577159 40.773724677958704 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 1 0 0 1   POINT (-73.9738611257716 40.7737246779587)
1030 1030 -73.9697526733133 40.7759529849808 13E-PM-1008-09 13E PM 10082018 9 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9697526733133 40.7759529849808)
1040 1040 -73.9702588981432 40.776610754288 14E-AM-1008-08 14E AM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9702588981432 40.776610754288)
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
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)
1162 1162 -73.95685442708809 40.7972517274475 39D-AM-1008-06 39D AM 10082018 6 Adult Gray   Gray+   Above Ground 3 on rock 0 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9568544270881 40.7972517274475)
1247 1247 -73.96709048698709 40.7832091658006 21D-PM-1008-06 21D PM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9670904869871 40.7832091658006)
1287 1287 -73.9763236949008 40.7686815615335 4D-PM-1008-12 04D PM 10082018 12 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   1 0 0 0 0 was chased by # 11 1 0 0 0 0 0 0 1   POINT (-73.9763236949008 40.7686815615335)
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)
1592 1592 -73.9575517912392 40.788915826819206 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575517912392 40.7889158268192)
1733 1733 -73.9756345867747 40.7675540517649 3E-PM-1008-09 03E PM 10082018 9 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9756345867747 40.7675540517649)
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)
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)
2347 2347 -73.9663124560664 40.779544003786 18F-PM-1008-02 18F PM 10082018 2 Adult Gray   Gray+         0 0 0 0 0 hopping around 0 0 0 0 0 0 0 1   POINT (-73.9663124560664 40.779544003786)
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)
2734 2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9763629541474 40.7682321897044)
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)
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)

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