squirrels

52 rows where Date = 10182018, Foraging = "false" and Shift = "AM" sorted by Approaches

View and edit SQL

Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Indifferent, Runs from, Other Interactions

Combination of Primary and Highlight Color

Shift

Police Precincts

Foraging

  • false · 52

Date

  • 10182018 · 52
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
5 -73.9593126695714 40.797533370163 39B-AM-1018-01 39B AM 10182018 1       +   Above Ground     false false false false false unknown true false false false false false false false   POINT (-73.9593126695714 40.797533370163)   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
148 -73.9532620128307 40.7952475548048 39G-AM-1018-01 39G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false dead (something ran over it) false false false false false false false false   POINT (-73.9532620128307 40.7952475548048)   19 4 19 13
166 -73.963846339804 40.7834051716226 23F-AM-1018-01 23F AM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 30   false false true false false   false false false false false false true false   POINT (-73.963846339804 40.7834051716226)   19 4 19 13
258 -73.9534333425633 40.7932564163328 37H-AM-1018-03 37H AM 10182018 3 Adult Gray White Gray+White   Above Ground 10 in a tree with red berries false false false true false   false true false false false false false true   POINT (-73.9534333425633 40.7932564163328)   19 4 19 13
380 -73.9649590119935 40.7822107920769 21F-AM-1018-01 21F AM 10182018 1 Adult Gray   Gray+   Above Ground 15   false false true false false   false false false false true false true false   POINT (-73.9649590119935 40.7822107920769)   19 4 19 13
450 -73.9644293195773 40.7813829172072 21F-AM-1018-02 21F AM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false true false true false   POINT (-73.9644293195773 40.7813829172072)   19 4 19 13
488 -73.9615751148595 40.7954551238146 36A-AM-1018-01 36A AM 10182018 1 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9615751148595 40.7954551238146)   19 4 19 13
506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   false false true false false   false false false false true false false true   POINT (-73.9649611089685 40.7814371834837)   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
631 -73.9548877830136 40.7950157489103 38F-AM-1018-04 38F AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false true false false   false false false false false false false false   POINT (-73.95488778301362 40.7950157489103)   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
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
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
1007 -73.9635317822977 40.7821352080233 22G-AM-1018-01 22G AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false true false false false   true false false true false false true false   POINT (-73.9635317822977 40.7821352080233)   19 4 19 13
1053 -73.9685859705486 40.7848805065322 23A-AM-1018-04 23A AM 10182018 4 Adult Gray   Gray+   Above Ground 3 Tree false false true false false   false false false false false false false true   POINT (-73.9685859705486 40.7848805065322)   19 4 19 13
1061 -73.9532657715601 40.7949046809422 39G-AM-1018-02 39G AM 10182018 2 Juvenile Gray   Gray+   Above Ground 25 Tree false false false false false sitting & watching false false false false false false true false   POINT (-73.9532657715601 40.7949046809422)   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
1203 -73.9616999731028 40.7954126939561 36A-AM-1018-02 36A AM 10182018 2 Juvenile Gray White Gray+White   Above Ground 15   false false false true false eating (red berries) false false false false false false true false   POINT (-73.9616999731028 40.7954126939561)   19 4 19 13
1304 -73.9533319519277 40.7933647909449 37H-AM-1018-02 37H AM 10182018 2 Adult Gray   Gray+   Above Ground   Large tree by (fence of the conservatory) about to climb up false false true false false   false false false false false false false false busy,ready to climb POINT (-73.9533319519277 40.7933647909449)   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
1402 -73.9745009906157 40.7741574075364 10C-AM-1018-01 10C AM 10182018 1 Adult Gray   Gray+   Above Ground 5   false false true false false   false false false false false false true false   POINT (-73.9745009906157 40.7741574075364)   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
1509 -73.9556450015702 40.7967188058002 39E-AM-1018-04 39E AM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false true false false true false   POINT (-73.9556450015702 40.7967188058002)   19 4 19 13
1518 -73.9632265832593 40.7816914475461 22G-AM-1018-04 22G AM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   false false true false false   false false false false false false false false   POINT (-73.9632265832593 40.78169144754611)   19 4 19 13
1528 -73.9690104245067 40.7853358193723 23A-AM-1018-02 23A AM 10182018 2 Juvenile Black   Black+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690104245067 40.7853358193723)   19 4 19 13
1620 -73.9635606199784 40.782206970617 22G-AM-1018-03 22G AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9635606199784 40.782206970617)   19 4 19 13
1632 -73.9592392692535 40.7961869951798 37B-AM-1018-02 37B AM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   false false false false false false false true   POINT (-73.9592392692535 40.7961869951798)   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
1737 -73.9640741640547 40.7807274581426 20G-AM-1018-01 20G AM 10182018 1 Juvenile Gray   Gray+   Above Ground 7 Tree limb false false false false false sitting still on limb false false false false false false true false   POINT (-73.9640741640547 40.7807274581426)   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
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
2043 -73.9643223016635 40.781431908715 21F-AM-1018-03 21F AM 10182018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false false dead false false false false false false false true   POINT (-73.9643223016635 40.781431908715)   19 4 19 13
2130 -73.9695572903383 40.780822981713 18C-AM-1018-01 18C AM 10182018 1 Adult Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9695572903383 40.780822981713)   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
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
2374 -73.9551370586201 40.7946465469021 38F-AM-1018-06 38F AM 10182018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false hopped away false false false false false false false true   POINT (-73.95513705862011 40.7946465469021)   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
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
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
2577 -73.9597048490102 40.7955846466241 37B-AM-1018-06 37B AM 10182018 6 Adult Gray   Gray+   Above Ground 1   false false true false false   false true false false false false false true   POINT (-73.9597048490102 40.7955846466241)   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
2599 -73.9689893412693 40.785308737683 23A-AM-1018-03 23A AM 10182018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8 Tree false false true false false   false false false false false false true false   POINT (-73.9689893412693 40.785308737683)   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
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
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
2888 -73.955258162768 40.7958147673603 39E-AM-1018-01 39E AM 10182018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false standing still false false false false false false false true   POINT (-73.955258162768 40.7958147673603)   19 4 19 13
2941 -73.9690266660317 40.7853134751509 23A-AM-1018-01 23A AM 10182018 1 Juvenile Cinnamon   Cinnamon+   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9690266660317 40.7853134751509)   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 69.795ms