squirrels

7 rows where Date = 10062018 and Highlight Fur Color = "Black, Cinnamon, White"

View and edit SQL

Suggested facets: Hectare, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Highlight Fur Color

  • Black, Cinnamon, White · 7

Date

  • 10062018 · 7
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
314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.960601067176 40.7917243850136)   19 4 19 13
379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false true false false true false   POINT (-73.9606817053484 40.7917320450401)   19 4 19 13
673 -73.958417813526 40.7927301214476 34E-PM-1006-01 34E PM 10062018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   false false false false false sitting and watching on a tree false false false false false false true false   POINT (-73.958417813526 40.7927301214476)   19 4 19 13
2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false true true false   false false false false true false false true   POINT (-73.9605163698302 40.7914179994956)   19 4 19 13
2723 -73.960642602756 40.7917265419842 32D-PM-1006-08 32D PM 10062018 8 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false false stand on two feet and watching me POINT (-73.960642602756 40.7917265419842)   19 4 19 13
2935 -73.9604599477345 40.7915035010169 32D-PM-1006-06 32D PM 10062018 6 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9604599477345 40.7915035010169)   19 4 19 13
2947 -73.9601215198114 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false true false false true   POINT (-73.9601215198114 40.7909769801241)   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 59.142ms