Recent Updates to the MCDC / OSEDA Public Data Archive (To be Accessed Using the Uexplore/Dexter Web Software) Rev. 04/26/2008

01/17/08: In the acs2006 directory we added key_indicators.xls, an Excel spreasheet containing a set of key social, economic and demographic indicators for Missouri data regions (PUMAs). The data here are essentialy the same as contained in the system data file of the same name (key_indictors.sas7bdat) but the spreadsheet file has been transposed (each column becomes a geographic area, and each row corresponds to a data item) and customized. Not all the data items are considered key indicators (they may be the numerators or the denominators used to derive the key indicator) and the ones that are key indicators are highlighted. We are in the process of creating a series of pdf file maps ("geopdfs") to display these key items.   The usmcdcprofiles dataset was modified, with several new variables added. This was related to creating the new key_indicators dataset since we wanted the key indicators to be a subset of the data in this profiles data set. 01/16/08:Three new datasets were added to the County Business Patterns collection (cbp filetype). These were all metro area ("CBSA" - core based statistical area) data, one for each of the years from 2003 to 2005. 01/14/08:A new round of median household income and poverty estimates for the nations, state, counties and school districts were added to the saipe data directory. 01/02/08: Dataset uscomnst07 was added to the popests directory. Contains the national and state level estimates through July 1, 2007 with components of change. The county level version of these estimates should be released in the spring (usually around late March or early April). 12/26/07: Data in the cntypage filetype (listed in the Compendia category) were updated with the latest available items for the time-series data. See the Missouri County Summary of Social and Economic Indicators web site for access to these data as formatted reports. 11/26/07: The 2006 ACS data have been under construction for about 2 months but have had the "Under Construction" sign taken down now. We have a complete set of standard extracts (key data items) for all available geographic entities in the single dataset usmcdcprofiles (the source data for a new set of profile reports that are similar to the set of 4 profile reports available on the Census Bureau's American FactFinder site). We also have a complete collection of the detailed (base) tables for the entire U.S. in the summary subdirectory. 09/27/07: The 2006 ACS PUMS datasets have been added in the acspums data subdiretory. 09/12/07: The 2006 ACS data for Missouri, stored in a series of Excel files organized by geographic summary level, were added to the archive in acs2006/profiles/Missouri subdiretory. (Even though it is in the profiles subdirectory, these xls files also contain complete Base tables and Subject tables.) We also processed the profiles sheets from national collections of these data to create the sreies of profile_data.csv files stored in the acs2006/profiles subdirectory. We intend to convert these to SAS datasets shortly. 08/20/07: We have added population estimates by age (single year), "bridged" race, sex and hispanic origin for 2006 to our 20XX datasets in the popests/nchsbri subdirectory. These are the data used in our Population Estimates by Age web application (which has been updated so that 2006 now appears and is the default selection on the Years select list). 08/11/07: Added the county level population estimates by age, sex, race and hispanic origin ("casrh") datasets to the popests data directory. We received IRS migration data for the remaining states (see following note) and regenerated the usinmig0506 and usoutmig0506 datasets. 08/04/07: We have processed partial data from the IRS regarding county migration trends for tax years 2005-2006. We have data for states Alabame through Tennessee and will be adding data for Texas through Wyoming shortly (awaiting data from IRS). These data are stored in the irsmig directory. We have updated the Migration_Profiles menu pages subdirectory so that users can now generate profiles for this latest year - i.e. we have added year 2005-2006 to the select list on the menu pages. 07/29/07: We have replaced most of the data sets in the beareis directory with the latest data as released by the BEA in 2007. The data are now reported through year 2005. 06/28/07: In the popests directory we added datasets ussc06 and mosc06 with sub-county (i.e place) level estimates for the entire U.S. and for Missouri, respectively. 06/21/07: In the taxsales (taxables sales data by sic and county for Missouri only from DOR) directory we downloaded the final sales reports and converted to SAS datasets. These replace the preliminary versions done in March of this year when 4th quarter 2006 data were not yet available on the DOR web site. 06/04/07: The County Business Patterns data for 2005 were added to the cbp filetype directory. These data sets provide counts of establishments with total number of employees and annual payroll by various NAICS categories (totals, major industries and more detailed, down to 6-digit NAICS code). These are reported for the nation, the states and for counties. Lots of suppression for the more detailed NAICS categories at the state & county levels. This continues a time series of such data sets going back to 1999. The county level data sets have over 2 million observations each. 04/24/07: We have a new filetype, irsmig, with data from the IRS regarding county to county migration derived by matching consecutive years of tax returns. We have converted the data based on tax years 2004-2005 (the most recent data available) and going back to data based on tax years 1999 and 2000. We have data for the entire U.S., with Missouri subsets. A link to this filetype has been added to this directory page in the "Other" category. In addition to the archive data sets (accessible by Dexter) we have kept the orgiginal Excel spreadsheet files for Missouri only, and have also created csv files based on the original xls files for the entire U.S. and contatenated these to create a single file per year or In and Out migration. 03/22/07: Processed the Census Bureau's new county level population estimates with components of change, 2000-2006. In the popests filetype directory created datasets uscom06 and mocom06, as well as aggregated-to-CBSA summaries in uscomcbsas06. 03/08/07: Completed a major restructuring of the combined base tables in the acs2005 data directory. We have taken the hundreds of "base tables" associated with the ACS and combined them according to type of table. The Datasets.html page has been revised to reflect the new datasets. A problem was found with the imputation tables stored in the acs20005/basetabs subdirectory. These have been corrected. 02/27/07: We added two new filetypes in the Compendia section. cntypage contains the data that OSEDA used in creating the Social and Economic profiles for Missouri extension people. It has a variety of data, with summaries for Missouri counties and the state, as well as for the 9 MU Extension regions. The data have recently been updated to get the most recently available data. mosenior has data for Missouri counties and the state as used in the Senior Report web site and publication. As the name suggests, the emphasis is on indicators related to the elderly population. We have eliminated the Agriculture category from the main directory box (above) and replaced it with a new Other category. This category has two filetypes in it: the old ag2002 type and the new movoters type (see below). 02/22/07: We have a new filetype, bls_la, with data from the Bureau of Labor Statistics local area employment statistics. These datasets provide a long time series (back to 1990 at the county level, to 1976 for states) with basic monthly employment data. We have downloaded all the BLS data in the series but we have thus far created SAS data tables only for state and county levels. We added dataset movoters.cntyvotrsbyyr in the movoters filetype directory. It contains counts of registered voters by Missouri counties for even-numbered years from 1992 to 2006. 02/14/07: Added 3 datasets in the georef collection related to New England City and Town Areas (NECTAS). The new datases are nectas (codes and names), nectadivs (these are the smaller NECTA divisions - there are only 9 of them) and nectamcds (basically an MCD to NECTA equivalency file). We also created (again in the georef collection) dataset mopums00, which is a nice summary of information regarding the 2000 PUMAs (5% versions) for Missouri. 01/22/07: A new set of 2000 census SF3 tables for State Legislative Districts have been added, with separate files for each state. The full sf3 table datasets are in the new slds2007 subdirectory within the sf32000 data directory. The corresponding standard extract datasets are in the new slds2007 subdirectory within the sf32000x data directory. slds2007 01/17/07: Added a set of 51 state-based block level datasets in the mable2k data directory. The files are named XXsldblks, where XX is the 2-character state postal abbreviation. Each row corresponds to a 2000 census block and the variables sldl02, sldh02 and cd109 contain up to date state legislative district codes and 109th congressional districts.