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, Running, Chasing, Climbing, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
360 | 360 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 40 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9672054610151 40.7876519923501) | |||||
381 | 381 | -73.959709414696 | 40.7919745085986 | 33D-PM-1006-03 | 33D | PM | 10062018 | 3 | Black | Black+ | Above Ground | 15 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | ran up tree | POINT (-73.959709414696 40.7919745085986) | |||||
670 | 670 | -73.9602398690946 | 40.7910157676119 | 32D-PM-1006-04 | 32D | PM | 10062018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602398690946 40.7910157676119) | ||||
728 | 728 | -73.96029131055779 | 40.7910635810038 | 32D-PM-1006-03 | 32D | PM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 40 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9602913105578 40.7910635810038) | ||||
1820 | 1820 | -73.9546337446865 | 40.7898772579576 | 33I-PM-1006-08 | 33I | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9546337446865 40.7898772579576) | |||||
2396 | 2396 | -73.9704339422613 | 40.77401495296439 | 11F-PM-1006-03 | 11F | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9704339422613 40.7740149529644) | |||||
2559 | 2559 | -73.95723834787741 | 40.787685738072206 | 30H-PM-1006-01 | 30H | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9572383478774 40.7876857380722) | ||||
2803 | 2803 | -73.9576652087316 | 40.787545797780105 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9576652087316 40.7875457977801) | |||||
2839 | 2839 | -73.9672252136807 | 40.787650474321204 | 26A-PM-1006-04 | 26A | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 40 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9672252136807 40.7876504743212) | |||||
15 | 15 | -73.9674285955293 | 40.7829723919744 | 21C-PM-1006-01 | 21C | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9674285955293 40.7829723919744) | |||||
298 | 298 | -73.957342596188 | 40.7944359654227 | 37E-PM-1006-09 | 37E | PM | 10062018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | moseying | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.957342596188 40.7944359654227) | |||
314 | 314 | -73.960601067176 | 40.7917243850136 | 32D-PM-1006-09 | 32D | PM | 10062018 | 9 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.960601067176 40.7917243850136) | ||||
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) | |||||
550 | 550 | -73.9714465493257 | 40.7772135587308 | 14C-PM-1006-02 | 14C | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9714465493257 40.7772135587308) | |||||
697 | 697 | -73.97046560040201 | 40.770112577324795 | 7H-PM-1006-05 | 07H | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ran across path to eat behind fence, next to the fence. | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.970465600402 40.7701125773248) | |||
837 | 837 | -73.9557172336815 | 40.79211256577221 | 35G-PM-1006-01 | 35G | PM | 10062018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9557172336815 40.7921125657722) | ||||
1106 | 1106 | -73.97029709193171 | 40.7696883113413 | 7H-PM-1006-08 | 07H | PM | 10062018 | 8 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | in grass | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9702970919317 40.7696883113413) | |||
1303 | 1303 | -73.9603302382958 | 40.7910100435196 | 32D-PM-1006-01 | 32D | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9603302382958 40.7910100435196) | ||||
1345 | 1345 | -73.95813265542058 | 40.7918074743129 | 34E-PM-1006-02 | 34E | PM | 10062018 | 2 | Juvenile | Black | Gray, White | Black+Gray, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9581326554206 40.7918074743129) | ||||
1519 | 1519 | -73.97173027730099 | 40.7748805439381 | 11D-PM-1006-05 | 11D | PM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.971730277301 40.7748805439381) | ||||
1586 | 1586 | -73.9714150090362 | 40.7774976423922 | 14C-PM-1006-03 | 14C | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9714150090362 40.7774976423922) | ||||
1703 | 1703 | -73.956998502609 | 40.7948117428147 | 37E-PM-1006-01 | 37E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.956998502609 40.7948117428147) | ||||
1973 | 1973 | -73.957138759793 | 40.795592603505504 | 38D-PM-1006-02 | 38D | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.957138759793 40.7955926035055) | ||||
2454 | 2454 | -73.9565151662506 | 40.794664798744705 | 37E-PM-1006-07 | 37E | PM | 10062018 | 7 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | me | POINT (-73.9565151662506 40.7946647987447) | |||
2604 | 2604 | -73.9605163698302 | 40.7914179994956 | 32D-PM-1006-05 | 32D | PM | 10062018 | 5 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9605163698302 40.7914179994956) | ||||
2610 | 2610 | -73.9713379914423 | 40.7696367609606 | 7H-PM-1006-01 | 07H | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | middle of grass | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | POINT (-73.9713379914423 40.7696367609606) | |||
2723 | 2723 | -73.96064260275601 | 40.791726541984204 | 32D-PM-1006-08 | 32D | PM | 10062018 | 8 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | stand on two feet and watching me | POINT (-73.960642602756 40.7917265419842) | |||
2766 | 2766 | -73.95516398474659 | 40.790858199891 | 34H-PM-1006-03 | 34H | PM | 10062018 | 3 | Gray | White | Gray+White | white belly | Ground Plane | FALSE | Under Tupelo Tree | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9551639847466 40.790858199891) | |||
2782 | 2782 | -73.9563473341712 | 40.7893712398425 | 32H-PM-1006-03 | 32H | PM | 10062018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | POINT (-73.9563473341712 40.78937123984251) | ||||
2935 | 2935 | -73.96045994773449 | 40.7915035010169 | 32D-PM-1006-06 | 32D | PM | 10062018 | 6 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9604599477345 40.7915035010169) | ||||
2947 | 2947 | -73.96012151981141 | 40.7909769801241 | 32D-PM-1006-02 | 32D | PM | 10062018 | 2 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9601215198114 40.7909769801241) |
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 );