Social Explorer Logo
Documentation: ACS 2007 (1-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2007-1yr Summary File: Technical Documentation
Social Explorer; U.S. Census Bureau; American Community Survey 2007 Summary File: Technical Documentation.
ACS 2007-1yr Summary File: Technical Documentation
Chapter 1. Abstract
1.1. Citation
U.S. Census Bureau, American Community Survey 2007 Summary File: Technical Documentation.

1.2. Special Notes
  1. Details on changes in the detailed tables and derived products since the 2006 ACS, including new products, is available on the ACS Website at:
  2. Changes to the 2007 detailed tables which contain complete lists of new, removed, and modified tables can be referenced on: Table_Changes2007.xls
  3. Because of added/dropped tables, changes were made to some of the tables in the sequences. Sequences 51 and 146 contain geo-restricted tables, so there are many missing tables in these sequences. Sequences 125-133 contain 3 new large median tables (these tables contain 499 cells). Due to the size restriction on the sequences (no more than 245 cells), each of the tables was broken into 3 sequences. For example, sequence 125 contains B24121 cells 1-167, sequence 126 contains B24121 cells 168-333, and sequence 127 contains B24121 cells 334-499. For more details, see Chapter 5 and review the file.
  4. ACS 2007 detailed tables that were subject to geographic restrictions are located on:
  5. Each set of ACS Summary file Technical Documentation is tied to a specific ACS year. Currently we have five sets of ACS Summary file, 2005 (prototype), 2006 (prototype), 2006 (production), and 2007 (production.).
  6. The ACS 2006 and ACS 2007 Production Summary files were created using the same file naming convention based on user input. 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
1.3.1. Updated Chapters
  • Chapter 1. Abstract
Updates were made to all of the Special Notes and the 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

1.3.2. Updated Appendices
  • 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 2007 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 single-year estimates for geographic areas with populations of 65,000 or more.

This release of the American Community Survey Production Summary file (ACS-SF) contains the 2007 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, and 2007 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 that should be a "total population" table will include the GQ population. But, 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, IDs 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 2006 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:

  1. Appendix A contains information on American Community Survey geographic terms and concepts.
  2. Appendix B links to the subject definitions on the ACS Website.
  3. Appendix C gives an overview on American Community Surveys collection methods and procedures. Data Collection and Processing Procedures are located in Appendix C.
  4. Appendix D links to the ACS questionnaire on the website.
  5. Appendix E links to data products and user assistance.
  6. 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."
  7. 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.
  8. 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.
  9. Appendix I links to FTP documentation, including the ReadMe file and sample SAS programs.
  10. 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 (