American FactFinder Deep Linking Tips

These are samples of links that will take you directly to a table for the geography you want. 
It is important to know the table number first. 

For an ACS table:
http://factfinder2.census.gov/bkmk/table/1.0/en/ACS/10_1YR/B15003/0400000US06|0400000US06.05000|0400000US06.16000

All tracts within a county to a data profile:
http://factfinder2.census.gov/bkmk/table/1.0/en/ACS/10_5YR/DP03/0500000US06045|0500000US06045.14000

All state and county to a data profile for multiple races - with Race from the ACS SF4 Selected Pop Tables 
http://factfinder2.census.gov/bkmk/table/1.0/en/ACS/10_SF4/DP03/0400000US06|0400000US06.05000/popgroup~001|400|451|453|455|457|459|461|463

For a Census 2000 or 2010 table:

2000 SF1
http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF1/H003/0400000US06|0400000US06.05000|0400000US06.16000

2000 SF2  Quick Table
http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF2/QTP11/0400000US06|0400000US06.05000|0400000US06.16000

2000 SF2 Table
http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF2/PCT001/0400000US06|0400000US06.05000|0400000US06.16000

2010 SF2 Table for a specific race
http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/10_SF2/SF2DP1/0400000US06|0400000US06.05000/popgroup~020 

2000 SF4 All county to a data profile - with multiple Race from the SF4  
http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/00_SF4/DP2/0400000US06.05000/popgroup~001|400|451|453|455|457|459|461|463

Quick start
http://factfinder2.census.gov/bkmk/qs/1.0/en/text_search:population/geo_search:california

Search Results
http://factfinder2.census.gov/bkmk/navigation/1.0/en/text_search:poverty


Here's the breakdown of the last part on the geography:

040 base geography summary level
00   base geography Geographic Component 
00   Congressional District vintage (looks like this will be “00” most of the time)
US   default (probably versus “PR”
24   base geography State code
.       divider to say I want all of the following piece nested within the base geography
140  Summary level
00	probably Geographic Component again.

Examples of geography selections:
0400000US06.05000  will get that table for all the counties in California
0500000US06067.14000 will get all the tracts in Sacramento County, California  
0500000US06037.14000  will get all the tracts in Los Angeles County, California
0500000US06067.14000|0500000US06037.14000 will get you all census tracts for both counties in CA.  The “|” acts as “and”
0400000US06.05000|0400000US06.16000 will get you all counties and all places in California


Here's the breakdown of the middle part on the file and table number:

/ACS/10_5YR/B01003/ is the program / data set / table.   /ACS/09_5YR/B01003/ will get me the same as above only for the 05-09 estimates. /DEC/10_SF1/P#/ Gets you into the most recent decennial Census data - replace the "#" with the table number.

For more information - the Deep Linking Guide is at http://factfinder2.census.gov/legacy/AFF_deep_linking_guide.pdf  The Guide provides all the possible options for the program and dataset.  You will need the technical documentation for the particular file to determine the table number.  Or you can find the table number on American FactFinder.


This tip sheet was developed by:
   Nancy Gemignani
   California State Data Center
   Demographic Research Unit
   Department of Finance
   e-mail:  ficalpop@dof.ca.gov
   phone:  916-323-4086