2018_Central_Park_Squirrel_Census_-_Squirrel_Data

3 rows where Above Ground Sighter Measurement = 6 and Hectare Squirrel Number = 8 sorted by Climbing

View and edit SQL

Suggested facets: Shift, Date, Combination of Primary and Highlight Color, Climbing, Eating, Kuks, Quaas, Tail twitches, Indifferent

Hectare Squirrel Number

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
476 -73.9690968160819 40.769923269444 8I-AM-1006-08 08I AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 6 tree 0 0 0 0 0   1 1 0 0 0 0 0 0 not backing down POINT (-73.9690968160819 40.769923269444)
1546 -73.976422624924 40.7735818387346 8B-AM-1007-08 08B AM 10072018 8 Adult Gray   Gray+   Above Ground 6   0 0 0 1 0 holding nut 0 0 0 0 0 0 1 0   POINT (-73.976422624924 40.7735818387346)
1820 -73.9546337446865 40.7898772579576 33I-PM-1006-08 33I PM 10062018 8 Adult Gray   Gray+   Above Ground 6   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9546337446865 40.7898772579576)

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.633ms