Decennial Census Summary Files on AFF

Open  American FactFinder  in a new window 


American FactFinder Topics menu Filter Options are in these menus
American Factfinder Selection Menus
  • From the Topics Menu choose Program.
  • Then from the list of Programs choose Decennial Census. 
  • Now from the Topics menus select Year (2000 or 2010) and finally Dataset, that is select one of the Summary Files.
  • Understanding what is in each dataset (Summary File) is important when choosing a Dataset. 
  • Refer to either the Census 2010 or Census 2000 page for more information about the content each Summary File.

  • The "Search Results" display will appear when you make your first choice from the options within the Topics filter menu.
  • The Search Results window lists all tables that are available.
  • Filters you apply or searches you do will reduce the number of tables in the Search Results window.
  • All your choices will appear in the "Your Selections" box in the upper left above the filter choices.
  • Selections can be deleted at any time.

The next step can be either making your Geography selection or, from within the Topics menu, making your Table the selection.  Because some tables have a geographic component, the Table Selection is presented first.


There is little advantage to selecting multiple tables as viewing and downloading are done one table at a time.

  • Filtering or searching by more than one topic will leave tables that satisfy every selection you have made.
  • To preview a table layout, click on the information icon (the small i to the right of each table name).
  • To compare the layout of two tables, click on the box to the left of each one and then click on the Compare button that is above the list of tables.
  • Using  the Topics Filters
    • Filter by People or Housing characteristics
      • The entries under the "People" and "Housing" menus represent subject groupings for data characteristics.
      • The entries reflect the particular summary file you have chosen.
      • If the characteristic you select leaves many tables in the list, other filter types can shorten the list.
      • The “Origins” and “Race & Ethnicity” filters allow you to filter by a specific population subgroup BUT only for what are defined as “basic” race and Hispanic origin groups. 
      • For a definition of "basic" and other population subgroups refer to the guide Sources for Data on Ethnicity.
      • Information on other population groups can be obtained using the Product Type filters and/or by searching as described below.
    • Filter by Product Type
      • The same data characteristics can appear in tables that differ only by the scope of what the table contains. Tables are assigned a product type ID based on their scope (IDs are a column heading on the list of tables)
      • The letters H and P following an ID identify tables that are specific either to housing or population characteristics. An addition of CT means data are available only for tracts or geographies larger than tracts.
      • Quick Tables (QT-H, QT-P);
        • Topic-specific quick tables present the most frequently requested details on a topic.
        • Quick tables that focus on race and Hispanic Origin include totals for basic race and Hispanic groups and some limited reporting for detailed race and Hispanic Groups.
      • Detailed Tables  (H, P, HCT, PCT)
        • These tables report specifics about a particular characteristic.
        • Some detailed tables will cross analyze two topics.
        • Detailed tables often repeat for each basic race and for Hispanics groups but not in SF2 or SF4 where specifying any population subgroup is done using the Race and Ethnic Groups filter.
      • Data Profiles (DP)
        • Data Profiles can be either general in coverage or specific to demographic, social, economic or housing characteristics.
        • Each table includes data on many indicators but with less detail on each than is found in Quick Tables or Detailed Tables.
        • In the 2010 SF1 there are no DPs rather the Demographic Profile file is a separate dataset, the Demographic Profile Summary File.
      • Geographic Comparison (GCT-H,  GCT-P)
        • These are Quick Tables where data are reported for all locations at the same level of geography that are within a large geographic coverage area. 
        • Choosing this filter will bring up a new filter where you can select the coverage area (the "parent") and then reporting level (the "child').
        • For example, if you choose "state" as a "parent," the child menu will list the geographies at the next level down (county, place, school district, etc.). 
        • Once your parent-child choices are set, use the Geographies filter to limit coverage to specific parent geographies. Example: parent-county, child-tract, then in Geographies menu - New York.
        • The geographies that appear in any menu will depend on what other choices you have made including dataset.
        • Leave your topical choices: people and housing, until last to ensure that you see all tables that meet you geographic criteria
      • Ranking Tables (available only for 2000 SF1)
        • Ranking tables report counts for total population, housing units, land area, and population density.
        • Tables only for preset geographic levels can be retrieved across the nation or within states that you select.
  • Using the Search Box
    • Works best when you are familiar with the terminology used for data characteristics.
    • The search box is NOT the best way to find tables based on race or Hispanic origin.
    • To obtain counts on population groups defined by basic race or the word Hispanic, use Race & Ethnicity Filters found in the People menu.
    • Total population counts for Detailed race and detailed Hispanic Origin groups are listed in a few tables and can be found by searching for one of these groups (e.g. korean, Mexican) refer to Sources for Data on Ethnicity for a complete list of these groups.
  • Using Race and Ethnic Groups
    • This filter is the feature designed specifically for getting data that analyzes population subgroups as defined on page Sources for Data on Ethnicity.
    • Finding data for a particular population subgroup depends on what dataset you chose and on whether the count for your group is large enough at the level of geography you selected.
    • To use this filter you must have selected from the Dataset menu either Summary File 2 or Summary File 4 (2000 only).
    • The tables in these files do not reference any population subgroups.
    • Use the Race and Ethnic Groups filter, which will open in an overlay window, to choose the population subgroups you want.
    • Searches or selections you make in the Race and Ethnic Groups overlay window do not impact your selections in the main AFF window until you finalize them.
    • Under Race and Ethnic Group, the Hispanic or Latino filter works well when looking for data on not Hispanic or Latino in combination with a race.
    • Under the Basic Race Category, the Race Combination filter is the best way of choosing race counts that are either alone or in combination.
    • For a race group (detailed or basic), a detailed Hispanic origin, or any other population subgroup listed in Sources for Data on Ethnicity search the name of the group.
    • To select a group click on the check box to the left of the entry.
    • To finalize a selection use the Add button found above the list of choices.
    • You can choose more than one group and finalize them all at once or select and finalize choices one at a time (clear the population groups filter after adding to begin a new selection.)
    • When your last selection has been made close the overlay window to return to the main AFF screen.
  • Combinations of Filters/Search (an example)
    • Use the People or Housing filter menus to choose your topic.
    • You can add a second characteristic like age using a search.
    • Then pick the type of table you want using the Product Type filter.
    • Except when using SF2 or SF4, for data by basic race or Hispanic Origin, use the search box to look for a basic race category or the word "hispanic."  
    • With Summary File 2 (SF2) and 4 (SF4) use the Race and Ethnic Groups filter type to find tables based on basic or detailed race or Hispanic Origin subpopulations.
  • Finalizing your selection
    • Check the box to left the table ID for the table that you want.
    • You can select more than one table but viewing and downloading may be easier handling one table at a time.
  • The Zip file will contain two files with an .csv extension. The one without the _ann suffix in the file name is the data file. 
  • The header rows in the data file will likely need to be modified before the data can be used with application software.