DEMOGRAPHICS

This table contains population and demographic estimates for a geographic area and time period.

Data Sources

This comes from publicly available Census data and will be available shortly after the official publication date/time.

NationalState/LocalNotes
SourceNational, stateMetropolitan/ micropolitan

County

City and town

Tribal areas
This comes from Census tables B01001, B01001A, B01001B, B01001C, B01001D, B01001E, B01001F, B01001G, B01001I, B01002, and B03002. Geographic extent is dependent on ACS 5 or 1 year.
WID Version?All areasThis comes from publicly available Census data and will be available shortly after the official publication date/time.
CustomThis is a python script to extract the data from the Census API and format it to load into the WID. The script contains parameters to define years and areas for extraction allowing users to pull the most current data as needed. It will require a user to obtain a Census API key and insert it at the line “api_key = ” ”

Table Format

In WID 2.8 fields for Margins of Error were removed from the table structure, but all others remained the same.

WID2.8

WID2.7

Update Calendar

None

Related Tables

GEOG

PERIOD

   

Education

Many states have a use for information about higher education providers, either for analytical purposes or to be able to direct job seekers to appropriate programs.  The National Center for Education Statistics (NCES) Integrated Postsecondary Education Data System (IPEDS) puts out data about providers and programs offered, organized by state but containing address-level data.

Data Sources

NationalState/LocalNotes
SourceIPEDSSameThere are Preliminary, Provisional, and Final data sets.  Schedule is approximate and lag varies for different download files.
WID Version?2022
2021
2020
2019
2018
2017
2016
The ARC files use the Provisional source data.

Table Format

This source provides content for data tables PROGRAMS, SCHOOLS, and PROGCOMP.

WID2.8:                PROGRAMS                 SCHOOLS                 PROGCOMP

Update Calendar

In general new files are published in the fall but the source data is sometimes delayed.

Related Tables

COMPLTYP                                     OCCCODES
LENTYPE                                         CLASSTIME
INSTOWN                                       INSTTYPE

   

POPULATN

This table contains population estimates for a geographic area and time period.

Data Sources

This comes from publicly available Census data and will be available shortly after the official publication date/time. ​

NationalState/LocalNotes
SourceNational, stateMetropolitan/ micropolitan

County

City and town

WID Version?All areasThis comes from publicly available ACS data and will be available shortly after the official publication date/time.
Population estimatesCensus Bureau’s Population Estimates Program (PEP) – custom Python extract

Table Format

There have been no recent changes.

WID2.8

WID2.7

Update Calendar

None

Related Tables

GEOG

PERIOD

POPSOURCE

   

LICAUTH

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

WID2.7

Update Calendar

States should submit revisions every two years.  To find out when your state’s most recent submission was, email ARC.DEED@state.mn.us.

   

LICENSE

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.

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.

NationalStateNotes
SourceCSOR

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).
VariesEvery state manages this differently and some are handled at the department level rather than by a central source.
WID Version?Download HereState-specific files hereThis 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

WID2.7

Update Calendar

States should submit revisions every two years.  To find out when your state’s most recent submission was, email ARC.DEED@state.mn.us.

   

INCOME

Income data by geography. Includes income estimates from the Census Bureau and the Bureau of Economic Analysis (BEA).

Data Sources

NationalState/LocalNotes
SourceBEABEABEA income data is available for the US, States, and Counties and is published at various times throughout the year.  National data lags by a year, but state and local data are published later.
 CensusCensusCensus income is available for the US, States, Metro/Micro areas and Counties and is published annually.
WID Version? BEAState PagesThis comes from publicly available BEA data and will be available shortly after the official publication date/time. National data is contained in state-specific file.
CensusAll RegionsThis comes from the American Community Survey and is updated when 5-year estimates become available. All areas are contained in a single file.
CustomThis is a python script to extract the data from the BEA API and format it to load into the WID. The script contains parameters to define years and areas for extraction allowing users to pull the most current data as needed. It will require a user to obtain a BEA API key and insert it at the line “api_key = ” # insert API key here”

Table Format

There have been no recent changes.

WID2.8

WID2.7

Update Calendar

BEA: https://www.bea.gov/newsreleases/2017rd.htm

Census: https://www.calendarwiz.com/calendars/calendar.php?crd=cens1sample&cid=31793&PHPSESSID=8c565d8eb664fa366a0b776d55e55b1a&jsenabled

Related Tables

GEOG

PERIOD

INCOMTYP

   

INDUSTRY

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

Data Sources

NationalState/LocalNotes
SourceBLSBLSQCEW 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.
EXPOThese are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
WID Version?Download HereThis 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

WID2.7

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

PERIOD

OWNERSHP

INDCODES

   

EMPDB

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

NationalState/LocalNotes
SourcevendorData 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/AN/AThe 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 to explain the difference.

WID2.8

WID2.7

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).

   

IOWAGE

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

NationalState/LocalNotes
SourceBLS BLSOES data is published annually from a 3-year overlapping sample.  For this reason, changes in occupational coding can complicate loads into the database.
LEWISThese 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?Download HereThis 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

WID2.6-2.7

WID2.4

Update Calendar

Not published
Latest information at https://www.bls.gov/news.release/pdf/ocwage.pdf

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

PERIOD

OCCCODES

INDCODES

WGSOURCE

RATETYPE

   

IOMATRIX

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

NationalState/LocalNotes
SourceBLSAlthough 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 CentralProjections SuiteThese are for editing and controlled access by LMI Analysts. State-level data is available for download as completed.
WID Version?Download HereThis 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

WID2.7

WID2.6.1

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

INDDIR

OCCDIR

GROWCODE