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. The non-standard tables currently available include:
O*NET 4.0 Database – the final version of the O*NET database that contained only anlyst data. Subsequent versions included data from the O*NET data collection program. This database is maintained for those who need to use ratings over a uniform set of descriptors. This database contains 24 lookup, data and crosswalk tables. You can view our documentation for the Workforce Information Database – compatible database or download the Visual FoxPro version from our O*NET 4.0 page.
O*NET 21.2 (Production) Database – this version was released in November 2016 and went into production in O*NET Online and other web applications at that time. You’ll find MS Access and delimited text files compatible with the Workforce Information Database on our O*NET 21.2. (updated 2/28/17)
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 databases that contains the crosswalk. The ZIP file that contains the Access database also contains delimited text versions. (Updated 2/3/17)
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.