This data as json, CSV (advanced)
Suggested facets: Shift, Date, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Above Ground Sighter Measurement, Specific Location, Running, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Moans, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5 | 5 | -73.9593126695714 | 40.797533370163 | 39B-AM-1018-01 | 39B | AM | 10182018 | 1 | + | Above Ground | false | false | false | false | false | unknown | true | false | false | false | false | false | false | false | POINT (-73.9593126695714 40.797533370163) | 19 | 4 | 19 | 13 | ||||||||
198 | 198 | -73.9761107065353 | 40.769642060286 | 5D-AM-1020-01 | 05D | AM | 10202018 | 1 | Adult | + | Too far & cloudy to tell | Above Ground | 30 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9761107065353 40.769642060286) | 19 | 4 | 19 | 13 | ||||||
512 | 512 | -73.9586098170241 | 40.7939653733898 | 35D-AM-1019-01 | 35D | AM | 10192018 | 1 | + | Above Ground | on tree, blue jays gathering nearby | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9586098170241 40.7939653733898) | 19 | 4 | 19 | 13 | ||||||||
2327 | 2327 | -73.9567801028221 | 40.7960096659564 | 38D-AM-1017-01 | 38D | AM | 10172018 | 1 | + | Above Ground | 30 | false | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9567801028221 40.7960096659564) | 19 | 4 | 19 | 13 | ||||||||
210 | 210 | -73.9711298491132 | 40.7676902603543 | 5I-PM-1008-01 | 05I | PM | 10082018 | 1 | Adult | Black | Cinnamon | Black+Cinnamon | Above Ground | 15 | in tree by arsenal - climbing | false | false | true | true | false | false | false | false | true | false | false | false | false | POINT (-73.9711298491132 40.7676902603543) | 19 | 4 | 19 | 13 | ||||
1138 | 1138 | -73.9594357049738 | 40.7840678890949 | 25I-AM-1012-01 | 25I | AM | 10122018 | 1 | Adult | Cinnamon | Cinnamon+ | Above Ground | 4 | on bar | false | false | false | true | false | false | false | false | true | true | true | false | false | POINT (-73.9594357049738 40.7840678890949) | 19 | 4 | 19 | 13 | |||||
534 | 534 | -73.9650499507011 | 40.7908191782173 | 30A-AM-1010-01 | 30A | AM | 10102018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | true | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9650499507011 40.7908191782173) | 19 | 4 | 19 | 13 | |||||
789 | 789 | -73.9675023138703 | 40.7872554700995 | 25A-PM-1007-01 | 25A | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 40 | tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9675023138703 40.7872554700995) | 19 | 4 | 19 | 13 | ||||
1135 | 1135 | -73.9667474482967 | 40.7760643720793 | 15H-PM-1008-01 | 15H | PM | 10082018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Oak tree | false | true | false | false | false | watching me | false | true | false | true | false | false | false | false | observant | POINT (-73.9667474482967 40.7760643720793) | 19 | 4 | 19 | 13 | ||
1560 | 1560 | -73.9587072763996 | 40.7850256219415 | 27I-AM-1007-01 | 27I | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 20 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9587072763996 40.7850256219415) | 19 | 4 | 19 | 13 | |||||
1939 | 1939 | -73.9540151828782 | 40.7920066170587 | 35H-AM-1013-01 | 35H | AM | 10132018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 15 | Climbing up tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9540151828782 40.7920066170587) | 19 | 4 | 19 | 13 | ||||
2244 | 2244 | -73.9509628195532 | 40.7977775674178 | 42H-PM-1014-01 | 42H | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 2 | false | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9509628195532 40.7977775674178) | 12423 | 18 | 4 | 36 | 18 | ||||
2583 | 2583 | -73.9769693140651 | 40.7684390015166 | 3D-AM-1006-01 | 03D | AM | 10062018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 9 | up a tree | true | false | true | true | true | digging (?) | false | false | false | true | false | false | false | true | runs from (man led his dog into the area to chase squirrel) | POINT (-73.9769693140651 40.7684390015166) | 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 | ||||
2005 | 2005 | -73.9755259087781 | 40.7707256124181 | 6D-AM-1008-01 | 06D | AM | 10082018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 10 | false | false | true | true | false | true | false | false | false | false | true | false | false | POINT (-73.9755259087781 40.7707256124181) | 19 | 4 | 19 | 13 | |||||
2114 | 2114 | -73.9651541395415 | 40.7798283208748 | 19G-PM-1017-01 | 19G | PM | 10172018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 12 | false | false | false | false | false | watching | false | false | false | false | false | true | false | false | POINT (-73.9651541395415 40.7798283208748) | 19 | 4 | 19 | 13 | ||||
2387 | 2387 | -73.9808517324721 | 40.7683154647217 | 1A-PM-1014-01 | 01A | PM | 10142018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 6 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9808517324721 40.7683154647217) | 19 | 4 | 19 | 13 | |||||
2550 | 2550 | -73.9694805745522 | 40.7743556902843 | 12F-AM-1020-01 | 12F | AM | 10202018 | 1 | Adult | Cinnamon | White | Cinnamon+White | Above Ground | 17 | Tree | false | false | false | false | false | jumping | false | false | false | false | false | false | false | false | POINT (-73.9694805745522 40.7743556902843) | 19 | 4 | 19 | 13 | |||
39 | 39 | -73.9716147061553 | 40.7813911036179 | 18A-PM-1018-01 | 18A | PM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9716147061553 40.7813911036179) | 19 | 4 | 19 | 13 | ||||||
91 | 91 | -73.9565905868276 | 40.7895654068546 | 32H-PM-1006-01 | 32H | PM | 10062018 | 1 | Gray | Gray+ | Above Ground | in the European Beech | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9565905868276 40.7895654068546) | 19 | 4 | 19 | 13 | |||||||
109 | 109 | -73.967097592707 | 40.7854119342538 | 24B-AM-1013-01 | 24B | AM | 10132018 | 1 | Gray | Gray+ | Above Ground | 50 | true | false | false | true | false | took nut to bury | false | false | false | false | true | false | false | true | POINT (-73.967097592707 40.7854119342538) | 19 | 4 | 19 | 13 | ||||||
317 | 317 | -73.9545799024508 | 40.7908084039886 | 34I-PM-1010-01 | 34I | PM | 10102018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9545799024508 40.7908084039886) | 19 | 4 | 19 | 13 | ||||||
387 | 387 | -73.9578316525492 | 40.7890102959629 | 31G-PM-1007-01 | 31G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | hiding | false | false | false | false | true | false | false | false | froze,sight of dogs | POINT (-73.9578316525492 40.7890102959629) | 19 | 4 | 19 | 13 | ||||
566 | 566 | -73.9708364583591 | 40.7723691587433 | 10F-AM-1007-01 | 10F | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 60 | false | false | true | false | false | false | false | false | true | false | false | false | false | POINT (-73.9708364583591 40.7723691587433) | 19 | 4 | 19 | 13 | ||||||
906 | 906 | -73.9664120826015 | 40.7888022709721 | 27A-AM-1008-01 | 27A | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.96641208260151 40.7888022709721) | 19 | 4 | 19 | 13 | ||||||
951 | 951 | -73.971791854883 | 40.7802971729784 | 17B-PM-1012-01 | 17B | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | climbed a fence | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.971791854883 40.7802971729784) | 19 | 4 | 19 | 13 | |||||
1071 | 1071 | -73.9703774000082 | 40.7717607551555 | 9G-AM-1007-01 | 09G | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 50 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9703774000082 40.7717607551555) | 19 | 4 | 19 | 13 | ||||||
1144 | 1144 | -73.9743184653765 | 40.7667932997 | 3G-AM-1008-01 | 03G | AM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9743184653765 40.7667932997) | 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 | |||||
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 | |||||
1641 | 1641 | -73.9653135277149 | 40.7817434070169 | 21E-PM-1012-01 | 21E | PM | 10122018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | in tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9653135277149 40.7817434070169) | 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 | ||||||
1837 | 1837 | -73.9710288101006 | 40.7715777109992 | 9G-PM-1007-01 | 09G | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | false | climbing (down tree) | false | false | false | false | false | false | false | false | POINT (-73.9710288101006 40.7715777109992) | 19 | 4 | 19 | 13 | |||||
1864 | 1864 | -73.9694344956258 | 40.7742869276902 | 12G-PM-1007-01 | 12G | PM | 10072018 | 1 | Gray | Gray+ | Above Ground | 40 | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9694344956258 40.7742869276902) | 19 | 4 | 19 | 13 | ||||||
1867 | 1867 | -73.9745204169071 | 40.7736282868469 | 9C-AM-1006-01 | 09C | AM | 10062018 | 1 | Adult | Gray | Gray+ | Above Ground | 40 | Tree | true | false | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9745204169071 40.7736282868469) | 19 | 4 | 19 | 13 | |||||
1974 | 1974 | -73.9772420734509 | 40.7730025191407 | 7A-PM-1007-01 | 07A | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9772420734509 40.7730025191407) | 19 | 4 | 19 | 13 | ||||||
2003 | 2003 | -73.9640526358598 | 40.7907411574825 | 30B-AM-1007-01 | 30B | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9640526358598 40.7907411574825) | 19 | 4 | 19 | 13 | ||||||
2417 | 2417 | -73.9720323148189 | 40.7729703459618 | 10E-PM-1007-01 | 10E | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9720323148189 40.7729703459618) | 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 | ||||
2443 | 2443 | -73.9667073186959 | 40.7840581361598 | 23C-PM-1014-01 | 23C | PM | 10142018 | 1 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.96670731869591 40.7840581361598) | 19 | 4 | 19 | 13 | ||||||
2561 | 2561 | -73.9591513028486 | 40.7835978067328 | 25I-PM-1007-01 | 25I | PM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9591513028486 40.7835978067328) | 19 | 4 | 19 | 13 | ||||||
2629 | 2629 | -73.9604576237503 | 40.7818120101394 | 23I-PM-1019-01 | 23I | PM | 10192018 | 1 | Adult | Gray | Gray+ | Above Ground | 35 | true | false | false | false | false | running (across branches) | false | false | false | false | false | false | false | false | POINT (-73.9604576237503 40.7818120101394) | 19 | 4 | 19 | 13 | |||||
2942 | 2942 | -73.9672063784809 | 40.7826070395665 | 21D-PM-1008-01 | 21D | PM | 10082018 | 1 | Gray | Gray+ | Above Ground | 8 | false | false | true | false | false | false | false | false | false | false | true | false | false | POINT (-73.9672063784809 40.7826070395665) | 19 | 4 | 19 | 13 | |||||||
1512 | 1512 | -73.9733882364574 | 40.7683078706597 | 5G-AM-1006-01 | 05G | AM | 10062018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | false | false | made eye contact with me | POINT (-73.9733882364574 40.7683078706597) | 19 | 4 | 19 | 13 | ||||
1653 | 1653 | -73.9695881075086 | 40.7842441291991 | 21A-AM-1019-01 | 21A | AM | 10192018 | 1 | Juvenile | Gray | Black | Gray+Black | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | keeps to tree,drops down on side away from people | POINT (-73.9695881075086 40.7842441291991) | 19 | 4 | 19 | 13 | ||||
2130 | 2130 | -73.9695572903383 | 40.780822981713 | 18C-AM-1018-01 | 18C | AM | 10182018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 30 | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9695572903383 40.780822981713) | 19 | 4 | 19 | 13 | |||||
2609 | 2609 | -73.9596865318094 | 40.7893787188526 | 31F-AM-1013-01 | 31F | AM | 10132018 | 1 | Adult | Gray | Black | Gray+Black | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596865318094 40.7893787188526) | 19 | 4 | 19 | 13 | |||||
113 | 113 | -73.9700100617602 | 40.7815739959357 | 19B-PM-1018-01 | 19B | PM | 10182018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 20 | true | false | false | false | false | flying | false | false | false | false | false | false | false | false | POINT (-73.9700100617602 40.7815739959357) | 19 | 4 | 19 | 13 | ||||
2874 | 2874 | -73.9597453664295 | 40.7891382153733 | 30F-PM-1007-01 | 30F | PM | 10072018 | 1 | Adult | Gray | Black, Cinnamon, White | Gray+Black, Cinnamon, White | Above Ground | 1 | tree | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9597453664295 40.7891382153733) | 19 | 4 | 19 | 13 | ||||
401 | 401 | -73.965862100991 | 40.7825926896917 | 22D-PM-1012-01 | 22D | PM | 10122018 | 1 | Adult | Gray | Black, White | Gray+Black, White | Above Ground | 5 | false | false | true | false | false | true | false | false | false | false | false | false | false | climbing tree | POINT (-73.965862100991 40.7825926896917) | 19 | 4 | 19 | 13 | ||||
135 | 135 | -73.9694168118643 | 40.7728877377977 | 11G-PM-1013-01 | 11G | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | In the Woods/Brush | false | false | true | false | true | false | false | false | false | false | false | false | true | watching me | POINT (-73.9694168118643 40.7728877377977) | 19 | 4 | 19 | 13 | |||
144 | 144 | -73.9730750601212 | 40.7701304211944 | 6F-PM-1008-01 | 06F | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9730750601212 40.7701304211944) | 19 | 4 | 19 | 13 | |||||
271 | 271 | -73.9661262885099 | 40.7844085550945 | 23D-AM-1013-01 | 23D | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | true | false | false | approaches (he saw me,came towards,then darted up) | POINT (-73.9661262885099 40.7844085550945) | 19 | 4 | 19 | 13 | ||||
291 | 291 | -73.9679661308374 | 40.7837388390673 | 22C-AM-1013-01 | 22C | AM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | false | false | false | sitting still,tail over back | false | false | false | false | false | false | false | false | POINT (-73.9679661308374 40.7837388390673) | 19 | 4 | 19 | 13 | ||||
433 | 433 | -73.9558474701153 | 40.7913335515534 | 34H-AM-1007-01 | 34H | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | tree | false | false | false | false | false | true | true | false | false | false | false | false | false | POINT (-73.9558474701153 40.7913335515534) | 19 | 4 | 19 | 13 | ||||
528 | 528 | -73.9647284206644 | 40.7839611840884 | 23E-PM-1006-01 | 23E | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | on a tree | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9647284206644 40.7839611840884) | 19 | 4 | 19 | 13 | |||||
641 | 641 | -73.9719036217446 | 40.7803588122409 | 17A-AM-1017-01 | 17A | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 3 | ground & tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719036217446 40.7803588122409) | 19 | 4 | 19 | 13 | ||||
930 | 930 | -73.9622030085794 | 40.7917723228749 | 32B-AM-1017-01 | 32B | AM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | ran up a tree | true | false | false | false | true | false | false | false | false | false | false | false | true | POINT (-73.9622030085794 40.7917723228749) | 19 | 4 | 19 | 13 | ||||
984 | 984 | -73.9672950266018 | 40.7782477517567 | 17F-PM-1020-01 | 17F | PM | 10202018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9672950266018 40.7782477517567) | 19 | 4 | 19 | 13 | |||||
1045 | 1045 | -73.9730420696993 | 40.7786151019726 | 15B-AM-1014-01 | 15B | AM | 10142018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | false | false | POINT (-73.9730420696993 40.7786151019726) | 19 | 4 | 19 | 13 | |||||
1055 | 1055 | -73.9632337134707 | 40.7914682370734 | 31B-PM-1007-01 | 31B | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | true | true | false | false | chasing #2 and climbing tree w/ #2 | false | false | false | false | false | false | false | true | POINT (-73.9632337134707 40.7914682370734) | 19 | 4 | 19 | 13 | ||||
1109 | 1109 | -73.9678154033099 | 40.7742783484486 | 12H-PM-1007-01 | 12H | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | in tree | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9678154033099 40.7742783484486) | 19 | 4 | 19 | 13 | ||||
1152 | 1152 | -73.9608399003798 | 40.7817704502248 | 23I-AM-1019-01 | 23I | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 18 | on a tree | false | false | true | false | false | false | false | false | false | false | false | false | false | eyed me warily,then went up the tree | POINT (-73.9608399003798 40.7817704502248) | 19 | 4 | 19 | 13 | |||
1408 | 1408 | -73.973230162241 | 40.7689824531444 | 5F-AM-1007-01 | 05F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 5 | fence | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.973230162241 40.7689824531444) | 19 | 4 | 19 | 13 | ||||
1429 | 1429 | -73.9706533131129 | 40.768902033819 | 6I-AM-1006-01 | 06I | AM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | true | false | true | true | true | false | false | false | false | false | false | false | true | runs from (someone sneezed) | POINT (-73.9706533131129 40.768902033819) | 19 | 4 | 19 | 13 | |||||
1431 | 1431 | -73.9601918930677 | 40.7944134683406 | 35C-AM-1007-01 | 35C | AM | 10072018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | (white oak) | false | false | false | false | false | sitting still | false | false | false | false | false | false | false | false | POINT (-73.9601918930677 40.7944134683406) | 19 | 4 | 19 | 13 | |||
1581 | 1581 | -73.97157754108 | 40.7776249963967 | 14C-PM-1006-01 | 14C | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 10 | false | false | true | false | false | false | true | false | false | false | false | false | true | POINT (-73.97157754108 40.7776249963967) | 19 | 4 | 19 | 13 | |||||
2142 | 2142 | -73.9598535425706 | 40.7915589343685 | 33D-PM-1006-01 | 33D | PM | 10062018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 15 | false | true | false | false | false | hanging on fence | true | false | false | true | false | false | false | true | POINT (-73.9598535425706 40.7915589343685) | 19 | 4 | 19 | 13 | |||||
2456 | 2456 | -73.9698446365683 | 40.7842607168578 | 22A-AM-1008-01 | 22A | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 4 | on fence | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9698446365683 40.7842607168578) | 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 | |||||
2522 | 2522 | -73.9658747245917 | 40.7754033737532 | 14I-PM-1018-01 | 14I | PM | 10182018 | 1 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Above Ground | Fallen branch | true | false | false | false | true | false | false | false | false | true | false | false | true | POINT (-73.9658747245917 40.7754033737532) | 19 | 4 | 19 | 13 | |||||
2724 | 2724 | -73.9611434082667 | 40.7893671772846 | 30E-PM-1008-01 | 30E | PM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 40 | false | false | true | false | false | false | true | false | false | false | false | false | false | POINT (-73.9611434082667 40.7893671772846) | 19 | 4 | 19 | 13 | |||||
2729 | 2729 | -73.9615429203441 | 40.7907417648701 | 31D-AM-1014-01 | 31D | AM | 10142018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 20 | Ground then up tree | false | false | true | false | false | chased by a doggo | false | false | true | false | false | false | false | true | runs from (dogs!) | POINT (-73.9615429203441 40.7907417648701) | 19 | 4 | 19 | 13 | |||
782 | 782 | -73.9710559113762 | 40.7794279914209 | 16C-PM-1018-01 | 16C | PM | 10182018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | false | false | false | false | disappeared up other side of tree | POINT (-73.9710559113762 40.7794279914209) | 19 | 4 | 19 | 13 | ||||
1118 | 1118 | -73.9719460335398 | 40.7810508156287 | 18A-AM-1012-01 | 18A | AM | 10122018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | White tail | Above Ground | 3 | tree | true | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9719460335398 40.7810508156287) | 19 | 4 | 19 | 13 | |||
2067 | 2067 | -73.9725077933574 | 40.7654562710325 | 2I-PM-1006-01 | 02I | PM | 10062018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 2 | Sitting on back of bench with food hanging from mouth | false | false | false | false | false | staring at me | false | false | false | false | false | false | false | true | POINT (-73.9725077933574 40.7654562710325) | 19 | 4 | 19 | 13 | |||
2251 | 2251 | -73.9587678566254 | 40.7962656030995 | 38C-PM-1014-01 | 38C | PM | 10142018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 20 | false | false | true | false | false | true | false | false | false | false | false | false | false | POINT (-73.9587678566254 40.7962656030995) | 19 | 4 | 19 | 13 | |||||
2389 | 2389 | -73.9801343393329 | 40.7691512453402 | 3A-AM-1012-01 | 03A | AM | 10122018 | 1 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. Cinnamon & White selected as Highlights. Made executive adjustments. | Above Ground | 1 | false | false | false | true | false | false | false | false | false | true | false | false | true | POINT (-73.9801343393329 40.7691512453402) | 19 | 4 | 19 | 13 | ||||
2495 | 2495 | -73.9621253644004 | 40.7912082086879 | 31C-AM-1017-01 | 31C | AM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 8 | true | false | true | true | false | false | false | false | false | true | false | false | true | POINT (-73.9621253644004 40.7912082086879) | 19 | 4 | 19 | 13 | |||||
45 | 45 | -73.9579645940414 | 40.7918613498407 | 34F-AM-1007-01 | 34F | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | true | false | true | false | false | false | false | false | false | false | false | false | true | POINT (-73.9579645940414 40.7918613498407) | 19 | 4 | 19 | 13 | |||||
102 | 102 | -73.9575986161364 | 40.799368134968 | 41B-PM-1014-01 | 41B | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | Climbing tree | false | false | true | false | false | climbing (tree) | false | false | false | false | false | false | false | true | POINT (-73.9575986161364 40.799368134968) | 19 | 4 | 19 | 13 | |||
137 | 137 | -73.9782417115139 | 40.7724665036447 | 7A-AM-1006-01 | 07A | AM | 10062018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in tree | false | false | false | false | true | false | true | false | false | true | false | false | false | looked at us | POINT (-73.9782417115139 40.7724665036447) | 19 | 4 | 19 | 13 | |||
385 | 385 | -73.979316275899 | 40.7692134727555 | 3B-PM-1007-01 | 03B | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | in tree | false | false | false | false | false | chased by dog | false | false | false | false | false | false | false | false | POINT (-73.979316275899 40.7692134727555) | 19 | 4 | 19 | 13 | ||||
601 | 601 | -73.9522291603405 | 40.7976985385835 | 42G-PM-1014-01 | 42G | PM | 10142018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 8 | false | false | true | false | true | false | false | true | false | false | false | false | true | POINT (-73.9522291603405 40.7976985385835) | 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 | |||||
917 | 917 | -73.9676514056678 | 40.7730853732876 | 11H-AM-1010-01 | 11H | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | true | false | false | started climbing down to me | POINT (-73.9676514056678 40.7730853732876) | 19 | 4 | 19 | 13 | ||||
996 | 996 | -73.9703149829421 | 40.7785583630323 | 16D-AM-1007-01 | 16D | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | true | false | false | false | false | false | false | false | false | true | POINT (-73.9703149829421 40.7785583630323) | 19 | 4 | 19 | 13 | |||||
1241 | 1241 | -73.9651817987035 | 40.7819082838334 | 21E-AM-1017-01 | 21E | AM | 10172018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | Climbs small tree | false | false | false | true | true | false | false | false | false | true | false | false | false | walks from | POINT (-73.9651817987035 40.7819082838334) | 19 | 4 | 19 | 13 | |||
1315 | 1315 | -73.9595955824812 | 40.7933047943534 | 34D-PM-1007-01 | 34D | PM | 10072018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 25 | false | false | true | false | true | false | false | false | false | true | false | false | true | POINT (-73.9595955824812 40.7933047943534) | 19 | 4 | 19 | 13 | |||||
1423 | 1423 | -73.9600204328201 | 40.782877291358 | 24I-AM-1019-01 | 24I | AM | 10192018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9600204328201 40.782877291358) | 19 | 4 | 19 | 13 | |||||
1500 | 1500 | -73.9769969548024 | 40.7710711265211 | 6C-AM-1007-01 | 06C | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | vid! | Above Ground | 15 | false | false | true | false | false | false | false | false | false | true | false | false | false | curious,but wary | POINT (-73.97699695480242 40.7710711265211) | 19 | 4 | 19 | 13 | |||
1825 | 1825 | -73.9624209799704 | 40.7910200972752 | 31C-PM-1010-01 | 31C | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9624209799704 40.7910200972752) | 19 | 4 | 19 | 13 | |||||
2406 | 2406 | -73.9668964315686 | 40.7777577990886 | 16G-AM-1010-01 | 16G | AM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 3 | false | false | true | false | false | false | false | false | false | true | false | false | true | POINT (-73.9668964315686 40.7777577990886) | 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 | |||||
2956 | 2956 | -73.9654741695628 | 40.7890427851106 | 28B-PM-1010-01 | 28B | PM | 10102018 | 1 | Adult | Gray | White | Gray+White | Above Ground | 10 | in a tree | false | false | true | false | false | false | false | false | false | false | false | false | false | POINT (-73.9654741695628 40.7890427851106) | 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 );