2018_Central_Park_Squirrel_Census_-_Squirrel_Data

4 rows where Date = 10082018 and Hectare = "13G" sorted by Location

View and edit SQL

Suggested facets: Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Climbing, Foraging

Tail twitches

  • 0 4

Hectare

Date

  • 10082018 · 4
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
695 -73.96850806398729 40.774530979415495 13G-PM-1008-03 13G PM 10082018 3 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 20 maple tree 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9685080639873 40.77453097941551)
1904 -73.9684058476942 40.7753959833776 13G-PM-1008-02 13G PM 10082018 2 Juvenile Gray   Gray+   Above Ground 15 willow oak tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684058476942 40.7753959833776)
2786 -73.9683883750097 40.7754344396847 13G-PM-1008-01 13G PM 10082018 1 Juvenile Gray   Gray+   Above Ground 20 willow oak tree 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9683883750097 40.7754344396847)
1401 -73.9681202146851 40.7743979416812 13G-PM-1008-04 13G PM 10082018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE lawn @ edge of landscaped area 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9681202146851 40.7743979416812)

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