2018_Central_Park_Squirrel_Census_-_Squirrel_Data

127 rows where Climbing = 1 and Foraging = 1 sorted by Lat/Long

✎ View and edit SQL

This data as json, CSV (advanced)

Tail twitches ✖

  • 0 19
  • 1 8

Foraging ✖

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 ▼
2216 2216 -73.97351950184459 40.778714727971504 14A-AM-1014-02 14A AM 10142018 2 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9735195018446 40.7787147279715)
2423 2423 -73.973552877209 40.7715638228207 7E-PM-1013-01 07E PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Ground & Tree Base 1 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.973552877209 40.7715638228207)
833 833 -73.9741846413977 40.7762518164182 12B-PM-1018-01 12B PM 10182018 1 Adult Gray   Gray+   Ground Plane FALSE Climbing up rocks 0 0 1 0 1 climbing (up rocks) 0 0 0 0 0 0 0 1   POINT (-73.9741846413977 40.7762518164182)
2727 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)
508 508 -73.97469187620759 40.765523188367794 1G-AM-1006-02 01G AM 10062018 2 Juvenile Gray White Gray+White   Above Ground 30   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9746918762076 40.7655231883678)
1595 1595 -73.9754696312232 40.768191647091996 4E-AM-1020-02 04E AM 10202018 2 Adult Gray Cinnamon, White Gray+Cinnamon, White White selected as Primary. Cinnamon selected as Highlights. Made executive adjustments. Above Ground 15   0 0 1 0 1 foraging (on the tree itself) 0 0 0 0 0 0 1 0   POINT (-73.9754696312232 40.768191647092)
2259 2259 -73.975565603566 40.7738462518304 9B-AM-1010-03 09B AM 10102018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.975565603566 40.7738462518304)
241 241 -73.97602564775579 40.7703573131398 5D-AM-1020-02 05D AM 10202018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1 small jumps 0 0 0 0 0 0 0 0   POINT (-73.9760256477558 40.7703573131398)
2864 2864 -73.9761879300037 40.7683918970301 3E-PM-1008-01 03E PM 10082018 1 Adult Gray   Gray+   Above Ground 3   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9761879300037 40.7683918970301)
303 303 -73.9762348224648 40.7694522315322 4D-PM-1008-08 04D PM 10082018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 1 1 climbed fence staring at me - went up tree 0 0 0 0 0 0 0 1   POINT (-73.97623482246482 40.7694522315322)
1714 1714 -73.9763542780331 40.773653130362206 9B-AM-1010-02 09B AM 10102018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 1 in bush 0 0 1 0 1   0 0 0 0 1 0 0 1 froze POINT (-73.9763542780331 40.773653130362206)
625 625 -73.9764235373322 40.770606513989 5C-PM-1010-11 05C PM 10102018 11 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.97642353733221 40.770606513989)
1729 1729 -73.97650461090191 40.7736674124746 8B-AM-1007-04 08B AM 10072018 4 Adult Gray   Gray+   Above Ground 2   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9765046109019 40.7736674124746)
1299 1299 -73.9766653663947 40.7688767713012 4D-AM-1012-01 04D AM 10122018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9766653663947 40.7688767713012)
2317 2317 -73.97673696861709 40.7735074437085 8B-PM-1012-05 08B PM 10122018 5 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9767369686171 40.7735074437085)
2965 2965 -73.9767389132988 40.7689323691424 4D-PM-1008-10 04D PM 10082018 10 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 6 climbed the fence & posed for a picture 0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9767389132988 40.7689323691424)
2583 2583 -73.97696931406509 40.7684390015166 3D-AM-1006-01 03D AM 10062018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 9 up a tree 1 0 1 1 1 digging (?) 0 0 0 1 0 0 0 1 runs from (man led his dog into the area to chase squirrel) POINT (-73.9769693140651 40.7684390015166)
1035 1035 -73.97725699096729 40.7664804797448 1E-AM-1006-02 01E AM 10062018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 1 0 1 0   POINT (-73.9772569909673 40.7664804797448)
2854 2854 -73.9772908667333 40.7697207404744 4C-AM-1006-05 04C AM 10062018 5 Juvenile Gray White Gray+White   Above Ground 20   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.9772908667333 40.7697207404744)
1549 1549 -73.97779784978941 40.7668620784309 1D-AM-1006-01 01D AM 10062018 1 Juvenile Gray White Gray+White   Ground Plane FALSE   1 0 1 0 1   0 0 0 0 1 0 0 0   POINT (-73.9777978497894 40.7668620784309)
2574 2574 -73.978199543688 40.7695660563362 4C-PM-1010-17 04C PM 10102018 17 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE climbed up tree 1 0 1 0 1   0 0 0 0 1 0 0 1   POINT (-73.978199543688 40.7695660563362)
1983 1983 -73.97841448676391 40.771817766751106 6A-AM-1006-01 06A AM 10062018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 0 0   POINT (-73.9784144867639 40.7718177667511)
931 931 -73.97859484138829 40.7718908026758 6A-PM-1012-01 06A PM 10122018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0   POINT (-73.9785948413883 40.7718908026758)
2300 2300 -73.9789251806378 40.7699558513225 4B-AM-1010-02 04B AM 10102018 2 Juvenile Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 30   0 0 1 1 1   1 0 0 0 0 0 1 0   POINT (-73.9789251806378 40.7699558513225)
1683 1683 -73.9790889008147 40.7676402781925 1C-PM-1013-01 01C PM 10132018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 1 0 0   POINT (-73.9790889008147 40.7676402781925)
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)
798 798 -73.98085422862799 40.7678702158382 1B-AM-1012-17 01B AM 10122018 17 Adult Gray Cinnamon, White Gray+Cinnamon, White   Ground Plane FALSE   0 0 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.98085422862802 40.7678702158382)

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