squirrels

9 rows where Hectare Squirrel Number = 6 and Highlight Fur Color = "Gray"

View and edit SQL

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Other Activities, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Foraging

Eating

Climbing

Highlight Fur Color

  • Gray · 9

Hectare Squirrel Number

City Council Districts

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
67 -73.968381325559 40.7780143443779 16E-PM-1018-06 16E PM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE On a rock false false false false true   false false false false true false true false   POINT (-73.968381325559 40.7780143443779)   19 4 19 13
290 -73.9560679864426 40.7947887062326 37E-PM-1006-06 37E PM 10062018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9560679864426 40.7947887062326)   19 4 19 13
780 -73.9675472064204 40.7835947167436 22C-PM-1006-06 22C PM 10062018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10 on tree false false false true false   false false false false false false false false   POINT (-73.9675472064204 40.7835947167436)   19 4 19 13
987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub false false true false true   false false false true false false true false   POINT (-73.9552035011902 40.7889851896334)   19 4 19 13
1966 -73.9750911996499 40.7722445210179 8C-PM-1013-06 08C PM 10132018 6   Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750911996499 40.7722445210179)   19 4 19 13
2075 -73.9636234953334 40.7775138547689 18I-PM-1007-06 18I PM 10072018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9636234953334 40.7775138547689)   19 4 19 13
2523 -73.9619016393127 40.7925160126921 33B-PM-1010-06 33B PM 10102018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false false true false false   POINT (-73.9619016393127 40.7925160126921)   19 4 19 13
2725 -73.9658867660358 40.7756523577509 15H-PM-1008-06 15H PM 10082018 6 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE base of gingko tree false false false true false   false false false false false false true false   POINT (-73.9658867660358 40.7756523577509)   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 64.265ms