squirrels

20 rows where Above Ground Sighter Measurement = 10, Combination of Primary and Highlight Color = "Gray+" and Indifferent = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Color notes, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Tail twitches, Runs from, Other Interactions

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
100 100 -73.9761592532482 40.7747213585387 10A-AM-1006-04 10A AM 10062018 4 Juvenile Gray   Gray+   Above Ground 10 tree near large rock on Bridle Path false false false false false walking on branch false false false false true false false false   POINT (-73.9761592532482 40.7747213585387)   19 4 19 13
281 281 -73.9619411917909 40.7923536640283 33B-PM-1010-11 33B PM 10102018 11 Adult Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9619411917909 40.7923536640283)   19 4 19 13
890 890 -73.9667755678511 40.7760256836088 15H-PM-1008-02 15H PM 10082018 2 Adult Gray   Gray+   Above Ground 10 oak tree false true true false false   false false false false false false false true   POINT (-73.9667755678511 40.7760256836088)   19 4 19 13
896 896 -73.9755055978764 40.7707438681742 6D-AM-1008-02 06D AM 10082018 2 Juvenile Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9755055978764 40.7707438681742)   19 4 19 13
983 983 -73.9641552070803 40.7908479527923 30B-AM-1007-05 30B AM 10072018 5 Adult Gray   Gray+   Above Ground 10   true false false false false   false false false false false false false false   POINT (-73.9641552070803 40.7908479527923)   19 4 19 13
1206 1206 -73.9748709206354 40.77608025411 11B-PM-1014-01 11B PM 10142018 1 Adult Gray   Gray+ Fat! Above Ground 10   false false true false false   true false false false false false false true   POINT (-73.9748709206354 40.77608025411)   19 4 19 13
1263 1263 -73.9770873939997 40.7710379662106 6C-PM-1020-02 06C PM 10202018 2 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9770873939997 40.7710379662106)   19 4 19 13
1280 1280 -73.9562469727195 40.79685907654 39D-AM-1008-04 39D AM 10082018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9562469727195 40.79685907654)   19 4 19 13
1313 1313 -73.9671813866177 40.7838640032038 22C-PM-1006-04 22C PM 10062018 4 Juvenile Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9671813866177 40.7838640032038)   19 4 19 13
1329 1329 -73.9772164524209 40.7688399538756 3D-AM-1006-06 03D AM 10062018 6   Gray   Gray+   Above Ground 10 tree true false true false false   false false false false false false false false did not run from humans,but ran straight to tree & climbed up POINT (-73.9772164524209 40.7688399538756)   19 4 19 13
1365 1365 -73.9791648157033 40.767625444347 2C-AM-1010-04 02C AM 10102018 4 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9791648157033 40.767625444347)   19 4 19 13
1378 1378 -73.9669762657479 40.7835913293646 22C-PM-1006-08 22C PM 10062018 8 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669762657479 40.7835913293646)   19 4 19 13
1673 1673 -73.9746940851342 40.7760966488186 11B-PM-1014-02 11B PM 10142018 2 Juvenile Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746940851342 40.7760966488186)   19 4 19 13
1831 1831 -73.9746877519291 40.7761402808083 11B-PM-1014-03 11B PM 10142018 3   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.9746877519291 40.7761402808083)   19 4 19 13
1926 1926 -73.9742811484852 40.775533619083 11B-PM-1014-08 11B PM 10142018 8   Gray   Gray+   Above Ground 10   false true false false false   false false false false false false false false   POINT (-73.97428114848522 40.775533619083)   19 4 19 13
2292 2292 -73.9669891940463 40.7835635162331 22C-PM-1006-07 22C PM 10062018 7 Adult Gray   Gray+   Above Ground 10   false false true false false   false false false false false false false false   POINT (-73.9669891940463 40.7835635162331)   19 4 19 13
2334 2334 -73.9754922970511 40.7707686392991 6D-AM-1008-03 06D AM 10082018 3 Juvenile Gray   Gray+   Above Ground 10   false false false false false   false false false false false false false false   POINT (-73.9754922970511 40.7707686392991)   19 4 19 13
2403 2403 -73.9777879635216 40.769359455673 4C-AM-1006-03 04C AM 10062018 3 Juvenile Gray   Gray+   Above Ground 10   false false false false true   false false false false false false false false   POINT (-73.9777879635216 40.769359455673)   19 4 19 13
2707 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
2893 2893 -73.9793101482654 40.7692600238491 3B-PM-1007-02 03B PM 10072018 2 Adult Gray   Gray+   Above Ground 10 in tree false false false false false chased by dog false false false false false false false false   POINT (-73.9793101482654 40.7692600238491)   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 55.182ms