2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Date = 10082018, Hectare Squirrel Number = 1 and Tail twitches = 1 sorted by Runs from

View and edit SQL

Suggested facets: Shift, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Eating, Foraging, Kuks, Tail flags, Approaches, Indifferent, Runs from

Tail twitches

Hectare Squirrel Number

Date

  • 10082018 · 9
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
26 -73.9649866016038 40.776492969445705 16I-AM-1008-01 16I AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9649866016038 40.7764929694457)
982 -73.9676424599715 40.777776610680704 16F-AM-1008-01 16F AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE near fence 0 0 0 0 1   0 0 0 0 1 1 0 0   POINT (-73.9676424599715 40.7777766106807)
1214 -73.9699517492486 40.7753169595373 13F-PM-1008-01 13F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9699517492486 40.7753169595373)
1430 -73.970804709441 40.7758611111219 13E-PM-1008-01 13E PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.970804709441 40.7758611111219)
1545 -73.9669207809051 40.779276785012605 18F-PM-1008-01 18F PM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9669207809051 40.7792767850126)
1975 -73.9753291616796 40.7687376032936 4E-PM-1008-01 04E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9753291616796 40.7687376032936)
2489 -73.9663168490265 40.7825083721362 21D-AM-1008-01 21D AM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 1 0 1 0   POINT (-73.9663168490265 40.7825083721362)
342 -73.9605966636226 40.788984910863704 30E-AM-1008-01 30E AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scurried into bushes when jogger ran by POINT (-73.9605966636226 40.7889849108637)
929 -73.97386112577159 40.773724677958704 10D-AM-1008-01 10D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 0 1   1 0 0 0 1 0 0 1   POINT (-73.9738611257716 40.7737246779587)

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