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.
# install.packages('acs')
suppressPackageStartupMessages(library("acs"))
## Warning: package 'acs' was built under R version 3.1.3
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
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.
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