AREATYPE

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

Data Sources

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.

Table Format

No recent changes.

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

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.

Table Format

No recent changes.

WID2.7

Update Calendar

OMB: https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/bulletins/2015/15-01.pdf

   

GEOG

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

Data Sources

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.

Table Format

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

WID2.7

WID2.6.1

Update Calendar

OMB: https://www.whitehouse.gov/sites/whitehouse.gov/files/omb/bulletins/2015/15-01.pdf