squirrels

7 rows where Combination of Primary and Highlight Color = "Black+Cinnamon" and Shift = "PM"

View and edit SQL

Suggested facets: Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Combination of Primary and Highlight Color

  • Black+Cinnamon · 7
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
210 -73.9711298491132 40.7676902603543 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing false false true true false   false false false true false false false false   POINT (-73.9711298491132 40.7676902603543)   19 4 19 13
430 -73.9710116801402 40.7723689301989 10G-PM-1017-08 10G PM 10172018 8 Adult Black Cinnamon Black+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9710116801402 40.7723689301989)   19 4 19 13
837 -73.9557172336815 40.7921125657722 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false true false false true   POINT (-73.9557172336815 40.7921125657722)   19 4 19 13
1392 -73.9648090698176 40.7903882097837 29A-PM-1019-03 29A PM 10192018 3 Juvenile Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false   false false false false false true false true ran from,but now approaching. kind of weirding me out. POINT (-73.9648090698176 40.7903882097837)   19 4 19 13
1741 -73.9736995552241 40.7722712518637 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree true false true false false   false false false false false false false false   POINT (-73.9736995552241 40.7722712518637)   19 4 19 13
2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728360875598 40.7660637295671)   19 4 19 13
2985 -73.9721159387757 40.7660503188637 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9721159387757 40.7660503188637)   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 62.474ms