Download the Database
The entire State and County QuickFacts 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 QuickFacts tables.
Please note that the data file format has changed. Data flags are now in a separate file.
- DataSet.txt [DataSet.txt] -- 3195 rows, one for the U.S., one for each state, one for each county, but no column headings. Each row is identified by a 5-digit combined state and county code. Data are comma-delimited.
- DataDict.txt [DataDict.txt] -- One row for each column in DataSet.txt. Flat ASCII files have mnemonic identifier, full title, number of decimals, and the U.S. total value (matching the first row of DataDict.txt)
- FIPS_CountyName.txt [FIPS_CountyName.txt] -- FIPS and corresponding place names.
Flags -- Some data items are represented by a flag.
- DataFlags.txt [DataFlags.txt] -- 3195 rows, one for the U.S., one for each state, one for each county, but no column headings. Each row is identified by a 5-digit combined state and county code. Data are comma-delimited. Column headings follow those in the Data Dictionary file DataDict.txt.
- FlagsDict.txt [FlagsDict.txt] -- Flag codes and corresponding meaning.
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:
-
FootNotes.txt [FootNotes.txt] -- Footnotes are identified by mnemonic (shown in DataDict), the county to which they apply (identified by code), and the footnote key (a link into FootText.txt). There is one row for each instance of each footnote in this flat ASCII file.
- FootText.txt [FootText.txt] -- Footnote key and its text
To add descriptive column headings to the data in Excel
Columns in DataSet.txt are identified by 9-character mnemonics like PST045211. While the definition of each mnemonic is provided in DataDict.txt, it is frequently preferable to merge them into the data file.
Download DataSet.txt, DataDict.txt, and FIPS_CountyName.txt to a local drive.
Open the file DataDict.txt. You will be prompted through the Text Import Wizard
- Click Next
- Click and drag the first break point to character 10
- Delete each break point (double click on it) that appears between characters 11 and 113
- Confirm or add break points (single click at characters 114, 118, 126, 137, 149, and 159
- Click Next
- Click Finish
Transpose information from each row to create column headings
- Insert 3 blank rows at the top of the DataDict worksheet
- Select cells starting with A6 (the one that reads STATECOU) to the cell at the bottom of column B (usually around B90)
- Copy it (Edit-Copy or Ctl-C)
- Select cell A1
- On the Edit menu, click Paste Special
- Select the Transpose checkbox, and then click OK
Open DataSet.txt and work through the wizard
- Make sure the radio button for Delimited is selected; click Next
- Put a check mark next to Comma; click Next
- Click the radio button for Text with the first column highlighted; for all other columns, the default General format is adequate; click Finish
- Insert 3 blank lines at the top of the spreadsheet
Copy headings from DataDict to the top of the DataSet worksheet
- Copy the first 2 lines of the DataDict into the first 2 lines of the DataSet spreadsheet
- If the mnemonics on on line 1 agree with the mnemonics on line 4, you are set.
To add in state and county names to the data in Excel
- In the DataSet spreadsheet, add a column to the left of column A to accept the county name
- Open the file FIPS_CountyName.txt in Excel
- In the import wizard
- Select Fixed Width, then Next
- Move the break line to the start of the name (character 6), and click Next
- Click on the radio button next to Text while the first column is highlighted.
- Click Finish
- Copy cells B1:B3195, and paste them into the DataSet spreadsheet, into the cell in column A to the left of code 00000 in column B.
Facebook
Twitter
Flickr
YouTube