2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Hectare = "09I" and Shift = "PM" sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Foraging, Indifferent, Runs from

Highlight Fur Color

Tail twitches

  • 0 7

Shift

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
1181 -73.9690395363594 40.771128205027 9I-PM-1010-01 09I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9690395363594 40.771128205027)
2500 -73.9689703880705 40.7712025611298 9I-PM-1010-02 09I PM 10102018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White standard coloration Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.96897038807052 40.7712025611298)
2631 -73.9690080105286 40.7710230515054 9I-PM-1010-03 09I PM 10102018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White         0 0 0 0 1   0 0 0 0 0 0 1 1   POINT (-73.9690080105286 40.7710230515054)
968 -73.9689781843873 40.7709333833783 9I-PM-1010-04 09I PM 10102018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9689781843873 40.7709333833783)
2152 -73.9686925781295 40.7705688673142 9I-PM-1010-05 09I PM 10102018 5 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9686925781295 40.7705688673142)
1670 -73.9682688752331 40.7711934835539 9I-PM-1010-06 09I PM 10102018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9682688752331 40.7711934835539)
602 -73.96857515954851 40.7709413567859 9I-PM-1010-07 09I PM 10102018 7 Adult Gray White Gray+White   Above Ground 1 ran up tree 1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9685751595485 40.7709413567859)

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