2018_Central_Park_Squirrel_Census_-_Squirrel_Data

14 rows where Hectare Squirrel Number = 2, Highlight Fur Color = "Gray" and Shift = "PM" sorted by Lat/Long

View and edit SQL

Suggested facets: Date, Age, Primary Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Shift

Hectare Squirrel Number

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 ▼
1601 -73.9544278270221 40.7987827316512 42D-PM-1013-02 42D PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail, Cinnamon feet Ground Plane FALSE   0 1 0 0 1 chasing (chased by #1),found a nut,buried it 0 0 0 0 0 0 1 0   POINT (-73.9544278270221 40.7987827316512)
2504 -73.9550131837533 40.7958617258176 39E-PM-1013-02 39E PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray Gray tail & butt Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 1 0   POINT (-73.9550131837533 40.7958617258176)
2026 -73.9622752768962 40.7814921913101 22H-PM-1007-02 22H PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4 low branch 0 0 0 0 0 watching me scratching 1 0 0 1 0 0 1 0   POINT (-73.9622752768962 40.7814921913101)
3018 -73.9645437409662 40.7811599933331 21F-PM-1018-02 21F PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9645437409662 40.7811599933331)
1415 -73.9678561384348 40.77828773978221 16E-PM-1018-02 16E PM 10182018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 0 0 gets distance from people but then continues to chase #1 POINT (-73.9678561384348 40.7782877397822)
1067 -73.9695305996721 40.774538689695895 12F-PM-1007-02 12F PM 10072018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9695305996721 40.7745386896959)
1437 -73.97212798086831 40.7661158663901 3I-PM-1013-02 03I PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9721279808683 40.7661158663901)
2488 -73.97269208477921 40.779411746388895 16A-PM-1019-02 16A PM 10192018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1 scared by dog POINT (-73.9726920847792 40.7794117463889)
2915 -73.9734630412566 40.7653097139415 1H-PM-1013-02 01H PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9734630412566 40.7653097139415)
2727 -73.974596903918 40.7765498215674 12A-PM-1013-02 12A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.974596903918 40.7765498215674)
2467 -73.9755923256429 40.7672967972471 3F-PM-1013-02 03F PM 10132018 2 Adult Black Gray Black+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 0 1   POINT (-73.97559232564292 40.7672967972471)
423 -73.97567542977471 40.7738518843446 9B-PM-1013-02 09B PM 10132018 2 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 1 0 1 0   POINT (-73.9756754297747 40.7738518843446)
1749 -73.97568253382991 40.7755542506699 11A-PM-1013-02 11A PM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9756825338299 40.7755542506699)
1909 -73.9772070122251 40.7694343352509 4C-PM-1010-02 04C PM 10102018 2 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.97720701222511 40.7694343352509)

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