According to this interactive New York Times map, Columbia County is deeply and irreconcilably divided: 47% of residents root for the New York Yankees, and 32% for the Boston Red Sox. (The Mets rate a lowly 8%.)
As you zoom in, the breakdowns can be reviewed by ZIP code. Not surprisingly, the percentages for the Yankees increase as you head further south and west, and for Red Sox as you head further to the northeast.
P.S. Go Sox!