Although the Workforce Information Database can contain a large amount of data, it does not, and cannot, contain all of the labor force, economic, population, occupational and other information produced by state and federal agencies. The databases and tables described on this page are not part of the Workforce Information Database. They fall into two categories – comprehensive databases that are maintained and updated independently of the Workforce Information Database and tables that will be included in the Workforce Information Database for which questions or issues were unresolved at the time of the release of the current database version.
O*NET Production Database – this contains detailed data on occupations and the skills, knowledge, and abilities that are required of workers. You’ll find the complete documentation and download files in several versions on the O*NET page.
Military Crosswalk Database – The Defense Manpower Data Center maintains crosswalk a file that links military occupations to their civilian counterparts from the SOC and O*NET classifications. This crosswalk is updated quarterly. While this content can be included in the Workforce Information Database, we’ve created a separate database due to the frequent updates. You can download a structure document or an Access database that contains the crosswalk.
The tables in this section conform to the structure of the Workforce Information Database. The content of their fields fall outside that described in the database structure document. Those values may be incorporated in a future version of the database.
New England Geography – generally speaking, the New England states, unlike the rest of the country, ignore counties. Rather, cities and towns are their basic geographic unit. The Analyst Resource Center has developed a prototype set of geography files describing the region. You can view a document describing the table contents or download MS Access and delimited text versions of prototype content. NOTE: These delineations were revised based on 2010 Census data in February 2013 and subsequent population estimates in August, 2016. (Updated 6/4/15, revised 8/18/16)
Tables for Future Versions
The tables in this list have been proposed for inclusion in the Workforce Information Database. Not all issues were resolved at the time of the release of the current version, so their inclusion may be in a future release. Please note these files structures are still evolving- so check back often for updates.
Poverty Rates: The poverty.zip file contains estimates of the number of persons in poverty and poverty rates for states and counties for the years 1989, 1993 and 1995-2015. You can download a copy of the prototype file or take a look at a structure document. The data were taken from the Census Bureau’s Small Area Income and Poverty Estimates (SAIPE) Program. (added 12/15/15, updated 01/04/17)
WID TAX Table content: The statetax.zip file contains Census Bureau estimates of state tax collections for 16 types of taxes not included in the tax types now in the WID. Estimates are for selected years between 1902 and 1948 and 1950-2014. (added 12/15/15, updated 9/27/16))
State and Local Economic Indicators: Tables that allow for tracking of economic activity by state on both the production and consumption sides of the economy.
STATE GDP: BEA estimates of Gross Domestic Product by industry group, including estimates of GDP components such as wages and subsidies. A structure document is also available. (Added 4/30/15, revised 5/14/15, updated 6/11/15)
PCE: BEA estimates of Personal Consumption Expenditures by state. Expenditures are largely industry based, and the PCE estimates also include adjustments such as for net foreign travel. A structure document is also available. (Added 5/30/15, Revised 12/01/15)
ZIP Code Business Profiles: The Census Bureau has published information about business establishments by ZIP Code for 2014. The details file contains counts of establishments by size class by industry by ZIP Code. The totals file contains payroll and employment data by ZIP Code. We’ve also provided a structure document. CAUTION: The details table is quite large. It contains over 6.5 million records and occupies slightly over two gigabytes of disk space. (Added 6/17/15, updated 5/24/16)
Commodities: The ARC has developed a prototype structure for a table that’s designed to house production and sales data for commodities produced in a state. A structure document and prototype Access database with test data are available for downloading. (Added 05/26/10, Revised 2/24/14)
Job Benefit Survey Files – the ARC has developed a table structure for incorporating benefit data into the Workforce Information Database for those states that conduct benefit surveys. You can view the structure document or download an archive file containing the structure document, MS Access and Visual FoxPro Databases here.
Employment Initiatives Tracking Tables: the ARC has developed table structures that allow states to track job openings, hires and wage information by industry, occupation and funding source for employment initiatives. The ARC has developed a structure document and prototype database containers as MS Access and Visual FoxPro databases.