squirrels

3 rows where Combination of Primary and Highlight Color = "Cinnamon+", Hectare Squirrel Number = 4 and Indifferent = "false"

View and edit SQL

Suggested facets: Shift, Date, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Foraging, Tail twitches, Approaches, Other Interactions

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
88 -73.9683608295976 40.7842927405327 22B-AM-1013-04 22B AM 10132018 4 Adult Cinnamon   Cinnamon+   Ground Plane FALSE Under bench false false false false true   false false false false false false false true ran from dog-walker POINT (-73.9683608295976 40.7842927405327)   19 4 19 13
509 -73.9714289592392 40.7750670702093 12E-PM-1018-04 12E PM 10182018 4 Adult Cinnamon   Cinnamon+   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9714289592392 40.7750670702093)   19 4 19 13
1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   true false false false false   false false false false true true false true   POINT (-73.9604089940153 40.7910028063138)   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 51.058ms