2018_Central_Park_Squirrel_Census_-_Squirrel_Data

11 rows where Eating = 0, Hectare = "07H" and Highlight Fur Color = "Cinnamon" sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Location, Above Ground Sighter Measurement, Running, Chasing, Foraging, Approaches, Indifferent

Hectare Squirrel Number

Highlight Fur Color

  • Cinnamon · 11

Eating

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
20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
435 -73.9702963056917 40.7697928730791 7H-AM-1006-11 07H AM 10062018 11 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9702963056917 40.7697928730791)
472 -73.9702721244652 40.7701011774207 7H-AM-1006-15 07H AM 10062018 15 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9702721244652 40.7701011774207)
486 -73.971213385696 40.769872094337 7H-AM-1006-04 07H AM 10062018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97121338569602 40.769872094337)
1285 -73.97051151894291 40.769839557706796 7H-AM-1006-08 07H AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705115189429 40.7698395577068)
1455 -73.9715621134573 40.7695918717513 7H-AM-1006-02 07H AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1 running (along ground,up tree) 0 0 0 0 0 0 1 0   POINT (-73.9715621134573 40.76959187175131)
1469 -73.97048311770351 40.7699878995692 7H-AM-1006-10 07H AM 10062018 10 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9704831177035 40.7699878995692)
1557 -73.9705331808443 40.769994357129605 7H-AM-1006-09 07H AM 10062018 9 Adult Gray Cinnamon Gray+Cinnamon         0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.9705331808443 40.7699943571296)
1628 -73.97136652496141 40.76971786480021 7H-AM-1006-01 07H AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0 nut in mouth 0 0 0 0 0 0 1 0   POINT (-73.9713665249614 40.7697178648002)
1813 -73.9706988226435 40.7696684566926 7H-AM-1006-16 07H AM 10062018 16 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9706988226435 40.7696684566926)

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