2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Date = 10102018 and Hectare = "15F" sorted by Runs from

View and edit SQL

Suggested facets: Location, Above Ground Sighter Measurement, Foraging, Indifferent, Runs from

Running

Tail twitches

  • 0 7

Hectare

Date

  • 10102018 · 7
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
59 -73.9684910712272 40.776881164002106 15F-PM-1010-05 15F PM 10102018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9684910712272 40.7768811640021)
89 -73.968052057989 40.777338666528 15F-PM-1010-06 15F PM 10102018 6 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.968052057989 40.777338666528)
297 -73.9685604013735 40.7773439909065 15F-PM-1010-03 15F PM 10102018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9685604013735 40.7773439909065)
1156 -73.9688929282726 40.7768899536946 15F-PM-1010-01 15F PM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9688929282726 40.7768899536946)
1718 -73.96826762377029 40.7772653590224 15F-PM-1010-04 15F PM 10102018 4 Adult Gray   Gray+   Ground Plane FALSE on path 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682676237703 40.7772653590224)
1838 -73.9686622009739 40.776729438050204 15F-PM-1010-02 15F PM 10102018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9686622009739 40.7767294380502)
237 -73.96789565689801 40.7767409597341 15F-PM-1010-07 15F PM 10102018 7 Adult Gray   Gray+   Above Ground 3 on fence 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.967895656898 40.7767409597341)

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