2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Date = 10182018, Location = "Above Ground" and Primary Fur Color = "Cinnamon" sorted by Unique Squirrel ID

View and edit SQL

Suggested facets: Shift, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Above Ground Sighter Measurement, Running, Indifferent, Runs from

Tail twitches

Primary Fur Color

  • Cinnamon · 5

Location

  • Above Ground · 5

Date

  • 10182018 · 5
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
509 -73.9714289592392 40.775067070209296 12E-PM-1018-04 12E PM 10182018 4 Adult Cinnamon   Cinnamon+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9714289592392 40.7750670702093)
620 -73.9655905300923 40.775261463802295 14I-PM-1018-06 14I PM 10182018 6 Adult Cinnamon Black Cinnamon+Black   Above Ground 2   1 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9655905300923 40.7752614638023)
2171 -73.9686370726471 40.7780382348833 16E-PM-1018-09 16E PM 10182018 9 Juvenile Cinnamon White Cinnamon+White   Above Ground 3 On trunk 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9686370726471 40.7780382348833)
506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649611089685 40.7814371834837)
166 -73.96384633980401 40.7834051716226 23F-AM-1018-01 23F AM 10182018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.963846339804 40.7834051716226)

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