2018_Central_Park_Squirrel_Census_-_Squirrel_Data

8 rows where Hectare = "02F" and Running = 1 sorted by Foraging

View and edit SQL

Suggested facets: Shift, Date, Highlight Fur Color, Combination of Primary and Highlight Color, Tail twitches, Indifferent, Runs from

Hectare Squirrel Number

Running

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
885 -73.97504638449841 40.7666871742836 2F-PM-1014-08 02F PM 10142018 8 Adult Gray Black Gray+Black   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9750463844984 40.7666871742836)
974 -73.9753744539307 40.7671162211032 2F-PM-1014-12 02F PM 10142018 12 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.97537445393071 40.7671162211032)
1427 -73.9755321998542 40.766831157600706 2F-PM-1014-01 02F PM 10142018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.97553219985421 40.7668311576007)
1600 -73.9753093777 40.7666673897583 2F-AM-1006-04 02F AM 10062018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White Beautiful white puff at the end of its tail Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 1 0   POINT (-73.97530937770001 40.7666673897583)
1682 -73.97592584072879 40.7667622711142 2F-PM-1014-05 02F PM 10142018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9759258407288 40.7667622711142)
2160 -73.975028559002 40.7667307335544 2F-PM-1014-09 02F PM 10142018 9 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.975028559002 40.7667307335544)
2410 -73.97551920769341 40.7664413570796 2F-PM-1014-06 02F PM 10142018 6 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755192076934 40.7664413570796)
2558 -73.97494695668541 40.7667805367199 2F-PM-1014-10 02F PM 10142018 10 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9749469566854 40.7667805367199)

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