squirrels

65 rows where Climbing = "true" and Date = 10082018

View and edit SQL

Suggested facets: Hectare, Shift, 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, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Date

  • 10082018 · 65

Climbing

  • true · 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 Zip Codes Community Districts Borough Boundaries City Council Districts Police Precincts
43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   true false true false false   false false false false true false true false   POINT (-73.9574648097543 40.78925084286221)   19 4 19 13
112 -73.9651754464439 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree false false true true false   false false false false false false true false   POINT (-73.9651754464439 40.7755181941559)   19 4 19 13
139 -73.969847380865 40.7769884612305 14E-AM-1008-05 14E AM 10082018 5 Adult Gray   Gray+   Above Ground 25   false false true false false nest building false false false false false false true false   POINT (-73.969847380865 40.7769884612305)   19 4 19 13
210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
235 -73.9753574279936 40.7683211694257 4E-PM-1008-08 04E PM 10082018 8 Adult Gray   Gray+   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9753574279936 40.7683211694257)   19 4 19 13
259 -73.9726958070536 40.7706096126328 7F-AM-1008-09 07F AM 10082018 9 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #8 false false false false false false true false   POINT (-73.9726958070536 40.7706096126328)   19 4 19 13
279 -73.9550082056509 40.7894521543449 33I-AM-1008-03 33I AM 10082018 3 Adult Gray   Gray+   Above Ground 2 98th @ edge of park false false true false false   false false false false false false true false   POINT (-73.9550082056509 40.7894521543449)   19 4 19 13
303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false true true true climbed fence staring at me - went up tree false false false false false false false true   POINT (-73.97623482246482 40.7694522315322)   19 4 19 13
336 -73.9757413215621 40.7692582758978 4E-PM-1008-04 04E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   true true true false false   false false false false false false true false   POINT (-73.9757413215621 40.7692582758978)   19 4 19 13
462 -73.9661785940531 40.7742569936186 13I-PM-1008-01 13I PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 climbed tree true false true false false   false false false false false false true false   POINT (-73.9661785940531 40.7742569936186)   19 4 19 13
511 -73.9653142636891 40.7760015129298 15I-AM-1008-04 15I AM 10082018 4 Adult Gray   Gray+   Ground Plane FALSE   false false true true false   false false false false false false false true   POINT (-73.9653142636891 40.7760015129298)   19 4 19 13
647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false true false false false   POINT (-73.9734762649298 40.7663703404546)   19 4 19 13
665 -73.9563661256875 40.7966823114508 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false false   POINT (-73.9563661256875 40.7966823114508)   19 4 19 13
695 -73.9685080639873 40.7745309794155 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree false false true false false   false false false false false false true false   POINT (-73.9685080639873 40.77453097941551)   19 4 19 13
696 -73.9656098194149 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9656098194149 40.7757643078973)   19 4 19 13
773 -73.9566189145352 40.7883417969746 31H-PM-1008-01 31H PM 10082018 1 Adult Gray White Gray+White   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9566189145352 40.7883417969746)   19 4 19 13
792 -73.9730115687964 40.7741018274312 10D-AM-1008-05 10D AM 10082018 5 Juvenile Gray White Gray+White   Above Ground 25   false false true true false   false false false false false false false false   POINT (-73.9730115687964 40.7741018274312)   19 4 19 13
879 -73.9735120882106 40.7715915415169 8E-PM-1008-07 08E PM 10082018 7 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9735120882106 40.7715915415169)   19 4 19 13
890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree false true true false false   false false false false false false false true   POINT (-73.9667755678511 40.7760256836088)   19 4 19 13
953 -73.9547959269955 40.7925162926273 36H-PM-1008-01 36H PM 10082018 1 Adult Gray White Gray+White white belly Above Ground 20   true false true false true   true true false false false false true false   POINT (-73.9547959269955 40.7925162926273)   19 4 19 13
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 true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1093 -73.9584106786233 40.7902777556926 32F-PM-1008-02 32F PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9584106786233 40.7902777556926)   19 4 19 13
1116 -73.9729847109778 40.7740709049602 10D-AM-1008-03 10D AM 10082018 3 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9729847109778 40.7740709049602)   19 4 19 13
1144 -73.9743184653765 40.7667932997 3G-AM-1008-01 03G AM 10082018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9743184653765 40.7667932997)   19 4 19 13
1274 -73.9745859998733 40.7671634885616 3G-AM-1008-02 03G AM 10082018 2 Adult Gray   Gray+ Big one! Beautiful tail Ground Plane FALSE   false false true false false   false false false false false false true false   POINT (-73.9745859998733 40.7671634885616)   19 4 19 13
1280 -73.9562469727195 40.79685907654 39D-AM-1008-04 39D AM 10082018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9562469727195 40.79685907654)   19 4 19 13
1483 -73.9545773579075 40.7898684635744 33I-AM-1008-05 33I AM 10082018 5 Adult     +   Above Ground 100   false false true false true   false false false false false false true false nearly dropped shell on my head! POINT (-73.9545773579075 40.7898684635744)   19 4 19 13
1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true false false   false false false false false false false true   POINT (-73.9695226023739 40.7797527775804)   19 4 19 13
1566 -73.9695133370801 40.7765009796853 14E-AM-1008-16 14E AM 10082018 16 Adult Gray   Gray+   Above Ground 6   false false true true true   false false false false false false true false   POINT (-73.9695133370801 40.7765009796853)   19 4 19 13
1569 -73.973047824163 40.7700873791211 7F-AM-1008-03 07F AM 10082018 3 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.973047824163 40.7700873791211)   19 4 19 13
1592 -73.9575517912392 40.7889158268192 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     false false true false false   false false false false false false false true   POINT (-73.9575517912392 40.7889158268192)   19 4 19 13
1598 -73.9726828460055 40.7705707694822 7F-AM-1008-08 07F AM 10082018 8 Adult Gray   Gray+   Above Ground 20   false false true false false playing w/ #9 false false false false false false true false   POINT (-73.9726828460055 40.7705707694822)   19 4 19 13
1610 -73.9607056611532 40.7889786103871 30E-AM-1008-03 30E AM 10082018 3 Adult Gray   Gray+   Above Ground 6   false false true false false   false false false false false false true false   POINT (-73.9607056611532 40.7889786103871)   19 4 19 13
1644 -73.9734654671008 40.7715988711659 8E-PM-1008-06 08E PM 10082018 6 Adult Gray White Gray+White   Ground Plane FALSE 5, 6, 7 all at same tree trunk base false true true false false   false false false false false false false false   POINT (-73.9734654671008 40.7715988711659)   19 4 19 13
1696 -73.9694591667705 40.7766518221998 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   false false true true true   false false false false false false true false   POINT (-73.9694591667705 40.7766518221998)   19 4 19 13
1715 -73.9745709109056 40.7672225695415 3G-AM-1008-03 03G AM 10082018 3 Adult Gray   Gray+   Above Ground 40   true false true false false in tree false false false false false false true false   POINT (-73.9745709109056 40.7672225695415)   19 4 19 13
1723 -73.9747959143543 40.7768078174366 12A-AM-1008-01 12A AM 10082018 1 Adult Gray   Gray+   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9747959143543 40.7768078174366)   19 4 19 13
1733 -73.9756345867747 40.7675540517649 3E-PM-1008-09 03E PM 10082018 9 Adult Gray   Gray+   Above Ground 5   true false true false false   false false false false false false false true   POINT (-73.9756345867747 40.7675540517649)   19 4 19 13
1741 -73.9736995552241 40.7722712518637 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree true false true false false   false false false false false false false false   POINT (-73.9736995552241 40.7722712518637)   19 4 19 13
1790 -73.9730592548116 40.7740879251541 10D-AM-1008-04 10D AM 10082018 4 Juvenile Gray   Gray+   Above Ground 25   false true true false false   false false false false false false false false   POINT (-73.9730592548116 40.7740879251541)   19 4 19 13
1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree false false true false true   false false false false false false true false   POINT (-73.9684058476942 40.7753959833776)   19 4 19 13
1940 -73.9696445614055 40.7791486203627 17D-AM-1008-05 17D AM 10082018 5 Juvenile Gray   Gray+   Above Ground 2   false false true false false   false false false false false false true false   POINT (-73.9696445614055 40.7791486203627)   19 4 19 13
1984 -73.9739249209875 40.7768528386853 13B-PM-1008-02 13B PM 10082018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false false false true false   POINT (-73.9739249209875 40.7768528386853)   19 4 19 13
1993 -73.9546367558712 40.789840987798 33I-AM-1008-04 33I AM 10082018 4 Adult     +   Above Ground 100   false false true false true   false false false false false false true false   POINT (-73.9546367558712 40.789840987798)   19 4 19 13
2005 -73.9755259087781 40.7707256124181 6D-AM-1008-01 06D AM 10082018 1 Adult Cinnamon White Cinnamon+White   Above Ground 10   false false true true false   true false false false false true false false   POINT (-73.9755259087781 40.7707256124181)   19 4 19 13
2015 -73.9574365550758 40.7886924675052 31H-PM-1008-03 31H PM 10082018 3 Adult Gray   Gray+   Above Ground   no clue, way up a tree! false false true false true throwing down acorns false false false false false false false false   POINT (-73.9574365550758 40.7886924675052)   19 4 19 13
2017 -73.9775067398903 40.7726566142401 7B-AM-1008-14 07B AM 10082018 14 Adult Gray   Gray+   Above Ground   on fence false false true false false   false false false false false false true false   POINT (-73.9775067398903 40.7726566142401)   19 4 19 13
2095 -73.9747762992858 40.7768579078578 12A-AM-1008-02 12A AM 10082018 2 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.9747762992858 40.7768579078578)   19 4 19 13
2118 -73.958369699409 40.7902456668332 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.958369699409 40.7902456668332)   19 4 19 13
2122 -73.9692946938852 40.7767389791452 14E-AM-1008-13 14E AM 10082018 13 Adult Gray   Gray+   Above Ground 1   false false true true true   false false false false false false true false curious POINT (-73.9692946938852 40.7767389791452)   19 4 19 13
2258 -73.9547785081171 40.789612183711 33I-AM-1008-02 33I AM 10082018 2 Adult Gray   Gray+   Above Ground 3 edge of park @ 98th false false true false false   false false false false true false true false   POINT (-73.9547785081171 40.789612183711)   19 4 19 13
2450 -73.9756273257684 40.7706539186221 6D-AM-1008-04 06D AM 10082018 4 Adult Gray   Gray+   Above Ground     false false true false false   false false false false false false false false   POINT (-73.9756273257684 40.7706539186221)   19 4 19 13
2452 -73.9727323797981 40.7669035463955 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest false false true false false   false false false false false false true false   POINT (-73.9727323797981 40.7669035463955)   19 4 19 13
2485 -73.9584950620879 40.7902770710643 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true true true true true   false false false false false false true false   POINT (-73.9584950620879 40.7902770710643)   19 4 19 13
2516 -73.9649823687651 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true false false   false false false false false false true false   POINT (-73.9649823687651 40.7763395359636)   19 4 19 13
2528 -73.9676529780724 40.7823206990549 21D-PM-1008-03 21D PM 10082018 3 Adult Gray White Gray+White   Above Ground 4   false false true false false   false false false false false false false false   POINT (-73.9676529780724 40.7823206990549)   19 4 19 13
2552 -73.9724947710698 40.7696619340886 6G-AM-1008-05 06G AM 10082018 5 Adult Gray   Gray+   Above Ground 30 branch false false true false false sitting false false false false false false true false   POINT (-73.9724947710698 40.7696619340886)   19 4 19 13
2584 -73.9727187453699 40.7669595710626 3H-AM-1008-02 03H AM 10082018 2 Adult Gray   Gray+   Above Ground     false false true false false   false false false false false false true false   POINT (-73.9727187453699 40.7669595710626)   19 4 19 13
2690 -73.9572840457971 40.7886933371744 31H-PM-1008-04 31H PM 10082018 4 Adult Gray   Gray+   Above Ground   Also way up false false true false true   false false false false false false false false   POINT (-73.95728404579711 40.7886933371744)   19 4 19 13
2722 -73.9692271132136 40.777528508844 15E-PM-1008-04 15E PM 10082018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false true false   POINT (-73.9692271132136 40.777528508844)   19 4 19 13
2724 -73.9611434082667 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   false false true false false   false true false false false false false false   POINT (-73.9611434082667 40.7893671772846)   19 4 19 13
2734 -73.9763629541474 40.7682321897044 3E-PM-1008-04 03E PM 10082018 4 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9763629541474 40.7682321897044)   19 4 19 13
2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   false false true false true   false false false false false false true false   POINT (-73.9761879300037 40.7683918970301)   19 4 19 13
2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   false false true false false   false false false false false true false false   POINT (-73.9672063784809 40.7826070395665)   19 4 19 13
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 false false true false true   false false false false false true false false   POINT (-73.9767389132988 40.7689323691424)   19 4 19 13

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE squirrels(
  "Longitude" TEXT,
  "Latitude" TEXT,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" TEXT,
  "Hectare Squirrel Number" TEXT,
  "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" TEXT,
  "Chasing" TEXT,
  "Climbing" TEXT,
  "Eating" TEXT,
  "Foraging" TEXT,
  "Other Activities" TEXT,
  "Kuks" TEXT,
  "Quaas" TEXT,
  "Moans" TEXT,
  "Tail flags" TEXT,
  "Tail twitches" TEXT,
  "Approaches" TEXT,
  "Indifferent" TEXT,
  "Runs from" TEXT,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT,
  "Zip Codes" TEXT,
  "Community Districts" TEXT,
  "Borough Boundaries" TEXT,
  "City Council Districts" TEXT,
  "Police Precincts" TEXT
);
Powered by Datasette · Query took 97.987ms