squirrels

10 rows where Combination of Primary and Highlight Color = "Gray+White" and Hectare Squirrel Number = 10 sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Eating, Foraging, Other Activities, Kuks, Tail twitches, Indifferent, Runs from

Climbing ✖

Hectare Squirrel Number ✖

Combination of Primary and Highlight Color ✖

  • Gray+White · 10 ✖
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
69 69 -73.9689000978955 40.7828364735236 20B-PM-1013-10 20B PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true drank from a pond of rain water false false false false false false true false   POINT (-73.9689000978955 40.7828364735236)   19 4 19 13
115 115 -73.9530040923555 40.7922896176936 36I-PM-1007-10 36I PM 10072018 10 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false true false stole (found?) an entire sandwich false false false false false false true false   POINT (-73.9530040923555 40.7922896176936)   19 4 19 13
741 741 -73.9790214253443 40.7686791169776 3B-PM-1007-10 03B PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false hopping false false false false false false true false   POINT (-73.9790214253443 40.7686791169776)   19 4 19 13
807 807 -73.9777259022441 40.7682059907903 3D-PM-1010-10 03D PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9777259022441 40.7682059907903)   19 4 19 13
1381 1381 -73.9586077039567 40.7961896477077 38C-AM-1019-10 38C AM 10192018 10 Adult Gray White Gray+White   Above Ground 20   true false true true false   true false false false true false false true   POINT (-73.9586077039567 40.7961896477077)   19 4 19 13
1852 1852 -73.9792161469158 40.7679285436253 2C-PM-1013-10 02C PM 10132018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false false false   POINT (-73.9792161469158 40.7679285436253)   19 4 19 13
1996 1996 -73.977641787698 40.7695830265784 4C-PM-1010-10 04C PM 10102018 10 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.977641787698 40.7695830265784)   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
2558 2558 -73.9749469566854 40.7667805367199 2F-PM-1014-10 02F PM 10142018 10 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9749469566854 40.7667805367199)   19 4 19 13
2704 2704 -73.9657764490284 40.7811923229286 20F-PM-1007-10 20F PM 10072018 10 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9657764490284 40.7811923229286)   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 218.303ms