squirrels

26 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White" and Date = 10132018 sorted by Zip Codes descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Climbing ✖

Date ✖

  • 10132018 · 26 ✖

Combination of Primary and Highlight Color ✖

  • Gray+Cinnamon, White · 26 ✖
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
155 155 -73.9522142360388 40.7949598486683 39H-PM-1013-02 39H PM 10132018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9522142360388 40.7949598486683)   19 4 19 13
422 422 -73.9694630409125 40.769737659647 8I-PM-1013-01 08I PM 10132018 1 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.9694630409125 40.769737659647)   19 4 19 13
523 523 -73.9793103340869 40.7678201535968 1C-PM-1013-06 01C PM 10132018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false false   POINT (-73.9793103340869 40.76782015359681)   19 4 19 13
646 646 -73.954092292214 40.7979800395433 41E-PM-1013-05 41E PM 10132018 5 Juvenile Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 10   false false false true false   false false false false false false false false   POINT (-73.954092292214 40.7979800395433)   19 4 19 13
688 688 -73.9580785600617 40.7957981310897 37C-PM-1013-01 37C PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9580785600617 40.7957981310897)   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
918 918 -73.9681093100008 40.7731753915361 11H-PM-1013-01 11H PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false nut in mouth false false false false false false true false   POINT (-73.9681093100008 40.7731753915361)   19 4 19 13
1014 1014 -73.9694468044483 40.770360886038 8I-PM-1013-05 08I PM 10132018 5 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.9694468044483 40.770360886038)   19 4 19 13
1024 1024 -73.9521514669041 40.7949515182825 39H-PM-1013-03 39H PM 10132018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false true true true   POINT (-73.9521514669041 40.7949515182825)   19 4 19 13
1108 1108 -73.9638397790384 40.7828950272904 23F-PM-1013-02 23F PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false true false false true false true false indifferent (mostly,did notice me,busy eating,foraging) POINT (-73.9638397790384 40.7828950272904)   19 4 19 13
1130 1130 -73.9519081627768 40.7973148719421 41G-AM-1013-02 41G AM 10132018 2 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.9519081627768 40.7973148719421)   19 4 19 13
1180 1180 -73.9639726817977 40.7829083461049 23F-PM-1013-01 23F PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true runs from (dove into some bushes/undergrowth,only saw briefly! → not because of humans tho.) POINT (-73.9639726817977 40.7829083461049)   19 4 19 13
1409 1409 -73.9581544682422 40.7958081306449 37C-PM-1013-02 37C PM 10132018 2 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.9581544682422 40.7958081306449)   19 4 19 13
1449 1449 -73.9561124892063 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   false false true true false   true false false false false false false true   POINT (-73.9561124892063 40.7949440648632)   19 4 19 13
1552 1552 -73.9695655231393 40.7698324659513 8I-PM-1013-02 08I PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9695655231393 40.7698324659513)   19 4 19 13
1681 1681 -73.9638141923763 40.7829225326288 23F-PM-1013-03 23F PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false indifferent (noticed me,busy eating,foraging) POINT (-73.9638141923763 40.7829225326288)   19 4 19 13
1797 1797 -73.9697178096275 40.7697036696301 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree false true false false false playing,interacting with #6 false false false false true false false false   POINT (-73.9697178096275 40.769703669630104)   19 4 19 13
1848 1848 -73.9604094481336 40.7951451478793 36B-PM-1013-01 36B PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9604094481336 40.7951451478793)   19 4 19 13
1952 1952 -73.9681810466693 40.7720638449419 10I-PM-1013-01 10I PM 10132018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9681810466693 40.7720638449419)   19 4 19 13
1953 1953 -73.9644974196807 40.7810020292593 20G-PM-1013-02 20G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false false false false true   POINT (-73.96449741968071 40.7810020292593)   19 4 19 13
2013 2013 -73.9695348385828 40.7703657361802 8I-PM-1013-07 08I PM 10132018 7 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.9695348385828 40.7703657361802)   19 4 19 13
2068 2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false false wandering,interacting with tourists false false false false false true false false approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)   19 4 19 13
2092 2092 -73.9698231469857 40.7702048311133 8I-PM-1013-04 08I PM 10132018 4 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.9698231469857 40.7702048311133)   19 4 19 13
2589 2589 -73.9694166642262 40.7697788641081 8I-PM-1013-03 08I PM 10132018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9694166642262 40.7697788641081)   19 4 19 13
2661 2661 -73.9693841004072 40.7704148658294 8I-PM-1013-06 08I PM 10132018 6 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.9693841004072 40.7704148658294)   19 4 19 13
2770 2770 -73.9637983513789 40.7828712516396 23F-PM-1013-04 23F PM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary: "much browner, like 1/2 & 1/2". Ground Plane FALSE   false false false false true   false false false false true false true false indifferent (busy foraging) POINT (-73.9637983513789 40.7828712516396)   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 68.098ms