This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Foraging, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3019 | 3019 | -73.9639431360458 | 40.7908677445466 | 30B-AM-1007-04 | 30B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9639431360458 40.7908677445466) | 19 | 4 | 19 | 13 | ||||||
3016 | 3016 | -73.9756457597888 | 40.7703559775625 | 6D-PM-1020-02 | 06D | PM | 10202018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9756457597888 40.7703559775625) | 19 | 4 | 19 | 13 | ||||||
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 | ||||
2991 | 2991 | -73.9684632673603 | 40.7848909525198 | 23A-AM-1018-05 | 23A | AM | 10182018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9684632673603 40.7848909525198) | 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 | ||||||
2929 | 2929 | -73.953123365424 | 40.7941113777459 | 38H-PM-1012-01 | 38H | PM | 10122018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.953123365424 40.7941113777459) | 19 | 4 | 19 | 13 | ||||||
2924 | 2924 | -73.9727230609785 | 40.7795341640894 | 16A-PM-1019-01 | 16A | PM | 10192018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9727230609785 40.7795341640894) | 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 | ||||
2818 | 2818 | -73.9681664642028 | 40.7724669681958 | 11I-PM-1012-02 | 11I | PM | 10122018 | 2 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | false | true | runs away from the ball | POINT (-73.9681664642028 40.7724669681958) | 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 | ||||||
2803 | 2803 | -73.9576652087316 | 40.7875457977801 | 29H-PM-1006-02 | 29H | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9576652087316 40.7875457977801) | 19 | 4 | 19 | 13 | ||||||
2749 | 2749 | -73.972967003211 | 40.7711848438157 | 7F-AM-1008-17 | 07F | AM | 10082018 | 17 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | scratching self | false | false | false | false | false | false | false | true | POINT (-73.972967003211 40.7711848438157) | 19 | 4 | 19 | 13 | |||||
2734 | 2734 | -73.9763629541474 | 40.7682321897044 | 3E-PM-1008-04 | 03E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9763629541474 40.7682321897044) | 19 | 4 | 19 | 13 | ||||||
2678 | 2678 | -73.9562946873694 | 40.7938593012595 | 36F-AM-1017-01 | 36F | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9562946873694 40.7938593012595) | 19 | 4 | 19 | 13 | |||||
2634 | 2634 | -73.9695685186489 | 40.7788293026327 | 16D-AM-1007-04 | 16D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9695685186489 40.7788293026327) | 19 | 4 | 19 | 13 | ||||||
2621 | 2621 | -73.9596904740342 | 40.7897200025671 | 31E-AM-1014-01 | 31E | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9596904740342 40.7897200025671) | 19 | 4 | 19 | 13 | ||||||
2593 | 2593 | -73.9590191812452 | 40.7906166981409 | 32E-PM-1017-08 | 32E | PM | 10172018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590191812452 40.7906166981409) | 19 | 4 | 19 | 13 | |||||
2577 | 2577 | -73.9597048490102 | 40.7955846466241 | 37B-AM-1018-06 | 37B | AM | 10182018 | 6 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.9597048490102 40.7955846466241) | 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 | ||||||
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 | |||||
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 | ||||||
2422 | 2422 | -73.9683066605832 | 40.7781213930544 | 16E-PM-1018-03 | 16E | PM | 10182018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9683066605832 40.7781213930544) | 19 | 4 | 19 | 13 | ||||||
2419 | 2419 | -73.9590551473416 | 40.7891607060794 | 31F-PM-1007-02 | 31F | PM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | tree trunk | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.95905514734162 40.7891607060794) | 19 | 4 | 19 | 13 | |||||
2416 | 2416 | -73.9588689820908 | 40.7992384137972 | 40A-PM-1014-03 | 40A | PM | 10142018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588689820908 40.799238413797205) | 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 | ||||
2354 | 2354 | -73.9636740170308 | 40.7903538224977 | 30B-AM-1007-12 | 30B | AM | 10072018 | 12 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.96367401703081 40.79035382249771) | 19 | 4 | 19 | 13 | ||||||
2347 | 2347 | -73.9663124560664 | 40.779544003786 | 18F-PM-1008-02 | 18F | PM | 10082018 | 2 | Adult | Gray | Gray+ | false | false | false | false | false | hopping around | false | false | false | false | false | false | false | true | POINT (-73.9663124560664 40.779544003786) | 19 | 4 | 19 | 13 | |||||||
2345 | 2345 | -73.965738547469 | 40.7886962740167 | 27B-PM-1006-01 | 27B | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | By large tree | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.965738547469 40.7886962740167) | 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 | ||||||
2335 | 2335 | -73.9704679459444 | 40.7773384236212 | 14D-PM-1019-10 | 14D | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | true | false | false | false | true | POINT (-73.9704679459444 40.7773384236212) | 19 | 4 | 19 | 13 | ||||||
2318 | 2318 | -73.967458693983 | 40.7769922522105 | 15G-AM-1008-02 | 15G | AM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967458693983 40.7769922522105) | 19 | 4 | 19 | 13 | ||||||
2279 | 2279 | -73.9586085858962 | 40.7990326758282 | 40A-PM-1014-04 | 40A | PM | 10142018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from path to bushes) | POINT (-73.9586085858962 40.7990326758282) | 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 | ||||||
2261 | 2261 | -73.9609692861012 | 40.790502891247 | 31D-AM-1014-07 | 31D | AM | 10142018 | 7 | Gray | Gray+ | Ground Plane | FALSE | Crossing path to tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9609692861012 40.790502891247) | 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 | ||||||
2239 | 2239 | -73.9668922014699 | 40.7823535653774 | 21D-AM-1008-06 | 21D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9668922014699 40.7823535653774) | 19 | 4 | 19 | 13 | ||||||
2215 | 2215 | -73.9674978826751 | 40.776288410765 | 15G-PM-1019-10 | 15G | PM | 10192018 | 10 | Adult | Gray | Gray+ | Above Ground | 1 | on a log | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9674978826751 40.776288410765) | 19 | 4 | 19 | 13 | |||||
2209 | 2209 | -73.9697583235533 | 40.7787320391004 | 16D-AM-1007-05 | 16D | AM | 10072018 | 5 | Adult | Gray | Gray+ | didn't get a good look | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96975832355331 40.7787320391004) | 19 | 4 | 19 | 13 | |||||
2193 | 2193 | -73.9569318105253 | 40.7973442139041 | 40C-PM-1006-07 | 40C | PM | 10062018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9569318105253 40.7973442139041) | 19 | 4 | 19 | 13 | ||||||
2182 | 2182 | -73.9573656523498 | 40.7979754563974 | 40C-AM-1017-01 | 40C | AM | 10172018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | false | chasing (#2) | false | false | false | false | false | false | false | true | POINT (-73.9573656523498 40.7979754563974) | 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 | ||||||
2162 | 2162 | -73.9583300280173 | 40.7853495002675 | 27I-PM-1020-04 | 27I | PM | 10202018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9583300280173 40.7853495002675) | 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 | |||||
2101 | 2101 | -73.957600085245 | 40.7936111607879 | 35E-PM-1006-04 | 35E | PM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.957600085245 40.7936111607879) | 19 | 4 | 19 | 13 | ||||||
2100 | 2100 | -73.9638312025305 | 40.7903826659569 | 30B-AM-1007-07 | 30B | AM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9638312025305 40.7903826659569) | 19 | 4 | 19 | 13 | ||||||
2070 | 2070 | -73.9725700261894 | 40.7668793330427 | 3H-PM-1014-01 | 03H | PM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | under a parked car | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9725700261894 40.7668793330427) | 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 | ||||||
2018 | 2018 | -73.9697924026634 | 40.7803611152023 | 18C-PM-1018-04 | 18C | PM | 10182018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9697924026634 40.7803611152023) | 19 | 4 | 19 | 13 | ||||||
2004 | 2004 | -73.9635838951472 | 40.7917524619792 | 31B-AM-1017-02 | 31B | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9635838951472 40.7917524619792) | 19 | 4 | 19 | 13 | ||||||
2000 | 2000 | -73.9591070579246 | 40.7896776771157 | 31F-PM-1007-05 | 31F | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9591070579246 40.7896776771157) | 19 | 4 | 19 | 13 | ||||||
1992 | 1992 | -73.9586085843149 | 40.7946617684536 | 36C-AM-1014-03 | 36C | AM | 10142018 | 3 | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9586085843149 40.7946617684536) | 19 | 4 | 19 | 13 | |||||||
1925 | 1925 | -73.9581389870644 | 40.7993081122523 | 41A-PM-1007-04 | 41A | PM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | true | false | true | false | false | laid down on the branch | false | false | false | false | false | false | false | true | POINT (-73.9581389870644 40.799308112252305) | 19 | 4 | 19 | 13 | |||||
1920 | 1920 | -73.9545383719188 | 40.7899711263765 | 33I-PM-1006-03 | 33I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.95453837191882 40.7899711263765) | 19 | 4 | 19 | 13 | ||||||
1908 | 1908 | -73.9588345546879 | 40.7991830272008 | 40A-PM-1014-02 | 40A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (ran from base of tree into bushes) | POINT (-73.9588345546879 40.7991830272008) | 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 | |||||
1879 | 1879 | -73.9701926736281 | 40.7778587687376 | 15D-AM-1007-02 | 15D | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9701926736281 40.7778587687376) | 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 | ||||||
1812 | 1812 | -73.9590074024938 | 40.7907059424675 | 32E-PM-1017-05 | 32E | PM | 10172018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590074024938 40.7907059424675) | 19 | 4 | 19 | 13 | |||||
1807 | 1807 | -73.9581366214863 | 40.7988964092722 | 40B-PM-1014-02 | 40B | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | true | true | false | false | false | false | false | true | POINT (-73.9581366214863 40.7988964092722) | 19 | 4 | 19 | 13 | ||||||
1794 | 1794 | -73.9757912350482 | 40.7747598621451 | 10B-AM-1006-04 | 10B | AM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9757912350482 40.7747598621451) | 19 | 4 | 19 | 13 | ||||||
1776 | 1776 | -73.9562350820255 | 40.7913464147989 | 34G-PM-1006-02 | 34G | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | eating bread it found on ground | false | false | false | false | false | false | false | true | POINT (-73.9562350820255 40.7913464147989) | 19 | 4 | 19 | 13 | |||||
1765 | 1765 | -73.9689041600147 | 40.7781788966185 | 16E-AM-1014-07 | 16E | AM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | true | false | false | false | false | false | false | false | false | false | false | false | true | runs from (dog) | POINT (-73.9689041600147 40.7781788966185) | 19 | 4 | 19 | 13 | ||||||
1746 | 1746 | -73.9603471161869 | 40.7906003311747 | 32E-PM-1017-15 | 32E | PM | 10172018 | 15 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9603471161869 40.7906003311747) | 19 | 4 | 19 | 13 | ||||||
1733 | 1733 | -73.9756345867747 | 40.7675540517649 | 3E-PM-1008-09 | 03E | PM | 10082018 | 9 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9756345867747 40.7675540517649) | 19 | 4 | 19 | 13 | ||||||
1732 | 1732 | -73.9767141407274 | 40.7737313251559 | 8A-PM-1014-02 | 08A | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.9767141407274 40.7737313251559) | 19 | 4 | 19 | 13 | |||||
1700 | 1700 | -73.965675791028 | 40.7887310058451 | 27B-PM-1006-02 | 27B | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | By large tree chasing #1 | false | true | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.965675791028 40.7887310058451) | 19 | 4 | 19 | 13 | |||||
1679 | 1679 | -73.9545399102352 | 40.7898646267709 | 33I-PM-1006-06 | 33I | PM | 10062018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9545399102352 40.7898646267709) | 19 | 4 | 19 | 13 | ||||||
1678 | 1678 | -73.9568726508546 | 40.7878795081255 | 30I-PM-1006-03 | 30I | PM | 10062018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | up tree | POINT (-73.9568726508546 40.7878795081255) | 19 | 4 | 19 | 13 | |||||
1674 | 1674 | -73.9589698681439 | 40.7906520520417 | 32E-PM-1017-06 | 32E | PM | 10172018 | 6 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9589698681439 40.7906520520417) | 19 | 4 | 19 | 13 | |||||
1665 | 1665 | -73.9583944353352 | 40.7979689846815 | 39B-PM-1014-04 | 39B | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | true | runs from (me—when i approached) | POINT (-73.9583944353352 40.7979689846815) | 19 | 4 | 19 | 13 | |||||
1658 | 1658 | -73.9736016229655 | 40.7723781376714 | 8D-AM-1007-03 | 08D | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.9736016229655 40.77237813767141) | 19 | 4 | 19 | 13 | |||||
1657 | 1657 | -73.9768254058709 | 40.7716757945251 | 6C-PM-1020-03 | 06C | PM | 10202018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9768254058709 40.7716757945251) | 19 | 4 | 19 | 13 | ||||||
1651 | 1651 | -73.9763373510536 | 40.7741168933928 | 9B-PM-1013-09 | 09B | PM | 10132018 | 9 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | false | true | runs from (people) | POINT (-73.9763373510536 40.7741168933928) | 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 | ||||||
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 | ||||||
1632 | 1632 | -73.9592392692535 | 40.7961869951798 | 37B-AM-1018-02 | 37B | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9592392692535 40.7961869951798) | 19 | 4 | 19 | 13 | ||||||
1626 | 1626 | -73.9617519095277 | 40.7947179071388 | 35A-PM-1013-04 | 35A | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | In the weeds by the pool | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9617519095277 40.7947179071388) | 19 | 4 | 19 | 13 | |||||
1594 | 1594 | -73.9778730762957 | 40.770827251547 | 5B-PM-1013-05 | 05B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9778730762957 40.770827251547) | 19 | 4 | 19 | 13 | ||||||
1553 | 1553 | -73.9690645326017 | 40.7773822116124 | 15E-AM-1013-03 | 15E | AM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | on fallen log | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9690645326017 40.7773822116124) | 19 | 4 | 19 | 13 | |||||
1524 | 1524 | -73.9725961508316 | 40.7795720444974 | 16A-PM-1019-06 | 16A | PM | 10192018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9725961508316 40.7795720444974) | 19 | 4 | 19 | 13 | ||||||
1507 | 1507 | -73.9699799501516 | 40.7736576286234 | 11F-AM-1013-02 | 11F | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9699799501516 40.7736576286234) | 19 | 4 | 19 | 13 | ||||||
1476 | 1476 | -73.976609486498 | 40.7717832922535 | 7C-PM-1020-04 | 07C | PM | 10202018 | 4 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.976609486498 40.7717832922535) | 19 | 4 | 19 | 13 | ||||||
1442 | 1442 | -73.961241953418 | 40.7941677113011 | 35B-PM-1013-07 | 35B | PM | 10132018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | true | false | got fed twice by grandpa,grabbed from grass and ate in tree | false | false | false | false | false | true | true | true | approaches (grandpa with food),runs from (kid),kid was slowly creeping up on it; it eventually climbed up. | POINT (-73.961241953418 40.7941677113011) | 19 | 4 | 19 | 13 | ||||
1434 | 1434 | -73.9760749752948 | 40.7703284894392 | 5D-PM-1018-02 | 05D | PM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 2 | On low fence | false | false | false | true | false | false | false | false | false | false | false | false | true | POINT (-73.9760749752948 40.7703284894392) | 19 | 4 | 19 | 13 | |||||
1426 | 1426 | -73.9664986446294 | 40.778308334318 | 17G-PM-1017-02 | 17G | PM | 10172018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9664986446294 40.778308334318) | 19 | 4 | 19 | 13 | ||||||
1398 | 1398 | -73.9602808042376 | 40.7906130788763 | 32E-AM-1007-14 | 32E | AM | 10072018 | 14 | Adult | Gray | Gray+ | Above Ground | 50 | literally fell to ground from 50 feet up | false | false | false | false | false | falling | false | false | false | false | false | false | false | true | POINT (-73.9602808042376 40.7906130788763) | 19 | 4 | 19 | 13 | ||||
1389 | 1389 | -73.9580021017892 | 40.7955140102242 | 37D-PM-1014-07 | 37D | PM | 10142018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9580021017892 40.7955140102242) | 19 | 4 | 19 | 13 | ||||||
1371 | 1371 | -73.9542733797804 | 40.795578653743 | 39F-PM-1006-02 | 39F | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | ran up tree when approached | POINT (-73.9542733797804 40.795578653743) | 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 | |||||
1348 | 1348 | -73.9599197612389 | 40.7954836456006 | 36B-PM-1013-05 | 36B | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 4 | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9599197612389 40.7954836456006) | 19 | 4 | 19 | 13 | ||||||
1314 | 1314 | -73.980919134781 | 40.7683772453336 | 1A-PM-1014-06 | 01A | PM | 10142018 | 6 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | true | false | false | false | false | false | false | true | POINT (-73.980919134781 40.7683772453336) | 19 | 4 | 19 | 13 | ||||||
1298 | 1298 | -73.9612900553755 | 40.7912917391867 | 32C-AM-1014-01 | 32C | AM | 10142018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9612900553755 40.7912917391867) | 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 | ||||||
1206 | 1206 | -73.9748709206354 | 40.77608025411 | 11B-PM-1014-01 | 11B | PM | 10142018 | 1 | Adult | Gray | Gray+ | Fat! | Above Ground | 10 | false | false | true | false | false | true | false | false | false | false | false | false | true | POINT (-73.9748709206354 40.77608025411) | 19 | 4 | 19 | 13 | |||||
1200 | 1200 | -73.9657721715305 | 40.778534830257 | 18G-PM-1013-03 | 18G | PM | 10132018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9657721715305 40.778534830257) | 19 | 4 | 19 | 13 | ||||||
1197 | 1197 | -73.9590868748584 | 40.7906047630418 | 32E-PM-1017-09 | 32E | PM | 10172018 | 9 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9590868748584 40.7906047630418) | 19 | 4 | 19 | 13 | |||||
1192 | 1192 | -73.9634811495245 | 40.790705585077 | 30B-AM-1007-10 | 30B | AM | 10072018 | 10 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.9634811495245 40.790705585077) | 19 | 4 | 19 | 13 | ||||||
1173 | 1173 | -73.959070754026 | 40.7906675143413 | 32E-PM-1017-07 | 32E | PM | 10172018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | treed area | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.959070754026 40.7906675143413) | 19 | 4 | 19 | 13 | |||||
1162 | 1162 | -73.9568544270881 | 40.7972517274475 | 39D-AM-1008-06 | 39D | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 3 | on rock | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9568544270881 40.7972517274475) | 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 );