2018_Central_Park_Squirrel_Census_-_Squirrel_Data

12 rows where Foraging = 0, Highlight Fur Color = "Gray", Shift = "AM" and Tail twitches = 1 sorted by Combination of Primary and Highlight Color

View and edit SQL

Suggested facets: Hectare, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Kuks, Quaas, Tail flags, Approaches, Indifferent, Runs from

Climbing

Tail twitches

Shift

Moans

  • 0 12

Highlight Fur Color

  • Gray · 12

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
506 -73.9649611089685 40.7814371834837 21F-AM-1018-05 21F AM 10182018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 2   0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649611089685 40.7814371834837)
534 -73.9650499507011 40.7908191782173 30A-AM-1010-01 30A AM 10102018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9650499507011 40.7908191782173)
588 -73.9646597452128 40.7827698220703 22F-AM-1007-07 22F AM 10072018 7 Juvenile Cinnamon Gray Cinnamon+Gray   Above Ground 3   0 0 1 0 0   0 0 0 0 1 0 0 0 alert & aware POINT (-73.9646597452128 40.7827698220703)
987 -73.96498278073409 40.7817322832767 21F-AM-1018-06 21F AM 10182018 6 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9649827807341 40.7817322832767)
1799 -73.978844141973 40.7696046074378 4B-AM-1010-05 04B AM 10102018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 10   0 1 0 0 0 chasing squirrel #6 1 1 0 0 1 0 0 0   POINT (-73.978844141973 40.7696046074378)
1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
2033 -73.9500167570283 40.7966185836685 41I-AM-1018-01 41I AM 10182018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 0 cautious,observant,runs off POINT (-73.9500167570283 40.7966185836685)
2487 -73.9595222999173 40.7833202577782 25I-AM-1012-02 25I AM 10122018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 31 on tree 1 1 0 0 0   0 0 0 1 1 0 1 0   POINT (-73.9595222999173 40.7833202577782)
2739 -73.9681960138614 40.7726867422002 11H-AM-1010-02 11H AM 10102018 2   Cinnamon Gray Cinnamon+Gray         0 0 0 1 0   0 0 0 0 1 0 1 0   POINT (-73.9681960138614 40.7726867422002)
2788 -73.9647845655965 40.7816573808695 21F-AM-1018-07 21F AM 10182018 7 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 0 0 1   POINT (-73.9647845655965 40.7816573808695)
2878 -73.969720780557 40.774110568875706 12F-AM-1020-04 12F AM 10202018 4 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 1 0 0 0   POINT (-73.969720780557 40.7741105688757)
2998 -73.97520792474191 40.775537697900205 11B-AM-1007-01 11B AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 1 1 0 0   POINT (-73.9752079247419 40.7755376979002)

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