Missouri Census Data Center

----- October 27, 2014 -----

Quick Links
ACS Profile Reports
ACS Profile extract app
ACS Trends Reports

2010 Census SF1 Profile
SF1 Data extract app

Circular Area Profiles (2010 census data)

Pop Trend Reports
Pop Estimates by Age

MO County Data Map
Applinks Master Menu

MABLE/Geocorr 2012
RxA Cure for the Common Codes

  SF3 Profiles (2000)
SF3 Trend Reports

Latest 3-year ACS Period Estimates Available

The Census Bureau released the American Community Survey 2011-2013 period estimates on Thursday, Oct. 23. As of Friday, 10-24, you can now access the MCDC's standard profile data for this release. To view the data in profile report format use the ACS Profiles we application (this is the first link in our Quick Links box). The data can also be accessed via Uexplore/Dexter in the usmcdcprofiles3yr and usmcdcprofiles3yralt data sets. (The "alt" version contains the same data as the original but has all the _moe variables moved to the end of the observation.)

Summary (aka "Base") Tables Available for the 2011-2013 ACS Estimates

You can now access the detailed summary tables containing 3-year period estimates, 2011-2013. These have been stored with the usual partitioning into 6 topic-based datasets, each containing data for the entire U.S. Estimates and MOEs are stored in separate data sets, which can be linked (after they have been extracted to your site) using the key field Logrecno (or, alternatively, you can use State, Geoid). To access use Uexplore go to access the acs2013/basetbls data directory. If you want to access table C17001 (with poverty by age) select data set ustabs17_203yr . Once in Dexter you'll note that the select list on the right lets you choose tables rather than individual cells (variables). Just select the C17001 table (or any of hundreds of other tables for the range of topics for this data set (Poverty=17, Disability=18, Income=19 and Individual Earnings=20). See the complete table outline metadata in the Varlabs subdirectory of basetbls. Accessing the module 17_20labels.txt module, for example, displays a page that starts like this:

/* Generated at 09:18 on 24SEP14 */ LABEL /* B17001. POVERTY STATUS IN THE PAST 12 MONTHS BY SEX BY AGE */ /* Universe: Population for whom poverty status is determined */ /* *** This table is repeated for the following Race/Hispanic/PR suffixes: _ABCDEFGHI *** */ B17001i1 ="Total:" B17001i2 =" Income in the past 12 months below poverty level:" B17001i3 =" Male:" B17001i4 =" Under 5 years" B17001i5 =" 5 years" B17001i6 =" 6 to 11 years" B17001i7 =" 12 to 14 years" B17001i8 =" 15 years" B17001i9 =" 16 and 17 years" B17001i10 =" 18 to 24 years" B17001i11 =" 25 to 34 years" B17001i12 =" 35 to 44 years" B17001i13 =" 45 to 54 years" B17001i14 =" 55 to 64 years" B17001i15 =" 65 to 74 years" B17001i16 =" 75 years and over" B17001i17 =" Female:" B17001i18 =" Under 5 years" B17001i19 =" 5 years" B17001i20 =" 6 to 11 years" B17001i21 =" 12 to 14 years" B17001i22 =" 15 years" B17001i23 =" 16 and 17 years" B17001i24 =" 18 to 24 years" B17001i25 =" 25 to 34 years" B17001i26 =" 35 to 44 years" B17001i27 =" 45 to 54 years" B17001i28 =" 55 to 64 years" B17001i29 =" 65 to 74 years" B17001i30 =" 75 years and over" B17001i31 =" Income in the past 12 months at or above poverty level:" .... /* C17001. POVERTY STATUS IN THE PAST 12 MONTHS BY SEX BY AGE */ /* Universe: Population for whom poverty status is determined */ /* *** This table is repeated for the following Race/Hispanic/PR suffixes: _ABCDEFGHI *** */ C17001i1 ="Total:" C17001i2 =" Income in the past 12 months below poverty level:" C17001i3 =" Male:" C17001i4 =" Under 18 years" C17001i5 =" 18 to 64 years" C17001i6 =" 65 years and over" C17001i7 =" Female:" C17001i8 =" Under 18 years" C17001i9 =" 18 to 64 years" C17001i10 =" 65 years and over" C17001i11 =" Income in the past 12 months at or above poverty level:" C17001i12 =" Male:" C17001i13 =" Under 18 years" C17001i14 =" 18 to 64 years" C17001i15 =" 65 years and over" C17001i16 =" Female:" C17001i17 =" Under 18 years" C17001i18 =" 18 to 64 years" C17001i19 =" 65 years and over" /* B17002. RATIO OF INCOME TO POVERTY LEVEL IN THE PAST 12 MONTHS */ /* Universe: Population for whom poverty status is determined */ B17002i1 ="Total:" B17002i2 =" Under .50" B17002i3 =" .50 to .74" B17002i4 =" .75 to .99" B17002i5 =" 1.00 to 1.24" B17002i6 =" 1.25 to 1.49" B17002i7 =" 1.50 to 1.74" B17002i8 =" 1.75 to 1.84" B17002i9 =" 1.85 to 1.99" B17002i10 =" 2.00 to 2.99" B17002i11 =" 3.00 to 3.99" B17002i12 =" 4.00 to 4.99" B17002i13 =" 5.00 and over"

Note that table topic 28=Computer Ownership and Internet Use is not available for these data. That is because the questions on those topics were first asked in 2013, and you cannot get a 3-year summary based on questions that were not asked in all 3 years.

This file last modified Monday October 27, 2014, 11:14:34

To see previous matter posted to this page (after May, 2013) visit our oldhome directory.


Site Map    |    Our URL    |   
The Missouri Census Data Center is a sponsored program of the Missouri State Library within the office of the Missouri Secretary of State. The MCDC has been a partner in the U.S. Census Bureau's State Data Center program since 1979.

Questions/Comments regarding this page or this web site are strongly encouraged and can be sent to