USA MapStats|Select a State|What's New

Download the Database

The entire MapStats state & county profiles dataset, with U.S., state, and county data is available for download. Downloadable data files for cities may be issued later. The current downloadable data set may include items not displayed on MapStats tables.

Flags -- Some data items are represented by a flag.

You will need to obtain FIPS state and county codes from another source.

Footnotes -- Those footnotes that appear for all geographic areas are not shown here. Footnotes that are applicable only to selected areas are provided in two files:

To manipulate the data in Excel

Open the file DataDict.txt. You will be prompted through the Text Import Wizard
  1. Click Next
  2. Click and drag the first break point to character 12
  3. Double click on each other break point to delete it
  4. Add in break points (single click) at characters 135,139,147, and 158
  5. Click Next
  6. Click Finish
Transpose information from each row to create column headings
  1. Insert 6 blank rows at the top of the DataDict worksheet
  2. Select cells starting with the one that reads STATECOU to the lower right cell
  3. Copy it (Edit-Copy or Ctl-C)
  4. Select cell A1
  5. On the Edit menu, click Paste Special
  6. Select the Transpose checkbox, and then click OK
Open DataSet.txt and work through the wizard
  1. Make sure the radio button for Delimited is selected; click Next
  2. Put a check mark next to Comma; click Next
  3. Click the radio button for Text with the first column highlighted; for all other columns, the default General format is adequate; click Finish
  4. Insert 5 blank lines at the top of the spreadsheet
Copy headings from DataDict to the top of the DataSet worksheet
  1. Copy the first 5 lines of the DataDict into the first 5 lines of the DataSet spreadsheet
  2. If the data values on line 5 agree with the data values on line 6, you are set.
Add in state and county names
  1. In the DataSet spreadsheet, add a column to the left of column A to accept the county name
  2. Open the file FIPS_CountyName.txt in Excel
  3. In the import wizard
    1. Select Fixed Width, then Next
    2. Move the break line to the start of the name (character 6), and click Next
    3. Click on the radio button next to Text while the first column is highlighted.
    4. Click Finish
  4. Copy cells B1:B3196, and paste them into the DataSet spreadsheet, cell A9

Skip this navigation menu

Page Last Modified: April 14, 2008