squirrels

15 rows where Above Ground Sighter Measurement = 10, Combination of Primary and Highlight Color = "Gray+Cinnamon" and Indifferent = "false"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Runs from, Other Interactions

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
144 -73.9730750601212 40.7701304211944 6F-PM-1008-01 06F PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9730750601212 40.7701304211944)   19 4 19 13
291 -73.9679661308374 40.7837388390673 22C-AM-1013-01 22C AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false sitting still,tail over back false false false false false false false false   POINT (-73.9679661308374 40.7837388390673)   19 4 19 13
337 -73.9583101927652 40.7852649316039 27I-PM-1020-05 27I PM 10202018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 In tree true false false false false   false false false false false false false true runs from (us) POINT (-73.9583101927652 40.7852649316039)   19 4 19 13
930 -73.9622030085794 40.7917723228749 32B-AM-1017-01 32B AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 ran up a tree true false false false true   false false false false false false false true   POINT (-73.9622030085794 40.7917723228749)   19 4 19 13
1055 -73.9632337134707 40.7914682370734 31B-PM-1007-01 31B PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #2 and climbing tree w/ #2 false false false false false false false true   POINT (-73.9632337134707 40.7914682370734)   19 4 19 13
1060 -73.9728871061191 40.7712983658944 8F-PM-1012-08 08F PM 10122018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false true false   false false false false false false false true   POINT (-73.9728871061191 40.7712983658944)   19 4 19 13
1109 -73.9678154033099 40.7742783484486 12H-PM-1007-01 12H PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false false true false   false false false false false false false false   POINT (-73.9678154033099 40.7742783484486)   19 4 19 13
1168 -73.9779874405715 40.7730765377366 7A-PM-1007-02 07A PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9779874405715 40.7730765377366)   19 4 19 13
1194 -73.9687462566073 40.783898987005 22B-PM-1014-06 22B PM 10142018 6   Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false digging false false false false false false false false   POINT (-73.9687462566073 40.783898987005)   19 4 19 13
1581 -73.97157754108 40.7776249963967 14C-PM-1006-01 14C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   false true false false false false false true   POINT (-73.97157754108 40.7776249963967)   19 4 19 13
1698 -73.9631392113757 40.7914635635784 31B-PM-1007-02 31B PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false true true false false chasing #1 and climbing tree w/ #1 false false false false false false false true   POINT (-73.9631392113757 40.7914635635784)   19 4 19 13
1768 -73.9773696455031 40.7687241866704 3D-PM-1010-14 03D PM 10102018 14 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false false false false crying out true true false false false false false false   POINT (-73.9773696455031 40.7687241866704)   19 4 19 13
1960 -73.9730158913661 40.7701310707272 6F-PM-1008-02 06F PM 10082018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   true true false false false chasing #2 false false false false false false false false   POINT (-73.9730158913661 40.7701310707272)   19 4 19 13
1970 -73.9631464693769 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree false false false false false hanging out,watching world false false false false false false false false watching POINT (-73.9631464693769 40.793415656751)   19 4 19 13
2366 -73.9676191846985 40.777641740817 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true true true   false false false false false false false true   POINT (-73.9676191846985 40.777641740817)   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 64.95ms