Demographics of Oglala Lakota County

The Keystone Pipeline is an oil pipeline running from the Canadian Tar Sands in Alberta to the Gulf Coast in Texas. The plan for the fourth phase of this project proposes to run a new section of this pipeline under the Missouri River, just upstream of the Oglala Lakota sacred land. The Lakota people rely on this river for their livelihood. In the wake of the Flint, Michigan crisis, the main concern of locals is possible contamination of the water. The implications would be catastrophic leading to the inability to use the river to fish, irrigate crop land or even have clean water to drink.

This map visualizes 2 sets of data obtained from the US Census Bureau on family income and minority populations. The 2 maps show striking similarities. Upon some calculations and research into the maps it was quite apparent that the Oglala Lakota County had the highest percent minority population of any county in the entire United States. Oglala Lakota County also has the 3rd lowest mean family income in the country. It is one of three counties in the United States completely encompassed by a Native American reservation. The Lakota tribe considers the Missouri River sacred since it has been the tribes main source of life since they inhabited the land nearly 1200 years ago.

-Cody J. Crane

UConn MAGIC 2017

Change in median household income within U.S. counties between 2004-09 and 2010-14 American Community Surveys

This visualization compares county-level median household income from the 2004-2009 and 2010-2014 American Community Survey 5-Year Estimates and compares the confidence intervals of the surveys to determine whether there was a significant increase or decline in median household income between the surveys, or no statistically significant change. Estimates from the 2004-2009 survey were converted to 2014 inflation-adjusted dollars using the Bureau of Labor Statistics’ ‘Consumer Price Index – All Urban Consumers‘ benchmark. These adjusted figures were compared with the median household estimate from the 2010-14 ACS (which were originally published in 2014 inflation-adjusted dollars).

Counties with inflation-adjusted median household income estimates with overlapping margins of error between the two surveys (when both survey estimates are expressed in 2014 inflation-adjusted dollars) are considered not to have experienced a statistically significant change in median household income between the survey periods. Counties which have an upper bound of the 2004-2009 confidence interval which is smaller than the lower bound of the 2010-2014 confidence interval, are considered to have had a statistically significant increase in median household income between the two survey periods. Conversely, those counties which have a lower bound of the 2009-2014 confidence interval which is greater than the upper bound of the 2010-2014 confidence interval are considered to have experienced a statistically significant decline in median household income.

The American Community Survey data showed statistically significant increase in median household income in 88 counties between these survey periods; 2,378 showed no significant change, and 677 a statistically significant decrease in median household income. Notably, the majority of the U.S. population lives in the counties that showed a significant decrease in household income: according to the 2014 ACS population figures, about 202 million people – 64% of the U.S. population – resided in these 677 counties.

Note that this visualization’s inflation adjustment uses national level Consumer Price Index, which may not reflect inflation differences that exist across geographies or regional differences in housing, transportation, or other sectors. The American Community Survey confidence intervals used here are the originally published data, which was reported at a 90% confidence interval.

Census Tracts Data Browser updated with latest American Community Survey Data

The map below of Connecticut Census Tracts data provides links into the Census Bureau’s American FactFinder data engine to gain easy access to tables of economic, housing, demographics and other data from the 2010-14 American Community Survey 5-Year Estimates. Hover over any Census Tract on the map to see links to eight data tables for the tract. You can use the map tools to pan or zoom into a particular area of the state, and by holding down Control (Command on a Mac), you can select multiple tracts and follow the links to see data for all selected areas. See the Instructions tab for more information.

Linked data tables include:

  • DP05 ACS Demographic and Housing Estimates: age, race/ethnicity, and housing unit counts
  • S1501 Educational Attainment: educational attainment and median earnings by level of education for the population age 25 and over
  • S2701 Health Insurance Coverage Status: insurance coverage rates by age, race, and income
  • S1101 Households and Families: characteristics of household structures
  • S1702 Poverty Status in the Past 12 Months of Families: poverty status by age, race, educational attainment, and presence of children in the household
  • DP03 Selected Economic Characteristics: unemployment, occupation,  employment by industry, and income and benefits data
  • DP04 Selected Housing Characteristics:  size, value, age, and other characteristics of housing units in the tract
  • DP02 Selected Social Characteristics: includes marital status, fertility, place of birth, language spoken at home, ancestry, and disability status characteristics of the tract’s residents

American Community Survey Median Household Income Distressed Tracts 2010 to 2013

This visualization uses data from the American Community Survey to display distressed census tracts, which is a tract at 60% or less of the state median household income level. This study ranges from the year 2010 to 2013.

by: Zachary Guarino


Connecticut Census Tract Data Browser for American Community Survey Data

Census Tracts, statistical areas of roughly three to seven thousand individuals, are the smallest practical geography for analysis using American Community Survey estimate data. In Connecticut many smaller towns have a single Census Tract, while larger cities can have more than a dozen.The Census Bureau’s American FactFinder data tool provides more than 3,500 different tables of data from the American Community Survey for Census Tracts on a wide range of topics. While the organization, documentation, downloading capabilities of American FactFinder are extremely sophisticated, it can be difficult to identify and select particular Census Tract for analysis – say, those in the northern portion of Hartford – without already being familiar with the boundaries of the tracts. (While this can be done using the Reference Map interface in American FactFinder, it is a fairly cumbersome process).

The shaded map of Census Tracts below allows the user to select single or multiple tracts for analysis, and takes advantage of the deep linking capabilities of American FactFinder.  By holding down the Control key, multiple tracts can be selected with the mouse. The links to demographic, economic, and other data which then appear in the mouseover ‘Tooltip’ menu can be a starting point for exploring additional data for the selected tracts, because the geographies chosen remain selected in the resulting American FactFinder session. Upon following the link in the Tooltip to a table in American FactFinder, click the Advanced Search tab above the table to return to the American FactFinder search screen, to browse among the thousands of tables of data for the tract(s), using a keyword search or the Topics menu.

Gini Index of Income Inequality for U.S. Counties

This visualization displays U.S. Census Bureau American Community Survey Gini index estimates for U.S. counties.  The Census Bureau defines the Gini index as “a statistical measure of income inequality ranging from 0 to 1. A measure of 1 indicates perfect inequality, i.e., one household having all the income and rest having none. A measure of 0 indicates perfect equality, i.e., all households having an equal share of income.” For an analysis of the ACS Gini index data, see the Census Brief: Houshold Income Inequality Within U.S. Counties.

The visualization allows the viewer to filter the counties displayed on the map by Gini index. Links into American FactFinder from the mouseover Tooltip for each county on the map provide further economic data including median household income, poverty, and insurance coverage data for the county.


Educational Attainment, and Earnings by Educational Attainment & Gender, in Connecticut Towns

The map and graphs below provide information on levels of educational attainment among Connecticut towns, along with data on median earnings by town for men and women having various levels of education. The data on education and income are tabulated only for those age 25 and over. The American Community Survey defines educational attainment as “the highest level of education completed in terms of the highest degree or the highest level of schooling completed.”

The data below are taken from Table S1501 the 2008-12 5-Year Estimates data release of the American Community Survey. The complete data for the state and all towns can be downloaded here.

For help with locating data on Connecticut from the American Community Survey or other Census Bureau program, please contact the Connecticut State Data Center.

Educational Attainment for the Population Below the Poverty Level in Connecticut Towns (American Community Survey 2008-12 5-Year Estimates data)

The recently-released ACS 2008-12 5-Year Estimates data provide updated estimates for all Connecticut towns, including detailed data on the population living below the poverty level. The visualization below uses data provided by the ACS on the educational attainment of those age 25 and older in poverty, providing details on the percentage of this population which has less than a high school diploma or GED, a high school degree or equivalent, some college credits or an associate degree, or a bachelor’s degree or higher. The map focuses on the percent of those in poverty in each town who hold a bachelor’s degree or higher. By selecting any town on the map, the bar graphs beneath will display more detailed educational attainment data for the town, both for the general population and those below the poverty threshold.

The American Community Survey uses poverty thresholds established by the Office of Management and Budget; more information is available here. It’s important to note that these thresholds do not vary geographically; for example, the same poverty threshold for a household consisting of a single adult with a related child under 18 ($15,504) is used in every state.

Median household income by Census Tract (American Community Survey 2008-12 5-Year Estimates data)

With the Census Bureau’s recent release of the 2008-12 5-Year Estimates data from the American Community Survey, new economic, social and demographic data are available for all Connecticut cities and towns, as well as smaller geographies such as school districts and Census Tracts. The visualization below uses household income data from the new ACS release to display median household income by Census Tract. Clicking any tract on the map will bring up a bar graph illustrating income distribution within the tract; links in the tooltip allow the user to explore more of the new data from the American Community Survey for the tract.