Census Bureau Releases State Level Estimates for 2009
The Census Bureau released new population estimates at the nation, region and state levels today (12/23). These files contain data for each year since the 2000 census and go up to July 1, 2009. These are the last post-censal estimates at the state level that we'll see for this decade. The data show that Missouri added over 31,000 people in the most recent year (July 1, 2008 to July 1, 2009), bringing it to a new estimate of 5,987,580. Missouri ranked 24th in terms of persons added to its population in the last year, but only 37th when that growth is measured as a percentage of the population. Looking at the trends over the decade, Missouri ranks 18th in terms of total increase and 26th in terms of percentage increase. The state has grown by almost 391,000 persons or 7% over the 9-year period.
Texas and California continue to lead the way in terms of absolute population growth, both in the most recent year and in the decade, with Texas ranking first and California second. Nevada leads in percentage growth for the decade, but slipped to 17th in percentage growth for the latest year (with Wyoming moving into the top ranking there with a 2.1% increase this year).
This is an excerpt from a report generated by the Missouri Census Data Center based upon the files made available by the Bureau. Click here to view the entire report, and/or here to access a csv file with the report data and more.
Uexplore/Dexter users can access the new data in dataset uscomnst09 in the /pub/data/popests data directory.
Introducing Rankster (Preview)
The pdf and csv files referenced above were generated using a new web utility application called rankster. Users who are familiar with our uexplore/dexter software will recognize rankster as a companion tool, with a comparable user interface and similar output formats and conventions. In fact, the easiest way to access rankster is via uexplore. You will navigate to a data set in our archive and when the Dexter custom form page displays there will be a new line near the top of the form that lets you specify that you want to run rankster to process this dataset. We use the future tense here because the code we are talking about is still in test mode. In order to use it at this point you will need to know how to edit a URL that appears in your browser window. When you have a Dexter query form displayed in your window (usually you get there by using uexplore) you are looking at the results of running an application that goes by the geek name "websas.uex2dex.sas". In order to run the test version and get access to rankster you need to change this name to "test.uex2dex.sas". How do you do that? By looking at the URL in your browser's address window (the one that has displayed /cgi-bin/broker?_PROGRAM=test.uex2dex.sas&...) You use your mouse to carefully highlight the word "websas" in this URL and then you type the word "test" (all lowercase, without the quotes). Then just hit enter to run the test version of the application. If you do it correctly the top of your new Dexter extracter page should look something like this:
(If you are having trouble seeing the page image below in your browser because it is too small, try "zooming in" on the page by typing "ctrl +" - holding down the Ctrl key while simultaneously typing "+" - to enlarge the image.)
As you can see (*), you now have an option to "Skip dexter and go straight to rankster", which you can just click on. But there will be times when it will be helpful to first run dexter to create a new dataset with just the rows and columns that you are interested in using for your rankings. In these cases you will be able to choose an option to first run Dexter but then pass the output dataset to rankster. If you ignore the new Rankster option line then rankster is not invoked. We hope to have this application available in production within the next week or two. We are hoping to have some useful training materials ready when we announce that step.
Census Bureau Releases 3-year Period Estimates for 2006-2008
As promised the Census Bureau has delivered the latest set of summary data products based on the American Community Survye for the calendar years 2006 through 2008. See the relevant press release at the Bureau's web site. The MCDC has
updated our ACS Profiles web application so that it will now allow you to display profiles based on these data. (See the link to this app as the first item in our Quick Links navigation box - just to the right side of this page.) The data can also be accessed via the American FactFinder web site.
IRS Migration Data for 2007/2008 Available
The IRS has released a new year of state and county level migration flows based on tracking tax returns between 2007 and 2008. As usual, the Missouri Census Data Center has obtained these data and made them available in our public data archive, as well as via our interactive web application that displays a migration profile for any selected county in the U.S.
We used to have to purchase these data on cd-rom/DVD but starting this year the IRS has decided to make the raw files available via a free download site.
You can access our irsmig data collection via uexplore, which lets you access the Migration_Profiles menu page .
New for this year (on our site, at least) is the availability of state-to-state migration profiles. (Prior to this everything we had was county level data.) These reports display the same kind of data in essentially the same format as the county profiles but the data are all at the state level. So you can access a report for Missouri to see how many tax-return flows occurred between Missouri and any other state in the country. We have these data for the most recent four tax-year combinations: 2004-2005, 2005-2006, 2006-2007 and 2007-2008. To access these you need to go to the Migration_Profiles menu page and look for the menu item US State-to-State.html.
2008 ACS Single-Year Data Now Complete
Last week (late September) we noted here that the Census Bureau had released a new set of American Community Survey data products based on a single year's worth of surveys, 2008. (See our
The 3-year period estimates data based on survey years 2006 through 2008 are scheduled to be released on October 27. That will give us data for geographic areas as small as 20,000. However, because the questions on insurance coverage have only been asked for 2008, there will not be any data on this topic in the these period estimates.
We have also downloaded the complete set of ACS detailed ("base") tables and have made them available via links within the ACS Profiles as well as via Uexplore/Dexter in the MCDC data archive. You can also access these tables at the Census Bureau's
American FactFinder site.
2008 ACS Data Released
The Census Bureau has released a new set of American Community Survey data products. These are single-year data, based entirely on the 2008 surveys (available for geographic areas of 65,000+ population). (See the Census Bureau Press Release regarding these data.)
The 3-year period estimates based on surveys taken over the calendar years 2006 through 2008 (available for geographic areas of 20,000+ population) are scheduled to be released next month (on October 27).
Unfortunately, the Bureau discovered problems with some of the data for this release, which has caused them to restrict access to those data. The problems affect tables dealing with income and poverty. The Bureau estimates that the corrected tables will be available in about a week (on September 29, next Tuesday).
In addition to the new data, MCDC has new software for displaying profile reports based upon the ACS data. This is reflected in a change to first two links (to "ACS Profile Reports" and "ACS Trends Reports") within our Quick Links navigation boxes (the light blue boxes like the one just above and to the right of what you are reading right now). There is little or no change in the content of the reports (just some changes in style), but there are significant differences in the interface that lets you select geography and time periods for your reports. The graphics associated with the tables have also been signficantly upgraded.
For those Uexplore/Dexter users wanting to access the raw data sets associated with this release, there will be a slight delay in making these available. We are working on making the usmcdcprofiles data set for 2008 (albeit with the economic data items missing) available. We plan to wait for the final set of detailed (base) tables to be released before putting our versions of those up in the data archive.
Population Estimates by Age
The National Center for Health Statistics has released "vintage 2008" population estimates for all counties in
the U.S. These are the special "bridged" race estimates that attempt to replicate the four major race categories that were used
by the Census Bureau and other federal agencies until the OMB-mandated shift to multi-racial categories in the late 90's. See
the NCHS Web Site for more details and links to the downloadable data files.
As we have been doing for the last several years now, the Missouri Census Data Center had downloaded these estimates and made them available in our public data archive. (For Uexplore/Dexter users the datra are in the nchsbri subdirectory of the /pub/data/popests filetype directory). More importantly (for most users) the data have been summarized and are accessible via the MCDC's
Population Estimates by Age web application. This utility app can dynamically generate estimates by age (including user-specified custom intervals), race, sex and Hispanic origin for all U.S. states and counties, for years 1990 to 2008 (the addition of 2008 data being the news item here).
These estimates are produced by the Census Bureau under a contract with the NCHS and are consistent with the Bureau's "casrh" estimates by age, sex, race and hispanic origin which were published (with the vintage 2008 updates) back in May. We have been monitoring the NCHS web site all summer waiting for this alternate version to become available. The major differences between these estimates and those published by the Bureau are the use of bridged race categories and the single year of age detail
available in the NCHS files (vs. 5-year cohorts used in the Bureau's files).
The MCDC's Population Trend Report web application also makes use of these detailed estimates data, so you can now run that application and have new choices for the time periods going through 2008.
It's getting close again. We are less than a year away from the next Decennial Census day - April 1, 2010. Which means we are less than two years away from seeing the first tabulated results of that once-in-a-decade survey. Less than two years away from knowing with near certainty just how many people live in our counties, our cities and our neighborhoods, regardless of size. Not only will we know the head count but we'll also know important demographic details of the population: age, race, gender, hispanic origin, living in a household (and whether it's a family household) or in group quarters (what kind), renters or owners, etc. Or at least we'll know these things as they were circa that point in time - April 1, 2010. So we can easily spot trends by linking to comparable data gathered on April 1, 2000 and even April 1, 1990.
What else are we looking forward to getting from the new census? Won't we also be getting new data regarding things such as people's incomes, poverty status, education, occupation, employment status, house values, and disabilities? Well, no. Not from the decennial census, not this decade. ...
Read more in our essay The American Community Survey vs. the Decennial Census Long Form - Are We Better Off Now Than We Were a Decade Ago?.
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.
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.
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.
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.
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). 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.
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.