squirrels

12 rows where Date = 10062018 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, Color notes, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Quaas, Tail flags, Indifferent, Runs from, Other Interactions

Kuks

  • true · 12

Date

  • 10062018 · 12
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
260 -73.978436117932 40.7724769242403 6A-AM-1006-06 06A AM 10062018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 15 tree false false true false false   true false false false false false false false   POINT (-73.978436117932 40.7724769242403)   19 4 19 13
471 -73.9707215394887 40.7727508149058 10G-AM-1006-05 10G AM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   false true false false false chasing (#6) true false false false false false false false   POINT (-73.9707215394887 40.7727508149058)   19 4 19 13
476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree false false false false false   true true false false false false false false not backing down POINT (-73.9690968160819 40.769923269444)   19 4 19 13
504 -73.9533476020736 40.7933003544685 37H-PM-1006-02 37H PM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE tree true false true false true   true false false false false false false true dogs POINT (-73.9533476020736 40.7933003544685)   19 4 19 13
935 -73.9666195118963 40.7839216739357 22C-PM-1006-10 22C PM 10062018 10 Adult Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666195118963 40.78392167393571)   19 4 19 13
1172 -73.9706929270645 40.7727841119424 10G-AM-1006-06 10G AM 10062018 6 Juvenile Gray   Gray+ skinny tail Ground Plane FALSE   false true false false false chasing (#5) true false false false false false false false   POINT (-73.9706929270645 40.7727841119424)   19 4 19 13
1302 -73.9704024529864 40.7729256063889 10G-AM-1006-04 10G AM 10062018 4 Juvenile Gray White Gray+White   Ground Plane FALSE   false true false false false chasing (#3) true false false false false false false false   POINT (-73.9704024529864 40.7729256063889)   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
1596 -73.9666945123922 40.7839956493194 22C-PM-1006-11 22C PM 10062018 11 Juvenile Gray   Gray+   Above Ground 13   false false true false false   true false false false false false false false   POINT (-73.9666945123922 40.7839956493194)   19 4 19 13
1774 -73.9668909481942 40.7841298584027 22C-PM-1006-12 22C PM 10062018 12 Adult Gray   Gray+   Ground Plane FALSE   false false false true false   true false false false false false false false human friendly POINT (-73.9668909481942 40.7841298584027)   19 4 19 13
1931 -73.9533085932603 40.7934877861075 37H-PM-1006-03 37H PM 10062018 3       +   Above Ground 43 tree false false true false false   true false false false false false false false   POINT (-73.9533085932603 40.7934877861075)   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

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 58.257ms