Skip Header

We are hiring thousands of people for the 2020 Census. Click to learn more and apply.

Table IDs Explained

Component ID: #ti739888441

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
Component ID: #ti862198583

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

Component ID: #ti1263682240

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.

Component ID: #ti1687775829

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

 

Component ID: #ti1234333697

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

Component ID: #ti562617662

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

Component ID: #ti1465004982

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

Component ID: #ti1935398275

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).

You May Be Interested In


Related Topics

Around the Bureau

X
  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
X
Comments or suggestions?
No, thanks
255 characters remaining
X
Thank you for your feedback.
Comments or suggestions?
Back to Header