squirrels

15 rows where Date = 10062018, Highlight Fur Color = "White", Indifferent = "false" and Runs from = "false"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary 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, Tail flags, Tail twitches, Approaches, 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
137 137 -73.9782417115139 40.7724665036447 7A-AM-1006-01 07A AM 10062018 1 Adult Gray White Gray+White   Above Ground 10 in tree false false false false true   false true false false true false false false looked at us POINT (-73.9782417115139 40.7724665036447)   19 4 19 13
589 589 -73.97826438139 40.7717086090782 6A-AM-1006-04 06A AM 10062018 4 Adult Gray White Gray+White   Ground Plane FALSE   false true false false true   false false false false true false false false curious POINT (-73.97826438139 40.7717086090782)   19 4 19 13
1204 1204 -73.9762965341309 40.775112516678 10A-AM-1006-02 10A AM 10062018 2 Adult Gray White Gray+White   Ground Plane FALSE Bridle Path lawn true false false false false   false false false false false false false false   POINT (-73.9762965341309 40.775112516678)   19 4 19 13
1302 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
1549 1549 -73.9777978497894 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false true false true   false false false false true false false false   POINT (-73.9777978497894 40.7668620784309)   19 4 19 13
1650 1650 -73.9762494239719 40.7750175306716 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields false false false true false eating (a peanut) false false false false false true false false   POINT (-73.9762494239719 40.7750175306716)   19 4 19 13
1685 1685 -73.9678822983274 40.7802960985637 18E-PM-1006-01 18E PM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false false false false   POINT (-73.9678822983274 40.7802960985637)   19 4 19 13
1756 1756 -73.9755041276839 40.7678213857557 3F-AM-1006-13 03F AM 10062018 13 Juvenile Gray White Gray+White   Ground Plane FALSE   true false false false true   false false false false false true false false   POINT (-73.9755041276839 40.7678213857557)   19 4 19 13
1983 1983 -73.9784144867639 40.7718177667511 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   false false true true true   false false false false false false false false   POINT (-73.9784144867639 40.7718177667511)   19 4 19 13
2044 2044 -73.9771552326199 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   true false true false false   false false false true false true false false   POINT (-73.9771552326199 40.7706917595308)   19 4 19 13
2087 2087 -73.956502663005 40.788160908881 30I-PM-1006-05 30I PM 10062018 5 Adult Gray White Gray+White   Ground Plane FALSE   true false false false false   false false false false false true false false   POINT (-73.956502663005 40.788160908881)   19 4 19 13
2103 2103 -73.9782983634755 40.7668314364263 1D-AM-1006-04 01D AM 10062018 4 Adult Gray White Gray+White   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9782983634755 40.7668314364263)   19 4 19 13
2344 2344 -73.9786310308892 40.7669349368183 1D-AM-1006-05 01D AM 10062018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   false false false true false   false false false false true false false false   POINT (-73.9786310308892 40.7669349368183)   19 4 19 13
2503 2503 -73.974382557804 40.7674812627373 3F-AM-1006-10 03F AM 10062018 10 Adult Cinnamon White Cinnamon+White   Above Ground 6 on fence false false true false false   false false false false false false false false clueless POINT (-73.974382557804 40.7674812627373)   19 4 19 13
2766 2766 -73.9551639847466 40.790858199891 34H-PM-1006-03 34H PM 10062018 3   Gray White Gray+White white belly Ground Plane FALSE Under Tupelo Tree false false false true false   false false false false true false false false   POINT (-73.9551639847466 40.790858199891)   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 53.512ms