squirrels

42 rows where Climbing = "true", Eating = "true" and Foraging = "true" sorted by Hectare Squirrel Number

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foraging ✖

  • true · 42 ✖

Eating ✖

  • true · 42 ✖

Climbing ✖

  • true · 42 ✖
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
768 768 -73.9729394928432 40.7743256716496 11D-AM-1010-01 11D AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9729394928432 40.7743256716496)   19 4 19 13
1429 1429 -73.9706533131129 40.768902033819 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     true false true true true   false false false false false false false true runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)   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
1983 1983 -73.9784144867639 40.7718177667511 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false false false   POINT (-73.9784144867639 40.7718177667511)   19 4 19 13
2009 2009 -73.9639505810228 40.789573183584 29B-PM-1010-01 29B PM 10102018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 4 climbing trees false false true true true scratching self false false false false true false true false   POINT (-73.9639505810228 40.789573183584)   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
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base true false true true true   false false false false false false false true   POINT (-73.973552877209 40.7715638228207)   19 4 19 13
2508 2508 -73.979381450452 40.7709033697887 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false true false true false   POINT (-73.979381450452 40.770903369788705)   19 4 19 13
2583 2583 -73.9769693140651 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree true false true true true digging (?) false false false true false false false true runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)   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
2288 2288 -73.9577009571427 40.796126044521 38C-PM-1014-10 38C PM 10142018 10 Juvenile Gray White Gray+White   Above Ground 10   false false true true true climbing (down from ~10') false false false false false false false true   POINT (-73.9577009571427 40.796126044521)   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
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
2187 2187 -73.9699134052609 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false true true false   POINT (-73.9699134052609 40.774446589038)   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
798 798 -73.980854228628 40.7678702158382 1B-AM-1012-17 01B AM 10122018 17 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.98085422862802 40.7678702158382)   19 4 19 13
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
760 760 -73.9718234159557 40.7810842503715 18A-AM-1012-02 18A AM 10122018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   false false true true true burying false false false true false false false true   POINT (-73.9718234159557 40.7810842503715)   19 4 19 13
1067 1067 -73.9695305996721 40.7745386896959 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9695305996721 40.7745386896959)   19 4 19 13
1093 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
1480 1480 -73.9628525533831 40.7938449345017 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true true true eating upside down on tree trunk false false false false false false false false   POINT (-73.9628525533831 40.7938449345017)   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
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
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   false false true true true   true false false false false false true false   POINT (-73.9789251806378 40.7699558513225)   19 4 19 13
2352 2352 -73.9727310397798 40.7787016773517 15B-PM-1017-02 15B PM 10172018 2 Adult Gray White Gray+White   Ground Plane FALSE tree false false true true true digging,chewing on tree—has nut in mouth! false false false false false false false true   POINT (-73.97273103977982 40.7787016773517)   19 4 19 13
2511 2511 -73.9584561537421 40.7911211164754 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false true false false false   POINT (-73.9584561537421 40.7911211164754)   19 4 19 13
1627 1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree false false true true true   false false false false true false true false   POINT (-73.9594391759139 40.784115697669)   19 4 19 13
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true true true   false false false false false false false true   POINT (-73.9569759970802 40.79314974522941)   19 4 19 13
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2485 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
964 964 -73.9631045499811 40.7906180969472 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false false false false true   POINT (-73.9631045499811 40.7906180969472)   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
2366 2366 -73.9676191846985 40.777641740817 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true true true   false false false false false false false true   POINT (-73.9676191846985 40.777641740817)   19 4 19 13
2607 2607 -73.9642988690682 40.7795591281979 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true true runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)   19 4 19 13
2317 2317 -73.9767369686171 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9767369686171 40.7735074437085)   19 4 19 13
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   false false true true true   false false false false false false true false   POINT (-73.9772908667333 40.7697207404744)   19 4 19 13
1161 1161 -73.9694066600156 40.7805662180672 18C-PM-1018-06 18C PM 10182018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 1   false false true true true   false false false false false false true false   POINT (-73.9694066600156 40.7805662180672)   19 4 19 13
2174 2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9684092812839 40.7711445841928)   19 4 19 13
274 274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9639832886071 40.7909532437095)   19 4 19 13
303 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
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   false false true true true   false false false false false false false true   POINT (-73.96926766598071 40.7700678919108)   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

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