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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25 | 25 | -73.96711306801141 | 40.7784859700171 | 17F-AM-1007-07 | 17F | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Above Ground | 24 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9671130680114 40.7784859700171) | ||||
38 | 38 | -73.9742073452913 | 40.7757957380463 | 12B-AM-1007-01 | 12B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9742073452913 40.7757957380463) | ||||
94 | 94 | -73.9641971813967 | 40.781353795943495 | 21G-PM-1007-01 | 21G | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9641971813967 40.7813537959435) | ||||
159 | 159 | -73.9638270331336 | 40.7810450065235 | 21G-PM-1007-02 | 21G | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9638270331336 40.7810450065235) | |||||
192 | 192 | -73.9651654887991 | 40.7777806006951 | 17H-PM-1007-02 | 17H | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9651654887991 40.7777806006951) | |||||
234 | 234 | -73.9741401377844 | 40.7758134257881 | 12B-AM-1007-02 | 12B | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9741401377844 40.7758134257881) | ||||
373 | 373 | -73.96721272832829 | 40.7810666805133 | 20D-AM-1007-01 | 20D | AM | 10072018 | 1 | Adult | Gray | Gray+ | too far to note 30' | Ground Plane | FALSE | 1 | 0 | 1 | 1 | 0 | a lot of activity | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9672127283283 40.7810666805133) | |||
427 | 427 | -73.9589367709165 | 40.78964653034829 | 31F-PM-1007-04 | 31F | PM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9589367709165 40.7896465303483) | |||||
566 | 566 | -73.9708364583591 | 40.772369158743295 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9708364583591 40.7723691587433) | |||||
727 | 727 | -73.9634563222926 | 40.780992836417 | 21G-PM-1007-04 | 21G | PM | 10072018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9634563222926 40.780992836417) | |||||
928 | 928 | -73.96704295859901 | 40.778437071937105 | 17F-AM-1007-05 | 17F | AM | 10072018 | 5 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.967042958599 40.7784370719371) | ||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9647891228606 40.789853066039) | |||||
1126 | 1126 | -73.97001860010491 | 40.7826052184658 | 20B-AM-1007-03 | 20B | AM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9700186001049 40.7826052184658) | |||||
1421 | 1421 | -73.9595022290348 | 40.7831151330074 | 25I-PM-1007-02 | 25I | PM | 10072018 | 2 | Adult | Gray | White | Gray+White | white belly | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | POINT (-73.9595022290348 40.783115133007406) | |||
1616 | 1616 | -73.9642666013207 | 40.7810384867375 | 21G-PM-1007-03 | 21G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.96426660132072 40.7810384867375) | ||||
1660 | 1660 | -73.98004994980342 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9800499498034 40.770218109957305) | |||
1808 | 1808 | -73.9698870647042 | 40.7826510985538 | 20B-AM-1007-02 | 20B | AM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | POINT (-73.9698870647042 40.7826510985538) | ||||
1910 | 1910 | -73.9699876501742 | 40.774248267675794 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9699876501742 40.77424826767581) | ||||
1944 | 1944 | -73.97432920664129 | 40.7756090404121 | 11B-AM-1007-05 | 11B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | POINT (-73.9743292066413 40.7756090404121) | |||||
2026 | 2026 | -73.9622752768962 | 40.7814921913101 | 22H-PM-1007-02 | 22H | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | low branch | 0 | 0 | 0 | 0 | 0 | watching me scratching | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9622752768962 40.7814921913101) | ||
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) | ||||
2217 | 2217 | -73.9652746477521 | 40.7809326848536 | 20F-PM-1007-07 | 20F | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | watching | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.96527464775211 40.7809326848536) | ||
2440 | 2440 | -73.96738035086291 | 40.778524502550795 | 17F-AM-1007-01 | 17F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9673803508629 40.7785245025508) | |||||
2463 | 2463 | -73.9653343572865 | 40.77752869246171 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9653343572865 40.7775286924617) | ||||
2469 | 2469 | -73.9600963639087 | 40.7934962325313 | 34C-AM-1007-01 | 34C | AM | 10072018 | 1 | Adult | Black | Black+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | dog | POINT (-73.9600963639087 40.7934962325313) | ||||
2634 | 2634 | -73.96956851864891 | 40.7788293026327 | 16D-AM-1007-04 | 16D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9695685186489 40.7788293026327) | |||||
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) | |||||
78 | 78 | -73.964474836001 | 40.7883840104749 | 28C-PM-1006-01 | 28C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 0 | gathering acorns | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | gnd to tree | POINT (-73.964474836001 40.7883840104749) | ||
90 | 90 | -73.97871808707359 | 40.7715877863274 | 5A-AM-1006-05 | 05A | AM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near 65th St arch | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9787180870736 40.7715877863274) | |||
133 | 133 | -73.9664711607022 | 40.787896428768 | 26A-PM-1006-06 | 26A | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Tree 90th left 90th & 89 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | studying us looking for food | POINT (-73.9664711607022 40.787896428768) | ||
335 | 335 | -73.97823514358521 | 40.7715896672335 | 6A-AM-1006-03 | 06A | AM | 10062018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | POINT (-73.9782351435852 40.7715896672335) | |||
379 | 379 | -73.9606817053484 | 40.7917320450401 | 32D-PM-1006-07 | 32D | PM | 10062018 | 7 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9606817053484 40.7917320450401) | ||||
569 | 569 | -73.9709040623777 | 40.7701163892686 | 7H-PM-1006-03 | 07H | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | tree | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9709040623777 40.7701163892686) | ||||
652 | 652 | -73.95700561239529 | 40.787875606758206 | 30I-PM-1006-02 | 30I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9570056123953 40.7878756067582) | |||||
658 | 658 | -73.9704575848926 | 40.7693499326095 | 7H-PM-1006-09 | 07H | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | by tree | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9704575848926 40.7693499326095) | ||||
663 | 663 | -73.9766440589836 | 40.7682390282581 | 3E-AM-1006-02 | 03E | AM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9766440589836 40.7682390282581) | |||||
730 | 730 | -73.9607280801601 | 40.7901506706248 | 31D-PM-1006-01 | 31D | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9607280801601 40.7901506706248) | |||||
1019 | 1019 | -73.97042696309641 | 40.7722964640257 | 10G-AM-1006-09 | 10G | AM | 10062018 | 9 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704269630964 40.7722964640257) | ||||
1048 | 1048 | -73.9782120139407 | 40.7717154468791 | 6A-AM-1006-05 | 06A | AM | 10062018 | 5 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 4 | tree | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | curious | POINT (-73.9782120139407 40.7717154468791) | ||
1201 | 1201 | -73.97828135384209 | 40.7715730368712 | 6A-AM-1006-02 | 06A | AM | 10062018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | tree | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | POINT (-73.9782813538421 40.7715730368712) | |||
1230 | 1230 | -73.9790822606486 | 40.7714466633386 | 5A-AM-1006-03 | 05A | AM | 10062018 | 3 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 8 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9790822606486 40.7714466633386) | |||||
1523 | 1523 | -73.9673103881521 | 40.78742674096179 | 26A-PM-1006-01 | 26A | PM | 10062018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9673103881521 40.7874267409618) | ||||
1529 | 1529 | -73.9692401421068 | 40.7707128895661 | 8I-AM-1006-04 | 08I | AM | 10062018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9692401421068 40.7707128895661) | ||||
1815 | 1815 | -73.96032682553171 | 40.7900154505092 | 31E-PM-1006-06 | 31E | PM | 10062018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603268255317 40.7900154505092) | ||||
1995 | 1995 | -73.9603366992925 | 40.7899612889539 | 31E-PM-1006-05 | 31E | PM | 10062018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9603366992925 40.789961288953904) | ||||
2044 | 2044 | -73.97715523261991 | 40.7706917595308 | 5C-AM-1006-01 | 05C | AM | 10062018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | POINT (-73.9771552326199 40.7706917595308) | ||||
2142 | 2142 | -73.95985354257058 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | 0 | 1 | 0 | 0 | 0 | hanging on fence | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9598535425706 40.7915589343685) | ||||
2363 | 2363 | -73.9690638424196 | 40.7713869295685 | 9H-AM-1006-06 | 09H | AM | 10062018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9690638424196 40.7713869295685) | ||||
2397 | 2397 | -73.9704592500888 | 40.772962887933005 | 10G-AM-1006-03 | 10G | AM | 10062018 | 3 | Juvenile | Gray | White | Gray+White | tuft on butt | Above Ground | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | POINT (-73.9704592500888 40.772962887933) | |||
2425 | 2425 | -73.9791141532217 | 40.7714888835416 | 5A-AM-1006-04 | 05A | AM | 10062018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9791141532217 40.77148888354161) | ||||
2433 | 2433 | -73.9706949930717 | 40.772362045852 | 10G-AM-1006-08 | 10G | AM | 10062018 | 8 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | POINT (-73.9706949930717 40.772362045852) | ||||
2521 | 2521 | -73.976869549792 | 40.770698245472296 | 5C-AM-1006-04 | 05C | AM | 10062018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 12 | thin branch of tree | 0 | 0 | 0 | 0 | 0 | relaxing | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.976869549792 40.7706982454723) | ||
2547 | 2547 | -73.9743393747021 | 40.767634679832504 | 3F-AM-1006-12 | 03F | AM | 10062018 | 12 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | POINT (-73.9743393747021 40.7676346798325) | ||||
2583 | 2583 | -73.97696931406509 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | 1 | 0 | 1 | 1 | 1 | digging (?) | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | |
2928 | 2928 | -73.9767953468937 | 40.7676376977667 | 3E-AM-1006-03 | 03E | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | 0 | 0 | 0 | 0 | 1 | checkin' his stashes | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | POINT (-73.9767953468937 40.7676376977667) |
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 );