Media (Newsroom) Survey Participants/ Respondents Partners Educators and Students
NAICS Lookup Schedule B Search Geocoding Service

NOTICE: Due to a lapse in federal funding portions of this website are not being updated. Learn more.

American Community Survey (ACS)

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:

Expand All
Collapse All

Element 1: Table Type

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
K20
 Supplemental Table The only source of 1-year statistics for selected geographies with populations of 20,000-64,999
S
 Subject Table A span of information on a particular ACS subject, such as veterans, presented in the format of both estimates and percentages
R
 Ranking Table State rankings across approximately 90 key variables
GCT
 Geographic Comparison Table Comparisons across approximately 95 key variables for geographies other than states such as counties or congressional districts
DP
 Data Profile Broad social, economic, housing, and demographic information in a total of four profiles
NP
 Narrative Profile Summaries of information in the Data Profiles using nontechnical text
CP
 Comparison Profile Comparisons of ACS estimates over time in the same layout as the Data Profiles
S0201
 Selected Population Profile Broad ACS statistics for population subgroups by race, ethnicity, ancestry, tribal affiliation, and place of birth

Back to Top

Element 2: Subject (B, C, K20, S, R, and GCT Tables Only)

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

 

Back to Top

Element 3: Table Number within a Subject

The next 2 or 3 digits are a sequential number, such as 001 or 002, that uniquely identifies the table within a given subject.

Back to Top

Element 4: Race Iteration (Selected Tables Only)

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

Back to Top

Element 5: Identification for Puerto Rico Geographies (Selected Tables Only)

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., B06014 and B06014PR).

Back to Top

You May Be Interested In

Related Topics

Contact Us

Around the Bureau

Email Updates

Most Popular

Share Your ACS Data Story