squirrels

14 rows where Highlight Fur Color = "Black, Cinnamon, White" and Runs from = "true"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Kuks, Tail flags, Tail twitches, Indifferent, Zip Codes, Community Districts, City Council Districts, Police Precincts

Eating

Runs from

  • true · 14

Highlight Fur Color

  • Black, Cinnamon, White · 14
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
568 -73.9799441493404 40.7671499997527 1C-AM-1012-01 01C AM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false   false false false true false false false true   POINT (-73.9799441493404 40.7671499997527) 12081 11 4 51 10
706 -73.9570132570934 40.7932014159087 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true true   false false false true false false true true   POINT (-73.9570132570934 40.7932014159087)   19 4 19 13
1009 -73.9636551433178 40.7901572818776 30B-PM-1019-02 30B PM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false true false true true   false false false false true false false true   POINT (-73.9636551433178 40.7901572818776)   19 4 19 13
1219 -73.9661892200474 40.7836798072777 22D-PM-1012-06 22D PM 10122018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9661892200474 40.7836798072777)   19 4 19 13
1625 -73.9736873018042 40.7649106677138 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree false false true false false   true false false false false false false true   POINT (-73.9736873018042 40.7649106677138)   19 4 19 13
1840 -73.9733222531339 40.7649975371546 1I-PM-1012-01 01I PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9733222531339 40.7649975371546)   19 4 19 13
1967 -73.9647247254127 40.7806136565784 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false true false false false true   POINT (-73.9647247254127 40.7806136565784)   19 4 19 13
2079 -73.9643025171914 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false true false true   false false false false false false false true   POINT (-73.9643025171914 40.790570391517)   19 4 19 13
2176 -73.9583201789615 40.7913938722521 33F-PM-1012-05 33F PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false false true   true false false true true false false true   POINT (-73.95832017896151 40.7913938722521)   19 4 19 13
2604 -73.9605163698302 40.7914179994956 32D-PM-1006-05 32D PM 10062018 5 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false true true false   false false false false true false false true   POINT (-73.9605163698302 40.7914179994956)   19 4 19 13
2825 -73.9643507588008 40.7904324693292 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.96435075880082 40.7904324693292)   19 4 19 13
2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false true false false false true   POINT (-73.97281464823851 40.765295171474506)   19 4 19 13
2874 -73.9597453664295 40.7891382153733 30F-PM-1007-01 30F PM 10072018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 1 tree false false true false false   false false false false true false false true   POINT (-73.9597453664295 40.7891382153733)   19 4 19 13
2947 -73.9601215198114 40.7909769801241 32D-PM-1006-02 32D PM 10062018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false true false false true   POINT (-73.9601215198114 40.7909769801241)   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 1683.995ms