Another Solo Pub Trivia Performance

This past Wednesday I once again ended up playing trivia at the pub solo. Once again, I decided over the final pint that I would attempt to visualise my performance.

One thing to keep in mind is that on Wednesday there were fewer teams competing—five instead of nine. And while I never placed higher than tied for third, this week’s bar charts show how I was incredibly competitive until the final music round.

Music and celebrity are clearly not my strong suits
Music and celebrity are clearly not my strong suits

Despite an abysmal performance at naming celebrities as they were as children, my near-perfect second round kept me only five points behind first place. And a perfect fourth round meant heading into that final round I climbed back to being only three points back. Thankfully I knew more of the songs this past week. And enough to not finish last. But, I was close enough that a perfect round would have been enough to still place first.

Super helpful that Lord of the Rings questions appeared a few times.

Pub Trivia Performance

Wednesday night I had the dubious honour of playing the weekly pub trivia solo. Accordingly my team name was Hats Solo. (After I opted not to wear my fedora one night, another regular team called itself Where’s Your Hat?) I started strong, had a second wind, but still faded to a seventh place (of nine) finish. As I finished my G&T, I decided I would visualise the results. Here, two days later, are my results.

History and geography are usually my strong suits
History and geography are usually my strong suits

Credit for the highlights, mine. The lowlights, someone else.

Energy Production in Pennsylvania

Pennsylvania was the country’s first state to operate a nuclear power plant for electricity generation and is today the second-largest nuclear-generated electricity state after Illinois. But in recent years the triple threat of the Pennsylvania Marcellus Shale natural gas boom, wind power subsidies, and solar power subsidies have hit the state’s nuclear industry hard. Consequently the power company Exelon has announced plans to shutdown the generating station at Three Mile Island—yes, that Three Mile Island—in 2019 if Pennsylvania does not rescue the industry as have the states of Illinois and New York, each facing similar challenges.

I wanted to take a look at the electricity generated by nuclear power in Pennsylvania, but had to settle for energy produced. And while the data was only as recent as 2014, it did extend back to 1960 thereby dating back almost as far back as nuclear power in Pennsylvania—it began in 1957.

The subject has always been of interest to me and was the focus of one of my first data visualisation pieces back at university. And so while the data is not quite the same, nor over the same geographic area, it is interesting to see the spike since even 2008. (Worth noting that even in a coal state the long, slow decline of coal even before President Obama is self-evident.)

The rise of Marcellus Shale natural gas has been quick and dramatic
The rise of Marcellus Shale natural gas has been quick and dramatic

Unfortunately the EIA data came through a .pdf and not a more accessible data file so I spent most of my time recreating the data. Consequently, I had little time to do more than track these changes. But even still, I think you would agree the message is clear: natural gas has quickly disrupted the market. (Let’s again ignore the fact I could not plot renewable energy sources.)

Small disclaimer I suppose, I have always supported nuclear power as part of a non-carbon energy portfolio. But I also grew up within sight of and fascinated by the Limerick Generating Station steam clouds, so call me biased.

Credit for this graphic is mine.

US Steel Imports

On Thursday President Trump announced that the Commerce Department would investigate imports of steel to the United States. This falls under the Buy American campaign pledge. A lot of talk in the media is, of course, about the threat of Chinese steel to the United States. So I dug into the Census Bureau’s website and found their data on steel imports.

Well, it turns out that steel imports were already down by over 5 million tons before Trump took office. And from 2015 to 2016, China fell sharply from 7th to 10th in a ranking of our import partners. In fact the only country from whom we import significant amounts of steel to see a rise over that period was Mexico.

But we’ll probably need their steel to build the wall to keep out their steel.

I visualised the data in this datagraphic. Enjoy. And look for a later post today in the usual, light-hearted vein.

The state of US steel imports
The state of US steel imports

Credit for the data goes to the US Census Burea. The graphic is mine.