U.S. flag

An official website of the United States government

Skip Header

Table IDs Explained

Ever wonder what a table ID represents? The characters may look random at first glance, but each American Community Survey (ACS) table ID is purposefully numbered to describe its content and format.For example, the characters in B06004APR show that the table contains place of birth statistics for the white alone population in Puerto Rico.

ACS table IDs consist of up to five elements. To learn more about the numbering system, drill into each of the following elements below:

Table ID Characters Type of Table Contains
B Detailed Tables Base Table Most detailed estimates on all topics for all geographies
C Collapsed Table Similar information from its corresponding Base Table (B) but at a lower level of detail because one or more lines in the Base Table have been grouped together
Subject Table A span of information on a particular ACS subject, such as veterans, presented in the format of both estimates and percentages
Ranking Table State rankings across approximately 90 key variables
Geographic Comparison Table Comparisons across approximately 95 key variables for geographies other than states such as counties or congressional districts
K20 Supplemental Table Simplified Detailed Tables at a lower population threshold than the standard 1-year tables (all areas with populations of 20,000 or more)
XK Experimental Estimates Experimental estimates, which are different from the standard ACS data releases
Data Profile Broad social, economic, housing, and demographic information in a total of four profiles
Narrative Profile Summaries of information in the Data Profiles using nontechnical text
Comparison Profile Comparisons of ACS estimates over time in the same layout as the Data Profiles
Selected Population Profile Broad ACS statistics for population subgroups by race, ethnicity, ancestry, tribal affiliation, and place of birth

Top of Section

The next 2 characters identify the subject of the table. Profiles (DP, NP, CP, and S0201) cover multiple topics, so they do not have any characters to indicate a subject.

Subject Number Subject Name Subject Number Subject Name
Age; Sex 17
Poverty Status
Race 18
Disability Status
Hispanic or Latino Origin 19
Ancestry 20
Citizenship Status; Year of Entry; Foreign Born Place of Birth 21
Veteran Status; Period of Military Service
Place of Birth 22
Food Stamps/Supplemental Nutrition Assistance Program (SNAP)
Migration/Residence 1 Year Ago 23
Employment Status; Work Status Last Year
Commuting (Journey to Work); Place of Work 24
Industry, Occupation, and Class of Worker
Relationship to Householder 25
Housing Characteristics
Grandparents and Grandchildren Characteristics 26
Group Quarters
Household Type; Family Type; Subfamilies 27
Health Insurance Coverage
Marital Status; Marital History 28
Computer and Internet Use
Fertility 29
Citizen Voting-Age Population
School Enrollment 98
Quality Measures
Educational Attainment; Undergraduate Field of Degree 99
Allocation Table for Any Subject
Language Spoken at Home    

Top of Section

The next 2 or 3 digits are a sequential number, such as 001 or 002, that uniquely identifies the table within a given subject. To find a specific table, download the table list for your year of interest from Table Shells and Table List.

Top of Section

For selected tables, an alphabetic suffix follows to indicate that a table is repeated for the nine major race and Hispanic or Latino groups:

Code Race or Ethnic Group
A White Alone
B Black or African American Alone
C American Indian and Alaska Native Alone
D Asian Alone
E Native Hawaiian and Other Pacific Islander Alone
F Some Other Race Alone
G Two or More Races
H White Alone, Not Hispanic or Latino
I Hispanic or Latino

Top of Section

For selected tables, a final alphabetic suffix "PR" follows to indicate a table is available for Puerto Rico geographies only. These Puerto Rico-specific tables exist because for some geography-based subjects, the wording of the Puerto Rico Community Survey questionnaire differs slightly but significantly from the American Community Survey questionnaire. (For example, the ACS asks "When did this person come to live in the United States?" whereas the PRCS asks "When did this person come to live in Puerto Rico?") The comparable United States table has the same ID but without the trailing "PR" (e.g., B06004A and B06004APR).

Top of Section
Page Last Revised - December 21, 2022
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?


Back to Header