squirrels

14 rows where Above Ground Sighter Measurement = 30, Combination of Primary and Highlight Color = "Gray+" and Indifferent = "false"

View and edit SQL

Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Specific Location, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, 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
39 -73.9716147061553 40.7813911036179 18A-PM-1018-01 18A PM 10182018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9716147061553 40.7813911036179)   19 4 19 13
480 -73.9641293283734 40.7907654006019 30B-AM-1007-03 30B AM 10072018 3 Adult Gray   Gray+   Above Ground 30   true false false false false   false false false false false false false false   POINT (-73.9641293283734 40.7907654006019)   19 4 19 13
496 -73.9548430741605 40.798207350942 41E-AM-1007-06 41E AM 10072018 6 Adult Gray   Gray+   Above Ground 30 tree false false true false true   false false false false false false false false   POINT (-73.9548430741605 40.798207350942)   19 4 19 13
1046 -73.9647891228606 40.789853066039 29B-AM-1007-02 29B AM 10072018 2 Adult Gray   Gray+   Above Ground 30   true false false false false   false false false true false false false false   POINT (-73.9647891228606 40.789853066039)   19 4 19 13
1144 -73.9743184653765 40.7667932997 3G-AM-1008-01 03G AM 10082018 1 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9743184653765 40.7667932997)   19 4 19 13
1355 -73.9655277320465 40.7806120529369 20F-AM-1014-03 20F AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   true false false false false false false false   POINT (-73.9655277320465 40.7806120529369)   19 4 19 13
1890 -73.9787723082807 40.7713655754004 5A-PM-1010-03 05A PM 10102018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9787723082807 40.7713655754004)   19 4 19 13
1951 -73.9548431601579 40.7906346271566 34I-PM-1010-02 34I PM 10102018 2 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9548431601579 40.7906346271566)   19 4 19 13
1994 -73.9598463837775 40.7834524724254 25I-PM-1007-05 25I PM 10072018 5 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9598463837775 40.7834524724254)   19 4 19 13
2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   false false true false false   false false false false false false false false   POINT (-73.9704328573603 40.7739347247552)   19 4 19 13
2420 -73.9587787592751 40.7981699014259 40A-AM-1010-01 40A AM 10102018 1 Juvenile Gray   Gray+   Above Ground 30 bottom of great hill false false true false false   false false false false false false false false climbing up a tree POINT (-73.9587787592751 40.7981699014259)   19 4 19 13
2499 -73.9690079924094 40.7845473505585 22A-AM-1008-06 22A AM 10082018 6 Adult Gray   Gray+   Above Ground 30   false false false true false   false false false false false false false false   POINT (-73.9690079924094 40.7845473505585)   19 4 19 13
2933 -73.9677903197449 40.7826561917755 21C-AM-1014-03 21C AM 10142018 3 Adult Gray   Gray+   Above Ground 30   false true true false false   false true false false false false false false looked at us from tree POINT (-73.9677903197449 40.7826561917755)   19 4 19 13
3011 -73.9678831312936 40.7847605974975 23B-PM-1012-06 23B PM 10122018 6 Adult Gray   Gray+   Above Ground 30   false false false false false   true false false false false false false false scolding POINT (-73.9678831312936 40.7847605974975)   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 81.362ms