Transcript Slide 1

Using American FactFinder
John DeWitt
Project Manager
Lisa Neidert
Data Services
Social Science Data Analysis Network
Population Studies Center
What is American FactFinder?
• Main portal to most popular data from U.S. Census Bureau
Decennial census
American Community Survey
Puerto Rico Community Survey
Population Estimates
Economic Census and Surveys
• Multiple data products
– Several indicators across geographies
– Many indicators for a single geography
• Occasionally difficult to link “data” to “information”
– Trends
– What product to use?
American FactFinder
•Fact Sheetsquick stats for a town,
county or zip code
•“Get data” linksmany of AFF’s data
•Download centerquick downloads
of detailed tables for all available states,
counties, metro areas, etc.
Fact Sheets (Data Profiles)
•Quick lookup
•Many common indicators
•Includes U.S. numbers for comparison
Aggregate Products are the
most commonly used data
products available from
the ACS. These include the
tables and maps in the
American Factfinder, which
describe the distributions
for basic and detailed
population and household
Detailed Tables
These are where experienced
journalists go first to find the
estimates they need. In the American
FactFinder, these tables are known as
the detailed and custom tables and
include the most descriptive and
detailed data. These tables feature
simple frequency estimates for
individual variables and estimates for
combinations (such as poverty status
by sex and age). Many variables in the
detailed tables, such as age, are
subdivided into several categories
(such as ages 0–17, 18–64, 65 and
older, and so on). Detailed tables can
also be obtained through FTP.
preformatted text.
Detailed Tables
Select multiple
Detailed Tables
See multiple
Scroll to see
other selected
Detailed Tables
Collapsed table
A detailed table with a reduced amount of detail
shown to comply with data release rules. Specifically,
it is a detailed table with a "C" prefix for which two or
more lines of data from the corresponding "B" prefix
table have been collapsed into a single line in the "C"
table. Not every B table has a collapsed version.
Downloading from AFF
FIPS Codes: A slight diversion
Standards (FIPS)
•Issued by National Institute of
Standards and Technology (NIST), now
updated by American National
Standards Institute (ANSI)
•Useful for mapping and databases
Subject Tables
These are summarized, topicspecific tables based on data from
the detailed tables. They are easier
to navigate and can be a better
choice if you just need a quick
overview, or if you’re new to the
ACS. Subject tables provide data for
some of the most popular topics,
such as finances, households, and
occupational characteristics for a
single geography. If your questions
is simple, subject tables may
provide the data you need with a
minimum of fuss.
Subject Tables
Select only one geography.
Browse by subject or
select a table below.
Ranking Tables
These tables compare the 50
states, the District of Columbia,
and Puerto Rico according to
various characteristics and rank
them from highest to lowest.
Ranking tables present state data
characteristics. These tables can
also be viewed as charts, using a
link on the page. The charts show
the 90-percent confidence limits
around each estimate as an
indication of which rankings may
be statistically different (meaning
the two estimates probably are
truly different.)
Browse by
subject or
select a table
Sort alphabetically by State or
numerically by Ranking.
Geographic Comparison Tables
These are similar to ranking tables
but are available for geographical
levels that extend below the state
level. Unlike ranking tables, they
provide margins of error for the
estimates but do not tell you
whether or not the differences in
rankings are statistically significant.
Geographic Comparison Tables
Select a geographic area (Nation or
State), and then the table format, or
the geography you want to compare.
Here we are choosing to compare all
of the counties in Michigan.
Geographic Comparison Tables
Select only one
Comparison Table.
Data Profiles
This product offers tables that
provide summaries of several basic
social, economic, housing, and
demographic characteristics for
each geographic unit. While they
are less sophisticated than
detailed tables, data profiles do a
good job of describing the broad
characteristics of a geographic
Data Profiles
Select only one geography.
Select different profiles to
see economic, housing, or
demographic data tables.
Scroll to see more
Accessible through data profiles
are narrative profiles, which
present the data in plain
language and use graphics,
similar to a news article. These
products contain data that are
automatically inserted into a
preformatted text.
Selected Population Profiles
Population profiles are readymade tabulations for specific
groups of interest, such as a
specific ancestry or race. While
other ACS profiles provide general
information for a geographic area,
the selected population profiles
use a similar format to provide
basic information for a specific
segment of the population.
Selected Population Profiles
Select multiple
Selected Population Profiles
Select the specific
population group
you want to look
at. You can choose
from Race or
Ethnic groups,
Ancestry groups or
Country of Birth.
Scroll to see more
Thematic Maps
The maps include two important
features in addition to their
categorical color schemes. First,
users can quickly identify which
other geographic units have a
significant statistical difference
from the selected unit for a
particular characteristic.
tabular interfaces to the data are
readily available as a link on the
left of the page.
Thematic Maps
Select only one geography.
Thematic Maps
Select only one
Thematic Map.
Use the zoom feature to
see a more detailed map.
Change the geography
displayed. Other options
include Congressional
Districts, Metropolitan and
Micropolitan Statistical
Areas and Public Use
Microdata Areas.
Comparison Profiles
The comparison profiles show data
side-by-side from the 2006 ACS
and the 2007 ACS, indicating
where there is a statistically
significant difference between the
two sets of estimates. Comparison
profiles are only available for 1year estimates.
Comparison Profiles
Select only one geography.
Select different profiles to
see economic, housing, or
demographic data tables.
Compare data
across the years.
Some data is not
able to be
accurately, in this
case the 2007 and
2008 3-year
Use the download center to quickly
download large amounts of data.
The download center allows users
to download up to 50 tables for a
single geography at a time, or you
can download all the summary file
extracts for all the tables. The
individual tables download as zip
file with pipe-delimited text files.
Download Center
Select only one
geography at a time.
Select the aggregate
product, or data
visualization, you
want to download.
Download Center
Select up to 50
different tables
to download.
Download Center
Sample Tasks
• How could you get a demographic overview of your
local county, city, or state?
• What FactFinder product would allow you to look at
median age of first marriage for your multiple
counties, a state, and the U.S. all at once?
• What state has the largest percentage of population
that has completed high school?
• Which FactFinder product allows a user to download
multiple files for all available geographies of specific
summary level (e.g. counties, metropolitan and
micropolitan areas, etc)