This data as json, CSV (advanced)
Suggested facets: Shift, Date, Hectare Squirrel Number, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Running, Climbing, Eating, Foraging, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Runs from, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
577 | 577 | -73.9497217674555 | 40.796517007214 | 42I-PM-1014-03 | 42I | PM | 10142018 | 3 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9497217674555 40.796517007214) | 19 | 4 | 19 | 13 | ||||||
2696 | 2696 | -73.9501457233643 | 40.797094356558 | 42I-PM-1014-01 | 42I | PM | 10142018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9501457233643 40.797094356558) | 19 | 4 | 19 | 13 | |||||
2728 | 2728 | -73.9507140045973 | 40.7957700986293 | 41I-PM-1017-01 | 41I | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon oval on back | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507140045973 40.7957700986293) | 19 | 4 | 19 | 13 | ||||
2838 | 2838 | -73.9507699667119 | 40.7955166039555 | 40I-AM-1018-02 | 40I | AM | 10182018 | 2 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9507699667119 40.795516603955505) | 19 | 4 | 19 | 13 | ||||||
1178 | 1178 | -73.9507772992986 | 40.7949188960194 | 40I-PM-1013-01 | 40I | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 7 | false | false | false | true | false | eating (berries) | false | false | false | false | false | false | true | false | POINT (-73.9507772992986 40.7949188960194) | 19 | 4 | 19 | 13 | ||||
2632 | 2632 | -73.950827557335 | 40.797579073666 | 42H-PM-1014-02 | 42H | PM | 10142018 | 2 | Adult | Gray | White | Gray+White | Above Ground | Running along stone ledge | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.950827557335 40.797579073666) | 18 | 4 | 36 | 18 | |||||
200 | 200 | -73.9510747586301 | 40.7973106833951 | 42H-AM-1019-02 | 42H | AM | 10192018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9510747586301 40.7973106833951) | 19 | 4 | 19 | 13 | |||||
2611 | 2611 | -73.951448051873 | 40.7973951649254 | 42G-AM-1018-02 | 42G | AM | 10182018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.951448051873 40.7973951649254) | 19 | 4 | 19 | 13 | ||||||
1136 | 1136 | -73.9515907796216 | 40.7952684235477 | 40H-AM-1017-02 | 40H | AM | 10172018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95159077962161 40.7952684235477) | 19 | 4 | 19 | 13 | ||||||
2916 | 2916 | -73.9517525111679 | 40.7974407641075 | 42G-PM-1014-02 | 42G | PM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 14 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9517525111679 40.7974407641075) | 19 | 4 | 19 | 13 | |||||
1130 | 1130 | -73.9519081627768 | 40.7973148719421 | 41G-AM-1013-02 | 41G | AM | 10132018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9519081627768 40.7973148719421) | 19 | 4 | 19 | 13 | |||||
215 | 215 | -73.9519639918804 | 40.7949911702392 | 39H-AM-1007-01 | 39H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9519639918804 40.7949911702392) | 19 | 4 | 19 | 13 | ||||||
1775 | 1775 | -73.951965247933 | 40.7938167628067 | 38I-PM-1014-03 | 38I | PM | 10142018 | 3 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | true | POINT (-73.951965247933 40.7938167628067) | 19 | 4 | 19 | 13 | |||||
1024 | 1024 | -73.9521514669041 | 40.7949515182825 | 39H-PM-1013-03 | 39H | PM | 10132018 | 3 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | true | POINT (-73.9521514669041 40.7949515182825) | 19 | 4 | 19 | 13 | |||||
272 | 272 | -73.9521950056404 | 40.794937340845 | 39H-PM-1013-01 | 39H | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | ran away when a human approached with a dog | POINT (-73.9521950056404 40.794937340845) | 19 | 4 | 19 | 13 | ||||
155 | 155 | -73.9522142360388 | 40.7949598486683 | 39H-PM-1013-02 | 39H | PM | 10132018 | 2 | Juvenile | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9522142360388 40.7949598486683) | 19 | 4 | 19 | 13 | |||||
304 | 304 | -73.9523001834395 | 40.7949231000186 | 39H-AM-1007-02 | 39H | AM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9523001834395 40.7949231000186) | 19 | 4 | 19 | 13 | |||||
2008 | 2008 | -73.9524364087437 | 40.792846505434 | 37I-PM-1006-01 | 37I | PM | 10062018 | 1 | Adult | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Above Ground | 5 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9524364087437 40.792846505434) | 19 | 4 | 19 | 13 | |||||
1877 | 1877 | -73.9524490779105 | 40.7936003219524 | 38I-AM-1019-01 | 38I | AM | 10192018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9524490779105 40.7936003219524) | 19 | 4 | 19 | 13 | |||||
525 | 525 | -73.952526164386 | 40.7963759240504 | 40G-AM-1007-02 | 40G | AM | 10072018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 18 | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.952526164386 40.7963759240504) | 19 | 4 | 19 | 13 | |||||
438 | 438 | -73.9525747516914 | 40.7977257435263 | 42F-PM-1017-02 | 42F | PM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.95257475169142 40.7977257435263) | 19 | 4 | 19 | 13 | ||||
2460 | 2460 | -73.9526681107152 | 40.7977012009146 | 42F-PM-1017-01 | 42F | PM | 10172018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | playing | false | false | false | false | false | false | true | false | POINT (-73.9526681107152 40.7977012009146) | 19 | 4 | 19 | 13 | ||||
2035 | 2035 | -73.9527184914182 | 40.7926785904847 | 37I-PM-1006-02 | 37I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9527184914182 40.7926785904847) | 19 | 4 | 19 | 13 | ||||||
1253 | 1253 | -73.9527227282134 | 40.7935061484064 | 37I-AM-1010-03 | 37I | AM | 10102018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 4 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527227282134 40.7935061484064) | 19 | 4 | 19 | 13 | ||||
1227 | 1227 | -73.9527924755398 | 40.7934366260533 | 37I-AM-1010-04 | 37I | AM | 10102018 | 4 | Adult | Gray | Gray+ | Above Ground | 50 | in tree | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9527924755398 40.7934366260533) | 19 | 4 | 19 | 13 | |||||
300 | 300 | -73.9528149779809 | 40.7924984810637 | 36I-AM-1017-06 | 36I | AM | 10172018 | 6 | Adult | Gray | Black | Gray+Black | Darker than others | Above Ground | 10 | Running down tree | true | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9528149779809 40.7924984810637) | 19 | 4 | 19 | 13 | |||
62 | 62 | -73.952819267977 | 40.7923130402793 | 36I-AM-1017-02 | 36I | AM | 10172018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.952819267977 40.7923130402793) | 19 | 4 | 19 | 13 | ||||
851 | 851 | -73.9528462779437 | 40.7923843043685 | 36I-AM-1017-04 | 36I | AM | 10172018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9528462779437 40.7923843043685) | 19 | 4 | 19 | 13 | |||||
3004 | 3004 | -73.9528482858163 | 40.7922056218325 | 36I-PM-1007-08 | 36I | PM | 10072018 | 8 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | true | false | true | false | POINT (-73.9528482858163 40.7922056218325) | 19 | 4 | 19 | 13 | |||||
799 | 799 | -73.9529413156461 | 40.7920963446605 | 36I-PM-1007-06 | 36I | PM | 10072018 | 6 | Adult | Cinnamon | Gray, White | Cinnamon+Gray, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9529413156461 40.7920963446605) | 19 | 4 | 19 | 13 | |||||
76 | 76 | -73.9530035564643 | 40.7921822457613 | 36I-PM-1007-07 | 36I | PM | 10072018 | 7 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9530035564643 40.7921822457613) | 19 | 4 | 19 | 13 | ||||||
115 | 115 | -73.9530040923555 | 40.7922896176936 | 36I-PM-1007-10 | 36I | PM | 10072018 | 10 | Juvenile | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | false | stole (found?) an entire sandwich | false | false | false | false | false | false | true | false | POINT (-73.9530040923555 40.7922896176936) | 19 | 4 | 19 | 13 | ||||
599 | 599 | -73.9530263552489 | 40.7920949788358 | 36I-PM-1007-05 | 36I | PM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9530263552489 40.7920949788358) | 19 | 4 | 19 | 13 | ||||||
1985 | 1985 | -73.9530791622513 | 40.7959885603967 | 40G-PM-1013-03 | 40G | PM | 10132018 | 3 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9530791622513 40.7959885603967) | 19 | 4 | 19 | 13 | ||||||
2885 | 2885 | -73.9530811255728 | 40.7983069118579 | 42F-AM-1019-02 | 42F | AM | 10192018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9530811255728 40.79830691185791) | 19 | 4 | 19 | 13 | |||||
2836 | 2836 | -73.953092053256 | 40.7982256930243 | 42F-PM-1017-03 | 42F | PM | 10172018 | 3 | Gray | Cinnamon | Gray+Cinnamon | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.953092053256 40.7982256930243) | 19 | 4 | 19 | 13 | ||||||||
2336 | 2336 | -73.9531263214136 | 40.7965675089932 | 40F-PM-1006-01 | 40F | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9531263214136 40.7965675089932) | 19 | 4 | 19 | 13 | |||||
2348 | 2348 | -73.9531965469704 | 40.7947437983977 | 38G-PM-1020-11 | 38G | PM | 10202018 | 11 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | true | false | true | true | false | POINT (-73.9531965469704 40.7947437983977) | 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 | |||||||||
18 | 18 | -73.9532170504865 | 40.7919669739962 | 36I-PM-1007-01 | 36I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9532170504865 40.7919669739962) | 19 | 4 | 19 | 13 | |||||
2204 | 2204 | -73.9532427699097 | 40.7962643767092 | 40G-PM-1013-04 | 40G | PM | 10132018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9532427699097 40.7962643767092) | 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 | ||||
945 | 945 | -73.9532838338416 | 40.7931112674583 | 37H-AM-1018-01 | 37H | AM | 10182018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | Right behind fence of the conservatory | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9532838338416 40.7931112674583) | 19 | 4 | 19 | 13 | |||||
786 | 786 | -73.953296595236 | 40.7927644594513 | 36I-AM-1017-03 | 36I | AM | 10172018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Cinnamon stripe on back | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.953296595236 40.7927644594513) | 19 | 4 | 19 | 13 | ||||
2802 | 2802 | -73.9533101544112 | 40.7938634280159 | 38H-AM-1019-01 | 38H | AM | 10192018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9533101544112 40.7938634280159) | 19 | 4 | 19 | 13 | |||||
1218 | 1218 | -73.953375642605 | 40.7947144477885 | 38G-PM-1020-02 | 38G | PM | 10202018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.953375642605 40.7947144477885) | 19 | 4 | 19 | 13 | |||||
942 | 942 | -73.9533923917973 | 40.7961701874769 | 40G-AM-1007-01 | 40G | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | large tree | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9533923917973 40.7961701874769) | 19 | 4 | 19 | 13 | ||||
327 | 327 | -73.9534306291679 | 40.7959052073753 | 39G-PM-1013-07 | 39G | PM | 10132018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9534306291679 40.7959052073753) | 19 | 4 | 19 | 13 | |||||
40 | 40 | -73.9535410657077 | 40.7928711760061 | 36H-PM-1008-02 | 36H | PM | 10082018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9535410657077 40.79287117600611) | 19 | 4 | 19 | 13 | ||||||
2238 | 2238 | -73.9536198726174 | 40.7980135102228 | 41E-AM-1007-03 | 41E | AM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9536198726174 40.7980135102228) | 19 | 4 | 19 | 13 | ||||||
1961 | 1961 | -73.953664715831 | 40.7981256393159 | 41E-PM-1013-04 | 41E | PM | 10132018 | 4 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.953664715831 40.7981256393159) | 19 | 4 | 19 | 13 | |||||
1422 | 1422 | -73.9537356145842 | 40.7917273773486 | 35I-PM-1006-02 | 35I | PM | 10062018 | 2 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | true | false | false | false | false | false | false | false | true | false | POINT (-73.9537356145842 40.7917273773486) | 19 | 4 | 19 | 13 | ||||||
2252 | 2252 | -73.9537703231359 | 40.7915959393814 | 35I-AM-1013-01 | 35I | AM | 10132018 | 1 | Adult | Cinnamon | White | Cinnamon+White | White underbelly | Above Ground | 18 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9537703231359 40.7915959393814) | 19 | 4 | 19 | 13 | ||||
2650 | 2650 | -73.9538251716292 | 40.7919360198175 | 35I-PM-1006-01 | 35I | PM | 10062018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538251716292 40.7919360198175) | 19 | 4 | 19 | 13 | |||||
2069 | 2069 | -73.9538377039825 | 40.7980605334961 | 42E-PM-1012-03 | 42E | PM | 10122018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 20 | in tree | false | false | true | false | true | true | false | false | false | false | false | true | false | POINT (-73.9538377039825 40.7980605334961) | 19 | 4 | 19 | 13 | ||||
2870 | 2870 | -73.9538475741188 | 40.796479421955 | 40F-PM-1006-02 | 40F | PM | 10062018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 6 | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538475741188 40.796479421955) | 19 | 4 | 19 | 13 | |||||
2277 | 2277 | -73.95385121459 | 40.7981257651433 | 42E-PM-1012-04 | 42E | PM | 10122018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.95385121459 40.7981257651433) | 19 | 4 | 19 | 13 | |||||
1481 | 1481 | -73.9538867186376 | 40.7941409434007 | 38G-PM-1020-03 | 38G | PM | 10202018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | true | false | false | false | false | false | false | false | true | false | false | true | false | POINT (-73.9538867186376 40.7941409434007) | 19 | 4 | 19 | 13 | |||||
2155 | 2155 | -73.9538938706987 | 40.7981150065974 | 42E-PM-1012-05 | 42E | PM | 10122018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9538938706987 40.7981150065974) | 19 | 4 | 19 | 13 | |||||
817 | 817 | -73.9540022445432 | 40.7979409854977 | 41E-AM-1007-01 | 41E | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | white haunches | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9540022445432 40.7979409854977) | 19 | 4 | 19 | 13 | ||||
1064 | 1064 | -73.9540257319561 | 40.798408619116 | 42E-PM-1012-02 | 42E | PM | 10122018 | 2 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | true | false | true | false | false | false | false | false | false | false | false | true | true | POINT (-73.9540257319561 40.798408619116) | 19 | 4 | 19 | 13 | |||||||
1103 | 1103 | -73.9541500874008 | 40.7920329989756 | 35H-AM-1013-02 | 35H | AM | 10132018 | 2 | Juvenile | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 10 | Sitting on tree limb | false | false | false | false | false | sitting | false | false | false | false | false | false | true | false | watching me from tree,but calm | POINT (-73.9541500874008 40.7920329989756) | 19 | 4 | 19 | 13 | ||
2958 | 2958 | -73.9541748083177 | 40.7952758442897 | 39F-PM-1006-01 | 39F | PM | 10062018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | carrying leaves | false | false | false | false | false | false | true | false | POINT (-73.9541748083177 40.7952758442897) | 19 | 4 | 19 | 13 | |||||
1870 | 1870 | -73.9542118614769 | 40.7939171395463 | 37G-AM-1014-06 | 37G | AM | 10142018 | 6 | Adult | Gray | White | Gray+White | White tail | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.95421186147692 40.7939171395463) | 19 | 4 | 19 | 13 | ||||
1924 | 1924 | -73.9542332505231 | 40.7933475171434 | 37G-AM-1014-01 | 37G | AM | 10142018 | 1 | Adult | Gray | White | Gray+White | White tail | Above Ground | 5 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9542332505231 40.7933475171434) | 19 | 4 | 19 | 13 | ||||
1246 | 1246 | -73.9543044385367 | 40.7984498571338 | 41E-AM-1007-04 | 41E | AM | 10072018 | 4 | Adult | Cinnamon | White | Cinnamon+White | white haunches/tail | Ground Plane | FALSE | rubbing belly on ground | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9543044385367 40.798449857133804) | 19 | 4 | 19 | 13 | |||
2063 | 2063 | -73.9544763281886 | 40.7969645476349 | 40F-PM-1006-03 | 40F | PM | 10062018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9544763281886 40.7969645476349) | 19 | 4 | 19 | 13 | |||||
478 | 478 | -73.954482814186 | 40.7987031768001 | 42D-PM-1013-01 | 42D | PM | 10132018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Drawing included. | Ground Plane | FALSE | false | false | false | false | true | watching passers-by | false | false | false | false | false | true | true | false | POINT (-73.954482814186 40.7987031768001) | 19 | 4 | 19 | 13 | |||
1458 | 1458 | -73.9545037193355 | 40.7900225055417 | 33I-PM-1006-04 | 33I | PM | 10062018 | 4 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9545037193355 40.7900225055417) | 19 | 4 | 19 | 13 | ||||||
1710 | 1710 | -73.9545438656122 | 40.7902168635009 | 34I-AM-1012-04 | 34I | AM | 10122018 | 4 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9545438656122 40.7902168635009) | 19 | 4 | 19 | 13 | |||||
1483 | 1483 | -73.9545773579075 | 40.7898684635744 | 33I-AM-1008-05 | 33I | AM | 10082018 | 5 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | nearly dropped shell on my head! | POINT (-73.9545773579075 40.7898684635744) | 19 | 4 | 19 | 13 | ||||||
1309 | 1309 | -73.9545841828392 | 40.7926924268376 | 36H-AM-1010-01 | 36H | AM | 10102018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9545841828392 40.7926924268376) | 19 | 4 | 19 | 13 | |||||
1603 | 1603 | -73.9545929242174 | 40.7986940168685 | 42D-AM-1014-02 | 42D | AM | 10142018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Gray & Cinnamon selected as Primary. White selected as Highlights. Made executive adjustments. | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9545929242174 40.7986940168685) | 19 | 4 | 19 | 13 | ||||
823 | 823 | -73.954595058342 | 40.7956567934304 | 39F-AM-1014-04 | 39F | AM | 10142018 | 4 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.954595058342 40.7956567934304) | 19 | 4 | 19 | 13 | |||||
1310 | 1310 | -73.9546201403481 | 40.7989423768656 | 42D-AM-1014-03 | 42D | AM | 10142018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9546201403481 40.7989423768656) | 19 | 4 | 19 | 13 | |||||
1820 | 1820 | -73.9546337446865 | 40.7898772579576 | 33I-PM-1006-08 | 33I | PM | 10062018 | 8 | Adult | Gray | Gray+ | Above Ground | 6 | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9546337446865 40.7898772579576) | 19 | 4 | 19 | 13 | ||||||
1993 | 1993 | -73.9546367558712 | 40.789840987798 | 33I-AM-1008-04 | 33I | AM | 10082018 | 4 | Adult | + | Above Ground | 100 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9546367558712 40.789840987798) | 19 | 4 | 19 | 13 | |||||||
74 | 74 | -73.9546654184146 | 40.7947639241491 | 38G-PM-1020-09 | 38G | PM | 10202018 | 9 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | true | false | false | true | false | POINT (-73.9546654184146 40.7947639241491) | 19 | 4 | 19 | 13 | |||||
2480 | 2480 | -73.9546780963388 | 40.7903216522111 | 34I-AM-1012-03 | 34I | AM | 10122018 | 3 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | false | false | nut in mouth | false | false | false | false | false | false | true | false | POINT (-73.9546780963388 40.7903216522111) | 19 | 4 | 19 | 13 | ||||
1895 | 1895 | -73.954699659637 | 40.7951308856929 | 38F-AM-1018-02 | 38F | AM | 10182018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.954699659637 40.7951308856929) | 19 | 4 | 19 | 13 | |||||
1689 | 1689 | -73.9547031549299 | 40.7978867539322 | 41E-PM-1013-01 | 41E | PM | 10132018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | true | false | false | false | false | false | false | false | false | false | false | true | false | POINT (-73.9547031549299 40.7978867539322) | 19 | 4 | 19 | 13 | |||||
2146 | 2146 | -73.9547398684817 | 40.7896483795302 | 33I-AM-1008-01 | 33I | AM | 10082018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | edge of park @ 98th (north) | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9547398684817 40.7896483795302) | 19 | 4 | 19 | 13 | ||||
546 | 546 | -73.9547423290276 | 40.7899702628835 | 33I-PM-1006-09 | 33I | PM | 10062018 | 9 | Adult | Black | Black+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9547423290276 40.7899702628835) | 19 | 4 | 19 | 13 | ||||||
2493 | 2493 | -73.954767265558 | 40.7973243644491 | 40E-PM-1017-03 | 40E | PM | 10172018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.954767265558 40.7973243644491) | 19 | 4 | 19 | 13 | |||||
2258 | 2258 | -73.9547785081171 | 40.789612183711 | 33I-AM-1008-02 | 33I | AM | 10082018 | 2 | Adult | Gray | Gray+ | Above Ground | 3 | edge of park @ 98th | false | false | true | false | false | false | false | false | false | true | false | true | false | POINT (-73.9547785081171 40.789612183711) | 19 | 4 | 19 | 13 | |||||
456 | 456 | -73.9547878025303 | 40.7899151873467 | 33I-PM-1006-05 | 33I | PM | 10062018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9547878025303 40.7899151873467) | 19 | 4 | 19 | 13 | ||||||
953 | 953 | -73.9547959269955 | 40.7925162926273 | 36H-PM-1008-01 | 36H | PM | 10082018 | 1 | Adult | Gray | White | Gray+White | white belly | Above Ground | 20 | true | false | true | false | true | true | true | false | false | false | false | true | false | POINT (-73.9547959269955 40.7925162926273) | 19 | 4 | 19 | 13 | ||||
1514 | 1514 | -73.9548006161673 | 40.7945503341011 | 38G-PM-1020-08 | 38G | PM | 10202018 | 8 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | true | false | false | true | false | false | true | false | POINT (-73.9548006161673 40.7945503341011) | 19 | 4 | 19 | 13 | |||||
1394 | 1394 | -73.95488263914 | 40.7959474571251 | 39F-AM-1014-05 | 39F | AM | 10142018 | 5 | Juvenile | Cinnamon | Cinnamon+ | Above Ground | 2 | up/down tree | true | false | true | false | true | false | false | false | false | true | false | true | false | POINT (-73.95488263914 40.7959474571251) | 19 | 4 | 19 | 13 | |||||
370 | 370 | -73.9548957862084 | 40.7944844464619 | 37G-AM-1014-05 | 37G | AM | 10142018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9548957862084 40.7944844464619) | 19 | 4 | 19 | 13 | ||||||
460 | 460 | -73.9549135206961 | 40.798525897229 | 42D-PM-1013-03 | 42D | PM | 10132018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | in tree | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.9549135206961 40.798525897229) | 19 | 4 | 19 | 13 | ||||
279 | 279 | -73.9550082056509 | 40.7894521543449 | 33I-AM-1008-03 | 33I | AM | 10082018 | 3 | Adult | Gray | Gray+ | Above Ground | 2 | 98th @ edge of park | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9550082056509 40.7894521543449) | 19 | 4 | 19 | 13 | |||||
2504 | 2504 | -73.9550131837533 | 40.7958617258176 | 39E-PM-1013-02 | 39E | PM | 10132018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Gray tail & butt | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | false | POINT (-73.9550131837533 40.7958617258176) | 19 | 4 | 19 | 13 | ||||
679 | 679 | -73.955018489069 | 40.7971235333699 | 40E-PM-1017-02 | 40E | PM | 10172018 | 2 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | false | false | false | false | false | false | false | true | false | POINT (-73.955018489069 40.7971235333699) | 19 | 4 | 19 | 13 | |||||
93 | 93 | -73.9551539498306 | 40.7987384656256 | 41D-AM-1014-01 | 41D | AM | 10142018 | 1 | Adult | Gray | Black | Gray+Black | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9551539498306 40.7987384656256) | 19 | 4 | 19 | 13 | ||||
2721 | 2721 | -73.9551923408239 | 40.7968302661402 | 40E-PM-1017-01 | 40E | PM | 10172018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9551923408239 40.7968302661402) | 19 | 4 | 19 | 13 | |||||
1017 | 1017 | -73.9552035011902 | 40.7889851896334 | 32I-AM-1013-06 | 32I | AM | 10132018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Above Ground | 3 | In and below shrub | false | false | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9552035011902 40.7889851896334) | 19 | 4 | 19 | 13 | ||||
2851 | 2851 | -73.955208233231 | 40.7890574331084 | 32I-PM-1007-02 | 32I | PM | 10072018 | 2 | Adult | + | Above Ground | 30 | false | false | true | false | false | different sound - happy,playful chirps | false | false | false | false | true | false | true | false | POINT (-73.955208233231 40.7890574331084) | 19 | 4 | 19 | 13 | ||||||
1301 | 1301 | -73.9552146665714 | 40.7892909102377 | 32I-PM-1007-03 | 32I | PM | 10072018 | 3 | Adult | Gray | Gray+ | small adult | Above Ground | 20 | false | false | true | false | false | false | false | false | false | false | false | true | false | POINT (-73.9552146665714 40.7892909102377) | 19 | 4 | 19 | 13 | |||||
2833 | 2833 | -73.9552595564798 | 40.7889533029466 | 32I-PM-1007-01 | 32I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | true | true | chirps | false | false | false | false | true | false | true | false | POINT (-73.9552595564798 40.7889533029466) | 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 );