squirrels

13 rows where Hectare Squirrel Number = 13 and Shift = "PM"

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Other Activities, Tail twitches, Approaches, Indifferent, Runs from

Shift

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
64 -73.9595002339508 40.7903365788694 32E-PM-1017-13 32E PM 10172018 13 Adult Gray   Gray+ Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments.       false false false true true   false false false false false false true false   POINT (-73.9595002339508 40.7903365788694)   19 4 19 13
111 -73.9763243383771 40.7705409315703 5C-PM-1010-13 05C PM 10102018 13 Adult Gray White Gray+White   Above Ground 20 way up a tree! false false true false false   false false false false false false false false   POINT (-73.9763243383771 40.7705409315703)   19 4 19 13
136 -73.9528682507794 40.7925807808307 36I-PM-1007-13 36I PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9528682507794 40.7925807808307)   19 4 19 13
211 -73.9702755805141 40.7783547795222 16D-PM-1010-13 16D PM 10102018 13 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9702755805141 40.7783547795222)   19 4 19 13
592 -73.9712256765283 40.7760942872488 13D-PM-1018-13 13D PM 10182018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray, Cinnamon & White selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9712256765283 40.7760942872488)   19 4 19 13
1352 -73.9616770335086 40.7921648631096 32C-PM-1013-13 32C PM 10132018 13 Adult Gray   Gray+   Ground Plane FALSE   false false false false true buried nut false false false false true false false false   POINT (-73.9616770335086 40.7921648631096)   19 4 19 13
1646 -73.9669782832746 40.7841166727168 22C-PM-1006-13 22C PM 10062018 13 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9669782832746 40.7841166727168)   19 4 19 13
1906 -73.9700066659086 40.7744028820163 12F-PM-1007-13 12F PM 10072018 13 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9700066659086 40.7744028820163)   19 4 19 13
2237 -73.9708225719705 40.7772497804149 14D-PM-1019-13 14D PM 10192018 13 Adult Gray   Gray+         false false false false false   false false false false false false false false   POINT (-73.9708225719705 40.7772497804149)   19 4 19 13
2628 -73.9770439076963 40.7685720141731 3D-PM-1010-13 03D PM 10102018 13 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9770439076963 40.7685720141731)   19 4 19 13
2644 -73.9775445441194 40.7697096533728 4C-PM-1010-13 04C PM 10102018 13 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9775445441194 40.7697096533728)   19 4 19 13
2837 -73.9772691210241 40.7690960712994 4D-PM-1008-13 04D PM 10082018 13 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9772691210241 40.7690960712994)   19 4 19 13
2927 -73.9650120066074 40.7805932882407 20F-PM-1007-13 20F PM 10072018 13 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9650120066074 40.78059328824071)   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 59.848ms