squirrels

9 rows where Indifferent = "true" and Specific Location = "in tree"

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Climbing, Eating, Foraging, Other Activities, Kuks

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
460 -73.9549135206961 40.798525897229 42D-PM-1013-03 42D PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 25 in tree false false false true false   false false false false false false true false   POINT (-73.9549135206961 40.798525897229)   19 4 19 13
505 -73.9677387336667 40.7742695912 12H-PM-1007-02 12H PM 10072018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 in tree false false true true false peanuts false false false false false false true false   POINT (-73.9677387336667 40.7742695912)   19 4 19 13
1227 -73.9527924755398 40.7934366260533 37I-AM-1010-04 37I AM 10102018 4 Adult Gray   Gray+   Above Ground 50 in tree false false true false false   false false false false false false true false   POINT (-73.9527924755398 40.7934366260533)   19 4 19 13
1239 -73.9725897240269 40.7691342079294 6G-AM-1008-01 06G AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 in tree false false false false false sitting false false false false false false true false   POINT (-73.9725897240269 40.7691342079294)   19 4 19 13
1253 -73.9527227282134 40.7935061484064 37I-AM-1010-03 37I AM 10102018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 in tree false false true false false   false false false false false false true false   POINT (-73.9527227282134 40.7935061484064)   19 4 19 13
1727 -73.9692472299565 40.7722592187215 10H-PM-1007-01 10H PM 10072018 1 Adult Gray White Gray+White dark gray Above Ground 15 in tree false false true false false   false false false false false false true false   POINT (-73.9692472299565 40.7722592187215)   19 4 19 13
1857 -73.9728797531377 40.7786733148687 15B-PM-1017-01 15B PM 10172018 1   Gray   Gray+   Above Ground 20 in tree false false true false true   false false false false false false true false   POINT (-73.9728797531377 40.7786733148687)   19 4 19 13
1921 -73.9756278240233 40.7669523701372 2F-AM-1006-02 02F AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 in tree false false true false false   false false false false false false true false   POINT (-73.9756278240233 40.7669523701372)   19 4 19 13
2069 -73.9538377039825 40.7980605334961 42E-PM-1012-03 42E PM 10122018 3 Adult Gray White Gray+White   Above Ground 20 in tree false false true false true   true false false false false false true false   POINT (-73.9538377039825 40.7980605334961)   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 80.082ms