Missouri Census Data Center

----- September 22, 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

American Community Survey Data for 2013 Released

The Census Bureau has released the first wave of data products based on the calendar year 2013 ACS surveys. These data are for larger geographic areas of at least 65,000 population. The 3-year (2011-2013) data are due to be released next month and the 5-year estimates (2009-2013) in December. See an example profile report using the new data or access our ACS Profiles web app and choose 2013 from the Select Period drop down. The profiles are available for the entire country.

Uexplore/Dexter users can access the new data to select just the data they want in just the desired format(s). The standard profile data can be found in the usmcdcprofiles data set in the acs2013 data directory. If you need access to the more detailed summary (base) tables you should select the basetbls subdirectory. The conventions are the same as used in prior cycles, with tables split into six subsets based on related topics. As usual, we have generated a Varlabs subdirectory (within the basetbls subdirectory of the acs2013 directory) where you can find the critical metadata that tells you what tables are available and what they contain. For example, in the 25_28labels.txt file (under Varlabs), here is a snapshot of what you'll see there:

/* B28001. TYPES OF COMPUTERS IN HOUSEHOLD */ /* Universe: Households */ B28001i1 ="Total:" B28001i2 =" Has a computer:" B28001i3 =" Desktop or laptop" B28001i4 =" Desktop or laptop alone" B28001i5 =" Handheld computer" B28001i6 =" Handheld computer alone" B28001i7 =" Other computer" B28001i8 =" Other computer alone" B28001i9 =" No Computer" /* B28002. PRESENCE AND TYPES OF INTERNET SUBSCRIPTIONS IN HOUSEHOLD */ /* Universe: Households */ B28002i1 ="Total:" B28002i2 =" With an Internet subscription:" B28002i3 =" Dial-up alone" B28002i4 =" DSL:" B28002i5 =" With mobile broadband" B28002i6 =" Without mobile broadband" B28002i7 =" Cable modem:" B28002i8 =" With mobile broadband" B28002i9 =" Without mobile broadband" B28002i10 =" Fiber-optic:" B28002i11 =" With mobile broadband" B28002i12 =" Without mobile broadband" B28002i13 =" Satellite Internet service:" B28002i14 =" With mobile broadband" B28002i15 =" Without mobile broadband" B28002i16 =" Two or more fixed broadband types, or other:" B28002i17 =" With mobile broadband" B28002i18 =" Without mobile broadband" B28002i19 =" Mobile broadband alone or with dialup" B28002i20 =" Internet access without a subscription" B28002i21 =" No Internet access" /* B28003. PRESENCE OF A COMPUTER AND TYPE OF INTERNET SUBSCRIPTION IN HOUSEHOLD */ /* Universe: Households */ B28003i1 ="Total:" B28003i2 =" Has a computer:" B28003i3 =" With dial-up Internet subscription alone" B28003i4 =" With a broadband Internet subscription" B28003i5 =" Without an Internet subscription" B28003i6 =" No computer"

This describes the first 3 of over 20 new (first ever!) tables dealing with the topics of computer and Internet access. You can access these data (just these 3 out of hundreds of detailed summary tables, or whichever you choose off the Tables select menu) by clicking on the uexplore basetbls directory link, and then choosing the ustabs25_28 data set from that menu page.

This takes you to Dexter. From there you can code a data "filter" in Sec.II of the form : State Equal To (=) 29 to specify you only want data pertaining to Missouri. Select a trio of ID varibles in Sec.III of the form and select the 3 tables (B28001 thru B28003) from the list on the right side of the query form. Your query is complete so click the Extract Data button. Within a few seconds you'll have an output screen that summarizes the results of your query and contains a link to the delimited output file which looks something like this:

 geoid	AreaName	Geocomp_Name	B28001i1	B28001i2	B28001i3	B28001i4	B28001i5	B28001i6	B28001
"Geographic ID (Census)" 	" " 	" " 	"Total:" 	"Has a computer:" 	"Desktop or laptop" 	"Desktop
04000US29	Missouri		2362853	1945008	1804472	497469	1433572	133046	97987	3773	417845	2362853	
04001US29	Missouri	Urban	1686793	1418641	1319834	323625	1084951	92848	75842	2804	268152	168679
04043US29	Missouri	Rural	676060	526367	484638	173844	348621	40198	22145	969	149693	676060	
040A0US29	Missouri	In metropolitan or micropolitan statistical area	2035797	1704829	1588025	4066
040C0US29	Missouri	In metropolitan statistical area	1763984	1490311	1390763	339137	1140151	9349
040C1US29	Missouri	In metropolitan statistical areaŚin principal city	558212	453401	418067	99
040C2US29	Missouri	In metropolitan statistical areaŚnot in principal city	1205772	1036910	972696
040E0US29	Missouri	In micropolitan statistical area	271813	214518	197262	67532	145609	16386	
040E1US29	Missouri	In micropolitan statistical areaŚin principal city	97426	78058	72227	21766	56
040E2US29	Missouri	In micropolitan statistical areaŚnot in principal city	174387	136460	125035
040G0US29	Missouri	Not in metropolitan or micropolitan statistical area	327056	240179	216447	
040H0US29	Missouri	Not in metropolitan statistical area	598869	454697	413709	158332	293421	
05000US29019	Boone County, Missouri		67680	60644	58139	10499	49878	2428	2775	77	7036	67680	
05000US29021	Buchanan County, Missouri		32448	25691	23939	6974	18331	1530	1492	0	6757	32448	
05000US29031	Cape Girardeau County, Missouri		29621	22975	21777	6872	16103	1198	827	0	6646	29
05000US29037	Cass County, Missouri		37378	33839	32067	8255	25279	1757	2387	15	3539	37378	30
05000US29043	Christian County, Missouri		29915	25770	24490	6176	19545	1280	1369	0	4145	2991
05000US29047	Clay County, Missouri		87712	78282	72303	15131	61937	5042	6080	409	9430	87712	68
05000US29051	Cole County, Missouri		28441	23247	21405	5061	18038	1798	930	0	5194	28441	20571	
05000US29071	Franklin County, Missouri		39255	33380	31114	10087	22615	1734	2651	393	5875	3925
05000US29077	Greene County, Missouri		118068	99130	93191	23710	74026	5402	7490	339	18938	1180
05000US29095	Jackson County, Missouri		274269	226189	206525	49440	174850	18378	14093	517	48
05000US29097	Jasper County, Missouri		45456	35628	32692	8983	26475	2827	981	109	9828	45456	28
05000US29099	Jefferson County, Missouri		82011	71446	67876	17863	53153	3341	2640	99	10565	82
05000US29165	Platte County, Missouri		37664	35054	31980	6464	28342	2903	1857	171	2610	37664	
05000US29183	St. Charles County, Missouri		138788	126456	121833	21817	104148	4509	4711	71
05000US29187	St. Francois County, Missouri		24435	18096	16288	5349	12695	1756	601	52	6339	24
05000US29189	St. Louis County, Missouri		401795	348874	330168	76085	271073	18065	16971	162	
05000US29510	St. Louis city, Missouri		140536	106055	95861	23168	81865	9319	8202	234	34481	
06000US2901915688	Columbia township, Boone County, Missouri		25807	23785	22584	3665	19899	1124	
06000US2902177236	Washington township, Buchanan County, Missouri		28560	22788	21259	6459	15943	
06000US2904726290	Gallatin township, Clay County, Missouri		31106	26796	24243	5788	20488	1860	
06000US2907770009	Springfield township, Greene County, Missouri		72173	59710	55298	15431	43190	39
06000US2909506490	Blue township, Jackson County, Missouri		64344	50136	44751	13251	36599	4725	21
06000US2909508686	Brooking township, Jackson County, Missouri		30119	23490	20515	6549	16735	2850
06000US2909538054	Kaw township, Jackson County, Missouri		78734	61988	57553	12165	48778	4156	60
06000US2909559564	Prairie township, Jackson County, Missouri		36329	33442	31868	5629	27813	1552
06000US2909568438	Sni-A-Bar township, Jackson County, Missouri		30367	27874	25549	5228	22441	22
06000US2909577506	Washington township, Jackson County, Missouri		28518	24064	21308	5379	18528	26
06000US2951065000	St. Louis city, St. Louis city, Missouri		140536	106055	95861	23168	81865	93
16000US2915670	Columbia city, Missouri		46626	42310	40757	6593	35496	1476	2296	77	4316	4662
16000US2935000	Independence city, Missouri		49305	40138	36377	10934	29021	3402	1392	0	9167	49
16000US2938000	Kansas City city, Missouri		193340	159580	145287	33090	124081	13194	12601	77
16000US2941348	Lee's Summit city, Missouri		33628	31086	29713	5376	25710	1373	1840	0	2542	33
16000US2954074	O'Fallon city, Missouri		29036	27290	26145	4090	22984	1074	1890	71	1746	2903
16000US2964082	St. Charles city, Missouri		26477	23052	22252	4485	18567	800	408	0	3425	26477	
16000US2964550	St. Joseph city, Missouri		27774	22127	20573	6241	15500	1332	1374	0	5647	2777
16000US2965000	St. Louis city, Missouri		140536	106055	95861	23168	81865	9319	8202	234	3448
16000US2970000	Springfield city, Missouri		72173	59710	55298	15431	43190	3952	4351	262	12463 
(etc)... 

(Truncated to fit here. We actually selected Tab-delimited rather than the default comma-delimited in Sec. I of the Dexter form so that the output would be a bit more readable here. In practical use you would generally want to leave the default comma-delimited which is then very easy to save to your dekstop and open in Excel. Note that the first 2 rows of the file contain data descriptor information with the actual data beginning on row 3.)

If you would like to see this data extraction live, or perhaps run something similar for a state other than Missouri we have saved this query in a library where you can access it. The direct link to the query file is http://mcdc.missouri.edu/data/acs2013/Queries/B28_3tabs_1state.html . (The normal way you would find and access it is via Uexplore; access the acs2013 filetype, select the Queries subdirectory and then the B28_3tabs_1state.html file.)

To run the same query but for Illinois instead of Missouri you need to replace the state code in Sec. II of the form with the FIPS code for the new state. Enter 17 to get Illinois. If you wanted to run it for both Missouri and Illinois you could change the value of Operator from Equal to(=) to In List.. (using drop down) and then in the Value text box enter 17:29 . Entering 34:36 would get you the requested tables for the states of New York and New Jersey. Choosing different tables would be a matter of changing what you select in the Tables list in Sec. III (note the tables are in table number order, with the [B/C]28 tables at the bottom).

This file last modified Tuesday October 14, 2014, 10:47:56

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