2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Above Ground Sighter Measurement = 5, Chasing = 0 and Date = 10142018 sorted by Location

View and edit SQL

Suggested facets: Hectare, Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Foraging, Kuks, Tail twitches, Indifferent, Runs from

Moans

  • 0 5

Date

  • 10142018 · 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
388 -73.9592537496995 40.7919271821316 33E-AM-1014-03 33E AM 10142018 3 Adult Black   Black+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9592537496995 40.7919271821316)
666 -73.96870277827259 40.770516261619896 9I-AM-1014-09 09I AM 10142018 9 Adult Gray   Gray+   Above Ground 5   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.96870277827261 40.7705162616199)
1924 -73.95423325052309 40.793347517143395 37G-AM-1014-01 37G AM 10142018 1 Adult Gray White Gray+White White tail Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9542332505231 40.7933475171434)
2056 -73.9589600626433 40.7913690265064 33E-AM-1014-08 33E AM 10142018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 5   0 0 1 0 0   1 0 0 0 0 0 1 0   POINT (-73.9589600626433 40.7913690265064)
2157 -73.9657171357842 40.7773277532224 16H-PM-1014-05 16H PM 10142018 5 Adult Gray White Gray+White   Above Ground 5 tree 1 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9657171357842 40.7773277532224)

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