Welcome Back and What's New

For those of you who may have been away for the summer, we welcome you back. We thought it would be a good idea to let you know what we have been up to over the last three months or so. As you probably know we no longer routinely post notices regarding new data, new/revised web applications, new training modules or other newsworthy items here on the MCDC home page. Instead we post them directly to our What's New page (second link in the navy blue navigation box at upper left).

The link is actually to the #current anchor location within the whatsnew page, so that it scrolls you forward to a recently-added article. Note that, unlike our whatsnew pages in prior years, the 2013 version is sorted in chronological order, with the latest articles at the bottom.

One other in-case-you-missed-it note: We now copy articles that (used to) appear here on the home page to our new oldhome directory. There is a link to this directory at the bottom of this page. For example, we recently posted an article here summarizing recent trends in Missouri's population with components of change. That article can now be viewed at this oldhome page.

What (Was) New: June to August, 2013

New version of CAPS works with 5-year ACS Estimates

Posted 6-4-2013

This application accesses census tract-level American Community Survey data (our standard "MCDC profile" data) and generates data for circular areas. So you can use it (for example) to get a feel for the characterisitics of persons living within a 5-mile radius of an existing or proposed site (includes not only the basic demographics, which are already available from our caps10c applicaition, but also the "good stuff" only available from the ACS - income, poverty, education, housing values, etc.) The application has a built-in limit of a 2-mile radius; so you cannot use it for circles smaller than this. The application is called caps10acs and you can access it at http://mcdc.missouri.edu/websas/caps10acs.html.

Population estimates at state and county levels with Demographic Detail for 2012

Posted 6-13-2013

These data were released by the Bureau today. The MCDC has downloaded the data and processed it as we have for several years now. The results can be viewed in the usual standard report formats by accessing the Estimates Reports page. There are the same set of 4 reports for each state (at state, county and metro area levels), and for the United States at the state and nation levels.

The raw data can be accessed in the public archive in the usual locations. The data as downloaded and converted more or less as-is can be viewed in the casrhalt subdirectory of the popests data directory. The best way to access the new data in the main directory, where we have done our usual reshaping of the data in an attempt to make it easier to code extraction queries based on the various cominations of demographic detail, is via the Dataset.html page within the popests directory. There are 51 datasets with names such as mocasrh12, ilcasrh12, cacasrh12, etc. each with data for a specific state. Two other datasets of interest are usstatescasrh12, which contains data summarized at the state level for all the states; and us1dimsums_casrh12, which contains county-level data for the entire US. The "1dim" in the name indicates one-dimensional summaries, meaning each observation provides estimates for a single demographic dimension: one for for each race alone, one for each gender, one row for each 5-year age cohort, one row for each Hispanic/non-Hispanic.

All the county-level datasets have been enhanced by merging the latest (March, 2013) metro area ("CBSA") codes and types, making it relatively easy to aggregate queries at the metro area or metro area type (Metro, Micro or blank) levels.

Poptrend1 Web Application Updated

Posted 6-20-2013

One of our simplest and yet quite useful dynamic web applications is the poptredn1 module. It simply displays the trends in a state or county's population year-by-year going back to 2000 and forward to the most recently available. The application has been updated to now include the two major components of change for each year: Natural Increase (births - deaths) and Net Migration. The usual 1990-style retro line-printer bar chart depicting Total Pop Change by year is still there, and is now followed by a similar chart for the Net Migration component. For those users who are not satisfied with the simplicity of these old-fashioned charts there are now more modern gif files with color charts of the same data, available via links inserted between the reports and the old line charts.

The best way to access this application is via the applinks menu pages. Start with the state of Missouri page . Look for the Population Trends 1 row/link. Use the navigation links at the top of the page to access the Missouri counties menu page, where you can choose any county in Mo. Or, you can follow the link to the US menu page from which you can select another state and then, if desired, any county within that state.

Missouri Taxable Sales Data for 2012

Posted 6-24-2013

After a 4-year hiatus we have brought back the Missouri taxable sales data, summarized by SIC and county/state. Access new mosicst12 and mosiccnty12 data sets using Dexter web application in the taxsales data directory.

BLS Unemployment Data Thru April, 2013 Added to Data Archive

Posted 6-26-2013

The bls_la (Local Area employment data) for state and counties was updated for the first time in 4 years. This is a time-series dataset, with data at the state level going back to 1976 and at the county level back to 1990. Counts of employed and unemployed persons as well as the unemployment rates are provided for each year. Access new usstcnty13 and mostcnty13 data sets using Dexter web application in the bls_la data directory.

County Business Patterns Data for 2010, 2011 Added to Data Archive

Posted 7-01-2013

The county business patterns (filetype CBP) data for years 2010 and 2011 have been added. There are six datasets per years with data summarized at the nation, state, county, metro area (CBSA) and ZIP code levels. There are many observations per geographic area with detailed breakdowns by SIC-code business categories. This makes the datasets quite large (e.g. over 2 million observations for the 2011 county level data in uscos11. Access the new data via uexplore/dexter in the cbp data directory. Use the Datasets.html page.

New Housing Unit Estimates Data Thru 2012 Added to Data Archive

Posted 7-02-2013

It took us an extra day since the Bureau changed the way they distribute the data (now using American FactFinder instead of a custom csv file). But we have created two new datasets in the popests data directory: ushuest2012 and mohuest2012. They contain data at the state, county and nation level with housing unit estimates for July 1 to 2010 thru 2012, along with 2010 census counts. Access the new data via uexplore/dexter in the popests data directory. Use the Datasets.html page, lines 5 and 42. See the original data release at the Bureau web site.

Social and Economic Profile Data/Reports Updated for 2013

Posted 7-10-2013

The Social and Economic Profiles data and reports are an OSEDA project done at the behest of and primarily for the benefit of community development specialists working with University (MU) Extension. These data get updated at least once a year in order to keep them fresh. For example, in this 2013 update we have "refreshed" (i.e. added or replaced data items with more current values) all the 2012 vintage population estimates data, new poverty estimates from SAIPE, new economic indicators from the BEA REIS data, new indicators related to children from the Kids Count database, and the most recent unemployment figures from the BLS. Most users will want to access these data as profiles (formatted reports) and can do so using the (new) menu page at http://www.oseda.missouri.edu/countypage/county_seir13.shtml. Note that we have not (yet) updated the Narrative profiles, just the Data Tables. We also have not yet aggregated the data to UM extension regions. The links to Additional Information on this menu page (county_seir13.shtml) now reference the MCDC's applinks page for that county.

Uexplore/Dexter users can access the single dataset containing all the data used in these profiles. The data directory ("filetype") is cntypage and the dataset is named merged13. The direct URL for accessing this dataset is http://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.uex2dex.sas&_SERVICE=appdev&path=/pub/data/cntypage&dset=merged13&view=0 ; this link has been added to the menu page. (For those purists who want to navigate to this using the Uexplore home page, you can find the link to the cntypage filetype within the Compendia Major Category section.)

MCDC-Estimated CD and State Legislative District ACS Profiles Available

Posted 7-13-2013

The MCDC has created a new web application that works specifically with our three national datasets at the 113th Congressional District and current ("2012") state legislative district levels. To access it use the new single menu page at http://mcdc.missouri.edu/webrepts/uslegdistprofiles.html. These are very similar, especially in terms of content, to our usual ACS Profiles reports.

Note that we previously (see the Februrary, 2013 article) reported on the existence of these data and how to access them via Dexter. But having the data in the profile report format should make it accessible to a much broader audience. The profile reports contain a link (at the bottom) to that February article that deals with how to access the underlying datasets. Note that they can be easily accessed via the ACS Extract Assistant app, which did not exist back in February.

Error Found in CAPS10c Output

Posted 7-24-2013

Our thanks to Wilson Hunter of David & Floyd (Greenway SC) who alerted us to a problem with the Percent field in the Change in Population 200-2010 item in the "1.Total Population Trends, Etc." portion of the caps10c (Circular Area Profiles - 2010 Census data) output. The calculation was being done with a utility module that handled the calculation as a weighted average of the PctChangePop variables weighted by the TotPop00 variable. The problem with this is we have blocks with 0 population in 2000 but with positive change over the decade. This causes the weighted-average approach to be off in circular areas that had blocks going from 0 to non-0 over the decade. The data needed to verify the calculation is right there in the report (just divide the Change by the 2000 population and multiply by 100.) We have fixed our code (as of approximately 10 AM CDT today) so it now correctly calculates the percentage.

Revised Version of Video-based Dexter Quick Start Guide

Posted 7-31-2013

This new video-based tutorial can be accessed directly at http://mcdc.missouri.edu/tutorials/dexter_quickstart_video2. It covers basic examples of using the Uexplore/Dexter software to create data extracts. This tutorial replaces an earlier version. It breaks the material down into smaller video modules, and has more examples. The tutorial can also be linked to by following the link to the "Dexter Quick Start Guide" displayed at the top of the Dexter Query Form.

Two Population Estimates Web Applications Updated For 2012 Data

Posted 8-03-2013
Rev. 8-12-2013

The Pop Estimates by Age and Pop Trend Reports (both accessible via entries in our Quick Links box) have been updated to provide access to the most recent (2012) available data. These applications both use the data from the National Center for Health Statistics in our popests/nchsbri data directory. The Pop Trend Reports now includes links to sample output (report and charts) as well as to a short video tutorial showing how the sample output was produced.

New Post-2010 Estimates Data Added to popests/nchsbri Data Directory

Posted 8-05-2013

We have downloaded the latest bridged-race population estimates data for 2012 from the National Center for Health Statistics web site. These data are very similar to the "casrh" (county age sex race hispanic) estimates from the Census Bureau (these data sets were created by the Census Bureau for the NCHS), except that they used 4 "bridged" race categories and do single years of age. We replace the collection of "201x" data sets each year. See the Readme file (in the /pub/data/popests/nchsbri directory) for a detailed description of these data sets.

ACS Trends Report Get Major Makeover

Posted 8-13-2013

The ACS Trend Reports application (http://mcdc.missouri.edu/acs/trends/menu.php has been substanitally modified, similar to what was done with the ACS Profile Reports back in April. The charting feature now works for both these apps (ACS Profiles and Trends). We made a few changes to the chart presentations, the biggest being to now use SVG graphics, rather than Flash (AnyCharts). This means the charts are now viewable on iPads and other recent devices that donít support Flash.

In case you missed it, we have also added an online tutorial for the ACS Profiles application. That tutorial has been significantly updated to reflect the revisions in the application.

MCDC Navigation Boxes Get Minor Revisions

Posted 8-13-2013

Just in case you were wondering why that link to the SF1 2010 Census Profile report was no longer at the very top of the Quick Links box on the Missouri Census Data Center home page, it's because we did some minor editing of Quick Links and its companion, the "Navy Blue Navigation Box" which usually appears at the upper left of MCDC pages. We have rearranged the links and dropped just a few, hoping to create more logical grouping and to put the "hottest" links at the top.

ZCTA_master Data Set(s) Updated

Posted 8-19-2013

The MCDC has a long history of providing special geographic reference data pertaining to ZIP Code/ZCTA geography. One of the most important resources that we provide in this area is the georef.zcta_master data set, i.e. the set named zcta_master within the /pub/dat/georef data directory (see the Datasets.html page and follow the links in the second row to access via Dexter. You can also access the zctamstr subdirectory of the georef data directory, where we have a collection of 51 state-based data sets with the same data.)

This new version replaces the one generated in September of last year and has a number of important updates. Probably the most important upgrade is that we now offer official 2007-2011 five-year period estimates for the ZCTAs as published by the Census Bureau in December, 2012. In the previous version we just had our unofficial guesstimates based on allocating/aggregating tract level data for 2006-2010. Other key updates involve geographic identifiers at the Urban Area and Congressional District (where we know have 113th - current) levels. The metadata files have been updated and enhanced to provide current and somewhat more extensive explanations. A video-based tutorial is being planned.