2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Hectare = "06I" sorted by Lat/Long

View and edit SQL

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

Highlight Fur Color

Tail twitches

Quaas

  • 0 8

Hectare

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 ▼
1894 -73.96997808572979 40.7688706046944 6I-PM-1013-01 06I PM 10132018 1 Adult Gray Black Gray+Black   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.9699780857298 40.7688706046944)
1267 -73.9701010964667 40.768891931450796 6I-PM-1013-02 06I PM 10132018 2 Adult Black   Black+   Ground Plane FALSE Bushes 0 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701010964667 40.76889193145081)
2554 -73.9701505245419 40.768998364571 6I-PM-1013-07 06I PM 10132018 7 Adult Cinnamon   Cinnamon+   Above Ground 11   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701505245419 40.768998364571004)
1369 -73.97027172608291 40.768951107763 6I-PM-1013-03 06I PM 10132018 3 Adult Cinnamon   Cinnamon+   Ground Plane FALSE Flowers, grass 0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9702717260829 40.768951107763)
58 -73.9704082821356 40.7690280985956 6I-PM-1013-06 06I PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 0 playing with #5 0 0 0 0 1 0 0 0   POINT (-73.9704082821356 40.7690280985956)
1157 -73.9704449096084 40.76899707783029 6I-PM-1013-05 06I PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 0 playing with #6 0 0 0 0 1 0 0 0   POINT (-73.9704449096084 40.7689970778303)
1296 -73.97055091705421 40.7689416540228 6I-PM-1013-04 06I PM 10132018 4 Adult Black Gray Black+Gray   Ground Plane FALSE Grass 0 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.9705509170542 40.7689416540228)
1429 -73.9706533131129 40.768902033818996 6I-AM-1006-01 06I AM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground     1 0 1 1 1   0 0 0 0 0 0 0 1 runs from (someone sneezed) POINT (-73.9706533131129 40.768902033819)

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