Pennsylvania – Page 4 – Coffee Spoons

The Spread of COVID-19 in Select States

By now we have probably all seen the maps of state coverage of the COVID-19 outbreak. But state level maps only tell part of the story. Not all outbreaks are widespread within states. And so after some requests from family, friends, and colleagues, I’ve been attempting to compile county-level data from the state health departments where those family, friends, and colleagues live. Not surprisingly, most of these states are the Philadelphia and Chicago metro areas, but also Virginia.

These are all images I have posted to Instagram. But the content tells a familiar story. The outbreaks in this early stage are all concentrated in and around the larger, interconnected cities. In Pennsylvania, that means clusters around the large cities of Philadelphia, Pittsburgh, and Harrisburg. In New Jersey they stretch along the Northeast Corridor between New York and Trenton (and along into Philadelphia) and then down into Delaware’s New Castle County, home to the city of Wilmington. And then in Virginia, we see small clusters in Northern Virginia in the DC metro area and also around Richmond and the Williamsburg area. Finally in Illinois we have a big cluster in and around Chicago, but also Springfield and the St. Louis area, whose eastern suburbs include Illinois communities like East St. Louis.

I have also been taking a more detailed look at the spread in Pennsylvania, because I live there. And I want to see the rapidity with which the outbreak is growing in each county. And for that I moved from a choropleth to a small multiple matrix of line charts, all with the same fixed scale. And, well, it doesn’t look good for southeastern Pennsylvania.

Then last night I also compared the total number of cases in Pennsylvania, New Jersey, Delaware, and Virginia. Most interestingly, Pennsylvania and New Jersey’s outbreaks began just a day apart (at least so far as we know given the limited amount of testing in early March). And those two states have taken dramatically different directions. New Jersey has seen a steep curve doubling less than every two days whereas Pennsylvania has been a bit more gradual, doubling a little less than every three.

For those of you who want to continue following along, I will be looking at potential options this coming weekend whilst still recording the data for future graphics.

Credit for the pieces is mine.

The Spread of COVID-19 in Pennsylvania

Over the last several days, along with most of the country, I’ve taken an interest in the spread of the novel coronavirus named COVID-19. Though, to be fair, it’s actually been in the news since early January, though early news reports like this from the Times, simply called it a mysterious new virus. At the time I thought little of it, because the news out of China was that it did not appear it could spread amongst humans. How did that idea…wait for it…pan out?

Anyway, over the last couple of days I’ve been making some maps for Instagram because people tend to look at a national map and see every nearly state infected when, in reality, there are pockets and clusters within those states. So I started looking at Pennsylvania. And initially, the cluster was along the Delaware River, namely Pennsylvania as well as its upper reaches near the Lehigh Valley and in the far northeast of the state.

But the spread has grown, and fairly quickly, with Montgomery County, a Philadelphia suburb, a hotspot. Consequently, the Pennsylvania governor has shut down all schools across the state and ordered non-essential shops, restaurants, and bars in the counties surrounding Philadelphia—as well as the county containing Pittsburgh—closed.

So 11 days in, here’s where we stand. (To be fair, I looked at including the early numbers out of today, but nothing has really changed, so I’ll wait until the evening figures are released before I update this again.)

Credit is mine. Data is the Pennsylvania Department of Health.

Where Is That Pesky Mason–Dixon Line?

It’s no big secret that genealogy and family history are two of my big interests and hobbies. Consequently, on rainy days I sometimes like to enjoy an episode or two of Who Do You Think You Are (I prefer the UK version, but the American one will do too) or Finding Your Roots. So I decided to watch one last night about Megan Mullally of Will & Grace fame. Long story short, her family has a connection to Philadelphia (only one block away from where I presently live) and so I paid a bit of attention to the map.

Now, DRM prevented me from taking a straight screenshot, so this is a photo of a screen—my apologies. But there is something to point out.

The borders are wrong. So I made a quick annotation pointing out the highlights as it relates to Pennsylvania.

Credit for the piece goes to the Who Do You Think You Are graphics department.

The annotations are mine, though as for their geographic accuracy, they are approximate. I mean after all, I’m using Photoshop to put lines on a photograph of a laptop screen.

Pennsylvania’s Population Shifts

Last month the US Census Bureau published their first batch of 2018 population estimates for states and counties. Pennsylvania is one of those states that is growing, but rather slowly. It will likely lose out to southern and western states in the 2020 census after which House seats will be reapportioned and electoral college votes subtracted.

From 2018 to 2010, the Commonwealth has grown 0.8%. Like I said, not a whole lot. But unlike some states (Illinois), it is at least growing. But Pennsylvania is a very diverse state. It has very rural agricultural communities and then also one of the densest and largest cities in the entire country with the whole lot in between . Where is the growth happening—or not—throughout the state? Fortunately we have county-level data to look at and here we go.

The most immediate takeaway is that the bulk of the growth is clearly happening in the southeastern part of the state, that is, broadly along the Keystone Corridor, the Amtrak line linking Harrisburg and Philadelphia. It’s also happening up north of Philadelphia into the exurbs and satellite cities.

We see two growth outliers. The one in the centre of the state is Centre County, home to the main campus of Pennsylvania State University. And then we have Butler County in the west, just north of Pittsburgh.

The lightest of reds are the lowest declines, in percentage terms. And those seem to be clustered around Scranton and Pittsburgh, along with the counties surrounding Centre County.

Everywhere else in the state is shrinking and by not insignificant amounts. Of course this data does not say where people are moving to from these counties. Nor does it say why. But come 2020, if the pattern holds, the state will need to take a look at its future planning. (Regional transit spending, I’m looking at you.)

Pennsylvania Primary Night

Surprise, surprise. This morning we just take a quick little peak at some of the data visualisation from the Pennsylvania primary races yesterday. Nothing is terribly revolutionary, just well done from the Washington Post, Politico, and the New York Times.

But let’s start with my district, which was super exciting.

The only thing to write home about is how the Republican incumbent dropped out at the last moment and was replaced by this guy…

Moving on.

Each of the three I chose to highlight did a good job. The Post was very straightforward and presented each office with a toggle to separate the two parties. Usually, however, this was not terribly interesting because races like the Pennsylvania governor had one incumbent running unopposed.

But Politico was able to hand it differently and simply presented the Democratic race above the Republican and simply noted that the sitting governor ran unopposed. This differs from the Post, where it was not immediately clear that Tom Wolf, the governor, was running unopposed and had already won.

Clean and simple design. No non-sense here.

The Times handled it similarly and simultaneously displayed both parties, but kept Wolf’s race simple. The neat feature, however, was the display of select counties beneath the choropleth. This could be super helpful in the midterms in several months when key races will hinge upon particular counties.

The Republican primary for the PA governorship has been ugly

But where the Times really shines is the race for Pennsylvania’s lieutenant governor. Fun fact, in Pennsylvania the governor and lieutenant governor do not run as a ticket and are voted for separately. This year’s Democratic incumbent, Mike Stack, does not get on with the governor and had a few little scandals to his name, prompting several Democrats to run against him. And the Times’ piece shows the two parties result, side-by-side.

Pennsylvania's oddest race this time 'round — Pennsylvania’s oddest race this time ’round

Credit for the Post’s piece goes to the Washington Post graphics department.

Credit for Politico’s piece goes to Politico’s graphics department.

Credit for the Times’ piece goes to Sarah Almukhtar, Wilson Andrews, Matthew Bloch, Jeremy Bowers, Tom Giratikanon, Jasmine C. Lee and Paul Murray, and Maggie Astor.

Finding Yourself on the Pennsylvania Turnpike

I hope you all enjoyed your Easter holidays. Easter, wasn’t that two weekends ago you ask. Catholic/Protestant Easter, yes. This past weekend was Orthodox Easter. And since that is what my family celebrates, I was away on holiday this past weekend and only got back in town last night. But on the way out to the ancestral stomping grounds in western Pennsylvania, I realised that the Pennsylvania Turnpike Commission put a little bit of thought into the signage at their more modern service plazas.

The outside is basically what you expect, the symbol of the Pennsylvania Turnpike and the name of the plaza. But if you look closer, the name of the plaza, in this case the Lawn plaza outside of Lawn, Pennsylvania, is set not just on a blue sign, but a cropping of a blue map of the commonwealth.

The yellow lines represent the Pennsylvania Turnpike and, with right being east, the Northeast Extension. The red star represents your current location along the turnpike system. Is this going to tell you how many miles until your next exit? No. I had to go inside and find out how many miles to Bedford, PA on a larger display map. But, this provides a wonderful low-fidelity display. After all, I roughly know where I am headed on the turnpike, and I know whence I came. So I can see that I am a little under half-way to my destination.

Credit for the piece goes to the designers of the Pennsylvania Turnpike Commission.

My Kingdom for a Needle

I am exhausted. I tried to stay up late enough to catch the absentee ballots from Washington County. Alas, I did not quite make it. (You better bet I will be drinking all the caffeine today.) But someone else did not quite make it through the night. Or rather, something. What was it? The New York Times election night needle.

To understand why the Times made the needle, read this really great explainer. The super short version: it tries to forecast the results of that particular election day, accounting for things like uncounted votes. On television, analysts and large interactive screens can show how, usually, urban districts are counted first then followed by slower-to-return rural areas. But for people following results solely online, those nuances might well be lost. Enter the needle.

Last night, like much of the Twitterverse I follow for politics, I had the needle open in one tab. But as the results began to come in, something odd was happening on the Times’ results page. The votes were being displayed in a precinct-by-precinct fashion in Allegheny, Washington, and Greene Counties. But Westmoreland was oddly grey. It turned out, the county elections board was not, I suppose, digitally publishing the precinct results, only county-wide.

Fun fact, the needle’s model is apparently built on precinct results. So how do you have a needle if something like 30% of the model’s required or expected data will not be available? The Times tweeted about it a few times, but ultimately pulled it down. Better to not have it and be right than have it wrong just to have it.

But that brings me to the second point about the needle. Well done to BuzzFeed’s Decision Desk HQ, who were presciently concerned about the ability of the county to get precinct level results up online. So they sent a reporter, as in a human being, to Westmoreland to get the analogue results and then upload them to BuzzFeed’s own results spreadsheet. (I never did find a BuzzFeed live results page.)

Who knows the budget difference between the New York Times’s graphics/politics desks and that of BuzzFeed’s, but the ability to put a single person in Westmoreland made the difference for BuzzFeed, whose coverage via Decision Desk HQ, made for a more compelling following because they were, old school like, reading out results as they came in via reporters. And because there were no exit polls in the election, we had to wait for all the votes. Strangely, it almost felt like watching a UK general election where you have to wait hours for some constituencies to announce results. Though this election had a noticeable lack of Raving Monster Loony candidates.

I bring up the BuzzFeed contribution to the night because it does show how sometimes the sheer fact of placing a reporter on the ground can yield tremendous results. Come November, no, I don’t think any single media organisation can afford to put a reporter in every single US county. But I would bet the Times will be working on how to better precinct proof their needle.

Credit for the piece goes to Nate Cohn, Josh Katz, Sarah Almukhtar, and Matthew Bloch.

Pennsylvania 18th Congressional District: The Special Election

Today is Tuesday, 12 March. And that means a special election in the 18th congressional district of Pennsylvania, located in the far southwest of the state, near Pittsburgh.

Long story short, the district is uber Republican. But, the long-time Republican congressman, the avowedly pro-life type, was caught urging his mistress to abort their unborn child. Needless to say, that did not go over so well and so he resigned and now here we are with a veteran state legislator and veteran who calls himself “Trump before there was Trump” running for the Republicans and another veteran but also former federal prosecutor involved with fighting the opioid epidemic running for the Democrats.

Now about that uber Republican-ness. It is so much so that Democrats didn’t even run candidates in 2014 and 2016. And then in 2016, Trump won the district by 20 percentage points. But the polls show the Republican, Rick Saccone, with a very narrow lead within the margin of error. That in and of itself is tremendous news for Democrats in Pennsylvania. But what if Conor Lamb, the Democrat, were to actually somehow pull off a victory?

Well the Washington Post put together a great piece about how it really might not matter. Why? Because of that whole redistricting thing that I talked about. Neither Saccone nor Lamb live in the district that will replace today’s 18th.

The piece has several nice graphics showing just how much this area of the state will change and how that will impact these two candidates. But my favourite piece was actually this dot plot.

That's an enormous gap for Lamb to overcome — That’s an enormous gap for Lamb to overcome

It speaks more to today’s election than the future of the district. Everyone will undoubtedly be looking to see if Lamb can eke out a victory of Saccone this evening. But even if he loses narrowly, the Democrats can still take a glimmer of hope because of just how insurmountable the challenge was. It would require an enormous swing just to crack 50.1%.

Credit for the piece goes to Reuben Fischer-Baum and Kevin Uhrmacher.

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.

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.

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 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?

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.