2018_Central_Park_Squirrel_Census_-_Squirrel_Data

7 rows where Above Ground Sighter Measurement = 2, Foraging = 1, Shift = "AM" and Tail twitches = 0 sorted by Moans

View and edit SQL

Suggested facets: Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Running, Climbing, Eating, Indifferent

Tail twitches

Shift

Quaas

  • 0 7

Moans

  • 0 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
1696 -73.96945916677049 40.776651822199796 14E-AM-1008-12 14E AM 10082018 12 Adult Gray   Gray+   Above Ground 2   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694591667705 40.7766518221998)
1729 -73.97650461090191 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765046109019 40.7736674124746)
1777 -73.9711751356843 40.775242275820204 12E-AM-1017-06 12E AM 10172018 6 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 2   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9711751356843 40.7752422758202)
1828 -73.9682965197661 40.780537896388296 18D-AM-1018-04 18D AM 10182018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9682965197661 40.7805378963883)
2639 -73.9543832609857 40.795355063970106 39F-AM-1014-02 39F AM 10142018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 rocks 1 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9543832609857 40.7953550639701)
2694 -73.969628583287 40.770406779793205 8H-AM-1017-03 08H AM 10172018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 2 fence 1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.969628583287 40.7704067797932)
2944 -73.97394038506219 40.769316228750895 5F-AM-1007-05 05F AM 10072018 5 Adult Gray White Gray+White   Above Ground 2 tree 1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9739403850622 40.7693162287509)

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