squirrels

9 rows where Climbing = "false", Hectare Squirrel Number = 1 and Kuks = "true"

View and edit SQL

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

Kuks

  • true · 9

Hectare Squirrel Number

Climbing

  • false · 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
433 -73.9558474701153 40.7913335515534 34H-AM-1007-01 34H AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40 tree false false false false false   true true false false false false false false   POINT (-73.9558474701153 40.7913335515534)   19 4 19 13
512 -73.9586098170241 40.7939653733898 35D-AM-1019-01 35D AM 10192018 1       +   Above Ground   on tree, blue jays gathering nearby false false false false false   true false false false false false false false   POINT (-73.9586098170241 40.7939653733898)   19 4 19 13
769 -73.976521916284 40.773784724458 9B-AM-1010-01 09B AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   false false false false true   true false false false false false false true   POINT (-73.976521916284 40.773784724458)   19 4 19 13
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
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
1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   true true false false false   true false false false false false true false   POINT (-73.9693209851947 40.7707450042769)   19 4 19 13
2142 -73.9598535425706 40.7915589343685 33D-PM-1006-01 33D PM 10062018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 15   false true false false false hanging on fence true false false true false false false true   POINT (-73.9598535425706 40.7915589343685)   19 4 19 13
2327 -73.9567801028221 40.7960096659564 38D-AM-1017-01 38D AM 10172018 1       +   Above Ground 30   false false false false false   true false false false false false false false   POINT (-73.9567801028221 40.7960096659564)   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 4549.907ms