2018_Central_Park_Squirrel_Census_-_Squirrel_Data

152 rows where Climbing = 1 and Hectare Squirrel Number = 1 sorted by Location

✎ View and edit SQL

This data as json, CSV (advanced)

Hectare Squirrel Number ✖

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
2569 2569 -73.9559663734409 40.794582826137706 37F-AM-1010-01 37F AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 1 0 0 1 0   POINT (-73.9559663734409 40.7945828261377)
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)
2609 2609 -73.95968653180941 40.7893787188526 31F-AM-1013-01 31F AM 10132018 1 Adult Gray Black Gray+Black   Above Ground 25   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9596865318094 40.7893787188526)
2652 2652 -73.96205425147491 40.794373172213795 34A-AM-1012-01 34A AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10 chasing from tree to ground 1 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9620542514749 40.7943731722138)
2700 2700 -73.9601988871514 40.7943473161329 35C-PM-1013-01 35C PM 10132018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20   0 0 1 0 1   1 1 0 1 1 0 1 0   POINT (-73.9601988871514 40.7943473161329)
2724 2724 -73.96114340826671 40.7893671772846 30E-PM-1008-01 30E PM 10082018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 40   0 0 1 0 0   0 1 0 0 0 0 0 0   POINT (-73.9611434082667 40.7893671772846)
2729 2729 -73.9615429203441 40.7907417648701 31D-AM-1014-01 31D AM 10142018 1   Gray Cinnamon Gray+Cinnamon   Above Ground 20 Ground then up tree 0 0 1 0 0 chased by a doggo 0 0 1 0 0 0 0 1 runs from (dogs!) POINT (-73.9615429203441 40.7907417648701)
2748 2748 -73.960094705031 40.7916066137699 33D-AM-1017-01 33D AM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.960094705031 40.7916066137699)
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)
2872 2872 -73.96153964579959 40.792359436678296 33C-AM-1012-01 33C AM 10122018 1 Adult Gray Cinnamon Gray+Cinnamon Cinnamon along tail & back Above Ground 20 tree branches 0 1 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9615396457996 40.7923594366783)
2874 2874 -73.9597453664295 40.7891382153733 30F-PM-1007-01 30F PM 10072018 1 Adult Gray Black, Cinnamon, White Gray+Black, Cinnamon, White   Above Ground 1 tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9597453664295 40.7891382153733)
2896 2896 -73.970595860252 40.7832060751268 20A-AM-1010-01 20A AM 10102018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.970595860252 40.7832060751268)
2911 2911 -73.9793923984874 40.770847547458295 5A-AM-1006-01 05A AM 10062018 1 Adult Gray   Gray+   Above Ground 10 Oak tree near rock outcropping 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.97939239848742 40.7708475474583)
2942 2942 -73.9672063784809 40.7826070395665 21D-PM-1008-01 21D PM 10082018 1   Gray   Gray+   Above Ground 8   0 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.9672063784809 40.7826070395665)
2956 2956 -73.9654741695628 40.7890427851106 28B-PM-1010-01 28B PM 10102018 1 Adult Gray White Gray+White   Above Ground 10 in a tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9654741695628 40.7890427851106)
2973 2973 -73.9766693184436 40.7708879215854 6C-PM-1020-01 06C PM 10202018 1 Adult Gray White Gray+White   Above Ground 25 Across Transverse 0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9766693184436 40.7708879215854)
3017 3017 -73.9662895079734 40.7843300758044 23C-AM-1019-01 23C AM 10192018 1 Adult Gray Cinnamon, White Gray+Cinnamon, White Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments. Above Ground 7   0 0 1 1 0 eating (on branch) 1 0 0 0 0 0 1 0   POINT (-73.9662895079734 40.7843300758044)
52 52 -73.9675634326877 40.781347735250705 19D-AM-1007-01 19D AM 10072018 1 Juvenile Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 0 fenced off area can't approach POINT (-73.9675634326877 40.7813477352507)
97 97 -73.9639744005647 40.782511195076395 22F-AM-1007-01 22F AM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 1 0   POINT (-73.9639744005647 40.7825111950764)
197 197 -73.9679336341793 40.7754186579647 14G-PM-1013-01 14G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0 watching POINT (-73.9679336341793 40.7754186579647)
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)
321 321 -73.96942888062121 40.7842952265291 22A-PM-1017-01 22A PM 10172018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9694288806212 40.7842952265291)
373 373 -73.96721272832829 40.7810666805133 20D-AM-1007-01 20D AM 10072018 1 Adult Gray   Gray+ too far to note 30' Ground Plane FALSE   1 0 1 1 0 a lot of activity 0 0 0 1 0 0 0 0   POINT (-73.9672127283283 40.7810666805133)
457 457 -73.965848283831 40.779724303305706 19F-PM-1017-01 19F PM 10172018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.965848283831 40.7797243033057)
470 470 -73.95812430217221 40.794431473386 36D-AM-1007-01 36D AM 10072018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1 avoiding a dog POINT (-73.95812430217221 40.794431473386)
643 643 -73.976730206737 40.773709213913996 8A-PM-1014-01 08A PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   1 0 0 0 0 0 0 1 runs from (goes up a tree) POINT (-73.976730206737 40.773709213914)
674 674 -73.9779811967788 40.7675178797546 2D-AM-1007-01 02D AM 10072018 1 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.9779811967788 40.7675178797546)
690 690 -73.9767949141123 40.774454583585 9A-PM-1010-01 09A PM 10102018 1 Adult     +   Ground Plane FALSE by large tree in sectioned off area 0 0 1 0 0 i think it climbed the tree when i first saw it. 0 0 0 0 0 0 1 0   POINT (-73.9767949141123 40.774454583585)
768 768 -73.9729394928432 40.774325671649606 11D-AM-1010-01 11D AM 10102018 1 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.9729394928432 40.7743256716496)
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)
837 837 -73.9557172336815 40.79211256577221 35G-PM-1006-01 35G PM 10062018 1 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9557172336815 40.7921125657722)
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)
1051 1051 -73.96137470327021 40.7920483852431 33C-PM-1007-01 33C PM 10072018 1 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9613747032702 40.792048385243106)
1193 1193 -73.9731880656287 40.766002618615495 2H-AM-1006-01 02H AM 10062018 1 Adult Black   Black+   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9731880656287 40.7660026186155)
1215 1215 -73.9728895595977 40.769937833229896 6F-AM-1006-01 06F AM 10062018 1 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9728895595977 40.7699378332299)
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)
1534 1534 -73.9695226023739 40.7797527775804 17D-AM-1008-01 17D AM 10082018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9695226023739 40.7797527775804)
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)
1667 1667 -73.96459890035891 40.778215745915496 18H-PM-1014-01 18H PM 10142018 1 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9645989003589 40.7782157459155)
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)
1739 1739 -73.96397004344492 40.777500305002796 17I-AM-1014-01 17I AM 10142018 1 Adult Cinnamon Gray, White Cinnamon+Gray, White   Ground Plane FALSE Running across fence between statue & swings 1 0 1 1 0   0 0 0 0 0 0 1 0   POINT (-73.9639700434449 40.7775003050028)
1918 1918 -73.9632866142841 40.7890043294436 29C-PM-1006-01 29C PM 10062018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 0 not too shy POINT (-73.96328661428412 40.78900432944361)
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)
2044 2044 -73.97715523261991 40.7706917595308 5C-AM-1006-01 05C AM 10062018 1 Adult Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 1 0 1 0 0   POINT (-73.9771552326199 40.7706917595308)
2118 2118 -73.958369699409 40.79024566683321 32F-PM-1008-01 32F PM 10082018 1 Adult Gray   Gray+   Ground Plane FALSE   1 1 1 1 1   0 0 0 0 0 0 1 0   POINT (-73.958369699409 40.7902456668332)
2338 2338 -73.9716621112698 40.774286221946895 11E-AM-1013-01 11E AM 10132018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9716621112698 40.7742862219469)
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)
2435 2435 -73.972087127535 40.776237268628 13C-AM-1010-01 13C AM 10102018 1 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.972087127535 40.776237268628)
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)
2696 2696 -73.9501457233643 40.797094356558 42I-PM-1014-01 42I PM 10142018 1 Adult Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9501457233643 40.797094356558)
2794 2794 -73.9712187890707 40.7750640173134 12E-PM-1018-01 12E PM 10182018 1 Juvenile Cinnamon White Cinnamon+White   Ground Plane FALSE   1 0 1 0 0   1 0 0 1 0 0 0 1   POINT (-73.9712187890707 40.7750640173134)
2833 2833 -73.9552595564798 40.7889533029466 32I-PM-1007-01 32I PM 10072018 1 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 chirps 0 0 0 0 1 0 1 0   POINT (-73.9552595564798 40.7889533029466)

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