This data as json, CSV (advanced)
Suggested facets: Shift, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Other Interactions
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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3012 | 3012 | -73.9613701960898 | 40.7943363227822 | 35B-PM-1013-04 | 35B | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | got threatened by dog (same dog,dog #1) | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9613701960898 40.7943363227822) | 19 | 4 | 19 | 13 | ||||
2997 | 2997 | -73.9619735385483 | 40.7944667974974 | 35A-PM-1013-01 | 35A | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9619735385483 40.7944667974974) | 19 | 4 | 19 | 13 | |||||
2992 | 2992 | -73.9746063250438 | 40.7687654196811 | 4F-PM-1013-03 | 04F | PM | 10132018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | false | true | POINT (-73.9746063250438 40.7687654196811) | 19 | 4 | 19 | 13 | |||||
2985 | 2985 | -73.9721159387757 | 40.7660503188637 | 3I-PM-1013-03 | 03I | PM | 10132018 | 3 | Adult | Black | Cinnamon | Black+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9721159387757 40.7660503188637) | 19 | 4 | 19 | 13 | |||||
2982 | 2982 | -73.9513477815203 | 40.7945259614138 | 39I-PM-1013-02 | 39I | PM | 10132018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | along the road | false | true | true | false | false | playing | false | false | false | false | false | false | false | false | POINT (-73.9513477815203 40.7945259614138) | 19 | 4 | 19 | 13 | ||||
2969 | 2969 | -73.9654409838612 | 40.7901338748522 | 29A-AM-1013-01 | 29A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | climbed tree (oak) | false | false | false | false | true | false | false | true | POINT (-73.9654409838612 40.7901338748522) | 19 | 4 | 19 | 13 | ||||
2950 | 2950 | -73.9790980124501 | 40.7685934093915 | 2B-PM-1013-08 | 02B | PM | 10132018 | 8 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9790980124501 40.7685934093915) | 19 | 4 | 19 | 13 | |||||
2934 | 2934 | -73.9561669236168 | 40.7994737431277 | 42C-PM-1013-04 | 42C | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9561669236168 40.7994737431277) | 19 | 4 | 19 | 13 | ||||||
2926 | 2926 | -73.9714653576023 | 40.7717400139502 | 9F-AM-1013-03 | 09F | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9714653576023 40.7717400139502) | 19 | 4 | 19 | 13 | |||||
2913 | 2913 | -73.9621297946132 | 40.7944058222814 | 34A-PM-1013-05 | 34A | PM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9621297946132 40.7944058222814) | 19 | 4 | 19 | 13 | |||||
2835 | 2835 | -73.9531953594918 | 40.7960413520131 | 40G-PM-1013-01 | 40G | PM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9531953594918 40.7960413520131) | 19 | 4 | 19 | 13 | ||||||
2827 | 2827 | -73.9778578822323 | 40.7705432705286 | 5B-PM-1013-03 | 05B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | grooming | false | false | false | false | false | false | false | false | POINT (-73.9778578822323 40.7705432705286) | 19 | 4 | 19 | 13 | |||||
2820 | 2820 | -73.9615926031253 | 40.7944223235385 | 35B-PM-1013-05 | 35B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | false | chased by dog #2 | true | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.96159260312531 40.7944223235385) | 19 | 4 | 19 | 13 | ||||
2819 | 2819 | -73.9550350096938 | 40.797694218705 | 41E-PM-1013-02 | 41E | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9550350096938 40.797694218705004) | 19 | 4 | 19 | 13 | |||||
2817 | 2817 | -73.9596445861554 | 40.7971948679007 | 38A-PM-1013-05 | 38A | PM | 10132018 | 5 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9596445861554 40.7971948679007) | 19 | 4 | 19 | 13 | ||||||
2815 | 2815 | -73.9747311312394 | 40.7677319725044 | 3F-PM-1013-06 | 03F | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 19 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97473113123941 40.7677319725044) | 19 | 4 | 19 | 13 | |||||
2810 | 2810 | -73.9614659899028 | 40.7945562907624 | 35A-PM-1013-10 | 35A | PM | 10132018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9614659899028 40.7945562907624) | 19 | 4 | 19 | 13 | |||||
2784 | 2784 | -73.9763722433833 | 40.7744121430891 | 9A-AM-1013-07 | 09A | AM | 10132018 | 7 | Adult | + | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763722433833 40.7744121430891) | 19 | 4 | 19 | 13 | |||||||||
2767 | 2767 | -73.9751806727197 | 40.7671940332258 | 3F-PM-1013-05 | 03F | PM | 10132018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 13 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.97518067271972 40.7671940332258) | 19 | 4 | 19 | 13 | |||||
2727 | 2727 | -73.974596903918 | 40.7765498215674 | 12A-PM-1013-02 | 12A | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.974596903918 40.7765498215674) | 19 | 4 | 19 | 13 | |||||
2716 | 2716 | -73.9618094076328 | 40.7944097368153 | 35A-PM-1013-03 | 35A | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9618094076328 40.7944097368153) | 19 | 4 | 19 | 13 | |||||
2714 | 2714 | -73.9600738985438 | 40.7938328798752 | 35C-PM-1013-08 | 35C | PM | 10132018 | 8 | + | false | false | false | false | false | true | false | false | false | false | false | false | false | did not *see* | POINT (-73.9600738985438 40.7938328798752) | 19 | 4 | 19 | 13 | |||||||||
2711 | 2711 | -73.9628842960118 | 40.7938048572403 | 34A-PM-1013-01 | 34A | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | took a chestnut | false | false | false | false | false | false | false | false | POINT (-73.9628842960118 40.7938048572403) | 19 | 4 | 19 | 13 | ||||
2693 | 2693 | -73.9561498646036 | 40.7949288561893 | 37E-AM-1013-05 | 37E | AM | 10132018 | 5 | ? | + | Above Ground | 10 | unsure, just heard kuks | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9561498646036 40.79492885618931) | 19 | 4 | 19 | 13 | ||||||
2672 | 2672 | -73.9614599022015 | 40.7945181285991 | 35A-PM-1013-11 | 35A | PM | 10132018 | 11 | Juvenile | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9614599022015 40.7945181285991) | 19 | 4 | 19 | 13 | ||||||
2669 | 2669 | -73.9615900833886 | 40.7945431292846 | 35A-PM-1013-07 | 35A | PM | 10132018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9615900833886 40.7945431292846) | 19 | 4 | 19 | 13 | |||||
2668 | 2668 | -73.9548648518558 | 40.7946730924872 | 38F-PM-1013-03 | 38F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548648518558 40.7946730924872) | 19 | 4 | 19 | 13 | |||||
2646 | 2646 | -73.9772239251936 | 40.7731716665766 | 8A-AM-1013-05 | 08A | AM | 10132018 | 5 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | true | false | false | false | false | false | false | true | false | false | POINT (-73.9772239251936 40.7731716665766) | 19 | 4 | 19 | 13 | |||||
2636 | 2636 | -73.9700264128414 | 40.7692014637698 | 7I-PM-1013-01 | 07I | PM | 10132018 | 1 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | Bench | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9700264128414 40.7692014637698) | 19 | 4 | 19 | 13 | ||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
2595 | 2595 | -73.9692676659807 | 40.7700678919108 | 8I-PM-1013-08 | 08I | PM | 10132018 | 8 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.96926766598071 40.7700678919108) | 19 | 4 | 19 | 13 | |||||
2585 | 2585 | -73.9771726831497 | 40.7732320781799 | 8A-AM-1013-01 | 08A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | trail | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9771726831497 40.7732320781799) | 19 | 4 | 19 | 13 | ||||
2571 | 2571 | -73.9695468150218 | 40.7821142051746 | 20B-PM-1013-03 | 20B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9695468150218 40.7821142051746) | 19 | 4 | 19 | 13 | |||||
2562 | 2562 | -73.9615643742864 | 40.7944678447843 | 35B-PM-1013-06 | 35B | PM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | chased by dog #2 | true | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9615643742864 40.7944678447843) | 19 | 4 | 19 | 13 | |||
2554 | 2554 | -73.9701505245419 | 40.768998364571 | 6I-PM-1013-07 | 06I | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Above Ground | 11 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9701505245419 40.768998364571004) | 19 | 4 | 19 | 13 | ||||||
2535 | 2535 | -73.9700101107283 | 40.7696729501144 | 7I-PM-1013-08 | 07I | PM | 10132018 | 8 | Adult | Black | Black+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | false | false | POINT (-73.9700101107283 40.7696729501144) | 19 | 4 | 19 | 13 | ||||||
2534 | 2534 | -73.9744368038675 | 40.7674281958115 | 3G-PM-1013-03 | 03G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | runs from (climbed tree to run from) | POINT (-73.97443680386752 40.7674281958115) | 19 | 4 | 19 | 13 | |||||
2532 | 2532 | -73.9695150319891 | 40.782613519363 | 20B-PM-1013-04 | 20B | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | chased a bird carrying massive wad of grass | false | false | false | false | true | false | false | false | POINT (-73.9695150319891 40.782613519363) | 19 | 4 | 19 | 13 | ||||
2520 | 2520 | -73.9548207106339 | 40.7946991812402 | 38F-PM-1013-04 | 38F | PM | 10132018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9548207106339 40.7946991812402) | 19 | 4 | 19 | 13 | |||||
2519 | 2519 | -73.9589475065438 | 40.7934846881536 | 35D-PM-1013-06 | 35D | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9589475065438 40.7934846881536) | 19 | 4 | 19 | 13 | |||||
2496 | 2496 | -73.9696274291417 | 40.7691980808067 | 7I-PM-1013-03 | 07I | PM | 10132018 | 3 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | Trash bins | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9696274291417 40.7691980808067) | 19 | 4 | 19 | 13 | ||||
2484 | 2484 | -73.9619786450142 | 40.7919876274548 | 32C-PM-1013-09 | 32C | PM | 10132018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9619786450142 40.7919876274548) | 19 | 4 | 19 | 13 | ||||||
2479 | 2479 | -73.9657958433575 | 40.7763496875058 | 15H-AM-1013-01 | 15H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9657958433575 40.7763496875058) | 19 | 4 | 19 | 13 | |||||
2467 | 2467 | -73.9755923256429 | 40.7672967972471 | 3F-PM-1013-02 | 03F | PM | 10132018 | 2 | Adult | Black | Gray | Black+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.97559232564292 40.7672967972471) | 19 | 4 | 19 | 13 | |||||
2458 | 2458 | -73.969517504176 | 40.7820741344297 | 20B-PM-1013-02 | 20B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.969517504176 40.7820741344297) | 19 | 4 | 19 | 13 | |||||
2446 | 2446 | -73.9522704511969 | 40.7965668878961 | 41G-AM-1013-01 | 41G | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9522704511969 40.7965668878961) | 19 | 4 | 19 | 13 | |||||
2445 | 2445 | -73.96193040894 | 40.792045169318 | 32C-PM-1013-10 | 32C | PM | 10132018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.96193040894 40.792045169318) | 19 | 4 | 19 | 13 | ||||||
2438 | 2438 | -73.969532160039 | 40.7822616641357 | 20B-PM-1013-01 | 20B | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.969532160039 40.7822616641357) | 19 | 4 | 19 | 13 | |||||
2437 | 2437 | -73.9619856085821 | 40.7919516520091 | 32C-PM-1013-08 | 32C | PM | 10132018 | 8 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9619856085821 40.7919516520091) | 19 | 4 | 19 | 13 | ||||||
2434 | 2434 | -73.9545912098958 | 40.7948301813102 | 38F-PM-1013-06 | 38F | PM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9545912098958 40.7948301813102) | 19 | 4 | 19 | 13 | |||||
2423 | 2423 | -73.973552877209 | 40.7715638228207 | 7E-PM-1013-01 | 07E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Ground & Tree Base | true | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.973552877209 40.7715638228207) | 19 | 4 | 19 | 13 | ||||
2377 | 2377 | -73.9704328573603 | 40.7739347247552 | 11F-AM-1013-03 | 11F | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9704328573603 40.7739347247552) | 19 | 4 | 19 | 13 | ||||||
2373 | 2373 | -73.9613276802049 | 40.7943813964442 | 35B-PM-1013-03 | 35B | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | threatened by approaching dog (dog #1) | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.96132768020492 40.7943813964442) | 19 | 4 | 19 | 13 | ||||
2371 | 2371 | -73.9769520212123 | 40.774006725863 | 9A-AM-1013-01 | 09A | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9769520212123 40.774006725863) | 19 | 4 | 19 | 13 | |||||
2366 | 2366 | -73.9676191846985 | 40.777641740817 | 16F-PM-1013-04 | 16F | PM | 10132018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9676191846985 40.777641740817) | 19 | 4 | 19 | 13 | |||||
2358 | 2358 | -73.9788379085607 | 40.7683896583055 | 2C-PM-1013-06 | 02C | PM | 10132018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | cleaning face & tail | false | false | false | false | true | true | false | false | POINT (-73.9788379085607 40.7683896583055) | 19 | 4 | 19 | 13 | ||||
2357 | 2357 | -73.9632301034883 | 40.7925707244111 | 32A-PM-1013-06 | 32A | PM | 10132018 | 6 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9632301034883 40.7925707244111) | 19 | 4 | 19 | 13 | |||||
2349 | 2349 | -73.980033740004 | 40.7683608292333 | 2B-PM-1013-04 | 02B | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.980033740004 40.7683608292333) | 19 | 4 | 19 | 13 | |||||
2338 | 2338 | -73.9716621112698 | 40.7742862219469 | 11E-AM-1013-01 | 11E | AM | 10132018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9716621112698 40.7742862219469) | 19 | 4 | 19 | 13 | ||||||
2284 | 2284 | -73.9730181306326 | 40.7794601322427 | 16A-AM-1013-02 | 16A | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9730181306326 40.7794601322427) | 19 | 4 | 19 | 13 | |||||||
2278 | 2278 | -73.964539031099 | 40.7809916310012 | 20G-PM-1013-01 | 20G | PM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.964539031099 40.7809916310012) | 19 | 4 | 19 | 13 | |||||
2275 | 2275 | -73.9614218413356 | 40.7938945058793 | 34B-AM-1013-01 | 34B | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | true | hopping | false | false | false | false | true | true | false | false | POINT (-73.9614218413356 40.7938945058793) | 19 | 4 | 19 | 13 | ||||
2274 | 2274 | -73.9698044218476 | 40.7697007833531 | 7I-PM-1013-06 | 07I | PM | 10132018 | 6 | Adult | Cinnamon | Cinnamon+ | "Brown" written in as Primary | Ground Plane | FALSE | Under the tree | false | false | false | true | false | playing,interacting with #7 | false | false | false | false | true | false | false | true | POINT (-73.9698044218476 40.7697007833531) | 19 | 4 | 19 | 13 | |||
2263 | 2263 | -73.9569375355884 | 40.7935398008612 | 36E-AM-1013-02 | 36E | AM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9569375355884 40.7935398008612) | 19 | 4 | 19 | 13 | ||||||
2262 | 2262 | -73.9556177490335 | 40.7888569161537 | 32I-AM-1013-03 | 32I | AM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | watching me from tree - curious | POINT (-73.9556177490335 40.7888569161537) | 19 | 4 | 19 | 13 | ||||
2249 | 2249 | -73.9785709201168 | 40.7674391934208 | 2C-PM-1013-02 | 02C | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9785709201168 40.7674391934208) | 19 | 4 | 19 | 13 | |||||
2242 | 2242 | -73.9565824187667 | 40.797312050952 | 40D-AM-1013-06 | 40D | AM | 10132018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | true | false | true | false | true | true | false | false | false | true | false | false | true | POINT (-73.9565824187667 40.797312050952) | 19 | 4 | 19 | 13 | |||||
2212 | 2212 | -73.9801138983722 | 40.7685721515635 | 2B-PM-1013-02 | 02B | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9801138983722 40.7685721515635) | 19 | 4 | 19 | 13 | |||||
2194 | 2194 | -73.960898739757 | 40.7961393097144 | 37A-PM-1013-02 | 37A | PM | 10132018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.960898739757 40.7961393097144) | 19 | 4 | 19 | 13 | |||||
2183 | 2183 | -73.967334936601 | 40.7773289724189 | 16F-PM-1013-01 | 16F | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | Woods | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.967334936601 40.7773289724189) | 19 | 4 | 19 | 13 | ||||
2179 | 2179 | -73.9559663949511 | 40.7974497269789 | 40D-AM-1013-07 | 40D | AM | 10132018 | 7 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | true | false | false | false | false | false | false | false | true | curious | POINT (-73.9559663949511 40.7974497269789) | 19 | 4 | 19 | 13 | |||||
2175 | 2175 | -73.9657487923637 | 40.7786823090663 | 18G-PM-1013-04 | 18G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657487923637 40.7786823090663) | 19 | 4 | 19 | 13 | ||||||
2165 | 2165 | -73.9794371709817 | 40.768387910254 | 2B-PM-1013-07 | 02B | PM | 10132018 | 7 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | POINT (-73.9794371709817 40.768387910254) | 19 | 4 | 19 | 13 | ||||||
2161 | 2161 | -73.9715375915057 | 40.7751212088827 | 12D-AM-1013-01 | 12D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | false | false | POINT (-73.9715375915057 40.7751212088827) | 19 | 4 | 19 | 13 | |||||
2143 | 2143 | -73.9596232170232 | 40.7959550843229 | 37B-PM-1013-01 | 37B | PM | 10132018 | 1 | Adult | Gray | Gray+ | Sighting was far away | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9596232170232 40.795955084322905) | 19 | 4 | 19 | 13 | |||||
2138 | 2138 | -73.9791536183194 | 40.7672705931866 | 1C-PM-1013-03 | 01C | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9791536183194 40.7672705931866) | 19 | 4 | 19 | 13 | |||||
2132 | 2132 | -73.967472660349 | 40.7772125619715 | 16F-PM-1013-03 | 16F | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | Woods | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.96747266034902 40.7772125619715) | 19 | 4 | 19 | 13 | ||||
2102 | 2102 | -73.9593909381748 | 40.7961036981921 | 37B-PM-1013-03 | 37B | PM | 10132018 | 3 | Adult | Cinnamon | White | Cinnamon+White | White back left leg | false | false | false | true | true | watching | false | false | false | false | false | false | false | true | POINT (-73.9593909381748 40.7961036981921) | 19 | 4 | 19 | 13 | |||||
2072 | 2072 | -73.9618709589382 | 40.7944969066792 | 35A-PM-1013-02 | 35A | PM | 10132018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9618709589382 40.7944969066792) | 19 | 4 | 19 | 13 | |||||
2068 | 2068 | -73.9735587560787 | 40.7672346255151 | 3G-PM-1013-02 | 03G | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | false | wandering,interacting with tourists | false | false | false | false | false | true | false | false | approaches (father - son taking photos,talking about giving him planters peanuts) | POINT (-73.9735587560787 40.7672346255151) | 19 | 4 | 19 | 13 | |||
2042 | 2042 | -73.9800896621713 | 40.7684379810317 | 2B-PM-1013-03 | 02B | PM | 10132018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9800896621713 40.7684379810317) | 19 | 4 | 19 | 13 | |||||
2030 | 2030 | -73.9749251267433 | 40.7679111971294 | 4F-PM-1013-01 | 04F | PM | 10132018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | true | false | false | POINT (-73.9749251267433 40.7679111971294) | 19 | 4 | 19 | 13 | |||||
2014 | 2014 | -73.9786474809514 | 40.7679715341109 | 2C-PM-1013-04 | 02C | PM | 10132018 | 4 | Adult | Gray | White | Gray+White | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9786474809514 40.7679715341109) | 19 | 4 | 19 | 13 | |||||||
2011 | 2011 | -73.9603245806655 | 40.7942712477697 | 35C-PM-1013-04 | 35C | PM | 10132018 | 4 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9603245806655 40.7942712477697) | 19 | 4 | 19 | 13 | ||||||
1967 | 1967 | -73.9647247254127 | 40.7806136565784 | 20G-PM-1013-03 | 20G | PM | 10132018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | false | true | POINT (-73.9647247254127 40.7806136565784) | 19 | 4 | 19 | 13 | |||||
1953 | 1953 | -73.9644974196807 | 40.7810020292593 | 20G-PM-1013-02 | 20G | PM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.96449741968071 40.7810020292593) | 19 | 4 | 19 | 13 | |||||
1952 | 1952 | -73.9681810466693 | 40.7720638449419 | 10I-PM-1013-01 | 10I | PM | 10132018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9681810466693 40.7720638449419) | 19 | 4 | 19 | 13 | |||||
1945 | 1945 | -73.9530257401736 | 40.795139740737 | 39G-PM-1013-01 | 39G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9530257401736 40.79513974073701) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
1938 | 1938 | -73.9719879697272 | 40.7725625124591 | 9F-AM-1013-02 | 09F | AM | 10132018 | 2 | Adult | Black | Black+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9719879697272 40.7725625124591) | 19 | 4 | 19 | 13 | ||||||
1932 | 1932 | -73.9616972557304 | 40.7953872829374 | 36A-PM-1013-03 | 36A | PM | 10132018 | 3 | Juvenile | Cinnamon | Cinnamon+ | COULD HAVE BEEN CHIPPY, DEEP BROWN | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9616972557304 40.7953872829374) | 19 | 4 | 19 | 13 | |||||
1922 | 1922 | -73.9602197762862 | 40.7936850570022 | 35C-PM-1013-07 | 35C | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9602197762862 40.7936850570022) | 19 | 4 | 19 | 13 | ||||||
1915 | 1915 | -73.9797112925048 | 40.7688046778472 | 2B-PM-1013-09 | 02B | PM | 10132018 | 9 | Adult | Gray | White | Gray+White | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9797112925048 40.7688046778472) | 19 | 4 | 19 | 13 | |||||
1900 | 1900 | -73.9529224802393 | 40.7961895763649 | 40G-PM-1013-05 | 40G | PM | 10132018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (to the tree) | POINT (-73.9529224802393 40.7961895763649) | 19 | 4 | 19 | 13 | |||||
1896 | 1896 | -73.973998077367 | 40.7739029133911 | 10C-PM-1013-01 | 10C | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.973998077367 40.7739029133911) | 19 | 4 | 19 | 13 | |||||
1872 | 1872 | -73.9613998967903 | 40.7912437235667 | 32C-PM-1013-02 | 32C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9613998967903 40.7912437235667) | 19 | 4 | 19 | 13 | ||||||
1865 | 1865 | -73.9558118887106 | 40.796885713436 | 39E-PM-1013-01 | 39E | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon head | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9558118887106 40.796885713436005) | 19 | 4 | 19 | 13 | ||||
1854 | 1854 | -73.9618076359384 | 40.7947808718203 | 35A-PM-1013-05 | 35A | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9618076359384 40.7947808718203) | 19 | 4 | 19 | 13 | |||||
1852 | 1852 | -73.9792161469158 | 40.7679285436253 | 2C-PM-1013-10 | 02C | PM | 10132018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9792161469158 40.7679285436253) | 19 | 4 | 19 | 13 | |||||
1823 | 1823 | -73.9612854506075 | 40.7920830673571 | 32C-PM-1013-04 | 32C | PM | 10132018 | 4 | Juvenile | Gray | Gray+ | Above Ground | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9612854506075 40.7920830673571) | 19 | 4 | 19 | 13 |
JSON shape: default, array, newline-delimited
CREATE TABLE squirrels( "Longitude" TEXT, "Latitude" TEXT, "Unique Squirrel ID" TEXT, "Hectare" TEXT, "Shift" TEXT, "Date" TEXT, "Hectare Squirrel Number" TEXT, "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" TEXT, "Chasing" TEXT, "Climbing" TEXT, "Eating" TEXT, "Foraging" TEXT, "Other Activities" TEXT, "Kuks" TEXT, "Quaas" TEXT, "Moans" TEXT, "Tail flags" TEXT, "Tail twitches" TEXT, "Approaches" TEXT, "Indifferent" TEXT, "Runs from" TEXT, "Other Interactions" TEXT, "Lat/Long" TEXT, "Zip Codes" TEXT, "Community Districts" TEXT, "Borough Boundaries" TEXT, "City Council Districts" TEXT, "Police Precincts" TEXT );