Tables and Products


Tables and Products in American Fact Finder

The Census Bureau collects data about various topics and geographies. These data in American FactFinder are organized in various presentation formats, referred to as tables and products, or product types.





Product Types in AFF

The product types in AFF consist of:



Comparison Profiles

Comparison profiles showing time series data, are tables available from the American Community Survey (ACS) for 1-year estimates beginning in 2007. Beginning in 2012, the 3-year estimate datasets also have comparison profiles available. These tables show detailed demographic, social, economic and housing data about a selected geography over several years. Users can identify trends and patterns over time. Comparison profiles are available for the United States, the 50 states, the District of Columbia and geographic areas with a population of more than 65,000 in the American FactFinder.





Data Profiles

Data Profiles have the most frequently requested demographic, social, economic, and housing data. Each of these four subject areas is a separate data profile. These are available from the American Community Survey and the decennial censuses. They summarize the data for a single geographic area, both numbers and percent, from the surveys and censuses to cover the most basic data on all topics. The decennial censuses also call their profiles "demographic profiles".

Data is available for the U.S., regions, divisions, states, counties, county subdivisions, places, metropolitan areas, American Indian and Alaska Native areas, Hawaiian home lands, congressional districts and more.

The ACS data profile for demographic characteristics and housing units can be used if official estimates from the Population Estimates Program are not available. The DP-1: General Demographic Characteristics table from the Population Estimates program will provide the official intercensal population estimates.

In AFF, these profiles have a table identifier (i.e., Table ID) beginning with "DP".





Detailed Tables

Detailed Tables are tables from datasets (sometimes called Summary Files) that provide the most detailed data on all topics and geographic areas for nearly all programs in AFF. All Quick Tables, Profiles, Geographic Comparison Tables, most Subject Tables, Ranking Tables, Comparison Profiles, and Narrative Profiles are sourced from Detailed Tables.

Tables often include totals and subtotals. Users may choose more than one geographic area in the table for viewing, printing and downloading.

Decennial census detailed tables are identified and labeled using established guidelines. Table identification begins with a letter that refers to the type of data in the table, and then a number is assigned sequentially as the tables are produced. For example, table IDs that start with:



ACS detailed tables begin with the letters "B" for base tables, and "C" for collapsed tables. The "collapsed" tables cover the same topics as the base table, but with fewer details. In ACS these tables have the ID beginning with "B" or "C". "C" is used for a collapsed version of a "B" table. A "C" table is very similar to a "B" table with the same number. For example, C07001 and B07001. But two or more lines from the "B" table have been collapsed into a single line in a "C" table.

Other programs identify their detailed tables in a variety of ways. For instance, the Annual Estimates of the Resident Population table has a table ID of 'PEPANNRES.'





Geographic Comparison Tables (GCT)

These tables in AFF provide basic measures for population, housing and governments for a group of related geographic areas (e.g., all counties in a state). Users can compare data across geographic areas in the same table.

The key to selecting geography for a GCT is to select the parent geography containing the geography you are looking for. For example, if 'All Counties in a State', select a state; and for 'All Census Tracts in a County', select a county.





Geographic Headers

Geography Header is a table for each decennial and ACS dataset that shows the geographic areas that are included in that dataset. The tables also show the most recent census population, housing units, land area, and population and housing unit density for each geography. The table ID for these tables is "G001".

These tables list various codes and other information about the selected geographies.





Narrative Profiles

Narrative Profiles are available in AFF from the American Community Survey from 2009 to 2012 for 1-Year and 3-Year Estimates only.


Narrative profiles provide text and charts to display selected social, economic, housing and demographic estimates for a single geographic area. The topics include households and families, disability, travel to work, income, poverty, and a wide variety of other topics drawn from the American Community Survey (ACS) Data profiles.





Public Use Microdata Samples (PUMS)

PUMS files are computerized files containing a small sample of individual records, with identifying information removed, from the American Community Survey showing the population and housing characteristics of the people included on those forms.



Quick Tables

These consist of predefined tables with frequently requested information for a single geographic area. The information includes numbers, percents, medians, averages, etc. Users may choose more than one geographic area. The data profiles are one type of Quick Table with a special name.





Ranking Tables

Ranking tables in AFF are organized according to the numeric value of the data displayed. ACS only presents state level data.

For ACS, a difference in ranks between two states does not mean that the estimates are statistically different, or that one is higher than the other. You can use the "with statistical significance" version of the table to determine whether two estimates can be said to be statistically different.

PEP offers several ranking table showing annual population change for counties and incorporated places.





Selected Population Profiles

Selected Population Profiles (Table ID S0201) are available from the ACS 1-Year and 3-Year estimates datasets only. The profiles show social, economic, housing, and demographic data. They are available for over a hundred race, ethnic, tribal, ancestry, and country of birth groups. These are generally only available for areas with a larger population, and for population groups that meet a threshold for the geographic area. For 1-Year estimates, the population group selected must have a population of at least 65,000; for 3-Year estimates, the population group selected must have a population of at least 20,000.





Subject Tables

Subject tables are similar to data profiles but include more detailed ACS data, classified by subject.