squirrels

14 rows where Date = 10142018 and Primary Fur Color = "Black"

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Approaches, Indifferent, Runs from

Primary Fur Color

  • Black · 14

Date

  • 10142018 · 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
42 -73.9579564338627 40.7959337795027 38C-PM-1014-09 38C PM 10142018 9 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9579564338627 40.7959337795027)   19 4 19 13
388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   false false true false false   false false false false false false false true   POINT (-73.9592537496995 40.7919271821316)   19 4 19 13
473 -73.9570130017159 40.7996027428625 42B-AM-1014-02 42B AM 10142018 2 Adult Black   Black+   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9570130017159 40.7996027428625)   19 4 19 13
593 -73.9593352806175 40.7918150568046 33E-AM-1014-02 33E AM 10142018 2 Juvenile Black   Black+   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9593352806175 40.7918150568046)   19 4 19 13
608 -73.9589675995517 40.7913119223584 33E-AM-1014-09 33E AM 10142018 9 Juvenile Black   Black+   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9589675995517 40.7913119223584)   19 4 19 13
755 -73.9579941847434 40.7991216713328 41B-PM-1014-02 41B PM 10142018 2 Adult Black   Black+   Above Ground 28   false false true false false   false false false false false false false false   POINT (-73.9579941847434 40.7991216713328)   19 4 19 13
1223 -73.9591298551111 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9591298551111 40.7919612446005)   19 4 19 13
2270 -73.9703732649257 40.7701979377103 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.97037326492571 40.7701979377103)   19 4 19 13
2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728360875598 40.7660637295671)   19 4 19 13
2540 -73.959127912788 40.7921197130403 33E-AM-1014-13 33E AM 10142018 13 Adult Black Cinnamon Black+Cinnamon Cinnamon on the tail Ground Plane FALSE   false false false false false sitting false false false false false false true false   POINT (-73.959127912788 40.7921197130403)   19 4 19 13
2572 -73.9719901848577 40.7720525965356 9F-PM-1014-07 09F PM 10142018 7 Adult Black   Black+ !!! Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9719901848577 40.7720525965356)   19 4 19 13
2768 -73.9641088172632 40.7886555184212 28C-AM-1014-01 28C AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9641088172632 40.7886555184212)   19 4 19 13
2773 -73.9625932664956 40.7885379477349 29D-AM-1014-01 29D AM 10142018 1 Adult Black   Black+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9625932664956 40.7885379477349)   19 4 19 13
2975 -73.959412243507 40.7917871123534 33E-AM-1014-01 33E AM 10142018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false false false digging false false false false false false false true   POINT (-73.959412243507 40.7917871123534)   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 58.7ms