This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts, Police Precincts
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | -73.9596413903948 | 40.7903128889029 | 32E-PM-1017-14 | 32E | PM | 10172018 | 14 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | false | true | POINT (-73.9596413903948 40.7903128889029) | 19 | 4 | 19 | 13 | |||||||
64 | 64 | -73.9595002339508 | 40.7903365788694 | 32E-PM-1017-13 | 32E | PM | 10172018 | 13 | Adult | Gray | Gray+ | Nothing selected as Primary. Gray selected as Highlights. Made executive adjustments. | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9595002339508 40.7903365788694) | 19 | 4 | 19 | 13 | |||||||
363 | 363 | -73.9707197274481 | 40.7773956803431 | 14D-PM-1019-12 | 14D | PM | 10192018 | 12 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707197274481 40.7773956803431) | 19 | 4 | 19 | 13 | ||||||||
390 | 390 | -73.970720187655 | 40.7774564799983 | 14D-PM-1019-11 | 14D | PM | 10192018 | 11 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.970720187655 40.7774564799983) | 19 | 4 | 19 | 13 | ||||||||
607 | 607 | -73.9547711796823 | 40.7908540751983 | 34I-PM-1010-06 | 34I | PM | 10102018 | 6 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9547711796823 40.7908540751983) | 19 | 4 | 19 | 13 | ||||||||
645 | 645 | -73.9758152322587 | 40.7692377401467 | 4E-PM-1008-03 | 04E | PM | 10082018 | 3 | Adult | Gray | Gray+ | false | true | false | false | false | chasing #4 | false | false | false | false | false | false | false | false | POINT (-73.9758152322587 40.7692377401467) | 19 | 4 | 19 | 13 | |||||||
1958 | 1958 | -73.9693120090055 | 40.771096102012 | 9H-PM-1018-07 | 09H | PM | 10182018 | 7 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9693120090055 40.771096102012) | 19 | 4 | 19 | 13 | ||||||||
2080 | 2080 | -73.954530253849 | 40.7910247489879 | 34I-PM-1010-07 | 34I | PM | 10102018 | 7 | Adult | Gray | Gray+ | true | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.954530253849 40.7910247489879) | 19 | 4 | 19 | 13 | ||||||||
2237 | 2237 | -73.9708225719705 | 40.7772497804149 | 14D-PM-1019-13 | 14D | PM | 10192018 | 13 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9708225719705 40.7772497804149) | 19 | 4 | 19 | 13 | ||||||||
2257 | 2257 | -73.95431338448 | 40.7940537582585 | 37G-PM-1007-08 | 37G | PM | 10072018 | 8 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95431338448 40.7940537582585) | 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 | |||||||
2719 | 2719 | -73.973425927351 | 40.7781929919344 | 14B-AM-1007-03 | 14B | AM | 10072018 | 3 | Adult | Gray | Gray+ | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.973425927351 40.7781929919344) | 19 | 4 | 19 | 13 | ||||||||
2840 | 2840 | -73.9532163535175 | 40.7982970313067 | 42F-PM-1017-04 | 42F | PM | 10172018 | 4 | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532163535175 40.7982970313067) | 19 | 4 | 19 | 13 | |||||||||
2866 | 2866 | -73.9744025383371 | 40.7777296605765 | 13A-AM-1017-04 | 13A | AM | 10172018 | 4 | Adult | Gray | Gray+ | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9744025383371 40.7777296605765) | 19 | 4 | 19 | 13 | ||||||||
2869 | 2869 | -73.9630822385425 | 40.7914844989865 | 31B-PM-1007-04 | 31B | PM | 10072018 | 4 | Juvenile | Gray | Gray+ | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9630822385425 40.7914844989865) | 19 | 4 | 19 | 13 | ||||||||
2875 | 2875 | -73.9546616782922 | 40.790974533739 | 34I-PM-1010-05 | 34I | PM | 10102018 | 5 | Adult | Gray | Gray+ | false | false | false | false | true | false | false | false | false | true | false | false | false | POINT (-73.9546616782922 40.790974533739) | 19 | 4 | 19 | 13 | ||||||||
46 | 46 | -73.9673253417305 | 40.7749505252981 | 13H-PM-1010-02 | 13H | PM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | tree | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9673253417305 40.7749505252981) | 19 | 4 | 19 | 13 | |||||
72 | 72 | -73.9666007935638 | 40.7845098131567 | 23C-PM-1014-03 | 23C | PM | 10142018 | 3 | Adult | Gray | Gray+ | Above Ground | 8 | false | true | false | false | false | chasing (#4 across trees) | false | false | false | false | false | false | false | false | POINT (-73.9666007935638 40.7845098131567) | 19 | 4 | 19 | 13 | |||||
96 | 96 | -73.9708549670788 | 40.7699587019058 | 7H-PM-1006-04 | 07H | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 12 | on tree knob | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9708549670788 40.7699587019058) | 19 | 4 | 19 | 13 | ||||
98 | 98 | -73.9730277911422 | 40.7712145488828 | 7F-AM-1008-16 | 07F | AM | 10082018 | 16 | Juvenile | Gray | Gray+ | Above Ground | 2 | tree | false | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9730277911422 40.7712145488828) | 19 | 4 | 19 | 13 | |||||
100 | 100 | -73.9761592532482 | 40.7747213585387 | 10A-AM-1006-04 | 10A | AM | 10062018 | 4 | Juvenile | Gray | Gray+ | Above Ground | 10 | tree near large rock on Bridle Path | false | false | false | false | false | walking on branch | false | false | false | false | true | false | false | false | POINT (-73.9761592532482 40.7747213585387) | 19 | 4 | 19 | 13 | ||||
105 | 105 | -73.9589249555235 | 40.7908193284981 | 32E-PM-1017-03 | 32E | PM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | bottom of tree | false | false | false | true | false | still | false | false | false | false | false | false | true | false | POINT (-73.9589249555235 40.7908193284981) | 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 | ||||||
110 | 110 | -73.9711318790279 | 40.7701941550273 | 7G-AM-1010-02 | 07G | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | true | false | false | false | false | false | false | false | false | true | false | false | true | POINT (-73.9711318790279 40.7701941550273) | 19 | 4 | 19 | 13 | ||||||
178 | 178 | -73.9613780522542 | 40.790786197111 | 31D-PM-1006-04 | 31D | PM | 10062018 | 4 | Adult | Gray | Gray+ | Above Ground | 30 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9613780522542 40.790786197111) | 19 | 4 | 19 | 13 | ||||||
229 | 229 | -73.972416242971 | 40.7714260236636 | 8F-PM-1012-04 | 08F | PM | 10122018 | 4 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.972416242971 40.7714260236636) | 19 | 4 | 19 | 13 | ||||||
237 | 237 | -73.967895656898 | 40.7767409597341 | 15F-PM-1010-07 | 15F | PM | 10102018 | 7 | Adult | Gray | Gray+ | Above Ground | 3 | on fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.967895656898 40.7767409597341) | 19 | 4 | 19 | 13 | |||||
281 | 281 | -73.9619411917909 | 40.7923536640283 | 33B-PM-1010-11 | 33B | PM | 10102018 | 11 | Adult | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9619411917909 40.7923536640283) | 19 | 4 | 19 | 13 | ||||||
306 | 306 | -73.9689700100267 | 40.7775169562765 | 15E-PM-1008-05 | 15E | PM | 10082018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | sitting | false | true | false | false | false | false | false | false | POINT (-73.9689700100267 40.7775169562765) | 19 | 4 | 19 | 13 | |||||
311 | 311 | -73.9578779556574 | 40.7934116539732 | 35E-PM-1006-06 | 35E | PM | 10062018 | 6 | Adult | Gray | Gray+ | Above Ground | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.9578779556574 40.7934116539732) | 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 | ||||||
360 | 360 | -73.9672054610151 | 40.7876519923501 | 26A-PM-1006-05 | 26A | PM | 10062018 | 5 | Adult | Gray | Gray+ | Above Ground | 40 | false | true | false | false | false | false | false | false | false | true | false | false | false | POINT (-73.9672054610151 40.7876519923501) | 19 | 4 | 19 | 13 | ||||||
371 | 371 | -73.964080104186 | 40.7907898627287 | 30B-AM-1007-02 | 30B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.964080104186 40.7907898627287) | 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 | ||||
480 | 480 | -73.9641293283734 | 40.7907654006019 | 30B-AM-1007-03 | 30B | AM | 10072018 | 3 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641293283734 40.7907654006019) | 19 | 4 | 19 | 13 | ||||||
582 | 582 | -73.9677779408464 | 40.7867482211349 | 25A-AM-1013-02 | 25A | AM | 10132018 | 2 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | true | false | false | false | chasing #3 | false | false | false | true | false | false | true | false | POINT (-73.9677779408464 40.7867482211349) | 19 | 4 | 19 | 13 | |||||
598 | 598 | -73.9698196671161 | 40.7802972001469 | 18C-PM-1018-03 | 18C | PM | 10182018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | true | true | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9698196671161 40.7802972001469) | 19 | 4 | 19 | 13 | ||||||
610 | 610 | -73.9671549566066 | 40.7751342870705 | 14H-AM-1007-01 | 14H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Above Ground | 180 | top of tree | true | false | false | false | false | jumping between branches | false | false | false | false | false | false | true | false | POINT (-73.9671549566066 40.7751342870705) | 19 | 4 | 19 | 13 | ||||
656 | 656 | -73.9553726714504 | 40.7987578541123 | 41D-AM-1014-02 | 41D | AM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | false | false | jumping | false | false | false | false | false | false | true | false | POINT (-73.9553726714504 40.7987578541123) | 19 | 4 | 19 | 13 | |||||
744 | 744 | -73.9745687653791 | 40.7776396926997 | 13A-PM-1014-02 | 13A | PM | 10142018 | 2 | Adult | Gray | Gray+ | Above Ground | 45 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9745687653791 40.7776396926997) | 19 | 4 | 19 | 13 | ||||||
747 | 747 | -73.9771422625274 | 40.772361415776 | 7B-AM-1008-02 | 07B | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771422625274 40.772361415776) | 19 | 4 | 19 | 13 | ||||||
749 | 749 | -73.9686304581526 | 40.7773631337117 | 15E-PM-1008-01 | 15E | PM | 10082018 | 1 | Adult | Gray | Gray+ | Above Ground | 4 | on fallen tree | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9686304581526 40.7773631337117) | 19 | 4 | 19 | 13 | |||||
783 | 783 | -73.9677654289757 | 40.786785529449 | 25A-AM-1013-03 | 25A | AM | 10132018 | 3 | Gray | Gray+ | Above Ground | 15 | BIG TREE | false | false | false | false | false | being chased by #2 | false | false | false | false | false | false | true | false | POINT (-73.9677654289757 40.786785529449) | 19 | 4 | 19 | 13 | |||||
801 | 801 | -73.9743342303548 | 40.7727742948332 | 8D-AM-1007-08 | 08D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | false | false | communicating from tree | false | false | false | false | false | false | false | false | POINT (-73.97433423035481 40.7727742948332) | 19 | 4 | 19 | 13 | |||||
811 | 811 | -73.9771695272048 | 40.7724277276263 | 7B-AM-1008-03 | 07B | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9771695272048 40.7724277276263) | 19 | 4 | 19 | 13 | ||||||
822 | 822 | -73.9576559099012 | 40.7992598626483 | 41B-AM-1010-09 | 41B | AM | 10102018 | 9 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9576559099012 40.7992598626483) | 19 | 4 | 19 | 13 | ||||||
849 | 849 | -73.9736165917399 | 40.7724543901497 | 8D-AM-1007-04 | 08D | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 3 | false | true | false | false | false | chasing squirrel #3 | false | false | false | false | false | false | false | false | POINT (-73.9736165917399 40.7724543901497) | 19 | 4 | 19 | 13 | |||||
896 | 896 | -73.9755055978764 | 40.7707438681742 | 6D-AM-1008-02 | 06D | AM | 10082018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9755055978764 40.7707438681742) | 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 | ||||||
926 | 926 | -73.9596006938677 | 40.7834706440535 | 25I-PM-1007-07 | 25I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #8 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9596006938677 40.7834706440535) | 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 | |||||
983 | 983 | -73.9641552070803 | 40.7908479527923 | 30B-AM-1007-05 | 30B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9641552070803 40.7908479527923) | 19 | 4 | 19 | 13 | ||||||
1011 | 1011 | -73.9719111470164 | 40.7758789855474 | 12D-AM-1013-02 | 12D | AM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 7 | Was on top of the edge of Bow Bridge | false | false | false | false | false | jumped off | false | false | false | true | false | false | false | true | POINT (-73.9719111470164 40.7758789855474) | 19 | 4 | 19 | 13 | ||||
1016 | 1016 | -73.9691293546408 | 40.7703219076549 | 8I-AM-1006-11 | 08I | AM | 10062018 | 11 | Adult | Gray | Gray+ | Above Ground | 50 | tree | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9691293546408 40.77032190765491) | 19 | 4 | 19 | 13 | |||||
1018 | 1018 | -73.9695305555392 | 40.7757541971012 | 13F-PM-1008-03 | 13F | PM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 15 | tree | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695305555392 40.7757541971012) | 19 | 4 | 19 | 13 | |||||
1046 | 1046 | -73.9647891228606 | 40.789853066039 | 29B-AM-1007-02 | 29B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 30 | true | false | false | false | false | false | false | false | true | false | false | false | false | POINT (-73.9647891228606 40.789853066039) | 19 | 4 | 19 | 13 | ||||||
1061 | 1061 | -73.9532657715601 | 40.7949046809422 | 39G-AM-1018-02 | 39G | AM | 10182018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 25 | Tree | false | false | false | false | false | sitting & watching | false | false | false | false | false | false | true | false | POINT (-73.9532657715601 40.7949046809422) | 19 | 4 | 19 | 13 | ||||
1065 | 1065 | -73.9769700777377 | 40.7728489574967 | 7B-AM-1008-08 | 07B | AM | 10082018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9769700777377 40.7728489574967) | 19 | 4 | 19 | 13 | ||||||
1069 | 1069 | -73.9595485734618 | 40.7835326425693 | 25I-PM-1007-08 | 25I | PM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | playing very high in tree w/ #7 | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9595485734618 40.7835326425693) | 19 | 4 | 19 | 13 | ||||||
1070 | 1070 | -73.9674631254594 | 40.7790076357696 | 17E-AM-1017-10 | 17E | AM | 10172018 | 10 | Juvenile | Gray | Gray+ | Above Ground | 2 | Fence | true | false | false | false | false | false | false | false | false | false | false | false | true | POINT (-73.9674631254594 40.7790076357696) | 19 | 4 | 19 | 13 | |||||
1147 | 1147 | -73.9631818528816 | 40.7925332194132 | 32A-AM-1018-01 | 32A | AM | 10182018 | 1 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631818528816 40.7925332194132) | 19 | 4 | 19 | 13 | ||||||
1148 | 1148 | -73.9707339200738 | 40.7796333355689 | 17C-PM-1013-03 | 17C | PM | 10132018 | 3 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | false | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9707339200738 40.7796333355689) | 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 | |||||
1254 | 1254 | -73.9764013589865 | 40.7663063499207 | 1F-PM-1019-03 | 01F | PM | 10192018 | 3 | Juvenile | Gray | Gray+ | Above Ground | 1 | false | false | false | false | false | hiding | false | false | false | false | false | false | false | false | POINT (-73.9764013589865 40.7663063499207) | 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 | ||||||
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 | ||||
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 | ||||
1420 | 1420 | -73.9647605121306 | 40.7803961531517 | 20G-AM-1018-03 | 20G | AM | 10182018 | 3 | Adult | Gray | Gray+ | Above Ground | 12 | in tree | true | false | false | false | false | true | false | false | false | false | false | false | false | POINT (-73.9647605121306 40.7803961531517) | 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 | |||||
1446 | 1446 | -73.9775238847836 | 40.7675792683587 | 2D-AM-1007-05 | 02D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 100 | true | false | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9775238847836 40.7675792683587) | 19 | 4 | 19 | 13 | ||||||
1495 | 1495 | -73.9735137178369 | 40.769109895294 | 5F-AM-1007-06 | 05F | AM | 10072018 | 6 | Adult | Gray | Gray+ | Above Ground | 2 | branch | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9735137178369 40.769109895294) | 19 | 4 | 19 | 13 | |||||
1504 | 1504 | -73.9706586108006 | 40.7796357444471 | 17C-PM-1013-02 | 17C | PM | 10132018 | 2 | Adult | Gray | Gray+ | Above Ground | 20 | in a tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9706586108006 40.7796357444471) | 19 | 4 | 19 | 13 | |||||
1527 | 1527 | -73.970216605149 | 40.7702960667277 | 8H-PM-1014-08 | 08H | PM | 10142018 | 8 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#7),playing? | false | false | false | false | false | false | true | false | POINT (-73.970216605149 40.7702960667277) | 19 | 4 | 19 | 13 | |||||
1546 | 1546 | -73.976422624924 | 40.7735818387346 | 8B-AM-1007-08 | 08B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | false | true | false | holding nut | false | false | false | false | false | false | true | false | POINT (-73.976422624924 40.7735818387346) | 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 | |||||
1574 | 1574 | -73.9561840935803 | 40.7992037821497 | 42C-PM-1013-05 | 42C | PM | 10132018 | 5 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | true | false | false | false | false | false | true | false | POINT (-73.9561840935803 40.7992037821497) | 19 | 4 | 19 | 13 | ||||||
1575 | 1575 | -73.9703169373939 | 40.7700658823854 | 7H-AM-1006-13 | 07H | AM | 10062018 | 13 | Adult | Gray | Gray+ | Above Ground | 10 | true | false | false | false | false | running (up tree) | false | false | false | false | false | false | true | false | POINT (-73.9703169373939 40.7700658823854) | 19 | 4 | 19 | 13 | |||||
1611 | 1611 | -73.9655238539833 | 40.7815633947684 | 21E-AM-1017-03 | 21E | AM | 10172018 | 3 | Adult | Gray | Gray+ | Above Ground | 7 | false | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9655238539833 40.7815633947684) | 19 | 4 | 19 | 13 | ||||||
1624 | 1624 | -73.9737060043988 | 40.7725660224983 | 8D-AM-1007-05 | 08D | AM | 10072018 | 5 | Adult | Gray | Gray+ | Above Ground | 15 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9737060043988 40.7725660224983) | 19 | 4 | 19 | 13 | ||||||
1649 | 1649 | -73.969347812694 | 40.7744098063421 | 12G-PM-1007-02 | 12G | PM | 10072018 | 2 | Gray | Gray+ | Above Ground | in tree | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.969347812694 40.7744098063421) | 19 | 4 | 19 | 13 | |||||||
1673 | 1673 | -73.9746940851342 | 40.7760966488186 | 11B-PM-1014-02 | 11B | PM | 10142018 | 2 | Juvenile | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746940851342 40.7760966488186) | 19 | 4 | 19 | 13 | ||||||
1684 | 1684 | -73.9637824756607 | 40.7904737110761 | 30B-AM-1007-08 | 30B | AM | 10072018 | 8 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.9637824756607 40.7904737110761) | 19 | 4 | 19 | 13 | ||||||
1693 | 1693 | -73.9593781427412 | 40.7841519912635 | 26I-AM-1010-02 | 26I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | false | false | true | false | false | false | false | false | false | false | false | POINT (-73.95937814274122 40.7841519912635) | 19 | 4 | 19 | 13 | ||||||
1737 | 1737 | -73.9640741640547 | 40.7807274581426 | 20G-AM-1018-01 | 20G | AM | 10182018 | 1 | Juvenile | Gray | Gray+ | Above Ground | 7 | Tree limb | false | false | false | false | false | sitting still on limb | false | false | false | false | false | false | true | false | POINT (-73.9640741640547 40.7807274581426) | 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 | ||||||
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 | ||||||
1770 | 1770 | -73.9728170980779 | 40.7703557830437 | 7F-AM-1008-06 | 07F | AM | 10082018 | 6 | Adult | Gray | Gray+ | Above Ground | 28 | in hole in tree | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | POINT (-73.9728170980779 40.770355783043705) | 19 | 4 | 19 | 13 | ||||
1817 | 1817 | -73.9703076450783 | 40.770158422629 | 8H-PM-1014-07 | 08H | PM | 10142018 | 7 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | chasing (#8),playing? | false | false | false | false | false | false | true | false | POINT (-73.9703076450783 40.770158422629) | 19 | 4 | 19 | 13 | |||||
1831 | 1831 | -73.9746877519291 | 40.7761402808083 | 11B-PM-1014-03 | 11B | PM | 10142018 | 3 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.9746877519291 40.7761402808083) | 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 | |||||
1926 | 1926 | -73.9742811484852 | 40.775533619083 | 11B-PM-1014-08 | 11B | PM | 10142018 | 8 | Gray | Gray+ | Above Ground | 10 | false | true | false | false | false | false | false | false | false | false | false | false | false | POINT (-73.97428114848522 40.775533619083) | 19 | 4 | 19 | 13 | |||||||
1955 | 1955 | -73.9606559309874 | 40.7889527629826 | 30E-AM-1008-02 | 30E | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 5 | false | true | false | false | false | true | false | false | false | false | false | true | false | POINT (-73.9606559309874 40.7889527629826) | 19 | 4 | 19 | 13 | ||||||
1989 | 1989 | -73.9631646754647 | 40.7925716810884 | 32A-AM-1018-02 | 32A | AM | 10182018 | 2 | Adult | Gray | Gray+ | Above Ground | 15 | true | true | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9631646754647 40.7925716810884) | 19 | 4 | 19 | 13 | ||||||
2010 | 2010 | -73.9673821557469 | 40.7786375267659 | 17F-PM-1020-06 | 17F | PM | 10202018 | 6 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | false | false | POINT (-73.96738215574692 40.7786375267659) | 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 | ||||||
2128 | 2128 | -73.9757673193743 | 40.7669614322613 | 2F-PM-1014-04 | 02F | PM | 10142018 | 4 | Adult | Gray | Gray+ | Above Ground | 20 | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9757673193743 40.766961432261304) | 19 | 4 | 19 | 13 | ||||||
2136 | 2136 | -73.9721897915211 | 40.7660434203132 | 3I-AM-1010-02 | 03I | AM | 10102018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9721897915211 40.76604342031321) | 19 | 4 | 19 | 13 | ||||||
2140 | 2140 | -73.9598875541307 | 40.7973415580717 | 38A-AM-1019-04 | 38A | AM | 10192018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | false | false | false | walking | false | false | false | false | false | false | true | false | POINT (-73.9598875541307 40.7973415580717) | 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 |
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 );