2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Hectare = "06H" sorted by Climbing

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Primary Fur Color, Location, Running, Climbing, Eating, Foraging, Indifferent, Runs from

Date

Hectare

Chasing

  • 0 5

Above Ground Sighter Measurement

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
151 -73.9714789136757 40.7694886645194 6H-AM-1008-01 06H AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9714789136757 40.7694886645194)
962 -73.97154668503241 40.7695584933538 6H-PM-1020-03 06H PM 10202018 3 Adult Gray Cinnamon Gray+Cinnamon Gray & Cinnamon selected as Primary. Nothing selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1 runs from (kids kicking the fence) POINT (-73.9715466850324 40.7695584933538)
1266 -73.9709897849823 40.768627964006 6H-AM-1008-02 06H AM 10082018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9709897849823 40.768627964006)
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)
1755 -73.97147981967771 40.7695231949631 6H-PM-1020-02 06H PM 10202018 2 Adult     +   Above Ground   Fence pole 0 0 1 0 0   0 0 0 0 0 0 0 1 runs from (me) POINT (-73.9714798196777 40.7695231949631)

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