Skip Main Navigation Skip To Navigation Content

American Community Survey

Census.govAmerican Community Survey › Data & Documentation: Summary File
Skip top of page navigation

Summary File

The American Community Survey (ACS) Summary File is a set of comma-delimited text files that contain all of the Detailed Tables for the ACS 1-year, 3-year, and 5-year data releases.

The Detailed Tables are stored in a series of files with only the data from the tables and without such information as the table title, description of the rows, or geographic identifiers. That information is located in other files that the user must merge with the data files to reproduce full tables.

Starting with the 2009-2013 ACS 5-year data release, block groups, the lowest level of geography published by the ACS, are available in American FactFinder. For earlier years, block groups are available only in the ACS 5-year Summary File.

Summary File Data and Documentation

2013 ACS 1-year Estimates 2011-2013 ACS 3-year Estimates 2009-2013 ACS 5-year Estimates

Data
Contains estimate, margin of error, and geography files for each release
1-Year Summary File 3-Year Summary File 5-Year Summary File

Templates
Includes description of variables in each column for all sequence files and geography file
1-year Templates [ZIP 1.8 MB] 3-year Templates [ZIP 1.7 MB] 5-year Templates [ZIP xx MB]

Technical Document
Core tech doc contains information about how to use the ACS Summary File
2013 Core Tech Doc [PDF 1.0 MB]
Instructions on How to Read the ACS Summary File into Excel [PDF 762 KB]
Instructions on Joining the ACS Summary File to TIGER/Line Shapefiles [PDF 211 KB]

Appendices include the sequence number and restrictions for all tables, as well as summary levels available for each release
1-year Appendices [XLS 302 KB] 3-year Appendices [XLS 292 KB] 5-year Appendices [XLS 268 KB]

Summary File User Tools

Summary File Retrieval Tool
Excel Macro tool ideal for downloading 20 tables or less for all published geographies within a state
Retrieval Tool [ZIP 10 MB]
Users Guide [PDF 854 KB]
Video: Block Group Data Using the Summary File Retrieval Tool on YouTube.

Table Shells
Contains table ID, line number, unique ID (table ID + Line Number), stub, and data release
Table Shells [XLS 1.9 MB]

Sequence Number/Table Number Lookup File
Contains information on the relationship between the sequences and the tables
1-year Lookup File 3-year Lookup File 5-year Lookup File
SAS format [sas7bdat 9.7 MB] SAS format [sas7bdat 9.5 MB] SAS format [sas7bdat 6.8 MB]
Excel format [XLS 5.0 MB] Excel format [XLS 4.9 MB] Excel format [XLS 2.7 MB]
Text format [TXT 2.0 MB] Text format [TXT 1.4 MB]

SAS Programs
Contains SAS programs for each sequence per state, which can be used to convert each estimate and margin of error into SAS Datasets with table stubs
1-year SAS programs [ZIP 42 MB] 3-year SAS programs [ZIP 42 MB] 5-year SAS programs

Example of Creating a Table Using SAS [PDF 65 KB]

Detailed example SAS program containing SAS macros which access the geography, estimate and margin of error data. It creates one table for all geographies from the ACS Summary File. Segments of the SAS codes can be used to convert geography files into SAS datasets
1-year Macros [SAS 12 KB] 3-year Macros [SAS 12 KB] 5-year Macros

Summary File Data and Documentation

2012 ACS 1-Year Estimates

2010-2012 ACS 3-Year Estimates

2008-2012 ACS 5-Year Estimates

Tools for using the ACS Summary File

  • Summary File Retrieval Tool [ZIP 9.8MB] - an Excel Macro tool ideal for downloading 20 tables or less for all published geographies within a state.
  • DVD Set – The entire ACS 5-year Summary File is available in comma delimited text format on a set of DVDs.
    • Email your name and mailing address and specify dataset (2008-2012) to acso.dvd.order@census.gov to request a DVD set. You may be contacted for additional information before your request is filled.
    • The DVDs include technical documentation and all 5-year estimates for all geographic areas down to the block group
  • DataFerrett – a web application that can be used to analyze and download a large number of tables for up to 67,000 geographic areas at a time.
  • Other Tools - such as SAS programs and Excel templates are available on the FTP site in the User Tools folder

Summary File Data and Documentation

2011 ACS 1-Year Estimates

2009-2011 ACS 3-Year Estimates

2007-2011 ACS 5-Year Estimates

Tools for using the ACS Summary File

  • Summary File Retrieval Tool [ZIP 8.9MB] - an Excel Macro tool ideal for downloading 20 tables or less for all published geographies within a state.
  • DVD Set – The entire ACS 5-year Summary File is available in comma delimited text format on a set of DVDs.
    • Email your name and mailing address and specify dataset (2007-2011) to acso.dvd.order@census.gov to request a DVD set. You may be contacted for additional information before your request is filled.
    • The DVDs include technical documentation and all 5-year estimates for all geographic areas down to the block group
  • DataFerrett – a web application that can be used to analyze and download a large number of tables for up to 67,000 geographic areas at a time.
  • Other Tools - such as SAS programs and Excel templates are available on the FTP site in the User Tools folder

Summary File Data and Documentation

2010 ACS 1-Year Estimates

2008-2010 ACS 3-Year Estimates

2006-2010 ACS 5-Year Estimates

Special Data Release - 2006-2010 ACS 5-Year Special Population and AIAN Tables

Tools for using the ACS Summary File


Note: These tools do not work with the Selected Population Tables Summary File and the American Indian and Alaska Native Tables Summary File

  • Summary File Retrieval Tool [ZIP 8.9MB] - an Excel Macro tool ideal for downloading 20 tables or less for all published geographies within a state.
  • DVD Set – The entire ACS 5-year Summary File is available in comma delimited text format on a set of DVDs.
    • Email your name and mailing address and specify dataset (2006-2010) to acso.dvd.order@census.gov to request a DVD set. You may be contacted for additional information before your request is filled.
    • The DVDs include technical documentation and all 5-year estimates for all geographic areas down to the block group.
  • DataFerrett – a web application that can be used to analyze and download a large number of tables for up to 67,000 geographic areas at a time.
  • Other Tools - such as SAS programs and Excel templates are available on the FTP site in the User Tools folder

Summary File Data and Documentation

2009 ACS 1-Year Estimates

2007-2009 ACS 3-Year Estimates

2005-2009 ACS 5-Year Estimates

New this year — 5-year Summary File

  • Includes first-ever block group data from the ACS (only available on the Summary File).
  • Includes all of the Detailed Tables published on the Census Bureau’s American FactFinder.
  • Includes an additional 295 Detailed Tables* not available on American FactFinder.

*Download the list of detailed tables [XLS 71KB] not available on American FactFinder or

Detailed tables not available on American FactFinder

Table NumberTable Title
B04004People Reporting Single Ancestry
B04005People Reporting Multiple Ancestry
B05003ASex By Age By Citizenship Status (White Alone)
B05003BSex By Age By Citizenship Status (Black Or African American Alone)
B05003CSex By Age By Citizenship Status (American Indian And Alaska Native Alone)
B05003DSex By Age By Citizenship Status (Asian Alone)
B05003ESex By Age By Citizenship Status (Native Hawaiian And Other Pacific Islander Alone)
B05003FSex By Age By Citizenship Status (Some Other Race Alone)
B05003GSex By Age By Citizenship Status (Two Or More Races)
B05003HSex By Age By Citizenship Status (White Alone Not Hispanic Or Latino)
B05003ISex By Age By Citizenship Status (Hispanic Or Latino)
B05004Median Age By Citizenship Status By Sex
B05008Sex By Place Of Birth By Year Of Entry For The Foreign Born Population
B05009Age And Nativity Of Own Children Under 18 Years In Families And Subfamilies By Number And Nativity Of Parents
B05010Ratio Of Income To Poverty Level In The Past 12 Months By Nativity Of Children Under 18 Years In Families And Subfamilies By Living Arrangements And Nativity Of Parents
B06001Place Of Birth By Age In The United States
B06001PRPlace Of Birth By Age In Puerto Rico
B06002Median Age By Place Of Birth In The United States
B06002PRMedian Age By Place Of Birth In Puerto Rico
B06007Place Of Birth By Language Spoken At Home And Ability To Speak English In The United States
B06007PRPlace Of Birth By Language Spoken At Home And Ability To Speak English In Puerto Rico
B06008Place Of Birth By Marital Status In The United States
B06008PRPlace Of Birth By Marital Status In Puerto Rico
B06009Place Of Birth By Educational Attainment In The United States
B06009PRPlace Of Birth By Educational Attainment In Puerto Rico
B06010Place Of Birth By Individual Income In The Past 12 Months In The United States
B06010PRPlace Of Birth By Individual Income In The Past 12 Months In Puerto Rico
B06011Median Income In The Past 12 Months By Place Of Birth In The United States
B06011PRMedian Income In The Past 12 Months By Place Of Birth In Puerto Rico
B07001Geographical Mobility In The Past Year By Age For Current Residence In The United States
B07001PRGeographical Mobility In The Past Year By Age For Current Residence In Puerto Rico
B07002Median Age By Geographical Mobility In The Past Year For Current Residence In The United States
B07002PRMedian Age By Geographical Mobility In The Past Year For Current Residence In Puerto Rico
B07007Geographical Mobility In The Past Year By Citizenship Status For Current Residence In The United States
B07007PRGeographical Mobility In The Past Year By Citizenship Status For Current Residence In Puerto Rico
B07008Geographical Mobility In The Past Year By Marital Status For Current Residence In The United States
B07008PRGeographical Mobility In The Past Year By Marital Status For Current Residence In Puerto Rico
B07009Geographical Mobility In The Past Year By Educational Attainment For Current Residence In The United States
B07009PRGeographical Mobility In The Past Year By Educational Attainment For Current Residence In Puerto Rico
B07010Geographical Mobility In The Past Year By Individual Income In The Past 12 Months For Current Residence In The United States
B07010PRGeographical Mobility In The Past Year By Individual Income In The Past 12 Months For Current Residence In Puerto Rico
B07011Median Income In The Past 12 Months By Geographical Mobility In The Past Year For Current Residence In The United States
B07011PRMedian Income In The Past 12 Months By Geographical Mobility In The Past Year For Current Residence In Puerto Rico
B07012Geographical Mobility In The Past Year By Poverty Status In The Past 12 Months For Current Residence In The United States
B07012PRGeographical Mobility In The Past Year By Poverty Status In The Past 12 Months For Current Residence In Puerto Rico
B07013Geographical Mobility In The Past Year By Tenure For Current Residence In The United States
B07013PRGeographical Mobility In The Past Year By Tenure For Current Residence In Puerto Rico
B07101Movers Between Regions In The United States
B07401Geographical Mobility In The Past Year By Age For Residence 1 Year Ago In The United States
B07401PRGeographical Mobility In The Past Year By Age For Residence 1 Year Ago In Puerto Rico
B07402Median Age By Geographical Mobility In The Past Year For Residence 1 Year Ago In The United States
B07402PRMedian Age By Geographical Mobility In The Past Year For Residence 1 Year Ago In Puerto Rico
B07403Geographical Mobility In The Past Year By Sex For Residence 1 Year Ago In The United States
B07403PRGeographical Mobility In The Past Year By Sex For Residence 1 Year Ago In Puerto Rico
B07404AGeographical Mobility In The Past Year By Race (White Alone) For Residence 1 Year Ago In The United States
B07404APRGeographical Mobility In The Past Year By Race (White Alone) For Residence 1 Year Ago In Puerto Rico
B07404BGeographical Mobility In The Past Year By Race (Black Or African American Alone) For Residence 1 Year Ago In The United States
B07404BPRGeographical Mobility In The Past Year By Race (Black Or African American Alone) For Residence 1 Year Ago In Puerto Rico
B07404CGeographical Mobility In The Past Year By Race (American Indian And Alaska Native Alone) For Residence 1 Year Ago In The United States
B07404CPRGeographical Mobility In The Past Year By Race (American Indian And Alaska Native Alone) For Residence 1 Year Ago In Puerto Rico
B07404DGeographical Mobility In The Past Year By Race (Asian Alone) For Residence 1 Year Ago In The United States
B07404DPRGeographical Mobility In The Past Year By Race (Asian Alone) For Residence 1 Year Ago In Puerto Rico
B07404EGeographical Mobility In The Past Year By Race (Native Hawaiian And Other Pacific Islander Alone) For Residence 1 Year Ago In The United States
B07404EPRGeographical Mobility In The Past Year By Race (Native Hawaiian And Other Pacific Islander Alone) For Residence 1 Year Ago In Puerto Rico
B07404FGeographical Mobility In The Past Year By Race (Some Other Race Alone) For Residence 1 Year Ago In The United States
B07404FPRGeographical Mobility In The Past Year By Race (Some Other Race Alone) For Residence 1 Year Ago In Puerto Rico
B07404GGeographical Mobility In The Past Year By Race (Two Or More Races) For Residence 1 Year Ago In The United States
B07404GPRGeographical Mobility In The Past Year By Race (Two Or More Races) For Residence 1 Year Ago In Puerto Rico
B07404HGeographical Mobility In The Past Year By Race (White Alone Not Hispanic Or Latino) For Residence 1 Year Ago In The United States
B07404HPRGeographical Mobility In The Past Year By Race (White Alone Not Hispanic Or Latino) For Residence 1 Year Ago In Puerto Rico
B07404IGeographical Mobility In The Past Year By Race (Hispanic Or Latino) For Residence 1 Year Ago In The United States
B07404IPRGeographical Mobility In The Past Year By Race (Hispanic Or Latino) For Residence 1 Year Ago In Puerto Rico
B07407Geographical Mobility In The Past Year By Citizenship Status For Residence 1 Year Ago In The United States
B07407PRGeographical Mobility In The Past Year By Citizenship Status For Residence 1 Year Ago In Puerto Rico
B07408Geographical Mobility In The Past Year By Marital Status For Residence 1 Year Ago In The United States
B07408PRGeographical Mobility In The Past Year By Marital Status For Residence 1 Year Ago In Puerto Rico
B07409Geographical Mobility In The Past Year By Educational Attainment For Residence 1 Year Ago In The United States
B07409PRGeographical Mobility In The Past Year By Educational Attainment For Residence 1 Year Ago In Puerto Rico
B07410Geographical Mobility In The Past Year By Individual Income In The Past 12 Months For Residence 1 Year Ago In The United States
B07410PRGeographical Mobility In The Past Year By Individual Income In The Past 12 Months For Residence 1 Year Ago In Puerto Rico
B07411Median Income In The Past 12 Months By Geographical Mobility In The Past Year For Residence 1 Year Ago In The United States
B07411PRMedian Income In The Past 12 Months By Geographical Mobility In The Past Year For Residence 1 Year Ago In Puerto Rico
B07412Geographical Mobility In The Past Year By Poverty Status In The Past 12 Months For Residence 1 Year Ago In The United States
B07412PRGeographical Mobility In The Past Year By Poverty Status In The Past 12 Months For Residence 1 Year Ago In Puerto Rico
B07413Geographical Mobility In The Past Year By Tenure For Residence 1 Year Ago In The United States
B07413PRGeographical Mobility In The Past Year By Tenure For Residence 1 Year Ago In Puerto Rico
B08006Sex Of Workers By Means Of Transportation To Work
B08011Sex Of Workers By Time Leaving Home To Go To Work
B08012Sex Of Workers By Travel Time To Work
B08014Sex Of Workers By Vehicles Available
B08015Aggregate Number Of Vehicles Used In Commuting By Workers 16 Years And Over By Sex
B08101Means Of Transportation To Work By Age
B08103Median Age By Means Of Transportation To Work
B08111Means Of Transportation To Work By Citizenship Status
B08113Means Of Transportation To Work By Language Spoken At Home And Ability To Speak English
B08121Median Earnings In The Past 12 Months By Means Of Transportation To Work
B08122Means Of Transportation To Work By Poverty Status In The Past 12 Months
B08124Means Of Transportation To Work By Occupation
B08126Means Of Transportation To Work By Industry
B08128Means Of Transportation To Work By Class Of Worker
B08131Aggregate Travel Time To Work Of Workers By Place Of Work-State And County Level
B08133Aggregate Travel Time To Work Of Workers By Time Leaving Home To Go To Work
B08137Means Of Transportation To Work By Tenure
B08201Household Size By Vehicles Available
B08202Household Size By Number Of Workers In Household
B08203Number Of Workers In Household By Vehicles Available
B08412Sex Of Workers By Travel Time To Work For Workplace Geography
B08503Median Age By Means Of Transportation To Work For Workplace Geography
B08505AMeans Of Transportation To Work For Workplace Geography (White Alone)
B08505BMeans Of Transportation To Work For Workplace Geography (Black Or African American Alone)
B08505CMeans Of Transportation To Work For Workplace Geography (American Indian And Alaska Native Alone)
B08505DMeans Of Transportation To Work For Workplace Geography (Asian Alone)
B08505EMeans Of Transportation To Work For Workplace Geography (Native Hawaiian And Other Pacific Islander Alone)
B08505FMeans Of Transportation To Work For Workplace Geography (Some Other Race Alone)
B08505GMeans Of Transportation To Work For Workplace Geography (Two Or More Races)
B08505HMeans Of Transportation To Work For Workplace Geography (White Alone Not Hispanic Or Latino)
B08505IMeans Of Transportation To Work For Workplace Geography (Hispanic Or Latino)
B08511Means Of Transportation To Work By Citizenship Status For Workplace Geography
B08513Means Of Transportation To Work By Language Spoken At Home And Ability To Speak English For Workplace Geography
B08521Median Earnings In The Past 12 Months By Means Of Transportation To Work For Workplace Geography
B08522Means Of Transportation To Work By Poverty Status In The Past 12 Months For Workplace Geography
B08528Means Of Transportation To Work By Class Of Worker For Workplace Geography
B08536Aggregate Travel Time To Work Of Workers By Means Of Transportation To Work For Workplace Geography
B08537Means Of Transportation To Work By Tenure For Workplace Geography
B08601Means Of Transportation To Work For Workplace Geography
B08602Time Arriving At Work From Home For Workplace Geography
B08603Travel Time To Work For Workplace Geography
B09008Presence Of Unmarried Partner Of Householder By Household Type For Children Under 18 Years
B09010Receipt Of Supplemental Security Income, Cash Public Assistance, Or Food Stamps In The Past 12 Months By Household Type For Children Under 18 Years In Households
B10001Grandchildren Under 18 Years Living With A Grandparent Householder By Age Of Child
B10002Grandchildren Under 18 Years Living With A Grandparent Householder By Grandparent Responsibility And Presence Of Parent
B10010Median Family Income For Families With Grandparent Householders And/Or Spouses Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Presence Of Parent Of Grandchildren
B10051Grandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren By Presence Of Parent Of Grandchildren And Age Of Grandparent
B10051AGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (White Alone)
B10051BGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Black Or African American Alone)
B10051CGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (American Indian And Alaska Native Alone)
B10051DGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Asian Alone)
B10051EGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Native Hawaiian And Other Pacific Islander Alone)
B10051FGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Some Other Race Alone)
B10051GGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Two Or More Races)
B10051HGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (White Alone Not Hispanic Or Latino)
B10051IGrandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent (Hispanic Or Latino)
B10053Citizenship Status By Grandparents Responsible For Own Grandchildren Under 18 Years By Age Of Grandparent
B10054Language And Ability To Speak English Of Grandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent
B10058Employment Status Of Grandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent
B10059Poverty Status In The Past 12 Months Of Grandparents Living With Own Grandchildren Under 18 Years By Responsibilityf For Own Grandchildren And Age Of Grandparent
B10060Units In Structure Of Grandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent
B10061Tenure Of Grandparents Living With Own Grandchildren Under 18 Years By Responsibility For Own Grandchildren And Age Of Grandparent
B10063Households With Grandparents Living With Own Grandchildren Uder 18 Years By Responsibility For Own Grandchildren And Presence Of Parent Of Grandchildren
B11011Household Type By Units In Structure
B12002ASex By Marital Status For The Population 15 Years And Over (White Alone)
B12002BSex By Marital Status For The Population 15 Years And Over (Black Or African American Alone)
B12002CSex By Marital Status For The Population 15 Years And Over (American Indian And Alaska Native Alone)
B12002DSex By Marital Status For The Population 15 Years And Over (Asian Alone)
B12002ESex By Marital Status For The Population 15 Years And Over (Native Hawaiian And Other Pacific Islander Alone)
B12002FSex By Marital Status For The Population 15 Years And Over (Some Other Race Alone)
B12002GSex By Marital Status For The Population 15 Years And Over (Two Or More Races)
B12002HSex By Marital Status For The Population 15 Years And Over (White Alone Not Hispanic Or Latino)
B12002ISex By Marital Status For The Population 15 Years And Over (Hispanic Or Latino)
B12005Marital Status By Nativity
B12006Marital Status By Labor Force Participation
B12007Median Age At First Marriage
B12007AMedian Age At First Marriage (White Alone)
B12007BMedian Age At First Marriage (Black Or African American Alone)
B12007CMedian Age At First Marriage (American Indian And Alaska Native Alone)
B12007DMedian Age At First Marriage (Asian Alone)
B12007EMedian Age At First Marriage (Native Hawaiian And Other Pacific Islander Alone)
B12007FMedian Age At First Marriage (Some Other Race Alone)
B12007GMedian Age At First Marriage (Two Or More Races)
B12007HMedian Age At First Marriage (White Alone Not Hispanic Or Latino)
B12007IMedian Age At First Marriage (Hispanic Or Latino)
B13002AWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (White Alone)
B13002BWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Black Or African American Alone)
B13002CWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (American Indian And Alaska Native Alone)
B13002DWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Asian Alone)
B13002EWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Native Hawaiian And Other Pacific Islander Alone)
B13002FWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Some Other Race Alone)
B13002GWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Two Or More Races)
B13002HWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (White Alone Not Hispanic Or Latino)
B13002IWomen 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status (Hispanic Or Latino)
B13004Women 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status And Presence Of Unmarried Partner
B13008Women 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status And Citizenship Status
B13010Women 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status And Poverty Status In The Past 12 Months
B13012Women 16 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status And Labor Force Status
B13014Women 15 To 50 Years Who Had A Birth In The Past 12 Months By Marital Status And Educational Attainment
B14006Poverty Status In The Past 12 Months By School Enrollment By Level Of School For The Population 3 Years And Over
B16005ANativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (White Alone)
B16005BNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Black Or African American Alone)
B16005CNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (American Indian And Alaska Native Alone)
B16005DNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Asian Alone)
B16005ENativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Native Hawaiian And Other Pacific Islander Alone)
B16005FNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Some Other Race Alone)
B16005GNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Two Or More Races)
B16005HNativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (White Alone Not Hispanic Or Latino)
B16005INativity By Language Spoken At Home By Ability To Speak English For The Population 5 Years And Over (Hispanic Or Latino)
B16007Age By Language Spoken At Home For The Population 5 Years And Over
B16008Citizenship Status By Age By Language Spoken At Home For The Population 5 Years And Over
B16009Poverty Status In The Past 12 Months By Age By Language Spoken At Home For The Population 5 Years And Over
B16010Educational Attainment And Employment Status By Language Spoken At Home For The Population 25 Years And Over
B17003Poverty Status In The Past 12 Months Of Individuals By Sex By Educational Attainment
B17004Poverty Status In The Past 12 Months Of Individuals By Sex By Work Experience
B17005Poverty Status In The Past 12 Months Of Individuals By Sex By Employment Status
B17012Poverty Status In The Past 12 Months Of Families By Household Type By Number Of Related Children Under 18 Years
B17013Poverty Status In The Past 12 Months Of Families By Household Type By Number Of Persons In Family
B17014Poverty Status In The Past 12 Months Of Families By Household Type By Number Of Workers In Family
B17018Poverty Status In The Past 12 Months Of Families By Household Type By Educational Attainment Of The Householder
B17019Poverty Status In The Past 12 Months Of Families By Household Type By Tenure
B17023Poverty Status In The Past 12 Months Of Families By Household Type By Number Of Own Children Under 18 Years
B17026Ratio of Income to Poverty Level of Families In The Past 12 Months
B19019Median Household Income In The Past 12 Months By Household Size
B19058Public Assistance Income Or Food Stamps In The Past 12 Months For Households
B19080Household Income Quintile Upper Limits
B19081Mean Household Income Of Quintiles
B19082Shares Of Aggregate Household Income By Quintile
B19083Gini Index Of Income Inequality
B20004Median Earnings In The Past 12 Months By Sex By Educational Attainment For The Population 25 Years And Over
B21003Veteran Status By Educational Attainment For The Civilian Population 25 Years And Over
B21004Median Income In The Past 12 Months By Veteran Status By Sex For The Civilian Population 18 Years And Over With Income
B21005Age By Veteran Status By Employment Status For The Civilian Population 18 To 64 Years
B22002Receipt Of Food Stamps In The Past 12 Months By Presence Of Children Under 18 Years By Household Type For Households
B22003Receipt Of Food Stamps In The Past 12 Months By Poverty Status In The Past 12 Months For Households
B22005AReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (White Alone)
B22005BReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Black Or African American Alone)
B22005CReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (American Indian And Alaska Native Alone)
B22005DReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Asian Alone)
B22005EReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Native Hawaiian And Other Pacific Islander Alone)
B22005FReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Some Other Race Alone)
B22005GReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Two Or More Races)
B22005HReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (White Alone Not Hispanic Or Latino)
B22005IReceipt Of Food Stamps In The Past 12 Months By Race Of Householder (Hispanic Or Latino)
B22007Receipt Of Food Stamps In The Past 12 Months By Family Type By Number Of Workers In Family In The Past 12 Months
B22008Median Household Income In The Past 12 Months By Receipt Of Food Stamps In The Past 12 Months
B23004Work Status In The Past 12 Months By Age By Employment Status For The Civilian Population 65 Years And Over
B23006Educational Attainment By Employment Status For The Population 25 To 64 Years
B23010Presence Of Own Children Under 18 Years In Married-Couple Families By Work Experience Of Householder And Spouse
B23013Median Age By Sex For Workers 16 To 64 Years
B23018Aggregate Usual Hours Worked In The Past 12 Months By Sex For Workers 16 Years And Over
B23020Mean Usual Hours Worked In The Past 12 Months For Workers 16 To 64 Years
C24010ASex By Occupation For The Civilian Employed Population 16 Years And Over (White Alone)
C24010BSex By Occupation For The Civilian Employed Population 16 Years And Over (Black Or African American Alone)
C24010CSex By Occupation For The Civilian Employed Population 16 Years And Over (American Indian And Alaska Native Alone)
C24010DSex By Occupation For The Civilian Employed Population 16 Years And Over (Asian Alone)
C24010ESex By Occupation For The Civilian Employed Population 16 Years And Over (Native Hawaiian And Other Pacific Islander Alone)
C24010FSex By Occupation For The Civilian Employed Population 16 Years And Over (Some Other Race Alone)
C24010GSex By Occupation For The Civilian Employed Population 16 Years And Over (Two Or More Races)
C24010HSex By Occupation For The Civilian Employed Population 16 Years And Over (White Alone Not Hispanic Or Latino)
C24010ISex By Occupation For The Civilian Employed Population 16 Years And Over (Hispanic Or Latino)
B24011Occupation By Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
B24012Sex By Occupation And Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
C24020Sex By Occupation For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24021Occupation By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24022Sex By Occupation And Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24031Industry By Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
B24032Sex By Industry And Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
C24040Sex By Industry For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24041Industry By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24042Sex By Industry And Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
C24050Industry By Occupation For The Civilian Employed Population 16 Years And Over
C24060Occupation By Class Of Worker For The Civilian Employed Population 16 Years And Over
C24070Industry By Class Of Worker For The Civilian Employed Population 16 Years And Over
B24081Class Of Worker By Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
B24082Sex By Class Of Worker And Median Earnings In The Past 12 Months For The Civilian Employed Population 16 Years And Over
B24090Sex By Class Of Worker For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24091Class Of Worker By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24092Sex By Class Of Worker And Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24121Detailed Occupation By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24122Detailed Occupation By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Male Population 16 Years And Over
B24123Detailed Occupation By Median Earnings In The Past 12 Months For The Full-Time, Year-Round Civilian Employed Female Population 16 Years And Over
B24124Detailed Occupation For The Full-Time, Year-Round Civilian Employed Population 16 Years And Over
B24125Detailed Occupation For The Full-Time, Year-Round Civilian Employed Male Population 16 Years And Over
B24126Detailed Occupation For The Full-Time, Year-Round Civilian Employed Female Population 16 Years And Over
B25005Vacant - Current Residence Eslewhere
B25012Tenure By Families And Presence Of Own Children
B25013Tenure By Educational Attainment Of Householder
B25027Mortgage Status by Age of Householder
B25094Selected Monthly Owner Costs
B25096Mortgage Status By Value
B25097Mortgage Status By Median Value (Dollars)
B25098Mortgage Status By Household Income In The Past 12 Months
B25099Mortgage Status By Median Household Income In The Past 12 Months
B25100Mortgage Status By Ratio Of Value To Household Income In The Past 12 Months
B25101Mortgage Status By Monthly Housing Costs As A Percentage Of Household Income In The Past 12 Months
B25102Mortgage Status By Real Estate Taxes Paid
B25103Mortgage Status By Median Real Estate Taxes Paid
B25104Monthly Housing Costs
B25105Median Monthly Housing Costs
B25106Tenure By Housing Costs As A Percentage Of Household Income In The Past 12 Months
B25107Median Value By Year Structure Built
B25108Aggregate Value By Year Structure Built
B25109Median Value By Year Householder Moved Into Unit
B25110Aggregate Value By Year Householder Moved Into Unit
B25111Median Gross Rent By Year Structure Built
B25112Aggregate Gross Rent By Year Structure Built
B25113Median Gross Rent By Year Householder Moved Into Unit
B25114Aggregate Gross Rent By Year Householder Moved Into Unit

Tools for using the ACS 5-year Summary File

  • Summary File Retrieval Tool [XLS 4.64MB] - an Excel Macro tool ideal for downloading 20 tables or less for all published geographies within a state.
  • DVD Set – The entire ACS 5-year Summary File is available in comma delimited text format on a set of DVDs.
    • Email your name and mailing address and specify dataset (2005-2009) to acso.dvd.order@census.gov to request a DVD set. You may be contacted for additional information before your request is filled.
    • The DVDs include technical documentation and all 5-year estimates for all geographic areas down to the block group.
  • DataFerrett – a web application that can be used to analyze and download a large number of tables for up to 67,000 geographic areas at a time.
  • Other Tools - such as SAS programs and Excel templates are available on the FTP site in the User Tools folder


[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® Off Site available free from Adobe.    [Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer Off Site available for free from Microsoft®.    This symbol Off Site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.

Source: U.S. Census Bureau | American Community Survey Office | Email ACS | Last Revised: November 24, 2014
Give us your feedback on this website!