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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1531 | 1531 | -73.9630381400083 | 40.7807571827321 | 21H-PM-1018-02 | 21H | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9630381400083 40.7807571827321) | ||||
1625 | 1625 | -73.9736873018042 | 40.76491066771379 | 1I-PM-1012-02 | 01I | PM | 10122018 | 2 | Juvenile | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Gray, Black, & Cinnamon selected as Primary. Gray, Cinnamon, & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | tree | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9736873018042 40.7649106677138) | ||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9746940851342 40.7760966488186) | |||||
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) | |||||
1731 | 1731 | -73.9692846326638 | 40.7841049008492 | 22A-PM-1017-02 | 22A | PM | 10172018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9692846326638 40.7841049008492) | |||||
1732 | 1732 | -73.97671414072741 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | ||||
1782 | 1782 | -73.9549133872427 | 40.7946871036949 | 38F-PM-1013-02 | 38F | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9549133872427 40.7946871036949) | ||||
1904 | 1904 | -73.9684058476942 | 40.7753959833776 | 13G-PM-1008-02 | 13G | PM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 15 | willow oak tree | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9684058476942 40.7753959833776) | ||||
1978 | 1978 | -73.9579689996645 | 40.794933848991704 | 37D-AM-1018-02 | 37D | AM | 10182018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9579689996645 40.7949338489917) | ||||
2029 | 2029 | -73.9687213827744 | 40.7843586374648 | 22B-PM-1014-02 | 22B | PM | 10142018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9687213827744 40.7843586374648) | ||||
2038 | 2038 | -73.98035621370491 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9803562137049 40.7685780990634) | |||||
2368 | 2368 | -73.9731925179247 | 40.7748962746181 | 11D-PM-1006-02 | 11D | PM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9731925179247 40.7748962746181) | ||||
2426 | 2426 | -73.9790203973636 | 40.768883711483205 | 3B-AM-1010-02 | 03B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | together w/ #3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9790203973636 40.7688837114832) | |||
2432 | 2432 | -73.9657203199746 | 40.775173008911 | 14I-PM-1018-02 | 14I | PM | 10182018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | POINT (-73.9657203199746 40.775173008911) | ||||
2783 | 2783 | -73.97917671562679 | 40.7714445258765 | 5A-AM-1006-02 | 05A | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | in tall shrubs near wall next to CPW | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | POINT (-73.9791767156268 40.7714445258765) | |||
2982 | 2982 | -73.9513477815203 | 40.7945259614138 | 39I-PM-1013-02 | 39I | PM | 10132018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | 0 | 1 | 1 | 0 | 0 | playing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | POINT (-73.9513477815203 40.7945259614138) | |||
43 | 43 | -73.9574648097543 | 40.7892508428622 | 31H-PM-1008-02 | 31H | PM | 10082018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9574648097543 40.78925084286221) | ||||
155 | 155 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9522142360388 40.7949598486683) | ||||
172 | 172 | -73.958535640774 | 40.7982737896998 | 40B-AM-1019-02 | 40B | AM | 10192018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.958535640774 40.7982737896998) | ||||
209 | 209 | -73.97107601968679 | 40.7725506006789 | 10F-PM-1019-02 | 10F | PM | 10192018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head & stripe | Ground Plane | FALSE | Behind fence, grass | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9710760196868 40.7725506006789) | ||
419 | 419 | -73.9777328709928 | 40.7669087724668 | 1D-AM-1006-02 | 01D | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | POINT (-73.9777328709928 40.7669087724668) | ||||
508 | 508 | -73.97469187620759 | 40.765523188367794 | 1G-AM-1006-02 | 01G | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Above Ground | 30 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9746918762076 40.7655231883678) | ||||
655 | 655 | -73.9728783802067 | 40.7731671049246 | 9E-PM-1014-02 | 09E | PM | 10142018 | 2 | Juvenile | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9728783802067 40.7731671049246) | ||||
756 | 756 | -73.9773079154219 | 40.7696506688861 | 4C-AM-1006-02 | 04C | AM | 10062018 | 2 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9773079154219 40.7696506688861) | ||||
1714 | 1714 | -73.9763542780331 | 40.773653130362206 | 9B-AM-1010-02 | 09B | AM | 10102018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | in bush | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | froze | POINT (-73.9763542780331 40.773653130362206) | ||
1885 | 1885 | -73.9594174605642 | 40.7973128653773 | 38B-AM-1019-02 | 38B | AM | 10192018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | POINT (-73.9594174605642 40.7973128653773) | ||||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | POINT (-73.9756457597888 40.7703559775625) |
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 );