squirrels

6 rows where Eating = "false" and Other Activities = "burying"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Climbing, Foraging, Approaches, Indifferent

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
228 -73.9728660779622 40.7753294525644 12C-AM-1013-03 12C AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9728660779622 40.7753294525644)   19 4 19 13
481 -73.9714303315699 40.7745934947706 11E-AM-1013-04 11E AM 10132018 4 Adult Black   Black+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9714303315699 40.7745934947706)   19 4 19 13
662 -73.9721854790038 40.7761086352438 12C-AM-1013-01 12C AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9721854790038 40.7761086352438)   19 4 19 13
1205 -73.9611118778753 40.7952007875354 36A-PM-1013-01 36A PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true burying false false false false false true false false   POINT (-73.9611118778753 40.7952007875354)   19 4 19 13
2474 -73.9721448879766 40.7762112840981 13C-AM-1010-02 13C AM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   false false true false false burying false false false false false false true false   POINT (-73.9721448879766 40.7762112840981)   19 4 19 13
2848 -73.9715977170548 40.7742172650622 11E-AM-1013-03 11E AM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false false true burying false false false false false false true false   POINT (-73.9715977170548 40.774217265062205)   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 86.03ms