What's New at MCDC in 2009

Quick Links ACS Profile Reports ACS Trends Report SF3 Profiles (2000) Circular Area Profiles SF3 Trend Reports Detailed SF3 Profiles IRS Migration Profile Missouri County Data Map Applinks Master Menu MABLE/Geocorr 2K RxA Cure for the Common Codes American FactFinder 2009  February || March || April || May || June June 2009.... MCDC Workshops MCDC staff (Katina Jones, Billy Earney, Jim Harlan, and John Blodgett) presented a series of workshops at Ellis Library and Stewart Hall on the University of Missouri Columbia campus on May 28th, 2009. A reference page with links to presentation slides and other related material can be found here. Population Trends One of the first data products/tools demonstrated at the recent MCDC workshops was the poptrends dynamic web application. Using this tool (which can be viewed by going to the Data Products/Inventory Showcase page and and then clicking on the Select menu (application) link in the first row of the matrix) we created a report that shows trends in selected demographic indicators for selected time periods (going back to 1990 and forward to 2007). We were able to provode a custom title for the report and even to specify that we wanted a blue color scheme (overriding the default green version.) Here is a partial snapshot of that report: Click here to see the full report (in a scrollable sub-window). The report shows clearly how the state's population has been growing over the last 17 years. Looking at the most recent years of data (2006 to 2007) we see that the state grew by almost 41,000 in that year, with only about 22,000 of that accounted for by white non-hispanic persons. Hispanics accounted for almost 9,000 of the increase and African Americans for about 6,500. These data will be refreshed later this month when we expect to get the special estimates data from the National Center for Health Statistics that we use as the source of our demographic trends data. We hope to have 2008 data added to the application before the start of summer. May 2009.... 2008 County Estimates by Age, Race, Sex, Hispanic The Census Bureau has released county level numbers with detail by age, race, sex and hispanic origin. See the Census Bureau estimates page for links to data sets and a presss release. (Veteran users of these estimates will be pleased to note that we are getting these number almost 3 months sooner than in recent years.) The MCDC has downloaded these data into our public archive where they can be accessed via Uexplore/Dexter in the popests data directory (datasets mocasrh08, ilcasrh08, etc - one dataset per state). We have also generated a series of summary reports at the county and metropolitan/micropolitan area levels for all states. To access the Missouri reports use this link, or go to the Population Estimates Reports by State page to access reports for any state in the nation. Here is a sample page from one of the Missouri reports: See the complete report at http://mcdc2.missouri.edu/pub/webrepts/casrh08/mor2county.pdf MCDC To Present Workshops on May 28 The MCDC will present a series of three workshops on May 28 at the campus of the University of Missouri in Columbia. The workshops are being held in conjunction with the Missouri Government Documents Conference being held at the same site on the previous day (May 27). See the workshop web page for details and for a link to the online registration application. (There is no fee involved but registration is required.) Space will be limited so you may want to register early. The three workshops (two of which will be presented concurrently) will cover the American Community Survey, an Introduction to GIS, and a guided tour of the MCDC web site. SF3 Profiles at Census Tract and Block Group Levels You can now access basic demographic profiles based on the 2000 census at the census tract and block group levels for the entire United States using the MCDC's SF3 Profiles (the 3rd item in our Quick Links menu box). Choose United States off the main menu and note that the two new entries on that menu page - Census Tracts and Block Groups. April 2009.... Missouri Taxable Sales Data for 2008 The 2008 taxable sales data for Missouri counties with state totals have been added to the MCDC data archive in the taxales filetype directory. This new set of data is in the identical structure with comparable content as the eight years of previous data already stored in the archive. What is new this year is a data set called taxsales_ranks where we have combined selected or calculated data from all nine years and then added some key ranking variables. We are hoping to develop a dynamic web application that will use the contents of this data set to let users see trends in the sales activity. New Economic Data from the Bureau of Economic Analysis The Bureau of Economic Analysis has released its annual update to the REIS (Region Economic Information System) economic data resource. As we have for the past several years now, the MCDC has downloaded the data and converted the files to a series of SAS data sets covering the country at the state and county levels. Uexplore/Dexter users can access the data sets in the beareis filetype directory. You can also access the data using our BEA Economic Profile web application (also available via applinks and the Missouri County Data Map). Here is an example of what such a profile looks like: The data can also be accessed at the BEA's web site. MCDC to Present Workshops in Late May The MCDC will present a series of three workshops on May 28 at the campus of the University of Missouri in Columbia. The workshops are being held in conjunction with the Missouri Government Documents Conference being held at the same site on the previous day (May 27). See the workshop web page for details and for a link to the online registration application. (There is no fee involved but registration is required.) Space will be limited so you may want to register early. The three workshops (two of which will be presented concurrently) will cover the American Community Survey, an Introduction to GIS, and a guided tour of the MCDC web site. OSEDA Upgrades Missouri County Profiles The Office of Social and Economic Data Analysis, a coordinating agency of the Missouri Census Data Center, has made some significant software and data upgrades to its (MU Extension) Social and Economic profile reports. These can be accessed from the OSEDA Main Menu page for the application, or they can be referenced as one of the applications in the MCDC's applinks scheme. an easy way to see one of these reports from the MCDC home page is to follow the Quick Links entry to Missouri County Data Map and then click on the map within the county of interest. New data for this update include the latest (2008) population estimate with components of change since 2000 ; official county population projections for 2015 and 2025; the latest agricultural data from the 2007 Census of Agriculture; more recent (2007) income and poverty estimates from SAIPE; and the lated BLS unemployment rate (December, 2008). OSEDA plans to update these profiles several times a year as the time series data are refreshed (e.g. a new version should appear in July after the population estimates by age, race, sex and hispanic origin for 2008 become available). Since many of the tables use data from the 2000 decennial census, where there is comparable data now becoming available from the American Community Survey (ACS), the updated reports feature hyperlinks from those tables to the MCDC's ACS Profiles web application. These links are only generated when the county's population indicates that 3-year ACS data are available for it. So there will be no links for Worth, but there will be for Warren. March 2009.... MABLE/Geocorr Update Using the recently released 2008 county level population estimates along with the accompanying county-to-metro area equivalency files from the Census Bureau, the MCDC has updated the MABLE data base and geocorr2k processing module. Users can now access the latest CBSA and CBSA-related geographic codes (CSA's and Metrodivs) and can use 2008 population estimates as weight variables in order to look at how these geographies are related to many others. The previous data being used was vintage 2006. ACS Training Session March 26, 2009 MCDC staff (Katina Jones, Billy Earney and John Blodgett) presented an ACS Training session at Thomas Jefferson Library on the UMSL campus in St. Louis on March 26th, 2009. Presentation slides can be found here. 2008 County Level Population Estimates The Census Bureau has released county level estimates of the population of states, counties and metro areas for the years 2000 to 2008. These estimates show not only the population estimates but also the components of population change -- births, deaths and net migration -- for each of the years. The Missouri Census Data Center has added these data to our public archive and has created several standard data products similar to what we have been doing with these updated estimates for each of the last several years. Specifically: The curmoests.xls Excel spreadsheet file has been updated. There are 4 worksheets within this file and only 1 has been updated - Counties 2008 . These data are for Missouri only and show the revised estimates for the state and each county for each year since the 2000 census. The other 3 worksheets contain data at sub-county levels and these will not be updated until the 2007 sub-county estimates are released (usually in late June or early July). The county data have been aggregated to create summaries at the metropolitan and micropolitan statistical area level for the entire United States. We have also aggregated the data to a number of county-based regions for the state of Missouri only. To view reports based upon these data go to our Population Estimates Reports page and note the revised entries in rows 3 thru 5. Notice that the left column contains a description/hyperlink to the report, while the right column contains the name of the archive data set used to generate the report and doubles as a hyperlink that will take you to the Dexter data extraction utility with that dataset selected for extracting. Progress with Restoration of sf32000 Files Last month we reported that due to a combination of a disk crash and a glitch in our backup system we lost our sf32000 data collection, containing the complete tables from Summary File 3, 2000 decennial census. This is far too important a collection to not recover these data. Here is where we are in our process of putting things back in place. We downloaded the state level csv data files for Missouri, Illinois and Kansas, as well as the national (US) data files. Using SAS code that we wrote back in 2002, which we were able to get from our colleagues in the State Data Center program (Larry Meyers at PSU and Roy Williams at U of Massachussetts), we were able to run conversions on these raw data files to put back our basic collection of datasets. We reran a custom aggregation setup to recreate the important uspumas data set with PUMA-level summaries for the entire U.S. We were able to use the Varlabs metadata files (also returned to us as part of our conversion code kit from same sources as noted above) we were able to rewrite a program to create a series of metadata data sets. This was critical because without these data sets our dexter and sf3tabgen dynamic web applications would not work. They are now back and working (as of 3-18-09). We still have work to do, with a number of custom aggregations to rerun and some metadata files to recreate, but we are well on our way to a near full recovery. Fortunately, the large majority of our end-user usage of these data involve using the standard extracts derived from these complete table data sets. And since those extract datasets were stored in a different filespace they were not affected by the problem. Hence our SF3 Profiles web app has continued to work, although the "drill down to source tables" feature (which uses the sf3taben application) was not working until we were able to recreate the metadata files (yesterday). February 2009.... SF32000 data lost On Feb 24, 2009, we had a hard drive failure. We were able to recover all data except for the sf32000 data directory. We are in the process of trying to rebuild these data sets as well as the related programs and metadata. It may take a while. ACS Profile Reports Offer "Drill Down" to Base Tables The MCDC's ACS Profile reports (see first entry in the Quick Links menu box at right side) now provide users with links to the more detailed base tables from which the profile data are extracted. For example, the first table, AGE, contains the link B01001. Clicking on this link takes you to a display of the more detailed Age by Sex base table which has slightly more detailed age cohorts and is broken down by gender. It displays this table for each geographic area you have selected. The base table display module is considered an "alpha" (test) version and we are continuing to work on refinements. These involve displaying multiple geographies across the page instead of down (consistent with how the profile data are displayed) and using fonts/colors to indicate levels of statistical uncertainty based on margin of error values. 2007 Census of Agriculture The U.S. Department of Agriculture has released the results of the 2007 Census of Agriculture. They have created an extensive web site with easy access to voluminous state and county level profiles. See, for example, the Missouri County Level Data index page which lets you access the 56 county-level profile reports for Missouri. (See the state level index if you want to access comparable data for any state.) Or visit the Ag Census 2007 home page at http://www.agcensus.usda.gov/index.asp. The MCDC has downloaded the data used in these profiles and is in the process of converting it to a form consistent with our data archive. Uexplore/Dexter users can access the new ag2007 filetype (data directory) in order to access these data in a database format. We are still working on the conversion process but do have a preliminary data set with the data included in Table 1: County Summary Highlights for all states and counties in the country. New County Economic Profiles You can now view the MCDC's economic profiles based upon the Bureau of Economic Analysis REIS profiles. The reports contain basic economic indicators for the years 1969 thru 2006 (with 2007 data scheduled to be available in the spring). See a sample report or access the front-end web page which allows you to specify the geographic areas, years, data detail, etc. for your customized report. You can also access the reports for Missouri counties using the Missouri County Data Map front end (see link in our Quick Links box), or you can follow the link at the bottom of that page to select any state in the U.S. and be taken to the applinks menu page for choosing a county. The Regional Economic Profile application is now the very first item shown on the applinks page. Other "What's New" by Year: 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002

This file last modified Wednesday July 01, 2009, 08:03:34