squirrels

27 rows where Date = 10182018 and Highlight Fur Color = "White" sorted by Chasing

✎ View and edit SQL

This data as json, CSV (advanced)

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

Foraging ✖

Highlight Fur Color ✖

  • White · 27 ✖

Date ✖

  • 10182018 · 27 ✖
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
164 164 -73.9758676144255 40.7701671581939 5D-PM-1018-03 05D PM 10182018 3 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9758676144255 40.7701671581939)   19 4 19 13
258 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
467 467 -73.9579724119943 40.7948709900016 37D-AM-1018-01 37D AM 10182018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579724119943 40.7948709900016)   19 4 19 13
469 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
488 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
556 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
710 710 -73.9695569897042 40.7712062147171 9H-PM-1018-01 09H PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false   false false false false false false true false   POINT (-73.96955698970422 40.7712062147171)   19 4 19 13
865 865 -73.9741621946917 40.7752481472025 11C-PM-1018-01 11C PM 10182018 1 Adult Gray White Gray+White   Above Ground 10   false false true false false   false false false false false false false true   POINT (-73.9741621946917 40.7752481472025)   19 4 19 13
1085 1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9722265046794 40.7700916895929)   19 4 19 13
1092 1092 -73.9711319254625 40.7760324859879 13D-PM-1018-12 13D PM 10182018 12 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9711319254625 40.776032485987905)   19 4 19 13
1133 1133 -73.9712550584322 40.7764273475386 13D-PM-1018-06 13D PM 10182018 6 Adult Gray White Gray+White   Above Ground 10   false false true false false cleaning false false false false false false true false   POINT (-73.9712550584322 40.7764273475386)   19 4 19 13
1203 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
1356 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
1541 1541 -73.9711617997772 40.7761212878075 13D-PM-1018-04 13D PM 10182018 4 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true digging false false false false false false true false   POINT (-73.9711617997772 40.7761212878075)   19 4 19 13
1787 1787 -73.9720365327715 40.7762329714016 13D-PM-1018-11 13D PM 10182018 11 Adult Gray White Gray+White   Above Ground 15   false false true true false   false false false false true false true false   POINT (-73.9720365327715 40.7762329714016)   19 4 19 13
1889 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
1978 1978 -73.9579689996645 40.7949338489917 37D-AM-1018-02 37D AM 10182018 2 Juvenile Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9579689996645 40.7949338489917)   19 4 19 13
2099 2099 -73.9685612289881 40.7778488829217 16E-PM-1018-08 16E PM 10182018 8 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false false true   false false false false true false true false   POINT (-73.9685612289881 40.7778488829217)   19 4 19 13
2125 2125 -73.9687933229572 40.7788600242549 17E-PM-1018-01 17E PM 10182018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false true true   false false false false false false true false   POINT (-73.9687933229572 40.7788600242549)   19 4 19 13
2171 2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk false false true false false   false false false false true false true false   POINT (-73.9686370726471 40.7780382348833)   19 4 19 13
2189 2189 -73.9761776424664 40.7695941843825 5D-PM-1018-07 05D PM 10182018 7 Adult Gray White Gray+White   Ground Plane FALSE   false false false true false   false false false false false false true false   POINT (-73.9761776424664 40.7695941843825)   19 4 19 13
2444 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
2582 2582 -73.9665004148497 40.7805656411756 19E-PM-1018-05 19E PM 10182018 5   Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false false false true false   POINT (-73.9665004148497 40.7805656411756)   19 4 19 13
2794 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
2897 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
82 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
627 627 -73.9763791121438 40.770281512254 5D-PM-1018-04 05D PM 10182018 4 Adult Gray White Gray+White Partial missing tail Ground Plane FALSE   false true false false false chasing (dog chasing) false false false false false false false true   POINT (-73.9763791121438 40.770281512254)   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 139.99ms