US Olympic Performance

I don’t know if you heard, but the Winter Olympics just concluded. I’m admittedly not a huge fan of the Winter Olympics, but that doesn’t mean I didn’t keep my eye on some of the stories coming out of the coverage. One that I liked was this piece from FiveThirtyEight.

US performance was lagging at this point
US performance was lagging at this point

It was about halfway through the Olympics and the US was not doing terribly well. The chart does a great job of showing how various countries were performing, or over- or under-performing, their expected total medal winnings. It did this through a filled bar chart with a bar-specific benchmark line. It was a nice combination of a couple of different techniques to incorporate not just the usual above or below the trend, but also the actual amounts.

Credit for the piece goes to Gus Wezerek.

Changes to Immigration Enforcement

Almost two weeks ago I read a piece in City Lab that used three maps to look at the changes to immigration enforcement in the first year of the Trump administration. I was taken by this final map in particular.

Some geographic patterns do emerge…
Some geographic patterns do emerge…

While the map does have some large areas of N/A, it still does show some interesting geographic patterns. I think New York showcases it the best. Counties that are less involved in enforcement operations are in the southern part, near New York City. But then you can begin to get a clear sense of what is “upstate” by that break roughly parallel to both the Connecticut and Pennsylvania northern borders.

To a lesser extent you can see the same pattern play out in Pennsylvania. While far more white—as in no change on the map—the counties of orange—more involvement—are located in the interior and western counties. That is perhaps somewhat in the same space as Pennsyltucky.

Immigration is clearly an engaging topic these days, and I found this map interesting not because of its design, but because of the geographic stories it tells.

Credit for the piece goes to Victoria Beckley.

The 2017–18 Flu Season

Last week I covered the Pennsylvania congressional district map changes quite a bit. Consequently I was not able to share a few good pieces of work. Let’s hope nothing goes terribly wrong this week and maybe we can catch up.

From last Friday we have this nice piece from FiveThirtyEight looking at the spread of influenza this season.

Red is definitely bad
Red is definitely bad

The duller blues and greens give way to a bright red from south to north. Very quickly you can see how from, basically, Christmas on, the flu has been storming across the United States. It looks as if your best bets are to head to either Maine or Montana. Maybe DC, it’s too small to tell, but I kind of doubt that.

As you all know, I am a fan of small multiples and so I love this kind of work. To play Devil’s advocate, however, I wonder if an interactive piece that featured one large map could have worked better? Could the ability to select the week and then the state yield information on how the flu has spread across each state? I am always curious what other other forms and options were under consideration before they chose this path.

Credit for the piece goes to the FiveThirtyEight graphics department.

Gerrymandering Pennsylvania Part V

Yesterday we looked at the new congressional district map here in Pennsylvania, drawn up by the state supreme court after the Republican legislature and Democratic governor could not come to agreement.

Also yesterday, FiveThirtyEight explored the redrawn map in more detail to see if, as I’ve read in a few places, the new map is a Democratic gerrymander. In short, no. The article does a great job explaining how, basically, it might seem like it because more Democrats are predicted to be elected based on various models. But, that is only because the map was so extremely gerrymandered in the past that any effort to increase competitiveness or fairness would make Republicans more likely to lose seats.

This one table in particular does a nice job showing just how in an average election cycle there are only four seats that you could consider reliably Democratic whereas there are six that are reliably Republican. And keep in mind that Pennsylvania actually exhibits the reverse split—there are more Democrats than Republicans in the state. So even with this new map, the state exhibits a slight Republican bias.

Still favouring the Republicans
Still favouring the Republicans

Credit for the piece goes to Aaron Bycoffe.

Gerrymandering Pennsylvania Part IV

Yesterday the Pennsylvania Supreme Court published the new congressional district map of Pennsylvania, the latest chapter in this tale. Republicans in the state legislature have already said they will take this to the federal courts, but they tried that just a few weeks ago and the Supreme Court refused to hear the case.

So the Washington Post put together a map showing precinct-level data aggregated to the new borders and the result is a far more competitive map. Despite there being more Democrats in Pennsylvania, overall the map still remains leaning towards Republican, but there are more light blue and red, again meaning competitive, districts to be fought over.

Well now we have some sensible lines…
Well now we have some sensible lines…

I did hear on the radio this morning, however, that one implication will be in the new Pennsylvania 4th, which is comprised mainly of the Philadelphia suburban county of Montgomery. Right now, that area is so gerrymandered that there is not a candidate right now living with the new borders.

Credit for the piece goes to the Washington Post Wonkblog.

More Murder in Merica

Today’s post was going to be something not this. But it is remarkable how many people die in the United States in mass shootings. It is, generally speaking, not a problem experienced in the rest of the developed world. The question is do we want gun violence to really define American exceptionalism?

Anyways, the Washington Post has a frightening piece exploring all the deaths, the guns, the killers, and the frequency of the killings.

Too many illustrations there
Too many illustrations there

Credit for the piece goes to Bonnie Berkowitz, Denise Lu, and Chris Alcantara.

Gerrymandering Pennsylvania Part III

Almost a month ago I wrote about how the Pennsylvania Supreme Court was considering a case involving the state’s heavily gerrymandered US congressional districts, which some have called among the worst in the nation. About a week later the Pennsylvania Supreme Court decided that the map is in fact so gerrymandered it violates the Pennsylvania Constitution. It ordered the Republican-controlled legislature to create a new, non-gerrymandered map that would have to be approved by the Democratic governor. I did not write up that then Pennsylvanian Republicans appealed to the US Supreme Court—no graphics for that story. That appeal was rejected by Justice Alito, but with only days to spare the state legislature then created this new map and sent in this new one on Friday.

The proposed congressional districts, black lines, overlaid atop electoral precincts, the pretty colours.
The proposed congressional districts, black lines, overlaid atop electoral precincts, the pretty colours.

The problem, according to the governor and outside analysts, is that the map is just as gerrymandered as the previous one. Consequently, yesterday the governor rejected the new map and so now the Pennsylvania Supreme Court, working with outside experts in political redistricting, will create a new congressional map for Pennsylvania. Hopefully before May when the state has its first primaries.

But just how do we know that the new map, despite looking different, was just as gerrymandered. Well, the Washington Post plotted the election margins for districts in 2016 using precinct data versus their proposed 2018 map overlaid atop those same precincts. What did they get? Almost identical results. The districts are no longer Goofy Kicking Donald Duck-esque, but they exhibit the same Republican bias of the previous map.

Trying to do the same thing to get a different or the same result?
Trying to do the same thing to get a different or the same result?

For the purposes of design, I probably would have dropped the “PA-” labels, as they are redundant since the whole plot examines Pennsylvania congressional districts. I think that, perhaps with a marker, and maybe a line of no-change would go a bit further in more clearly showing how the ultimately rejected map was nearly identical to its previous incarnation.

Credit for the map borders goes to the Pennsylvania state legislature, the version here to the Washington Post Wonkblog. All Wonkblog for the scatterplot.

Post-Brexit Trading

Off of yesterday’s piece looking at the potential slowdown in British economic growth post-Brexit, I wanted to look at a piece from the Economist exploring the state of the UK’s current trade deals.

Still loathe the use of bubbles though…
Still loathe the use of bubbles though…

I understand what is going on, with the size of the bubbles relating to British exports and the colour to the depth of the free trade deal, i.e. how complex, thorough, and wide-ranging. But the grouping by quadrant?

With trade, geographical proximity is a factor. Things that come from farther cost more because fuel, labour time, &c. One of the advantages the UK currently has is the presence of a massive market on its doorstep with which it already has tariff- and customs-less trade—the European Union.

Consequently, could the graphic somehow incorporate the element of distance? The problem would be how to account for routes, modes of transport, time—how long does a lorry have to queue at the border, for example. Alas, I do not have a great answer.

Regardless of my concepts, this piece does show how the most valuable trade partners already enjoy the deepest and largest trade deals, all through the European Union. And so the UK will need to work to replicate those deals with all of these various countries.

Credit for the piece goes the Economist Data Team.

Baseball’s Free Agency Problem

Baseball season begins next week. For different teams it starts different days, but for the Red Sox at least, pitchers and catchers report to Spring Training on Tuesday. But the Red Sox, along with many other teams throughout baseball, have holes in their roster. Why? Arguably because nearly 100 free agents remain unsigned.

I do not intend to go into the different theories as to why, but this has been a remarkably slow offseason. How do we know? Well using MLB Trade Rumours listing of the top-50 free agents this year, and the signings reported on Baseball Reference, we can look at the upper and middle, or maybe upper-middle, tiers of free agency.

The upper tiers of baseball's free agent market, as of 9 February
The upper tiers of baseball’s free agent market, as of 9 February

Kind of messy to look at with all the player labels, but we can see here the projected contracts, in both length and total value, along with the contracts players signed, if they have. And for context we can see how those contracts compares to the Qualifying Offer (QO). What’s that? Complicated baseball stuff that is meant to ensure teams that lose stars or highly valuable players are compensated, especially since they might come from smaller market teams that cannot afford superstar prices. The QO is meant to help competitiveness in the sport. How does it do that? Let’s just say complicated baseball stuff. We should also point out that some players, most notably the Yankees’ Masahiro Tanaka, were expected to opt out of their contracts and try the free market. Tanaka did not, which is why his projection was so far off.

Comparing the signed to the unsigned free agents
Comparing the signed to the unsigned free agents

So is it true that free agency is or has moved slowly? Consider that approximately 100 free agents remain unsigned as of late Thursday night—please no big signings tomorrow morning—and that of the top 50, 22 of them remain unsigned. And if we take the QO as a proxy for the best players in the game, add in two players who were exempt because baseball stuff, we can say that 8 of the 11 best players remain unsigned. Though, in fairness to ownership, three of those players are reportedly sitting on multi-year offers in the nine-figure range.

But if players are unsigned, does that mean they are competing for lower value contracts? Possibly. If we use MLB Trade Rumours’ projected contracts, because in years past they have proven smart at these things, we can see that for the 28 who have signed, it’s a roughly even split in terms of the number of players who have signed for more or less than their projection. Sometimes however, non-monetary factors come into play. Two notable free agents, Todd Frazier and Addison Reed, both reportedly signed lesser value contracts to play closer to a specified geography, in Frazier’s case the Northeast and in Reed’s the Midwest.

How are the signed players doing versus their contract projections
How are the signed players doing versus their contract projections

But the telling part in that graphic is not necessarily the vertical movement, i.e. dollars, but the horizontal movement. (Though we should call out the cases of Carlos Santana and Tyler Chatwood, signed by the Phillies and Cubs respectively, who did far better than projected.) Consider that a team might not have a lot of money to spend and so might extend a contract over additional years, offering job security to a player. Or in a bidding war, the length of the contract might be what leads a player to pick one team over another. In those cases we would expect to see more left-to-right movement. So far we have only had one player, Lorenzo Cain, who signed for more years than expected. Most players who have signed for less have also signed for fewer years. Note the cluster of right-to-left, or shorter-than-expected, contracts in the lower tiers versus the small, vertical-only cluster in the same section for those signing greater than projected contracts.

Lastly, are these trends hitting any specific positional type of player? Well maybe. Ignoring the market for catchers because of how small the pool was—though the case of Jonathan Lucroy as the unsigned catcher is fascinating—we can see that the market has really been there for relief pitchers as there are few of the top-50 remaining on the market. Starting pitchers and outfields, while with quite a few still on the market, have generally done better than projected. But infielders lag behind with numerous players unsigned and those that have signed, most have signed for less than projected.

Are there any trends at the position level
Are there any trends at the position level

But at the same time, I would fully expect that once these higher level free agents come off the board—while one would think they would certainly be signed, who knows in such a weird offseason as this—the unsigned middle and lower tiers will quickly follow suit.

Of course none of this touches upon age. (Largely because lack of time on my part.) Though, in most cases, getting to free agency in and of itself makes a player older by definition the way baseball’s pre-arbitration and arbitration salary periods work. (Again, more baseball stuff but suffice it to say your first several years you play for peanuts and crackerjacks.)

Hopefully by this afternoon—Friday that is—some of these players will have signed. After all, baseball starts next week. If we are lucky this post will be outdated, at least in terms of the dataset, come Monday. Regardless, it has been a fascinating albeit boring baseball offseason.

Credit for the data goes to MLB Trade Rumours and Baseball Reference.

Continuing Resolutions

The Senate reached a compromise on a two-year budget that increases spending by nearly half a trillion dollars on both the military and domestic programmes. This comes after a series of continuing resolutions, which are temporary spending bills that allow the government to function when the fiscal year has begun, but a budget has not been set.

It should pass the Senate, but there are questions about whether House Republicans will pass the budget because of their concerns about adding to the deficit. If it does pass, it could mark a significant step forward in getting the fiscal house in order.

To see just how chaotic the use of continuing resolutions has been, thankfully we have a piece from FiveThirtyEight exploring that issue. Spoiler: we have used it a lot since the late 1990s.

My favourites are when they are used instead of a budget…
My favourites are when they are used instead of a budget…

Credit for the piece goes to Gus Wezerek.