Missouri Census Data Center now offering access to 2012 ACS data as profile products

The Missouri Census Data Center had created data set versions of the 2012 1-year ACS base/summary tables. And MCDC has completed using those detailed tables in order to create ACS Profiles and ACS Trends report products (use the first and third links from the “Quick Links” box on the home page for access to the menu pages). We have done considerable work on the code we use to create these derived variables, trying to avoid using tables with a higher probability of having suppressed values.

You can also get access to these data in a single data set, usmcdcprofiles in the acs2012 data directory. Access this data set with 7750 geographic summaries (rows) and 1057 data items (variables/columns). The latter include the margin-of-error values and calculated percentage variables for all variable that are counts (so you get, for example, Poor, Poor_moe and PctPoor (as well as PovUniverse). There are numerous ways to access this data set (which might require you to skim the Dexter Quick Start Guide – linked to from the Dexter query form):
1. You can navigate the old fashioned way(s). Click sequence:
a. American Community Survey home page - http://mcdc.missouri.edu/pub/data/acs/Readme.shtml - from the Navy blue navigation box on our home page.
b. Access Data from the section index at the top of the page .
c. Acs2012 data directory link.
d. Usmcdcprofiles.sas7bdat data set. (Alternately, choose Datasets.html followed by the usmcdcprofiles link in col. 1 of that page).
2. Access the ACS Profiles report application and choose 1-year periods/2012 from the Select Period drop-down. Complete your specs by completing selecting an area type, and subsequent choices that vary based on area type (aka “summary level”). Run the report. (Alternatively, just click on the “Sample Profile Report” link which appear just below the 1. Select period: line. From the generated report page note the gray Other formats box at upper right and the link labeled Extract data via Dexter at the bottom of that box. This will invoke Dexter and pre-select the data directory and data set.
3. Go to the Whatsnew page (link again is in navy blue navigation box at upper left of mcdc home page) and note the article posted 10-07-2012. In the first paragraph it provides you with a direct link to the “link to the Dexter access” to the relevant data set.

Circular Area Profiles (CAPS) from Missouri Census Data Center

They keep doing interesting stuff at the Missouri Census Data Center.

Both the population estimates reports and the new CAPS version are worth checking out. CAPS stands for Circular Area Profiles System (CAPS).

Link to population estimates reports.

Link to ACS CAPS.
This application will aggregate 2007-2011 American Community Survey data to approximate circular areas as specified by the user using a point location and 1 or more radius values. Data used are from the latest tract level 5-year period estimates,

County and ZIP Business Patterns, via Missouri

The Missouri Census Data Center has downloaded and converted County Business Patterns data for 2007 thru 2009. These data are available at the nation, state, county, CBSA (Metropolitan and Micropolitan Statistical Areas), and ZIP code levels. Access these data via the Uexplore/Dexter utility apps; take advantage of the Datasets.html directory page where all the new data has been forced to the top of the access table.

Demographic profile reports

The Missouri Census Data Center has converted the final files in the SF1 Demographic Profile series as released by the Census Bureau. The data tables are accessible via uexplore/dexter. It has also created a set of 4 reports based on these data. Here is the menu page to facilitate access to these reports.

IRS migration data

The IRS has released a new year of state and county level migration flows based on tracking tax returns between 2007 and 2008. As usual, the Missouri Census Data Center has obtained these data and made them available in its public data archive, as well as via its interactive web application that displays a migration profile for any selected county in the U.S.

MDCD used to have to purchase these data on CD-ROM/DVD, but starting this year, the IRS has decided to make the raw files available via a free download site.

You can access the MCDC irsmig data collection, which lets you access the migration profiles menu page.

Missouri Census Data Center Updates

The Missouri Census Data Center has processed a number of new data files and updated some web applications to work with the new 3-year ACS data. The new data include a complete national collection of the ACS 3-year period estimates, both the MCDC's custom profile extracts (similar to the Bureau's profile reports available via AFF) and the complete set of base tables with MOEs. They have also converted the latest income and poverty estimates from the Bureau and the just-released state level population estimates.

For details please visit the MCDC home page - http://mcdc2.missouri.edu/ - and follow the various links from there. Uexplore/Dexter users may find it helpful to visit the MCDC Data Archive home page - http://mcdc2.missouri.edu/applications/uexplore.shtml - and look at the Recent Updates to the Archive section.

Be sure to note that the link to "ACS Profiles" in our Quick Links navigation box now takes you to the revised version of the application, modified to facilitate access to our 4-across profile reports with graphics for both the 3-year period estimates and the single-year data.