Social Explorer Logo
Documentation: ACS 2007 (3-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2007-3yr Summary File: Technical Documentation
Social Explorer; U.S. Census Bureau; 2005-2007 American Community Survey 3-Year Summary File: Technical Documentation.
ACS 2007-3yr Summary File: Technical Documentation
Chapter 1. Introduction
1.1. Citation
U.S. Census Bureau, 2005-2007 American Community Survey 3-Year Summary File: Technical Documentation.
1.2. Special Notes
  1. For the first time, a 3-Year Summary File has been released to the public.
  2. The 2005-2007 American Community Survey (ACS) 3-Year Summary File contains exactly the same table format and content as the 2007 ACS Summary File.
  3. Details on changes in the detailed tables and derived products since the 2006 ACS, including new products is available on the ACS Website at:
  4. Changes to the 2005-2007 detailed tables which contain complete lists of new, removed, and modified tables can be referenced on the ACS Website on:
  5. Because of added/dropped tables, a lot of the special sequence numbers have been moved around. For instance, B24010 used to be in 0106 and 0107, but is now in 0111 and 0112. For more details, see Chapter 5 and review the file
  6. ACS 2007 detailed tables that were subject to geographic restrictions are located on: - 2007_Data_Product_Geographic_Restriction.xls
  7. Each set of ACS Summary file Technical Documentation is tied to a specific ACS year. Currently we have four sets of ACS Summary file, 2005 (prototype), 2006 (prototype), 2006 (production), 2007 (production), and 2005-2007 3-Year (production.)
  8. The Census Bureau and American Community Survey Office plans to re-run the 2005 ACS-Summary file and produce them in the current final format.
  9. Based on user input, the ACS 2006, ACS 2007, and 2005-2007 ACS 3-Year Production Summary Files were created using the same file naming convention. For more details reference Chapter 1 of the technical documentation, section 3.3: File Identification.

1.3. Notes on Updates to the Technical Document Since 2007
Updated Chapters
  • Chapter 1. Abstract
Updates were made to all of the Special Notes, GQ section, number of tables, added the 2007 summary file link: , and in the document overview updated the Appendix F to contain "the 110th Congressional District".
  • Chapter 2. How to Use the ACS Summary file
Updates were made to links.
  • Chapter 5. List of Detailed Tables
Updated chapter 5 file link to

Updated Appendices
  • Appendix A. ACS Geographic Terms and Concepts
American Community Survey geographic terms and concepts were updated to reflect more current definitions.
  • Appendix D. Questionnaire
links to the ACS questionnaire on the website were updated to include the most recent questionnaire.
  • Appendix E. Data Products and User Assistance
Data Products and User Assistance section links and document sources were updated.
  • Appendix G. Code Lists
Removed code lists for 2006 and added code lists for 2007.
  • Appendix I. Sample SAS Programs
Updates were made to the sample SAS programs, added additional sample programs, updated links, and modified SASReadme.
  • Appendix J. User Notes
Updates were made to the user notes and to links.

1.4. Type of File
Summary statistics.
1.5. Subject Content
The American Community Survey (ACS) is the largest household survey in the United States, with an annual sample size of about 3 million addresses. Every year the ACS supports the release of 1-Year estimates for geographic areas with populations of 65,000 or more and 3-Year estimates for geographic areas with populations of 20,000 or more. This release of the American Community Survey Production Summary file (ACS-SF) contains the 2005-2007 ACS 3-Year detailed tables (a.k.a. "base tables"). Please send any comments you have via email to: We will keep users aware of any updates via the ACS Alert from the ACS website.

The 2006, 2007, and 2005-2007 ACS 3-Year data products include the Group Quarters (GQ) population. The GQ population includes all people not living in households. ACS data were collected from residents who were currently residing in the GQs when the ACS was conducted at that location. Data are collected at two types of group quarters: institutional, including residences such as correctional facilities, nursing homes, and psychiatric hospitals; and non-institutional, which include residences such as college dormitories, military barracks, group homes, and shelters.

Every table labeled a "total population" table will include the GQ population. However, tables describing household characteristics will not include GQ data. For example, tables such as Median Household Income, will only have data from the population living in households.

The ACS-SF contains sample data, which is information about the characteristics of local communities compiled from the questions asked of a sample of people and housing units. The ACS covers a broad spectrum of geographic areas in the United States and Puerto Rico. The topics listed below are covered by the ACS and focus on demographic, social, housing, and economic characteristics.

Sex Age
Households by type Race
Relationship Hispanic origin
School enrollment Educational attainment
Fertility Residence one year ago
Veteran status Disability status
U.S. citizenship status Language spoken at home
Martial status Place of birth
Year of entry Ancestry
Grandparents caring for children World region of birth of foreign born
Employment status Commuting to work
Class of worker Income and benefits
Industry Occupation
Poverty status  
Housing occupancy Housing tenure
Units in structure Year structure built
Number of rooms Number of bedrooms
House heating fuel Housing value
Occupants per room Vehicles available
Mortgage status and costs Utility cost
Year householder moved into unit Gross rent

The Census Bureau uses the data collected by the ACS to create estimates and variances, which are termed statistics, for these characteristics. The statistics produced from the ACS describe the characteristics of population and housing in the United States and Puerto Rico. The ACS releases statistics in several forms - totals, proportions, percentages, means, medians, averages, and ratios. There are three sets of data files in identical format with one field per estimate. One file contains the estimates, the second file contains the standard errors, and the third file contains the margin of error.

The ACS-SF contains a total of 1369 unique detailed tables. Of these tables, ID's beginning with the letter "C" are collapsed versions of tables (i.e. these tables have fewer detailed cells). These detailed tables include both U.S. and Puerto Rico population and housing characteristics for the housing unit population and for a limited list of race and Hispanic or Latino groups. Population and housing items may be cross tabulated. Selected aggregates and medians are also provided. A complete listing of subjects in this file is found in the section, "Subject Locator".

1.6. Geographic Content
The ACS Production Summary file includes all detailed tables for all geographic areas published by the 2005-2007 ACS. The main directory of the ACS-Summary File's FTP server ( contains documentation on using the ACS-SF and 53 subdirectories, for the United States, the 50 states, the District of Columbia, and Puerto Rico. The file structures are identical for all files, but the geographic coverage differs.

This abstract lists the most frequently accessed geographic levels. The "Summary Level Sequence Chart" section outlines the hierarchical and inventory geographic summaries in their entirety. Two summary level sequence charts are provided: one for the state files and one for the final national file.

1.6.1. State Files
ACS-SF for states also has inventory (complete) summaries for the following geographic areas:
  • State
  • County
  • County subdivision
  • Place
  • Congressional district (110th Congress)
  • Public Use Microdata Area (PUMA)
  • School Districts
  • Alaska Native Regional Corporation

1.6.2. National Files
The ACS-SF national file provides summary data for the entire United States. The file structure includes, but is not limited to, the following geographic entities:
  • United States
  • Region
  • Division
  • State
  • County
  • County subdivision
  • Place
  • Metropolitan statistical area
  • Combined statistical area
  • New England City and Town Area (NECTA)
  • Urban area
  • Congressional district (110th Congress)
  • Public Use Microdata Area (PUMA)

1.7. Document Overview
A brief summary of the chapters in the documentation is listed below:

  1. Chapter 1: Abstract contains an overview of the American Community Survey (ACS) and how to use the ACS Summary File technical documentation.
  2. Chapter 2: How to Use the Summary File gives users the background information on the data tables. It also describes the naming conventions on the table names, and it gives a brief summary of the geographies.
  3. Chapter 3: Subject Locator is an index designed to help users quickly identify the tables in the summary file. This index is arranged in alphabetical order by the name of a subject.
  4. Chapter 4: Summary Level Sequence Chart has a detailed list on the geographies and their summary level. The summary level is a three-character code that the ACS uses for identifications on geographies. The summary level is used in the production of the ACS data.
  5. Chapter 5: List of Detailed Tables contains information on the file identification, the tables identification number, title of the table, how many cells are the table, the start position for the table, and the sequence numbers.
  6. Chapter 6: Accuracy of the Data provides data users with a basic understanding of the sample design, estimation methodology, and accuracy of the data.
  7. Chapter 7: User Updates informs data users about corrections, errata, and related information. Users can find unique characteristics, changes, or corrections associated with the data. American Community Survey Notes and Errata, which contain user updates for individual files, are located on

    Additional reference materials can be found in the appendices of this document: A. Appendix A contains information on American Community Survey geographic terms and concepts.

    B. Appendix B links to the subject definitions on the ACS Website.
    C. Appendix C gives an overview on American Community Survey's collection methods and procedures. Data Collection and Processing Procedures are located in Appendix C.
    D. Appendix D links to the ACS questionnaire on the website.
    E. Appendix E links to data products and user assistance.
    F. Appendix F links to maps of areas published by the 2007 ACS for the "nation", "counties and places", "PUMAs", "Core Based Statistical Areas", and "the 110th Congressional District".
    G. Appendix G links to ACS code lists for "Ancestry", "Hispanic Origin", "Industry", "Language", "Occupation", "Place of Birth, Migration, and Place of Work", "Race", and "State". Also included is the GQ Code List.
    H. Appendix H consists of the document "Examples of Standard Error Calculations" which contains examples based on the real data to demonstrate the use of the formulas referenced in the Accuracy of the Data Document in Chapter 7.
    I. Appendix I links to FTP documentation, including the ReadMe file and sample SAS programs.
    J. Additional User Notes are located in Appendix J.
1.8. User Updates
The section on User Updates informs data users about corrections, errata, and related explanatory information. These updates provide information about unique characteristics, changes, or corrections. However, sometimes this information becomes available too late to be reflected in the tables or related documentation. American Community Survey user updates are available on the Census Bureau's Internet site at

Users also can register to receive user updates by e-mail by contacting Customer Services Center, Marketing Services Office, U.S. Census Bureau on 301-763-INFO (