2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Above Ground Sighter Measurement = 20, Highlight Fur Color = "Cinnamon" and Shift = "PM" sorted by Foraging

View and edit SQL

Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Running, Chasing, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Indifferent

Tail twitches

Shift

Highlight Fur Color

  • Cinnamon · 11

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
444 -73.96414623605409 40.7778316005464 18I-PM-1007-09 18I PM 10072018 9 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0 canoodling w/ 8 0 0 0 0 0 0 1 0   POINT (-73.9641462360541 40.7778316005464)
1300 -73.964280573021 40.777830911491 18I-PM-1007-08 18I PM 10072018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 1 1 0 0 canoodling w/ #9 0 0 0 0 0 0 1 0   POINT (-73.964280573021 40.777830911491)
1333 -73.9754527701832 40.7656088463928 1G-PM-1010-02 01G PM 10102018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0 laying on tree branch 0 0 0 1 1 0 0 0   POINT (-73.9754527701832 40.7656088463928)
1338 -73.9716624574422 40.776203711010105 13D-PM-1018-07 13D PM 10182018 7 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0 scratching 0 0 0 0 0 0 1 0   POINT (-73.9716624574422 40.7762037110101)
1503 -73.97321932906308 40.7748791447746 11D-PM-1006-01 11D PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9732193290631 40.7748791447746)
1506 -73.9728339757306 40.7782891207966 14B-PM-1014-04 14B PM 10142018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 running up and down 0 0 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9728339757306 40.7782891207966)
1508 -73.96938943057859 40.775690674802604 13F-PM-1008-04 13F PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 0 0 0   1 0 0 0 0 0 0 0   POINT (-73.9693894305786 40.7756906748026)
2368 -73.9731925179247 40.7748962746181 11D-PM-1006-02 11D PM 10062018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731925179247 40.7748962746181)
2683 -73.972179947936 40.7810042827198 17A-PM-1013-02 17A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20 on a little pedestal-shaped part of a tree 0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.972179947936 40.7810042827198)
2877 -73.9730027200009 40.7798000868804 16A-PM-1019-05 16A PM 10192018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9730027200009 40.7798000868804)
2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)

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