This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Runs from
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50 | 50 | -73.96806350709491 | 40.779249873647 | 17E-AM-1017-05 | 17E | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Branch | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9680635070949 40.779249873647) | ||||
99 | 99 | -73.9710541405708 | 40.772469160571795 | 10F-PM-1019-05 | 10F | PM | 10192018 | 5 | Adult | Black | Black+ | Above Ground | 10 | Behind fence, tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710541405708 40.7724691605718) | ||||
182 | 182 | -73.9691050656013 | 40.780813953822204 | 18C-PM-1018-01 | 18C | PM | 10182018 | 1 | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9691050656013 40.7808139538222) | ||||||
473 | 473 | -73.95701300171591 | 40.799602742862504 | 42B-AM-1014-02 | 42B | AM | 10142018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570130017159 40.7996027428625) | ||||
481 | 481 | -73.9714303315699 | 40.774593494770606 | 11E-AM-1013-04 | 11E | AM | 10132018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | burying | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714303315699 40.7745934947706) | ||||
542 | 542 | -73.9713487591577 | 40.7784353043714 | 15C-PM-1017-03 | 15C | PM | 10172018 | 3 | Adult | Black | Black+ | Above Ground | 17 | running across overpass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9713487591577 40.7784353043714) | ||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9547423290276 40.7899702628835) | |||||
608 | 608 | -73.95896759955171 | 40.791311922358396 | 33E-AM-1014-09 | 33E | AM | 10142018 | 9 | Juvenile | Black | Black+ | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9589675995517 40.7913119223584) | |||||
634 | 634 | -73.95963759070379 | 40.79073477083529 | 32E-AM-1007-05 | 32E | AM | 10072018 | 5 | Adult | Black | Black+ | Above Ground | 30 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9596375907038 40.79073477083531) | |||||
731 | 731 | -73.97335458025151 | 40.7675056025357 | 4G-AM-1006-04 | 04G | AM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733545802515 40.7675056025357) | |||||
746 | 746 | -73.9591407691 | 40.796084690312206 | 37B-AM-1018-01 | 37B | AM | 10182018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9591407691 40.7960846903122) | |||||
770 | 770 | -73.95977827620291 | 40.79207733767571 | 33D-AM-1017-07 | 33D | AM | 10172018 | 7 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9597782762029 40.7920773376757) | |||||
821 | 821 | -73.959077668148 | 40.7926045823346 | 34D-AM-1008-02 | 34D | AM | 10082018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959077668148 40.7926045823346) | |||||
854 | 854 | -73.95771130260559 | 40.7904332453456 | 32G-PM-1013-02 | 32G | PM | 10132018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9577113026056 40.7904332453456) | |||||
1026 | 1026 | -73.9710951149579 | 40.772501245008 | 10F-PM-1019-04 | 10F | PM | 10192018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | Behind fence, grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710951149579 40.772501245008) | ||||
1066 | 1066 | -73.9720174997123 | 40.774889426602705 | 11D-AM-1010-07 | 11D | AM | 10102018 | 7 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720174997123 40.7748894266027) | |||||
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) | ||
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) | |||||
1210 | 1210 | -73.97079374645409 | 40.772528270844795 | 10G-PM-1017-07 | 10G | PM | 10172018 | 7 | Adult | Black | White | Black+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | traveling | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9707937464541 40.7725282708448) | |||
1223 | 1223 | -73.95912985511109 | 40.7919612446005 | 33E-AM-1014-04 | 33E | AM | 10142018 | 4 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9591298551111 40.7919612446005) | ||||
1473 | 1473 | -73.9584064190878 | 40.7912992852442 | 33F-PM-1012-03 | 33F | PM | 10122018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9584064190878 40.7912992852442) | ||||
1516 | 1516 | -73.9625383795297 | 40.7883862331728 | 28D-AM-1012-03 | 28D | AM | 10122018 | 3 | Adult | Black | Black+ | Above Ground | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9625383795297 40.7883862331728) | |||||
1528 | 1528 | -73.9690104245067 | 40.7853358193723 | 23A-AM-1018-02 | 23A | AM | 10182018 | 2 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690104245067 40.7853358193723) | |||||
1959 | 1959 | -73.97077370737709 | 40.780037346583796 | 17B-PM-1012-02 | 17B | PM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 2/3 chasing each other | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9707737073771 40.7800373465838) | ||||
1979 | 1979 | -73.96127592913992 | 40.7930468323219 | 33B-AM-1010-03 | 33B | AM | 10102018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9612759291399 40.7930468323219) | |||||
2120 | 2120 | -73.9733905460282 | 40.7656337147768 | 2H-PM-1006-03 | 02H | PM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9733905460282 40.7656337147768) | |||||
2135 | 2135 | -73.9596251284566 | 40.7916254797561 | 33D-AM-1017-05 | 33D | AM | 10172018 | 5 | Adult | Black | Black+ | Above Ground | 5 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9596251284566 40.7916254797561) | |||||
2192 | 2192 | -73.9593410965431 | 40.7923134010383 | 33D-AM-1017-08 | 33D | AM | 10172018 | 8 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9593410965431 40.7923134010383) | |||||
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) | |||||
2270 | 2270 | -73.9703732649257 | 40.77019793771029 | 8H-PM-1014-04 | 08H | PM | 10142018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97037326492571 40.7701979377103) | |||||
2325 | 2325 | -73.9728360875598 | 40.7660637295671 | 3H-PM-1014-04 | 03H | PM | 10142018 | 4 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9728360875598 40.7660637295671) | ||||
2351 | 2351 | -73.97458184501092 | 40.765449887362706 | 1G-AM-1006-01 | 01G | AM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9745818450109 40.7654498873627) | |||||
2395 | 2395 | -73.9729603550254 | 40.7660215710657 | 3H-AM-1008-06 | 03H | AM | 10082018 | 6 | Adult | Black | Black+ | beauty! | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9729603550254 40.7660215710657) | ||||
2427 | 2427 | -73.97292974853309 | 40.767327854143794 | 4H-AM-1006-03 | 04H | AM | 10062018 | 3 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | met #4 while foraging and briefly tussled | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9729297485331 40.7673278541438) | ||||
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9706949930717 40.772362045852) | ||||
2540 | 2540 | -73.959127912788 | 40.79211971304029 | 33E-AM-1014-13 | 33E | AM | 10142018 | 13 | Adult | Black | Cinnamon | Black+Cinnamon | Cinnamon on the tail | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.959127912788 40.7921197130403) | ||
2549 | 2549 | -73.972248505758 | 40.76590436930079 | 3I-PM-1013-01 | 03I | PM | 10132018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.972248505758 40.765904369300806) | |||||
2572 | 2572 | -73.9719901848577 | 40.7720525965356 | 9F-PM-1014-07 | 09F | PM | 10142018 | 7 | Adult | Black | Black+ | !!! | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9719901848577 40.7720525965356) | ||||
2638 | 2638 | -73.9598973337711 | 40.793334636047796 | 34C-PM-1012-01 | 34C | PM | 10122018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | digging | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9598973337711 40.7933346360478) | ||||
2731 | 2731 | -73.9595886063173 | 40.7918405182594 | 33D-AM-1017-09 | 33D | AM | 10172018 | 9 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9595886063173 40.7918405182594) | ||||
2755 | 2755 | -73.9712022111028 | 40.767250436826295 | 4I-AM-1006-01 | 04I | AM | 10062018 | 1 | Adult | Black | Black+ | Above Ground | 3 | On top of park lamp | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9712022111028 40.7672504368263) | ||||
2768 | 2768 | -73.96410881726321 | 40.7886555184212 | 28C-AM-1014-01 | 28C | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9641088172632 40.7886555184212) | |||||
2773 | 2773 | -73.96259326649559 | 40.7885379477349 | 29D-AM-1014-01 | 29D | AM | 10142018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9625932664956 40.7885379477349) | |||||
2999 | 2999 | -73.972415182837 | 40.773080463452004 | 10E-AM-1010-02 | 10E | AM | 10102018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.972415182837 40.773080463452) |
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 );