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 | Zip Codes | Community Districts | Borough Boundaries | City Council Districts | Police Precincts |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
661 | 661 | -73.9700759073973 | 40.7680560871695 | 5I-AM-1010-01 | 05I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700759073973 40.7680560871695) | 10090 | 23 | 4 | 51 | 11 | |||||
671 | 671 | -73.9709244006956 | 40.7676942639697 | 5I-AM-1010-02 | 05I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9709244006956 40.7676942639697) | 19 | 4 | 19 | 13 | ||||||
676 | 676 | -73.9710207438538 | 40.7682187144432 | 5I-AM-1010-05 | 05I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9710207438538 40.7682187144432) | 19 | 4 | 19 | 13 | ||||||
707 | 707 | -73.961547503801 | 40.7931560668672 | 33B-AM-1010-06 | 33B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.961547503801 40.7931560668672) | 19 | 4 | 19 | 13 | ||||||
739 | 739 | -73.9620597449066 | 40.7922465876813 | 33B-PM-1010-10 | 33B | PM | 10102018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | true | false | false | false | false | false | false | false | POINT (-73.9620597449066 40.7922465876813) | 19 | 4 | 19 | 13 | ||||||
785 | 785 | -73.9619417432685 | 40.7930365939865 | 33B-PM-1010-12 | 33B | PM | 10102018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9619417432685 40.7930365939865) | 19 | 4 | 19 | 13 | ||||||
822 | 822 | -73.9576559099012 | 40.7992598626483 | 41B-AM-1010-09 | 41B | AM | 10102018 | 9 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9576559099012 40.7992598626483) | 19 | 4 | 19 | 13 | ||||||
828 | 828 | -73.9545101041865 | 40.7903823616782 | 34I-PM-1010-03 | 34I | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | in the playground. | true | false | false | false | true | with some nuts in the mouth | false | false | false | false | false | false | false | false | POINT (-73.9545101041865 40.7903823616782) | 19 | 4 | 19 | 13 | ||||
903 | 903 | -73.9719941577406 | 40.77037129313 | 7G-AM-1010-04 | 07G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9719941577406 40.77037129313) | 19 | 4 | 19 | 13 | ||||||
910 | 910 | -73.9796383715206 | 40.7682477738244 | 2B-AM-1010-07 | 02B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9796383715206 40.7682477738244) | 19 | 4 | 19 | 13 | ||||||
923 | 923 | -73.9578924882613 | 40.789806297824 | 32G-AM-1010-02 | 32G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 13 | false | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9578924882613 40.789806297824) | 19 | 4 | 19 | 13 | ||||||
933 | 933 | -73.9616204569548 | 40.7926188605509 | 33B-PM-1010-01 | 33B | PM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9616204569548 40.7926188605509) | 19 | 4 | 19 | 13 | ||||||
948 | 948 | -73.9568143871234 | 40.7899001700041 | 32G-AM-1010-01 | 32G | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9568143871234 40.7899001700041) | 19 | 4 | 19 | 13 | ||||||
977 | 977 | -73.9764601882854 | 40.766070446642 | 1F-AM-1010-05 | 01F | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9764601882854 40.766070446642) | 19 | 4 | 19 | 13 | ||||||
988 | 988 | -73.9787040192473 | 40.7679010247281 | 2C-AM-1010-06 | 02C | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | stood still & watched me then jumped on a fence and ran away | false | false | false | false | false | false | true | true | POINT (-73.9787040192473 40.7679010247281) | 19 | 4 | 19 | 13 | |||||
990 | 990 | -73.9629615594409 | 40.7924176425827 | 32B-PM-1010-06 | 32B | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9629615594409 40.7924176425827) | 19 | 4 | 19 | 13 | ||||||
1000 | 1000 | -73.9805137046778 | 40.769275143797 | 2A-AM-1010-08 | 02A | AM | 10102018 | 8 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9805137046778 40.769275143797) | 19 | 4 | 19 | 13 | |||||
1084 | 1084 | -73.9698839750249 | 40.7781433076692 | 16D-PM-1010-08 | 16D | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9698839750249 40.7781433076692) | 19 | 4 | 19 | 13 | ||||||
1156 | 1156 | -73.9688929282726 | 40.7768899536946 | 15F-PM-1010-01 | 15F | PM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9688929282726 40.7768899536946) | 19 | 4 | 19 | 13 | ||||||
1195 | 1195 | -73.9801698909399 | 40.7683721553321 | 2B-AM-1010-04 | 02B | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9801698909399 40.7683721553321) | 19 | 4 | 19 | 13 | ||||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
1238 | 1238 | -73.9773692131441 | 40.7679771150149 | 3D-PM-1010-02 | 03D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9773692131441 40.7679771150149) | 19 | 4 | 19 | 13 | ||||||
1251 | 1251 | -73.9748247677824 | 40.7667893867839 | 2G-AM-1010-01 | 02G | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9748247677824 40.7667893867839) | 19 | 4 | 19 | 13 | ||||||
1277 | 1277 | -73.9619609976132 | 40.7922824443528 | 33B-PM-1010-09 | 33B | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9619609976132 40.7922824443528) | 19 | 4 | 19 | 13 | ||||||
1293 | 1293 | -73.9775465365348 | 40.7681943707876 | 3D-PM-1010-09 | 03D | PM | 10102018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9775465365348 40.7681943707876) | 19 | 4 | 19 | 13 | ||||||
1357 | 1357 | -73.9631350020634 | 40.791907210332 | 32B-PM-1010-01 | 32B | PM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 25 | in tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9631350020634 40.791907210332) | 19 | 4 | 19 | 13 | |||||
1365 | 1365 | -73.9791648157033 | 40.767625444347 | 2C-AM-1010-04 | 02C | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9791648157033 40.767625444347) | 19 | 4 | 19 | 13 | ||||||
1550 | 1550 | -73.9698642668906 | 40.7784669316504 | 16D-PM-1010-10 | 16D | PM | 10102018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698642668906 40.7784669316504) | 19 | 4 | 19 | 13 | ||||||
1606 | 1606 | -73.9628932797886 | 40.7923116396365 | 32B-PM-1010-05 | 32B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9628932797886 40.7923116396365) | 19 | 4 | 19 | 13 | ||||||
1643 | 1643 | -73.9530535624781 | 40.7929809144271 | 37I-AM-1010-02 | 37I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9530535624781 40.7929809144271) | 19 | 4 | 19 | 13 | ||||||
1645 | 1645 | -73.9619673317128 | 40.7924176673037 | 33B-PM-1010-08 | 33B | PM | 10102018 | 8 | Juvenile | Gray | Gray+ | Above Ground | running up tree | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9619673317128 40.7924176673037) | 19 | 4 | 19 | 13 | ||||||
1693 | 1693 | -73.9593781427412 | 40.7841519912635 | 26I-AM-1010-02 | 26I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95937814274122 40.7841519912635) | 19 | 4 | 19 | 13 | ||||||
1718 | 1718 | -73.9682676237703 | 40.7772653590224 | 15F-PM-1010-04 | 15F | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | on path | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9682676237703 40.7772653590224) | 19 | 4 | 19 | 13 | |||||
1751 | 1751 | -73.9594045885402 | 40.7840886870652 | 26I-AM-1010-01 | 26I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9594045885402 40.7840886870652) | 19 | 4 | 19 | 13 | ||||||
1811 | 1811 | -73.9788088165392 | 40.7690153025878 | 3B-AM-1010-04 | 03B | AM | 10102018 | 4 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9788088165392 40.7690153025878) | 19 | 4 | 19 | 13 | ||||||
1824 | 1824 | -73.9617250054003 | 40.7925390432044 | 33B-PM-1010-03 | 33B | PM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9617250054003 40.7925390432044) | 19 | 4 | 19 | 13 | ||||||
1829 | 1829 | -73.9746965894947 | 40.7664351724309 | 2G-AM-1010-03 | 02G | AM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9746965894947 40.7664351724309) | 19 | 4 | 19 | 13 | ||||||
1838 | 1838 | -73.9686622009739 | 40.7767294380502 | 15F-PM-1010-02 | 15F | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686622009739 40.7767294380502) | 19 | 4 | 19 | 13 | ||||||
1881 | 1881 | -73.9674984567017 | 40.7745938268705 | 13H-PM-1010-04 | 13H | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9674984567017 40.7745938268705) | 19 | 4 | 19 | 13 | ||||||
1882 | 1882 | -73.9541601469123 | 40.7907832744689 | 34I-PM-1010-04 | 34I | PM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | across the lawn and climb up a small tree | true | false | true | false | false | grooming | false | false | false | false | false | false | false | false | POINT (-73.9541601469123 40.79078327446891) | 19 | 4 | 19 | 13 | ||||
1890 | 1890 | -73.9787723082807 | 40.7713655754004 | 5A-PM-1010-03 | 05A | PM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9787723082807 40.7713655754004) | 19 | 4 | 19 | 13 | ||||||
1902 | 1902 | -73.9703314162405 | 40.778584776139 | 16D-PM-1010-12 | 16D | PM | 10102018 | 12 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9703314162405 40.778584776139) | 19 | 4 | 19 | 13 | ||||||
1903 | 1903 | -73.9701379806066 | 40.7785234812393 | 16D-PM-1010-11 | 16D | PM | 10102018 | 11 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9701379806066 40.7785234812393) | 19 | 4 | 19 | 13 | ||||||
1934 | 1934 | -73.969756965598 | 40.7786455091699 | 16D-PM-1010-02 | 16D | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.969756965598 40.7786455091699) | 19 | 4 | 19 | 13 | ||||||
1951 | 1951 | -73.9548431601579 | 40.7906346271566 | 34I-PM-1010-02 | 34I | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9548431601579 40.7906346271566) | 19 | 4 | 19 | 13 | ||||||
2038 | 2038 | -73.9803562137049 | 40.7685780990634 | 2B-AM-1010-02 | 02B | AM | 10102018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | false | true | POINT (-73.9803562137049 40.7685780990634) | 19 | 4 | 19 | 13 | ||||||
2076 | 2076 | -73.9712636931964 | 40.77998098773 | 17B-AM-1010-03 | 17B | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9712636931964 40.77998098773) | 19 | 4 | 19 | 13 | ||||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2172 | 2172 | -73.9642900903774 | 40.7917017168842 | 31A-AM-1010-03 | 31A | AM | 10102018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9642900903774 40.7917017168842) | 19 | 4 | 19 | 13 | ||||||
2219 | 2219 | -73.9709242364673 | 40.7684217215595 | 5I-AM-1010-04 | 05I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9709242364673 40.7684217215595) | 19 | 4 | 19 | 13 | ||||||
2240 | 2240 | -73.9697787673802 | 40.7781746195436 | 16D-PM-1010-05 | 16D | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9697787673802 40.7781746195436) | 19 | 4 | 19 | 13 | ||||||
2297 | 2297 | -73.9787771053108 | 40.769356212275 | 3B-AM-1010-07 | 03B | AM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | together w/ #8 | false | false | false | true | false | false | true | false | POINT (-73.9787771053108 40.76935621227501) | 19 | 4 | 19 | 13 | |||||
2361 | 2361 | -73.9708032298419 | 40.7784265674544 | 15C-AM-1010-02 | 15C | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | nest building | false | false | false | false | false | false | true | false | POINT (-73.9708032298419 40.77842656745441) | 19 | 4 | 19 | 13 | |||||
2379 | 2379 | -73.9711865134364 | 40.7785039981892 | 15C-AM-1010-03 | 15C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | true | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9711865134364 40.7785039981892) | 19 | 4 | 19 | 13 | |||||
2385 | 2385 | -73.9787552947847 | 40.7690779628762 | 3B-AM-1010-06 | 03B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9787552947847 40.7690779628762) | 19 | 4 | 19 | 13 | ||||||
2420 | 2420 | -73.9587787592751 | 40.7981699014259 | 40A-AM-1010-01 | 40A | AM | 10102018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 30 | bottom of great hill | false | false | true | false | false | false | false | false | false | false | false | false | false | climbing up a tree | POINT (-73.9587787592751 40.7981699014259) | 19 | 4 | 19 | 13 | ||||
2435 | 2435 | -73.972087127535 | 40.776237268628 | 13C-AM-1010-01 | 13C | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.972087127535 40.776237268628) | 19 | 4 | 19 | 13 | ||||||
2459 | 2459 | -73.9679156307975 | 40.7745269360259 | 13H-PM-1010-06 | 13H | PM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9679156307975 40.7745269360259) | 19 | 4 | 19 | 13 | ||||||
2468 | 2468 | -73.9674603784345 | 40.7749493803168 | 13H-PM-1010-01 | 13H | PM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9674603784345 40.774949380316805) | 19 | 4 | 19 | 13 | ||||||
2470 | 2470 | -73.96388775887 | 40.7915477304252 | 31A-AM-1010-02 | 31A | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | scratching | false | false | false | false | false | false | true | false | POINT (-73.96388775887 40.7915477304252) | 19 | 4 | 19 | 13 | |||||
2476 | 2476 | -73.9710843362124 | 40.7679739601336 | 5I-AM-1010-03 | 05I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 3 | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9710843362124 40.7679739601336) | 19 | 4 | 19 | 13 | ||||||
2533 | 2533 | -73.9766195697096 | 40.7661907261547 | 1F-AM-1010-04 | 01F | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9766195697096 40.7661907261547) | 19 | 4 | 19 | 13 | ||||||
2548 | 2548 | -73.9703571491616 | 40.7678515625131 | 5I-AM-1010-06 | 05I | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703571491616 40.7678515625131) | 10090 | 23 | 4 | 51 | 11 | |||||
2555 | 2555 | -73.9613127978423 | 40.7929321504568 | 33B-AM-1010-04 | 33B | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9613127978423 40.7929321504568) | 19 | 4 | 19 | 13 | ||||||
2565 | 2565 | -73.9708640291801 | 40.7781721063527 | 15C-AM-1010-01 | 15C | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9708640291801 40.7781721063527) | 19 | 4 | 19 | 13 | ||||||
2570 | 2570 | -73.9721064150173 | 40.7667053821991 | 3I-AM-1010-01 | 03I | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721064150173 40.7667053821991) | 19 | 4 | 19 | 13 | ||||||
2578 | 2578 | -73.9765386965371 | 40.766371971273 | 1F-AM-1010-02 | 01F | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765386965371 40.766371971273) | 19 | 4 | 19 | 13 | ||||||
2614 | 2614 | -73.9765877920583 | 40.7660946071574 | 1F-AM-1010-04 | 01F | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9765877920583 40.7660946071574) | 19 | 4 | 19 | 13 | ||||||
2640 | 2640 | -73.9788304714091 | 40.7696373635315 | 4B-AM-1010-06 | 04B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Above Ground | 12 | true | false | false | false | false | running from squirrel #5 | false | false | false | false | false | false | false | false | POINT (-73.9788304714091 40.7696373635315) | 19 | 4 | 19 | 13 | |||||
2717 | 2717 | -73.9632238528617 | 40.7920328991252 | 32B-PM-1010-02 | 32B | PM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9632238528617 40.7920328991252) | 19 | 4 | 19 | 13 | ||||||
2780 | 2780 | -73.9700634278 | 40.7784223722453 | 16D-PM-1010-07 | 16D | PM | 10102018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9700634278 40.7784223722453) | 19 | 4 | 19 | 13 | ||||||
2781 | 2781 | -73.9752673884392 | 40.7662642413761 | 2G-AM-1010-04 | 02G | AM | 10102018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9752673884392 40.7662642413761) | 19 | 4 | 19 | 13 | ||||||
2807 | 2807 | -73.9618213644671 | 40.7927648819738 | 33B-AM-1010-02 | 33B | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96182136446711 40.7927648819738) | 19 | 4 | 19 | 13 | ||||||
2875 | 2875 | -73.9546616782922 | 40.790974533739 | 34I-PM-1010-05 | 34I | PM | 10102018 | 5 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 | ||||||||
2894 | 2894 | -73.979734151564 | 40.7682150214703 | 2B-AM-1010-06 | 02B | AM | 10102018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.979734151564 40.7682150214703) | 19 | 4 | 19 | 13 | ||||||
2914 | 2914 | -73.9722053355548 | 40.7662094993614 | 3I-AM-1010-03 | 03I | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 50 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9722053355548 40.7662094993614) | 19 | 4 | 19 | 13 | ||||||
2939 | 2939 | -73.9680204438195 | 40.7743882322654 | 13H-PM-1010-08 | 13H | PM | 10102018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9680204438195 40.77438823226541) | 19 | 4 | 19 | 13 | ||||||
2962 | 2962 | -73.9722530826293 | 40.7667138028361 | 3I-AM-1010-05 | 03I | AM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9722530826293 40.7667138028361) | 19 | 4 | 19 | 13 | ||||||
2970 | 2970 | -73.9619019299709 | 40.7924476439693 | 33B-PM-1010-05 | 33B | PM | 10102018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9619019299709 40.7924476439693) | 19 | 4 | 19 | 13 | ||||||
2994 | 2994 | -73.9617207091245 | 40.7922839025935 | 33B-AM-1010-01 | 33B | AM | 10102018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9617207091245 40.7922839025935) | 19 | 4 | 19 | 13 | |||||
3006 | 3006 | -73.9744390217386 | 40.7663168362582 | 2G-AM-1010-02 | 02G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9744390217386 40.7663168362582) | 19 | 4 | 19 | 13 | ||||||
1309 | 1309 | -73.9545841828392 | 40.7926924268376 | 36H-AM-1010-01 | 36H | AM | 10102018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9545841828392 40.7926924268376) | 19 | 4 | 19 | 13 | |||||
1164 | 1164 | -73.9790226400629 | 40.7698997653792 | 4B-AM-1010-01 | 04B | AM | 10102018 | 1 | Adult | Gray | Black, Cinnamon | Gray+Black, Cinnamon | Above Ground | 2 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9790226400629 40.7698997653792) | 19 | 4 | 19 | 13 | |||||
1627 | 1627 | -73.9594391759139 | 40.784115697669 | 26I-PM-1010-03 | 26I | PM | 10102018 | 3 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | black in tail | Above Ground | 15 | tree | false | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.9594391759139 40.784115697669) | 19 | 4 | 19 | 13 | |||
16 | 16 | -73.9722500196844 | 40.7742879599026 | 11D-AM-1010-03 | 11D | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | grooming | false | false | false | false | false | false | true | false | POINT (-73.9722500196844 40.7742879599026) | 19 | 4 | 19 | 13 | ||||
124 | 124 | -73.9588660250232 | 40.7982597947515 | 40A-AM-1010-03 | 40A | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom of great hill | false | false | false | true | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9588660250232 40.7982597947515) | 19 | 4 | 19 | 13 | |||
146 | 146 | -73.95621174551 | 40.7951044378207 | 38E-AM-1010-09 | 38E | AM | 10102018 | 9 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95621174551 40.7951044378207) | 19 | 4 | 19 | 13 | |||||
191 | 191 | -73.9787105069657 | 40.7693708133873 | 3B-AM-1010-08 | 03B | AM | 10102018 | 8 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | together w/ #7 | false | false | false | false | false | false | true | false | POINT (-73.9787105069657 40.7693708133873) | 19 | 4 | 19 | 13 | ||||
242 | 242 | -73.9590236602085 | 40.7982632456866 | 40A-AM-1010-04 | 40A | AM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | bottom great hill | false | false | false | false | true | false | false | false | true | false | false | true | true | dog chased | POINT (-73.9590236602085 40.7982632456866) | 19 | 4 | 19 | 13 | |||
253 | 253 | -73.9589627056561 | 40.7847591558491 | 26I-PM-1010-02 | 26I | PM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | hiding food | false | false | false | false | true | false | true | false | POINT (-73.9589627056561 40.7847591558491) | 19 | 4 | 19 | 13 | ||||
287 | 287 | -73.9709281471442 | 40.7828097939777 | 20A-AM-1010-02 | 20A | AM | 10102018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9709281471442 40.7828097939777) | 19 | 4 | 19 | 13 | |||||
313 | 313 | -73.9646610347972 | 40.7790583544252 | 19H-AM-1010-05 | 19H | AM | 10102018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | near a brush | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9646610347972 40.7790583544252) | 19 | 4 | 19 | 13 | ||||
522 | 522 | -73.9773821135611 | 40.7690453494383 | 4C-PM-1010-06 | 04C | PM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | behind playground benches | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9773821135611 40.7690453494383) | 19 | 4 | 19 | 13 | ||||
547 | 547 | -73.9559677963727 | 40.7951124076946 | 38E-AM-1010-07 | 38E | AM | 10102018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | branches | true | true | false | false | false | chasing and being chased by #6 | false | false | false | false | true | false | false | true | POINT (-73.9559677963727 40.7951124076946) | 19 | 4 | 19 | 13 | |||
572 | 572 | -73.9763622269272 | 40.7704671295941 | 5C-PM-1010-10 | 05C | PM | 10102018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | true | false | false | fed by woman | POINT (-73.9763622269272 40.7704671295941) | 19 | 4 | 19 | 13 | ||||
597 | 597 | -73.9718270820347 | 40.7748300991287 | 11D-AM-1010-06 | 11D | AM | 10102018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.97182708203471 40.7748300991287) | 19 | 4 | 19 | 13 | |||||
619 | 619 | -73.9769887473852 | 40.7707561532949 | 5C-PM-1010-04 | 05C | PM | 10102018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.97698874738522 40.7707561532949) | 19 | 4 | 19 | 13 | |||||
650 | 650 | -73.9809610117171 | 40.7683896665502 | 2A-AM-1010-02 | 02A | AM | 10102018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | perched on small fence | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9809610117171 40.7683896665502) | 19 | 4 | 19 | 13 | ||||||
678 | 678 | -73.977447585355 | 40.7697167828003 | 4C-PM-1010-11 | 04C | PM | 10102018 | 11 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.977447585355 40.7697167828003) | 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 );