2018_Central_Park_Squirrel_Census_-_Squirrel_Data

9 rows where Approaches = 1, Date = 10062018 and Eating = 1 sorted by Location

View and edit SQL

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

Hectare Squirrel Number

Eating

Date

  • 10062018 · 9

Approaches

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
2233 -73.9754709117681 40.7681421869407 3E-AM-1006-08 03E AM 10062018 8 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9754709117681 40.7681421869407)
214 -73.97725765612441 40.767989509396294 3D-AM-1006-08 03D AM 10062018 8 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0 approaches (food stand) POINT (-73.9772576561244 40.7679895093963)
314 -73.960601067176 40.7917243850136 32D-PM-1006-09 32D PM 10062018 9 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 1 1 0 0   POINT (-73.960601067176 40.7917243850136)
658 -73.9704575848926 40.7693499326095 7H-PM-1006-09 07H PM 10062018 9 Adult Black   Black+   Ground Plane FALSE by tree 0 0 0 1 1   0 0 0 1 0 1 0 1   POINT (-73.9704575848926 40.7693499326095)
1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
1289 -73.97246812695259 40.7743474675821 11D-PM-1006-03 11D PM 10062018 3 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.9724681269526 40.7743474675821)
1650 -73.97624942397191 40.775017530671605 10A-AM-1006-01 10A AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE near Strawberry Fields 0 0 0 1 0 eating (a peanut) 0 0 0 0 0 1 0 0   POINT (-73.9762494239719 40.7750175306716)
2610 -73.9713379914423 40.7696367609606 7H-PM-1006-01 07H PM 10062018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE middle of grass 0 0 0 1 1   0 0 0 0 1 1 0 0   POINT (-73.9713379914423 40.7696367609606)
2750 -73.957775998085 40.7932880937406 35E-PM-1006-05 35E PM 10062018 5 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 1 0 0   POINT (-73.957775998085 40.7932880937406)

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