squirrels

27 rows where Date = 10132018, Foraging = "false" and Tail twitches = "true" sorted by Approaches

View and edit SQL

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

Running

Tail twitches

  • true · 27

Police Precincts

Foraging

  • false · 27

Date

  • 10132018 · 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
27 -73.9670628558161 40.7734991420941 12I-AM-1013-01 12I AM 10132018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE on tree roots false false false false false sitting false false false false true false false true   POINT (-73.9670628558161 40.77349914209411)   19 4 19 13
58 -73.9704082821356 40.7690280985956 6I-PM-1013-06 06I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false playing with #5 false false false false true false false false   POINT (-73.9704082821356 40.7690280985956)   19 4 19 13
109 -73.967097592707 40.7854119342538 24B-AM-1013-01 24B AM 10132018 1   Gray   Gray+   Above Ground 50   true false false true false took nut to bury false false false false true false false true   POINT (-73.967097592707 40.7854119342538)   19 4 19 13
361 -73.9614824437251 40.7912929799884 32C-PM-1013-03 32C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9614824437251 40.7912929799884)   19 4 19 13
567 -73.9756972647636 40.773624164826 9B-PM-1013-04 09B PM 10132018 4 Juvenile Gray Black Gray+Black   Above Ground 30   false false true false false   false false false false true false true false   POINT (-73.9756972647636 40.773624164826)   19 4 19 13
622 -73.9754836796706 40.7738879545412 9B-PM-1013-01 09B PM 10132018 1 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false false playing false false false false true false true false   POINT (-73.9754836796706 40.7738879545412)   19 4 19 13
628 -73.9600165785486 40.7952466761832 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true true false false false   false false false false true false false true   POINT (-73.9600165785486 40.7952466761832)   19 4 19 13
856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree false false true false false   false false false false true false true false   POINT (-73.95916671628011 40.7937602121568)   19 4 19 13
979 -73.9612349421547 40.7959586475744 36A-PM-1013-09 36A PM 10132018 9   Gray   Gray+   Ground Plane FALSE THICK UNDERGROWTH true false false false false   false false false false true false false true   POINT (-73.9612349421547 40.7959586475744)   19 4 19 13
1157 -73.9704449096084 40.7689970778303 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   false false false false false playing with #6 false false false false true false false false   POINT (-73.9704449096084 40.7689970778303)   19 4 19 13
1188 -73.9669529835992 40.7871864151365 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO true false true false false d.p.t. false false false true true false true false calm POINT (-73.96695298359921 40.7871864151365)   19 4 19 13
1202 -73.9694979297007 40.7694667408721 7I-PM-1013-02 07I PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE Construction materials true false false false false   false false false false true false false false   POINT (-73.9694979297007 40.7694667408721)   19 4 19 13
1296 -73.9705509170542 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass false false false true false   false false false false true false false false   POINT (-73.9705509170542 40.7689416540228)   19 4 19 13
1553 -73.9690645326017 40.7773822116124 15E-AM-1013-03 15E AM 10132018 3 Adult Gray   Gray+   Above Ground 2 on fallen log false false false false false   false false false false true false false true   POINT (-73.9690645326017 40.7773822116124)   19 4 19 13
1585 -73.9611312355348 40.7950130863913 36A-PM-1013-04 36A PM 10132018 4   Gray White Gray+White   Ground Plane FALSE ON ROCK NEAR POND false false false false false sitting false false false false true false true false   POINT (-73.9611312355348 40.7950130863913)   19 4 19 13
1797 -73.9697178096275 40.7697036696301 7I-PM-1013-07 07I PM 10132018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE Under the tree false true false false false playing,interacting with #6 false false false false true false false false   POINT (-73.9697178096275 40.769703669630104)   19 4 19 13
1872 -73.9613998967903 40.7912437235667 32C-PM-1013-02 32C PM 10132018 2 Adult Gray   Gray+   Ground Plane FALSE   false true false false false   false false false false true false false false   POINT (-73.9613998967903 40.7912437235667)   19 4 19 13
1894 -73.9699780857298 40.7688706046944 6I-PM-1013-01 06I PM 10132018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   true false false false false   false false false false true false true false   POINT (-73.9699780857298 40.7688706046944)   19 4 19 13
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree false false true false false   false false false false true false false true   POINT (-73.9540151828782 40.7920066170587)   19 4 19 13
2274 -73.9698044218476 40.7697007833531 7I-PM-1013-06 07I PM 10132018 6 Adult Cinnamon   Cinnamon+ "Brown" written in as Primary Ground Plane FALSE Under the tree false false false true false playing,interacting with #7 false false false false true false false true   POINT (-73.9698044218476 40.7697007833531)   19 4 19 13
2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   false false true false false   false false false false true false false false   POINT (-73.9700101107283 40.7696729501144)   19 4 19 13
2606 -73.96143417385 40.7945464262112 35B-PM-1013-02 35B PM 10132018 2 Juvenile     +   Ground Plane FALSE   false false false true false did not notice dog sitting a few yards away (10-20 ft) false false false false true false true false   POINT (-73.96143417385 40.7945464262112)   19 4 19 13
2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree false false false true false   false false false false true false true false   POINT (-73.972179947936 40.7810042827198)   19 4 19 13
2855 -73.9690832219322 40.782343340986 20B-PM-1013-06 20B PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   false true false false false   false false false false true false true false   POINT (-73.96908322193221 40.782343340986)   19 4 19 13
859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   true false true false false   false false false false true true false true   POINT (-73.9600964585868 40.7952339524416)   19 4 19 13
1294 -73.9604089940153 40.7910028063138 32D-AM-1013-04 32D AM 10132018 4 Adult Cinnamon   Cinnamon+ Brown legs Ground Plane FALSE   true false false false false   false false false false true true false true   POINT (-73.9604089940153 40.7910028063138)   19 4 19 13
2030 -73.9749251267433 40.7679111971294 4F-PM-1013-01 04F PM 10132018 1 Adult Cinnamon Gray, Black Cinnamon+Gray, Black   Ground Plane FALSE   false false false true false   false false false false true true false false   POINT (-73.9749251267433 40.7679111971294)   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 81.536ms