2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Above Ground Sighter Measurement = 8 and Date = 10142018 sorted by Tail twitches

View and edit SQL

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Chasing, Climbing, Eating, Foraging, Moans, Runs from

Tail twitches

  • 0 7

Date

  • 10142018 · 7

Above Ground Sighter Measurement

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
72 -73.9666007935638 40.7845098131567 23C-PM-1014-03 23C PM 10142018 3 Adult Gray   Gray+   Above Ground 8   0 1 0 0 0 chasing (#4 across trees) 0 0 0 0 0 0 0 0   POINT (-73.9666007935638 40.7845098131567)
601 -73.9522291603405 40.7976985385835 42G-PM-1014-01 42G PM 10142018 1 Adult Gray White Gray+White   Above Ground 8   0 0 1 0 1   0 0 1 0 0 0 0 1   POINT (-73.9522291603405 40.7976985385835)
1652 -73.94984217462209 40.7969397424182 42I-PM-1014-02 42I PM 10142018 2 Adult Cinnamon White Cinnamon+White   Above Ground 8   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9498421746221 40.7969397424182)
2029 -73.9687213827744 40.7843586374648 22B-PM-1014-02 22B PM 10142018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9687213827744 40.7843586374648)
2341 -73.9665363265054 40.7844967881001 23C-PM-1014-04 23C PM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 0 0 being chased by #3 across trees 0 0 0 0 0 0 0 0   POINT (-73.9665363265054 40.7844967881001)
2465 -73.9686999860219 40.784401473513604 22B-PM-1014-03 22B PM 10142018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 8   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9686999860219 40.7844014735136)
2740 -73.96126586889142 40.7912119940469 32C-AM-1014-04 32C AM 10142018 4 Adult Gray   Gray+   Above Ground 8   0 0 0 1 0   0 0 0 0 0 0 0 0   POINT (-73.9612658688914 40.7912119940469)

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