squirrels

62 rows where Date = 10182018 and Running = "true" sorted by Zip Codes

View and edit SQL

Suggested facets: Hectare, Shift, 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, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Running

  • true · 62

Police Precincts

Date

  • 10182018 · 62
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
21 -73.9703781726172 40.7787526130321 16C-PM-1018-03 16C PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   true false false true true   false false false false false false true false   POINT (-73.9703781726172 40.7787526130321)   19 4 19 13
82 -73.9688271202401 40.7809719445309 19C-PM-1018-01 19C PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false true false   false false false false true false true false   POINT (-73.9688271202401 40.7809719445309)   19 4 19 13
107 -73.9521110154872 40.7978449143313 42G-AM-1018-03 42G AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false stop to look at me—then ran false false false false false false false true   POINT (-73.9521110154872 40.7978449143313)   19 4 19 13
113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   true false false false false flying false false false false false false false false   POINT (-73.9700100617602 40.7815739959357)   19 4 19 13
120 -73.9511118711108 40.7950813345902 40I-AM-1018-01 40I AM 10182018 1 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true begging false false false false false false false false   POINT (-73.9511118711108 40.7950813345902)   19 4 19 13
320 -73.9684376038582 40.7824275067237 20C-PM-1018-09 20C PM 10182018 9 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9684376038582 40.7824275067237)   19 4 19 13
329 -73.967832992543 40.7783669913408 17E-PM-1018-03 17E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.967832992543 40.7783669913408)   19 4 19 13
408 -73.9633760173635 40.7818422357619 22G-PM-1018-03 22G PM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false chilling false false false false false false true false observed POINT (-73.96337601736352 40.7818422357619)   19 4 19 13
442 -73.9502466289084 40.7959228779883 41I-AM-1018-02 41I AM 10182018 2 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false true   false false false false false false false false runs off POINT (-73.9502466289084 40.7959228779883)   19 4 19 13
469 -73.9717201378775 40.776120280884 13D-PM-1018-02 13D PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9717201378775 40.776120280884)   19 4 19 13
529 -73.9635290751183 40.7820936628202 22G-AM-1018-02 22G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true false true false false   true false false false false false false true   POINT (-73.9635290751183 40.7820936628202)   19 4 19 13
556 -73.9721670042434 40.776085913838 13D-PM-1018-09 13D PM 10182018 9 Adult Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9721670042434 40.776085913838)   19 4 19 13
598 -73.9698196671161 40.7802972001469 18C-PM-1018-03 18C PM 10182018 3 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9698196671161 40.7802972001469)   19 4 19 13
620 -73.9655905300923 40.7752614638023 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   true false true false false   false false false false true false true false   POINT (-73.9655905300923 40.7752614638023)   19 4 19 13
720 -73.9669814346326 40.780390919948 19E-PM-1018-01 19E PM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9669814346326 40.780390919948)   19 4 19 13
746 -73.9591407691 40.7960846903122 37B-AM-1018-01 37B AM 10182018 1 Adult Black   Black+   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9591407691 40.7960846903122)   19 4 19 13
751 -73.9683479943823 40.7815827298303 20C-PM-1018-01 20C PM 10182018 1 Juvenile Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9683479943823 40.7815827298303)   19 4 19 13
771 -73.9648626810032 40.7804506112843 20G-AM-1018-02 20G AM 10182018 2 Adult Gray   Gray+   Above Ground 5 Ran up tree true false true false false   true false false false false false false false   POINT (-73.9648626810032 40.7804506112843)   19 4 19 13
869 -73.9629483374528 40.7936809905265 33A-PM-1018-03 33A PM 10182018 3 Adult Gray   Gray+   Above Ground 6   true false true false false   false false false false false false false true   POINT (-73.9629483374528 40.7936809905265)   19 4 19 13
884 -73.9678937289837 40.7782808361645 16E-PM-1018-01 16E PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9678937289837 40.7782808361645)   19 4 19 13
987 -73.9649827807341 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9649827807341 40.7817322832767)   19 4 19 13
995 -73.9698843507358 40.7803754187581 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9698843507358 40.7803754187581)   19 4 19 13
1147 -73.9631818528816 40.7925332194132 32A-AM-1018-01 32A AM 10182018 1 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631818528816 40.7925332194132)   19 4 19 13
1242 -73.9714512125212 40.7760275250114 13D-PM-1018-03 13D PM 10182018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true true   false false false false false false true false   POINT (-73.9714512125212 40.7760275250114)   19 4 19 13
1270 -73.967762162893 40.7823359027165 20C-PM-1018-08 20C PM 10182018 8 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false false   false false false false false true false true runs from (dog) POINT (-73.967762162893 40.7823359027165)   19 4 19 13
1338 -73.9716624574422 40.7762037110101 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   true false true false false scratching false false false false false false true false   POINT (-73.9716624574422 40.7762037110101)   19 4 19 13
1356 -73.9534910562766 40.7935774443789 37H-AM-1018-04 37H AM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false true false false true was with a lot of robins POINT (-73.9534910562766 40.7935774443789)   19 4 19 13
1370 -73.9681627331154 40.7785099665602 17E-PM-1018-02 17E PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE On the rock true false false false false   false false false false false false true false   POINT (-73.9681627331154 40.7785099665602)   19 4 19 13
1420 -73.9647605121306 40.7803961531517 20G-AM-1018-03 20G AM 10182018 3 Adult Gray   Gray+   Above Ground 12 in tree true false false false false   true false false false false false false false   POINT (-73.9647605121306 40.7803961531517)   19 4 19 13
1451 -73.9645365195454 40.7781531021263 18H-AM-1018-02 18H AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   Tree true true false false false playing? false false false false false false false false   POINT (-73.9645365195454 40.7781531021263)   19 4 19 13
1530 -73.9689305978751 40.7818152496266 19C-PM-1018-06 19C PM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 Climbed fence true false true false false climbing (fence) false false false false false false true false   POINT (-73.9689305978751 40.7818152496266)   19 4 19 13
1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9681874036914 40.7817948690964)   19 4 19 13
1736 -73.9743873549635 40.7745426051392 10C-AM-1018-04 10C AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9743873549635 40.7745426051392)   19 4 19 13
1889 -73.9679319758284 40.7821154802399 20C-PM-1018-07 20C PM 10182018 7 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false false false   POINT (-73.9679319758284 40.7821154802399)   19 4 19 13
1895 -73.954699659637 40.7951308856929 38F-AM-1018-02 38F AM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.954699659637 40.7951308856929)   19 4 19 13
1989 -73.9631646754647 40.7925716810884 32A-AM-1018-02 32A AM 10182018 2 Adult Gray   Gray+   Above Ground 15   true true false false false   false false false false false false true false   POINT (-73.9631646754647 40.7925716810884)   19 4 19 13
2018 -73.9697924026634 40.7803611152023 18C-PM-1018-04 18C PM 10182018 4 Juvenile Gray   Gray+   Above Ground 1   true true false false false   false false false false false false false true   POINT (-73.9697924026634 40.7803611152023)   19 4 19 13
2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false false cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)   19 4 19 13
2164 -73.955013129397 40.7954024311542 38F-AM-1018-05 38F AM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false ran up tree false false false false false false false true   POINT (-73.955013129397 40.7954024311542)   19 4 19 13
2170 -73.9678923667678 40.7819675626236 20C-PM-1018-05 20C PM 10182018 5 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9678923667678 40.781967562623606)   19 4 19 13
2294 -73.9630820577441 40.7821632293136 22G-PM-1018-01 22G PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false false true false   false false false true false false true false   POINT (-73.9630820577441 40.7821632293136)   19 4 19 13
2301 -73.968906907671 40.7816278267843 19C-PM-1018-07 19C PM 10182018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   true false true false false   false false false false false false false false   POINT (-73.968906907671 40.7816278267843)   19 4 19 13
2313 -73.9646174034945 40.7781287528262 18H-AM-1018-01 18H AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Running from one tree to the other true true false false false playing? false false false false false false false false   POINT (-73.9646174034945 40.7781287528262)   19 4 19 13
2407 -73.9555724351776 40.7967602498249 39E-AM-1018-03 39E AM 10182018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9555724351776 40.7967602498249)   19 4 19 13
2422 -73.9683066605832 40.7781213930544 16E-PM-1018-03 16E PM 10182018 3 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9683066605832 40.7781213930544)   19 4 19 13
2444 -73.966590487009 40.7802469052891 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false true false false false false   POINT (-73.96659048700901 40.7802469052891)   19 4 19 13
2522 -73.9658747245917 40.7754033737532 14I-PM-1018-01 14I PM 10182018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground   Fallen branch true false false false true   false false false false true false false true   POINT (-73.9658747245917 40.7754033737532)   19 4 19 13
2543 -73.9691424997919 40.780542852496 18C-AM-1018-02 18C AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9691424997919 40.780542852496)   19 4 19 13
2581 -73.9635981227569 40.7928169540326 32A-AM-1018-05 32A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9635981227569 40.7928169540326)   19 4 19 13
2611 -73.951448051873 40.7973951649254 42G-AM-1018-02 42G AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.951448051873 40.7973951649254)   19 4 19 13
2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.954499539822 40.7949716693686)   19 4 19 13
2676 -73.9692849074642 40.7708755098145 9H-PM-1018-06 09H PM 10182018 6 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692849074642 40.7708755098145)   19 4 19 13
2687 -73.9550235589287 40.7951312356844 38F-AM-1018-03 38F AM 10182018 3 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.9550235589287 40.7951312356844)   19 4 19 13
2703 -73.9690174442945 40.7817617696508 19C-PM-1018-05 19C PM 10182018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.9690174442945 40.7817617696508)   19 4 19 13
2772 -73.9677368646039 40.7821550964837 20C-PM-1018-06 20C PM 10182018 6 Juvenile Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.96773686460392 40.782155096483706)   19 4 19 13
2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9647845655965 40.7816573808695)   19 4 19 13
2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   true false false true false false false true   POINT (-73.9712187890707 40.7750640173134)   19 4 19 13
2822 -73.9711120079542 40.7760801911766 13D-PM-1018-14 13D PM 10182018 14 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   true false true false false climbing (down) false false false false false false true false   POINT (-73.9711120079542 40.7760801911766)   19 4 19 13
2838 -73.9507699667119 40.7955166039555 40I-AM-1018-02 40I AM 10182018 2 Adult Cinnamon   Cinnamon+   Ground Plane FALSE   true false false false true   false false false false false false true false   POINT (-73.9507699667119 40.795516603955505)   19 4 19 13
2897 -73.9689554458632 40.7778593393957 16E-PM-1018-10 16E PM 10182018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false false false false   false false false false false false true false   POINT (-73.9689554458632 40.7778593393957)   19 4 19 13
2930 -73.9692563597762 40.770904999952 9H-PM-1018-05 09H PM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true true false false false   false false false false false false false false   POINT (-73.9692563597762 40.770904999952)   19 4 19 13
2991 -73.9684632673603 40.7848909525198 23A-AM-1018-05 23A AM 10182018 5 Adult Gray   Gray+   Ground Plane FALSE   true false false false false   false false false false false false false true   POINT (-73.9684632673603 40.7848909525198)   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 161.325ms