2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Approaches = 1, Hectare Squirrel Number = 4 and Highlight Fur Color = "Cinnamon" sorted by Other Activities

View and edit SQL

Suggested facets: Shift, Date, Eating, Foraging, Tail twitches

Highlight Fur Color

  • Cinnamon · 8

Hectare Squirrel Number

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
692 -73.9594529310985 40.7840492606552 26I-PM-1010-04 26I PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.95945293109851 40.7840492606552)
1474 -73.9801971465604 40.7697081749827 3A-PM-1017-04 03A PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9801971465604 40.7697081749827)
1597 -73.9789401448556 40.76973731414979 4B-AM-1010-04 04B AM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9789401448556 40.7697373141498)
1704 -73.9624052832372 40.7809656348254 21H-PM-1018-04 21H PM 10182018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9624052832372 40.7809656348254)
1868 -73.97122650227809 40.778379099119206 15C-PM-1017-04 15C PM 10172018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9712265022781 40.7783790991192)
1919 -73.9637440847107 40.789142741937205 29C-AM-1007-04 29C AM 10072018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9637440847107 40.7891427419372)
2575 -73.97357533521291 40.7687061447032 5G-PM-1010-04 05G PM 10102018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9735753352129 40.7687061447032)
1533 -73.95200246546021 40.794732982815496 39I-PM-1013-04 39I PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as both Primary and Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0 playing 0 0 0 0 0 1 0 0   POINT (-73.95200246546021 40.7947329828155)

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.942ms