2018_Central_Park_Squirrel_Census_-_Squirrel_Data

20 rows where Highlight Fur Color = "Black, Cinnamon, White" and Tail twitches = 0 sorted by Date

View and edit SQL

Suggested facets: Hectare, Shift, Date, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Running, Climbing, Eating, Foraging, Kuks, Tail flags, Indifferent, Runs from

Approaches

  • 0 18
  • 1 2

Tail twitches

Highlight Fur Color

  • Black, Cinnamon, White · 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
379 -73.9606817053484 40.7917320450401 32D-PM-1006-07 32D PM 10062018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 1 0   POINT (-73.9606817053484 40.7917320450401)
673 -73.958417813526 40.792730121447605 34E-PM-1006-01 34E PM 10062018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   0 0 0 0 0 sitting and watching on a tree 0 0 0 0 0 0 1 0   POINT (-73.958417813526 40.7927301214476)
1969 -73.96890514730721 40.7764511282884 14F-AM-1007-04 14F AM 10072018 4 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 1 0   POINT (-73.9689051473072 40.7764511282884)
328 -73.96523572796708 40.781929688714705 21E-PM-1012-02 21E PM 10122018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9652357279671 40.7819296887147)
420 -73.96718516112429 40.7750878657618 14H-PM-1012-01 14H PM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 0   0 0 0 0 0 1 0 0 approaches (came very close to me) POINT (-73.9671851611243 40.7750878657618)
568 -73.97994414934041 40.767149999752704 1C-AM-1012-01 01C AM 10122018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 0 0 0   0 0 0 1 0 0 0 1   POINT (-73.9799441493404 40.7671499997527)
571 -73.9659549963516 40.7833659689194 22D-PM-1012-05 22D PM 10122018 5 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White         0 0 0 1 0   0 0 0 0 0 0 1 0   POINT (-73.9659549963516 40.7833659689194)
706 -73.95701325709341 40.793201415908705 35F-PM-1012-01 35F PM 10122018 1 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 1 1   0 0 0 1 0 0 1 1   POINT (-73.9570132570934 40.7932014159087)
1219 -73.96618922004741 40.7836798072777 22D-PM-1012-06 22D PM 10122018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   1 0 0 0 0   0 0 0 0 0 0 0 1   POINT (-73.9661892200474 40.7836798072777)
1625 -73.9736873018042 40.76491066771379 1I-PM-1012-02 01I PM 10122018 2 Juvenile Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. Above Ground 1 tree 0 0 1 0 0   1 0 0 0 0 0 0 1   POINT (-73.9736873018042 40.7649106677138)
2852 -73.9728146482385 40.7652951714745 1I-PM-1012-03 01I PM 10122018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Gray, Black, & Cinnamon selected as Primary. Gray, Black, & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   0 0 0 1 0   0 0 0 1 0 0 0 1   POINT (-73.97281464823851 40.765295171474506)
3021 -73.96658719935171 40.783677506488296 22D-PM-1012-07 22D PM 10122018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 1 0   POINT (-73.9665871993517 40.7836775064883)
1967 -73.96472472541271 40.780613656578396 20G-PM-1013-03 20G PM 10132018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 1 0 0 0 1   POINT (-73.9647247254127 40.7806136565784)
829 -73.9711801122578 40.778688894221396 16C-AM-1014-02 16C AM 10142018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 1 0 0   POINT (-73.97118011225781 40.77868889422141)
1537 -73.97672201797249 40.77532621031229 10A-PM-1014-03 10A PM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground   above my head in tree 0 0 0 1 0 eating (in a tree) 0 0 0 0 0 0 1 0 indifferent (lots of people taking its picture,didn't bother it) POINT (-73.9767220179725 40.7753262103123)
2096 -73.97089038621759 40.778737067464206 16C-AM-1014-03 16C AM 10142018 3 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 0 1   0 0 0 0 0 0 1 0   POINT (-73.9708903862176 40.7787370674642)
113 -73.9700100617602 40.7815739959357 19B-PM-1018-01 19B PM 10182018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 20   1 0 0 0 0 flying 0 0 0 0 0 0 0 0   POINT (-73.9700100617602 40.7815739959357)
1286 -73.9589096782789 40.793969875790296 35D-AM-1019-02 35D AM 10192018 2 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White Black tail & edge, Cinnamon mid, While tail edge Ground Plane FALSE   0 0 0 0 1 very quietly searching in long grass 0 0 0 0 0 0 0 0   POINT (-73.9589096782789 40.7939698757903)
2079 -73.96430251719141 40.790570391517 30B-PM-1019-06 30B PM 10192018 6 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9643025171914 40.790570391517)
2825 -73.96435075880079 40.790432469329204 30B-PM-1019-07 30B PM 10192018 7 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Ground Plane FALSE   0 0 0 1 1   0 0 0 0 0 0 0 1   POINT (-73.96435075880082 40.7904324693292)

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