2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Date = 10122018 and Hectare = "11I" sorted by Above Ground Sighter Measurement

View and edit SQL

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Tail flags, Indifferent, Runs from

Tail twitches

Hectare

Date

  • 10122018 · 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
889 -73.96810426129379 40.772331431865 11I-PM-1012-04 11I PM 10122018 4 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681042612938 40.772331431865)
1317 -73.9680522379372 40.772389813511 11I-PM-1012-06 11I PM 10122018 6 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9680522379372 40.772389813511)
1568 -73.96810798698209 40.772349408134495 11I-PM-1012-05 11I PM 10122018 5 Adult Gray   Gray+   Above Ground 2   1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9681079869821 40.7723494081345)
2818 -73.9681664642028 40.77246696819579 11I-PM-1012-02 11I PM 10122018 2 Adult Gray   Gray+   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 0 1 runs away from the ball POINT (-73.9681664642028 40.7724669681958)
402 -73.9681917366128 40.7723298813768 11I-PM-1012-03 11I PM 10122018 3 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 0 1 runs from the dog POINT (-73.9681917366128 40.7723298813768)
485 -73.9677423154682 40.7728813350245 11I-AM-1012-02 11I AM 10122018 2 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9677423154682 40.77288133502451)
1795 -73.968004352343 40.7726669278308 11I-PM-1012-01 11I PM 10122018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 1 0 0 0 look at humans determining POINT (-73.968004352343 40.7726669278308)
2199 -73.9677500862135 40.7726060987821 11I-AM-1012-01 11I AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 0 1   POINT (-73.9677500862135 40.7726060987821)
2311 -73.96801718943509 40.772464442631296 11I-PM-1012-07 11I PM 10122018 7 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 0 0 1 burying its food into the ground 0 0 0 0 0 0 0 0   POINT (-73.96801718943512 40.7724644426313)

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