2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Date = 10182018, Hectare Squirrel Number = 2 and Shift = "PM" sorted by Runs from

✎ View and edit SQL

This data as json, CSV (advanced)

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

Tail twitches ✖

  • 0 18
  • 1 2

Shift ✖

Hectare Squirrel Number ✖

Date ✖

  • 10182018 · 20 ✖
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
119 119 -73.9592038887673 40.796382675378 38B-PM-1018-02 38B PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1 burying nut 0 0 0 0 0 0 0 0   POINT (-73.9592038887673 40.796382675378)
469 469 -73.9717201378775 40.776120280884 13D-PM-1018-02 13D PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9717201378775 40.776120280884)
882 882 -73.9786805884996 40.769755923192704 4B-PM-1018-02 04B PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 1 0 0   POINT (-73.9786805884996 40.7697559231927)
938 938 -73.96994511963959 40.7710409982701 9H-PM-1018-02 09H PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9699451196396 40.7710409982701)
995 995 -73.9698843507358 40.780375418758105 18C-PM-1018-02 18C PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.9698843507358 40.7803754187581)
1085 1085 -73.9722265046794 40.7700916895929 7G-PM-1018-02 07G PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9722265046794 40.7700916895929)
1086 1086 -73.9713399316534 40.77506780267571 12E-PM-1018-02 12E PM 10182018 2 Adult Black Cinnamon, White Black+Cinnamon, White Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 3   0 0 1 0 0 lounging on tree upside down 0 0 0 0 1 0 1 0   POINT (-73.9713399316534 40.7750678026757)
1370 1370 -73.9681627331154 40.7785099665602 17E-PM-1018-02 17E PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE On the rock 1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9681627331154 40.7785099665602)
1396 1396 -73.9704677007779 40.7786860108302 16C-PM-1018-02 16C PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 6   0 1 0 1 1   0 0 0 0 1 0 1 0   POINT (-73.9704677007779 40.7786860108302)
1415 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)
1531 1531 -73.9630381400083 40.7807571827321 21H-PM-1018-02 21H PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 1 0 0 0   0 0 0 1 0 0 1 0   POINT (-73.9630381400083 40.7807571827321)
1539 1539 -73.9681874036914 40.7817948690964 20C-PM-1018-02 20C PM 10182018 2 Adult Gray   Gray+   Ground Plane FALSE   1 1 0 0 0   0 0 0 0 0 0 0 0   POINT (-73.9681874036914 40.7817948690964)
1691 1691 -73.9703705008688 40.7818586173755 19B-PM-1018-02 19B PM 10182018 2 Adult Gray Black, Cinnamon Gray+Black, Cinnamon Gray & Cinnamon selected as Primary. Black selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9703705008688 40.7818586173755)
1970 1970 -73.96314646937691 40.793415656751 33A-PM-1018-02 33A PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 Tree cavity [of] London Plane tree 0 0 0 0 0 hanging out,watching world 0 0 0 0 0 0 0 0 watching POINT (-73.9631464693769 40.793415656751)
2048 2048 -73.96276614653759 40.7819356810575 22G-PM-1018-02 22G PM 10182018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9627661465376 40.7819356810575)
2444 2444 -73.966590487009 40.780246905289104 19E-PM-1018-02 19E PM 10182018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 0 0 0   POINT (-73.96659048700901 40.7802469052891)
2681 2681 -73.968807163616 40.7812018159499 19C-PM-1018-02 19C PM 10182018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 0   POINT (-73.968807163616 40.7812018159499)
1434 1434 -73.9760749752948 40.7703284894392 5D-PM-1018-02 05D PM 10182018 2 Adult Gray   Gray+   Above Ground 2 On low fence 0 0 0 1 0   0 0 0 0 0 0 0 1   POINT (-73.9760749752948 40.7703284894392)
2432 2432 -73.9657203199746 40.775173008911 14I-PM-1018-02 14I PM 10182018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 0 1   POINT (-73.9657203199746 40.775173008911)
3018 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)

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