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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1123 | 1123 | -73.9670858934045 | 40.7753505024976 | 14H-PM-1012-02 | 14H | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670858934045 40.7753505024976) | ||||
1284 | 1284 | -73.95708916967759 | 40.793544880224104 | 36E-PM-1012-01 | 36E | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9570891696776 40.7935448802241) | ||||
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) | ||||
1317 | 1317 | -73.9680522379372 | 40.772389813511 | 11I-PM-1012-06 | 11I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9680522379372 40.772389813511) | |||||
1447 | 1447 | -73.9601968065017 | 40.7935831836482 | 34C-PM-1012-03 | 34C | PM | 10122018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9601968065017 40.79358318364821) | ||||
1456 | 1456 | -73.97142424264959 | 40.774453579812295 | 11E-PM-1012-05 | 11E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | foraging (foraged,ran to tree root,munched) | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9714242426496 40.7744535798123) | |||
1462 | 1462 | -73.9584064203778 | 40.7912272455454 | 33F-PM-1012-04 | 33F | PM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9584064203778 40.7912272455454) | ||||
1487 | 1487 | -73.96539465596099 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | burying the food on ground | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | |||
1565 | 1565 | -73.9803895322385 | 40.7680730789944 | 1B-AM-1012-13 | 01B | AM | 10122018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9803895322385 40.7680730789944) | ||||
1568 | 1568 | -73.96810798698209 | 40.772349408134495 | 11I-PM-1012-05 | 11I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9681079869821 40.7723494081345) | |||||
1579 | 1579 | -73.97683095561271 | 40.7717803706095 | 6B-AM-1012-01 | 06B | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Started in field, crossed busy street, ran up tree | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97683095561271 40.7717803706095) | |||
1690 | 1690 | -73.96052295327 | 40.7934359372871 | 34C-PM-1012-04 | 34C | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96052295327 40.7934359372871) | |||||
1706 | 1706 | -73.965215665278 | 40.7761309082202 | 15I-PM-1012-02 | 15I | PM | 10122018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.965215665278 40.7761309082202) | |||||
1716 | 1716 | -73.97974252624591 | 40.76791202463521 | 1B-AM-1012-02 | 01B | AM | 10122018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9797425262459 40.7679120246352) | ||||
1772 | 1772 | -73.9690540696008 | 40.7766014124609 | 14F-PM-1012-08 | 14F | PM | 10122018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690540696008 40.7766014124609) | ||||
1781 | 1781 | -73.96005650463 | 40.793404850298295 | 34C-PM-1012-02 | 34C | PM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.96005650463 40.7934048502983) | ||||
1795 | 1795 | -73.968004352343 | 40.7726669278308 | 11I-PM-1012-01 | 11I | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | look at humans determining | POINT (-73.968004352343 40.7726669278308) | ||||
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) | |||
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) | ||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9647318357023 40.7760936175332) | |||||
1991 | 1991 | -73.965059909327 | 40.776213188679705 | 15I-PM-1012-06 | 15I | PM | 10122018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.965059909327 40.7762131886797) | |||||
2147 | 2147 | -73.9651217998407 | 40.7761115392738 | 15I-PM-1012-01 | 15I | PM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9651217998407 40.7761115392738) | ||||
2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9538938706987 40.7981150065974) | ||||
2176 | 2176 | -73.9583201789615 | 40.7913938722521 | 33F-PM-1012-05 | 33F | PM | 10122018 | 5 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | POINT (-73.95832017896151 40.7913938722521) | ||||
2627 | 2627 | -73.97663480786329 | 40.7717715634438 | 7C-AM-1012-01 | 07C | AM | 10122018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around grass | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9766348078633 40.7717715634438) | |||
2673 | 2673 | -73.9768867959365 | 40.7734803954589 | 8B-PM-1012-01 | 08B | PM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9768867959365 40.7734803954589) | ||||
2691 | 2691 | -73.9564599077179 | 40.7965185098695 | 39D-PM-1012-01 | 39D | PM | 10122018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9564599077179 40.7965185098695) | ||||
2808 | 2808 | -73.9765027953575 | 40.7717327360835 | 7C-AM-1012-02 | 07C | AM | 10122018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | hopping around | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765027953575 40.7717327360835) | |||
2818 | 2818 | -73.9681664642028 | 40.77246696819579 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | ||||
2900 | 2900 | -73.9631005470369 | 40.788549405719294 | 28D-AM-1012-01 | 28D | AM | 10122018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9631005470369 40.7885494057193) | ||||
2903 | 2903 | -73.9670432105975 | 40.7753462013506 | 14H-PM-1012-03 | 14H | PM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9670432105975 40.7753462013506) |
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 );