squirrels

8 rows where Combination of Primary and Highlight Color = "Gray+Black" and Shift = "PM"

View and edit SQL

Suggested facets: Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Other Activities, Tail twitches, Indifferent, Runs from

Shift

Highlight Fur Color

Combination of Primary and Highlight Color

  • Gray+Black · 8
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
301 -73.9717425494287 40.7664227676653 3I-PM-1013-07 03I PM 10132018 7 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9717425494287 40.7664227676653)   19 4 19 13
567 -73.9756972647636 40.773624164826 9B-PM-1013-04 09B PM 10132018 4 Juvenile Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false true false true false   POINT (-73.9756972647636 40.773624164826)   19 4 19 13
885 -73.9750463844984 40.7666871742836 2F-PM-1014-08 02F PM 10142018 8 Adult Gray Black Gray+Black   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9750463844984 40.7666871742836)   19 4 19 13
991 -73.9635689059841 40.790163434915 30B-PM-1019-03 30B PM 10192018 3 Adult Gray Black Gray+Black   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9635689059841 40.790163434915)   19 4 19 13
1874 -73.9657327332849 40.7747554568985 14I-PM-1018-03 14I PM 10182018 3 Juvenile Gray Black Gray+Black   Above Ground 4   false false true false false   false false false false false false true false   POINT (-73.9657327332849 40.7747554568985)   19 4 19 13
1894 -73.9699780857298 40.7688706046944 6I-PM-1013-01 06I PM 10132018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9699780857298 40.7688706046944)   19 4 19 13
2055 -73.9806928007664 40.768255422025 1A-PM-1014-03 01A PM 10142018 3 Adult Gray Black Gray+Black   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.9806928007664 40.768255422025)   19 4 19 13
2421 -73.9682278905989 40.7733027508057 11H-PM-1013-02 11H PM 10132018 2 Adult Gray Black Gray+Black   Above Ground 10   false false false false false digging false false false false false false true false   POINT (-73.9682278905989 40.7733027508057)   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 56.57ms