squirrels

122 rows where Climbing = "true" and Date = 10072018 sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Tail flags ✖

Foraging ✖

Date ✖

  • 10072018 · 22 ✖

Climbing ✖

  • true · 22 ✖
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
2868 2868 -73.9653873284496 40.7804699882574 20F-PM-1007-11 20F PM 10072018 11 Adult Gray White Gray+White   Above Ground 10 in tree false false true false false   false false false false false false false false   POINT (-73.9653873284496 40.7804699882574)   19 4 19 13
2874 2874 -73.9597453664295 40.7891382153733 30F-PM-1007-01 30F PM 10072018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 1 tree false false true false false   false false false false true false false true   POINT (-73.9597453664295 40.7891382153733)   19 4 19 13
2927 2927 -73.9650120066074 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9650120066074 40.78059328824071)   19 4 19 13
373 373 -73.9672127283283 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   true false true true false a lot of activity false false false true false false false false   POINT (-73.9672127283283 40.7810666805133)   19 4 19 13
1862 1862 -73.9764851231754 40.7715736862861 6C-AM-1007-07 06C AM 10072018 7 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false ambling false false false false false true false true trucks POINT (-73.9764851231754 40.7715736862861)   19 4 19 13
1300 1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false true true false false canoodling w/ #9 false false false false false false true false   POINT (-73.964280573021 40.777830911491)   19 4 19 13
444 444 -73.9641462360541 40.7778316005464 18I-PM-1007-09 18I PM 10072018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false canoodling w/ 8 false false false false false false true false   POINT (-73.9641462360541 40.7778316005464)   19 4 19 13
1698 1698 -73.9631392113757 40.7914635635784 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #1 and climbing tree w/ #1 false false false false false false false true   POINT (-73.9631392113757 40.7914635635784)   19 4 19 13
1055 1055 -73.9632337134707 40.7914682370734 31B-PM-1007-01 31B PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #2 and climbing tree w/ #2 false false false false false false false true   POINT (-73.9632337134707 40.7914682370734)   19 4 19 13
2990 2990 -73.9766012108307 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #4 false false false false false false true false   POINT (-73.9766012108307 40.7712310725379)   19 4 19 13
2248 2248 -73.9766477027266 40.7712737417779 6C-AM-1007-04 06C AM 10072018 4 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #5 false false false false false false true false   POINT (-73.9766477027266 40.7712737417779)   19 4 19 13
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true chirps false false false false true false true false   POINT (-73.9552595564798 40.7889533029466)   19 4 19 13
1837 1837 -73.9710288101006 40.7715777109992 9G-PM-1007-01 09G PM 10072018 1 Adult Gray   Gray+   Above Ground 2   false false true false false climbing (down tree) false false false false false false false false   POINT (-73.9710288101006 40.7715777109992)   19 4 19 13
2851 2851 -73.955208233231 40.7890574331084 32I-PM-1007-02 32I PM 10072018 2 Adult     +   Above Ground 30   false false true false false different sound - happy,playful chirps false false false false true false true false   POINT (-73.955208233231 40.7890574331084)   19 4 19 13
1654 1654 -73.9766342125035 40.7715437147052 6C-AM-1007-08 06C AM 10072018 8 Adult     +   Above Ground 35   false false true false false dropping acorns false false false false false false false false   POINT (-73.9766342125035 40.7715437147052)   19 4 19 13
1609 1609 -73.9639024988123 40.7776953065849 18I-PM-1007-01 18I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639024988123 40.7776953065849)   19 4 19 13
2222 2222 -73.9639048209454 40.7777373345558 18I-PM-1007-02 18I PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   false false true true true hanging upside down false false false false false false true false   POINT (-73.9639048209454 40.7777373345558)   19 4 19 13
1887 1887 -73.9586184232889 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   false false true false false jumping false false false false false false false false stared at me POINT (-73.9586184232889 40.7993153832942)   19 4 19 13
919 919 -73.9637279711853 40.7905198502307 30B-AM-1007-09 30B AM 10072018 9 Adult Gray   Gray+   Above Ground 50   false false true false false jumping b/w trees false false false false false false false false   POINT (-73.9637279711853 40.7905198502307)   19 4 19 13
1925 1925 -73.9581389870644 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   true false true false false laid down on the branch false false false false false false false true   POINT (-73.9581389870644 40.799308112252305)   19 4 19 13
505 505 -73.9677387336667 40.7742695912 12H-PM-1007-02 12H PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false true true false peanuts false false false false false false true false   POINT (-73.9677387336667 40.7742695912)   19 4 19 13
1607 1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   false false true false false pulling things off branches false false false false false false false false   POINT (-73.9770508584979 40.7710769301257)   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 8.561ms