Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to get the ethnic breakdown (within limits) on a zipcode basis in the US?

I was looking at this census data but its insanely hard to parse.

Where kind I find data that is more easily parsed?

share|improve this question
up vote 5 down vote accepted

The Census Bureau has far easier avenues of extracting data through the American FactFinder (AFF). There are many tutorials for how to use AFF, but it is generally not been 'intensely hard' to use for me. By downloading the information in .csv format, you would be able to download the latest information from the ACS, or the 2010 Census.

share|improve this answer
How did you find this? – soandos Jun 11 '14 at 15:19
Well, I've known about this method for years. Luckily, there are places like to guide you to these places that may otherwise seem difficult to find. – Kotebiya Jun 11 '14 at 15:30

The data you are looking for is found in the Demographic Profile Summary File (DPSF). The data contains population counts by age groups and race/ethnic. It contains entries for all census geographic areas (including ZCTAs which are approx. of US Postal Zip Codes).

The "raw" summary files are packaged on a state by state basis. At the parent FTP directory, the file 0FILE_STRUCTURE.doc describes how to use the files. The description of TABLES_2010.DBF starting on page 13 describes the column layout of the data fields.

Each state has zip package with three files:

0000120101.dp : this is the data file geo20101.dp : this is the geographic reference file that maps the geographic identifier to the geographic type and place name.

Each row in the data file (example is from Alabama) starts like this:


The fifth field (e.g., 0000001) is the geographic identifier. The fields following this are the data and are ordered as described in the description of TABLES_2010.DBF.

Another access method is to use the US Census Data Ferret. I have only limited experience so far in using it. But it is an online interactive application that will help you select sources and fields to build and download a custom table.

share|improve this answer
Although I voted up this answer, I feel it is more complex than this person is looking for. – Kotebiya Jun 11 '14 at 15:32
@kotebiya - yes it is more complex than what the person is asking for. I included the Data Ferret tool that I think helps bridge getting data between expert and novice users. – Andrew - OpenGeoCode Jun 11 '14 at 15:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.