squirrels

34 rows where Climbing = "true", Combination of Primary and Highlight Color = "Gray+" and Foraging = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Other Activities, Indifferent, Runs from, Other Interactions

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
262 262 -73.9712876234172 40.7695885530701 7H-PM-1006-02 07H PM 10062018 2 Adult Gray   Gray+   Above Ground 25 tree true false true true true   false false false false false false true false   POINT (-73.9712876234172 40.7695885530701)   19 4 19 13
402 402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true runs from the dog POINT (-73.9681917366128 40.7723298813768)   19 4 19 13
496 496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree false false true false true   false false false false false false false false   POINT (-73.9548430741605 40.798207350942)   19 4 19 13
666 666 -73.9687027782726 40.7705162616199 9I-AM-1014-09 09I AM 10142018 9 Adult Gray   Gray+   Above Ground 5   false false true false true   false false false false false false false false   POINT (-73.96870277827261 40.7705162616199)   19 4 19 13
833 833 -73.9741846413977 40.7762518164182 12B-PM-1018-01 12B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE Climbing up rocks false false true false true climbing (up rocks) false false false false false false false true   POINT (-73.9741846413977 40.7762518164182)   19 4 19 13
889 889 -73.9681042612938 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681042612938 40.772331431865)   19 4 19 13
1192 1192 -73.9634811495245 40.790705585077 30B-AM-1007-10 30B AM 10072018 10 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false true   POINT (-73.9634811495245 40.790705585077)   19 4 19 13
1240 1240 -73.9696119179789 40.7802926111865 18C-PM-1018-09 18C PM 10182018 9 Juvenile Gray   Gray+   Above Ground 5   false false true true true   false false false false false false false false   POINT (-73.9696119179789 40.7802926111865)   19 4 19 13
1317 1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9680522379372 40.772389813511)   19 4 19 13
1487 1487 -73.965394655961 40.7763136791661 15I-PM-1012-05 15I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true burying the food on ground false false false false false false false false look at us and continue hiding the food POINT (-73.965394655961 40.7763136791661)   19 4 19 13
1566 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
1568 1568 -73.9681079869821 40.7723494081345 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   true false true false true   false false false false false false false false   POINT (-73.9681079869821 40.7723494081345)   19 4 19 13
1696 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
1697 1697 -73.9568610943394 40.7935959584643 36E-PM-1012-02 36E PM 10122018 2 Adult Gray   Gray+   Above Ground 28 on tree branch false false true false true picking acorns off oak tree false false false false false false true false   POINT (-73.95686109433942 40.7935959584643)   19 4 19 13
1729 1729 -73.9765046109019 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   false false true false true   false false false false false false true false   POINT (-73.9765046109019 40.7736674124746)   19 4 19 13
1776 1776 -73.9562350820255 40.7913464147989 34G-PM-1006-02 34G PM 10062018 2 Adult Gray   Gray+   Above Ground 6   false false true true true eating bread it found on ground false false false false false false false true   POINT (-73.9562350820255 40.7913464147989)   19 4 19 13
1828 1828 -73.9682965197661 40.7805378963883 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   false false true false true   false false false false false false false false   POINT (-73.9682965197661 40.7805378963883)   19 4 19 13
1857 1857 -73.9728797531377 40.7786733148687 15B-PM-1017-01 15B PM 10172018 1   Gray   Gray+   Above Ground 20 in tree false false true false true   false false false false false false true false   POINT (-73.9728797531377 40.7786733148687)   19 4 19 13
1904 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
1962 1962 -73.9647318357023 40.7760936175332 15I-PM-1012-04 15I PM 10122018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true   false false false false false false false false   POINT (-73.9647318357023 40.7760936175332)   19 4 19 13
2015 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
2118 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 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
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   false false true true true   false false false false false false false true   POINT (-73.9657487923637 40.7786823090663)   19 4 19 13
2179 2179 -73.9559663949511 40.7974497269789 40D-AM-1013-07 40D AM 10132018 7 Adult Gray   Gray+   Above Ground 6   false false true false true   false false false false false false false true curious POINT (-73.9559663949511 40.7974497269789)   19 4 19 13
2354 2354 -73.9636740170308 40.7903538224977 30B-AM-1007-12 30B AM 10072018 12 Adult Gray   Gray+   Above Ground 4   false false true false true   false false false false false false false true   POINT (-73.96367401703081 40.79035382249771)   19 4 19 13
2616 2616 -73.9675917702187 40.7789922281625 17E-AM-1017-02 17E AM 10172018 2 Adult Gray   Gray+   Above Ground 8 Shore false false true false true   false false false false false false true false   POINT (-73.9675917702187 40.7789922281625)   19 4 19 13
2690 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
2791 2791 -73.9593624259363 40.7905522356793 32E-AM-1007-02 32E AM 10072018 2 Adult Gray   Gray+   Above Ground 40   false false true false true   false false false false false false true false   POINT (-73.9593624259363 40.7905522356793)   19 4 19 13
2818 2818 -73.9681664642028 40.7724669681958 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   true false true false true   false false false false false false false true runs away from the ball POINT (-73.9681664642028 40.7724669681958)   19 4 19 13
2844 2844 -73.9578840941242 40.7955586232429 37D-PM-1014-06 37D PM 10142018 6 Adult Gray   Gray+   Above Ground 25   false false true false true   false false false false false false false false   POINT (-73.9578840941242 40.7955586232429)   19 4 19 13
2864 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
2934 2934 -73.9561669236168 40.7994737431277 42C-PM-1013-04 42C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9561669236168 40.7994737431277)   19 4 19 13
3012 3012 -73.9613701960898 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   true false true false true got threatened by dog (same dog,dog #1) false false false false false false false true runs from (dog) POINT (-73.9613701960898 40.7943363227822)   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 64.492ms