The licauth table contains all agencies that issue occupational licenses.  It is furnished to the ARC by state LMI offices.  For more detail on this process, see our FAQ.

Data Sources

The source for this data varies by state.

Table Format

In version 2.8 the authority name fields were changed from name1, name2, and name3 to department, division, and board to improve consistency between states.

WID2.8 (PDF 922 KB)

WID2.7 (PDF 919 KB)

Update Calendar

States should submit revisions every year by June 30.  To find out when your state’s most recent submission was, email [email protected].

The license table is furnished to the ARC by state LMI offices.  For more detail on this process, see our FAQ.

A review of the data quality and contents was conducted in 2018-2019. A summary of that work is available here (PDF).

Data Sources

The original source for this data varies by state. Once it’s been submitted to the ARC it’s reviewed and standardized and made available to the public. The primary means of publication is through the CareerOneStop LicenseFinder tool, but download files are also available from their site and on a state-by-state basis from the ARC. While these are useful for states to review and are helpful for cross-state comparisons, this is not a source for the deliverable that is to be submitted.

	National	State	Notes
Source	CSOR NCSL License to Work		There are a number of organizations that have made efforts to track occupational licenses. They rarely are related back to SOC or ONET occupational coding, they may be limited in scope to certain types of occupations, and they may not be frequently updated. However, many add value that the WID structure doesn’t have, such as richer descriptive content or detail on types of requirements (“good moral character”, for example).
		Varies	Every state manages this differently and some are handled at the department level rather than by a central source.
WID Version?	Download Here	State-specific files here	This comes from state-submitted data. Improvements made centrally include – standardizing occupational coding so it compares across states, – adding licenses identified as missing by other sources or collected centrally, – adding license compacts, – adding industry where relevant, – organizing descriptions into indicator values for key requirements

Table Format

In version 2.8 several requirements fields were added to allow comparison of license characteristics between states. Preliminary values have been generated from existing license descriptions and other data sources for most licenses.

WID2.8 (PDF 922 KB)

WID2.7 (PDF 919 KB)

Update Calendar

States should submit revisions every year by June 30.  To find out when your state’s most recent submission was, email [email protected].

Table of covered employment by industry collected for the ES-202/QCEW report.

Data Sources

	National	State/Local	Notes
Source	BLS	BLS	QCEW data is published quarterly with a lag of 6 to 9 months. It is available nationally, statewide, and for counties. States may have different regulations regarding QCEW publication and more detail may be available directly from states.
		EXPO	These are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
WID Version?	Download Here		This comes from publicly available BLS data and will be available shortly after the official publication date/time. This extract is for the entire year, after the annual publication.

Table Format

There have been no recent changes.

WID2.8 (PDF 922 KB)

WID2.7 (PDF 919 KB)

Update Calendar

https://www.bls.gov/schedule/news_release/cew.htm

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

GEOG (PDF 1,003 KB)

PERIOD (PDF 1,003 KB)

OWNERSHP (PDF 1,003 KB)

INDCODES (PDF 1,003 KB)

This table contains the employer data from the Workforce Information Database Employer Database.  Contents are furnished by a private contractor and use of the data in the Employer Database is subject to the terms and agreements the found in the contract signed by the states and the Employer Database supplier.

Data Sources

	National	State/Local	Notes
Source		vendor	Data is released at the state level from the vendor once or twice a year. It can be arranged to download it from the vendor and a disk is sent to state LMI offices.
	Career OneStop	Career OneStop (widget)	CareerOneStop receives the data through the same contract as states.  They have produced a search tool and embeddable widget that meets contract requirements that states can link to or insert on their own websites.
WID Version?	N/A	N/A	The download from the vendor is similar to EMPDB structure.

Table Format

There were some values in the most recent release that violated foreign keys.  The vendor put out this (XLSX 13 KB) to explain the difference.

WID2.8 (PDF 922 KB)

WID2.7 (PDF 919 KB)

Update Calendar

Not published

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

[one-half-first]

GEOG (PDF 1,003 KB)

GEOCODE (PDF 1,003 KB)

CONTACTTITLE (PDF 1,003 KB)

CONTACTPRO (PDF 1,003 KB)

PRVGOVST (PDF 1,003 KB)

LOCSTAT (PDF 1,003 KB)

STOCKEXCH (PDF 1,003 KB)

[/one-half-first]

[one-half]

ANNSLFLG (PDF 1,003 KB)

CREDITCD (PDF 1,003 KB)

EMPDBINF (PDF 1,003 KB)

ANNSLRNG (PDF 1,003 KB)

EMPSZRNG (PDF 1,003 KB)

EMPSZFLG (PDF 1,003 KB)

[/one-half]

The primary data source of this table is the Occupational Employment Statistics (OES) program, a BLS-state partnership for collecting data at the occupational level.

Data Sources

	National	State/Local	Notes
Source	BLS	BLS	OES data is published annually from a 3-year overlapping sample.  For this reason, changes in occupational coding can complicate loads into the database.
		LEWIS	These are for editing and controlled access by LMI Analysts. State-level data can also be aggregated to state-specific regional combinations, as well extracts created for analysis.
WID Version?	WID 2.8 WID 3.0		This comes from publicly available BLS data and will be available shortly after the official publication date/time.

Table Format

With version 2.6, OESWAGE was replaced with IOWAGE, a similar table that is designed to be more accommodating of additional data sources.

WID2.8 (PDF 922 KB)

WID2.6-2.7 (PDF 919 KB)

WID2.4 (PDF 721 KB)

Update Calendar

Not published
Latest information at https://www.bls.gov/news.release/pdf/ocwage.pdf (PDF 499 KB)

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

GEOG (PDF 1,003 KB)

PERIOD (PDF 1,003 KB)

OCCCODES (PDF 1,003 KB)

INDCODES (PDF 1,003 KB)

WGSOURCE (PDF 1,003 KB)

RATETYPE (PDF 1,003 KB)

National Projections are a BLS program and State and Local Projections are an ETA program conducted in partnership with states.  National projections are produced every two years while the areas and frequency of state-level estimates is more variable.

Data Sources

	National	State/Local	Notes
Source	BLS		Although data is produced for industries and occupations and combined into a single table for the purposes of the WID, the BLS presents them as separate programs.  Analysis and documentation may not apply to both industry and occupational projections.
	Projections Central	Projections Suite	These are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
WID Version?	Download Here (XLSX 7.7 MB)		This comes from publicly available BLS data and will be available shortly after the official publication date/time.

Table Format

In version 2.8 field titles were lengthened and an ownership field was added to inddir to help crosswalk the industries that are unique to projections. With version 2.7, data fields were added to reflect changes in methodology.  Fields that no longer have historically consistent meaning or are no longer available were left in the table structure to preserve historic data but are meant to be left NULL with new imports.

WID2.8 (PDF 922 KB)

WID2.7 (PDF 919 KB)

WID2.6.1 (PDF 881 KB)

Update Calendar

National: Odd numbered years, usually in December

Related Tables

Links to the table description in the current structure document.  Note: Page anchors do not work in Microsoft Edge (the default browser for some states).

GEOG (PDF 1,003 KB)

INDDIR (PDF 1,003 KB)

OCCDIR (PDF 1,003 KB)

GROWCODE (PDF 1,003 KB)