The election of 2012 saw an important shift in the way politics is conducted and in the way it is covered by the media. Whether we’re looking at President Obama’s team of number-crunchers or the rise of Nate Silver’s 538 Blog, politics is more quantitative than ever. For the most serious political thinkers, polls and numbers are one of the the most important tools of political analysis. But, this is Overthinking It, so we have to ask: can we use these tools to look at fictional Presidents? How does our most famous pop-culture Commander in Chief stack up against real-life Presidents?

For 7 years beginning in1999, “The West Wing” was the most prominent pop-culture portrayal of Presidential power and of politics. For fans of the show, President Bartlet was the kind of President we could only dream of having. The show was on for more than 100 episodes, and like any real-life POTUS, he guarded his approval rating jealously. With that much data out there, I set out to chart President Bartlet’s approval rating over this first term, and compare it to the modern era of U.S. Presidents.

Methodology

Before I dive in, I’d like to discuss how I arrived at the data. First of all, I focused only on Bartlet’s first term in office, taking it through the half-way point of Season 4. Seasons 5-7 just didn’t have enough data to make much headway – mentions of approval rating disappeared almost entirely. I also made one major assumption: that any event significant enough to move the needle more than a few points would have been portrayed in an episode – it’s unlikely that we fought a major war or the administration suffered a major scandal that happened entirely off-screen.

I’ve got a more detailed description of my methodology below, but if you want to skip right to the graph, the basic process was:

Find all explicit mentions of approval rating in the transcripts Make a subjective judgment for each episode whether the approval rating was like to go up or down following the events of the episode Interpolate between that data Add some noise to make it look more realistic

If you want to know more, read on, otherwise you can skip to “Analysis” below.

I used the “West Wing Transcripts” website and scoured them for any mention of “Approval”, “Points”, “Percent”, etc. I am fairly certain that I got all explicit mentions of where the approval rating was, but it’s possible that it was discussed colloquially in a way that did not come up in my search – if you find one, please let me know in the comments. All told, I found 13 explicit mentions of the President’s approval rating, spread out over his first four years (there is also a flashback to the first few weeks in office that provided two data point.)

After finding all of those mentions I matched the episodes up with a timeline of the administration. The series creators have said that there intention was not to peg the Bartlet administration to any specific year, but that ship sailed when Sam Seaborne talks about using a particular room for the “Millennial Celebration.” I assumed that the years of the show matched up with the years of the Presidency, and I relied extensively on the work already done at the “Unofficial Continuity Guide.” Some episodes have very specific events that date them (Holidays, the Inauguration, etc.), and those served as anchors for the rest of the timeline. For episodes without those markers, I assumed that the air-date was the same as the “In-universe” dates, excepting times where this would have been inconsistent with one of the in-universe cues.

There is one big inconsistency that I ultimately had to make a subjective choice on – the Season One Finale (“What Kind of Day Has it Been”) aired in May and appears to have occurred around that time because it comes just one week after a string of spring episodes (starting with “Let Bartlet be Bartlet.”) In the Season Two Premiere (“Midterms”), however, it’s stated that the assassination occurred 14 weeks before Election day, placing the shooting in August. In the end, I just had to pick one and put it at May – we’re told that his approval rating goes up to 81 after the shooting, and he’s clearly come back down when the Midterms come around. It makes more sense that he would fall that much in six months as opposed to just three.

After making that timeline, I placed the explicit mentions of the approval rating next to the appropriate episode. From there, I looked at the remaining episodes and made a subjective judgment, based on the events of the episode and scored it as either “UP”, “DOWN” or “EVEN.” I used the explicit mentions as benchmarks and went from there. Those are the points marked in orange on the graph as “Episodes” – based on data from the episodes themselves.

The remaining data is just interpolation of the episode data with some random noise introduced to give the graph a more natural look. Again, I assumed that major events are captured in the actual episodes, so the interpolated data shouldn’t be a substantial departure from what we would expect.

Analysis

The fully interpolated data is in blue, with the data points based on actual episodes marked in red.

The graph is clearly dominated by three key events – the assassination attempt on the President (Season 1 Finale), the MS announcement (Season 2 Finale) and the campaign against Governor Ritchie (Season 4). Those events are reflected below:

Of course, the graph can’t be looked at in isolation. Next I wanted to compare it to data from real life Presidents. The excel sheet has more specific data from all Presidents dating back to Reagan, and Wikipedia has graphs for all President dating back to FDR. Most importantly, Gallup has data that summarizes the data for Presidents since Truman. What I wanted to look at is how Bartlet compares to other Presidents along a few different statistics. The data is summarized in this chart. The blue lines represent the high/low of that President’s approval rating, the red boxes represent their average approval rating across their entire term.

Check the next page for some analysis…..