2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Approaches = 1, Foraging = 0 and Hectare Squirrel Number = 2 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Runs from

Tail twitches

Hectare Squirrel Number

Foraging

Approaches

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
1075 -73.9640534906634 40.777738389983604 17I-AM-1014-02 17I AM 10142018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 0 0 0 standing upright 0 0 0 0 0 1 0 1 runs from (only ran away when a grandpa chased it off) POINT (-73.9640534906634 40.7777383899836)
882 -73.9786805884996 40.769755923192704 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786805884996 40.7697559231927)
2762 -73.9656324462902 40.783403475308106 22E-PM-1014-02 22E PM 10142018 2 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9656324462902 40.7834034753081)
738 -73.9725712588741 40.7669101832926 4H-AM-1006-02 04H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0 climbing (over small wire fence then on the ground) 0 0 0 0 0 1 0 1 approaches (saw me & came forward),runs from (startled by another person) POINT (-73.9725712588741 40.7669101832926)
797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.969345754447 40.7770429650288)
2380 -73.97613757295049 40.766223189212496 1F-PM-1019-02 01F PM 10192018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9761375729505 40.7662231892125)
230 -73.97314980648721 40.7659963196581 2H-AM-1006-02 02H AM 10062018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9731498064872 40.7659963196581)
1721 -73.95873307074629 40.7907682009641 32F-AM-1012-02 32F AM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray patches on back legs Ground Plane FALSE   0 0 0 0 0 curious about me 0 0 0 0 0 1 0 1   POINT (-73.9587330707463 40.7907682009641)
2068 -73.9735587560787 40.7672346255151 3G-PM-1013-02 03G PM 10132018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 0 wandering,interacting with tourists 0 0 0 0 0 1 0 0 approaches (father - son taking photos,talking about giving him planters peanuts) POINT (-73.9735587560787 40.7672346255151)
859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "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" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);
Powered by Datasette · Query took 153.548ms