This article contains a calculator which allows you to input an age range and select a state and delivers demographic results broken down by country and state of origin.
It uses Census Bureau data compiled by the University of Minnesota’s IPUMS-USA project (2012 American Community Survey) and reports where the members of your selected age range in a state were originally born.
If you consume Don’t Quit Your Day Job… through email or in a reader, please click through for interactive content.
Interactive Birth Location and Origin Calculator for the United States
How Much of Each State’s Residents Were Born There?
This calculator was inspired by an excellent demographic feature which recently went up on the New York Times’s The Upshot blog. Entitled Where We Came From, that piece broke down exactly where members of all the states were originally born – whether the same state, other states, or overseas.
That article piqued my interest – but I wanted to take it a step further, and try to restrict the information by age ranges. This article is the result of my efforts – enter an (inclusive) age range, and this calculator will crunch the weights on 2012 census data I pulled from IPUMS-USA and report out (to 4 decimal points!) the percentages of that demographic from various states and countries (and, in some cases, regions).
Please let me know if you have any suggestions or bugs to report (I put it together somewhat quickly) – but I hope you find this an interesting piece.
Sample: 2012 American Community Survey
Variables: Person Weight, Birthplace (Detailed), State ICP Number, Age
To Reproduce: In R: Sum weights per state for total weights, export to CSV. Split data tables in for unique State, Age, Birthplace, and export to CSV. Divide unique weights into total weights for selected, update the page (as quickly as we can…).
Steven Ruggles, J. Trent Alexander, Katie Genadek, Ronald Goeken, Matthew B. Schroeder, and Matthew Sobek. Integrated Public Use Microdata Series: Version 5.0 [Machine-readable database]. Minneapolis: University of Minnesota, 2010.