Prospects: Who Will Reach College Age in the Next 14 Years?
The changing ethnic and socioeconomic makeup of America's children has all kinds of effects on the country's educational institutions and is the sort of thing that's easy to describe with recruiters' anecdotes and provosts' gut feelings. My task was to quantify some of these changes and make them more accessible.
Using some Census tables that break down the population by racial/ethnic background and individual year of age (e.g., 4 years old, 17 years old), I managed to show the differences in demographics between some areas' younger and older children as well as the varying distributions of specific ethnic groups in those areas, both to help readers see those changes and to help reporters better focus their efforts as they explained what this meant for our audience.
AP general election results, 2016
In a major American election, all eyes are on the AP. In 2016, I was one of three main developers on our backend data pipeline for the AP's election results interactives, which were embedded on hundreds of websites all over the world. It's the most heavily viewed project I've ever worked on, without a doubt.
I also designed and built the entire system to render those same results as print-ready PDFs for newspaper customers and publish them on the wire, using design mocks from one of our graphics editors.
6 Campuses and the Liquor Surrounding Them
I worked with two of The Chronicle's data reporters on this piece, which was part of a larger special section on alcohol's place in campus life nationwide. I coordinated our efforts to compile a list of all alcohol license holders from more than 30 states, which involved downloading raw data and making records requests.
I also wrote agency-specific scrapers for some states, and I standardized all of that information for us to analyze further. I performed the GIS analysis for the areas we did focus on, and I designed and implemented the custom Google maps we ran online. I also packaged the data for most of the states (the easiest ones to use) and made those files available for readers and other journalists to download.