squirrels

68 rows where Date = 10142018, Eating = "true" and Runs from = "false"

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, Indifferent, Other Interactions, Zip Codes, Community Districts, Police Precincts

Runs from

  • false · 68

Date

  • 10142018 · 68
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
42 -73.9579564338627 40.7959337795027 38C-PM-1014-09 38C PM 10142018 9 Adult Black   Black+   Ground Plane FALSE   false false false true false   false false false false false true false false   POINT (-73.9579564338627 40.7959337795027)   19 4 19 13
128 -73.9746229094643 40.7748467061969 10B-PM-1014-05 10B PM 10142018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false true false false false avoided people POINT (-73.9746229094643 40.7748467061969)   19 4 19 13
154 -73.9686056085297 40.7781658424866 16E-AM-1014-03 16E AM 10142018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9686056085297 40.7781658424866)   19 4 19 13
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
213 -73.968367485157 40.7838472644815 22B-PM-1014-05 22B PM 10142018 5   Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false eating (eats with head tilted far to the right (tooth issue?)) false false false false false false false false   POINT (-73.968367485157 40.7838472644815)   19 4 19 13
289 -73.9684254196866 40.77809016436 16E-AM-1014-02 16E AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9684254196866 40.77809016436)   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
580 -73.9750992564362 40.7743391883762 10B-PM-1014-03 10B PM 10142018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9750992564362 40.7743391883762)   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
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
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
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
1360 -73.9674930668431 40.781351011968 20D-PM-1014-01 20D PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.96749306684312 40.781351011968)   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
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
1965 -73.9719359643975 40.772699885583 9F-PM-1014-01 09F PM 10142018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false he is fed every day by a woman who calls him "chiquita"! he ran right up to her. POINT (-73.9719359643975 40.772699885583)   19 4 19 13
2047 -73.9721656413591 40.7722869065638 9F-PM-1014-08 09F PM 10142018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false false turned to face me while eating POINT (-73.9721656413591 40.7722869065638)   19 4 19 13
2073 -73.9661108248377 40.7891945123815 28A-AM-1014-01 28A AM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.9661108248377 40.7891945123815)   19 4 19 13
2124 -73.9730039581521 40.7730688398468 9E-PM-1014-03 09E PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE underneath a tree false false false true true   false false false false true false false false   POINT (-73.9730039581521 40.7730688398468)   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
2154 -73.976716425804 40.7736889979965 8A-PM-1014-03 08A PM 10142018 3 Juvenile Gray   Gray+   Above Ground 23   false false true true false   false false false false false false false false   POINT (-73.976716425804 40.7736889979965)   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
2398 -73.958713848373 40.7963918051751 38C-PM-1014-02 38C PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false   POINT (-73.958713848373 40.7963918051751)   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
2551 -73.970138810251 40.770579297644 8H-PM-1014-02 08H PM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false false false froze & watched me,then went back to eating POINT (-73.970138810251 40.770579297644)   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
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
2659 -73.9553603438021 40.7985282963244 41D-PM-1014-05 41D PM 10142018 5 Adult Gray White Gray+White   Above Ground 12   false false false true false   false false false false false false false false   POINT (-73.9553603438021 40.7985282963244)   19 4 19 13
2707 -73.9743165321099 40.7754674678574 11B-PM-1014-07 11B PM 10142018 7   Gray   Gray+   Above Ground 10   true false false true true   false false false false false false false false   POINT (-73.9743165321099 40.7754674678574)   19 4 19 13
2740 -73.9612658688914 40.7912119940469 32C-AM-1014-04 32C AM 10142018 4 Adult Gray   Gray+   Above Ground 8   false false false true false   false false false false false false false false   POINT (-73.9612658688914 40.7912119940469)   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
2931 -73.9730926233232 40.7781330751738 14B-PM-1014-08 14B PM 10142018 8   Gray Cinnamon, White Gray+Cinnamon, White White belly & stripes on tail, Cinnamon face & stripes on back Ground Plane FALSE   false false false true true   false false false false false true false false   POINT (-73.9730926233232 40.7781330751738)   19 4 19 13
2951 -73.9742986032935 40.7770454318226 13A-PM-1014-04 13A PM 10142018 4   Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false false   POINT (-73.9742986032935 40.7770454318226)   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
2959 -73.9747963162162 40.7745023355775 10B-PM-1014-04 10B PM 10142018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false false false avoided people POINT (-73.9747963162162 40.7745023355775)   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 128.414ms