|
January || February || March || April ||
June || July || August || September ||
November || December
December 2008
Census Bureau Releases 2008 State-Level Pop Estimates
The Census Bureau has released the first set of population estimates for 2008 in the form of state and nation level figures with annual components of change since 2000. The new data show the state of Missouri growing by an estimated 33,206 persons between July 1, 2007 and 2008, resulting in a 2008 official estimate of 5,911,605. This is a .6% increase (less than one percent) as compared to a .9% increase nationwide. The 33,206-person increase was the result of 82,985 births and 53,170 deaths (resulting in a "natural increase" of 29,815) and a net in-migration of 3,391 persons. The Bureau does not report gross migrations (total persons moving into the state vs. those moving out) but the net figures are broken down to show that there was a 5,902 international migration gain and a domestic migration net loss of 2,384. In other words, there were 2,384 more persons who moved out of Missouri and into another state than there were persons from other states who moved into Missouri.
Missouri continues to rank as the 18th most populous state (the same rank it had last year, but down from its rank of 17 based on the 2000 census figures). The 6 fastest-growing states, based on total net population increase in the last year, were (in order) Texas, California, North Carolina, Georgia, Arizona and Florida. Missouri ranked 22nd in net growth this year. See some of the key numbers
along with the corresponding state ranks in our State level estimates report. Uexplore/Dexter users can access and extract the data from the newly-created
popests.uscomnst08 data set. See the offical Census Bureau press release as well as "popular tables" associated with these estimates at the Bureau's population estimates web page.
New SAIPE Poverty Estimates
The Small Area Income and Poverty Estimates (SAIPE) porgram at the Census Bureau released new data for the
country last week. They released new data for calendar years 2006 and 2007. We downloaded data for US states and counties and for US School Districts for both years. We ran our standard conversion setup which recreates two data sets within the
saipe data directory. These sets are named usstcnty20xx and usschldst20xx. So the latter now have data for years 2000 thru 2007. The corresponding Missouri-subset views (change the first 2 characters of the name from "us" to "mo") were also updated. To access the original data see the
SAIPE web site.
First-ever American Community Survey "Period Estimates" Released by Bureau
The Census Bureau has released its first ever set of data tabulations based on multiple years of American Community Survey data. The data are for the 3-year period 2005 to 2007 and are provided for geographic areas of at least 20,000 population. Previously, the Bureau had released data for the years 2005, 2006 and 2007 separately but only for areas with a minimum population of 65,000.
These data can be accessed at the Census Bureau's American FactFinder web site (choose the Data Sets options and the American Community Survey sub-option from the menu on the left of the page).
On this (MCDC) web site you can access these new data:
- Using the MCDC's ACS Profile dynamic web report generator application (which is also the first link in the Quick Links box that appears on the right side of most MCDC web pages).
- Using the MCDC's Uexplore/Dexter web tools (see note). To access the standard extract data you should navigate via Uexplore to the
acs2007 data directory and select the usmcdcprofiles3yr data set for extraction. There are over 14,000 rows (geographic areas) and just under 1000 variables (data items) in this huge data set. Access the detailed metadata page (link provided at the top of the Dexter extracter page) to learn more about this data set. While this profile data will suffice for most users for most applications, there may be times when you will want to access the more detailed "base tables" from which the profiles data are derived. The MCDC provides access to these as well, in the basetbls subdirectory of the acs2007 data directory. There are 12 data sets in this directory comprising the base tables data. Each has a filename ending with a 3yr suffix. Six of these 12 contains the actual estimates while the other six contain the corresponding MOE (margin of error) measures. There are six of each because we divide the collection of over 1200 tables into subject-based subsets. The data set ustabs00_073yr.sas7bdat (the ".sas7bdat" part is the file extension, which just means it's a Dexter-accessible SAS data set) contains data for all tables numbered starting with 00 thru 07, which means:
00: Sampling info
01:Age and Sex / 02:Race / 03: Hispanic Origin / 04: Ancestry / 05: Foreign Born, Citizenship / 06: Place of Birth / 07: Residence Last Year, Migration . Each of the over 14,000 observations (rows, geographic areas summarized) contains about 4,000 variables. To see what the tables are, as well as the detailed labels for all the variables comprising those tables, you can access the Varlabs subdirectory of acs2007 and then click on the file 00_07labels.txt. You can also access this file from the link near the bottom of the Detailed Metadata page for each data set.
November 2008
Coming Soon from the American Community Survey
On or about the 9th of December, the Census Bureau plans to release the first set of period estimates based on American Community Survey data collected over the 3-year period 2005 to 2007. This will be a landmark event in the evolution of the
ACS - the first time the Census Bureau has released such multi-year estimates since the full survey went into effect in 2005.
This means that data will now be available for geographic areas with a minimum population of 20,000 (per the most recent official Bureau estimates.) Up to now we have seen data only for areas of at least 65,000. In Missouri, this means that we should be getting detailed social and economic 3-year period estimates for the following entities:
- Cities: Arnold, Ballwin, Belton, Blue Springs, Cape Girardeau, Chesterfield, Ferguson, Florissant, Gladstone, Grandview, Hazelwood, Jefferson City, Joplin, Kirkwood, Liberty, Maryland Heights, Raytown, St. Charles, St. Peters, Sedalia, University City,
Webster Groves, Wentzville, and Wildwood .
- Counties: Adair, Audrain, Barry, Butler, Callaway, Camden, Clinton, Crawford, Dunklin, Henry, Howell, Johnson, Laclede, Lafayette, Lawrence, Lincoln, McDonald, Marion, Miller, Morgan, Newton, Nodaway, Pettis, Phelps, Polk, Pulaski, Randolph, Ray, St. Francois, Saline,
Scott, Stoddard, Stone, Taney, Texas, Vernon, Warren, Washington, and Webster
There will also be new data for the larger cities and counties (those over 65,000). Of course these data will differ from what we
have already seen with the single-year estimates. These new 3-year period estimates (what some users will want to call "moving averages", although the Bureau discourages use of that terminology for technical reasons) will be based on a much larger sample. As such, they should have significantly smaller sampling errors. That's the good news. The not-so-good thing is that they will be based on surveys taken anywhere from 1 to 4 years ago, so that the data will not be as current as the single-year figures. This is a new choice with which data users (and data providers such as the MCDC) shall need to start dealing. Our guess for now is that the 3-year period estimates are going to become the default figures that will see the most widespread use.
The Missouri Census Data Center is currently adapting our software to work with the new data. We are adding "period" parameter choices to our interactive applications so that users will be able to choose whether they want to see the single-year or three-year period estimates (for areas where there is a choice)
New Compass ACS Handbooks Available
The Census Bureau has been working on a series of introductory manuals for understanding and using the American Community Survey data, each one geared to a
specific audience and/or application. The first two compass modules were released in October and have been copied to the MCDC web site (in the /pub/data/acs/Docs subdirectory). These are rather large (60 to 70 page) PDF files that are intended to be read rather than used just as reference tools. One is intended for the general user and the other for the "business community".
The MCDC is planning to do workshops in March that will be based more or less on the material covered in these handbooks.
MCDC Enhancements to ACS2007 Base Tables Processing
In addition to working to get ready for the new data being released in December the MCDC has been working on making the data we already have
more readily accessible from our web site. We have particularly focused on a new methodology for downloading and converting the huge detailed "base" table collections from the Census Bureau. The results of our efforts can be viewed by Uexplore/Dexter users in the new basetbls subdirectory of the acs2007 main data directory. Users will note the existence of a Datasets.html file within this directory, which means we provide better access to the data sets within this directory, complete with detailed metadata modules. We have modified the software so that the Dexter modules recognize this collection as being table-based so that the selection menus in Part III of the Dexter query form let the user choose from tables instead of variables. We have also created a new Varlabs subdirectory of the new basetbls directory, which contains a set of 6 variable-level data dictionary files in plain text format that load quickly and are easy to search for keywords.
New ACS Base Tables Display Module Under Development
The MCDC has begun work on a new software module, called acstabgen, that will do for ACS data what our sf3tabgen module did for the very popular Summary File 3 data from the 2000 census. You may not recognize the name of this module, but if you have ever used the MCDC's 2k census standard demographic profile reports ("dp3_2k"), then you may have taken advantage of the ability to "drill down" to a detailed table that was the source of the variables extracted for the profile. We hope to do something very similar with the ACS profiles, allowing users to drill down to a more detailed "parent" table.
September 2008
New Data from the American Community Survey
The Census Bureau has released the results of the data collected in the American Community Survey for the calendar year 2007. The MCDC has downloaded much of the data provided on the Bureau web site and added it to our data archive. Most importantly, we have transformed the data into our standard summary data sets and have modified our ACS Profile web application so that it now accesses the latest data (the user can choose a year now, with data available for both 2006 and 2007). The application can be accessed from the first entry in our Quick Links navigation boxes which appear on most MCDC web pages, including this one.
For those who would like to see trend data for the currently available years (2006, 2007) we have created an acstrends report application. It can be accessed at
http://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.acstrendskin.sas&_SERVICE=sasapp. View a sample trend report (for the state of Missouri) at
http://mcdc2.missouri.edu/cgi-bin/broker?_PROGRAM=websas.acstrends.sas&_SERVICE=appdev&geoid1=04000US29.
Single-year Population Estimates from NCHS
In August the Census Bureau released its latest (through 2007) estimates of the population for U.S. counties by age, sex, race and hispanic origin. The age detail on those data sets was 5-year intervals (i.e. persons aged 0-4, 5-9, etc.) and the race categories were based on the current OMB standards that allow for multi-racial categories. Each year the National Center for Health Statistics (NCHS) commissions the Bureau to create an alternate set of estimates based on the same basic data and methodology, but which are for single years of age and for a set of four basic "bridged" race categories (white; black; American Indian, Eskimo or Aleut; and Asian or Pacific Islander.) The Missouri Census Data Center has downloaded and processed these data to update our nchsbri data directory (under the popests data directory). Uexplore/Dexter users can access these data directly, but more importantly general users can access the data using the MCDC's Population Estimates by Age web application, which now has 2007 on the Select Year(s) menu. Not only is this a more convenient way for most users to access the data, but it allows you to define your own age intervals. You can (for example) get breakdowns of the population aged 5 to 17, or aged 62 and older (for example) and you can get this broken down by county, race, sex and hispanic origin.
ACS Data Release Schedule for Remainder of 2008
The Census Bureau plans to release the rest of the single-year data products based on American Community Survey data collected in the 2007 calendar year on September 23. Previously (in late August), the Bureau released some economic data for 2007 and these data can be accessed now on their American FactFinder site. This represents about 20% of the 1-year data to be published for 2007. The Missouri Census Data Center will be downloading the raw data and working on our own custom profiles based upon these data, similar to what we did with the 2006 data. We estimate that it may take at least 2 or 3 weeks to complete processing once we are given access to the data. To see what we mean by our custom profiles follow the link to "ACS Profile Reports (2006)" at the top of our Quick Links box (right side of this and most other MCDC pages).
The Census Bureau has announced that it intends to release the first "period estimates" data based on ACS data collected for the 3-year period 2005 though 2007 on December 9 of this year. These base tables and profiles will be similar to the single year products discussed in the previous paragraph, but will be based on combining data from three years of surveys. The good news for data users is that these data will be available for geographic areas with populations of at least 20,000 in 2007. This means, for example, that in Missouri we shall then have data for about half the counties in the state (as compared to 16 counties for which we currently have single-year estimates using a population threshold of 65,000). Note that counties with 65,000 or more population there will be both single-year data and three-year period estimates; users will have to decided which they prefer to use.
Census Tract and Block Group Data for the Entire U.S.
Bowing to user demand (two requests in the same month!) the MCDC has added 2000 decennial census data for every census tract and
block group in the U.S. We already had data for the special "split block group" geographic areas (known to Census insiders as the
"summaryl level 090" data) and we were able to aggregate these to create the summaries for the complete census tracts (summary level 140) and block groups (summary level 150). We have complete sets of P and H tables from Summary File 3, and we used these data to create our standard sf3 extracts data sets (filetype sf32000x). These are the data we use to generate our populate SF3-based demographic profiles. You can now generate such a profile if you know how to code the parms for our dp3_2k web application. We hope to have a dynamic menu front-end application ready shortly to allow easy selecting of the tract or block group. To see an example try using the following link:
http://mcdc.missouri.edu/cgi-bin/broker?_PROGRAM=websas.dp3_2k.sas&_SERVICE=sasapp&st=06&co=001&tr=4001 . This results in a profile for census tract 4001 in Alameda county, California (06 is the state code for CA; 001 is the county code for Alameda; and 4001 is obvioulsy the code for tract 4001). To get data for block group 1 within this census tract just append the parm specification bg=1 to this URL.
Direct access to the complete P and H tables is limited for now to access via the table links within the dp3_2k profile reports. The complete-table data is stored on a different server and is not currently accessible via Uexplore/Dexter. This could change.
We do, of course, provide Uexplore/Dexter access to the extract data in the new data xxtrbgs subdirectory of sf32000x.
Katina Jones
In April Katina Jones was hired by the Missouri State Library as their Statistical Research Analyst and as the
Coordinator for the Missouri Census Data Center. Katina has a BA in Applied Psychology and Broad Field Social Science
from Alverno College in Wisconsin. She has prior experience as a research analyst and program evaluator for
several social service organizations. Katina has relocated to Jefferson City from St. Louis County where she
served for more than 7 years as the Marketing Coordinator for a specialty pharmaceutical company.
August 2008
IRS Migration Profiles Updated
The MCDC has added another year (2006/2007) of data to the IRS Migration Profile Reports. The new data from the Internal Revenue Service provides county-to-county migration estimates (using tax returns and exemptions as proxies for households and persons) based on matching tax returns across the two years. So a person filing from Cook County, IL in 2006 who files from Taney County, MO in 2007 is presumed to have moved during the year. Profile reports for eight years are available for this application. The underlying data are also available to Uexplore/Dexter users in the
irsmig data directory.
2008 National Population Projections
The Census Bureau has released nation-level population projections for years through 2050. A Bureau press release provides highlights of the report, which include:
- By 2030, when all the baby boomers will be 65 or older, about 1 in every 5 Americans will be a senior citizen..By 2050 the 65+ cohort is projected to more than double, going from the current estimate of 38.7 million to 88.5 million.
- The nation's population is expected to cross the 400 million mark in 2039.
- The non-Hispanic white-alone ("majority") population is expected to increase only slightly between now and 2050 (by less than 4 million). This would make it a minority group comprising only 46% of the nation's 439 million projected population in 2050 (versus the 66% population share it has in 2008).
Read the full Press Release and access the detailed data tables at the Bureau's web page.
2007 County Estimates With Demographic Detail
The Census Bureau has released county level numbers with detail by age, race, sex and hispanic origin.
See the
Census Bureau presss release
related to these estimates.
The MCDC has downloaded these data into our public archive where they can be accessed via
Uexplore/Dexter in the popests data directory (datasets mocasrh07, ilcasrh07, 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/casrh07/mor2county.pdf
July 2008
New Estimates Show Columbia Population Approaching 100,000
The Census Bureau has released new population estimates for 2007 for sub-county geographic areas. Among the interesting facts that can be gleaned from the new data:
- The city of Columbia, MO grew by another 2,323 people over the year (7-1-2006 to 7-1-2007) and the new estimate is 99,174. The city has been experiencing consistent growth of a little over 2% per year and should cross the 100,000 threshold when the 2008 estimates are released next summer.
- Other cities in the state showing singnificant growth were O'Fallon (+3029, 4.2%) and Wentzville (+1787, 8.6%) in St. Charles county and the towns of Nixa, Ozark and Republic in the Springfield/Branson area, each of which added just under 1000 new persons.
- The Kansas City area had 3 of the top ten fastest growers (based on numeric increase): Kansas City itself added 3567 (the largest numeric increase of any city in the state, although it was less than 1%), while Blue Springs and Lee's Summit each added more than 1000 new residents.
- At the other end of the spectrum the city of St. Louis shows a loss of 3078 residents, but this is based on the initial (pre-challenge) figure. In each of the last 4 years the city has successfully challenged their initial estimate and the result each time has been a revised figure on the order of 5 to 6 thousand higher. Sources within the city tell us of their intent to challenge again this year, and that the corrected amount would be in the same ballpark. So their apparent 3000+ decline could well turn into a 2000+ gain.
- Other Missouri cities showing population losses of at least 200 persons were Florissant (-375), Chesterfield (-282), University City (-241), and Wildwood (-203) - all in St. Louis county, and Grandview (-213) in Jackson county.
- Nationwide, Houston, Texas had the largest numeric increase during the year with 38,932 new residents (1.8%), while four other Texas cities (San Antonio, Fort Worth, Austin and Dallas) all posted gains of over 10,000 to rank in the top 15. New Orleans showed the largest percentage increase at 13.8% as victims of Katrina returned, but the 2007 estimate of 239,124 is still less than half of what it was in 2000. New Orleans has lost over 245,000 residents this decade. Their neighbor city, Baton Rouge, experienced a loss of over 3600 people, a good portion of which was no doubt hurricane refugees who left to return to New Orleans or other cities along the gulf.
- Cleveland had the largest numeric loss of population (-5,067) just edging out Columbus, GA (-4,794). Cusseta-Chattahoochee, GA experienced perhaps the most dramatic downward shift, however; it showed a decline of just over 4,000 residents which was 30% of their 2006 estimate of only 13,485.
View these numbers and more in a series of Top 50/Bottom 50 reports for
Missouri only
| United States
We have also made available two Excel files containing the new data for Missouri:
- Data for Complete Places only
- Curmoest.xls, our multiple-sheet file with
the latest figures for all Mo geographies. Two of the sheets are Cities and City by County. The latter is sorted by county and shows estimates for the portions of cities within counties.
Finally, Uexplore/Dexter users can access the two new MCDC archive datasets by going to the popests data directory and clicking on either the mossc07.sas7bdat or ussc07.sas7bdat data files.
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
|
