squirrels

13 rows where Above Ground Sighter Measurement = 15 and Date = 10072018 sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Climbing, Eating, Other Activities, Tail twitches, Indifferent, Other Interactions

Foraging ✖

Date ✖

  • 10072018 · 13 ✖

Above Ground Sighter Measurement ✖

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
163 163 -73.9712308864394 40.7714534847379 9G-AM-1007-04 09G AM 10072018 4 Adult Gray White Gray+White   Above Ground 15   false false false false false grooming false false false false false false true false   POINT (-73.9712308864394 40.7714534847379)   19 4 19 13
371 371 -73.964080104186 40.7907898627287 30B-AM-1007-02 30B AM 10072018 2 Adult Gray   Gray+   Above Ground 15   true false false false false   false false false false false false false false   POINT (-73.964080104186 40.7907898627287)   19 4 19 13
387 387 -73.9578316525492 40.7890102959629 31G-PM-1007-01 31G PM 10072018 1 Adult Gray   Gray+   Above Ground 15   false false false false false hiding false false false false true false false false froze,sight of dogs POINT (-73.9578316525492 40.7890102959629)   19 4 19 13
591 591 -73.9543323786888 40.7943086530436 37G-PM-1007-03 37G PM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false true false lying on belly on branch,eating big nut false false false false false false false false   POINT (-73.9543323786888 40.7943086530436)   19 4 19 13
781 781 -73.955516031113 40.7923188156277 35G-AM-1007-01 35G AM 10072018 1 Adult Gray White Gray+White   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.955516031113 40.7923188156277)   19 4 19 13
801 801 -73.9743342303548 40.7727742948332 8D-AM-1007-08 08D AM 10072018 8 Adult Gray   Gray+   Above Ground 15   false false false false false communicating from tree false false false false false false false false   POINT (-73.97433423035481 40.7727742948332)   19 4 19 13
1500 1500 -73.9769969548024 40.7710711265211 6C-AM-1007-01 06C AM 10072018 1 Adult Gray White Gray+White vid! Above Ground 15   false false true false false   false false false false true false false false curious,but wary POINT (-73.97699695480242 40.7710711265211)   19 4 19 13
1607 1607 -73.9770508584979 40.7710769301257 6C-AM-1007-02 06C AM 10072018 2 Adult     +   Above Ground 15   false false true false false pulling things off branches false false false false false false false false   POINT (-73.9770508584979 40.7710769301257)   19 4 19 13
1624 1624 -73.9737060043988 40.7725660224983 8D-AM-1007-05 08D AM 10072018 5 Adult Gray   Gray+   Above Ground 15   false false false true false   false false false false false false false false   POINT (-73.9737060043988 40.7725660224983)   19 4 19 13
1727 1727 -73.9692472299565 40.7722592187215 10H-PM-1007-01 10H PM 10072018 1 Adult Gray White Gray+White dark gray Above Ground 15 in tree false false true false false   false false false false false false true false   POINT (-73.9692472299565 40.7722592187215)   19 4 19 13
1796 1796 -73.9765355395622 40.7735653237366 8B-AM-1007-03 08B AM 10072018 3 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.97653553956222 40.7735653237366)   19 4 19 13
1887 1887 -73.9586184232889 40.7993153832942 41A-PM-1007-02 41A PM 10072018 2 Adult Black   Black+   Above Ground 15   false false true false false jumping false false false false false false false false stared at me POINT (-73.9586184232889 40.7993153832942)   19 4 19 13
2561 2561 -73.9591513028486 40.7835978067328 25I-PM-1007-01 25I PM 10072018 1 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false false false   POINT (-73.9591513028486 40.7835978067328)   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 93.605ms