squirrels

35 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Eating = "true" and Shift = "AM"

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
187 187 -73.9700162034073 40.7815277479588 19B-AM-1019-02 19B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true false posing false false false false false false true true indifferent then runs from POINT (-73.9700162034073 40.7815277479588)   19 4 19 13
330 330 -73.9708969246276 40.7767695507462 14D-AM-1014-03 14D AM 10142018 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.9708969246276 40.7767695507462)   19 4 19 13
335 335 -73.9782351435852 40.7715896672335 6A-AM-1006-03 06A AM 10062018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 30 tree false true false true false   false false false true true false false false   POINT (-73.9782351435852 40.7715896672335)   19 4 19 13
489 489 -73.97780296909 40.7676321060669 2D-AM-1007-06 02D AM 10072018 6 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.97780296909002 40.767632106066905)   19 4 19 13
629 629 -73.9573724133264 40.7980080911115 40C-AM-1017-02 40C AM 10172018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true false chasing (#1) false false false false false false false true   POINT (-73.9573724133264 40.7980080911115)   19 4 19 13
669 669 -73.9802079259866 40.7678723471007 1B-AM-1012-10 01B AM 10122018 10 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9802079259866 40.7678723471007)   19 4 19 13
768 768 -73.9729394928432 40.7743256716496 11D-AM-1010-01 11D AM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false false true   POINT (-73.9729394928432 40.7743256716496)   19 4 19 13
798 798 -73.980854228628 40.7678702158382 1B-AM-1012-17 01B AM 10122018 17 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.98085422862802 40.7678702158382)   19 4 19 13
804 804 -73.9697196619878 40.7814068507607 19B-AM-1019-01 19B AM 10192018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Side stripes Ground Plane FALSE   true false false true false   false false false false false false true true indifferent then runs from POINT (-73.9697196619878 40.7814068507607)   19 4 19 13
816 816 -73.9785300509908 40.7721127748427 6A-AM-1006-07 06A AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9785300509908 40.7721127748427)   19 4 19 13
842 842 -73.9645147011741 40.7772566833799 17I-AM-1014-04 17I AM 10142018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true true false   POINT (-73.9645147011741 40.7772566833799)   19 4 19 13
843 843 -73.9714089647431 40.7767916587915 14D-AM-1014-12 14D AM 10142018 12 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9714089647431 40.7767916587915)   19 4 19 13
1295 1295 -73.9709534894049 40.7765964740768 14D-AM-1014-15 14D AM 10142018 15 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9709534894049 40.7765964740768)   19 4 19 13
1330 1330 -73.9643032554205 40.7794514526463 19H-AM-1010-02 19H AM 10102018 2   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false true false true false false ran from human with dog POINT (-73.9643032554205 40.7794514526463)   19 4 19 13
1335 1335 -73.969560591279 40.7705619840715 8I-AM-1006-09 08I AM 10062018 9 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false false false false false very curious,looked like it expected food POINT (-73.969560591279 40.7705619840715)   19 4 19 13
1436 1436 -73.9766779585686 40.7669673778105 2E-AM-1010-04 02E AM 10102018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   true false false false false false true false   POINT (-73.9766779585686 40.7669673778105)   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
1603 1603 -73.9545929242174 40.7986940168685 42D-AM-1014-02 42D AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9545929242174 40.7986940168685)   19 4 19 13
1708 1708 -73.9618486459307 40.7946365810826 35A-AM-1014-02 35A AM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9618486459307 40.7946365810826)   19 4 19 13
1885 1885 -73.9594174605642 40.7973128653773 38B-AM-1019-02 38B AM 10192018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9594174605642 40.7973128653773)   19 4 19 13
2066 2066 -73.9784610031588 40.7668839966177 1D-AM-1006-07 01D AM 10062018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9784610031588 40.7668839966177)   19 4 19 13
2163 2163 -73.9643664403785 40.7793670703727 19H-AM-1010-01 19H AM 10102018 1   Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near base of small tree true false false true true   false false false false false false true false run from human w/ dog POINT (-73.9643664403785 40.7793670703727)   19 4 19 13
2195 2195 -73.955352152771 40.7988549523022 42D-AM-1014-01 42D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   false false true true false   true false false false false false true false   POINT (-73.955352152771 40.7988549523022)   19 4 19 13
2199 2199 -73.9677500862135 40.7726060987821 11I-AM-1012-01 11I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false true false false true   POINT (-73.9677500862135 40.7726060987821)   19 4 19 13
2343 2343 -73.9719194877439 40.7748000962909 11D-AM-1010-04 11D AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9719194877439 40.7748000962909)   19 4 19 13
2389 2389 -73.9801343393329 40.7691512453402 3A-AM-1012-01 03A AM 10122018 1 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 1   false false false true false   false false false false true false false true   POINT (-73.9801343393329 40.7691512453402)   19 4 19 13
2471 2471 -73.964274290774 40.7795319556023 19H-AM-1010-03 19H AM 10102018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true false ran from human w/ dog POINT (-73.964274290774 40.7795319556023)   19 4 19 13
2495 2495 -73.9621253644004 40.7912082086879 31C-AM-1017-01 31C AM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   true false true true false   false false false false true false false true   POINT (-73.9621253644004 40.7912082086879)   19 4 19 13
2510 2510 -73.9748635473782 40.7742591029151 10C-AM-1018-02 10C AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false sitting in the sun false false false false false false true false   POINT (-73.9748635473782 40.7742591029151)   19 4 19 13
2600 2600 -73.9544553697736 40.7912866208106 34I-AM-1012-01 34I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9544553697736 40.7912866208106)   19 4 19 13
2607 2607 -73.9642988690682 40.7795591281979 19H-AM-1010-04 19H AM 10102018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false false false true true runs from human w/ dog POINT (-73.9642988690682 40.7795591281979)   19 4 19 13
2655 2655 -73.9659156108069 40.7810709818696 20E-AM-1014-01 20E AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false false   POINT (-73.9659156108069 40.7810709818696)   19 4 19 13
2863 2863 -73.9698246369929 40.7711472794488 9H-AM-1006-04 09H AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9698246369929 40.7711472794488)   19 4 19 13
3015 3015 -73.9759163300535 40.7736180793606 9B-AM-1010-08 09B AM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White Cinnamon head, White (Almost Silver) Ground Plane FALSE   false false false true true   false false false false true false false false   POINT (-73.9759163300535 40.7736180793606)   19 4 19 13
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   false false true true false eating (on branch) true false false false false false true false   POINT (-73.9662895079734 40.7843300758044)   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 60.535ms