Skip to main content

Education and the 2020 Election Results

In 2017, I stumbled upon some 2016 election data and started to look at the relationship between educational attainment in the US and election results.  The title was only half serious, but some people took exception to it.  Still, it's remained a topic of interest to me since then.  

Before I begin writing about the latest visualization, let me point out a couple of things on this new display with the 2020 election data.  You'll likely notice some similar patterns, but patterns don't prove causality.  Even if they did, I could come up with two equally plausible explanations of this data that come at the answer from diametrically opposed political perspectives. Take your pick, or just look and see what you find interesting.  It doesn't always have to lead to something.

This time we're dealing with another hot political topic, COVID-19 and vaccinations.  And, it seemed to me that the political divisions in America tend to fall along the same lines.  Or so I thought (and maybe I still do.)

There are five views here, and while they're pretty easy to understand, I think, I'd recommend you read below before diving in.

Scatter arrays (almost) every county in the US on two scales: The percentage of votes cast for Biden (x-axis) and the percentage of adults age 24+ with at least a bachelor's degree (the definition of attainment throughout this post).  Each county is a bubble, and the bubble is sized by the number of votes cast.  Hover for details.  What is most interesting to me is the way in which the pattern stays the same even if you select a region or a single state.

Thermometer breaks counties into bands based on attainment, and then shows the total votes for Biden (blue) and Trump (red). Again, that pattern is clear: Counties with higher educational attainment tend to vote for Democrats; lower attainment indicates more votes for Republicans.  On this visualization, the colored filters in purple (half way between blue and red) refer to the counties selected, not the voters.  So if you choose to slide to at least 50% Hispanic, for instance, you will only show counties that are at least half Hispanic.  In this case, it would not show you how Hispanic voters voted. Vulnerability refers to the CDC Social Vulnerability Index, which you can read about here. And play around with the vaccine data here too.  It's interesting, and, maybe, surprising. (Note: I removed very small groups in the "under 5%" and "over 65%" to make the chart easier to read.)

Note: The filters are cumulative, and you can see how your choices affect the population in the visualization at top left.  But if you try to choose a county that's at least 51% White and 51% Black, you won't get any data because that's mathematically impossible. And data from Alaska is not reported by county, fyi.

Attainment by county is a reference guide.  Choose a state if you'd like, and hover over the county to see a lot of data about it.

Perhaps the most surprising display is the Vaccine Hesitancy view.  What is so compelling here is how borders seem to create extremely sharp lines of demarcation, especially compared to the attainment view; if you expected them to look the same (I did) this is curious, to say the least.  I have no explanation for it.  Maybe someone does?

And, getting back to the original point is the final view, Vote Totals, showing how many votes each party got from each group of counties, clustered by attainment.  The top shows counts, the bottom percentage of their totals. Democrats got 51M votes, or 64% of their total, from the counties with the highest educational attainment. Republicans got 33M, or 45% of theirs from that same group.

As always, play around with this; you won't break it, and you can always use the reset button to start over.  And, of course, let me know what you see that strikes you as interesting.


Popular posts from this blog

The Highly Rejective Colleges

If you're not following Akil Bello on Twitter, you should be.  His timeline is filled with great insights about standardized testing, and he takes great effort to point out racism (both subtle and not-so-subtle) in higher education, all while throwing in references to the Knicks and his daughter Enid, making the experience interesting, compelling, and sometimes, fun. Recently, he created the term " highly rejective colleges " as a more apt description for what are otherwise called "highly selective colleges."  As I've said before, a college that admits 15% of applicants really has a rejections office, not an admissions office.  The term appears to have taken off on Twitter, and I hope it will stick. So I took a look at the highly rejectives (really, that's all I'm going to call them from now on) and found some interesting patterns in the data. Take a look:  The 1,132 four-year, private colleges and universities with admissions data in IPEDS are incl

Freshman Migration, 1986 to 2020

(Note: I discovered that in IPEDS, Penn State Main Campus now reports with "The Pennsylvania State University" as one system.  So when you'd look at things over time, Penn State would have data until 2018, and then The Penn....etc would show up in 2020.  I found out Penn State main campus still reports its own data on the website, so I went there, and edited the IPEDS data by hand.  So if you noticed that error, it should be corrected now, but I'm not sure what I'll do in years going forward.) Freshman migration to and from the states is always a favorite visualization of mine, both because I find it a compelling and interesting topic, and because I had a few breakthroughs with calculated variables the first time I tried to do it. If you're a loyal reader, you know what this shows: The number of freshman and their movement between the states.  And if you're a loyal viewer and you use this for your work in your business, please consider supporting the costs

The College Finder

Note: A few people have commented on slow loading with the visualization.  If you have troubles, click here to be taken right to the visualization .  It should open in a new tab and you can follow along from there.    This is always a popular post with high school counselors, IECs, parents, and students who are looking for general information on degrees awarded, or a very specific combination of academic programs, location, and other institutional characteristics. It uses IPEDS data I downloaded as soon as I can when it became available (and before a looming government shutdown), and shows all 1,700 majors recognized by the federal government in the IPEDS system, using CIP codes, and the number of degrees awarded by college in any selected area. For instance, you might have a question about which college awards the most degrees in French Language and Literature: A few clicks, and you find it's the University of Arizona.  If you want a colder climate, choose the Great Lakes region,