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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
643 | 643 | -73.976730206737 | 40.773709213914 | 8A-PM-1014-01 | 08A | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | true | true | false | true | false | false | false | false | false | false | true | runs from (goes up a tree) | POINT (-73.976730206737 40.773709213914) | 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 | |||||
2259 | 2259 | -73.975565603566 | 40.7738462518304 | 9B-AM-1010-03 | 09B | AM | 10102018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | true | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.975565603566 40.7738462518304) | 19 | 4 | 19 | 13 | |||||
2744 | 2744 | -73.9752915601718 | 40.7739329570033 | 9B-AM-1010-04 | 09B | AM | 10102018 | 4 | + | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9752915601718 40.7739329570033) | 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 | ||||||
2396 | 2396 | -73.9704339422613 | 40.7740149529644 | 11F-PM-1006-03 | 11F | PM | 10062018 | 3 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9704339422613 40.7740149529644) | 19 | 4 | 19 | 13 | ||||||
2144 | 2144 | -73.975198284551 | 40.7740343763399 | 9B-AM-1010-06 | 09B | AM | 10102018 | 6 | Juvenile | Gray | White | Gray+White | Above Ground | 16 | tree | false | false | true | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.975198284551 40.7740343763399) | 19 | 4 | 19 | 13 | |||
1116 | 1116 | -73.9729847109778 | 40.7740709049602 | 10D-AM-1008-03 | 10D | AM | 10082018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9729847109778 40.7740709049602) | 19 | 4 | 19 | 13 | |||||
1790 | 1790 | -73.9730592548116 | 40.7740879251541 | 10D-AM-1008-04 | 10D | AM | 10082018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 25 | false | true | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730592548116 40.7740879251541) | 19 | 4 | 19 | 13 | ||||||
792 | 792 | -73.9730115687964 | 40.7741018274312 | 10D-AM-1008-05 | 10D | AM | 10082018 | 5 | Juvenile | Gray | White | Gray+White | Above Ground | 25 | false | false | true | true | false | false | false | false | false | false | false | false | false | POINT (-73.9730115687964 40.7741018274312) | 19 | 4 | 19 | 13 | |||||
256 | 256 | -73.976798124308 | 40.7741316574113 | 9A-PM-1010-04 | 09A | PM | 10102018 | 4 | Cinnamon | Cinnamon+ | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.97679812430802 40.7741316574113) | 19 | 4 | 19 | 13 | |||||||
1402 | 1402 | -73.9745009906157 | 40.7741574075364 | 10C-AM-1018-01 | 10C | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9745009906157 40.7741574075364) | 19 | 4 | 19 | 13 | ||||||
462 | 462 | -73.9661785940531 | 40.7742569936186 | 13I-PM-1008-01 | 13I | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | climbed tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9661785940531 40.7742569936186) | 19 | 4 | 19 | 13 | ||||
505 | 505 | -73.9677387336667 | 40.7742695912 | 12H-PM-1007-02 | 12H | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | true | true | false | peanuts | false | false | false | false | false | false | true | false | POINT (-73.9677387336667 40.7742695912) | 19 | 4 | 19 | 13 | |||
788 | 788 | -73.9687476703117 | 40.7742856696093 | 12G-AM-1012-01 | 12G | AM | 10122018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9687476703117 40.7742856696093) | 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 | ||||||
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 | ||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699124811406 40.7743016981538) | 19 | 4 | 19 | 13 | |||||
768 | 768 | -73.9729394928432 | 40.7743256716496 | 11D-AM-1010-01 | 11D | AM | 10102018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | false | true | POINT (-73.9729394928432 40.7743256716496) | 19 | 4 | 19 | 13 | |||||
169 | 169 | -73.9748706415584 | 40.7744174965072 | 10B-AM-1006-02 | 10B | AM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | High in a tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9748706415584 40.7744174965072) | 19 | 4 | 19 | 13 | |||||
2187 | 2187 | -73.9699134052609 | 40.774446589038 | 12F-PM-1007-14 | 12F | PM | 10072018 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | true | true | false | POINT (-73.9699134052609 40.774446589038) | 19 | 4 | 19 | 13 | |||||
690 | 690 | -73.9767949141123 | 40.774454583585 | 9A-PM-1010-01 | 09A | PM | 10102018 | 1 | Adult | + | Ground Plane | FALSE | by large tree in sectioned off area | false | false | true | false | false | i think it climbed the tree when i first saw it. | false | false | false | false | false | false | true | false | POINT (-73.9767949141123 40.774454583585) | 19 | 4 | 19 | 13 | |||||
695 | 695 | -73.9685080639873 | 40.7745309794155 | 13G-PM-1008-03 | 13G | PM | 10082018 | 3 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | maple tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9685080639873 40.77453097941551) | 19 | 4 | 19 | 13 | ||||
1067 | 1067 | -73.9695305996721 | 40.7745386896959 | 12F-PM-1007-02 | 12F | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695305996721 40.7745386896959) | 19 | 4 | 19 | 13 | |||||
2323 | 2323 | -73.9715921982161 | 40.7746153066601 | 11E-PM-1012-06 | 11E | PM | 10122018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 5 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9715921982161 40.7746153066601) | 19 | 4 | 19 | 13 | ||||
1354 | 1354 | -73.9765269282059 | 40.7746876635248 | 9A-AM-1013-10 | 09A | AM | 10132018 | 10 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9765269282059 40.7746876635248) | 19 | 4 | 19 | 13 | |||||
1874 | 1874 | -73.9657327332849 | 40.7747554568985 | 14I-PM-1018-03 | 14I | PM | 10182018 | 3 | Juvenile | Gray | Black | Gray+Black | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9657327332849 40.7747554568985) | 19 | 4 | 19 | 13 | |||||
2224 | 2224 | -73.9662310606968 | 40.7747758221226 | 14I-AM-1013-01 | 14I | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9662310606968 40.7747758221226) | 19 | 4 | 19 | 13 | |||||
1503 | 1503 | -73.9732193290631 | 40.7748791447746 | 11D-PM-1006-01 | 11D | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9732193290631 40.7748791447746) | 19 | 4 | 19 | 13 | |||||
2368 | 2368 | -73.9731925179247 | 40.7748962746181 | 11D-PM-1006-02 | 11D | PM | 10062018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9731925179247 40.7748962746181) | 19 | 4 | 19 | 13 | |||||
1484 | 1484 | -73.9716736557408 | 40.7749333494336 | 12E-AM-1017-07 | 12E | AM | 10172018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9716736557408 40.7749333494336) | 19 | 4 | 19 | 13 | |||||
2747 | 2747 | -73.971314838366 | 40.774951285041 | 12E-AM-1017-03 | 12E | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 8 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.971314838366 40.774951285041) | 19 | 4 | 19 | 13 | |||||
1543 | 1543 | -73.9713906492842 | 40.7750061310143 | 12E-PM-1018-03 | 12E | PM | 10182018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9713906492842 40.7750061310143) | 19 | 4 | 19 | 13 | ||||||
1935 | 1935 | -73.9675268877392 | 40.7750409681718 | 13H-AM-1013-01 | 13H | AM | 10132018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9675268877392 40.7750409681718) | 19 | 4 | 19 | 13 | |||||
2794 | 2794 | -73.9712187890707 | 40.7750640173134 | 12E-PM-1018-01 | 12E | PM | 10182018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | true | false | false | true | false | false | true | false | false | false | true | POINT (-73.9712187890707 40.7750640173134) | 19 | 4 | 19 | 13 | |||||
509 | 509 | -73.9714289592392 | 40.7750670702093 | 12E-PM-1018-04 | 12E | PM | 10182018 | 4 | Adult | Cinnamon | Cinnamon+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9714289592392 40.7750670702093) | 19 | 4 | 19 | 13 | ||||||
1086 | 1086 | -73.9713399316534 | 40.7750678026757 | 12E-PM-1018-02 | 12E | PM | 10182018 | 2 | Adult | Black | Cinnamon, White | Black+Cinnamon, White | Black & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Above Ground | 3 | false | false | true | false | false | lounging on tree upside down | false | false | false | false | true | false | true | false | POINT (-73.9713399316534 40.7750678026757) | 19 | 4 | 19 | 13 | |||
339 | 339 | -73.965509576403 | 40.7752456763263 | 14I-PM-1018-05 | 14I | PM | 10182018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 2 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.96550957640301 40.7752456763263) | 19 | 4 | 19 | 13 | |||||
865 | 865 | -73.9741621946917 | 40.7752481472025 | 11C-PM-1018-01 | 11C | PM | 10182018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9741621946917 40.7752481472025) | 19 | 4 | 19 | 13 | |||||
2586 | 2586 | -73.9752965316933 | 40.7752538575789 | 10B-AM-1006-03 | 10B | AM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | In tree | false | false | true | false | false | false | false | false | false | true | true | false | false | POINT (-73.9752965316933 40.7752538575789) | 19 | 4 | 19 | 13 | |||||
620 | 620 | -73.9655905300923 | 40.7752614638023 | 14I-PM-1018-06 | 14I | PM | 10182018 | 6 | Adult | Cinnamon | Black | Cinnamon+Black | Above Ground | 2 | true | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9655905300923 40.7752614638023) | 19 | 4 | 19 | 13 | |||||
2054 | 2054 | -73.9726381234747 | 40.7752694815985 | 12D-PM-1014-01 | 12D | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9726381234747 40.7752694815985) | 19 | 4 | 19 | 13 | |||||
359 | 359 | -73.9716404781264 | 40.7753181851766 | 12D-PM-1014-02 | 12D | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | false | false | seems to be grinding teeth on a piece of material (sounds from grinding) | false | false | false | false | false | false | true | false | POINT (-73.9716404781264 40.7753181851766) | 19 | 4 | 19 | 13 | ||||
1904 | 1904 | -73.9684058476942 | 40.7753959833776 | 13G-PM-1008-02 | 13G | PM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 15 | willow oak tree | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9684058476942 40.7753959833776) | 19 | 4 | 19 | 13 | |||||
197 | 197 | -73.9679336341793 | 40.7754186579647 | 14G-PM-1013-01 | 14G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | watching | POINT (-73.9679336341793 40.7754186579647) | 19 | 4 | 19 | 13 | ||||
112 | 112 | -73.9651754464439 | 40.7755181941559 | 15I-AM-1008-01 | 15I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9651754464439 40.7755181941559) | 19 | 4 | 19 | 13 | ||||
1010 | 1010 | -73.9689723590015 | 40.7756860990338 | 13F-AM-1007-01 | 13F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9689723590015 40.7756860990338) | 19 | 4 | 19 | 13 | |||||
696 | 696 | -73.9656098194149 | 40.7757643078973 | 15I-AM-1008-05 | 15I | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9656098194149 40.7757643078973) | 19 | 4 | 19 | 13 | ||||||
776 | 776 | -73.9686816795392 | 40.775770422667 | 14F-PM-1012-02 | 14F | PM | 10122018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9686816795392 40.775770422667) | 19 | 4 | 19 | 13 | |||||
657 | 657 | -73.9679008849677 | 40.7759013923034 | 14G-AM-1012-02 | 14G | AM | 10122018 | 2 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9679008849677 40.7759013923034) | 19 | 4 | 19 | 13 | ||||||
511 | 511 | -73.9653142636891 | 40.7760015129298 | 15I-AM-1008-04 | 15I | AM | 10082018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9653142636891 40.7760015129298) | 19 | 4 | 19 | 13 | ||||||
890 | 890 | -73.9667755678511 | 40.7760256836088 | 15H-PM-1008-02 | 15H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 10 | oak tree | false | true | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9667755678511 40.7760256836088) | 19 | 4 | 19 | 13 | |||||
2822 | 2822 | -73.9711120079542 | 40.7760801911766 | 13D-PM-1018-14 | 13D | PM | 10182018 | 14 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | true | false | false | climbing (down) | false | false | false | false | false | false | true | false | POINT (-73.9711120079542 40.7760801911766) | 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 | |||||
1395 | 1395 | -73.9710801547498 | 40.7760872452093 | 13D-AM-1014-03 | 13D | AM | 10142018 | 3 | Juvenile | Gray | White | Gray+White | Above Ground | 2 | false | true | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9710801547498 40.7760872452093) | 19 | 4 | 19 | 13 | |||||
1962 | 1962 | -73.9647318357023 | 40.7760936175332 | 15I-PM-1012-04 | 15I | PM | 10122018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9647318357023 40.7760936175332) | 19 | 4 | 19 | 13 | ||||||
1747 | 1747 | -73.9665763797607 | 40.7761316400012 | 15H-AM-1013-03 | 15H | AM | 10132018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9665763797607 40.7761316400012) | 19 | 4 | 19 | 13 | |||||
414 | 414 | -73.9721899838568 | 40.7761519045651 | 13C-AM-1010-03 | 13C | AM | 10102018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721899838568 40.7761519045651) | 19 | 4 | 19 | 13 | ||||||
1044 | 1044 | -73.9693254080548 | 40.7761600327118 | 14F-AM-1007-01 | 14F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9693254080548 40.7761600327118) | 19 | 4 | 19 | 13 | |||||
1338 | 1338 | -73.9716624574422 | 40.7762037110101 | 13D-PM-1018-07 | 13D | PM | 10182018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | true | false | true | false | false | scratching | false | false | false | false | false | false | true | false | POINT (-73.9716624574422 40.7762037110101) | 19 | 4 | 19 | 13 | ||||
2474 | 2474 | -73.9721448879766 | 40.7762112840981 | 13C-AM-1010-02 | 13C | AM | 10102018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 7 | false | false | true | false | false | burying | false | false | false | false | false | false | true | false | POINT (-73.9721448879766 40.7762112840981) | 19 | 4 | 19 | 13 | ||||
1787 | 1787 | -73.9720365327715 | 40.7762329714016 | 13D-PM-1018-11 | 13D | PM | 10182018 | 11 | Adult | Gray | White | Gray+White | Above Ground | 15 | false | false | true | true | false | false | false | false | false | true | false | true | false | POINT (-73.9720365327715 40.7762329714016) | 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 | ||||||
833 | 833 | -73.9741846413977 | 40.7762518164182 | 12B-PM-1018-01 | 12B | PM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Climbing up rocks | false | false | true | false | true | climbing (up rocks) | false | false | false | false | false | false | false | true | POINT (-73.9741846413977 40.7762518164182) | 19 | 4 | 19 | 13 | ||||
286 | 286 | -73.9720907384613 | 40.7762987836055 | 13C-PM-1019-01 | 13C | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 7 | false | false | true | false | false | true | false | false | false | false | false | true | false | POINT (-73.9720907384613 40.7762987836055) | 19 | 4 | 19 | 13 | ||||||
1487 | 1487 | -73.965394655961 | 40.7763136791661 | 15I-PM-1012-05 | 15I | PM | 10122018 | 5 | Adult | Gray | Gray+ | Above Ground | 2 | true | false | true | false | true | burying the food on ground | false | false | false | false | false | false | false | false | look at us and continue hiding the food | POINT (-73.965394655961 40.7763136791661) | 19 | 4 | 19 | 13 | ||||
2516 | 2516 | -73.9649823687651 | 40.7763395359636 | 16I-AM-1008-02 | 16I | AM | 10082018 | 2 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9649823687651 40.7763395359636) | 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 | |||||
1133 | 1133 | -73.9712550584322 | 40.7764273475386 | 13D-PM-1018-06 | 13D | PM | 10182018 | 6 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | true | false | false | cleaning | false | false | false | false | false | false | true | false | POINT (-73.9712550584322 40.7764273475386) | 19 | 4 | 19 | 13 | ||||
1566 | 1566 | -73.9695133370801 | 40.7765009796853 | 14E-AM-1008-16 | 14E | AM | 10082018 | 16 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695133370801 40.7765009796853) | 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 | |||||
366 | 366 | -73.9673548527075 | 40.7765669058396 | 15G-PM-1019-11 | 15G | PM | 10192018 | 11 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673548527075 40.7765669058396) | 19 | 4 | 19 | 13 | |||||
2813 | 2813 | -73.9659118189359 | 40.7765739928504 | 15H-AM-1013-02 | 15H | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9659118189359 40.7765739928504) | 19 | 4 | 19 | 13 | ||||||
555 | 555 | -73.9685227310735 | 40.776599466588 | 15F-AM-1007-02 | 15F | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9685227310735 40.776599466588) | 19 | 4 | 19 | 13 | ||||
85 | 85 | -73.9676410497481 | 40.7766043512974 | 15G-PM-1019-05 | 15G | PM | 10192018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9676410497481 40.7766043512974) | 19 | 4 | 19 | 13 | |||||
981 | 981 | -73.9673160165357 | 40.7766158001202 | 15G-PM-1019-12 | 15G | PM | 10192018 | 12 | Adult | Gray | Gray+ | Above Ground | 4 | false | false | true | false | false | false | false | false | false | false | false | false | false | stared | POINT (-73.9673160165357 40.7766158001202) | 19 | 4 | 19 | 13 | |||||
1696 | 1696 | -73.9694591667705 | 40.7766518221998 | 14E-AM-1008-12 | 14E | AM | 10082018 | 12 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694591667705 40.7766518221998) | 19 | 4 | 19 | 13 | ||||||
2122 | 2122 | -73.9692946938852 | 40.7767389791452 | 14E-AM-1008-13 | 14E | AM | 10082018 | 13 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | true | true | false | false | false | false | false | false | true | false | curious | POINT (-73.9692946938852 40.7767389791452) | 19 | 4 | 19 | 13 | |||||
1723 | 1723 | -73.9747959143543 | 40.7768078174366 | 12A-AM-1008-01 | 12A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 1 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9747959143543 40.7768078174366) | 19 | 4 | 19 | 13 | ||||||
1984 | 1984 | -73.9739249209875 | 40.7768528386853 | 13B-PM-1008-02 | 13B | PM | 10082018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9739249209875 40.7768528386853) | 19 | 4 | 19 | 13 | |||||
2095 | 2095 | -73.9747762992858 | 40.7768579078578 | 12A-AM-1008-02 | 12A | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9747762992858 40.7768579078578) | 19 | 4 | 19 | 13 | ||||||
268 | 268 | -73.968107276769 | 40.7768612676036 | 15F-AM-1007-09 | 15F | AM | 10072018 | 9 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | false | true | POINT (-73.968107276769 40.7768612676036) | 19 | 4 | 19 | 13 | |||||
531 | 531 | -73.9709104380323 | 40.7769096957616 | 14D-AM-1014-16 | 14D | AM | 10142018 | 16 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9709104380323 40.7769096957616) | 19 | 4 | 19 | 13 | |||||
1081 | 1081 | -73.9680855277775 | 40.7769251965381 | 15F-AM-1007-10 | 15F | AM | 10072018 | 10 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9680855277775 40.7769251965381) | 19 | 4 | 19 | 13 | |||||
3013 | 3013 | -73.964661337306 | 40.7769785494935 | 17I-AM-1014-03 | 17I | AM | 10142018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Cinnamon face | Above Ground | 10 | false | false | true | false | false | climbing (dog barked & it ran up tree) | false | false | false | false | false | false | true | false | POINT (-73.964661337306 40.7769785494935) | 19 | 4 | 19 | 13 | |||
139 | 139 | -73.969847380865 | 40.7769884612305 | 14E-AM-1008-05 | 14E | AM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 25 | false | false | true | false | false | nest building | false | false | false | false | false | false | true | false | POINT (-73.969847380865 40.7769884612305) | 19 | 4 | 19 | 13 | |||||
797 | 797 | -73.969345754447 | 40.7770429650288 | 15E-AM-1013-02 | 15E | AM | 10132018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | true | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.969345754447 40.7770429650288) | 19 | 4 | 19 | 13 | |||||
168 | 168 | -73.9745691353018 | 40.7771035589298 | 13A-PM-1014-03 | 13A | PM | 10142018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | true | false | false | false | false | false | false | false | false | false | true | child chasing | POINT (-73.9745691353018 40.7771035589298) | 19 | 4 | 19 | 13 | ||||
835 | 835 | -73.9707900566519 | 40.7771670550089 | 14D-AM-1014-09 | 14D | AM | 10142018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9707900566519 40.7771670550089) | 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 | ||||
2157 | 2157 | -73.9657171357842 | 40.7773277532224 | 16H-PM-1014-05 | 16H | PM | 10142018 | 5 | Adult | Gray | White | Gray+White | Above Ground | 5 | tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.9657171357842 40.7773277532224) | 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 | ||||||
1564 | 1564 | -73.9703816112358 | 40.7773846065919 | 15D-PM-1017-02 | 15D | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 1 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703816112358 40.7773846065919) | 19 | 4 | 19 | 13 | |||||
2198 | 2198 | -73.9709738166531 | 40.7774102689734 | 14D-PM-1019-08 | 14D | PM | 10192018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9709738166531 40.7774102689734) | 19 | 4 | 19 | 13 | ||||||
844 | 844 | -73.9642379942652 | 40.7774792520738 | 17I-PM-1017-01 | 17I | PM | 10172018 | 1 | Juvenile | Cinnamon | White | Cinnamon+White | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | was in a tree,so i couldn't really tell | POINT (-73.9642379942652 40.7774792520738) | 19 | 4 | 19 | 13 | ||||
1739 | 1739 | -73.9639700434449 | 40.7775003050028 | 17I-AM-1014-01 | 17I | AM | 10142018 | 1 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | Running across fence between statue & swings | true | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9639700434449 40.7775003050028) | 19 | 4 | 19 | 13 | ||||
2404 | 2404 | -73.9665309689616 | 40.7775271020244 | 16G-AM-1010-04 | 16G | AM | 10102018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9665309689616 40.7775271020244) | 19 | 4 | 19 | 13 | |||||
2722 | 2722 | -73.9692271132136 | 40.777528508844 | 15E-PM-1008-04 | 15E | PM | 10082018 | 4 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9692271132136 40.777528508844) | 19 | 4 | 19 | 13 | ||||||
2463 | 2463 | -73.9653343572865 | 40.7775286924617 | 17H-PM-1007-01 | 17H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | false | false | true | true | false | false | false | false | true | false | false | false | true | POINT (-73.9653343572865 40.7775286924617) | 19 | 4 | 19 | 13 | |||||
764 | 764 | -73.9746608786299 | 40.7776092078254 | 13A-AM-1017-01 | 13A | AM | 10172018 | 1 | Adult | Gray | Gray+ | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9746608786299 40.7776092078254) | 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 );