2018_Central_Park_Squirrel_Census_-_Squirrel_Data

6 rows where Date = 10082018 and Hectare = "03H" sorted by Foraging

View and edit SQL

Suggested facets: Primary Fur Color, Combination of Primary and Highlight Color, Location, Climbing, Foraging, Indifferent, Runs from

Tail twitches

Hectare

Date

  • 10082018 · 6
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
647 -73.9734762649298 40.7663703404546 3H-AM-1008-05 03H AM 10082018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 13   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9734762649298 40.7663703404546)
2452 -73.9727323797981 40.766903546395504 3H-AM-1008-03 03H AM 10082018 3 Adult Gray   Gray+   Above Ground 40 building nest 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727323797981 40.7669035463955)
2584 -73.9727187453699 40.7669595710626 3H-AM-1008-02 03H AM 10082018 2 Adult Gray   Gray+   Above Ground     0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9727187453699 40.7669595710626)
2680 -73.9721348050673 40.7666920046704 3H-AM-1008-01 03H AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 8   0 0 0 0 0 teasing barking dog 0 0 0 0 0 0 1 0 indifferent by not caring about dog POINT (-73.9721348050673 40.7666920046704)
2322 -73.97236778547979 40.766731541087104 3H-AM-1008-04 03H AM 10082018 4 Adult Black   Black+   Above Ground 50   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9723677854798 40.7667315410871)
2395 -73.9729603550254 40.7660215710657 3H-AM-1008-06 03H AM 10082018 6 Adult Black   Black+ beauty! Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9729603550254 40.7660215710657)

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