2018_Central_Park_Squirrel_Census_-_Squirrel_Data

10 rows where Chasing = 1, Date = 10062018, Indifferent = 1 and Tail twitches = 0

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Climbing, Kuks, Tail flags

Tail twitches

Indifferent

Date

  • 10062018 · 10

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
20 -73.9706105896967 40.769812482150705 7H-AM-1006-05 07H AM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9706105896967 40.7698124821507)
352 -73.970540988328 40.769810306706205 7H-AM-1006-06 07H AM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 12   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.970540988328 40.7698103067062)
1016 -73.9691293546408 40.7703219076549 8I-AM-1006-11 08I AM 10062018 11 Adult Gray   Gray+   Above Ground 50 tree 0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9691293546408 40.77032190765491)
1535 -73.9703921271418 40.770027611531404 7H-PM-1006-06 07H PM 10062018 6 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #7 0 0 0 0 0 0 1 0   POINT (-73.9703921271418 40.770027611531404)
1588 -73.9693209851947 40.7707450042769 8I-AM-1006-01 08I AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   1 1 0 0 0   1 0 0 0 0 0 1 0   POINT (-73.9693209851947 40.7707450042769)
1815 -73.96032682553171 40.7900154505092 31E-PM-1006-06 31E PM 10062018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603268255317 40.7900154505092)
1995 -73.9603366992925 40.7899612889539 31E-PM-1006-05 31E PM 10062018 5 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9603366992925 40.789961288953904)
2298 -73.97553718499721 40.7733561233828 9C-PM-1006-02 09C PM 10062018 2 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9755371849972 40.7733561233828)
2362 -73.9700263936574 40.769933509858106 7H-PM-1006-07 07H PM 10062018 7 Adult Gray   Gray+   Above Ground 15   0 1 1 0 0 playing w/ #6 0 0 0 0 0 0 1 0   POINT (-73.9700263936574 40.7699335098581)
2542 -73.9754802138871 40.773300804411996 9C-PM-1006-03 09C PM 10062018 3 Adult Gray White Gray+White   Above Ground 15   0 1 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9754802138871 40.773300804412)

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