2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Date = 10072018, Highlight Fur Color = "Cinnamon, White" and Shift = "AM" sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Hectare, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Indifferent

Tail twitches

  • 0 10

Shift

Highlight Fur Color

  • Cinnamon, White · 10

Date

  • 10072018 · 10
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
674 -73.9779811967788 40.7675178797546 2D-AM-1007-01 02D AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779811967788 40.7675178797546)
2905 -73.9784872728213 40.768812260393204 3C-AM-1007-01 03C AM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9784872728213 40.7688122603932)
848 -73.9692190295442 40.776336630915395 14F-AM-1007-02 14F AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9692190295442 40.7763366309154)
1220 -73.97799837948492 40.767545209917294 2D-AM-1007-02 02D AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6 up tree 0 1 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9779983794849 40.7675452099173)
1325 -73.97752788478971 40.7687881061059 3C-AM-1007-02 03C AM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9775278847897 40.7687881061059)
714 -73.96915857561909 40.776340465695 14F-AM-1007-03 14F AM 10072018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9691585756191 40.776340465695)
1068 -73.96660639702 40.7756655031741 14H-AM-1007-03 14H AM 10072018 3 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.96660639702002 40.7756655031741)
616 -73.9556937218252 40.7990928062435 42C-AM-1007-04 42C AM 10072018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White young adult Ground Plane FALSE   0 0 0 0 0 walking 0 0 0 0 0 0 1 0   POINT (-73.9556937218252 40.7990928062435)
489 -73.97780296909 40.7676321060669 2D-AM-1007-06 02D AM 10072018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.97780296909002 40.767632106066905)
725 -73.9689627791 40.776062004359005 14F-AM-1007-06 14F AM 10072018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689627791 40.776062004359)

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