squirrels

3 rows where Climbing = "true", Eating = "false", Runs from = "true" and Specific Location = "in tree"

View and edit SQL

Suggested facets: Shift, Date, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Other Activities, Tail twitches, 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
372 -73.9781303869038 40.7725000348875 7A-AM-1006-02 07A AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8 in tree false false true false false   false false false false false false false true   POINT (-73.9781303869038 40.7725000348875)   19 4 19 13
1357 -73.9631350020634 40.791907210332 32B-PM-1010-01 32B PM 10102018 1 Juvenile Gray   Gray+   Above Ground 25 in tree false false true false false   false false false false true false false true   POINT (-73.9631350020634 40.791907210332)   19 4 19 13
1608 -73.9545425520879 40.7956853415959 39F-PM-1006-04 39F PM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 35 in tree false false true false false climbing down false false false false false false false true ran when saw me POINT (-73.9545425520879 40.7956853415959)   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 61.327ms