2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Date = 10122018 and Hectare = "33E" sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Primary Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Eating, Foraging, Runs from

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
383 -73.9588358879692 40.7912631913057 33E-PM-1012-01 33E PM 10122018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9588358879692 40.7912631913057)
2405 -73.9588361742943 40.791115225155 33E-PM-1012-02 33E PM 10122018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9588361742943 40.791115225155)
2250 -73.95890163858891 40.7911727679625 33E-PM-1012-03 33E PM 10122018 3 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9589016385889 40.7911727679625)
1547 -73.958939037549 40.7913193931203 33E-PM-1012-04 33E PM 10122018 4 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1 playing 0 0 0 0 0 0 0 0   POINT (-73.958939037549 40.7913193931203)
1292 -73.959019987128 40.791254669180496 33E-PM-1012-05 33E PM 10122018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.959019987128 40.7912546691805)
1805 -73.9590328527128 40.791221441757706 33E-PM-1012-06 33E PM 10122018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9590328527128 40.7912214417577)
772 -73.95841884610591 40.7913241048498 33E-PM-1012-07 33E PM 10122018 7 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9584188461059 40.7913241048498)
2214 -73.9583688637255 40.791388958496 33E-PM-1012-08 33E PM 10122018 8 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9583688637255 40.791388958496)
1232 -73.9589254878322 40.7914467650712 33E-PM-1012-09 33E PM 10122018 9 Adult Black   Black+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.9589254878322 40.7914467650712)

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.143ms