2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Chasing = 1, Foraging = 0, Hectare Squirrel Number = 6 and Highlight Fur Color = "Cinnamon" sorted by longitude

View and edit SQL

Suggested facets: Shift, Date, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Tail flags, Tail twitches, Approaches, Indifferent

Eating

Highlight Fur Color

  • Cinnamon · 9

Hectare Squirrel Number

Foraging

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
1166 -73.980048119915 40.7676638655026 1B-AM-1012-06 01B AM 10122018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.980048119915 40.7676638655026)
2845 -73.9765016413674 40.77406728629529 9A-AM-1013-06 09A AM 10132018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9765016413674 40.7740672862953)
352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
44 -73.970252675331 40.7705999588222 8H-AM-1017-06 08H AM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6   0 1 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.970252675331 40.77059995882221)
682 -73.9651828383592 40.780282094386294 19F-PM-1017-06 19F PM 10172018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 1 0 0   0 0 0 0 1 1 0 0   POINT (-73.9651828383592 40.7802820943863)
1128 -73.9638599044346 40.7809288795308 21G-AM-1014-06 21G AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9638599044346 40.7809288795308)
576 -73.96220476777009 40.7945126358465 35A-AM-1014-06 35A AM 10142018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9622047677701 40.7945126358465)
1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
2247 -73.95595201371721 40.7950536287174 38E-AM-1010-06 38E AM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 1 branches 1 1 0 0 0 chasing and being chased by #7 0 0 0 0 1 0 1 0   POINT (-73.95595201371721 40.7950536287174)

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