Need help creating report with proper data scope

#1

Any thoughts on how best to pull/find data broken out by age ranges, annual income, & state of residence from 2000-forward? (earlier than 2000 if possible) Used some existing census table tools, but hit wall getting back prior to 2003.

Any help or suggestion is appreciated.

-Tim

0 Likes

#2

The NHGIS project, housed in the Minnesota Population Center, offers many of the Census summary tables as far back as 1790. While NHGIS is primarily focused on mapping data, the summary tables can be extracted independent of shape files as .csv files with optional descriptive headers. In your case, you can create one .csv file for each census year with the population of each state broken down by age and household income.

If the available Census tables are not sufficient for your purposes, IPUMS-USA provides the necessary microdata to create your own tables. You can find online tutorials for using IPUMS-USA microdata here.

Hope this helps.

0 Likes