squirrels

46 rows where Date = 10142018, Eating = "true" and Indifferent = "true"

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, Police Precincts

Hectare

Indifferent

  • true · 46

Eating

  • true · 46

Date

  • 10142018 · 46
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
158 -73.9710991123992 40.7723889726647 9F-PM-1014-02 09F PM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9710991123992 40.7723889726647)   19 4 19 13
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
393 -73.9577212629651 40.7965525296722 38C-PM-1014-06 38C PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9577212629651 40.7965525296722)   19 4 19 13
498 -73.9669432929573 40.779136518298 18F-AM-1014-01 18F AM 10142018 1 Adult Gray White Gray+White   Above Ground   Low tree false false false true false   false false false false false false true false   POINT (-73.9669432929573 40.779136518298)   19 4 19 13
548 -73.9584696083284 40.7980121226635 39B-PM-1014-03 39B PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9584696083284 40.7980121226635)   19 4 19 13
577 -73.9497217674555 40.796517007214 42I-PM-1014-03 42I PM 10142018 3   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9497217674555 40.796517007214)   19 4 19 13
719 -73.9626881234742 40.7905208345549 30C-AM-1014-01 30C AM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false true false true false   POINT (-73.9626881234742 40.7905208345549)   19 4 19 13
736 -73.9660110060416 40.7809990098597 20F-AM-1014-01 20F AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9660110060416 40.7809990098597)   19 4 19 13
818 -73.9608757424052 40.7906686504657 31D-AM-1014-06 31D AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9608757424052 40.7906686504657)   19 4 19 13
826 -73.9557263533489 40.7939505791448 37F-PM-1014-02 37F PM 10142018 2 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE LAWN false false false true true   false false false false false false true false   POINT (-73.95572635334891 40.7939505791448)   19 4 19 13
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
845 -73.9582850206205 40.7978975855555 39B-PM-1014-01 39B PM 10142018 1 Adult Gray White Gray+White White belly Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9582850206205 40.7978975855555)   19 4 19 13
878 -73.9757215415855 40.7668205976986 2F-PM-1014-03 02F PM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9757215415855 40.7668205976986)   19 4 19 13
1021 -73.97186968288 40.778926988884 15B-AM-1014-03 15B AM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true true running (from a dog) false false false false false false true false   POINT (-73.97186968288 40.778926988884)   19 4 19 13
1097 -73.9761579527932 40.7755877312075 10A-PM-1014-02 10A PM 10142018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon   Ground Plane FALSE in the bushes beneath a tree false false false true true   false false false false true false true false   POINT (-73.9761579527932 40.7755877312075)   19 4 19 13
1122 -73.9728700359494 40.7659842666881 3H-PM-1014-05 03H PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728700359494 40.7659842666881)   19 4 19 13
1223 -73.9591298551111 40.7919612446005 33E-AM-1014-04 33E AM 10142018 4 Adult Black Cinnamon, White Black+Cinnamon, White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9591298551111 40.7919612446005)   19 4 19 13
1255 -73.9717469822209 40.7753731930704 12D-PM-1014-03 12D PM 10142018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false true false   false false false false true false true false   POINT (-73.9717469822209 40.7753731930704)   19 4 19 13
1382 -73.9611274898661 40.7915250069086 32C-AM-1014-05 32C AM 10142018 5 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9611274898661 40.7915250069086)   19 4 19 13
1482 -73.9588610195699 40.7945269936639 36C-AM-1014-02 36C AM 10142018 2 Juvenile Gray White Gray+White   Ground Plane FALSE Crossing path false false false true true   false false false false false false true false   POINT (-73.9588610195699 40.7945269936639)   19 4 19 13
1537 -73.9767220179725 40.7753262103123 10A-PM-1014-03 10A PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground   above my head in tree false false false true false eating (in a tree) false false false false false false true false indifferent (lots of people taking its picture,didn't bother it) POINT (-73.9767220179725 40.7753262103123) 12420 20 4 19 12
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
1667 -73.9645989003589 40.7782157459155 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9645989003589 40.7782157459155)   19 4 19 13
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
1739 -73.9639700434449 40.7775003050028 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings true false true true false   false false false false false false true false   POINT (-73.9639700434449 40.7775003050028)   19 4 19 13
1771 -73.9750688083336 40.7665584681025 2F-PM-1014-07 02F PM 10142018 7 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9750688083336 40.7665584681025)   19 4 19 13
1775 -73.951965247933 40.7938167628067 38I-PM-1014-03 38I PM 10142018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   false false false true false   false false false false false false true true   POINT (-73.951965247933 40.7938167628067)   19 4 19 13
1936 -73.9667911565238 40.779321901098 18F-AM-1014-02 18F AM 10142018 2 Adult Gray   Gray+   Ground Plane FALSE In small tree by water false false false true true   false true false false false false true false   POINT (-73.9667911565238 40.77932190109801)   19 4 19 13
2128 -73.9757673193743 40.7669614322613 2F-PM-1014-04 02F PM 10142018 4 Adult Gray   Gray+   Above Ground 20   false false false true false   false false false false false false true false   POINT (-73.9757673193743 40.766961432261304)   19 4 19 13
2174 -73.9684092812839 40.7711445841928 9I-AM-1014-07 09I AM 10142018 7 Adult Cinnamon   Cinnamon+ No real highlight, White tail? Ground Plane FALSE   false false true true true   false false false false false false true false   POINT (-73.9684092812839 40.7711445841928)   19 4 19 13
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
2270 -73.9703732649257 40.7701979377103 8H-PM-1014-04 08H PM 10142018 4 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.97037326492571 40.7701979377103)   19 4 19 13
2325 -73.9728360875598 40.7660637295671 3H-PM-1014-04 03H PM 10142018 4 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9728360875598 40.7660637295671)   19 4 19 13
2507 -73.964868521585 40.7821064183815 22F-PM-1014-01 22F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.964868521585 40.7821064183815)   19 4 19 13
2545 -73.9617594316752 40.7946803725236 35A-AM-1014-01 35A AM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   true false false true false   false false false false false false true false   POINT (-73.9617594316752 40.7946803725236)   19 4 19 13
2580 -73.970795746101 40.7704727212299 8H-PM-1014-01 08H PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.970795746101 40.7704727212299)   19 4 19 13
2613 -73.96393252683 40.7808289765857 21G-AM-1014-04 21G AM 10142018 4 Adult Gray White Gray+White   Above Ground 6   false false false true false   false false false false false false true false   POINT (-73.96393252683 40.7808289765857)   19 4 19 13
2641 -73.9615516703494 40.7905219388359 31D-AM-1014-04 31D AM 10142018 4 Juvenile Gray   Gray+   Ground Plane FALSE Open ground true false false true true   false false false false true false true false   POINT (-73.9615516703494 40.7905219388359)   19 4 19 13
2645 -73.9584967368893 40.7977320341094 39B-PM-1014-05 39B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true pretended to bury a nut,stuck a leaf on top to make the spot less conspicuous. false false false false false false true false   POINT (-73.9584967368893 40.7977320341094)   19 4 19 13
2804 -73.9576094432477 40.7965342664074 38C-PM-1014-07 38C PM 10142018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false true true false   false false false false false false true false   POINT (-73.9576094432477 40.7965342664074)   19 4 19 13
2805 -73.9711634340673 40.7760553338671 13D-AM-1014-05 13D AM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false true false true true   false false false false false false true false   POINT (-73.9711634340673 40.7760553338671)   19 4 19 13
2846 -73.9661570478029 40.7807271518813 20E-AM-1014-02 20E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9661570478029 40.7807271518813)   19 4 19 13
2916 -73.9517525111679 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   false false true true false   false false false false false false true false   POINT (-73.9517525111679 40.7974407641075)   19 4 19 13
2953 -73.9585862117341 40.7986549251083 40A-PM-1014-05 40A PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true eating (in a tree cage thing) false false false false false false true false   POINT (-73.9585862117341 40.7986549251083)   19 4 19 13
2967 -73.9713257586372 40.7762719619467 13D-AM-1014-09 13D AM 10142018 9 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9713257586372 40.7762719619467)   19 4 19 13
2980 -73.9716414586381 40.771760114722 9F-PM-1014-06 09F PM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false true false running (from birds) false false false true false false true false   POINT (-73.9716414586381 40.771760114722)   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 90.403ms