2010 Urban Area Lists Record Layouts

U.S. Department of Commerce

2010 Census Urban Lists Record Layouts

2010 Urban Area List Files

Urban area-sorted files are available as fixed format text files and Excel files. Each urban area-sorted list file is sorted by urban area census code (UACE) and contains records for either: 1) all urban areas (ua_list_all.txt/xls), 2) urbanized areas (ua_list_ua.txt/xls), or 3) urban clusters (ua_list_uc.txt/xls). Each file includes urban areas in the United States, Puerto Rico, and the Island Areas.

The text files are fixed format and designed for internet viewing. Five blanks are included after each field in the fixed format file. Start and end positions are included in the layout below for the fixed format text files. Area measurements are presented in both square meters and square miles. Area measurements in square miles are rounded to two decimal places. Population density values are in persons per square mile of land area, rounded to one decimal place.

2010 Urban Area State-Sorted List Files

Urban area state-sorted files are available as fixed format text files and Excel files. Each urban area state-sorted list file is sorted first by state and then by urban area census code (UACE) and contains records for either: 1) all urban areas (ua_st_list_all.txt/xls), 2) urbanized areas (ua_st_list_ua.txt/xls), or 3) urban clusters (ua_st_list_uc.txt/xls). Each file includes urban areas in the United States, Puerto Rico, and the Island Areas (where applicable).

Both file formats include the state name followed by a blank line. The next line includes the column names. The data for each state is followed by three blank lines.

Area measurements are presented in both square meters and square miles. Area measurements in square miles are rounded to two decimal places. Population density values are in persons per square mile of land area, rounded to one decimal place.

2010 Percent Urban and Rural by State

This file contains urban and rural population, population density, and land area by state. Urban area numbers are presented for all urban areas, urbanized areas, and urban clusters.

Area measurements are in square meters. Population density vales are in persons per square mile of land area, rounded to one decimal place. All percentage values are rounded to two decimal places.

2010 Percent Urban and Rural by County

This file contains urban and rural population, population density, and land area by county. Urban area numbers are presented for all urban areas, urbanized areas, and urban clusters.

Area measurements are in square meters. Population density vales are in persons per square mile of land area, rounded to one decimal place. All percentage values are rounded to two decimal places.

2000 to 2010 Population and Area Change by 2010 Urbanized Area

This file contains total and percent change in population and land area for the 2010 Urbanized Areas from 2000 to 2010.

Total land area measurements are in square miles. Percent change in land area calculations are based on total land area of urban area in square meters. All total land area and percentage values are rounded to two decimal places.

Notes on urbanized area change: Area and population change can be the result of one or a combination of 1) internal growth, 2) new growth, and/or 3) the merger of adjacent urban territory formerly associated with an urban cluster.

Column Name	Maximum Length	Start (.txt)	End (.txt)	Column Description
UACE	5	1	5	Five digit code that uniquely identifies 2010 urban area entities
NAME	60	11	70	2010 urban area name
POP	9	76	84	2010 population of the urban area
HU	9	90	98	2010 housing unit count for the urban area
AREALAND	14	104	117	Land area for the urban area in square meters
AREALANDSQMI	9	123	131	Land area for the record converted to square miles
AREAWATER	14	137	150	Water area for the record in square meters
AREAWATERSQMI	9	156	164	Water area for the record converted to square miles
POPDEN	9	170	178	Population density
LSADC	2	184	185	Legal/Statistical area description code for the urban area (75 for urbanized area, 76 for urban cluster)

Column Name	Maximum Length	Start	End Column	Description
UACE	5	1	5	Five digit code that uniquely identifies 2010 urban area entities
NAME	60	11	70	2010 urban area name
STATE	2	76	77	2010 state FIPS code
PART	1	83	83	2010 urban area part flag indicates urban areas with territory in multiple states. Each record will have value = “P” if associated with urban area in multiple states, NULL otherwise
POP	9	89	97	2010 population of the urban area for part of urban area located within the state
HU	9	103	111	2010 housing unit count for the urban area for part of urban area located within the state
AREALAND	14	117	130	Land area for the record in square meters for part of urban area located within the state
AREALANDSQMI	9	136	144	Land area for the record converted to square miles for part of urban area located within the state
AREAWATER	14	150	163	Water area for the record in square meters for part of urban area located within the state
AREAWATERSQMI	9	169	177	Water area for the record converted to square miles for part of urban area located within the state
POPDEN	9	183	191	Calculated urban area population density for part of urban area located within the state
LSADC	2	197	198	Legal/statistical area description code for the urban area (75 for urbanized area, 76 for urban cluster)

Column name	Maximum length	Column description
STATE	2	2010 state FIPS code
STATENAME	20	State name
POP_ST	9	2010 total population of the state
AREA_ST	14	Land area of the state
POP_URBAN	9	2010 urban population of the state
POPPCT_URBAN	6	Percentage of the total population of the state represented by the urban population
AREA_URBAN	14	Land area of the urban areas within the state
AREAPCT_URBAN	6	Percentage of the land area of the state represented by the land area of the urban areas
POPDEN_URBAN	9	Population density of the urban areas
POP_UA	9	Population of the urbanized areas of the state
POPPCT_UA	6	Percentage of the total population of the state represented by the population of the urbanized areas
AREA_UA	14	Land area of the urbanized areas within the state
AREAPCT_UA	6	Percentage of the land area of the state represented by the land area of the urbanized areas
POPDEN_UA	9	Population density of the urbanized areas
POP_UC	9	Population of the urban clusters of the state
POPPCT_UC	6	Percentage of the total population of the state represented by the population of the urban clusters
AREA_UC	14	Land area of the urban clusters within the state
AREAPCT_UC	6	Percentage of the land area of the state represented by the land area of the urban clusters
POPDEN_UC	9	Population density of the urban clusters
POP_RURAL	9	2010 rural population of the state
POPPCT_RURAL	6	Percentage of the total population of the state represented by the rural population
AREA_RURAL	14	Land area of the rural areas within the state
AREAPCT_RURAL	6	Percentage of the land area of the state represented by the land area of the rural areas
POPDEN_RURAL	9	Population density of the rural areas

Column name	Maximum length	Column description
STATE	2	2010 state FIPS code
COUNTY	3	2010 county FIPS code
STATENAME	20	State name
COUNTYNAME	100	County name
POP_COU	9	2010 total population of the county
AREA_COU	14	Land area of the county
POP_URBAN	9	2010 urban population of the county
POPPCT_URBAN	6	Percentage of the total population of the county represented by the urban population
AREA_URBAN	14	Land area of the urban areas within the county
AREAPCT_URBAN	6	Percentage of the land area of the county represented by the land area of the urban areas
POPDEN_URBAN	9	Population density of the urban areas
POP_UA	9	Population of the urbanized areas of the county
POPPCT_UA	6	Percentage of the total population of the county represented by the population of the urbanized areas
AREA_UA	14	Land area of the urbanized areas within the county
AREAPCT_UA	6	Percentage of the land area of the county represented by the land area of the urbanized areas
POPDEN_UA	9	Population density of the urbanized areas
POP_UC	9	Population of the urban clusters of the county
POPPCT_UC	6	Percentage of the total population of the county represented by the population of the urban clusters
AREA_UC	14	Land area of the urban clusters within the county
AREAPCT_UC	6	Percentage of the land area of the county represented by the land area of the urban clusters
POPDEN_UC	9	Population density of the urban clusters
POP_RURAL	9	2010 rural population of the county
POPPCT_RURAL	6	Percentage of the total population of the county represented by the rural population
AREA_RURAL	14	Land area of the rural areas within the county
AREAPCT_RURAL	6	Percentage of the land area of the county represented by the land area of the rural areas
POPDEN_RURAL	9	Population density of the rural areas

Column name	Maximum length	Column description
UA	5	Five digit code that uniquely identifies 2010 urban area entities
UANAME	100	2010 urban area name
UA00	5	Five digit code that uniquely identifies 2000 urban area entities
UA00NAME	100	2000 urban area name
UAPOP	9	2010 population of the 2010 urban area
UA00POP	9	2000 population of the 2000 urban area
UAPOPCHNGE	9	Change in urban area population from 2000 to 2010
UAPOPPCTCHNGE	6	Percent population change in urban area from 2000 to 2010
UAAREALAND	9	Total land area of the 2010 urban area
UA00ARELAND	9	Total land area of the 2000 urban area
UAAREACHNGE	9	Change in urban area land area from 2000 to 2010
UAAREAPCTCHNGE	6	Percent land area change in urban area from 2000 to 2010