November 25, 2009
Aggregate Data: PUMA to County conversion
The ACS provides annual data, but the geographic scope of these data is limited because of the 65,000+ population requirement. Less than 900 counties meet this cutpoint. One solution to this is to produce a PUMA-based query and then use a crosswalk to map PUMAs to counties.
PUMA to County Widget [PDQ-Explore output]
This widget takes output from PDQ-Explore and converts PUMA-based characteristics to county-based characteristics
PUMA to County Widget [American FactFinder output]
This widget takes output from American FactFinder and converts PUMA-based characteristics to county-based characteristics
November 24, 2009
Creating County Level Statistics from Microdata Files
Normally one would use tabular data to produce county-level statistics. However, sometimes the measure one wants is not available in tabular data and/or the county is not populous enough for county-based measures, e.g., ACS population limits.
The following document describes how one can produce county level data from PUMAs:
Here are the links to the executable program, the crosswalk, and instructions: