2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Date = 10202018, Hectare Squirrel Number = 1 and Shift = "PM" sorted by Hectare

View and edit SQL

Suggested facets: Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Tail flags, Tail twitches, Indifferent, Runs from

Moans

  • 0 9

Hectare Squirrel Number

Date

  • 10202018 · 9
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
2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)
216 -73.97542703689841 40.770241150230795 6D-PM-1020-01 06D PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE Baseball field 0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9754270368984 40.7702411502308)
2861 -73.9720102361126 40.7692143930301 6G-PM-1020-01 06G PM 10202018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9720102361126 40.7692143930301)
3002 -73.9710991846972 40.768982782424104 6H-PM-1020-01 06H PM 10202018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9710991846972 40.7689827824241)
2602 -73.97548229388691 40.771776689383294 7C-PM-1020-01 07C PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9754822938869 40.7717766893833)
984 -73.9672950266018 40.7782477517567 17F-PM-1020-01 17F PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 7   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9672950266018 40.7782477517567)
410 -73.9584024936392 40.785149170194394 27I-PM-1020-01 27I PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1 runs from (us) POINT (-73.9584024936392 40.7851491701944)
2088 -73.96511558803459 40.790694632578 30A-PM-1020-01 30A PM 10202018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 0   POINT (-73.9651155880346 40.790694632578)
193 -73.9537691298752 40.7941272599797 38G-PM-1020-01 38G PM 10202018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9537691298752 40.7941272599797)

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