Clinton Has a Spreadsheet of Dems Who Crossed Her John Kerry, Ted Kennedy listed as '7s' By Kevin Spak, Newser Staff Posted Jan 13, 2014 7:30 AM CST 155 comments Comments In this Dec. 6, 2013 file photo, former Secretary of State Hillary Rodham Clinton speaks on Capitol Hill. (AP Photo/Susan Walsh, File) (Newser) – Hillary Clinton doesn't just remember who her friends and enemies are—she has a database. As her 2008 campaign wound down, two of her closest advisers created what Jonathan Allen and Amie Parnes dramatically term a "political hit list" in an excerpt from their new book at Politico today. The spreadsheet documented not only which Democrats had and hadn't endorsed her, but any favors they'd done, extenuating circumstances, and, at one point, a betrayal rating on a 1-7 scale. Here are some of the known 7s: Claire McCaskill—"Hate is too weak a word to describe the feelings that Hillary’s core loyalists still have for McCaskill," Allen and Parnes write. The Clintons supported her in 2006 (as did Obama), but she coordinated her endorsement of Obama with two other women for maximum effect. Ted Kennedy—Delivered a pivotal Obama endorsement right before Super Tuesday. Years later, an aide joked about the fate of Hillary's foes saying, "Bill Richardson: investigated; John Edwards: disgraced by scandal; Chris Dodd: stepped down. Ted Kennedy: dead." Also on the list: John Kerry, Patrick Leahy, Bob Casey, Chris Van Hollen, and Jay Rockefeller. Of course, every politician keeps track of their allies—it's the scope of the Clintons' sphere that makes it unusual. "It wasn’t so much punishing as rewarding," one source said. "I honestly think that’s an important subtlety in Bill Clinton, in his head. She’s not as calculated, but he is." Other Clinton aides likewise downplayed the "enemy" half of the list. "I don't want to make her sound like Nixon in a pantsuit." It's worth noting that this isn't the first time the fabled list has been reported on.