squirrels

11 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Hectare Squirrel Number = 5, Indifferent = "true", Running = "false" and Runs from = "false" sorted by Other Activities

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Specific Location, Eating, Foraging, Other Activities, Tail twitches

Runs from ✖

  • false · 11 ✖

Running ✖

  • false · 11 ✖

Hectare Squirrel Number ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon, White · 11 ✖
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
104 104 -73.9764036522984 40.7705846185121 5C-AM-1006-05 05C AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9764036522984 40.7705846185121)   19 4 19 13
309 309 -73.9696001184129 40.7820810673532 19B-PM-1018-05 19B PM 10182018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9696001184129 40.7820810673532)   19 4 19 13
355 355 -73.9639635134738 40.7900337598704 29B-PM-1010-05 29B PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9639635134738 40.7900337598704)   19 4 19 13
864 864 -73.969485639023 40.780519159069 18C-PM-1018-05 18C PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.969485639023 40.780519159069)   19 4 19 13
908 908 -73.9594120573719 40.7841945750598 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree false false true false true   false false false false false false true false   POINT (-73.9594120573719 40.7841945750598)   19 4 19 13
1014 1014 -73.9694468044483 40.770360886038 8I-PM-1013-05 08I PM 10132018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9694468044483 40.770360886038)   19 4 19 13
1196 1196 -73.9580111496275 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9580111496275 40.7985365971474)   19 4 19 13
1312 1312 -73.9712034320741 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9712034320741 40.7764415506669)   19 4 19 13
1519 1519 -73.971730277301 40.7748805439381 11D-PM-1006-05 11D PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.971730277301 40.7748805439381)   19 4 19 13
1800 1800 -73.970962498391 40.7766899040856 14D-AM-1014-05 14D AM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.970962498391 40.7766899040856)   19 4 19 13
2685 2685 -73.9601851468038 40.7968698151479 38A-AM-1019-05 38A AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White belly Ground Plane FALSE   false false false false true standing on back legs false false false false false true true false   POINT (-73.9601851468038 40.7968698151479)   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 28719.136ms