AREATYPE

A table containing identifiers for the geographic type, i.e., MSA, SDA, county city, township, etc.

Data Sources

NationalState/LocalNotes
WID Version?Download HereDownload HereThese codes are generally specific to the WID, not drawn from the data source.

Many states have analysis regions, congressional districts, and WSAs that are available from state sources that can be assigned codes between 50 and 70 at the state’s discretion.

Table Format

No recent changes.

WID2.8

WID2.7

Update Calendar

N/A

   

SUBGEOG

A table containing identifiers for substate geographic areas. For each larger stfips, areatype, area combination, this table will contain a list of unique substfips, subareatyp and subarea smaller combinations that comprise the larger geographic area.

Data Sources

Geographic ExtentNotes
CensusNational and LocalNational, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
State SpecificVariesMany states have analysis regions, congressional districts, and WSAs that are available from state sources.
WID Version?National and Local All national, state, and local are contained in the same table.
Workforce Development BoardsWorkforce Development Boards (WDB) are state program areas. They’re defined locally but tracked by CareerOneStop and reviewed annually to ensure they remain current. This data set makes COS verified WDB definitions available in standard GEOG/SUBGEOG format.
MSAThe Office of Management and Budget (OMB) defines Metropolitan and Micropolitan Statistical Areas and the Census Bureau publishes the bulletins as delineation files.

July 2023 (combined with geog)
Sep 2018  GEOG
Apr 2018  GEOG
Aug 2017  GEOG
Jul 2015  GEOG
Feb 2013 GEOG

Note: July 2023 continues to use 31 and 32 for areatypes because of the upcoming change to WID 3.0 and the implementation of AreaTypeVersion to distinguish between vintages of areas instead of the previous practice of adding new codes.

Table Format

No recent changes.

WID2.8

WID2.7

Update Calendar

Census: https://www.census.gov/programs-surveys/metro-micro.html

   

GEOG

The GEOG table is the central location for all geographic areas used in the database.

Data Sources

NationalState/LocalNotes
SourceCensusCensusNational, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas
State SpecificMany states have analysis regions, congressional districts, and WSAs that are available from state sources.
WID Version?Download HereDownload Here All national, state, and local are contained in the same table.
July 2023
Sep 2018
Apr 2018
Aug 2017
Jul 2015
Feb 2013
Current MSA.  Component areas can be found through the Census Bureau or on the subgeog page.

Note: July 2023 continues to use 31 and 32 for areatypes because of the upcoming change to WID 3.0 and the implementation of AreaTypeVersion to distinguish between vintages of areas instead of the previous practice of adding new codes.

Table Format

In version 2.7 the fields LATITUDE (numeric(11,6)), LONGITUDE (numeric(11,6)), GEOPCODE (char(1)) were added

WID2.8

WID2.7

WID2.6.1

Update Calendar

Census: https://www.census.gov/programs-surveys/metro-micro.html