2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Climbing = 1, Date = 10122018 and Hectare Squirrel Number = 1 sorted by Specific Location

View and edit SQL

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

Hectare Squirrel Number

Climbing

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
401 -73.965862100991 40.782592689691704 22D-PM-1012-01 22D PM 10122018 1 Adult Gray Black, White Gray+Black, White   Above Ground 5   0 0 1 0 0   1 0 0 0 0 0 0 0 climbing tree POINT (-73.965862100991 40.7825926896917)
788 -73.9687476703117 40.7742856696093 12G-AM-1012-01 12G AM 10122018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9687476703117 40.7742856696093)
931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
1299 -73.9766653663947 40.7688767713012 4D-AM-1012-01 04D AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9766653663947 40.7688767713012)
2652 -73.96205425147491 40.794373172213795 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9620542514749 40.7943731722138)
1641 -73.96531352771491 40.7817434070169 21E-PM-1012-01 21E PM 10122018 1 Adult Gray   Gray+   Above Ground 20 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9653135277149 40.7817434070169)
1118 -73.9719460335398 40.7810508156287 18A-AM-1012-01 18A AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White White tail Above Ground 3 tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.9719460335398 40.7810508156287)
2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)

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