2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Foraging = 0, Highlight Fur Color = "Gray, White", Indifferent = 1 and Tail twitches = 0 sorted by Age

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Runs from

Indifferent

Highlight Fur Color

  • Gray, White · 9

Foraging

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
458 -73.97357503529591 40.7694500333777 6F-PM-1008-06 06F PM 10082018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White White patches. Almost looks like fox squirrel       0 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9735750352959 40.7694500333777)
660 -73.9638298997554 40.78259663323671 22F-AM-1007-03 22F AM 10072018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White large white highlight Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9638298997554 40.7825966332367)
799 -73.9529413156461 40.7920963446605 36I-PM-1007-06 36I PM 10072018 6 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9529413156461 40.7920963446605)
939 -73.97614477914841 40.7690147873986 4D-PM-1008-02 04D PM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9761447791484 40.7690147873986)
1142 -73.9765805609072 40.7692807820935 4D-PM-1008-07 04D PM 10082018 7 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE hopped over fence and chased # 6 around tree & ran it to end of lawn 1 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9765805609072 40.7692807820935)
1384 -73.97876087620051 40.7686062296462 3C-PM-1008-01 03C PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 3   0 0 0 0 0 walked between trees 0 0 0 0 0 0 1 0   POINT (-73.9787608762005 40.7686062296462)
1739 -73.96397004344492 40.777500305002796 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings 1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639700434449 40.7775003050028)
1775 -73.951965247933 40.7938167628067 38I-PM-1014-03 38I PM 10142018 3 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 1   POINT (-73.951965247933 40.7938167628067)
2516 -73.96498236876509 40.7763395359636 16I-AM-1008-02 16I AM 10082018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9649823687651 40.7763395359636)

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