The American Community Survey (ACS) is a part of the U.S. Census Bureau's Decennial Census Program and is designed to provide more current demographic, social, economic, and housing estimates throughout the decade. The ACS provides information on more than 40 topics, including education, language ability, the foreign-born, marital status, migration and many more. Each year the survey randomly samples around 3.5 million addresses and produces statistics that cover 1-year and 5-year periods for geographic areas in the United States and Puerto Rico, ranging from neighborhoods to Congressional districts to the entire nation. For more information about the ACS, please visit our main page at: http://www.census.gov/acs. ACS data are published through a number of channels, including American FactFinder, QuickFacts, Easy Stats as well as the Census Bureaus Application Programming Interface (API). This document will brief data users on the contents of the ACS Summary File and explain how they can use it to obtain statistics.
The American Community Survey Summary File (ACSSF) is a unique data product that includes all the estimates and margins of error from the Detailed Tables and geographies that are published for the ACS. Other ACS data products, such as Subject Tables and Data Profiles, are created from the Detailed Tables and are therefore not available in the ACS Summary File.
Since the Detailed Tables contain a large number of cells, the tables are stored in a series of files with only the data from the tables, without such information as the title of the tables, the description of the rows, and the names of the geographic areas. That information (or metadata) is in other files, including the Sequence Number and Table Number Lookup file and templates, that the user must merge with the data files to reproduce the tables. Learn more about the Sequence Number and Table Number Lookup file in Chapter 2.3. and the templates in Chapter 2.2.
The ACS Summary File data files are in American Standard Code for Information Interchange (ASCII) format. The files are divided into three types:
Geographies - (position based and comma delimited)
Geographies - (position based and comma delimited)
Margins of Error - (comma delimited)
Chapter 2 discusses each component in detail and explains how to put them all together.
Data contained in the ACS Summary File cover demographic, social, economic, and housing subject areas. All Detailed Tables for the ACS 1-year and 5-year estimates are in the Summary File and are listed in Appendix A for their respective data release.
The ACS Summary File covers geographic areas based on "summary levels." A summary level specifies the content and the hierarchical relationships of the geographic elements that are required to tabulate and summarize data. For example, summary level code "040" represents the U.S. states, Washington D.C., and Puerto Rico; while summary level code "050" represents counties and county equivalents within states.
The ACS 1-year estimates are published for areas that have populations above 65,000. The ACS 3-year estimates are no longer published, but historically covered areas with populations above 20,000. The ACS 5-year estimates are published for all geographic areas, including census tracts, block groups, American Indian areas, core based statistical areas, combined statistical areas, Congressional districts, and state legislative districts. View the full list of summary levels
published for the Detailed Tables in Appendix B. Data for census block groups are published in American FactFinder, the Census Bureau API, as well as the ACS Summary File, for the 2010-2014 ACS 5-year data release. The list of tables in the 5-year Appendix A shows which tables are available at the block group level.
The Summary File Excel Import Tool is a replicate of the Excel templates that Census 2000 provided for the Summary File 3 release. The Excel Import Tool provides a basic layout of each sequence in Excel in the same format as the estimate and margin of error files are formatted. A detailed description of a sequence is available in Chapter 2.3.For individuals that do not have Excel 2007 or later and are unable to use the Summary File Retrieval Tool, the Excel Import Tool provides an alternative option to read the ACS Summary File into Excel. You can access instructions for using this tool on the ACS Summary File Documentation page.
There are two programming options for SAS users. The first option is a set of individual SAS programs, one for each summary file by geography and sequence. These programs are best for users only interested in looking at a specific sequence for a specific geography. The second option is a single SAS program that is parameterized to allow users to read in any sequence for any geography into SAS. This program can also be used to read the entire summary file into SAS, and is designed for users looking for a large amount of data. You can access these programs on the Summary File Documentation page.
DataFerrett is a tool provided by the Census Bureau to help users view, download, and manipulate a wide variety of data sets to suit their needs. Among the features provided by this tool is the ability to construct user-defined variables from the variables on the input data file(s), the ability for users to exclude data that is not of interest, a variety of options for downloading data, and the ability to create complex tabular reports from the data including graphs and thematic maps. This tool is ideal for data users who wish to view, customize, and restrict the data that is available in the ACS 5-year Summary File. A link to this tool is available on the Summary File page.
Discontinuation of the ACS Summary File Retrieval Tool
The ACS Summary File Retrieval Tool was discontinued starting with the 2014 ACS Data Releases. Due to the addition of block groups in American FactFinder (AFF) starting with the 2009-2013 ACS 5-year data release and similar functionality of the AFF Download Center, it is no longer necessary to maintain the retrieval tool. In addition, the 2013 ACS 1-year, 3-year, and 5-year estimates were removed from the ACS Summary File Retrieval Tool due to technical and software compatibility issues. You can still access older years of data using the older versions of the ACS Summary File Retrieval
Tool and view detailed instructions on using the AFF Download Center by visiting the ACS Summary File Documentation page at http://www.census.gov/programssurveys/acs/technical-documentation/summary-file-documentation.html.
3-Year Estimates Discontinued
The Census Bureau will not release the 2012-2014 ACS 3-year estimates. The Census Bureau will continue to produce annual estimates for communities of 65,000 or more, and communities of all sizes will continue to receive updated five-year rolling averages for all geographies down block groups each year.
Block Groups Continue to be Available in American FactFinder
For the 2009-2013 and 2010-2014 ACS 5-year data releases, data for census block groups are published in American FactFinder, the Census Bureau API, as well as the ACS Summary File. Block group level data for earlier years are only available in the ACS Summary File.
Beginning with the 2010-2014 ACS 5-year data release, the Census Bureau plans to streamline the production and release of Summary Level 070 tables (state/county/county subdivision/place remainder (or part)) to the 15 tables necessary for the delineation of metropolitan, micropolitan, and related statistical areas (particularly for identification of New England City and Town Area principal cities) by the Office of Management and Budget(OMB), for commuting analysis, and for basic demographic and housing analysis.
The 15 tables to remain for Summary Level 070 include:
1. B01001-Sex by Age
2. B01003-Total Population
4. B08007-Sex of Workers by Place of Work-State and County Level
5. B08008-Sex of Workers by Place of Work-Place Level
6. B08009-Sex of Workers by Place of Work-Minor Civil Division Level
for 12 Selected States (CT, ME, MA, MI, MN, NH, NJ, NY, PA, RI, VT, WI)
7. B08301-Means of Transportation to Work
8. B08302-Time Leaving Home to Go to Work
9. B08303-Travel Time to Work
10. B08601-Means of Transportation to Work for Workplace Geography
11. B08602-Time Arriving at Work from Home for Workplace Geography
12. B08603-Travel Time to Work for Workplace Geography
13. B08604-Worker Population for Workplace Geography
14. B25001-Housing Units
Two Additional Areas Included in the 2010-2014 ACS 5-Year Summary File
The 2010-2014 ACS 5-year Summary File contains two areas from Summary Level 070:
State-County-County Subdivision-Place/Remainder that are not available on American FactFinder. These geographies are "Louisville city (part), Louisville Central CCD, Jefferson County, Kentucky" and "Louisville city (part), Louisville West CCD, Jefferson County, Kentucky." These two additional areas were not published in American FactFinder due to the Census Bureaus Geography Divisions changes to Louisville city.
More details concerning this change can be found on the ACS website on http://www.census.gov/programs-surveys/acs/technical-documentation/table-andgeography-
Please send any technical questions or comments on the ACS Summary File you have via email to: email@example.com. If you have questions or comments about the American Community Survey, you can submit a question online at ask.census.gov/.