squirrels

21 rows where Age = "" and Hectare Squirrel Number = 3

✎ View and edit SQL

This data as json, CSV (advanced)

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

Climbing ✖

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
1 1 -73.9561344937861 40.7940823884086 37F-PM-1014-03 37F PM 10142018 3       +         false false false false false   false false false false false false false false   POINT (-73.9561344937861 40.7940823884086)   19 4 19 13
8 8 -73.9602609920814 40.7942883045566 35C-PM-1013-03 35C PM 10132018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9602609920814 40.79428830455661)   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
452 452 -73.960300330029 40.7953475871869 36B-AM-1013-03 36B AM 10132018 3   Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.960300330029 40.7953475871869)   19 4 19 13
577 577 -73.9497217674555 40.796517007214 42I-PM-1014-03 42I PM 10142018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9497217674555 40.796517007214)   19 4 19 13
617 617 -73.9558809064648 40.7952765022241 38E-PM-1014-03 38E PM 10142018 3   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH false false false false true   false false false false false false true false   POINT (-73.9558809064648 40.7952765022241)   19 4 19 13
752 752 -73.9768617690725 40.7741877060705 9A-PM-1010-03 09A PM 10102018 3   Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false froze - standing on hind legs for ~10 seconds then scampered off POINT (-73.97686176907251 40.7741877060705)   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
891 891 -73.9613351649026 40.7909866851357 31D-AM-1014-03 31D AM 10142018 3   Gray White Gray+White   Ground Plane FALSE Undergrowth false false false false true   false false false false false false false true   POINT (-73.9613351649026 40.7909866851357)   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
1244 1244 -73.9565260889843 40.7991807924337 42C-AM-1007-03 42C AM 10072018 3       +         false false false false false   false true false false false false false false   POINT (-73.9565260889843 40.79918079243371)   19 4 19 13
1311 1311 -73.9694169352433 40.7744408293858 12G-PM-1007-03 12G PM 10072018 3   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE bushes false false false false true   false false false false false false false false friendly POINT (-73.9694169352433 40.7744408293858)   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
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
1992 1992 -73.9586085843149 40.7946617684536 36C-AM-1014-03 36C AM 10142018 3   Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9586085843149 40.7946617684536)   19 4 19 13
2191 2191 -73.9734108731087 40.7676051392697 4G-AM-1006-03 04G AM 10062018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9734108731087 40.7676051392697)   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
2766 2766 -73.9551639847466 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree false false false true false   false false false false true false false false   POINT (-73.9551639847466 40.790858199891)   19 4 19 13
2836 2836 -73.953092053256 40.7982256930243 42F-PM-1017-03 42F PM 10172018 3   Gray Cinnamon Gray+Cinnamon         true false false false false   false false false false false false true false   POINT (-73.953092053256 40.7982256930243)   19 4 19 13
2860 2860 -73.9565179671319 40.7936663940365 36F-PM-1012-03 36F PM 10122018 3   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.95651796713192 40.7936663940365)   19 4 19 13
2954 2954 -73.9677474313377 40.7742119240825 12H-PM-1007-03 12H PM 10072018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false peanuts false false false false false false true false   POINT (-73.9677474313377 40.7742119240825)   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 69.252ms