squirrels

19 rows where Above Ground Sighter Measurement = 20 and Date = 10072018 sorted by Community Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Quaas, Indifferent, Runs from

Foraging ✖

Date ✖

  • 10072018 · 19 ✖

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
268 268 -73.968107276769 40.7768612676036 15F-AM-1007-09 15F AM 10072018 9 Adult Cinnamon White Cinnamon+White   Above Ground 20   false false true false true   false false false false false false false true   POINT (-73.968107276769 40.7768612676036)   19 4 19 13
444 444 -73.9641462360541 40.7778316005464 18I-PM-1007-09 18I PM 10072018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false canoodling w/ 8 false false false false false false true false   POINT (-73.9641462360541 40.7778316005464)   19 4 19 13
555 555 -73.9685227310735 40.776599466588 15F-AM-1007-02 15F AM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO Above Ground 20   true false true false false   false false false false false false false true   POINT (-73.9685227310735 40.776599466588)   19 4 19 13
1010 1010 -73.9689723590015 40.7756860990338 13F-AM-1007-01 13F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9689723590015 40.7756860990338)   19 4 19 13
1081 1081 -73.9680855277775 40.7769251965381 15F-AM-1007-10 15F AM 10072018 10 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   true false true false false   false false false false false false false true   POINT (-73.9680855277775 40.7769251965381)   19 4 19 13
1300 1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   false true true false false canoodling w/ #9 false false false false false false true false   POINT (-73.964280573021 40.777830911491)   19 4 19 13
1301 1301 -73.9552146665714 40.7892909102377 32I-PM-1007-03 32I PM 10072018 3 Adult Gray   Gray+ small adult Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9552146665714 40.7892909102377)   19 4 19 13
1425 1425 -73.9586252875856 40.7852027586217 27I-AM-1007-03 27I AM 10072018 3 Adult Gray Cinnamon Gray+Cinnamon had .5 of a tail Above Ground 20   false false true false true   false false false false false false true false   POINT (-73.9586252875856 40.7852027586217)   19 4 19 13
1431 1431 -73.9601918930677 40.7944134683406 35C-AM-1007-01 35C AM 10072018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20 (white oak) false false false false false sitting still false false false false false false false false   POINT (-73.9601918930677 40.7944134683406)   19 4 19 13
1466 1466 -73.9651177657676 40.7812408103825 20F-PM-1007-05 20F PM 10072018 5 Juvenile Gray White Gray+White white tail Above Ground 20   false false true false false   false false false false false false false true   POINT (-73.9651177657676 40.781240810382506)   19 4 19 13
1554 1554 -73.9597462612063 40.7832801145306 25I-PM-1007-06 25I PM 10072018 6       + Didn't see squirrel size, or colors Above Ground 20 up in tree false false false false false   false true false false false false false false   POINT (-73.9597462612063 40.7832801145306)   19 4 19 13
1560 1560 -73.9587072763996 40.7850256219415 27I-AM-1007-01 27I AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   false false true true false   false false false false false false false true   POINT (-73.9587072763996 40.7850256219415)   19 4 19 13
1899 1899 -73.9764314091366 40.7736458057952 8B-AM-1007-02 08B AM 10072018 2 Adult Gray   Gray+   Above Ground 20   false false true false false   false false false false false false true false   POINT (-73.9764314091366 40.773645805795205)   19 4 19 13
1925 1925 -73.9581389870644 40.7993081122523 41A-PM-1007-04 41A PM 10072018 4 Adult Gray   Gray+   Above Ground 20   true false true false false laid down on the branch false false false false false false false true   POINT (-73.9581389870644 40.799308112252305)   19 4 19 13
2145 2145 -73.9651250402583 40.7812884929069 20F-PM-1007-04 20F PM 10072018 4 Juvenile Gray White Gray+White white on tail Above Ground 20 climbed tree false false true false true   false false false false false false false false   POINT (-73.9651250402583 40.7812884929069)   19 4 19 13
2248 2248 -73.9766477027266 40.7712737417779 6C-AM-1007-04 06C AM 10072018 4 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #5 false false false false false false true false   POINT (-73.9766477027266 40.7712737417779)   19 4 19 13
2436 2436 -73.95827701417 40.7856610238891 28I-PM-1007-01 28I PM 10072018 1 Adult Gray   Gray+   Above Ground 20   true false true false false   false false false false false false true false   POINT (-73.95827701417 40.7856610238891)   19 4 19 13
2730 2730 -73.9653575758687 40.7805339953372 20F-PM-1007-12 20F PM 10072018 12 Adult Gray White Gray+White   Above Ground 20 in tree false false true true false   false false false false false false false false   POINT (-73.9653575758687 40.7805339953372)   19 4 19 13
2990 2990 -73.9766012108307 40.7712310725379 6C-AM-1007-05 06C AM 10072018 5 Adult Gray   Gray+   Above Ground 20   false true true false false chasing #4 false false false false false false true false   POINT (-73.9766012108307 40.7712310725379)   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 183.982ms