2018_Central_Park_Squirrel_Census_-_Squirrel_Data

3 rows where Above Ground Sighter Measurement = 4, Indifferent = 0 and Tail twitches = 1 sorted by Lat/Long

View and edit SQL

Suggested facets: Shift, Climbing, Eating, Tail flags, Approaches

Primary Fur Color

Tail twitches

Indifferent

Highlight Fur Color

Above Ground Sighter Measurement

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 ▼
1138 -73.9594357049738 40.7840678890949 25I-AM-1012-01 25I AM 10122018 1 Adult Cinnamon   Cinnamon+   Above Ground 4 on bar 0 0 0 1 0   0 0 0 1 1 1 0 0   POINT (-73.9594357049738 40.7840678890949)
2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9700101107283 40.7696729501144)
1048 -73.9782120139407 40.7717154468791 6A-AM-1006-05 06A AM 10062018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 tree 0 0 1 0 0   0 0 0 1 1 0 0 0 curious POINT (-73.9782120139407 40.7717154468791)

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