This data as json, CSV (advanced)
Suggested facets: Hectare, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Specific Location, Running, Climbing, Eating, Foraging, Kuks, Tail flags, Tail twitches, Approaches
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
495 | 495 | -73.9801007327506 | 40.7677455633932 | 1B-PM-1019-06 | 01B | PM | 10192018 | 6 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9801007327506 40.7677455633932) | ||||
286 | 286 | -73.97209073846129 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9720907384613 40.7762987836055) | |||||
343 | 343 | -73.9730224561601 | 40.7796833353894 | 16A-PM-1019-04 | 16A | PM | 10192018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9730224561601 40.7796833353894) | ||||
638 | 638 | -73.9562765288004 | 40.78806179638679 | 31I-PM-1019-02 | 31I | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9562765288004 40.7880617963868) | |||||
644 | 644 | -73.97221256300399 | 40.776131146585705 | 13C-PM-1019-05 | 13C | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | POINT (-73.972212563004 40.7761311465857) | ||||
737 | 737 | -73.97111769994709 | 40.7724278547281 | 10F-PM-1019-06 | 10F | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | Different tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9711176999471 40.7724278547281) | |||
922 | 922 | -73.9708002461415 | 40.7726685284831 | 10F-PM-1019-10 | 10F | PM | 10192018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Arbor path & hill w/ bushes | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9708002461415 40.7726685284831) | |||
999 | 999 | -73.980948293606 | 40.76856888506279 | 2A-PM-1019-04 | 02A | PM | 10192018 | 4 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.980948293606 40.7685688850628) | |||
1175 | 1175 | -73.9803282698463 | 40.7680809889384 | 1B-PM-1019-09 | 01B | PM | 10192018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | Tree to ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9803282698463 40.7680809889384) | |||
1184 | 1184 | -73.9807982742225 | 40.7678795985389 | 1B-PM-1019-01 | 01B | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9807982742225 40.7678795985389) | ||||
1269 | 1269 | -73.9652921233647 | 40.790440565854 | 29A-PM-1019-01 | 29A | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9652921233647 40.790440565854) | ||||
1316 | 1316 | -73.9674724790652 | 40.7768771349868 | 15G-PM-1019-01 | 15G | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9674724790652 40.7768771349868) | ||||
1582 | 1582 | -73.9804065254162 | 40.7681481183296 | 1B-PM-1019-08 | 01B | PM | 10192018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9804065254162 40.7681481183296) | ||||
1897 | 1897 | -73.97107389601 | 40.7723265810536 | 10F-PM-1019-07 | 10F | PM | 10192018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | Same tree (as #6) | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.97107389601 40.7723265810536) | |||
2203 | 2203 | -73.97105314852979 | 40.7773757069445 | 14D-PM-1019-06 | 14D | PM | 10192018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.97105314852982 40.777375706944504) | |||||
2283 | 2283 | -73.9628982772673 | 40.788430480338604 | 28D-PM-1019-01 | 28D | PM | 10192018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9628982772673 40.7884304803386) | ||||
2375 | 2375 | -73.9563720614251 | 40.7879453306251 | 31I-PM-1019-01 | 31I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9563720614251 40.7879453306251) | |||||
2412 | 2412 | -73.98094464895641 | 40.768503216587895 | 2A-PM-1019-03 | 02A | PM | 10192018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 15 | in tree! | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809446489564 40.7685032165879) | |||
2482 | 2482 | -73.9805927710872 | 40.76799891166421 | 1B-PM-1019-07 | 01B | PM | 10192018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9805927710872 40.7679989116642) | ||||
2517 | 2517 | -73.9710221361528 | 40.7724939691584 | 10F-PM-1019-01 | 10F | PM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Above Ground | 2 | Behind fence, tree trunk | 0 | 0 | 1 | 0 | 0 | sitting | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9710221361528 40.7724939691584) | |
2684 | 2684 | -73.9809688694074 | 40.7688535974878 | 2A-PM-1019-06 | 02A | PM | 10192018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9809688694074 40.7688535974878) | ||||
2688 | 2688 | -73.9799302952205 | 40.767720720979796 | 1B-PM-1019-02 | 01B | PM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9799302952205 40.7677207209798) | ||||
2800 | 2800 | -73.9802983138318 | 40.7676540772339 | 1B-PM-1019-05 | 01B | PM | 10192018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9802983138318 40.7676540772339) | ||||
2834 | 2834 | -73.9651132904127 | 40.7905384124102 | 29A-PM-1019-02 | 29A | PM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9651132904127 40.7905384124102) | ||||
2904 | 2904 | -73.97203897567171 | 40.7763524091989 | 13C-PM-1019-02 | 13C | PM | 10192018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9720389756717 40.7763524091989) | |||||
2987 | 2987 | -73.9563724838337 | 40.7882504581015 | 31I-PM-1019-04 | 31I | PM | 10192018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.95637248383372 40.7882504581015) |
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 );