Skip to main content

My homage to the Atlas of the Census

In eighth grade, a teacher introduced my class to the Statistical Abstract of the United States, and it changed the way I looked at numbers and information.  Of course, in those days, it was just a book, and very hard to interact with.  But I still remember poring over it, absorbing interesting, if arcane, facts about the country and its regions.  Ever since, I've been fascinated with reference books like it.

Then, sometime about 2005, I came across the Census Atlas of the United States, and my mind was blown even more.  It contains page after page of maps, representing gobs of data, visualized in a way that tells stories, sometimes with a single picture.  One map, especially, made an impression on me. It's in this chapter, page 14 of the chapter, page 40 of the book, showing Prevalent Asian Group, by county.  If you can't download that large .pdf file, it's below:


In my job, and in higher education in general, we think about race and ethnicity a lot, of course, but here was something that exploded and challenged the status quo and made me think differently: "Asian," was not a monolithic term.  Far from it.

That day, I bought a copy of the Atlas, and always pick it up when I see it.  It's astonishing, I think, and I still discover something new every time I spend some time with it.

I've wanted to do my own mini-version for a long time, but the thing that makes it hard is getting at Census Bureau data.  It's either very hard to extract, or rolled up in ways that don't inspire further analysis.  But I did come across a file that was accessible and fairly easy to work with, with data on a lot of factors at the US county level.  And I started working on it.

This includes 19 maps: The first 16 show US counties, colored by the variable indicated.  In the heading is the US average.  For instance, about 66.2% of the US population is "White alone."  All maps are color coded with that center value as the center point.  Check the legend.

You can look at the whole US or just a state; unfortunately, adding Alaska and Hawaii makes it hard and time consuming to get the maps to look good.  If you have Tableau, you can download this and look at it yourself.

The maps have data filters on them too.  So if  you're looking at the view with percent of adults with a high school diploma, for instance, you can pull the slider up or down to show only those counties with very high or very low values.  On each map, I've also added a somewhat-random second slider, so you can see combinations of variables.  On the high school graduates one, for instance, you can also look at population density.  See which counties have high/high, high/low, or low/low combinations. Play around.

Additionally, there are three other views: Two showing 2012 presidential election results, and one scatter-gram, where you can cross any two variables, and see the relationships between them.

If you work in my job, you might find interesting data that can help you understand how--and why--your distant markets are different than your local ones.  Or maybe it's just fun to play with.

Either way, I hope you enjoy it.  I'd love to hear what you discover.





Comments

Popular posts from this blog

Another 1000 Words and Ten Charts on First-generation, Low-income, and Minority Students

I have always enjoyed writing, and I consider this and my other blog like a hobby.  Usually, I spend no more than 45 minutes on any post, as I don't make my living by writing, and my blogs are not "monetized." But once in a while, an opportunity presents itself to write for a wider audience, and that's when I see what it takes to make a living putting words to paper. That happened this week.

You may have seen my opinion piece in the Chronicle of Higher Education. If not, you can read it first, read it last, or not at all; I think both this and that stand alone, despite their relationship.  In the end, we ended up with about 40% of my first draft, which is what happens when you write for a print publication. And of course, a print publication makes interactive charts, well, difficult.

I think there is more to say on the topic, because the similarities in recruitment challenges for first-generation, low-income, and minority students tend to look a lot alike, and the mo…

2018 Admissions Data

This is always a popular post, it seems, and I've had a couple of people already ask when it was going to be out.  Wait no more.

This is IPEDS 2018 admissions data, visualized for you in two different ways.  You can switch using the tabs across the top.

The first view is the universe of colleges and universities that report data; not every college is required to, and a few leave data out, and test optional colleges are not supposed to report test scores.  But IPEDS is not perfect, so if you find any problems, contact the college.

On the first view, you'll see 1,359 four-year private and public, not-for-profit institutions displayed.  In order to make this as clean as possible, I've taken out some specialty schools (nursing, business, engineering, etc.) as many of those don't have complete data.  But you can put them back in using the filter at top right.

Hover over any bar, and a little chart pops up showing undergraduate enrollment by ethnicity.

You can also choose to…

Changes in Bachelor's Degrees, 2011-2017

This will probably be the final post in Higher Ed Data Stories for a while.  As you may already know, I'm leaving DePaul for the "best coast" to take the position of Vice Provost of Enrollment at Oregon State University, effective July 1.  Thus, I'll be in personal and professional transition for a while, and once I arrive, I'll be busy learning a new institution and working on new challenges that should keep me occupied for a while. (Additionally, I'm not sure what my Tableau situation will be like...)

As you may already know, HEDS got its start when I decided to revise and share work I was already doing in my job at DePaul. Much of it, I presumed, would be of interest to university colleagues and high school and independent counselors.  But I had no idea how many people craved information like this.

So, for now, here is information about bachelor's degrees earned in 2011, 2014, and 2017, the most recent available in the IPEDS data center.  It's pres…