squirrels

27 rows where Age = "" and Hectare Squirrel Number = 4 sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, 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, Tail flags, Tail twitches, Indifferent, Runs from

Police Precincts ✖

Hectare Squirrel Number ✖

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
29 29 -73.9671786715256 40.7867352791232 25A-AM-1013-04 25A AM 10132018 4   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9671786715256 40.7867352791232)   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
302 302 -73.9695176417703 40.7741725190048 12G-PM-1007-04 12G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9695176417703 40.7741725190048)   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
455 455 -73.9688574691102 40.7837825208444 21B-AM-1019-04 21B AM 10192018 4       +         false false false false false   false false false false false false false false   POINT (-73.9688574691102 40.7837825208444)   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
537 537 -73.9682803241007 40.7724510558327 11H-AM-1010-04 11H AM 10102018 4   Gray White Gray+White         false false false false true   false false false false true false false false   POINT (-73.9682803241007 40.7724510558327)   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
604 604 -73.9540908513075 40.794201225045 37G-PM-1007-04 37G PM 10072018 4   Cinnamon Gray Cinnamon+Gray gray tail Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9540908513075 40.794201225045)   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
959 959 -73.9746133058077 40.7760646554109 11B-PM-1014-04 11B PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false false true jumping false false false false false false false false   POINT (-73.9746133058077 40.776064655410906)   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
1072 1072 -73.9566571713254 40.7989855775435 41C-AM-1017-04 41C AM 10172018 4   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9566571713254 40.7989855775435)   19 4 19 13
1089 1089 -73.9655955841325 40.7762063860571 15H-PM-1008-04 15H PM 10082018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE edge of landscape false false false false true   false false false false false false true false   POINT (-73.9655955841325 40.7762063860571)   19 4 19 13
1475 1475 -73.9686778167484 40.7765625256946 14F-PM-1012-04 14F PM 10122018 4       +         false false false false false   true true false false false false false false   POINT (-73.96867781674841 40.7765625256946)   19 4 19 13
1585 1585 -73.9611312355348 40.7950130863913 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND false false false false false sitting false false false false true false true false   POINT (-73.9611312355348 40.7950130863913)   19 4 19 13
2011 2011 -73.9603245806655 40.7942712477697 35C-PM-1013-04 35C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9603245806655 40.7942712477697)   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
2840 2840 -73.9532163535175 40.7982970313067 42F-PM-1017-04 42F PM 10172018 4   Gray   Gray+         true false false false false   false false false false false false true false   POINT (-73.9532163535175 40.7982970313067)   19 4 19 13
252 252 -73.974420668782 40.7749628597465 10C-PM-1013-04 10C PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.974420668782 40.7749628597465)   19 4 19 13
446 446 -73.9678774314725 40.7738535171265 12H-PM-1007-04 12H PM 10072018 4   Gray Cinnamon Gray+Cinnamon         false false false true false mushroom false false false false false false true false   POINT (-73.9678774314725 40.7738535171265)   19 4 19 13
727 727 -73.9634563222926 40.780992836417 21G-PM-1007-04 21G PM 10072018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.9634563222926 40.780992836417)   19 4 19 13
1029 1029 -73.9601259189134 40.7955350609057 36B-PM-1013-04 36B PM 10132018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9601259189134 40.7955350609057)   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
2951 2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9742986032935 40.7770454318226)   19 4 19 13
2981 2981 -73.9800094828465 40.7677782585639 1B-AM-1012-04 01B AM 10122018 4   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9800094828465 40.7677782585639)   19 4 19 13
3014 3014 -73.9665572004288 40.7804347548303 19E-PM-1018-04 19E PM 10182018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9665572004288 40.7804347548303)   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 329.685ms