This data as json, CSV (advanced)
Suggested facets: Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28 | 28 | -73.958736593111 | 40.790852437062604 | 32F-PM-1008-07 | 32F | PM | 10082018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.958736593111 40.7908524370626) | |||||
76 | 76 | -73.9530035564643 | 40.792182245761296 | 36I-PM-1007-07 | 36I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9530035564643 40.7921822457613) | |||||
134 | 134 | -73.9575943815564 | 40.7933755266787 | 35E-PM-1006-07 | 35E | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | POINT (-73.9575943815564 40.7933755266787) | |||||
238 | 238 | -73.9760942252437 | 40.7742035674209 | 9B-PM-1013-07 | 09B | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.97609422524371 40.7742035674209) | ||||
301 | 301 | -73.9717425494287 | 40.7664227676653 | 3I-PM-1013-07 | 03I | PM | 10132018 | 7 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9717425494287 40.7664227676653) | ||||
327 | 327 | -73.95343062916791 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9534306291679 40.7959052073753) | ||||
640 | 640 | -73.97855365291359 | 40.7716184505002 | 6A-PM-1012-07 | 06A | PM | 10122018 | 7 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | elevated ground | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9785536529136 40.771618450500206) | |||
664 | 664 | -73.9725174868556 | 40.7664248283566 | 3H-PM-1014-07 | 03H | PM | 10142018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9725174868556 40.7664248283566) | ||||
856 | 856 | -73.9591667162801 | 40.7937602121568 | 35D-PM-1013-07 | 35D | PM | 10132018 | 7 | Juvenile | Gray | White | Gray+White | Above Ground | 12 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.95916671628011 40.7937602121568) | |||
985 | 985 | -73.9681722244801 | 40.783559826281 | 22B-PM-1014-07 | 22B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9681722244801 40.783559826281) | ||||
1039 | 1039 | -73.9584646000078 | 40.7983984665955 | 40B-PM-1014-07 | 40B | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9584646000078 40.7983984665955) | ||||
1105 | 1105 | -73.9811218801005 | 40.7684406206185 | 1A-PM-1014-07 | 01A | PM | 10142018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9811218801005 40.7684406206185) | ||||
1142 | 1142 | -73.9765805609072 | 40.7692807820935 | 4D-PM-1008-07 | 04D | PM | 10082018 | 7 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | hopped over fence and chased # 6 around tree & ran it to end of lawn | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9765805609072 40.7692807820935) | |||
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) | |||
1245 | 1245 | -73.9739326393775 | 40.7779105370473 | 14A-PM-1014-07 | 14A | PM | 10142018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9739326393775 40.7779105370473) | ||||
1262 | 1262 | -73.9683345414813 | 40.7779016280345 | 16E-PM-1018-07 | 16E | PM | 10182018 | 7 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9683345414813 40.7779016280345) | ||||
1338 | 1338 | -73.9716624574422 | 40.776203711010105 | 13D-PM-1018-07 | 13D | PM | 10182018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 1 | 0 | 1 | 0 | 0 | scratching | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9716624574422 40.7762037110101) | |||
1438 | 1438 | -73.97168547522399 | 40.7706668465923 | 7G-PM-1018-07 | 07G | PM | 10182018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.971685475224 40.7706668465923) | |||||
1544 | 1544 | -73.9642111283068 | 40.77777139853271 | 18I-PM-1007-07 | 18I | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9642111283068 40.7777713985327) | ||||
1580 | 1580 | -73.9775079672882 | 40.7691500357424 | 4C-PM-1010-07 | 04C | PM | 10102018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9775079672882 40.7691500357424) | ||||
1666 | 1666 | -73.96494654768709 | 40.7822708362663 | 22F-PM-1014-07 | 22F | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9649465476871 40.7822708362663) | |||||
1817 | 1817 | -73.9703076450783 | 40.770158422628995 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | 0 | 1 | 0 | 0 | 0 | chasing (#8),playing? | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9703076450783 40.770158422629) | ||||
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) | |||
2013 | 2013 | -73.96953483858279 | 40.7703657361802 | 8I-PM-1013-07 | 08I | PM | 10132018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9695348385828 40.7703657361802) | ||||
2085 | 2085 | -73.9690551477139 | 40.782368566319604 | 20B-PM-1013-07 | 20B | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9690551477139 40.7823685663196) | ||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9699124811406 40.7743016981538) | ||||
2362 | 2362 | -73.9700263936574 | 40.769933509858106 | 7H-PM-1006-07 | 07H | PM | 10062018 | 7 | Adult | Gray | Gray+ | Above Ground | 15 | 0 | 1 | 1 | 0 | 0 | playing w/ #6 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700263936574 40.7699335098581) | ||||
2402 | 2402 | -73.9777206733344 | 40.7668595585487 | 1D-PM-1007-07 | 01D | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | lying down | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9777206733344 40.7668595585487) | ||||
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) | ||||
2623 | 2623 | -73.9604482901468 | 40.7898646293603 | 31E-PM-1006-07 | 31E | PM | 10062018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9604482901468 40.7898646293603) | ||||
2759 | 2759 | -73.9543373703455 | 40.7943889087123 | 38G-PM-1020-07 | 38G | PM | 10202018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9543373703455 40.7943889087123) | ||||
2780 | 2780 | -73.9700634278 | 40.778422372245295 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9700634278 40.7784223722453) | |||||
2812 | 2812 | -73.963209639301 | 40.7926138443715 | 32A-PM-1013-07 | 32A | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.963209639301 40.7926138443715) |
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 );