squirrels

12 rows where Date = 10132018 and Hectare Squirrel Number = 9 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Eating, Foraging, Tail twitches, Indifferent, Runs from, Other Interactions

Climbing ✖

Hectare Squirrel Number ✖

Date ✖

  • 10132018 · 12 ✖
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
1221 1221 -73.9796409671481 40.7679049871186 1C-PM-1013-09 01C PM 10132018 9 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9796409671481 40.7679049871186)   19 4 19 13
794 794 -73.9790010565108 40.7685732369544 2C-PM-1013-09 02C PM 10132018 9 Adult     +   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.9790010565108 40.7685732369544)   19 4 19 13
1915 1915 -73.9797112925048 40.7688046778472 2B-PM-1013-09 02B PM 10132018 9 Adult Gray White Gray+White   Above Ground 30   true false false false false   false false false false false false false false   POINT (-73.9797112925048 40.7688046778472)   19 4 19 13
803 803 -73.9697983725608 40.7700677022205 8I-PM-1013-09 08I PM 10132018 9 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.9697983725608 40.7700677022205)   19 4 19 13
1651 1651 -73.9763373510536 40.7741168933928 9B-PM-1013-09 09B PM 10132018 9 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false true false false true runs from (people) POINT (-73.9763373510536 40.7741168933928)   19 4 19 13
1212 1212 -73.9761792189352 40.7745745517215 9A-AM-1013-09 09A AM 10132018 9 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9761792189352 40.7745745517215)   19 4 19 13
2978 2978 -73.9688817006443 40.7829120321438 20B-PM-1013-09 20B PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9688817006443 40.7829120321438)   19 4 19 13
2484 2484 -73.9619786450142 40.7919876274548 32C-PM-1013-09 32C PM 10132018 9 Juvenile Gray   Gray+   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9619786450142 40.7919876274548)   19 4 19 13
809 809 -73.9633250636501 40.7922155082679 32A-PM-1013-09 32A PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9633250636501 40.7922155082679)   19 4 19 13
141 141 -73.9590992841423 40.793758098573 35D-PM-1013-09 35D PM 10132018 9 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9590992841423 40.793758098573)   19 4 19 13
1622 1622 -73.9615090149261 40.7945150173918 35A-PM-1013-09 35A PM 10132018 9   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false false true   POINT (-73.9615090149261 40.7945150173918)   19 4 19 13
979 979 -73.9612349421547 40.7959586475744 36A-PM-1013-09 36A PM 10132018 9   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH true false false false false   false false false false true false false true   POINT (-73.9612349421547 40.7959586475744)   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 72.457ms