2018_Central_Park_Squirrel_Census_-_Squirrel_Data

5 rows where Foraging = 0, Hectare Squirrel Number = 1 and Highlight Fur Color = "Gray, White" sorted by Indifferent

View and edit SQL

Suggested facets: Shift, Date, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Indifferent, Runs from

Moans

  • 0 5

Highlight Fur Color

  • Gray, White · 5

Hectare Squirrel Number

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
151 -73.9714789136757 40.7694886645194 6H-AM-1008-01 06H AM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9714789136757 40.7694886645194)
813 -73.9758959798289 40.7694125671679 4D-PM-1008-01 04D PM 10082018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9758959798289 40.7694125671679)
2647 -73.954499539822 40.7949716693686 38F-AM-1018-01 38F AM 10182018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.954499539822 40.7949716693686)
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)

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