squirrels

34 rows where Combination of Primary and Highlight Color = "Gray+Cinnamon, White", Foraging = "true" and Tail twitches = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, 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
114 114 -73.971905618214 40.776238547063 13D-PM-1018-10 13D PM 10182018 10 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.971905618214 40.776238547063)   19 4 19 13
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
482 482 -73.9721797824576 40.7801213843628 16A-PM-1019-07 16A PM 10192018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true false false approaches (very friendly) POINT (-73.9721797824576 40.7801213843628)   19 4 19 13
740 740 -73.9583477850634 40.7914073632782 33F-PM-1012-06 33F PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false true false true true   true false false false true false false false   POINT (-73.9583477850634 40.7914073632782)   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
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
1118 1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree true false true false true   false false false false true false false true   POINT (-73.9719460335398 40.7810508156287)   19 4 19 13
1196 1196 -73.9580111496275 40.7985365971474 40B-AM-1019-05 40B AM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false false true   false false false false true true true false   POINT (-73.9580111496275 40.7985365971474)   19 4 19 13
1312 1312 -73.9712034320741 40.7764415506669 13D-PM-1018-05 13D PM 10182018 5 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 false true   false false false false true true true false   POINT (-73.9712034320741 40.7764415506669)   19 4 19 13
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   false true false true true   false false false false true false true false   POINT (-73.9704677007779 40.7786860108302)   19 4 19 13
1462 1462 -73.9584064203778 40.7912272455454 33F-PM-1012-04 33F PM 10122018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false true   POINT (-73.9584064203778 40.7912272455454)   19 4 19 13
1519 1519 -73.971730277301 40.7748805439381 11D-PM-1006-05 11D PM 10062018 5 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.971730277301 40.7748805439381)   19 4 19 13
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence false false false false true   false false false false true false false false   POINT (-73.9676539688726 40.7777229934129)   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
1686 1686 -73.9593373093799 40.7982428507976 39A-PM-1014-03 39A PM 10142018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Higlights. Made executive adjustments. Above Ground 6 Jumped from ground onto branch false false false false true digging? false false false false true false true false   POINT (-73.95933730937992 40.7982428507976)   19 4 19 13
1744 1744 -73.9584661589182 40.7912068380845 33F-PM-1012-01 33F PM 10122018 1 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.9584661589182 40.7912068380845)   19 4 19 13
1769 1769 -73.9721086069437 40.7698172190404 6G-AM-1008-06 06G AM 10082018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White white at end of tail Ground Plane FALSE grass false false false false true   false false false false true false true false   POINT (-73.9721086069437 40.7698172190404)   19 4 19 13
1793 1793 -73.9771575249322 40.7673873716547 2E-AM-1010-07 02E AM 10102018 7 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.9771575249322 40.7673873716547)   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
1866 1866 -73.9636027664439 40.790075966587 30B-PM-1019-01 30B PM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false true true   false false false false true false false true   POINT (-73.9636027664439 40.790075966587)   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
1950 1950 -73.9643016116839 40.7904796216068 30B-PM-1019-05 30B PM 10192018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false false true true hiding a nut false false false false true false false true   POINT (-73.9643016116839 40.7904796216068)   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
2201 2201 -73.9717135461165 40.7761780680083 13D-PM-1018-01 13D PM 10182018 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.9717135461165 40.776178068008306)   19 4 19 13
2314 2314 -73.9663961415789 40.7750691120996 14H-PM-1012-06 14H PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary with a note that it was "hard to tell". Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9663961415789 40.7750691120996)   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
2508 2508 -73.979381450452 40.7709033697887 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false true true true   false false false false true false true false   POINT (-73.979381450452 40.770903369788705)   19 4 19 13
2511 2511 -73.9584561537421 40.7911211164754 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   false false true true true   false false false false true false false false   POINT (-73.9584561537421 40.7911211164754)   19 4 19 13
2610 2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass false false false true true   false false false false true true false false   POINT (-73.9713379914423 40.7696367609606)   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
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
2849 2849 -73.9709912560997 40.7758965595198 13D-AM-1014-01 13D AM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false true   false false false false true false false true   POINT (-73.9709912560997 40.7758965595198)   19 4 19 13
3000 3000 -73.9688293382172 40.7738958027568 12G-AM-1012-04 12G AM 10122018 4 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.9688293382172 40.773895802756805)   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

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 65.622ms