Documentation: ACS 2009 (1-Year Estimates)
you are here: choose a survey survey document chapter
Publisher: U.S. Census Bureau
Document: ACS 2009-1yr Summary File: Technical Documentation
citation:
Social Explorer; U.S. Census Bureau; American Community Survey 2009 Summary File: Technical Documentation.
ACS 2009-1yr Summary File: Technical Documentation
Chapter 2. How to Use the ACS Summary File
2.1. Introduction
This chapter is intended to provide a guide for data users to the American Community Survey Summary Files. New users should review this chapter before attempting to use the Summary File product.

2.2. Data Format
The American Community Survey Summary Files (ACS-SF) are available in .zip file format. The Zip file format is a compressed format used to reduce the file size. Users can download the .zip files through the File Transfer Protocol (FTP) from the American Community Survey FTP site located at: http://www2.census.gov/acs2009_1yr/summaryfile/. To read the Summary Files data, the compressed files must be uncompressed (unzipped) to allow access to the data.

2.3. New Organization of ACS Summary Files
Based on user feedback, the ACS Summary File is now organized into three categories



1. Entire_SF: This zip file contains all of the Summary File data, MOE's, and geography files - 1 File in Directory /acs2009_1yr/summaryfile/Entire_SF/20091YRSF.zip



For the user' s convenience, this zip file contains all of the Summary Files for the U.S., Puerto Rico, states, and District of Columbia. For example, to obtain all Summary Files for nation (U.S.), states, District of Columbia, and Puerto Rico, just download and unzip the file 20091YRSF.zip.

2. Entire_States: These files contain all of the summary file data, MOE's, and geography files per state - 53 Files in Directory (50 States, 1 US, DC, PR) /acs2009_1yr/summaryfile/Entire_States/.zip



This directory contains 53 zip files that include the United States, each of the 50 states, District of Columbia, and Puerto Rico. Each zip file contains 176 estimate files, 176 Margin of Error files, and 1 geography file. See partial contents of the zip file for Alabama below.



3. Seq_By_ST: 53 directories with 176 Compressed Sequence Files (both Estimates & MOE's) and 1 Geography file in each directory /acs2009_1yr/summaryfile/Seq_By_ST//.zip



Each directory contains 176 zip files and 1 geography file. Each zip file containing 1 estimate and 1 Margin of Error file. See a partial view of the AK directory below:



2.4. File Naming Conventions
The naming convention used for the Summary Files provides a hierarchy to allow for easier navigation to the desired information. Figures 2.1 and 2.2 provide an overview of the summary file naming convention.



  • t = type of data (e=estimate, m=margin of error, s=standard error)
  • yyyy = reference year for the data, e.g., 2009
  • p = period covered by the file (1=1-year, 3=3-year, 5=5-year)
  • gg = geographic area (state or US) covered by the file; 'PR' for the Puerto Rico Community Survey
  • ssss = file sequence number (valid range is 0001 through 9999)

Each sequence number will correspond to a series of detailed tables. Each record of this file will be for a unique geographic area published by the ACS. All the data cells contained in the detailed tables for that geographic area would be on this record. There will be a file for the estimates and a separate one for the standard errors.

  • iter = ' 000, placeholder for future values for iteration
  • r = data revision indicator, only present if needed. 'a' , 'b' , etc



  • t = type of data (g= geographic header file)
  • yyyy = reference year for the data, e.g., 2009
  • p = period covered by the file (1=1-year, 3=3-year, 5=5-year)
  • gg = geographic area is represented by 2 digit FIPS state code


2.5. Reading the Geographic File
The geographic file layout is below (Table 2.1). The geographic file provides the reference name, field description, field size, field starting position, and geographic summary levels that apply. The information pertaining to summary level identifies additional geographic information. Each record of the geographic file contains particular geographic area codes. For example, the reference name "PLACE" only contains information for summary levels 160 - State-Place, 312 - Metropolitan Statistical Area/Micropolitan Statistical Area-State-Principal City and 352 - New England City and Town Area-State-Principal City. For more detail on geographic definitions, see "Appendix A. Geographic Terms and Concepts".

Table 2.1 Geographic Header Record Layout for the ACS Summary File

Data Dictionary Reference Name Description Field Size Starting Position Geographic Summary Levels For Single-Year Tables
RECORD CODES        
FILEID Always equal to ACS Summary File identification 6 1 All Summary Levels
STUSAB State Postal Abbreviation 2 7 All Summary Levels
SUMLEVEL Summary Level 3 9 All Summary Levels
COMPONENT Geographic Component 2 12 All Summary Levels
LOGRECNO Logical Record Number 7 14 All Summary Levels
GEOGRAPHIC AREA CODES        
US US 1 21 010
REGION Census Region 1 22 020
DIVISION Census Division 1 23 030
STATECE State (Census Code) 2 24 Blank for All Summary Levels
STATE State (FIPS Code) 2 26 040, 050, 060,160, 230, 312, 352, 500, 795, 950, 960, 970, M01, M06, M07, M08, M11, M15, P01, P06, P07, P08, P11, P15
COUNTY County of current residence 3 28 050, 060, M01, M08, P01, P08
COUSUB County Subdivision (FIPS) 5 31 060, M08, P08
PLACE Place (FIPS Code) 5 36 160, 312, 352, M07, M11, M15, P07, P11, P15
BLANK   6 41 Reserved for future use
BLANK   1 47 Reserved for future use
BLANK   5 48 Reserved for future use
AIANHH American Indian Area/Alaska Native Area/ Hawaiian Home Land (Census) 4 53 250
AIANHHFP American Indian Area/Alaska Native Area/ Hawaiian Home Land (FIPS) 5 57 250
BLANK   1 62 Reserved for future use
BLANK   3 63 Reserved for future use
BLANK   5 66 Reserved for future use
ANRC Alaska Native Regional Corporation (FIPS) 5 71 230
CBSA Metropolitan and Micropolitan Statistical Area 5 76 310, 312, 314, 332, M10, M11, M12, P10, P11, P12
CSA Combined Statistical Area 3 81 330, M09, P09
METDIV Metropolitan Statistical Area-Metropolitan Division 5 84 314, M12, P12
MACC Metropolitan Area Central City 1 89  
MEMI Metropolitan/Micropolitan Indicator Flag 1 90 010, 020, 030, 040, 314
NECTA New England City and Town Area 5 91 350, 352, 355, M14, M15, M16, P14, P15, P16
CNECTA New England City and Town Combined Statistical Area 3 96 335, M13, P13
NECTADIV New England City and Town Area Division 5 99 355, M16, P16
UA Urban Area 5 104 400
BLANK   5 109 Reserved for future use
CDCURR Current Congressional District *** 2 114 500
BLANK   3 116 Reserved for future use
BLANK   3 119 Reserved for future use
BLANK   6 122 Reserved for future use
BLANK   3 128 Reserved for future use
BLANK   5 131 Reserved for future use
SUBMCD   5 136 Reserved for future use
SDELM State-School District (Elementary) 5 141 950
SDSEC State-School District (Secondary) 5 146 960
SDUNI State-School District (Unified) 5 151 970
UR Urban/Rural 1 156 010, 020, 030, 040
PCI Principal City Indicator 1 157 010, 020, 030, 040, 312, 352
BLANK   6 158 Reserved for future use
BLANK   5 164 Reserved for future use
PUMA5 Public Use Microdata Area - 5% File 5 169 795
BLANK   5 174 Reserved for future use
GEOID Geographic Identifier 40 179 All Summary Levels
NAME Area Name 200 219 All Summary Levels


The Geographic Summary Levels labeled as "Reserved for future use" will be used for the ACS period estimate data products.

2.6. Identification Fields within Summary File
The first six columns of the estimates and margin of error files provide data and geographic information related to the tables contained within the same row.

  • FILEID = File Identification - 6 characters
  • FILETYPE= File Type - 6 characters
  • STUSAB = State/U.S.-Abbreviation (USPS) - 2 characters
  • CHARITER= Character Iteration - 3 characters
  • SEQUENCE= Sequence Number - 4 characters
  • LOGRECNO= Logical Record Number - 7 characters

A logical unique record number is assigned to all files for a specific geographic entity so that all records for a specific entity can be linked together across files. Besides the logical record number, other identifying fields are also carried over from the geographic header file to the table files. For more details on these fields, see the example below.



2.7. Sequence Rules and Table ID
There are a few simple rules that are followed in the organization of tables into sequences in the ACS Summary File.

There are never more than 245 cells in a sequence. Tables are grouped into sequences according to their subject area.

Tables from different subject areas are not combined into the same sequence. Tables are grouped together when they share a collapsing arrangement. (Group B & C tables in same sequence.) For example, tables B02003 and C02003 should be in the same sequence. Place of Work (POW) tables are not grouped together with Place of Residence (POR) tables.

The data from the American Community Survey contain approximately 75 detailed tables that have different table layouts for the Puerto Rico Community Survey. The United States tables are limited to geographic areas within the United States that includes all 50 states plus the District of Columbia. The Puerto Rico tables are limited to areas within Puerto Rico. Separation of files between US and Puerto Rico was made because the comparable tables may have a different number of cells (such as C06001 with 45 cells and C06001PR with 37 cells). To identify what tables are available for Puerto Rico only look for the "PR" suffix in the table id (e.g. C06001PR). For more information on PR only sequences that are counterparts to states-only sequences, please reference the following table.

US/State-only Sequences - Missing PR Data PR Only Sequences - Missing US/State Data
1 (US) 167 (PR)
2 (US) 168 (PR)
23 (US) 169 (PR)
24 (US) 170 (PR)
28 (US) 171 (PR)
29 (US) 172 (PR)
30 (US) 173 (PR)
31 (US) 174 (PR)
32 (US) 175 (PR)
165 (US) 176 (PR)


Sequences 126-143 contain 6 large median tables with 499 cells. Due to the size restriction on the sequences (no more than 245 cells), each of the tables is broken down into 3 sequences. These tables are only produced for the U.S. Please reference the following table for more details.

US Only Sequences US Only Tables
126 B24121
127 B24121
128 B24121
129 B24122
130 B24122
131 B24122
132 B24123
133 B24123
134 B24123
135 B24124
136 B24124
137 B24124
138 B24125
139 B24125
140 B24125
141 B24126
142 B24126
143 B24126