2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Chasing = 1, Date = 10132018 and Hectare Squirrel Number = 3 sorted by Hectare Squirrel Number

View and edit SQL

Suggested facets: Shift, Age, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Foraging, Tail twitches, Indifferent, Runs from

Eating

Approaches

Hectare Squirrel Number

Date

  • 10132018 · 5

Chasing

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
222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
361 -73.96148244372509 40.7912929799884 32C-PM-1013-03 32C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 1 0 0 0   0 0 0 0 1 0 0 0   POINT (-73.9614824437251 40.7912929799884)
628 -73.96001657854859 40.795246676183204 36B-PM-1013-03 36B PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9600165785486 40.7952466761832)
1143 -73.9628349778362 40.793887005205995 34A-PM-1013-03 34A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9628349778362 40.793887005206)
1167 -73.9593244415072 40.794964729747 36C-PM-1013-03 36C PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE Clearing near bike path (bikes active) 0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9593244415072 40.794964729747)

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