2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Above Ground Sighter Measurement = 5, Climbing = 1 and Shift = "AM" sorted by Eating

View and edit SQL

Suggested facets: Hectare, Date, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging, Kuks, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Shift

Climbing

Above Ground Sighter Measurement

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
212 -73.9638837160341 40.7809747900833 21G-AM-1014-07 21G AM 10142018 7 Adult Gray White Gray+White   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638837160341 40.7809747900833)
388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9592537496995 40.7919271821316)
665 -73.95636612568751 40.796682311450795 39D-AM-1008-03 39D AM 10082018 3 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9563661256875 40.7966823114508)
666 -73.96870277827259 40.770516261619896 9I-AM-1014-09 09I AM 10142018 9 Adult Gray   Gray+   Above Ground 5   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.96870277827261 40.7705162616199)
696 -73.96560981941491 40.7757643078973 15I-AM-1008-05 15I AM 10082018 5 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9656098194149 40.7757643078973)
764 -73.9746608786299 40.7776092078254 13A-AM-1017-01 13A AM 10172018 1 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9746608786299 40.7776092078254)
771 -73.9648626810032 40.7804506112843 20G-AM-1018-02 20G AM 10182018 2 Adult Gray   Gray+   Above Ground 5 Ran up tree 1 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9648626810032 40.7804506112843)
1032 -73.96328685617941 40.7907806312915 30B-AM-1007-06 30B AM 10072018 6 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9632868561794 40.7907806312915)
1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638599044346 40.7809288795308)
1402 -73.9745009906157 40.7741574075364 10C-AM-1018-01 10C AM 10182018 1 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9745009906157 40.7741574075364)
1507 -73.9699799501516 40.7736576286234 11F-AM-1013-02 11F AM 10132018 2 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699799501516 40.7736576286234)
1921 -73.97562782402329 40.766952370137204 2F-AM-1006-02 02F AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 in tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9756278240233 40.7669523701372)
1924 -73.95423325052309 40.793347517143395 37G-AM-1014-01 37G AM 10142018 1 Adult Gray White Gray+White White tail Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9542332505231 40.7933475171434)
1935 -73.9675268877392 40.775040968171794 13H-AM-1013-01 13H AM 10132018 1 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675268877392 40.7750409681718)
2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9589600626433 40.7913690265064)
2095 -73.9747762992858 40.776857907857796 12A-AM-1008-02 12A AM 10082018 2 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9747762992858 40.7768579078578)
2135 -73.9596251284566 40.7916254797561 33D-AM-1017-05 33D AM 10172018 5 Adult Black   Black+   Above Ground 5   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9596251284566 40.7916254797561)
2449 -73.9599911537509 40.791445254284504 33D-AM-1017-04 33D AM 10172018 4 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9599911537509 40.7914452542845)
2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960094705031 40.7916066137699)
1841 -73.98063779675729 40.7681097168268 1B-AM-1012-15 01B AM 10122018 15 Adult Gray   Gray+   Above Ground 5   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9806377967573 40.7681097168268)

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