Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

A questionnaire change: politics or not?

Finding “war brides” in the ACS

Census Bureau is considering adding a new Middle East/North Africa ethnic category

Big Data Initiative at NIH-OBSSR

UM Now Has Access to IndiaStat

Data Services Knowledge Base

Q:  

Is there a way to estimate what percentage of workers are foreign born by class of worker for congressional districts? I am using the 2005 ACS with the geographic area of 109th Congressional District.

A:  

The Census Bureau creates summary tables of the most likely tables that users would want to see and makes these available through American FactFinder. Very few tables include foreign birth as one of the *by variables.

Thus, you have to turn to the microdata where you can make any sort of tabulation.

The easiest way for you to get access to the ACS microdata is through the Minnesota Population Center's IPUMS interface:

http://www.ipums.org/usa

You need to register to make an extract, but you will get instant access, once you describe what you want to do.

The items you need for your analysis are:

STATEFIP and PUMA from the housing record
BPL, CLASSWKR, and PERWT from the person record

Congressional District is not a geographic choice on the microdata. However, you can map a person's congressional district on the basis of their state and PUMA. PUMA stands for Public Use Microdata Area. This will not be a perfect mapping because sometimes congressional districts cross PUMA boundaries.

PUMAs are population groupings of approximately 100,000 people. In rural areas, it will be several counties. In a metro area, it will be several places or parts of a place defined on the basis of census tracts.

There is a correspondence engine or crosswalk that describes the relationship of PUMAs to congressional districts:

http://mcdc2.missouri.edu/websas/geocorr2k.html

In your case, you will want to choose PUMA for 5 Pct Samples (2000) from the left column and Congressional District: 109th from the right. You can select all states, but for illustrative purposes, I have only selected the state of Michigan. The results for Michigan are below:

http://www.psc.isr.umich.edu/dis/data/kb/downloads/t1095_puma2cd.txt

Many PUMAs fall into only one Congressional District. For example, 00100, 00200, 00300 are all part of Michigan's 1st congressional district. However, PUMA 005 falls into three congressional districts (56% in CD1; 21% in CD2 and 22% in CD4), so you would weight your results to reflect this.

Drop by if this is not clear to you and we can help you set something up so that you can create this table for congressional districts.

Annotated Resources:

Direct Links:

Related Question Groups: