2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Climbing = 1, Date = 10082018 and Highlight Fur Color = "Cinnamon" sorted by Approaches

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Specific Location, Running, Eating, Quaas, Tail flags, Indifferent, Runs from

Tail twitches

Highlight Fur Color

  • Cinnamon · 8

Date

  • 10082018 · 8

Climbing

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
43 -73.9574648097543 40.7892508428622 31H-PM-1008-02 31H PM 10082018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9574648097543 40.78925084286221)
112 -73.96517544644391 40.7755181941559 15I-AM-1008-01 15I AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7 tree 0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9651754464439 40.7755181941559)
210 -73.97112984911321 40.76769026035429 5I-PM-1008-01 05I PM 10082018 1 Adult Black Cinnamon Black+Cinnamon   Above Ground 15 in tree by arsenal - climbing 0 0 1 1 0   0 0 0 1 0 0 0 0   POINT (-73.9711298491132 40.7676902603543)
462 -73.96617859405309 40.7742569936186 13I-PM-1008-01 13I PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 climbed tree 1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9661785940531 40.7742569936186)
647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
1079 -73.9722737593623 40.768963018754 6G-AM-1008-04 06G AM 10082018 4 Juvenile Gray Cinnamon Gray+Cinnamon very long tail Above Ground 20 tree 1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9722737593623 40.768963018754)
1741 -73.9736995552241 40.77227125186371 8E-PM-1008-02 08E PM 10082018 2 Adult Black Cinnamon Black+Cinnamon   Above Ground 10 in tree 1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9736995552241 40.7722712518637)
2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)

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