Files in this directory contain national data formatted for use with the Workforce Information Database. File Name Contents Last Update _____________________________________________________________________________ NOTE ON CPI FILE CONTENTS: Beginning with indexes for January 2007, the indexes are presented with three decimal places. Structures of the CPI files here have been revised to reflect that change. Data for years before 2007 will continue to be presented at one decimal place. Those official CPI numbers will not be changed. NOTE on LABFORCE Files and seasonal adjustment: with the release of December data each year, BLS updates the seasonal adjustment factors used during the previous five years. In this case, seasonally adjusted data beginning in January 2003 may be updated. NOTE on CES Files and seasonal adjustment: CES files are also subject to seasonal adjustment revisions. See above. NOTE on May 2008 OES wage files: Non-standard NAICS industry codes added by BLS: 9991 Federal Government (OES Designation) 9992 State Government (OES Designation) 9993 Local Government (OES Designation) _____________________________________________________________________________ CPI2324.DBF & JuLY 2010 CPI2324.TXT Consumer Price Index, Seasonally Adjusted (1947-present) and unadjusted (1913-present) Formatted for use in CPI table in Versions 2.3 and 2.4 of the Workforce Information Database. (NOTE: Contents of this table can be used with version 2.3 of the database only if the structure of that CPI table was modified to increase the size of the CPI field to include three decimal places.) LAB2124.DBF & LAB2124.TXT National labor force, employment, and July 2010 unemployment for use with the LABFORCE table in Versions 2.1-2.4 of the Workforce Information Database. Contains the complete national series from 1948 through the most recent month. LABFOR11.DBF & LABFOR11.TXT National labor force, employment, and July 2010 unemployment for use with the LABFORCE table in Version 1.1 of the Workforce Information Database. Contains the complete national series from 1948 through the most recent month. CES23.DBF & CES23.TXT Monthly updates to the CES table, July 2010 based on NAICS. Contains data for January 2000 through the most recent month. For use in Version 2.3 of the Workforce Information Database. CES24.DBF & CES24.TXT Monthly updates to the CES table, July 2010 based on NAICS. Contains data for January 2000 through the most recent month. For use in Version 2.4 of the Workforce Information Database. BLSCES23.ZIP Monthly CES table update produced July 2010 by BLS formatted for use with Version 2.3 of the Workforce Infdormation Database. Includes data for 1,000+ series (versus 146 series in the CES23 files). Contains data from 1939 through June 2010. Codes are compatible with the CESCODE table in this directory. (contains both FoxPro and comma-delimited text versions) BLSCES24.ZIP Monthly CES table update produced July 2010 by BLS formatted for use with Version 2.4 of the Workforce Infdormation Database. Includes data for 1,000+ series (versus 146 series in the CES23 files). Contains data from 1939 through June 2010. Codes are compatible with the CESCODE table in this directory. (contains both FoxPro and comma-delimited text versions) OESW0924.ZIP May 2009 OES wage estimates formatted May 2010 for use in the OESWAGE table in version 2.4 (OESW0924.DBF and OESW0924.TXT). OESW0923.ZIP May 2009 OES wage estimates formatted May 2010 for use in the OESWAGE table in version 2.3 (OESW0923.DBF and OESW0923.TXT). 09MWAG2X.ZIP May 2009 OES wage estimates formatted May 2010 for use in the WAGE table in versions 2.2-2.4 (09MWAG2X.DBF and 09MWAG2X.TXT) of the Workforce Information Database. MATRIX08FP.ZIP National employment projections Jan 2010 matrix from BLS for 2008-2018. Archive file contains Visual FoxPro databases formatted for the Workforce Information Database Version 2.4. Contents described in MATRIX08.PDF. (NOTE: SUBTOT variables added to selected tables in Jan. 2010.) MATRIX08AC.ZIP National employment projections Jan 2010 matrix from BLS for 2008-2018. Archive file contains a MS Access databases formatted for the Workforce Information Database Version 2.4. Contents described in MATRIX08.PDF. (NOTE: SUBTOT variables added to selected tables in Jan. 2010.) GEOG10.ZIP Metropolitan Statistical Area, Dec 2009 Micropolitan Statistical Area and Metropolitan Division GEOG and SUBGEOG files. Conform to OMB Bulletin #10-02, December 2009. INDUS08.ZIP National 2008 Covered Employment and Jul 2009 Wages (ES-202) for use in the INDUSTRY table in versions 2.2-2.3 and version 2.4 of the Workforce Information Database. FoxPro and delimited text files are included for each version. (NOTE: contents of OWNERSHIP field corrected on 07/29/09) OESW0824.ZIP May 2008 OES wage estimates formatted May 2009 for use in the OESWAGE table in version 2.4 (OESW24.DBF and OESW24.TXT). OESW0823.ZIP May 2008 OES wage estimates formatted May 2009 for use in the OESWAGE table in version 2.3 (OESW23.DBF and OESW23.TXT). 08MWAG2X.ZIP May 2008 OES wage estimates formatted May 2009 for use in the WAGE table in versions 2.2-2.4 (07MWAG2X.DBF and 07MWAG2X.TXT) of the Workforce Information Database. CESCODE.DBF & CESCODE.TXT NAICS-based CES code lookup table Feb 2009 for use with BLSCES23 and BLSCES24 Revised by BLS on 2/09/09. 07MWAG2X.ZIP May 2007 OES wage estimates formatted Sep 2008 for use in the WAGE table in versions 2.2-2.4 (07MWAG2X.DBF and 07MWAG2X.TXT) of the Workforce Information Database. NOTE: Records for two occupations were removed on 9/27/08 per BLS notice at http://www.bls.gov/oes/#notices) INDUS07.ZIP National 2007 Covered Employment and Aug 2008 Wages (ES-202) for use in the INDUSTRY table in versions 2.2-2.3 and version 2.4 of the Workforce Information Database. MATRIX04.ZIP National employment projections Apr 2008 matrix from BLS for 2004-2014. Archive file contains FoxPro 2.6, comma-delimited text and Visual FoxPro databases in separate archives formatted for ALMIS Database Version 2.3. Contents described in MATRIX04.DOC. (NOTE: contents of the OCCPRJ files were updated on 4/9/08 to correct estimates with truncated values.) CES2007.ZIP & CES2007.PDF CESCODE lookup table modified to Jan 2008 include changes made to CES series to reflect the change to a 2007 NAICS code basis, effective with January 2008 data released 2/1/2008. The PDF file documents changes made to the CESCODE file to implement the changes. MATRIX06.ZIP National employment projections Dec 2007 matrix from BLS for 2006-2016. Archive file contains VisualFoxPro databases formatted for Workforce Information Database Version 2.4. Contents described in MATRIX06.DOC. INDUS06.ZIP National 2006 Covered Employment and Jul 2007 Wages (ES-202) for use in the INDUSTRY table in versions 2.1-2.3 and version 2.4 of the Workforce Information Database. M06WAGE.ZIP May 2006 OES wage estimates formatted Jun 2007 for use in the WAGE table in versions 2.2-2.3 (WAGE2223.DBF and WAGE2223.TXT) of the ALMIS Database. M06OESW.ZIP May 2006 OES wage estimates formatted Jun 2007 for use in the OESWAGE table in versions 2.2-2.3 (OESW2223.DBF and OESW2223.TXT). MATRIX04.ZIP National employment projections Mar 2007 matrix from BLS for 2004-2014. Archive file contains FoxPro 2.6, comma-delimited text and Visual FoxPro databases in separate archives formatted for ALMIS Database Version 2.3. Contents described in MATRIX04.DOC. (NOTE: PCTESTIND field was empty prior to file update on 1/12/06. DRAFT MATXSOC content was added on 1/27/06. DRAFT MATXNAIC content was added on 2/17/06.)(NOTE: contents of the percent distribution columns (PCTESTIND, PCTESTOCC, PCTPROJIND, and PCTPROJOCC) were corrected on 5/5/06) (NOTE: MATXNAIC contents were enhanced on 3/29/07 to include matrix industry codes that weren't in the earlier version.) M05OESW.ZIP May 2005 OES wage estimates formatted Nov 2006 for use in the OESWAGE table in versions 2.1-2.2 (OESW2122.DBF and OESW2122.TXT) and 2.3 (OESW23.DBF and OESW23.TXT) of the ALMIS Database. (NOTE: Bad values in the WPCTRELERR field were replaced with zeros on 11/03/06) INDUS05.ZIP National 2005 Covered Employment and Oct 2006 Wages (ES-202) for use in the INDUSTRY table in ver. 2.1-2.3 of the ALMIS Database. NOTE: Industries are coded to NAICS. NAICSCODE tables in \VER22\FOXPRO\LOOKUP and \VER22\TXT\LOOKUP were modified to reflect additional codes found in the new QCES data. M05WAGE.ZIP May 2005 OES wage estimates formatted Jun 2006 for use in the WAGE table in versions 2.1-2.3 (WAGE2123.DBF and WAGE2123.TXT) of the ALMIS Database. M05OESW.ZIP May 2005 OES wage estimates formatted Jun 2006 for use in the OESWAGE table in versions 2.1-2.2 (OESW2122.DBF and OESW2122.TXT) and 2.3 (OESW23.DBF and OESW23.TXT) of the ALMIS Database. GEOG06.ZIP Metropolitan Statistical Area, Jan 2006 Micropolitan Statistical Area and Metropolitan Division GEOG and SUBGEOG files. Conform to OMB Bulletin #06-01, December 2005. GEOG03.ZIP Metropolitan Statistical Area, Nov 2005 Micropolitan Statistical Area and Metropolitan Division GEOG and SUBGEOG files. Conform to OMB Bulletin #03-04, June 2003. GEOG04.ZIP Metropolitan Statistical Area, Nov 2005 Micropolitan Statistical Area and Metropolitan Division GEOG and SUBGEOG files. Conform to OMB Bulletin #04-03, February 2004. GEOG05.ZIP Metropolitan Statistical Area, Nov 2005 Micropolitan Statistical Area and Metropolitan Division GEOG and SUBGEOG files. Conform to OMB Bulletin #05-02, February 2005. N04WAGE.ZIP Nov. 2004 OES wage estimates formatted Nov 2005 for use in the WAGE table in versions 2.1-2.3 (WAGE2123.DBF and WAGE2123.TXT) of the ALMIS Database. N04OESW.ZIP Nov. 2004 OES wage estimates formatted Nov 2005 for use in the OESWAGE table in versions 2.1 (OESW21.DBF and OESW21.TXT) and 2.2-2.3 (OESW2223.DBF and OESW2223.TXT) of the ALMIS Database. (NOTE: Invalid values in PCT10 variable were replaced with zeros on 12/03/05) INDUS04.ZIP National 2004 Covered Employment and Oct 2005 Wages (ES-202) for use in the INDUSTRY table in ver. 2.1-2.3 of the ALMIS Database. NOTE: Industries are coded to NAICS. (use NAICS.ZIP in the /NONSTD folder.) Contains both FoxPro and text files. NOTE: values for OWNERSHIP variable were corrected on 10/07/05. BLDING2X.DBF & BLSING2X.TXT Housing units authorized by REMOVED 10/05/05 Building permits. Annual, 1980- 2004. Monthly, January 1995- present. NOTE: 1980-2004 based on survey of 19,000 places. 2004- present based on survey of 20,000 places. IMPORTANT: See BLDING2X.DOC for more information. URL.DBF & URL.TXT Prototype file containing URLs for Aug 2005 state Labor Market Information web pages. HUDINC11 HUD Median Family Income Apr 2005 U.S., States 1989, 1996-2005 (for use in ALMIS Version 1.1 HUDINCOM table) (NOTE: Data for 1999 corrected on 4/19/05) HUDINC2X HUD Median Family Income Apr 2005 U.S., States 1989, 1996-2005 (for use in ALMIS Versions 2.0-2.3 INCOME table) (NOTE: Data for 1999 corrected on 4/19/05) INDUS03.ZIP National 2003 Covered Employment and Oct 2004 Wages (ES-202) for use in the INDUSTRY table in versions 2.0-2.3 of the ALMIS Database. NOTE: Industries are coded to NAICS. (use NAICS.ZIP in the /NONSTD folder.) Includes both FoxPro and text files MATR0212.ZIP National employment projections Jul 2004 matrix from BLS for 2002-2012. Archive file contains both FoxPro 2.6 and comma-delimited text files formatted for ALMIS Database Version 2.2. (NOTE: Annual openings projections replaced with new data received from BLS.) Contents described in MATR0212.DOC. INDUS02.ZIP National 2002 Covered Employment and Oct 2003 Wages (ES-202) for use in the INDUSTRY table in versions 2.0-2.3 of the ALMIS Database. NOTE: Industries are coded to NAICS. (use NAICS.ZIP in the /NONSTD folder.) Includes both FoxPro and text files CESHIST.ZIP Historical CES estimates, 1939-1999, Sep 2003 NAICS-based. Contains both FoxPro and text files. They were converted to the ZIP file in January 2004. CESBYSIC.ZIP Contains all of the following Sep 2003 CES files formerly found individually in this directory, including: EEUPDA11.DBF & EEUPDA11.TXT CES monthly estimates for published May 2003 industries, 2000-2003. For use with CES table in version 1.1 of the ALMIS Database. See CES.TXT ***SIC-based. Data only through 04/2003*** EEUPDA20.DBF & EEUPDA20.TXT CES monthly estimates for published May 2003 industries, 2000-2003. For use with CES table in version 2.0 of the ALMIS Database. See CES.TXT ***SIC-based. Data only through 04/2003*** HISTDETA.ZIP Current Employment Statistics (CES) Jan. 2001 monthly estimates, not seasonally adjusted. For detailed industries. 1909-1989. See CES.TXT for more info. HISTPUBL.ZIP CES monthly estimates, seasonally Jan. 2001 adjusted and undadjusted, 1909 to 1989. See CES.TXT CURRDETA.ZIP CES monthly estimates for detailed Jan. 2001 industries, 1989-2000. See CES.TXT. CURRPUBL.ZIP CES monthly estimates for published Jan. 2001 industries, 1989-1999. See CES.TXT. CESNAICS.ZIP CES monthly estimates. Industry Jun 2003 codes are based on NAICS. Seasonally adjusted data only. No annual averages. Formatted for use in the CES table described in the addendum to the database version 2.2 structure. Data for 1939 through December 1999. FoxPro and text files are included. COMMUTE.ZIP Commuting patterns from the 2000 Mar 2003 Census for use in the ALMIS Database COMMUTE table. INDUS01.ZIP National 2001 Covered Employment and Nov 2002 Wages (ES-202) for use in the INDUSTRY table in versions 2.0-2.3 of the ALMIS Database. NOTE: Industries are coded to NAICS. (use NAICS.ZIP in the /NONSTD folder.) Includes both FoxPro and text files MATR0010.ZIP National employment projections Dec 2001 matrix from BLS for 2000-2010. Archive file contains both FoxPro 2.6 and comma-delimited text files formatted for ALMIS Database Version 2.2. Contents described in MATR0010.DOC. INDUS00.ZIP National Covered Employment and Wages Nov. 2001 for 2000. Separate files formatted for versions 1.1 and 2.0 of the ALMIS Database INDUSTRY table. Archive contains both delimited text and FoxPro files. (Coded to SIC) INDUS99.ZIP National Covered Employment and Wages Mar. 2001 for 1999. Separate files formatted for versions 1.1 and 2.0 of the ALMIS Database INDUSTRY table. Archive contains both delimited text and FoxPro files. (Coded to SIC) NATPRJ99.ZIP National employment projections Aug. 2000 matrix from BLS for 1998-2008. __________________ NOTE: The ES-202 files in this directory were downloaded from the Bureau of Labor Statistics' Internet server (ftp://146.142.4.23/pub/special.requests/cew/2000/National/). Not all ALMIS variables are populated. The notable exceptions are the monthly count of the number employees and firms, and the employment level of the largest employer in the industry. If you have any questions, feel free to contact the NCSC at 515-242-5034 or NCSC@iowa.gov