2018_Central_Park_Squirrel_Census_-_Squirrel_Data

27 rows where Climbing = 1, Highlight Fur Color = "Cinnamon, White" and Shift = "PM" sorted by Unique Squirrel ID

✎ View and edit SQL

This data as json, CSV (advanced)

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

Approaches ✖

  • 0 26
  • 1 1

Shift ✖

Moans ✖

  • 0 27

Highlight Fur Color ✖

  • Cinnamon, White · 27 ✖

Climbing ✖

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
2323 2323 -73.9715921982161 40.7746153066601 11E-PM-1012-06 11E PM 10122018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. Above Ground 5   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9715921982161 40.7746153066601)
2054 2054 -73.97263812347471 40.7752694815985 12D-PM-1014-01 12D PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9726381234747 40.7752694815985)
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)
2210 2210 -73.9699124811406 40.7743016981538 12F-PM-1007-07 12F PM 10072018 7 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9699124811406 40.7743016981538)
2187 2187 -73.96991340526091 40.774446589038 12F-PM-1007-14 12F PM 10072018 14 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 1 1 0   POINT (-73.9699134052609 40.774446589038)
236 236 -73.9737266070919 40.7786338379896 14A-PM-1014-01 14A PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9737266070919 40.7786338379896)
726 726 -73.973305698325 40.778382331129606 14A-PM-1014-06 14A PM 10142018 6 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 9   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.973305698325 40.7783823311296)
776 776 -73.9686816795392 40.775770422666994 14F-PM-1012-02 14F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9686816795392 40.775770422667)
288 288 -73.9731113265165 40.778664067635496 15A-PM-1017-01 15A PM 10172018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10   0 0 1 1 0 eating in tree 0 0 0 0 0 0 1 0   POINT (-73.9731113265165 40.7786640676355)
782 782 -73.9710559113762 40.779427991420896 16C-PM-1018-01 16C PM 10182018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 3   0 0 1 0 0   0 0 0 0 0 0 0 0 disappeared up other side of tree POINT (-73.9710559113762 40.7794279914209)
1161 1161 -73.9694066600156 40.7805662180672 18C-PM-1018-06 18C PM 10182018 6 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9694066600156 40.7805662180672)
2301 2301 -73.968906907671 40.781627826784295 19C-PM-1018-07 19C PM 10182018 7 Juvenile Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray & White selected as Highlights. Made executive adjustments. Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.968906907671 40.7816278267843)
1331 1331 -73.9588809150045 40.7847231576181 26I-PM-1010-01 26I PM 10102018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9588809150045 40.7847231576181)
908 908 -73.9594120573719 40.78419457505979 26I-PM-1010-05 26I PM 10102018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 tree 0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9594120573719 40.7841945750598)
964 964 -73.9631045499811 40.790618096947206 30B-PM-1019-04 30B PM 10192018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9631045499811 40.7906180969472)
274 274 -73.9639832886071 40.7909532437095 30B-PM-1019-08 30B PM 10192018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9639832886071 40.7909532437095)
1592 1592 -73.9575517912392 40.788915826819206 31H-PM-1008-05 31H PM 10082018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground     0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9575517912392 40.7889158268192)
2485 2485 -73.9584950620879 40.790277071064295 32F-PM-1008-03 32F PM 10082018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9584950620879 40.7902770710643)
2511 2511 -73.95845615374209 40.791121116475395 33F-PM-1012-02 33F PM 10122018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 1 0 0 0   POINT (-73.9584561537421 40.7911211164754)
2090 2090 -73.9569759970802 40.7931497452294 35F-PM-1012-03 35F PM 10122018 3 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 7   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9569759970802 40.79314974522941)
2251 2251 -73.9587678566254 40.7962656030995 38C-PM-1014-01 38C PM 10142018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 20   0 0 1 0 0   1 0 0 0 0 0 0 0   POINT (-73.9587678566254 40.7962656030995)
2776 2776 -73.9789687905912 40.769269313932796 3B-PM-1007-04 03B PM 10072018 4 Juvenile Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 4 At fence 1 0 1 1 0   0 0 0 0 1 0 1 1   POINT (-73.9789687905912 40.7692693139328)
795 795 -73.9582523503306 40.7996897499473 41A-PM-1007-05 41A PM 10072018 5 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9582523503306 40.7996897499473)
2829 2829 -73.95652309635541 40.798556387711 41C-PM-1007-02 41C PM 10072018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9565230963554 40.798556387711)
2916 2916 -73.95175251116791 40.7974407641075 42G-PM-1014-02 42G PM 10142018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 14   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9517525111679 40.7974407641075)
2508 2508 -73.97938145045201 40.770903369788705 4A-PM-1007-01 04A PM 10072018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 1 1   0 0 0 0 1 0 1 0   POINT (-73.979381450452 40.770903369788705)
1125 1125 -73.9775735077285 40.7692872082165 4C-PM-1010-08 04C PM 10102018 8 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 10 on stone arch 1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9775735077285 40.7692872082165)

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