A table containing identifiers for the geographic type, i.e., MSA, SDA, county city, township, etc.
| National | State/Local | Notes | |
| WID Version? | Download Here | Download Here | These 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. |
No recent changes.
N/A
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.
| Geographic Extent | Notes | |
| Census | National and Local | National, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas |
| State Specific | Varies | Many 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 Boards (XLSX 141 KB) | Workforce 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. | |
| MSA | The Office of Management and Budget (OMB) defines Metropolitan and Micropolitan Statistical Areas and the Census Bureau publishes the bulletins as delineation files. July 2023 (XLSX 100 KB) (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. |
No recent changes.
Census: https://www.census.gov/programs-surveys/metro-micro.html
The GEOG table is the central location for all geographic areas used in the database.
| National | State/Local | Notes | |
| Source | Census | Census | National, state, counties, places, Metropolitan & micropolitan statistical areas, metropolitan divisions, combined statistical areas |
| State Specific | Many states have analysis regions, congressional districts, and WSAs that are available from state sources. | ||
| WID Version? | Download Here | Download Here | All national, state, and local are contained in the same table. |
| July 2023 (XLSX 100 KB) 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. |
In version 2.7 the fields LATITUDE (numeric(11,6)), LONGITUDE (numeric(11,6)), GEOPCODE (char(1)) were added
Census: https://www.census.gov/programs-surveys/metro-micro.html