squirrels

9 rows where Date = 10182018 and Kuks = "true"

View and edit SQL

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

Kuks

  • true · 9

Date

  • 10182018 · 9
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
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
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
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
1262 -73.9683345414813 40.7779016280345 16E-PM-1018-07 16E PM 10182018 7 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 10   false false true false false   true false false false false false true false   POINT (-73.9683345414813 40.7779016280345)   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
2712 -73.9682760864462 40.7780727569417 16E-PM-1018-04 16E PM 10182018 4 Adult Gray   Gray+   Ground Plane FALSE   false false false false true   true false false false false false true false   POINT (-73.9682760864462 40.7780727569417)   19 4 19 13
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
2960 -73.962524814515 40.7810022923615 21H-PM-1018-03 21H PM 10182018 3 Adult Gray   Gray+   Above Ground 25   false false true false false   true false false false false false true false   POINT (-73.962524814515 40.7810022923615)   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 76.705ms