squirrels

18 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon", Eating = "true" and Hectare Squirrel Number = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Tail flags, Tail twitches, Indifferent, Runs from

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
44 44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   false true false true false   false false false false false false true false   POINT (-73.970252675331 40.77059995882221)   19 4 19 13
393 393 -73.9577212629651 40.7965525296722 38C-PM-1014-06 38C PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9577212629651 40.7965525296722)   19 4 19 13
501 501 -73.9708798496132 40.7761532088521 13D-AM-1014-06 13D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false   false false false false false false false true   POINT (-73.9708798496132 40.7761532088521)   19 4 19 13
522 522 -73.9773821135611 40.7690453494383 4C-PM-1010-06 04C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE behind playground benches false false false true false   false false false false true false false true   POINT (-73.9773821135611 40.7690453494383)   19 4 19 13
597 597 -73.9718270820347 40.7748300991287 11D-AM-1010-06 11D AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.97182708203471 40.7748300991287)   19 4 19 13
814 814 -73.9607608482656 40.7954687648248 36A-PM-1013-06 36A PM 10132018 6   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE EDGE OF WOODS false false false true false   false false false false false false true false   POINT (-73.9607608482656 40.7954687648248)   19 4 19 13
818 818 -73.9608757424052 40.7906686504657 31D-AM-1014-06 31D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9608757424052 40.7906686504657)   19 4 19 13
1216 1216 -73.9707245013626 40.7780656588337 15D-AM-1007-06 15D AM 10072018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9707245013626 40.7780656588337)   19 4 19 13
1419 1419 -73.9756017589251 40.7680335996527 3E-PM-1008-06 03E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9756017589251 40.7680335996527)   19 4 19 13
1777 1777 -73.9711751356843 40.7752422758202 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   false false false true true   false false false false false false true false   POINT (-73.9711751356843 40.7752422758202)   19 4 19 13
1878 1878 -73.9761223919286 40.7685998275864 4E-PM-1008-06 04E PM 10082018 6 Adult Gray Cinnamon Gray+Cinnamon         false false false true true   false false false false false false true false   POINT (-73.9761223919286 40.7685998275864)   19 4 19 13
1963 1963 -73.9651591861399 40.781183828857 20F-PM-1007-06 20F PM 10072018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9651591861399 40.781183828857)   19 4 19 13
2502 2502 -73.9758375334287 40.7676793289765 3E-AM-1006-06 03E AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 14   false false false true false   false false false false false false false false   POINT (-73.9758375334287 40.7676793289765)   19 4 19 13
2635 2635 -73.9763836740342 40.7706121151491 5C-AM-1006-06 05C AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9763836740342 40.7706121151491)   19 4 19 13
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag false false true true false   false false false false false false true true   POINT (-73.9566300789162 40.7993692120774)   19 4 19 13
2769 2769 -73.9769885189342 40.7708936173356 5C-PM-1010-06 05C PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9769885189342 40.7708936173356)   19 4 19 13
2845 2845 -73.9765016413674 40.7740672862953 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false true false   false false false false false false true false   POINT (-73.9765016413674 40.7740672862953)   19 4 19 13
2980 2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   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 174.176ms