This data as json, CSV (advanced)
Suggested facets: Shift, Age, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Color notes, Location, Above Ground Sighter Measurement, Running, Chasing, Climbing, Eating, Other Activities, Tail flags, Tail twitches, Approaches, Runs from, Other Interactions, Zip Codes, Community Districts, City Council Districts
Specific Location ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2241 | 2241 | -73.9575258627966 | 40.787715550749 | 30H-AM-1007-03 | 30H | AM | 10072018 | 3 | Adult | Cinnamon | Cinnamon+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9575258627966 40.787715550749) | 19 | 4 | 19 | 13 | ||||||
1843 | 1843 | -73.9685940262068 | 40.776932102013 | 15F-AM-1007-07 | 15F | AM | 10072018 | 7 | Adult | Cinnamon | Black | Cinnamon+Black | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9685940262068 40.776932102013) | 19 | 4 | 19 | 13 | |||||
685 | 685 | -73.9658181813014 | 40.7798160637561 | 19F-AM-1007-01 | 19F | AM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | bit scared | POINT (-73.9658181813014 40.7798160637561) | 19 | 4 | 19 | 13 | ||||
687 | 687 | -73.9636971843665 | 40.7825638537362 | 22F-AM-1007-04 | 22F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9636971843665 40.7825638537362) | 19 | 4 | 19 | 13 | |||||||
971 | 971 | -73.978392591149 | 40.7668993398193 | 1D-PM-1007-04 | 01D | PM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.978392591149 40.7668993398193) | 19 | 4 | 19 | 13 | |||||
1056 | 1056 | -73.9811078442462 | 40.767515940567 | 1A-AM-1007-04 | 01A | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9811078442462 40.767515940567) | 12081 | 11 | 4 | 51 | 10 | ||||
1067 | 1067 | -73.9695305996721 | 40.7745386896959 | 12F-PM-1007-02 | 12F | PM | 10072018 | 2 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | false | true | false | POINT (-73.9695305996721 40.7745386896959) | 19 | 4 | 19 | 13 | |||||
1457 | 1457 | -73.9697744662785 | 40.7755950428973 | 13F-AM-1007-04 | 13F | AM | 10072018 | 4 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697744662785 40.7755950428973) | 19 | 4 | 19 | 13 | |||||
1513 | 1513 | -73.9662409997642 | 40.7891042935432 | 28A-PM-1007-03 | 28A | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | true | false | true | true | chasing #2 took #2 food wrapper and is foraging through it | false | false | false | false | false | false | true | false | POINT (-73.9662409997642 40.7891042935432) | 19 | 4 | 19 | 13 | ||||
2075 | 2075 | -73.9636234953334 | 40.7775138547689 | 18I-PM-1007-06 | 18I | PM | 10072018 | 6 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | digging | false | false | false | false | false | false | true | false | POINT (-73.9636234953334 40.7775138547689) | 19 | 4 | 19 | 13 | ||||
2184 | 2184 | -73.9694938608335 | 40.7745700102115 | 12F-PM-1007-03 | 12F | PM | 10072018 | 3 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9694938608335 40.7745700102115) | 19 | 4 | 19 | 13 | |||||
2943 | 2943 | -73.962534856258 | 40.7812134517411 | 22H-PM-1007-01 | 22H | PM | 10072018 | 1 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.962534856258 40.7812134517411) | 19 | 4 | 19 | 13 | |||||
3003 | 3003 | -73.9698663926657 | 40.773999710413 | 12F-PM-1007-09 | 12F | PM | 10072018 | 9 | Adult | Cinnamon | Gray | Cinnamon+Gray | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698663926657 40.773999710413) | 19 | 4 | 19 | 13 | |||||
2891 | 2891 | -73.9636482556874 | 40.7775831570186 | 18I-PM-1007-05 | 18I | PM | 10072018 | 5 | Juvenile | Cinnamon | Gray, Black | Cinnamon+Gray, Black | Ground Plane | FALSE | false | false | false | false | true | jumping crazily / digging hole | false | false | false | false | false | false | true | false | POINT (-73.9636482556874 40.7775831570186) | 19 | 4 | 19 | 13 | ||||
68 | 68 | -73.9694240327509 | 40.7755898126674 | 13F-AM-1007-02 | 13F | AM | 10072018 | 2 | Adult | Cinnamon | White | Cinnamon+White | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.96942403275091 40.7755898126674) | 19 | 4 | 19 | 13 | |||||||
800 | 800 | -73.9682144039334 | 40.7773070675393 | 15F-AM-1007-08 | 15F | AM | 10072018 | 8 | Adult | Cinnamon | White | Cinnamon+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9682144039334 40.7773070675393) | 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 | |||
2732 | 2732 | -73.9694185786221 | 40.7787189999566 | 16D-AM-1007-06 | 16D | AM | 10072018 | 6 | Adult | Cinnamon | White | Cinnamon+White | primary color: brown ( I marked cinnamon as closest to brown - JO) | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9694185786221 40.7787189999566) | 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 | ||||||
192 | 192 | -73.9651654887991 | 40.7777806006951 | 17H-PM-1007-02 | 17H | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9651654887991 40.7777806006951) | 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 | ||||||
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 | ||||||
892 | 892 | -73.9611368390233 | 40.7815619053395 | 22I-AM-1007-02 | 22I | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9611368390233 40.7815619053395) | 19 | 4 | 19 | 13 | ||||||
912 | 912 | -73.958024711869 | 40.7938724278575 | 36D-PM-1007-01 | 36D | PM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.958024711869 40.7938724278575) | 19 | 4 | 19 | 13 | ||||||
1190 | 1190 | -73.9728069355821 | 40.7794458131748 | 15A-AM-1007-01 | 15A | AM | 10072018 | 1 | Adult | Gray | Gray+ | tbd | Ground Plane | FALSE | false | false | false | false | true | hopping | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9728069355821 40.7794458131748) | 19 | 4 | 19 | 13 | |||
1228 | 1228 | -73.9729090336637 | 40.7794340052503 | 15A-AM-1007-02 | 15A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | in fenced in lawn (chill) | POINT (-73.9729090336637 40.7794340052503) | 19 | 4 | 19 | 13 | |||||
1321 | 1321 | -73.9699285688296 | 40.7774474015189 | 15D-AM-1007-08 | 15D | AM | 10072018 | 8 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | true | false | false | true | chasing #7 | false | false | false | false | false | false | true | false | POINT (-73.9699285688296 40.7774474015189) | 19 | 4 | 19 | 13 | |||||
1612 | 1612 | -73.9746049088475 | 40.7728776887397 | 8C-AM-1007-01 | 08C | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | behind fence, safe | true | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9746049088475 40.7728776887397) | 19 | 4 | 19 | 13 | |||||
1647 | 1647 | -73.9795585338537 | 40.768895893226 | 3B-PM-1007-08 | 03B | PM | 10072018 | 8 | Juvenile | Gray | Gray+ | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9795585338537 40.768895893226) | 19 | 4 | 19 | 13 | ||||||
1713 | 1713 | -73.97977158132 | 40.7706273151066 | 4A-AM-1007-01 | 04A | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.97977158132 40.7706273151066) | 19 | 4 | 19 | 13 | ||||||
1724 | 1724 | -73.9795492724533 | 40.7709497471738 | 4A-AM-1007-02 | 04A | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9795492724533 40.7709497471738) | 19 | 4 | 19 | 13 | ||||||
1729 | 1729 | -73.9765046109019 | 40.7736674124746 | 8B-AM-1007-04 | 08B | AM | 10072018 | 4 | Adult | Gray | Gray+ | Above Ground | 2 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9765046109019 40.7736674124746) | 19 | 4 | 19 | 13 | ||||||
2230 | 2230 | -73.9730813162152 | 40.7779315720879 | 14B-AM-1007-02 | 14B | AM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9730813162152 40.7779315720879) | 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 | ||||||
2359 | 2359 | -73.9700785314537 | 40.777714111862 | 15D-AM-1007-01 | 15D | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9700785314537 40.777714111862) | 19 | 4 | 19 | 13 | ||||||
2360 | 2360 | -73.9573325001041 | 40.7874662104558 | 30H-AM-1007-01 | 30H | AM | 10072018 | 1 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9573325001041 40.7874662104558) | 19 | 4 | 19 | 13 | ||||||
2486 | 2486 | -73.9766317094163 | 40.7734230472026 | 8B-AM-1007-05 | 08B | AM | 10072018 | 5 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9766317094163 40.7734230472026) | 19 | 4 | 19 | 13 | ||||||
2670 | 2670 | -73.9531041906469 | 40.7919916819219 | 36I-PM-1007-02 | 36I | PM | 10072018 | 2 | Adult | Gray | Gray+ | Ground Plane | FALSE | true | true | false | false | true | false | false | false | false | true | true | true | false | chased birds (blue jay) | POINT (-73.9531041906469 40.7919916819219) | 19 | 4 | 19 | 13 | |||||
2686 | 2686 | -73.9775571403892 | 40.7665316585198 | 1E-PM-1007-03 | 01E | PM | 10072018 | 3 | Adult | Gray | Gray+ | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9775571403892 40.7665316585198) | 19 | 4 | 19 | 13 | ||||||
2791 | 2791 | -73.9593624259363 | 40.7905522356793 | 32E-AM-1007-02 | 32E | AM | 10072018 | 2 | Adult | Gray | Gray+ | Above Ground | 40 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9593624259363 40.7905522356793) | 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 | |||||
97 | 97 | -73.9639744005647 | 40.7825111950764 | 22F-AM-1007-01 | 22F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9639744005647 40.7825111950764) | 19 | 4 | 19 | 13 | |||||
132 | 132 | -73.9696433533986 | 40.7828208083804 | 20B-AM-1007-01 | 20B | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | quietly | false | false | false | false | false | false | true | false | POINT (-73.9696433533986 40.7828208083804) | 19 | 4 | 19 | 13 | ||||
161 | 161 | -73.9649632550828 | 40.7809187761995 | 20F-PM-1007-01 | 20F | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | cinnamon tail | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9649632550828 40.7809187761995) | 19 | 4 | 19 | 13 | ||||
190 | 190 | -73.9695507965155 | 40.7743070423435 | 12F-PM-1007-04 | 12F | PM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | stared | POINT (-73.96955079651552 40.7743070423435) | 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 | |||||
398 | 398 | -73.9686737866872 | 40.7739714023732 | 12G-PM-1007-06 | 12G | PM | 10072018 | 6 | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686737866872 40.7739714023732) | 19 | 4 | 19 | 13 | ||||||||
831 | 831 | -73.9587712679442 | 40.7944502501428 | 36D-PM-1007-02 | 36D | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | true | true | false | POINT (-73.9587712679442 40.7944502501428) | 19 | 4 | 19 | 13 | |||||
1063 | 1063 | -73.9750346778281 | 40.7665404404824 | 2G-PM-1007-01 | 02G | 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.9750346778281 40.7665404404824) | 19 | 4 | 19 | 13 | |||||
1169 | 1169 | -73.9570391901515 | 40.7930697207834 | 35F-AM-1007-01 | 35F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | true | false | true | false | POINT (-73.9570391901515 40.7930697207834) | 19 | 4 | 19 | 13 | |||||
1216 | 1216 | -73.9707245013626 | 40.7780656588337 | 15D-AM-1007-06 | 15D | AM | 10072018 | 6 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9707245013626 40.7780656588337) | 19 | 4 | 19 | 13 | |||||
1326 | 1326 | -73.9747288122551 | 40.7659918747507 | 2G-PM-1007-03 | 02G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9747288122551 40.7659918747507) | 19 | 4 | 19 | 13 | |||||
1425 | 1425 | -73.9586252875856 | 40.7852027586217 | 27I-AM-1007-03 | 27I | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | had .5 of a tail | Above Ground | 20 | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9586252875856 40.7852027586217) | 19 | 4 | 19 | 13 | ||||
1544 | 1544 | -73.9642111283068 | 40.7777713985327 | 18I-PM-1007-07 | 18I | PM | 10072018 | 7 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9642111283068 40.7777713985327) | 19 | 4 | 19 | 13 | |||||
1609 | 1609 | -73.9639024988123 | 40.7776953065849 | 18I-PM-1007-01 | 18I | PM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 25 | false | false | true | true | true | hanging upside down | false | false | false | false | false | false | true | false | POINT (-73.9639024988123 40.7776953065849) | 19 | 4 | 19 | 13 | ||||
1616 | 1616 | -73.9642666013207 | 40.7810384867375 | 21G-PM-1007-03 | 21G | PM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.96426660132072 40.7810384867375) | 19 | 4 | 19 | 13 | |||||
1906 | 1906 | -73.9700066659086 | 40.7744028820163 | 12F-PM-1007-13 | 12F | PM | 10072018 | 13 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9700066659086 40.7744028820163) | 19 | 4 | 19 | 13 | |||||
2220 | 2220 | -73.963716747038 | 40.7892160137944 | 29C-AM-1007-01 | 29C | AM | 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.96371674703802 40.7892160137944) | 19 | 4 | 19 | 13 | |||||
2222 | 2222 | -73.9639048209454 | 40.7777373345558 | 18I-PM-1007-02 | 18I | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Above Ground | 12 | false | false | true | true | true | hanging upside down | false | false | false | false | false | false | true | false | POINT (-73.9639048209454 40.7777373345558) | 19 | 4 | 19 | 13 | ||||
2260 | 2260 | -73.9784685928652 | 40.7669924015341 | 1D-PM-1007-05 | 01D | PM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9784685928652 40.7669924015341) | 19 | 4 | 19 | 13 | |||||
2305 | 2305 | -73.9679833225379 | 40.7738547093402 | 12H-PM-1007-05 | 12H | PM | 10072018 | 5 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9679833225379 40.7738547093402) | 19 | 4 | 19 | 13 | ||||||
2321 | 2321 | -73.9743060404813 | 40.7687901781431 | 5F-PM-1007-02 | 05F | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9743060404813 40.7687901781431) | 19 | 4 | 19 | 13 | |||||
2424 | 2424 | -73.9684752839242 | 40.7765816261518 | 15F-AM-1007-01 | 15F | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | true | false | false | true | true | false | false | false | false | false | false | true | true | POINT (-73.9684752839242 40.7765816261518) | 19 | 4 | 19 | 13 | ||||
2448 | 2448 | -73.9668230576555 | 40.7870637233327 | 25B-PM-1007-02 | 25B | PM | 10072018 | 2 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9668230576555 40.7870637233327) | 19 | 4 | 19 | 13 | |||||
2537 | 2537 | -73.9735533713513 | 40.7690605609001 | 5F-PM-1007-05 | 05F | PM | 10072018 | 5 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9735533713513 40.7690605609001) | 19 | 4 | 19 | 13 | |||||
2679 | 2679 | -73.9794481602391 | 40.770638572864 | 4A-AM-1007-03 | 04A | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9794481602391 40.770638572864) | 19 | 4 | 19 | 13 | |||||
2695 | 2695 | -73.962800448652 | 40.7915532640139 | 31B-PM-1007-03 | 31B | PM | 10072018 | 3 | Juvenile | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.962800448652 40.7915532640139) | 19 | 4 | 19 | 13 | |||||
2737 | 2737 | -73.9703683510176 | 40.7743975363958 | 12F-PM-1007-10 | 12F | PM | 10072018 | 10 | Adult | Gray | Cinnamon | Gray+Cinnamon | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9703683510176 40.7743975363958) | 19 | 4 | 19 | 13 | |||||||
2771 | 2771 | -73.9735383602914 | 40.7723124703937 | 8D-AM-1007-01 | 08D | AM | 10072018 | 1 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | acknowledged me though | POINT (-73.9735383602914 40.7723124703937) | 19 | 4 | 19 | 13 | ||||
2789 | 2789 | -73.9686800784941 | 40.7766739029138 | 15F-AM-1007-03 | 15F | AM | 10072018 | 3 | Adult | Gray | Cinnamon | Gray+Cinnamon | Listed as primary white with cinnamon highlights, I changed to Gray/cinnamon - JO | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9686800784941 40.7766739029138) | 19 | 4 | 19 | 13 | ||||
2828 | 2828 | -73.9587439756541 | 40.7849006107353 | 27I-AM-1007-04 | 27I | AM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | true | POINT (-73.9587439756541 40.7849006107353) | 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 | ||||
2961 | 2961 | -73.9736238258579 | 40.7688712771191 | 5F-PM-1007-04 | 05F | PM | 10072018 | 4 | Adult | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9736238258579 40.7688712771191) | 19 | 4 | 19 | 13 | |||||
2995 | 2995 | -73.9668442742942 | 40.7870781042595 | 25B-PM-1007-01 | 25B | PM | 10072018 | 1 | Gray | Cinnamon | Gray+Cinnamon | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9668442742942 40.7870781042595) | 19 | 4 | 19 | 13 | ||||||
489 | 489 | -73.97780296909 | 40.7676321060669 | 2D-AM-1007-06 | 02D | AM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.97780296909002 40.767632106066905) | 19 | 4 | 19 | 13 | |||||
714 | 714 | -73.9691585756191 | 40.776340465695 | 14F-AM-1007-03 | 14F | AM | 10072018 | 3 | 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.9691585756191 40.776340465695) | 19 | 4 | 19 | 13 | |||||
848 | 848 | -73.9692190295442 | 40.7763366309154 | 14F-AM-1007-02 | 14F | AM | 10072018 | 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.9692190295442 40.7763366309154) | 19 | 4 | 19 | 13 | |||||
901 | 901 | -73.9702228131711 | 40.7742131587983 | 12F-PM-1007-12 | 12F | PM | 10072018 | 12 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Above Ground | 5 | false | false | false | false | true | going down tree | false | false | false | false | false | false | true | false | POINT (-73.9702228131711 40.7742131587983) | 19 | 4 | 19 | 13 | ||||
976 | 976 | -73.9740381194088 | 40.7675912588173 | 4G-PM-1007-01 | 04G | PM | 10072018 | 1 | 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.9740381194088 40.7675912588173) | 19 | 4 | 19 | 13 | |||||
1910 | 1910 | -73.9699876501742 | 40.7742482676758 | 12F-PM-1007-06 | 12F | PM | 10072018 | 6 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | false | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699876501742 40.77424826767581) | 19 | 4 | 19 | 13 | |||||
2187 | 2187 | -73.9699134052609 | 40.774446589038 | 12F-PM-1007-14 | 12F | PM | 10072018 | 14 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | true | true | true | false | false | false | false | false | true | true | false | POINT (-73.9699134052609 40.774446589038) | 19 | 4 | 19 | 13 | |||||
2210 | 2210 | -73.9699124811406 | 40.7743016981538 | 12F-PM-1007-07 | 12F | PM | 10072018 | 7 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | true | true | false | true | false | false | false | true | false | false | true | false | POINT (-73.9699124811406 40.7743016981538) | 19 | 4 | 19 | 13 | |||||
2508 | 2508 | -73.979381450452 | 40.7709033697887 | 4A-PM-1007-01 | 04A | PM | 10072018 | 1 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | true | false | true | true | true | false | false | false | false | true | false | true | false | POINT (-73.979381450452 40.770903369788705) | 19 | 4 | 19 | 13 | |||||
2579 | 2579 | -73.9698130452581 | 40.7745000645436 | 12F-PM-1007-15 | 12F | PM | 10072018 | 15 | Adult | Gray | Cinnamon, White | Gray+Cinnamon, White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9698130452581 40.7745000645436) | 19 | 4 | 19 | 13 | |||||
2760 | 2760 | -73.9701808122548 | 40.7744632730919 | 12F-PM-1007-11 | 12F | PM | 10072018 | 11 | 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.9701808122548 40.7744632730919) | 19 | 4 | 19 | 13 | |||||
3001 | 3001 | -73.9775592228416 | 40.7668485329273 | 1D-PM-1007-01 | 01D | PM | 10072018 | 1 | 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.9775592228416 40.7668485329273) | 19 | 4 | 19 | 13 | |||||
73 | 73 | -73.96148483609 | 40.7922645521905 | 33C-PM-1007-03 | 33C | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.96148483609 40.7922645521905) | 19 | 4 | 19 | 13 | |||||
437 | 437 | -73.9793952066038 | 40.7707837657859 | 4A-PM-1007-03 | 04A | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | by rock | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9793952066038 40.77078376578591) | 19 | 4 | 19 | 13 | ||||
468 | 468 | -73.9780659679557 | 40.7672382282781 | 1D-PM-1007-06 | 01D | PM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9780659679557 40.7672382282781) | 19 | 4 | 19 | 13 | |||||
475 | 475 | -73.9697855573137 | 40.7742186391935 | 12F-PM-1007-05 | 12F | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | true | true | false | false | false | false | false | false | true | false | POINT (-73.9697855573137 40.7742186391935) | 19 | 4 | 19 | 13 | |||||
694 | 694 | -73.9698032734704 | 40.7782343912417 | 16D-AM-1007-02 | 16D | AM | 10072018 | 2 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9698032734704 40.7782343912417) | 19 | 4 | 19 | 13 | |||||
750 | 750 | -73.9699672074164 | 40.7774389345748 | 15D-AM-1007-07 | 15D | AM | 10072018 | 7 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | true | false | false | true | chasing #8 | false | false | false | false | false | false | true | false | POINT (-73.9699672074164 40.7774389345748) | 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 | ||||
1498 | 1498 | -73.9765064169087 | 40.7737211426714 | 8B-AM-1007-06 | 08B | AM | 10072018 | 6 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9765064169087 40.7737211426714) | 19 | 4 | 19 | 13 | |||||
1660 | 1660 | -73.9800499498034 | 40.7702181099573 | 4A-PM-1007-05 | 04A | PM | 10072018 | 5 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | At rock | false | false | false | false | true | false | false | false | true | true | false | true | false | POINT (-73.9800499498034 40.770218109957305) | 19 | 4 | 19 | 13 | ||||
1671 | 1671 | -73.9611399573659 | 40.781130706026 | 22I-AM-1007-01 | 22I | AM | 10072018 | 1 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9611399573659 40.781130706026005) | 19 | 4 | 19 | 13 | |||||
1730 | 1730 | -73.9796142848349 | 40.7702117898305 | 4A-PM-1007-04 | 04A | PM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | true | false | true | false | POINT (-73.9796142848349 40.7702117898305) | 19 | 4 | 19 | 13 | |||||
1851 | 1851 | -73.9623621412501 | 40.7814673556041 | 22H-PM-1007-03 | 22H | PM | 10072018 | 3 | Adult | Gray | White | Gray+White | Above Ground | 4 | chased squirrel #2 away | false | false | true | false | true | false | false | false | false | false | false | true | false | POINT (-73.9623621412501 40.7814673556041) | 19 | 4 | 19 | 13 | ||||
2704 | 2704 | -73.9657764490284 | 40.7811923229286 | 20F-PM-1007-10 | 20F | PM | 10072018 | 10 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9657764490284 40.7811923229286) | 19 | 4 | 19 | 13 | |||||
2906 | 2906 | -73.9597260014375 | 40.790707423031 | 32E-AM-1007-04 | 32E | AM | 10072018 | 4 | Adult | Gray | White | Gray+White | Ground Plane | FALSE | false | false | false | false | true | false | false | false | false | false | false | true | false | POINT (-73.9597260014375 40.790707423031) | 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 );