squirrels

36 rows where Above Ground Sighter Measurement = 15, Indifferent = "true", Location = "Above Ground" and Primary Fur Color = "Gray" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Chasing, Climbing, Tail flags, Tail twitches, Other Interactions

Zip Codes

  • 36

Primary Fur Color

  • Gray · 36

Police Precincts

Location

  • Above Ground · 36

Indifferent

  • true · 36

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
380 -73.9649590119935 40.7822107920769 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false true false true false   POINT (-73.9649590119935 40.7822107920769)   19 4 19 13
539 -73.9761440627966 40.7706035301542 6D-PM-1020-04 06D PM 10202018 4   Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9761440627966 40.7706035301542)   19 4 19 13
582 -73.9677779408464 40.7867482211349 25A-AM-1013-02 25A AM 10132018 2   Gray   Gray+   Above Ground 15 BIG TREE false true false false false chasing #3 false false false true false false true false   POINT (-73.9677779408464 40.7867482211349)   19 4 19 13
783 -73.9677654289757 40.786785529449 25A-AM-1013-03 25A AM 10132018 3   Gray   Gray+   Above Ground 15 BIG TREE false false false false false being chased by #2 false false false false false false true false   POINT (-73.9677654289757 40.786785529449)   19 4 19 13
1018 -73.9695305555392 40.7757541971012 13F-PM-1008-03 13F PM 10082018 3 Adult Gray   Gray+   Above Ground 15 tree false false false true true   false false false false false false true false   POINT (-73.9695305555392 40.7757541971012)   19 4 19 13
1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1535 -73.9703921271418 40.7700276115314 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #7 false false false false false false true false   POINT (-73.9703921271418 40.770027611531404)   19 4 19 13
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
1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree false false true false true   false false false false false false true false   POINT (-73.9684058476942 40.7753959833776)   19 4 19 13
1989 -73.9631646754647 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631646754647 40.7925716810884)   19 4 19 13
2180 -73.960864328605 40.7902122634639 31D-PM-1006-02 31D PM 10062018 2 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.960864328605 40.7902122634639)   19 4 19 13
2282 -73.9722056538718 40.7805111762703 17A-PM-1013-03 17A PM 10132018 3 Adult Gray   Gray+   Above Ground 15 tree false false false false false grooming! & scratching false false false false false false true false   POINT (-73.9722056538718 40.7805111762703)   19 4 19 13
2361 -73.9708032298419 40.7784265674544 15C-AM-1010-02 15C AM 10102018 2 Adult Gray   Gray+   Above Ground 15   false false true false false nest building false false false false false false true false   POINT (-73.9708032298419 40.77842656745441)   19 4 19 13
2362 -73.9700263936574 40.7699335098581 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   false true true false false playing w/ #6 false false false false false false true false   POINT (-73.9700263936574 40.7699335098581)   19 4 19 13
2813 -73.9659118189359 40.7765739928504 15H-AM-1013-02 15H AM 10132018 2 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9659118189359 40.7765739928504)   19 4 19 13
1627 -73.9594391759139 40.784115697669 26I-PM-1010-03 26I PM 10102018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White black in tail Above Ground 15 tree false false true true true   false false false false true false true false   POINT (-73.9594391759139 40.784115697669)   19 4 19 13
207 -73.9770824412252 40.7709961309457 5C-AM-1006-03 05C AM 10062018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.97708244122522 40.7709961309457)   19 4 19 13
657 -73.9679008849677 40.7759013923034 14G-AM-1012-02 14G AM 10122018 2   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9679008849677 40.7759013923034)   19 4 19 13
2052 -73.9746493441414 40.7750478734868 11B-PM-1014-06 11B PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   false false false false false cleaning false false false false false false true false   POINT (-73.9746493441414 40.7750478734868)   19 4 19 13
1104 -73.9589852989486 40.7912720015917 33E-AM-1014-07 33E AM 10142018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9589852989486 40.7912720015917)   19 4 19 13
1595 -73.9754696312232 40.768191647092 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   false false true false true foraging (on the tree itself) false false false false false false true false   POINT (-73.9754696312232 40.768191647092)   19 4 19 13
2303 -73.9589470461357 40.7912817646361 33E-AM-1014-10 33E AM 10142018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9589470461357 40.7912817646361)   19 4 19 13
2653 -73.958932543729 40.7913445531266 33E-AM-1014-11 33E AM 10142018 11 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.958932543729 40.7913445531266)   19 4 19 13
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
294 -73.9756573579063 40.7656644063024 1G-PM-1010-01 01G PM 10102018 1 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false true false false true false too busy eating in his tree POINT (-73.9756573579063 40.7656644063024)   19 4 19 13
359 -73.9716404781264 40.7753181851766 12D-PM-1014-02 12D PM 10142018 2 Adult Gray White Gray+White   Above Ground 15   false false true false false seems to be grinding teeth on a piece of material (sounds from grinding) false false false false false false true false   POINT (-73.9716404781264 40.7753181851766)   19 4 19 13
488 -73.9615751148595 40.7954551238146 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9615751148595 40.7954551238146)   19 4 19 13
773 -73.9566189145352 40.7883417969746 31H-PM-1008-01 31H PM 10082018 1 Adult Gray White Gray+White   Above Ground 15   false false true false false   false false false false false false true false   POINT (-73.9566189145352 40.7883417969746)   19 4 19 13
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
999 -73.980948293606 40.7685688850628 2A-PM-1019-04 02A PM 10192018 4 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.980948293606 40.7685688850628)   19 4 19 13
1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9616999731028 40.7954126939561)   19 4 19 13
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
1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false false true false true false   POINT (-73.9720365327715 40.7762329714016)   19 4 19 13
2298 -73.9755371849972 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9755371849972 40.7733561233828)   19 4 19 13
2412 -73.9809446489564 40.7685032165879 2A-PM-1019-03 02A PM 10192018 3 Juvenile Gray White Gray+White   Above Ground 15 in tree! true false false false false   false false false false false false true false   POINT (-73.9809446489564 40.7685032165879)   19 4 19 13
2542 -73.9754802138871 40.773300804412 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   false true false false false   false false false false false false true false   POINT (-73.9754802138871 40.773300804412)   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 4963.543ms