This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2936 | 2936 | -73.9809876538513 | 40.768322324214296 | 1A-PM-1014-05 | 01A | PM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9809876538513 40.7683223242143) | ||||
2940 | 2940 | -73.963911430308 | 40.7809127228847 | 21G-AM-1014-05 | 21G | AM | 10142018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.963911430308 40.7809127228847) | ||||
131 | 131 | -73.9755560786227 | 40.7662992317575 | 2F-AM-1006-05 | 02F | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | curious but shy | POINT (-73.9755560786227 40.7662992317575) | |||
646 | 646 | -73.954092292214 | 40.7979800395433 | 41E-PM-1013-05 | 41E | PM | 10132018 | 5 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 10 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.954092292214 40.7979800395433) | |||
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) | ||||
1048 | 1048 | -73.9782120139407 | 40.7717154468791 | 6A-AM-1006-05 | 06A | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | curious | POINT (-73.9782120139407 40.7717154468791) | ||
1584 | 1584 | -73.9581310602492 | 40.7960214726964 | 38C-PM-1014-05 | 38C | PM | 10142018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | chasing (#4) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581310602492 40.7960214726964) | |||
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) | |||||
1950 | 1950 | -73.96430161168391 | 40.7904796216068 | 30B-PM-1019-05 | 30B | PM | 10192018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | hiding a nut | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9643016116839 40.7904796216068) | |||
2733 | 2733 | -73.9690082314914 | 40.7738993942891 | 12G-AM-1012-05 | 12G | AM | 10122018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9690082314914 40.7738993942891) | ||||
2873 | 2873 | -73.955068474109 | 40.79117881528779 | 34H-PM-1006-05 | 34H | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | white tail tip | Ground Plane | FALSE | in grass | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.955068474109 40.7911788152878) | ||
506 | 506 | -73.9649611089685 | 40.7814371834837 | 21F-AM-1018-05 | 21F | AM | 10182018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9649611089685 40.7814371834837) | ||||
905 | 905 | -73.9757216124349 | 40.7754310239649 | 11A-PM-1013-05 | 11A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9757216124349 40.7754310239649) | |||
1799 | 1799 | -73.978844141973 | 40.7696046074378 | 4B-AM-1010-05 | 04B | AM | 10102018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | chasing squirrel #6 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.978844141973 40.7696046074378) | |||
1891 | 1891 | -73.9749641575871 | 40.767330505627704 | 3F-AM-1006-05 | 03F | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9749641575871 40.7673305056277) | ||||
2245 | 2245 | -73.9774228454023 | 40.7686399839016 | 3D-AM-1006-05 | 03D | AM | 10062018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (chased by boy),wary of humans in playground | POINT (-73.9774228454023 40.7686399839016) | |||
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) | ||||
2651 | 2651 | -73.9632993246327 | 40.78881995196561 | 29C-AM-1007-05 | 29C | AM | 10072018 | 5 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9632993246327 40.7888199519656) | ||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9621297946132 40.7944058222814) | ||||
1165 | 1165 | -73.9689504114652 | 40.77667701537639 | 14F-PM-1012-05 | 14F | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 2 | on a fallen branch | 1 | 0 | 0 | 1 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | looking at me | POINT (-73.9689504114652 40.7766770153764) | |
1947 | 1947 | -73.97471754195459 | 40.769282003087795 | 5E-PM-1012-05 | 05E | PM | 10122018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | begging | POINT (-73.9747175419546 40.7692820030878) | |||
2152 | 2152 | -73.9686925781295 | 40.7705688673142 | 9I-PM-1010-05 | 09I | PM | 10102018 | 5 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9686925781295 40.7705688673142) | ||||
80 | 80 | -73.9688454483585 | 40.78453012881629 | 22A-AM-1008-05 | 22A | AM | 10082018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 3 | trash can | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9688454483585 40.7845301288163) | |||
128 | 128 | -73.97462290946429 | 40.7748467061969 | 10B-PM-1014-05 | 10B | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | avoided people | POINT (-73.9746229094643 40.7748467061969) | |||
277 | 277 | -73.96190702296741 | 40.795255669250004 | 35A-AM-1014-05 | 35A | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9619070229674 40.79525566925) | ||||
436 | 436 | -73.9734695768004 | 40.7716297491384 | 8E-PM-1008-05 | 08E | PM | 10082018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 5, 6, 7 all at same tree trunk base | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9734695768004 40.7716297491384) | |||
574 | 574 | -73.97063600052749 | 40.7717074044466 | 9G-PM-1007-05 | 09G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9706360005275 40.7717074044466) | ||||
590 | 590 | -73.97851333014259 | 40.77182602883379 | 6A-PM-1012-05 | 06A | PM | 10122018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9785133301426 40.7718260288338) | ||||
792 | 792 | -73.97301156879641 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9730115687964 40.7741018274312) | ||||
841 | 841 | -73.97469338525721 | 40.773313866931 | 9C-PM-1006-05 | 09C | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | w/ dog | POINT (-73.9746933852572 40.773313866931) | |||
887 | 887 | -73.9635028497015 | 40.7928207574906 | 32A-PM-1013-05 | 32A | PM | 10132018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9635028497015 40.7928207574906) | ||||
940 | 940 | -73.9700879096644 | 40.7765899724756 | 14E-PM-1017-05 | 14E | PM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9700879096644 40.7765899724756) | ||||
1054 | 1054 | -73.9570050460867 | 40.7985192250745 | 40C-AM-1017-05 | 40C | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9570050460867 40.7985192250745) | ||||
1157 | 1157 | -73.9704449096084 | 40.76899707783029 | 6I-PM-1013-05 | 06I | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing with #6 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9704449096084 40.7689970778303) | |||
1224 | 1224 | -73.95725308434791 | 40.7987460430546 | 41B-AM-1010-05 | 41B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9572530843479 40.7987460430546) | ||||
1259 | 1259 | -73.976864402584 | 40.7705663751959 | 5C-PM-1010-05 | 05C | PM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.976864402584 40.7705663751959) | ||||
1292 | 1292 | -73.959019987128 | 40.791254669180496 | 33E-PM-1012-05 | 33E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.959019987128 40.7912546691805) | |||
1324 | 1324 | -73.954554245377 | 40.7983935730557 | 41E-AM-1007-05 | 41E | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | man/pit bull mix wandered | POINT (-73.954554245377 40.7983935730557) | |||
1347 | 1347 | -73.9616693665254 | 40.792971019627 | 33B-AM-1010-05 | 33B | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9616693665254 40.792971019627) | ||||
1466 | 1466 | -73.96511776576759 | 40.7812408103825 | 20F-PM-1007-05 | 20F | PM | 10072018 | 5 | Juvenile | Gray | White | Gray+White | white tail | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9651177657676 40.781240810382506) | |||
1489 | 1489 | -73.9501762527462 | 40.797553408607705 | 42H-PM-1014-05 | 42H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 15 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9501762527462 40.7975534086077) | ||||
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) | ||
1728 | 1728 | -73.9787846880249 | 40.768254590348796 | 2C-PM-1013-05 | 02C | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9787846880249 40.7682545903488) | ||||
1758 | 1758 | -73.9581241870185 | 40.7961057536141 | 38C-AM-1019-05 | 38C | AM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9581241870185 40.7961057536141) | ||||
2002 | 2002 | -73.9581706950566 | 40.790632139726895 | 32F-AM-1012-05 | 32F | AM | 10122018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 10 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9581706950566 40.7906321397269) | ||||
2061 | 2061 | -73.9608834102446 | 40.790624710005005 | 31D-AM-1014-05 | 31D | AM | 10142018 | 5 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9608834102446 40.790624710005) | ||||
2084 | 2084 | -73.9567255763265 | 40.7936331899263 | 36F-AM-1017-05 | 36F | AM | 10172018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 8 | 0 | 0 | 0 | 0 | 0 | staying very still to avoid two very curious dogs on the ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | petrified,frozen (tail over its back,frozen) | POINT (-73.9567255763265 40.7936331899263) | ||
2087 | 2087 | -73.956502663005 | 40.788160908881004 | 30I-PM-1006-05 | 30I | PM | 10062018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.956502663005 40.788160908881) | ||||
2173 | 2173 | -73.95461232594408 | 40.7941434862099 | 37G-PM-1007-05 | 37G | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | jumping around! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9546123259441 40.7941434862099) | |||
2344 | 2344 | -73.9786310308892 | 40.766934936818295 | 1D-AM-1006-05 | 01D | AM | 10062018 | 5 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9786310308892 40.7669349368183) | ||||
2659 | 2659 | -73.95536034380208 | 40.7985282963244 | 41D-PM-1014-05 | 41D | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 12 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9553603438021 40.7985282963244) | ||||
2701 | 2701 | -73.97912175106559 | 40.767658347539395 | 2C-AM-1010-05 | 02C | AM | 10102018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | right at the base of the same tree as #3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9791217510656 40.7676583475394) | |||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.97518067271972 40.7671940332258) | ||||
2944 | 2944 | -73.97394038506219 | 40.769316228750895 | 5F-AM-1007-05 | 05F | AM | 10072018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 2 | tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9739403850622 40.7693162287509) |
JSON shape: default, array, newline-delimited
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 );