2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Hectare = "07H" and Running = 1 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Shift, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Climbing, Foraging, Tail flags, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Eating

Running

Hectare

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
262 -73.97128762341721 40.7695885530701 7H-PM-1006-02 07H PM 10062018 2 Adult Gray   Gray+   Above Ground 25 tree 1 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9712876234172 40.7695885530701)
569 -73.9709040623777 40.7701163892686 7H-PM-1006-03 07H PM 10062018 3 Adult Gray   Gray+   Above Ground 8 tree 1 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9709040623777 40.7701163892686)
1575 -73.9703169373939 40.770065882385396 7H-AM-1006-13 07H AM 10062018 13 Adult Gray   Gray+   Above Ground 10   1 0 0 0 0 running (up tree) 0 0 0 0 0 0 1 0   POINT (-73.9703169373939 40.7700658823854)
697 -73.97046560040201 40.770112577324795 7H-PM-1006-05 07H PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ran across path to eat behind fence, next to the fence. 1 0 0 1 1   0 0 0 0 1 0 0 1   POINT (-73.970465600402 40.7701125773248)
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)
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)

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