Description: The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS collects information such as age, race, income, commute time to work, home value, veteran status, and other important data.

Sources:
2013 ACS Table B22002 - for access via API key
2013 ACS Table S2201 - for manual download

There are 2 ways of getting the American Community Survey data from the US Census: downloading the data and reading it or retrieving the data via the Census API.

Load the ACS package

# install.packages('acs')
suppressPackageStartupMessages(library("acs"))
## Warning: package 'acs' was built under R version 3.1.3

Read Census data from a file

Read the .CSV file for table S2201

censustableS2201 <- read.acs("ACS_13_5YR_S2201_with_ann.csv", endyear = 2013, 
    span = 5, skip = 2)
## Warning: Using first three columns as geographic headers.
## Warning: NAs introduced by coercion
head(censustableS2201, 3)
## ACS DATA: 
##  2009 -- 2013 ;
##   Estimates w/90% confidence intervals;
##   for different intervals, see confint()
##                                                  HC01_EST_VC01.Total; Estimate; Households.1163
## Census Tract 1.02, Durham County, North Carolina 1815 +/- 111                                  
## Census Tract 2, Durham County, North Carolina    1368 +/- 87                                   
## Census Tract 3.01, Durham County, North Carolina 1226 +/- 71                                   
##                                                  HC02_EST_VC01.Households receiving food stamps; Estimate; Households.285
## Census Tract 1.02, Durham County, North Carolina 301 +/- 114                                                             
## Census Tract 2, Durham County, North Carolina    257 +/- 103                                                             
## Census Tract 3.01, Durham County, North Carolina 261 +/- 105                                                             
##                                                  HC03_EST_VC01.Households not receiving food stamps; Estimate; Households.878
## Census Tract 1.02, Durham County, North Carolina 1514 +/- 133                                                                
## Census Tract 2, Durham County, North Carolina    1111 +/- 131                                                                
## Census Tract 3.01, Durham County, North Carolina 965 +/- 118                                                                 
##                                                  HC01_EST_VC02.Total; Estimate; With one or more people 60 years and over.33.9
## Census Tract 1.02, Durham County, North Carolina 20.3 +/- 4.7                                                                 
## Census Tract 2, Durham County, North Carolina    24 +/- 7.2                                                                   
## Census Tract 3.01, Durham County, North Carolina 21.5 +/- 6.7                                                                 
##                                                  HC02_EST_VC02.Households receiving food stamps; Estimate; With one or more people 60 years and over.37.2
## Census Tract 1.02, Durham County, North Carolina 18.9 +/- 13.4                                                                                           
## Census Tract 2, Durham County, North Carolina    9.7 +/- 14.5                                                                                            
## Census Tract 3.01, Durham County, North Carolina 26.4 +/- 16.9                                                                                           
##                                                  HC03_EST_VC02.Households not receiving food stamps; Estimate; With one or more people 60 years and over.32.8
## Census Tract 1.02, Durham County, North Carolina 20.5 +/- 5.1                                                                                                
## Census Tract 2, Durham County, North Carolina    27.3 +/- 9                                                                                                  
## Census Tract 3.01, Durham County, North Carolina 20.1 +/- 7.4                                                                                                
##                                                  HC01_EST_VC03.Total; Estimate; With children under 18 years.32.0
## Census Tract 1.02, Durham County, North Carolina 31.9 +/- 6.5                                                    
## Census Tract 2, Durham County, North Carolina    39.3 +/- 9                                                      
## Census Tract 3.01, Durham County, North Carolina 20.9 +/- 6.8                                                    
##                                                  HC02_EST_VC03.Households receiving food stamps; Estimate; With children under 18 years.56.5
## Census Tract 1.02, Durham County, North Carolina 35.9 +/- 16.7                                                                              
## Census Tract 2, Durham County, North Carolina    57.2 +/- 23.4                                                                              
## Census Tract 3.01, Durham County, North Carolina 50.6 +/- 22.3                                                                              
##                                                  HC03_EST_VC03.Households not receiving food stamps; Estimate; With children under 18 years.24.0
## Census Tract 1.02, Durham County, North Carolina 31.1 +/- 7.5                                                                                   
## Census Tract 2, Durham County, North Carolina    35.1 +/- 7.8                                                                                   
## Census Tract 3.01, Durham County, North Carolina 12.8 +/- 8                                                                                     
##                                                  HC01_EST_VC06.Total; Estimate; POVERTY STATUS IN THE PAST 12 MONTHS - Below poverty level.18.6
## Census Tract 1.02, Durham County, North Carolina 18.1 +/- 5.9                                                                                  
## Census Tract 2, Durham County, North Carolina    28.5 +/- 9.5                                                                                  
## Census Tract 3.01, Durham County, North Carolina 20.7 +/- 6.9                                                                                  
##                                                  HC02_EST_VC06.Households receiving food stamps; Estimate; POVERTY STATUS IN THE PAST 12 MONTHS - Below poverty level.49.8
## Census Tract 1.02, Durham County, North Carolina 39.5 +/- 18.7                                                                                                            
## Census Tract 2, Durham County, North Carolina    60.7 +/- 23.3                                                                                                            
## Census Tract 3.01, Durham County, North Carolina 26.1 +/- 16.2                                                                                                            
##                                                  HC03_EST_VC06.Households not receiving food stamps; Estimate; POVERTY STATUS IN THE PAST 12 MONTHS - Below poverty level.8.4
## Census Tract 1.02, Durham County, North Carolina 13.9 +/- 5.4                                                                                                                
## Census Tract 2, Durham County, North Carolina    21.1 +/- 11.2                                                                                                               
## Census Tract 3.01, Durham County, North Carolina 19.3 +/- 7.8                                                                                                                
##                                                  HC01_EST_VC09.Total; Estimate; DISABILITY STATUS - With one or more people with a disability.37.1
## Census Tract 1.02, Durham County, North Carolina 21.9 +/- 5.2                                                                                     
## Census Tract 2, Durham County, North Carolina    15.1 +/- 6.6                                                                                     
## Census Tract 3.01, Durham County, North Carolina 23.9 +/- 7.6                                                                                     
##                                                  HC02_EST_VC09.Households receiving food stamps; Estimate; DISABILITY STATUS - With one or more people with a disability.61.1
## Census Tract 1.02, Durham County, North Carolina 43.5 +/- 17                                                                                                                 
## Census Tract 2, Durham County, North Carolina    30.7 +/- 18.9                                                                                                               
## Census Tract 3.01, Durham County, North Carolina 54.4 +/- 19.4                                                                                                               
##                                                  HC03_EST_VC09.Households not receiving food stamps; Estimate; DISABILITY STATUS - With one or more people with a disability.29.4
## Census Tract 1.02, Durham County, North Carolina 17.6 +/- 4.6                                                                                                                    
## Census Tract 2, Durham County, North Carolina    11.4 +/- 7.7                                                                                                                    
## Census Tract 3.01, Durham County, North Carolina 15.6 +/- 6.5                                                                                                                    
##                                                  HC01_EST_VC12.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race.94.1
## Census Tract 1.02, Durham County, North Carolina 97.6 +/- 2.2                                                                                    
## Census Tract 2, Durham County, North Carolina    98.2 +/- 2                                                                                      
## Census Tract 3.01, Durham County, North Carolina 98.9 +/- 1.3                                                                                    
##                                                  HC02_EST_VC12.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race.87.7
## Census Tract 1.02, Durham County, North Carolina 92 +/- 11.7                                                                                                                
## Census Tract 2, Durham County, North Carolina    94.9 +/- 7.8                                                                                                               
## Census Tract 3.01, Durham County, North Carolina 100 +/- 12.5                                                                                                               
##                                                  HC03_EST_VC12.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race.96.1
## Census Tract 1.02, Durham County, North Carolina 98.7 +/- 1.8                                                                                                                   
## Census Tract 2, Durham County, North Carolina    98.9 +/- 1.7                                                                                                                   
## Census Tract 3.01, Durham County, North Carolina 98.7 +/- 1.7                                                                                                                   
##                                                  HC01_EST_VC13.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - White.43.2
## Census Tract 1.02, Durham County, North Carolina 60.2 +/- 7.5                                                                                            
## Census Tract 2, Durham County, North Carolina    52.6 +/- 7.4                                                                                            
## Census Tract 3.01, Durham County, North Carolina 46.4 +/- 8.6                                                                                            
##                                                  HC02_EST_VC13.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - White.11.6
## Census Tract 1.02, Durham County, North Carolina 35.9 +/- 17.9                                                                                                                      
## Census Tract 2, Durham County, North Carolina    27.6 +/- 17.8                                                                                                                      
## Census Tract 3.01, Durham County, North Carolina 20.7 +/- 17.5                                                                                                                      
##                                                  HC03_EST_VC13.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - White.53.4
## Census Tract 1.02, Durham County, North Carolina 65 +/- 7.7                                                                                                                             
## Census Tract 2, Durham County, North Carolina    58.4 +/- 8.8                                                                                                                           
## Census Tract 3.01, Durham County, North Carolina 53.4 +/- 9.2                                                                                                                           
##                                                  HC01_EST_VC14.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Black or African American.43.2
## Census Tract 1.02, Durham County, North Carolina 33.5 +/- 5.8                                                                                                                
## Census Tract 2, Durham County, North Carolina    38.2 +/- 8.2                                                                                                                
## Census Tract 3.01, Durham County, North Carolina 41.4 +/- 6.7                                                                                                                
##                                                  HC02_EST_VC14.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Black or African American.62.5
## Census Tract 1.02, Durham County, North Carolina 53.5 +/- 18                                                                                                                                            
## Census Tract 2, Durham County, North Carolina    67.3 +/- 18.3                                                                                                                                          
## Census Tract 3.01, Durham County, North Carolina 58.2 +/- 20.7                                                                                                                                          
##                                                  HC03_EST_VC14.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Black or African American.36.9
## Census Tract 1.02, Durham County, North Carolina 29.5 +/- 6.1                                                                                                                                               
## Census Tract 2, Durham County, North Carolina    31.5 +/- 9.6                                                                                                                                               
## Census Tract 3.01, Durham County, North Carolina 36.9 +/- 8.7                                                                                                                                               
##                                                  HC01_EST_VC15.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - American Indian and Alaska Native.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 1.9                                                                                                                          
## Census Tract 2, Durham County, North Carolina    0 +/- 2.5                                                                                                                          
## Census Tract 3.01, Durham County, North Carolina 1.1 +/- 1.4                                                                                                                        
##                                                  HC02_EST_VC15.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - American Indian and Alaska Native.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 11                                                                                                                                                      
## Census Tract 2, Durham County, North Carolina    0 +/- 12.7                                                                                                                                                    
## Census Tract 3.01, Durham County, North Carolina 5 +/- 6.5                                                                                                                                                     
##                                                  HC03_EST_VC15.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - American Indian and Alaska Native.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 2.3                                                                                                                                                         
## Census Tract 2, Durham County, North Carolina    0 +/- 3.1                                                                                                                                                         
## Census Tract 3.01, Durham County, North Carolina 0 +/- 3.6                                                                                                                                                         
##                                                  HC01_EST_VC16.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Asian.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 1.9                                                                                              
## Census Tract 2, Durham County, North Carolina    0.8 +/- 1.2                                                                                            
## Census Tract 3.01, Durham County, North Carolina 5.1 +/- 4                                                                                              
##                                                  HC02_EST_VC16.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Asian.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 11                                                                                                                          
## Census Tract 2, Durham County, North Carolina    0 +/- 12.7                                                                                                                        
## Census Tract 3.01, Durham County, North Carolina 0 +/- 12.5                                                                                                                        
##                                                  HC03_EST_VC16.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Asian.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 2.3                                                                                                                             
## Census Tract 2, Durham County, North Carolina    1 +/- 1.5                                                                                                                             
## Census Tract 3.01, Durham County, North Carolina 6.4 +/- 5                                                                                                                             
##                                                  HC01_EST_VC17.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Native Hawaiian and Other Pacific Islander.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 1.9                                                                                                                                   
## Census Tract 2, Durham County, North Carolina    0 +/- 2.5                                                                                                                                   
## Census Tract 3.01, Durham County, North Carolina 0 +/- 2.8                                                                                                                                   
##                                                  HC02_EST_VC17.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Native Hawaiian and Other Pacific Islander.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 11                                                                                                                                                               
## Census Tract 2, Durham County, North Carolina    0 +/- 12.7                                                                                                                                                             
## Census Tract 3.01, Durham County, North Carolina 0 +/- 12.5                                                                                                                                                             
##                                                  HC03_EST_VC17.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Native Hawaiian and Other Pacific Islander.0.0
## Census Tract 1.02, Durham County, North Carolina 0 +/- 2.3                                                                                                                                                                  
## Census Tract 2, Durham County, North Carolina    0 +/- 3.1                                                                                                                                                                  
## Census Tract 3.01, Durham County, North Carolina 0 +/- 3.6                                                                                                                                                                  
##                                                  HC01_EST_VC18.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Some other race.7.7
## Census Tract 1.02, Durham County, North Carolina 3.9 +/- 3.1                                                                                                      
## Census Tract 2, Durham County, North Carolina    6.5 +/- 6.4                                                                                                      
## Census Tract 3.01, Durham County, North Carolina 5 +/- 5.1                                                                                                        
##                                                  HC02_EST_VC18.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Some other race.13.7
## Census Tract 1.02, Durham County, North Carolina 2.7 +/- 4.3                                                                                                                                  
## Census Tract 2, Durham County, North Carolina    0 +/- 12.7                                                                                                                                   
## Census Tract 3.01, Durham County, North Carolina 16.1 +/- 21                                                                                                                                  
##                                                  HC03_EST_VC18.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - One race - Some other race.5.8
## Census Tract 1.02, Durham County, North Carolina 4.2 +/- 3.6                                                                                                                                     
## Census Tract 2, Durham County, North Carolina    8 +/- 7.9                                                                                                                                       
## Census Tract 3.01, Durham County, North Carolina 2 +/- 2.3                                                                                                                                       
##                                                  HC01_EST_VC19.Total; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - Two or more races.5.9
## Census Tract 1.02, Durham County, North Carolina 2.4 +/- 2.2                                                                                             
## Census Tract 2, Durham County, North Carolina    1.8 +/- 2                                                                                               
## Census Tract 3.01, Durham County, North Carolina 1.1 +/- 1.3                                                                                             
##                                                  HC02_EST_VC19.Households receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - Two or more races.12.3
## Census Tract 1.02, Durham County, North Carolina 8 +/- 11.7                                                                                                                          
## Census Tract 2, Durham County, North Carolina    5.1 +/- 7.8                                                                                                                         
## Census Tract 3.01, Durham County, North Carolina 0 +/- 12.5                                                                                                                          
##                                                  HC03_EST_VC19.Households not receiving food stamps; Estimate; RACE AND HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER - Two or more races.3.9
## Census Tract 1.02, Durham County, North Carolina 1.3 +/- 1.8                                                                                                                            
## Census Tract 2, Durham County, North Carolina    1.1 +/- 1.7                                                                                                                            
## Census Tract 3.01, Durham County, North Carolina 1.3 +/- 1.7                                                                                                                            
##                                                  HC01_EST_VC21.Total; Estimate; Hispanic or Latino origin (of any race).8.4
## Census Tract 1.02, Durham County, North Carolina 17.5 +/- 5.4                                                              
## Census Tract 2, Durham County, North Carolina    15.3 +/- 7.8                                                              
## Census Tract 3.01, Durham County, North Carolina 12.5 +/- 6                                                                
##                                                  HC02_EST_VC21.Households receiving food stamps; Estimate; Hispanic or Latino origin (of any race).13.7
## Census Tract 1.02, Durham County, North Carolina 22.3 +/- 16.3                                                                                         
## Census Tract 2, Durham County, North Carolina    23.7 +/- 18.7                                                                                         
## Census Tract 3.01, Durham County, North Carolina 19.2 +/- 21.2                                                                                         
##                                                  HC03_EST_VC21.Households not receiving food stamps; Estimate; Hispanic or Latino origin (of any race).6.7
## Census Tract 1.02, Durham County, North Carolina 16.5 +/- 5.7                                                                                             
## Census Tract 2, Durham County, North Carolina    13.3 +/- 8.9                                                                                             
## Census Tract 3.01, Durham County, North Carolina 10.7 +/- 7                                                                                               
##                                                  HC01_EST_VC22.Total; Estimate; White alone, not Hispanic or Latino.42.5
## Census Tract 1.02, Durham County, North Carolina 46.2 +/- 6.5                                                           
## Census Tract 2, Durham County, North Carolina    43.9 +/- 7.6                                                           
## Census Tract 3.01, Durham County, North Carolina 37.8 +/- 7.6                                                           
##                                                  HC02_EST_VC22.Households receiving food stamps; Estimate; White alone, not Hispanic or Latino.11.6
## Census Tract 1.02, Durham County, North Carolina 13.6 +/- 13.5                                                                                     
## Census Tract 2, Durham County, North Carolina    3.9 +/- 6.6                                                                                       
## Census Tract 3.01, Durham County, North Carolina 17.6 +/- 17.6                                                                                     
##                                                  HC03_EST_VC22.Households not receiving food stamps; Estimate; White alone, not Hispanic or Latino.52.5
## Census Tract 1.02, Durham County, North Carolina 52.6 +/- 6.6                                                                                          
## Census Tract 2, Durham County, North Carolina    53.1 +/- 9.3                                                                                          
## Census Tract 3.01, Durham County, North Carolina 43.3 +/- 8.6                                                                                          
##                                                  HC01_EST_VC25.Total; Estimate; HOUSEHOLD INCOME IN THE PAST 12 MONTHS (IN 2013 INFLATION-ADJUSTED DOLLARS) - Median income (dollars).39653
## Census Tract 1.02, Durham County, North Carolina 39311 +/- 5631                                                                                                                            
## Census Tract 2, Durham County, North Carolina    34384 +/- 5983                                                                                                                            
## Census Tract 3.01, Durham County, North Carolina 35962 +/- 9114                                                                                                                            
##                                                  HC02_EST_VC25.Households receiving food stamps; Estimate; HOUSEHOLD INCOME IN THE PAST 12 MONTHS (IN 2013 INFLATION-ADJUSTED DOLLARS) - Median income (dollars).23068
## Census Tract 1.02, Durham County, North Carolina 18945 +/- 6381                                                                                                                                                       
## Census Tract 2, Durham County, North Carolina    22608 +/- 18359                                                                                                                                                      
## Census Tract 3.01, Durham County, North Carolina 31005 +/- 15231                                                                                                                                                      
##                                                  HC03_EST_VC25.Households not receiving food stamps; Estimate; HOUSEHOLD INCOME IN THE PAST 12 MONTHS (IN 2013 INFLATION-ADJUSTED DOLLARS) - Median income (dollars).47813
## Census Tract 1.02, Durham County, North Carolina 45198 +/- 6673                                                                                                                                                           
## Census Tract 2, Durham County, North Carolina    38884 +/- 6989                                                                                                                                                           
## Census Tract 3.01, Durham County, North Carolina 40243 +/- 9191                                                                                                                                                           
##                                                  HC01_EST_VC28.Total; Estimate; WORK STATUS - Families.680
## Census Tract 1.02, Durham County, North Carolina 834 +/- 131                                              
## Census Tract 2, Durham County, North Carolina    706 +/- 133                                              
## Census Tract 3.01, Durham County, North Carolina 510 +/- 97                                               
##                                                  HC02_EST_VC28.Households receiving food stamps; Estimate; WORK STATUS - Families.197
## Census Tract 1.02, Durham County, North Carolina 118 +/- 63                                                                          
## Census Tract 2, Durham County, North Carolina    171 +/- 92                                                                          
## Census Tract 3.01, Durham County, North Carolina 208 +/- 94                                                                          
##                                                  HC03_EST_VC28.Households not receiving food stamps; Estimate; WORK STATUS - Families.483
## Census Tract 1.02, Durham County, North Carolina 716 +/- 128                                                                             
## Census Tract 2, Durham County, North Carolina    535 +/- 127                                                                             
## Census Tract 3.01, Durham County, North Carolina 302 +/- 95                                                                              
##                                                  HC01_EST_VC29.Total; Estimate; WORK STATUS - Families - No workers in past 12 months.14.4
## Census Tract 1.02, Durham County, North Carolina 11 +/- 7.8                                                                               
## Census Tract 2, Durham County, North Carolina    5.9 +/- 5.8                                                                              
## Census Tract 3.01, Durham County, North Carolina 18.6 +/- 8.2                                                                             
##                                                  HC02_EST_VC29.Households receiving food stamps; Estimate; WORK STATUS - Families - No workers in past 12 months.27.4
## Census Tract 1.02, Durham County, North Carolina 5.9 +/- 10.2                                                                                                        
## Census Tract 2, Durham County, North Carolina    14.6 +/- 22.2                                                                                                       
## Census Tract 3.01, Durham County, North Carolina 22.6 +/- 16                                                                                                         
##                                                  HC03_EST_VC29.Households not receiving food stamps; Estimate; WORK STATUS - Families - No workers in past 12 months.9.1
## Census Tract 1.02, Durham County, North Carolina 11.9 +/- 8.9                                                                                                           
## Census Tract 2, Durham County, North Carolina    3.2 +/- 3.6                                                                                                            
## Census Tract 3.01, Durham County, North Carolina 15.9 +/- 9.7                                                                                                           
##                                                  HC01_EST_VC30.Total; Estimate; WORK STATUS - Families - 1 worker in past 12 months.30.6
## Census Tract 1.02, Durham County, North Carolina 45.3 +/- 13.2                                                                          
## Census Tract 2, Durham County, North Carolina    52.8 +/- 14.8                                                                          
## Census Tract 3.01, Durham County, North Carolina 37.8 +/- 14.1                                                                          
##                                                  HC02_EST_VC30.Households receiving food stamps; Estimate; WORK STATUS - Families - 1 worker in past 12 months.31.0
## Census Tract 1.02, Durham County, North Carolina 63.6 +/- 22                                                                                                       
## Census Tract 2, Durham County, North Carolina    71.3 +/- 30                                                                                                       
## Census Tract 3.01, Durham County, North Carolina 26.4 +/- 16.3                                                                                                     
##                                                  HC03_EST_VC30.Households not receiving food stamps; Estimate; WORK STATUS - Families - 1 worker in past 12 months.30.4
## Census Tract 1.02, Durham County, North Carolina 42.3 +/- 14.1                                                                                                         
## Census Tract 2, Durham County, North Carolina    46.9 +/- 16.4                                                                                                         
## Census Tract 3.01, Durham County, North Carolina 45.7 +/- 17.2                                                                                                         
##                                                  HC01_EST_VC31.Total; Estimate; WORK STATUS - Families - 2 or more workers in past 12 months.55.0
## Census Tract 1.02, Durham County, North Carolina 43.6 +/- 11.5                                                                                   
## Census Tract 2, Durham County, North Carolina    41.2 +/- 13.9                                                                                   
## Census Tract 3.01, Durham County, North Carolina 43.5 +/- 14.5                                                                                   
##                                                  HC02_EST_VC31.Households receiving food stamps; Estimate; WORK STATUS - Families - 2 or more workers in past 12 months.41.6
## Census Tract 1.02, Durham County, North Carolina 30.5 +/- 23.5                                                                                                              
## Census Tract 2, Durham County, North Carolina    14 +/- 21                                                                                                                  
## Census Tract 3.01, Durham County, North Carolina 51 +/- 22.3                                                                                                                
##                                                  HC03_EST_VC31.Households not receiving food stamps; Estimate; WORK STATUS - Families - 2 or more workers in past 12 months.60.5
## Census Tract 1.02, Durham County, North Carolina 45.8 +/- 12                                                                                                                    
## Census Tract 2, Durham County, North Carolina    49.9 +/- 15.9                                                                                                                  
## Census Tract 3.01, Durham County, North Carolina 38.4 +/- 17.1                                                                                                                  
##                                                  HC01_EST_VC34.Total; Estimate; PERCENT IMPUTED - Food stamp/SNAP recipiency.0.9
## Census Tract 1.02, Durham County, North Carolina 0.6 +/- NA                                                                     
## Census Tract 2, Durham County, North Carolina    0 +/- NA                                                                       
## Census Tract 3.01, Durham County, North Carolina 0 +/- NA                                                                       
##                                                  HC02_EST_VC34.Households receiving food stamps; Estimate; PERCENT IMPUTED - Food stamp/SNAP recipiency.(X)
## Census Tract 1.02, Durham County, North Carolina NA +/- NA                                                                                                 
## Census Tract 2, Durham County, North Carolina    NA +/- NA                                                                                                 
## Census Tract 3.01, Durham County, North Carolina NA +/- NA                                                                                                 
##                                                  HC03_EST_VC34.Households not receiving food stamps; Estimate; PERCENT IMPUTED - Food stamp/SNAP recipiency.(X)
## Census Tract 1.02, Durham County, North Carolina NA +/- NA                                                                                                     
## Census Tract 2, Durham County, North Carolina    NA +/- NA                                                                                                     
## Census Tract 3.01, Durham County, North Carolina NA +/- NA

Get Census data via API

Request a Census API Key

U.S. Census' Developers Page Request a key

Install your Census API Key (replace YOUR.KEY.HERE with your specific API key)

api.key.install("YOUR.KEY.HERE", file = "key.rda")

Select your geography. In this case we want to select Durham, Johnston, Orange, and Wake counties. You select counties based on the last 3 digits of their FIPS code, which for North Carolina can be found here

triangleNC <- geo.make(state = 37, county = c(63, 101, 135, 183), tract = "*", 
    check = TRUE)
## Testing geography item 1: Tract *, Durham County, North Carolina .... OK.
## Testing geography item 2: Tract *, Johnston County, North Carolina .... OK.
## Testing geography item 3: Tract *, Orange County, North Carolina .... OK.
## Testing geography item 4: Tract *, Wake County, North Carolina .... OK.

For individual counties:

durhamNC <- geo.make(state = 37, county = 63, tract = "*", check = TRUE)
## Testing geography item 1: Tract *, Durham County, North Carolina .... OK.

Fetch the data

censustable <- acs.fetch(endyear = 2013, geography = triangleNC, table.number = "B22002", 
    col.names = "pretty")
head(censustable, 3)
## ACS DATA: 
##  2009 -- 2013 ;
##   Estimates w/90% confidence intervals;
##   for different intervals, see confint()
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Total: 
## Census Tract 1.01, Durham County, North Carolina 1163 +/- 102                                                                                                 
## Census Tract 1.02, Durham County, North Carolina 1815 +/- 111                                                                                                 
## Census Tract 2, Durham County, North Carolina    1368 +/- 87                                                                                                  
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: 
## Census Tract 1.01, Durham County, North Carolina 285 +/- 118                                                                                                                                                      
## Census Tract 1.02, Durham County, North Carolina 301 +/- 114                                                                                                                                                      
## Census Tract 2, Durham County, North Carolina    257 +/- 103                                                                                                                                                      
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: 
## Census Tract 1.01, Durham County, North Carolina 161 +/- 89                                                                                                                                                                                     
## Census Tract 1.02, Durham County, North Carolina 108 +/- 61                                                                                                                                                                                     
## Census Tract 2, Durham County, North Carolina    147 +/- 88                                                                                                                                                                                     
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: Married-couple family 
## Census Tract 1.01, Durham County, North Carolina 11 +/- 17                                                                                                                                                                                                            
## Census Tract 1.02, Durham County, North Carolina 26 +/- 32                                                                                                                                                                                                            
## Census Tract 2, Durham County, North Carolina    24 +/- 38                                                                                                                                                                                                            
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: 
## Census Tract 1.01, Durham County, North Carolina 150 +/- 88                                                                                                                                                                                                   
## Census Tract 1.02, Durham County, North Carolina 82 +/- 49                                                                                                                                                                                                    
## Census Tract 2, Durham County, North Carolina    106 +/- 76                                                                                                                                                                                                   
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: Male householder, no wife present 
## Census Tract 1.01, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                                                       
## Census Tract 1.02, Durham County, North Carolina 40 +/- 35                                                                                                                                                                                                                                      
## Census Tract 2, Durham County, North Carolina    30 +/- 35                                                                                                                                                                                                                                      
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: Female householder, no husband present 
## Census Tract 1.01, Durham County, North Carolina 150 +/- 88                                                                                                                                                                                                                                          
## Census Tract 1.02, Durham County, North Carolina 42 +/- 38                                                                                                                                                                                                                                           
## Census Tract 2, Durham County, North Carolina    76 +/- 68                                                                                                                                                                                                                                           
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: With children under 18 years: Nonfamily households 
## Census Tract 1.01, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                            
## Census Tract 1.02, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                            
## Census Tract 2, Durham County, North Carolina    17 +/- 26                                                                                                                                                                                                           
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: 
## Census Tract 1.01, Durham County, North Carolina 124 +/- 75                                                                                                                                                                                   
## Census Tract 1.02, Durham County, North Carolina 193 +/- 93                                                                                                                                                                                   
## Census Tract 2, Durham County, North Carolina    110 +/- 68                                                                                                                                                                                   
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: Married-couple family 
## Census Tract 1.01, Durham County, North Carolina 14 +/- 25                                                                                                                                                                                                          
## Census Tract 1.02, Durham County, North Carolina 10 +/- 17                                                                                                                                                                                                          
## Census Tract 2, Durham County, North Carolina    41 +/- 43                                                                                                                                                                                                          
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: 
## Census Tract 1.01, Durham County, North Carolina 22 +/- 25                                                                                                                                                                                                  
## Census Tract 1.02, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                   
## Census Tract 2, Durham County, North Carolina    0 +/- 12                                                                                                                                                                                                   
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: Male householder, no wife present 
## Census Tract 1.01, Durham County, North Carolina 9 +/- 15                                                                                                                                                                                                                                     
## Census Tract 1.02, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                                                     
## Census Tract 2, Durham County, North Carolina    0 +/- 12                                                                                                                                                                                                                                     
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: Female householder, no husband present 
## Census Tract 1.01, Durham County, North Carolina 13 +/- 20                                                                                                                                                                                                                                         
## Census Tract 1.02, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                                                          
## Census Tract 2, Durham County, North Carolina    0 +/- 12                                                                                                                                                                                                                                          
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household received Food Stamps/SNAP in the past 12 months: No children under 18 years: Nonfamily households 
## Census Tract 1.01, Durham County, North Carolina 88 +/- 69                                                                                                                                                                                                         
## Census Tract 1.02, Durham County, North Carolina 183 +/- 92                                                                                                                                                                                                        
## Census Tract 2, Durham County, North Carolina    69 +/- 51                                                                                                                                                                                                         
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: 
## Census Tract 1.01, Durham County, North Carolina 878 +/- 104                                                                                                                                                             
## Census Tract 1.02, Durham County, North Carolina 1514 +/- 133                                                                                                                                                            
## Census Tract 2, Durham County, North Carolina    1111 +/- 131                                                                                                                                                            
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: 
## Census Tract 1.01, Durham County, North Carolina 211 +/- 72                                                                                                                                                                                            
## Census Tract 1.02, Durham County, North Carolina 471 +/- 117                                                                                                                                                                                           
## Census Tract 2, Durham County, North Carolina    390 +/- 100                                                                                                                                                                                           
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: Married-couple family 
## Census Tract 1.01, Durham County, North Carolina 120 +/- 56                                                                                                                                                                                                                  
## Census Tract 1.02, Durham County, North Carolina 226 +/- 83                                                                                                                                                                                                                  
## Census Tract 2, Durham County, North Carolina    189 +/- 68                                                                                                                                                                                                                  
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: 
## Census Tract 1.01, Durham County, North Carolina 91 +/- 50                                                                                                                                                                                                           
## Census Tract 1.02, Durham County, North Carolina 218 +/- 90                                                                                                                                                                                                          
## Census Tract 2, Durham County, North Carolina    201 +/- 122                                                                                                                                                                                                         
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: Male householder, no wife present 
## Census Tract 1.01, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                                                              
## Census Tract 1.02, Durham County, North Carolina 97 +/- 69                                                                                                                                                                                                                                             
## Census Tract 2, Durham County, North Carolina    67 +/- 81                                                                                                                                                                                                                                             
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: Other family: Female householder, no husband present 
## Census Tract 1.01, Durham County, North Carolina 91 +/- 50                                                                                                                                                                                                                                                  
## Census Tract 1.02, Durham County, North Carolina 121 +/- 65                                                                                                                                                                                                                                                 
## Census Tract 2, Durham County, North Carolina    134 +/- 98                                                                                                                                                                                                                                                 
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: With children under 18 years: Nonfamily households 
## Census Tract 1.01, Durham County, North Carolina 0 +/- 12                                                                                                                                                                                                                   
## Census Tract 1.02, Durham County, North Carolina 27 +/- 36                                                                                                                                                                                                                  
## Census Tract 2, Durham County, North Carolina    0 +/- 12                                                                                                                                                                                                                   
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: 
## Census Tract 1.01, Durham County, North Carolina 667 +/- 110                                                                                                                                                                                         
## Census Tract 1.02, Durham County, North Carolina 1043 +/- 154                                                                                                                                                                                        
## Census Tract 2, Durham County, North Carolina    721 +/- 119                                                                                                                                                                                         
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: Married-couple family 
## Census Tract 1.01, Durham County, North Carolina 181 +/- 66                                                                                                                                                                                                                
## Census Tract 1.02, Durham County, North Carolina 206 +/- 75                                                                                                                                                                                                                
## Census Tract 2, Durham County, North Carolina    142 +/- 75                                                                                                                                                                                                                
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: 
## Census Tract 1.01, Durham County, North Carolina 91 +/- 60                                                                                                                                                                                                         
## Census Tract 1.02, Durham County, North Carolina 66 +/- 45                                                                                                                                                                                                         
## Census Tract 2, Durham County, North Carolina    3 +/- 7                                                                                                                                                                                                           
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: Male householder, no wife present 
## Census Tract 1.01, Durham County, North Carolina 46 +/- 50                                                                                                                                                                                                                                           
## Census Tract 1.02, Durham County, North Carolina 29 +/- 31                                                                                                                                                                                                                                           
## Census Tract 2, Durham County, North Carolina    0 +/- 12                                                                                                                                                                                                                                            
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: Other family: Female householder, no husband present 
## Census Tract 1.01, Durham County, North Carolina 45 +/- 32                                                                                                                                                                                                                                                
## Census Tract 1.02, Durham County, North Carolina 37 +/- 30                                                                                                                                                                                                                                                
## Census Tract 2, Durham County, North Carolina    3 +/- 7                                                                                                                                                                                                                                                  
##                                                  Receipt of Food Stamps/SNAP by Presence of Children Under 18 Years by Household Type for Households:  Household did not receive Food Stamps/SNAP in the past 12 months: No children under 18 years: Nonfamily households 
## Census Tract 1.01, Durham County, North Carolina 395 +/- 110                                                                                                                                                                                                              
## Census Tract 1.02, Durham County, North Carolina 771 +/- 157                                                                                                                                                                                                              
## Census Tract 2, Durham County, North Carolina    576 +/- 122

For 2013 you will receive warnings, that is okay.

Missing values

Explanation of Symbols:

An ** entry in the margin of error column indicates that either no sample observations or too few sample observations were available to compute a standard error and thus the margin of error. A statistical test is not appropriate.
An - entry in the estimate column indicates that either no sample observations or too few sample observations were available to compute an estimate, or a ratio of medians cannot be calculated because one or both of the median estimates falls in the lowest interval or upper interval of an open-ended distribution.
An - following a median estimate means the median falls in the lowest interval of an open-ended distribution.
An + following a median estimate means the median falls in the upper interval of an open-ended distribution.
An *** entry in the margin of error column indicates that the median falls in the lowest interval or upper interval of an open-ended distribution. A statistical test is not appropriate.
An ***** entry in the margin of error column indicates that the estimate is controlled. A statistical test for sampling variability is not appropriate.
An N entry in the estimate and margin of error columns indicates that data for this geographic area cannot be displayed because the number of sample cases is too small.
An (X) means that the estimate is not applicable or not available.

Contributors: Thomas Robinson, Gjeltema