squirrels

12 rows where Date = 10082018, Indifferent = "false" and Tail twitches = "true"

✎ View and edit SQL

This data as json, CSV (advanced)

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, Running, Climbing, Eating, Foraging, Kuks, Approaches, 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
342 342 -73.9605966636226 40.7889849108637 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   false false false false true false false true scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)   19 4 19 13
376 376 -73.9698817079185 40.7758322627711 13E-PM-1008-10 13E PM 10082018 10 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true true   false false false false true false false true   POINT (-73.9698817079185 40.7758322627711)   19 4 19 13
647 647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   false false true false false   false false false false true false false false   POINT (-73.9734762649298 40.7663703404546)   19 4 19 13
929 929 -73.9738611257716 40.7737246779587 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false false false true   true false false false true false false true   POINT (-73.9738611257716 40.7737246779587)   19 4 19 13
982 982 -73.9676424599715 40.7777766106807 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence false false false false true   false false false false true true false false   POINT (-73.9676424599715 40.7777766106807)   19 4 19 13
1079 1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree true false true false false   false false false false true false false true   POINT (-73.9722737593623 40.768963018754)   19 4 19 13
1214 1214 -73.9699517492486 40.7753169595373 13F-PM-1008-01 13F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   false false false true true   false false false false true true false false   POINT (-73.9699517492486 40.7753169595373)   19 4 19 13
1237 1237 -73.9705370795538 40.7761725434851 13E-PM-1008-04 13E PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Gray selected as Highlights. Made executive adjustments. Ground Plane FALSE   false false false false true   false false false false true false false false he took 2 steps then turned and stared at me POINT (-73.9705370795538 40.7761725434851)   19 4 19 13
1593 1593 -73.9676539688726 40.7777229934129 16F-AM-1008-02 16F AM 10082018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE near fence false false false false true   false false false false true false false false   POINT (-73.9676539688726 40.7777229934129)   19 4 19 13
2218 2218 -73.9694382427984 40.7846350692923 22A-AM-1008-04 22A AM 10082018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   false false false false true   false false false false true false false true   POINT (-73.9694382427984 40.7846350692923)   19 4 19 13
2271 2271 -73.9673949458096 40.7826218539496 21D-AM-1008-04 21D AM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   true false false false false   false false false false true false false true   POINT (-73.9673949458096 40.78262185394961)   19 4 19 13
2515 2515 -73.9693338657183 40.7757055884538 13F-PM-1008-05 13F PM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 tree trunk true false false true true   true false false false true false false false   POINT (-73.9693338657183 40.77570558845381)   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.301ms