squirrels

13 rows where Combination of Primary and Highlight Color = "Cinnamon+Gray", Indifferent = "true" and Tail twitches = "true"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Tail flags

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
423 -73.9756754297747 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9756754297747 40.7738518843446)   19 4 19 13
432 -73.9757787135906 40.7737231427345 9B-PM-1013-03 09B PM 10132018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9757787135906 40.7737231427345)   19 4 19 13
748 -73.9756603846107 40.7672531319384 3F-PM-1013-03 03F PM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9756603846107 40.7672531319384)   19 4 19 13
1492 -73.9807078515193 40.7683335292642 2A-AM-1010-04 02A AM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9807078515193 40.7683335292642)   19 4 19 13
1816 -73.9710187505339 40.7797265666746 17B-AM-1010-02 17B AM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9710187505339 40.7797265666746)   19 4 19 13
2255 -73.9642967875857 40.7815652353937 21F-AM-1018-08 21F AM 10182018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9642967875857 40.7815652353937)   19 4 19 13
2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree true true false false false   false false false true true false true false   POINT (-73.9595222999173 40.7833202577782)   19 4 19 13
2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false true false false   false false false false true false true false   POINT (-73.9501457233643 40.797094356558)   19 4 19 13
2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         false false false true false   false false false false true false true false   POINT (-73.9681960138614 40.7726867422002)   19 4 19 13
2746 -73.9561432836863 40.7982665347234 41C-AM-1017-07 41C AM 10172018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9561432836863 40.7982665347234)   19 4 19 13
2938 -73.97033289562 40.7701079697795 7H-AM-1006-14 07H AM 10062018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.97033289562 40.7701079697795)   19 4 19 13
3004 -73.9528482858163 40.7922056218325 36I-PM-1007-08 36I PM 10072018 8 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9528482858163 40.7922056218325)   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 74.007ms