squirrels

42 rows where Age = "" and Location = "Above Ground" sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Location ✖

  • Above Ground · 42 ✖

Age ✖

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
5 5 -73.9593126695714 40.797533370163 39B-AM-1018-01 39B AM 10182018 1       +   Above Ground     false false false false false unknown true false false false false false false false   POINT (-73.9593126695714 40.797533370163)   19 4 19 13
91 91 -73.9565905868276 40.7895654068546 32H-PM-1006-01 32H PM 10062018 1   Gray   Gray+   Above Ground   in the European Beech false false true false false   false false false false false false false false   POINT (-73.9565905868276 40.7895654068546)   19 4 19 13
109 109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
189 189 -73.9735489537928 40.7681257911523 4G-AM-1006-02 04G AM 10062018 2   Gray White Gray+White   Above Ground 12 tree false false false false false sitting in tree false false false false false false true false   POINT (-73.9735489537928 40.7681257911523)   19 4 19 13
256 256 -73.976798124308 40.7741316574113 9A-PM-1010-04 09A PM 10102018 4   Cinnamon   Cinnamon+   Above Ground 20   true false true false false   false false false false false false true false   POINT (-73.97679812430802 40.7741316574113)   19 4 19 13
318 318 -73.9743990576746 40.7768690723163 12A-PM-1013-04 12A PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Above Ground 1   false true false false false chasing #3 false false false false false false true false   POINT (-73.9743990576746 40.7768690723163)   19 4 19 13
381 381 -73.959709414696 40.7919745085986 33D-PM-1006-03 33D PM 10062018 3   Black   Black+   Above Ground 15   true false false true false   false false false false true false false true ran up tree POINT (-73.959709414696 40.7919745085986)   19 4 19 13
497 497 -73.9602166876979 40.7953811003986 36B-AM-1013-04 36B AM 10132018 4   Black   Black+   Above Ground 20 Moved 20+ feet high above top of tree limb false true false false false   false false false false false false false true   POINT (-73.9602166876979 40.7953811003986)   19 4 19 13
503 503 -73.9598340783572 40.7915857030295 33D-PM-1006-02 33D PM 10062018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false   false false false false false false false true   POINT (-73.95983407835722 40.7915857030295)   19 4 19 13
512 512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
526 526 -73.9680833729772 40.7741871025115 12H-PM-1007-08 12H PM 10072018 8       +   Above Ground 7 in tree false false false false false   false false false false false false false true   POINT (-73.9680833729772 40.7741871025115)   19 4 19 13
539 539 -73.9761440627966 40.7706035301542 6D-PM-1020-04 06D PM 10202018 4   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9761440627966 40.7706035301542)   19 4 19 13
582 582 -73.9677779408464 40.7867482211349 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE false true false false false chasing #3 false false false true false false true false   POINT (-73.9677779408464 40.7867482211349)   19 4 19 13
639 639 -73.9558589529608 40.7892400394941 32H-PM-1006-02 32H PM 10062018 2   Gray   Gray+   Above Ground 8   false false true false false   false false false false false false false false   POINT (-73.9558589529608 40.7892400394941)   19 4 19 13
650 650 -73.9809610117171 40.7683896665502 2A-AM-1010-02 02A AM 10102018 2   Gray Cinnamon Gray+Cinnamon   Above Ground   perched on small fence false false false true false   false false false false true false false true   POINT (-73.9809610117171 40.7683896665502)   19 4 19 13
657 657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9679008849677 40.7759013923034)   19 4 19 13
686 686 -73.9695745672033 40.7791835122147 17D-AM-1008-06 17D AM 10082018 6       +   Above Ground   high in tree, couldn't see it, only heard it false false false false false   true false false false false false false false   POINT (-73.9695745672033 40.7791835122147)   19 4 19 13
783 783 -73.9677654289757 40.786785529449 25A-AM-1013-03 25A AM 10132018 3   Gray   Gray+   Above Ground 15 BIG TREE false false false false false being chased by #2 false false false false false false true false   POINT (-73.9677654289757 40.786785529449)   19 4 19 13
861 861 -73.953287300494 40.793520326789 37H-PM-1006-04 37H PM 10062018 4       +   Above Ground 43 tree false false true false false   false false false false false false false false   POINT (-73.953287300494 40.793520326789)   19 4 19 13
1008 1008 -73.9553038162633 40.7909367783223 34H-PM-1006-04 34H PM 10062018 4   Gray Cinnamon Gray+Cinnamon   Above Ground   Elm tree false false false false false   false false false false false false false false   POINT (-73.9553038162633 40.790936778322305)   19 4 19 13
1150 1150 -73.9744726434743 40.776729630785 12A-PM-1013-03 12A PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Above Ground 3   true false false false false chased up a tree by #4 false false false false false false true false   POINT (-73.9744726434743 40.776729630785)   19 4 19 13
1194 1194 -73.9687462566073 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false digging false false false false false false false false   POINT (-73.9687462566073 40.783898987005)   19 4 19 13
1329 1329 -73.9772164524209 40.7688399538756 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree true false true false false   false false false false false false false false did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)   19 4 19 13
1385 1385 -73.9615649773504 40.7954761311501 36A-PM-1013-02 36A PM 10132018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 6   false false false false true   false false false false false false true false   POINT (-73.9615649773504 40.7954761311501)   19 4 19 13
1554 1554 -73.9597462612063 40.7832801145306 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree false false false false false   false true false false false false false false   POINT (-73.9597462612063 40.7832801145306)   19 4 19 13
1649 1649 -73.969347812694 40.7744098063421 12G-PM-1007-02 12G PM 10072018 2   Gray   Gray+   Above Ground   in tree false true false false false   false false false false false false false false   POINT (-73.969347812694 40.7744098063421)   19 4 19 13
1767 1767 -73.958719099962 40.7947587726617 36C-AM-1014-04 36C AM 10142018 4   Gray White Gray+White   Above Ground 15 Ground then tree to eat true false true true false   false false false false false false false true   POINT (-73.958719099962 40.7947587726617)   19 4 19 13
1778 1778 -73.9685598106128 40.7807054868066 19D-PM-1008-02 19D PM 10082018 2       + unknown - cannot see, only hear Above Ground     false false false false false   true false false false false false false false   POINT (-73.9685598106128 40.7807054868066)   19 4 19 13
1831 1831 -73.9746877519291 40.7761402808083 11B-PM-1014-03 11B PM 10142018 3   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746877519291 40.7761402808083)   19 4 19 13
1842 1842 -73.9532804650089 40.7934579333341 37H-PM-1006-05 37H PM 10062018 5       +   Above Ground   tree false false false false false   false false false false false false false false   POINT (-73.9532804650089 40.7934579333341)   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
1864 1864 -73.9694344956258 40.7742869276902 12G-PM-1007-01 12G PM 10072018 1   Gray   Gray+   Above Ground 40 in tree false true false false false   false false false false false false false false   POINT (-73.9694344956258 40.7742869276902)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
1931 1931 -73.9533085932603 40.7934877861075 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree false false true false false   true false false false false false false false   POINT (-73.9533085932603 40.7934877861075)   19 4 19 13
2142 2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2327 2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   false false false false false   true false false false false false false false   POINT (-73.9567801028221 40.7960096659564)   19 4 19 13
2660 2660 -73.9726056411971 40.7793467904743 16A-PM-1019-03 16A PM 10192018 3   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9726056411971 40.7793467904743)   19 4 19 13
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false true   true true false true true false true false   POINT (-73.9601988871514 40.7943473161329)   19 4 19 13
2707 2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree false false true false false chased by a doggo false false true false false false false true runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)   19 4 19 13
2744 2744 -73.9752915601718 40.7739329570033 9B-AM-1010-04 09B AM 10102018 4       +   Above Ground 10   true false true false false   false false false false false false false false   POINT (-73.9752915601718 40.7739329570033)   19 4 19 13
2942 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

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