squirrels

20 rows where Hectare Squirrel Number = 5 and Highlight Fur Color = "Cinnamon, White" sorted by Eating

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Date, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Foraging ✖

Highlight Fur Color ✖

  • Cinnamon, White · 20 ✖

Hectare Squirrel Number ✖

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
131 131 -73.9755560786227 40.7662992317575 2F-AM-1006-05 02F AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false curious but shy POINT (-73.9755560786227 40.7662992317575)   19 4 19 13
795 795 -73.9582523503306 40.7996897499473 41A-PM-1007-05 41A PM 10072018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true false false   false false false false false false false true   POINT (-73.9582523503306 40.7996897499473)   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
1048 1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree false false true false false   false false false true true false false false curious POINT (-73.9782120139407 40.7717154468791)   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
1584 1584 -73.9581310602492 40.7960214726964 38C-PM-1014-05 38C PM 10142018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false chasing (#4) false false false false false false false true   POINT (-73.9581310602492 40.7960214726964)   19 4 19 13
1592 1592 -73.9575517912392 40.7889158268192 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     false false true false false   false false false false false false false true   POINT (-73.9575517912392 40.7889158268192)   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
2733 2733 -73.9690082314914 40.7738993942891 12G-AM-1012-05 12G AM 10122018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false false false   true false false false false false false true   POINT (-73.9690082314914 40.7738993942891)   19 4 19 13
2873 2873 -73.955068474109 40.7911788152878 34H-PM-1006-05 34H PM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White white tail tip Ground Plane FALSE in grass true false false false true   false false false false false false false false   POINT (-73.955068474109 40.7911788152878)   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
646 646 -73.954092292214 40.7979800395433 41E-PM-1013-05 41E PM 10132018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.954092292214 40.7979800395433)   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
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
1950 1950 -73.9643016116839 40.7904796216068 30B-PM-1019-05 30B PM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true hiding a nut false false false false true false false true   POINT (-73.9643016116839 40.7904796216068)   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 164.905ms