2018_Central_Park_Squirrel_Census_-_Squirrel_Data

74 rows where Climbing = 1 and Date = 10132018 sorted by Combination of Primary and Highlight Color

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions

Moans ✖

  • 0 74

Date ✖

  • 10132018 · 74 ✖

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
222 222 -73.97702735535249 40.7732399463626 8A-AM-1013-03 08A AM 10132018 3 Juvenile     +   Above Ground 3 fence 1 1 1 1 0 playing tag together 0 0 0 0 0 1 0 0   POINT (-73.9770273553525 40.7732399463626)
794 794 -73.9790010565108 40.768573236954396 2C-PM-1013-09 02C PM 10132018 9 Adult     +   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9790010565108 40.7685732369544)
1938 1938 -73.9719879697272 40.7725625124591 9F-AM-1013-02 09F AM 10132018 2 Adult Black   Black+   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9719879697272 40.7725625124591)
2266 2266 -73.9716402454355 40.7665133780672 3I-PM-1013-08 03I PM 10132018 8 Adult Black   Black+   Above Ground 2   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9716402454355 40.7665133780672)
2535 2535 -73.9700101107283 40.7696729501144 7I-PM-1013-08 07I PM 10132018 8 Adult Black   Black+   Above Ground 4   0 0 1 0 0   0 0 0 0 1 0 0 0   POINT (-73.9700101107283 40.7696729501144)
2985 2985 -73.9721159387757 40.766050318863705 3I-PM-1013-03 03I PM 10132018 3 Adult Black Cinnamon Black+Cinnamon   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9721159387757 40.7660503188637)
1640 1640 -73.9564632239432 40.7904807427954 33G-AM-1013-01 33G AM 10132018 1 Adult Cinnamon   Cinnamon+   Above Ground 13 shelter in hole in tree 0 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9564632239432 40.7904807427954)
2554 2554 -73.9701505245419 40.768998364571 6I-PM-1013-07 06I PM 10132018 7 Adult Cinnamon   Cinnamon+   Above Ground 11   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9701505245419 40.768998364571004)
261 261 -73.9552861155228 40.788973931872 32I-AM-1013-05 32I AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552861155228 40.788973931872)
384 384 -73.968045072743 40.783662671722496 22C-AM-1013-02 22C AM 10132018 2 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 4   0 0 1 0 1   1 0 0 1 0 0 0 1   POINT (-73.968045072743 40.7836626717225)
852 852 -73.9609704650925 40.7938786854735 34B-AM-1013-03 34B AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   1 0 1 0 0 hopping 0 0 0 0 0 1 0 1   POINT (-73.9609704650925 40.7938786854735)
1017 1017 -73.9552035011902 40.7889851896334 32I-AM-1013-06 32I AM 10132018 6 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 3 In and below shrub 0 0 1 0 1   0 0 0 1 0 0 1 0   POINT (-73.9552035011902 40.7889851896334)
1145 1145 -73.9611446263364 40.7911003407299 32D-AM-1013-03 32D AM 10132018 3 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9611446263364 40.7911003407299)
1351 1351 -73.9610985171525 40.7913867116989 32D-AM-1013-01 32D AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9610985171525 40.7913867116989)
1354 1354 -73.97652692820591 40.774687663524794 9A-AM-1013-10 09A AM 10132018 10 Juvenile Cinnamon Gray Cinnamon+Gray   Ground Plane FALSE   0 0 1 1 0   0 0 0 0 0 0 0 1   POINT (-73.9765269282059 40.7746876635248)
1939 1939 -73.9540151828782 40.7920066170587 35H-AM-1013-01 35H AM 10132018 1 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 15 Climbing up tree 0 0 1 0 0   0 0 0 0 1 0 0 1   POINT (-73.9540151828782 40.7920066170587)
2646 2646 -73.9772239251936 40.7731716665766 8A-AM-1013-05 08A AM 10132018 5 Adult Cinnamon Gray Cinnamon+Gray   Above Ground 20   1 0 1 1 0   0 0 0 0 0 1 0 0   POINT (-73.9772239251936 40.7731716665766)
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)
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)
2194 2194 -73.960898739757 40.7961393097144 37A-PM-1013-02 37A PM 10132018 2 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.960898739757 40.7961393097144)
2595 2595 -73.9692676659807 40.7700678919108 8I-PM-1013-08 08I PM 10132018 8 Adult Cinnamon Gray, White Cinnamon+Gray, White   Above Ground 1   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.96926766598071 40.7700678919108)
2252 2252 -73.95377032313591 40.7915959393814 35I-AM-1013-01 35I AM 10132018 1 Adult Cinnamon White Cinnamon+White White underbelly Above Ground 18   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9537703231359 40.7915959393814)
147 147 -73.9564023626619 40.7905423546155 33G-AM-1013-02 33G AM 10132018 2 Adult Gray   Gray+   Above Ground 13 shelter in hole in tree 0 0 1 0 0   0 0 0 0 0 0 1 1   POINT (-73.9564023626619 40.7905423546155)
1188 1188 -73.9669529835992 40.787186415136496 25A-AM-1013-05 25A AM 10132018 5   Gray   Gray+   Ground Plane FALSE CROSS BRIDLE - INTO TREE TO AVOID DOGGO 1 0 1 0 0 d.p.t. 0 0 0 1 1 0 1 0 calm POINT (-73.96695298359921 40.7871864151365)
1442 1442 -73.961241953418 40.7941677113011 35B-PM-1013-07 35B PM 10132018 7 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 1 0 got fed twice by grandpa,grabbed from grass and ate in tree 0 0 0 0 0 1 1 1 approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. POINT (-73.961241953418 40.7941677113011)
1507 1507 -73.9699799501516 40.7736576286234 11F-AM-1013-02 11F AM 10132018 2 Adult Gray   Gray+   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9699799501516 40.7736576286234)
1594 1594 -73.9778730762957 40.770827251547 5B-PM-1013-05 05B PM 10132018 5 Adult Gray   Gray+   Above Ground 3   1 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9778730762957 40.770827251547)
1599 1599 -73.9782603348665 40.7705790257951 5B-PM-1013-06 05B PM 10132018 6 Adult Gray   Gray+   Above Ground 5   1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9782603348665 40.7705790257951)
1823 1823 -73.9612854506075 40.792083067357105 32C-PM-1013-04 32C PM 10132018 4 Juvenile Gray   Gray+   Above Ground     1 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9612854506075 40.7920830673571)
1854 1854 -73.9618076359384 40.7947808718203 35A-PM-1013-05 35A PM 10132018 5 Adult Gray   Gray+   Above Ground 3 in tree 0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9618076359384 40.7947808718203)
2175 2175 -73.9657487923637 40.7786823090663 18G-PM-1013-04 18G PM 10132018 4 Adult Gray   Gray+   Above Ground 3   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9657487923637 40.7786823090663)
2179 2179 -73.95596639495109 40.7974497269789 40D-AM-1013-07 40D AM 10132018 7 Adult Gray   Gray+   Above Ground 6   0 0 1 0 1   0 0 0 0 0 0 0 1 curious POINT (-73.9559663949511 40.7974497269789)
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)
2377 2377 -73.9704328573603 40.7739347247552 11F-AM-1013-03 11F AM 10132018 3 Adult Gray   Gray+   Above Ground 30   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9704328573603 40.7739347247552)
2534 2534 -73.9744368038675 40.7674281958115 3G-PM-1013-03 03G PM 10132018 3 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1 runs from (climbed tree to run from) POINT (-73.97443680386752 40.7674281958115)
2813 2813 -73.96591181893591 40.7765739928504 15H-AM-1013-02 15H AM 10132018 2 Adult Gray   Gray+   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9659118189359 40.7765739928504)
2820 2820 -73.9615926031253 40.7944223235385 35B-PM-1013-05 35B PM 10132018 5 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.96159260312531 40.7944223235385)
2934 2934 -73.9561669236168 40.799473743127706 42C-PM-1013-04 42C PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.9561669236168 40.7994737431277)
2982 2982 -73.9513477815203 40.7945259614138 39I-PM-1013-02 39I PM 10132018 2 Juvenile Gray   Gray+   Ground Plane FALSE along the road 0 1 1 0 0 playing 0 0 0 0 0 0 0 0   POINT (-73.9513477815203 40.7945259614138)
3012 3012 -73.96137019608979 40.7943363227822 35B-PM-1013-04 35B PM 10132018 4 Adult Gray   Gray+   Ground Plane FALSE   1 0 1 0 1 got threatened by dog (same dog,dog #1) 0 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9613701960898 40.7943363227822)
567 567 -73.9756972647636 40.773624164826 9B-PM-1013-04 09B PM 10132018 4 Juvenile Gray Black Gray+Black   Above Ground 30   0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.9756972647636 40.773624164826)
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)
135 135 -73.9694168118643 40.7728877377977 11G-PM-1013-01 11G PM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5 In the Woods/Brush 0 0 1 0 1   0 0 0 0 0 0 0 1 watching me POINT (-73.9694168118643 40.7728877377977)
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)
201 201 -73.9598015842806 40.7973522744237 38A-PM-1013-03 38A PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598015842806 40.7973522744237)
271 271 -73.9661262885099 40.7844085550945 23D-AM-1013-01 23D AM 10132018 1 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 3   0 0 1 0 0   0 0 0 0 0 1 0 0 approaches (he saw me,came towards,then darted up) POINT (-73.9661262885099 40.7844085550945)
374 374 -73.9556817958407 40.788852000621 32I-AM-1013-02 32I AM 10132018 2 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556817958407 40.788852000621)
797 797 -73.969345754447 40.7770429650288 15E-AM-1013-02 15E AM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 20   1 0 1 0 0   0 0 0 0 0 1 0 0   POINT (-73.969345754447 40.7770429650288)
1273 1273 -73.95589438800509 40.7971535141896 40D-PM-1013-06 40D PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 4   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9558943880051 40.7971535141896)
1467 1467 -73.9684657285532 40.7840113573723 22B-AM-1013-05 22B AM 10132018 5 Adult Gray Cinnamon Gray+Cinnamon   Above Ground   tree 0 0 1 0 0   0 0 0 0 0 0 0 0 looked down on me like her imperial subject POINT (-73.9684657285532 40.7840113573723)
1480 1480 -73.96285255338309 40.793844934501706 34A-PM-1013-02 34A PM 10132018 2 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 1 1 eating upside down on tree trunk 0 0 0 0 0 0 0 0   POINT (-73.9628525533831 40.7938449345017)
1522 1522 -73.95389705545321 40.7955196793479 39G-PM-1013-03 39G PM 10132018 3 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9538970554532 40.7955196793479)
2132 2132 -73.967472660349 40.7772125619715 16F-PM-1013-03 16F PM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 4 Woods 0 0 1 0 1   0 0 0 0 0 0 0 1   POINT (-73.96747266034902 40.7772125619715)
2242 2242 -73.9565824187667 40.797312050952 40D-AM-1013-06 40D AM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 15   1 0 1 0 1   1 0 0 0 1 0 0 1   POINT (-73.9565824187667 40.797312050952)
2262 2262 -73.9556177490335 40.788856916153705 32I-AM-1013-03 32I AM 10132018 3 Juvenile Gray Cinnamon Gray+Cinnamon   Above Ground 15   0 0 1 0 0   0 0 0 0 0 0 0 0 watching me from tree - curious POINT (-73.9556177490335 40.7888569161537)
2366 2366 -73.96761918469849 40.777641740816996 16F-PM-1013-04 16F PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Above Ground 10   0 0 1 1 1   0 0 0 0 0 0 0 1   POINT (-73.9676191846985 40.777641740817)
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)
2562 2562 -73.9615643742864 40.7944678447843 35B-PM-1013-06 35B PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   1 0 1 0 0 chased by dog #2 1 0 0 0 0 0 0 1 runs from (dog) POINT (-73.9615643742864 40.7944678447843)
2664 2664 -73.95983503855409 40.7973274000224 38A-PM-1013-04 38A PM 10132018 4 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9598350385541 40.7973274000224)
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)
2720 2720 -73.9566300789162 40.7993692120774 42C-PM-1013-06 42C PM 10132018 6 Adult Gray Cinnamon Gray+Cinnamon   Ground Plane FALSE Between park and main drag 0 0 1 1 0   0 0 0 0 0 0 1 1   POINT (-73.9566300789162 40.7993692120774)
1449 1449 -73.95611248920629 40.7949440648632 37E-AM-1013-04 37E AM 10132018 4 Adult Gray Cinnamon, White Gray+Cinnamon, White   Above Ground 8   0 0 1 1 0   1 0 0 0 0 0 0 1   POINT (-73.9561124892063 40.7949440648632)
856 856 -73.9591667162801 40.7937602121568 35D-PM-1013-07 35D PM 10132018 7 Juvenile Gray White Gray+White   Above Ground 12 tree 0 0 1 0 0   0 0 0 0 1 0 1 0   POINT (-73.95916671628011 40.7937602121568)
859 859 -73.9600964585868 40.7952339524416 36B-PM-1013-02 36B PM 10132018 2 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0   0 0 0 0 1 1 0 1   POINT (-73.9600964585868 40.7952339524416)
1225 1225 -73.95848035139392 40.7933802077327 35D-PM-1013-01 35D PM 10132018 1 Adult Gray White Gray+White   Above Ground 12   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584803513939 40.7933802077327)
1252 1252 -73.9777998932399 40.770981586533395 5B-PM-1013-02 05B PM 10132018 2 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9777998932399 40.7709815865334)
1587 1587 -73.9805517765469 40.7683044693163 2B-PM-1013-05 02B PM 10132018 5 Adult Gray White Gray+White   Ground Plane FALSE   1 0 1 0 0 climbing fence! 0 0 0 0 0 0 0 0 snuck into bike cart! POINT (-73.9805517765469 40.7683044693163)
1747 1747 -73.96657637976071 40.7761316400012 15H-AM-1013-03 15H AM 10132018 3 Adult Gray White Gray+White   Above Ground 10   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9665763797607 40.7761316400012)
1933 1933 -73.95848243616551 40.7934247634031 35D-PM-1013-02 35D PM 10132018 2 Adult Gray White Gray+White   Above Ground 24   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9584824361655 40.7934247634031)
1935 1935 -73.9675268877392 40.775040968171794 13H-AM-1013-01 13H AM 10132018 1 Adult Gray White Gray+White   Above Ground 5   0 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9675268877392 40.7750409681718)
2224 2224 -73.9662310606968 40.7747758221226 14I-AM-1013-01 14I AM 10132018 1 Adult Gray White Gray+White   Above Ground 10   1 0 1 0 0   0 0 0 0 0 0 1 0   POINT (-73.9662310606968 40.7747758221226)
2479 2479 -73.9657958433575 40.7763496875058 15H-AM-1013-01 15H AM 10132018 1 Adult Gray White Gray+White   Above Ground 50   0 0 1 0 0   0 0 0 0 0 0 0 0   POINT (-73.9657958433575 40.7763496875058)
2519 2519 -73.9589475065438 40.7934846881536 35D-PM-1013-06 35D PM 10132018 6 Adult Gray White Gray+White   Ground Plane FALSE   0 0 1 0 0   0 0 0 0 0 0 0 1   POINT (-73.9589475065438 40.7934846881536)
2815 2815 -73.97473113123941 40.76773197250439 3F-PM-1013-06 03F PM 10132018 6 Adult Gray White Gray+White   Above Ground 19   0 0 1 0 0   0 1 0 0 0 0 0 1   POINT (-73.97473113123941 40.7677319725044)

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