|
2008
January || February || March || April ||
June
June 2008
New Site Map Page
The MCDC has created a new sitemap page which organizes many of our most important and frequently-accessed pages into nine (initially) major subject categories. An excellent alternative starter page for users who want to find out what's available and most frequently accessed on the site. A link to this site map is included near the bottom of most MCDC web site pages (including this one, of course).
New Tutorials re This Web Site
We have created a new pair of powerpoint tutorials for users wanting a guided tour of some of the most frequently used resources available on this site. Things to See and Do on the MCDC Web Site and its companion module (aptly named More Things to See and Do ...) were created as a replacement for and enhancement of the MCDC Quick Tour page. They have already been used in-house as training modules for MCDC staff. They shall form the basis of workshop presentations during the upcoming year.
Marking Twenty Years of MU's Coordinating Role
It has been 20 years since the first contract-for-services agreement went into effect between the Missouri State Library (as lead agency of the Missouri State Data Center, as it was then called) and a consortium of University of Missouri agencies under the leadership of OSEDA - the Office of Social and Economic Data Analysis. The contract was for computing and other technical services related to the state's Data Center program, and has continued as such ever since. The new contract being worked out now between the two agencies will be our 21st consecutive 1-year agreement.
April 2008
New Missouri Population Projections Released
The following press release was issued by the Missouri Office of Administration on Friday, April 25:
State Releases Population Projections through 2030
JEFFERSON CITY - Commissioner of Administration Larry Schepker announced today that the state has released a new set of population projections for the State of Missouri, all 114 counties and the City of St. Louis, through the year 2030. "I hope these projections assist individuals and communities across the state by providing additional information about Missouri population trends," the Commissioner stated.
Based on the latest projections:
- Missouri's population is expected to approach 6.8 million people in 2030, a growth of roughly 1.2 million people from the year 2000, which will represent a 21% increase in the state's population.
- Missouri's rank among the nation's most populous states has been on the decline since the turn of the century, when Missouri ranked fifth in the nation. Missouri's standing fell two positions during the decade of the 1990s dropping from the fifteenth spot in 1990 to seventeenth by 2000. Missouri's projected growth rate of approximately 6% per decade is slower than the nation's projected rate of 10% per decade.
- By 2030, persons over age 65 will represent more than one-fifth of all Missourians. Senior citizens are expected to increase 87% between 2000 and 2030 when there are projected to be 1.4 million seniors.
- The number of children under the age of 18 in Missouri is expected to increase but not as rapidly as persons 18 and over. Between 2000 and 2030, Missouri children are expected to increase by roughly 7% while the 18 and over population will increase by nearly 25%.
- Natural change (births minus deaths) will continue to add the largest number of people to Missouri's population. Natural change is expected to add an average of 244,000 Missourians per decade. Moreover, net migration (those migrating in compared to those migrating out) is expected to further increase Missouri's population by 139,000 persons every ten years.
The projections were completed by the State Demographer, housed in the Office of Administration's Division of Budget and Planning. The projections were reviewed by a team of demographic experts before being released. Note: The projections do not include breakouts by ethnic group. 2007 estimates of Missouri's population by race and ethnicity will be available, by county, in August of 2008 from the U.S. Census Bureau.
More information and the complete set of projections can be found at the following link: http://www.oa.mo.gov/bp/projections/.
(View the complete press release on the OA web site at http://www.oa.mo.gov/co/releases/042508PopProjections.htm.)
The projected data are also available here on the MCDC web site (for access via Uexplore/Dexter) in a new filetype/subdirectory, moprojs (Missouri projections). In addition to the raw data we have also created a directory of xls (Excel spreadsheet) files which include population pyramid charts. We also aggregated the data to county-based regions and provided a pair of alternative datasets where we transposed the data so that projection years become row IDs and the demographic categories (age and sex) become columns (variables).
New Economic Data From BEA
The Bureau of Economic Analysis has released its annually updated Regional Economic Information System ("REIS") data, with estimates through 2006.
The MCDC has downloaded and converted that data and it can be accessed from our data archive using the
Uexplore/Dexter web tools, in the
beareis data directory.
New Population Trends Application
Access this new application from this menu page.
You will be able to choose a state of interest, 1 or more counties within that state, any of 8 different time periods ranging from 1990-2006 to 2005-2006, and any of 13 key demographic categories (total population, black population, hispanic population, elderly population, etc.) The results are displayed in a new format for the MCDC. The rows of the column are contained in a scrollable table where the column headers are fixed as you scroll through the data lines. The report can be printed and it will handle page breaks and repeating the column headers on each printed page (even though it is an html file, not a pdf.)
We are working on adding a button to let you save the report data to an excel file.
You can also go directly to a report (bypassing the front-end window) where the geography is pre-chosen and all time periods and demographic indicators are specified by using our applinks interface tool. (See the Applinks Master Menu link or (for Missouri counties only) use the Missouri County Data Map link, both from the Quick Links box on the right of this page.) After the report is displayed there is a link at the bottom of the report that takes you to the menu page in case you want to customize the report or select different geography. The application supports multiple geographies within a state.
March 2008
2007 County Level Population Estimates
The Census Bureau has released county level estimates of the population of states and counties for the years 2000 to 2007. 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 2007 . 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.
February 2008
In Case You Hadn't Noticed
We have made some changes to the two standard navigational boxes that appear on this and many other MCDC web pages. Users
should note the prestigious top position within our Quick Links box is now occupied by a link to our ACS Profile Reports application. This reflects the importance of this application as a primary resource for accessing the American Community
Survey data as released by the Census Bureau. Expect this application to continue to evolve (as it has been doing over the last several months in case you have not tried it lately.) More changes are underway as we write this, involving the addition of graphics (charts and maps).
The applinks utility application, accessible from the Applinks Master Menu link (in the Navy blue navigation box) or from the Missouri County Data Map (Quick Links item), has been revised so that a link to the ACS Profiles links appears first (although the report is still not available for areas of less than 65,000 population). We have also grouped all the 2000 census links and moved them to the bottom of the menu page in
order to give more prominence to applications that feature more current data.
State Estimates for 2007 Show Little Change in Missouri
The Census Bureau has released the first set of population estimates for 2007. These are at the state and nation level only
(no counties) and have estimates regarding the components of change in population since the 2000 census. The data show that
Missouri had an estimated population of 5,878,415 as of July 1 of last year. This represents an increase of 281,732 persons (5.0%) since the 2000 census, with net migration accounting for about 40% of the growth and natural increase the other 60%. Missouri now (2007) ranks as the 18th largest state in terms of population (from 17th at the time
of the 2000 census). It also ranks 18th in terms of absolute population growth since 2000, but only 27th in percentage increase. Over the most recent 1-year period (2006-2007) the Bureau estimates that the state had a net population gain of 40,776 or .7% (that's less than 1%; 7/10ths of 1%, to be precise). For those
who follow these numbers carefully you will note that the 2006 estimate for the state was 5,849,369 as originally published last year. However, when the Bureau issues these estimates they also revise estimates for earlier years and the revised 2006 estimate for Missouri is 5,837,639 (a decline of 11,730 from the original estimate). So that increase of 40,776 is based on the lower revised
estimate. The new estimate is only 29,049 higher than last year's original figure.
See a report showing key data items in our population estimates reports directory. This report shows data for all states and includes a second version of the report showing how each of the data
items ranks among the states. The raw data file can be accessed in the MCDC's popests data directory (/pub/data/popests) in either csv format (for Excel users) or as a
SAS dataset via uexplore/Dexter (for those familiar with Dexter).
Comparable data at the state and county level is due to be released by the Bureau in late March, with place (city) level numbers in late June (without the components-of-change detail).
Changes to MCDC Personnel
There have been a number of changes to key positions within the Missouri Census Data Center lead and core agencies in recent months:
- In October Lindsay McCarroll resigned from her coordinator position at the Missouri State Library. The library is currently advertising to fill this position. Barbara Reading is once again serving as the interim coordinator of the MCDC program.
- In September Matt Hesser was hired by the Missouri Office of Administration as the the new State Demographer. Matt takes
over the position that was held for many years by Ryan Burson prior to his resignation at the end of 2006. The
State Demographer is designated as a coordinating agency within the MCDC program.
- In August Evelyn Cleveland retired from her position with OSEDA. Evelyn had been with OSEDA for nearly 30 years and was part of the Data Center since its inception in 1979. She was responsible for many aspects of this web site. Among other duties, she was the person primarily responsible for maintaining this home page.
- Also in August OSEDA (at the University of Missouri in Columbia) hired Billy Earney as a programmer/analyst to essentially take over Evelyn's position. Billy came
to Columbia from the Rolla campus of the University, from which he had graduated and where he had taught and served as a research
programmer/analyst for over 10 years. Billy has assumed a major role in developing and maintaining the MCDC web site, especially many of
the dynamic web applications such as the new ACS profiles.
January 2008
New Key Indicators for Missouri from 2006 American Community Survey
Continuing in the MCDC tradition of taking large collections of complex data and trying to create much smaller collections of much simpler data, the MCDC has created a preliminary version of a Key Indicators dataset. We have taken the information in our ACS profiles datasets (see the Whatsnew page for last November if you missed the announcement of that new data resource) and further boiled it down to just under 20 key variables. We have focused on the state of Missouri for this prototype and on the Public Use Microdata Sample (PUMA) geographic areas as the summary units. Why PUMA's? Because there are data available for all of them and they cover the entire state. Except for Congressional Districts they are the only sub-state units that have such complete coverage. And because of this, it makes sense to do statewide maps to display the items. We are still working on preparing the maps that will be a critical part of working with these data, but we do have a prototype of the data ready for public access.
The data are available in the MCDC data archive within the acs2006 data directory. From here you can either access the SAS dataset version (key_indicators.sas7bdat) via Dexter or the Excel spreadsheet version, key_indicators.xls (in either case by clicking on the filename/link). We have done some customizing of the data in the Excel spreadsheet. For one thing, we have transposed the data so that variables correspond to rows and geographic areas (PUMAs) are in the columns. (Actually, there are 2 sheets within this databook and the default one is the one we are describing here; but there is also a second sheet named "data" that is a straight translation of the SAS dataset as created via Dexter).
The variables that we are defining as the key indicators (which are the ones for which we are going to produce maps and charts) are the ones highlighted in the spreadsheet. The other rows (variables) are related items; in many/most cases they are numerator or
denominator items used in calculating the indicators.
The decisions regarding what data items are most useful as key indicators are not final. We very much welcome user feedback with respect to what data items they would like to see in these datasets. Once we have settled on the indicator data content, we plan to create more such datasets based on other geographic universes and units (such as United States as the universe and states as the units). We could (and probably will) do something at the county level, but there are not that many counties for which ACS data are available thus far.
Users not familiar with the PUMA geography should look carefully at the mopumas.pdf
document (linked to within the acs2006 data directory) which indicates the counties that comprise each PUMA in Missouri. We shall also
be creating a statewide PUMA base map to complement the pdf-format map booklet created by the Census Bureau (and linked to from the mopumas.pdf document).
Other New Data
- We have added new datasets in the saipe (small area income and poverty estimates from the Census Bureau) with the latest estimates for the nation, states, counties and school districts.
- We have created a new set of County Business Patterns data at the metropolitan/micropolitan statistical area level (for years 2003, 2004 and 2005). See these in the cbp data directory.
- Not exactly new, but being regularly refreshed with the most current data, are the two datasets in our
coredata subdirectory. These data are from the Department of Elementary and Secondary Education (DESE) and contain some basic public information at the school district and building levels going back to the 1990-91 school year and coming forward to the current (2007-08) year.
Other "What's New" by Year:
2007 |
2006 |
2005 |
2004 |
2003 |
2002
|
