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, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||||
872 | 872 | -73.9551524422379 | 40.7910535596756 | 34H-PM-1006-01 | 34H | PM | 10062018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9551524422379 40.7910535596756) | |||||
1101 | 1101 | -73.95912925497 | 40.7925530280455 | 34D-AM-1008-01 | 34D | AM | 10082018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | staring at us | POINT (-73.95912925497001 40.7925530280455) | ||||
2166 | 2166 | -73.9711178122133 | 40.7672642958437 | 4I-PM-1007-01 | 04I | PM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9711178122133 40.76726429584371) | |||||
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) | |||||
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) | |||||
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) | ||||
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) | |||||
325 | 325 | -73.96309908232429 | 40.788576428401605 | 28D-AM-1012-02 | 28D | AM | 10122018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9630990823243 40.7885764284016) | |||||
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) | ||||
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) | |||||
1057 | 1057 | -73.9594406225891 | 40.7918533707789 | 33D-AM-1017-02 | 33D | AM | 10172018 | 2 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9594406225891 40.7918533707789) | ||||
1486 | 1486 | -73.9545807749923 | 40.790050753764895 | 33I-PM-1006-02 | 33I | PM | 10062018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9545807749923 40.7900507537649) | |||||
1833 | 1833 | -73.962516494651 | 40.788476898990204 | 28D-PM-1019-02 | 28D | PM | 10192018 | 2 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.962516494651 40.7884768989902) | |||||
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) | ||||
2284 | 2284 | -73.9730181306326 | 40.779460132242704 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9730181306326 40.7794601322427) | ||||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.97559232564292 40.7672967972471) | ||||
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) | ||||
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) | ||||
1892 | 1892 | -73.9745908987975 | 40.7655191512308 | 1G-AM-1006-03 | 01G | AM | 10062018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | POINT (-73.9745908987975 40.7655191512308) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
2322 | 2322 | -73.97236778547979 | 40.766731541087104 | 3H-AM-1008-04 | 03H | AM | 10082018 | 4 | Adult | Black | Black+ | Above Ground | 50 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9723677854798 40.7667315410871) | |||||
2329 | 2329 | -73.9717515173863 | 40.7747999274418 | 11D-PM-1006-04 | 11D | PM | 10062018 | 4 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9717515173863 40.7747999274418) | |||||
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) | ||||
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) | |||||
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) | ||||
2817 | 2817 | -73.9596445861554 | 40.79719486790071 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9596445861554 40.7971948679007) | |||||
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) | ||||
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) | |||||
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) | |||||
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) | ||||
691 | 691 | -73.96959649834541 | 40.7802302192799 | 18C-PM-1018-08 | 18C | PM | 10182018 | 8 | Juvenile | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9695964983454 40.7802302192799) | |||||
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) | |||||
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) | |||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9704575848926 40.7693499326095) | ||||
1232 | 1232 | -73.9589254878322 | 40.7914467650712 | 33E-PM-1012-09 | 33E | PM | 10122018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9589254878322 40.7914467650712) | |||||
227 | 227 | -73.95981553009129 | 40.7905887826983 | 32E-AM-1007-10 | 32E | AM | 10072018 | 10 | Adult | Black | Black+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9598155300913 40.7905887826983) | |||||
181 | 181 | -73.9708775864433 | 40.772473633538 | 10F-PM-1019-12 | 10F | PM | 10192018 | 12 | Adult | Black | White | Black+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9708775864433 40.772473633538) | ||||
1149 | 1149 | -73.960237785199 | 40.7907831607574 | 32E-PM-1017-16 | 32E | PM | 10172018 | 16 | Adult | Black | Black+ | Ground Plane | FALSE | rocky outcrop | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.960237785199 40.7907831607574) |
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 );