HUD has created a set of Excel files for each state, plus DC and Puerto Rico. These files are appropriate for planners and local practitioners interested only in their geographic area. More extensive guidance for using these files is provided here: CHAS Users Guide

Because of the large amount of data in each table and the large number of jurisdictions, providing nationwide data in only one file per table is beyond the capacity of Excel, except at the state level. For example, if Table 1—with 249 rows of data per jurisdiction—were provided for all 1,882 counties in one file, that file would have 468,618 rows. Below are 52 zip files—one for each state, the District of Columbia, and Puerto Rico—each of which contains data for that state only, in Excel. The Excel files are named as follows: CA_Table1_050, where “CA” indicates the state, “Table1” is the table, and “050” is the geographic summary level. For 19 states in which MCDs are the primary governmental or administrative divisions of a county, there are 36 Excel files in each zip file—18 at the summary level 050 and 18 at the summary level 060. All other zip files contain 18 Excel files.

State Files for Download

Alabama (*.zip, 3.3MB)

Alaska (*.zip, 0.4MB)

Arizona (*.zip, 2.5MB)

Arkansas (*.zip, 1.0MB)

California (*.zip, 3.5MB)

Colorado (*.zip, 1.7MB)

Connecticut (*.zip, 4.4MB)

Delaware (*.zip, 0.2MB)

District of Columbia (*.zip, 0.1MB)

Florida (*.zip, 3.6MB)

Georgia (*.zip, 6.0MB)

Hawaii (*.zip, 0.3MB)

Idaho (*.zip, 1.2MB)

Illinois (*.zip, 11.6MB)

Indiana (*.zip, 9.8MB)

Iowa (*.zip, 2.4MB)

Kansas (*.zip, 3.2MB)

Kentucky (*.zip, 3.7MB)

Louisiana (*.zip, 3.1MB)

Maine (*.zip, 1.6MB)

Maryland (*.zip, 1.6MB)

Massachusetts (*.zip, 7.6MB)

Michigan (*.zip, 11.2MB)

Minnesota (*.zip, 6.8MB)

Mississippi (*.zip, 3.3MB)

Missouri (*.zip, 3.7MB)

Montana (*.zip, 0.6MB)

Nebraska (*.zip, 1.4MB)

Nevada (*.zip, 0.6MB)

New Hampshire (*.zip, 1.7MB)

New Jersey (*.zip, 10.4MB)

New Mexico (*.zip, 1.3MB)

New York (*.zip, 11.7MB)

North Carolina (*.zip, 5.5MB)

North Dakota (*.zip, 0.9MB)

Ohio (*.zip, 13.3MB)

Oklahoma (*.zip, 2.7MB)

Oregon (*.zip, 1.9MB)

Pennsylvania (*.zip, 9.8MB)

Puerto Rico (*.zip, 4.3MB)

Rhode Island (*.zip, 1.7MB)

South Carolina (*.zip, 2.7MB)

South Dakota (*.zip, 1.0MB)

Tennessee (*.zip, 4.3MB)

Texas (*.zip, 7.9MB)

Utah (*.zip, 0.9MB)

Vermont (*.zip, 0.9MB)

Virginia (*.zip, 5.3MB)

Washington (*.zip, 2.1MB)

West Virginia (*.zip, 2.2MB)

Wisconsin (*.zip, 5.7MB)

Wyoming (*.zip, 0.7MB)