The visualization below highlights Census Tracts with median household income less than sixty percent of statewide averages, according to American Community Survey data.
How does Connecticut heat up their homes during the cold seasons? There are numerous ways to provide heat for a home. This visualization shows the different types of heat sources and how many housing units use them for each Connecticut town. You can see trends in the data when looking at the maps. Towns with urban environments tend to use utility gas and kerosene as a source of heat. Rural and suburban towns tend to use liquefied petroleum gas or wood as heating sources. Surprising data I found is that some homes use solar energy for heat. There is not a lot of homes that use solar energy, but maybe the number will increase in the future as we adapt to more renewable energy. The data source is from the American Community Survey 5-year estimate from 2011 to 2015. This data visualization is for the 2015 year.
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
Our colleagues at the Center for Land Use Education and Research (CLEAR) have just announced the statewide, 2016, 3 inch aerial imagery is now available via the CT ECO Website! This imagery is available for use in a wide range of ways depending on the users need/application. Included below is an overview of the options available for viewing and downloading the 2016 Connecticut aerial photography:
- as a dynamic image service and a cached image service
- for download by tile (PLEASE use the download manager if you will be downloading more than a couple of tiles) and
- in the Aerial Imagery Viewer for viewing
Stay tuned for more options as town mosaics for download an all lidar products including DEM tiles, elevation image services and LAS files are made available from CT ECO and CLEAR.
The project was managed by the Capitol Region Council of Governments (CRCOG), on behalf of the Connecticut regional councils of governments, and funded by the Connecticut Office of Policy and Management (OPM) with contributions from the Connecticut Department of Transportation (DOT) and the Connecticut Department of Emergency Services and Public Protection (DESPP). The project management team includes municipal, regional, state and university representatives.
The following visualization explores poverty levels in Connecticut by township; as well as by educational attainment. The data is provided by the US Census Bureau through the American Community Survey 2015 5-year estimates (2011-2015). My goal in assessing this data was to observe trends of poverty in Connecticut, as it relates to education level, location, and gender. Through the visualization it can be observed that the highest pockets of poverty are found in Bridgeport, Hartford, New Haven and Waterbury. These cities have the largest populations in the state which also correlates to the largest numbers of poverty. There was a large discrepancy in poverty rates, in the category of gender. Females had a greater instance of poverty at 60% compared to males at 40%. In the category of education, individuals whose highest level of education was a high school diploma were found to have the highest occurrence of poverty. Contrary to popular belief, people who have some college/associates degree were in many cases, just as likely to be living in poverty as people who earned less than a high school degree.
The most effective way to utilize this dashboard is to view it for statewide trends or town data. If you are looking for information on a particular town in Connecticut, select that town in the table on the right. By selecting the town, the other charts and map will be updated to reflect information only for this town. If you would like to look at multiple towns at once you can select more than one by holding the control key (Windows) or command key (Mac) and selecting the additional town(s). It is important to note that by comparing multiple towns, the statistics will be a sum of all towns included.
Last week’s release of the 2011-2015 American Community Survey 5-Year Estimates by the U.S. Census Bureau provides new demographic and socioeconomic data for all Connecticut towns, including estimates of income, poverty, and workforce characteristics. One especially detailed table in this new dataset – made available by the American Community Survey since the program began – is DP03: Selected Economic Characteristics (see links appearing to the left of the table in American FactFinder to view data for previous years). Because the survey periods don’t overlap, the economic estimates published in the 2015 5-Year Estimates dataset can be compared with the 2010 5-Year Estimates data for evidence of change. The graphics below employ a calculation which determines whether town-level economic measures increased or decreased beyond the margin of error of the survey estimates, and illustrate these statistically significant changes between the 2006-10 and 2011-15 survey periods for several economic indicators.
For help with locating U.S. Census Bureau data for Connecticut, including American Community Survey data, please contact the Connecticut State Data Center.
This data looks at trends in the maximum level of education attained in Connecticut for residents over the age of 25 from 2010 to 2015. Across the state, the percentage of peoples who have achieved less than the equivalent of a high school education is much lower than those who have. Additionally, the percentage of people who have some college education but no degree or who hold an Associate’s degree is much lower than the percentage of those who hold a Bachelor’s degree. From 2010 to 2015 there is an increase in Graduate or Professional degrees earned and a subsequent decrease in the percentage of people who hold only Bachelor’s degrees. Urban areas such as Hartford, New Haven, and Bridgeport are more likely to have lower rates of degree attainment. Attainment of education beyond a high school diploma or its equivalent is less prevalent in the eastern part of the state while the southwestern part of the state has higher percentages of people who have obtained either their Bachelor’s or a Graduate degree. From 2010 to 2015, many towns saw increases in higher education attainment and decreases in the relative percentages of people who have not attained an education beyond the high school level.
The following visualizations showcase health insurance trends across New England since 2009 for people aged 18-24. The data is provided by the U.S. Census Bureau through the American Community Survey 1-Year Estimates for 2009 – 2015. 2009 is a great starting point for any analysis concerning health insurance trends given that the Affordable Care Act did not come into effect until after March 2010. For this post, I decided to explore insurance trends for the age group 18-24, due to one of the main aspects of the Affordable Care Act being that an individual can stay on their parents health insurance until age 26.
- Massachusetts seems to be in a category of its own with enrollment above 90% for every year between 2009-2015. It is worth considering the effects and legacy of the Massachusetts health care reform of 2006.
- Rhode Island had only 76.37% of its population aged 18-24 covered with health insurance in 2009. Enrollment would eventually increase by 15.35% between 2009 and 2015, all the way to 91.72% coverage.
- Rhode Island went from being the New England state with the lowest health insurance enrollment in 2009, to being the state with the third highest enrollment by 2015.
- Massachusetts and Vermont having the highest health insurance enrollments for age group 18-24 in New England interestingly corresponds with these states being considered the most ‘liberal’ states in the U.S. according to a Gallup poll. A quick comparison across the continental U.S. and Puerto Rico shows that this holds true for not just New England, but also for the entire nation as of 2015.
- Going on a similar direction as note #3, Maine and New Hampshire are the most conservative New England states according to the same Gallup poll, and they also happen to be the ones with the lowest health insurance enrollments for this particular age group inside New England.
- Vermont experienced a noteworthy increase in enrollment of 7.17% between 2010 and 2011.
- How did the 2007-2010 recession impacted Health Insurance enrollment for this particular age group? Although the states of Connecticut, Massachusetts, New Hampshire and Rhode Island experienced drops in health insurance enrollment just by looking at the percentages displayed in the visualizations, none of them had a drop of more than 2%; so effectively all drops in health insurance enrollment between 2009-2010 are covered by the margin of errors for the data corresponding to each state.
- Between 2009-2015, all of the New England States saw increases in health insurance enrollment for this particular age group.
Minor correction by the author: Observation #6 initially implied that Vermont’s increase in health insurance enrollment for age group 18-24 between 2010 and 2011 could be attributed to a decrease in the estimated population for said group between those two years. That was a data misread. Vermont actually experienced a population increase of 1.4% between 2010 and 2011 – not a decrease. Therefore, Vermont’s increase in enrollment is actually noteworthy.
Health Insurance Coverage Status by Sex by Age: U.S. Census Bureau, 2009-2015 American Community Survey 1-Year Estimates, Table B27001.
The following visualization is a comparison of per capita income of different races of civilians within Connecticut and then taking a look at the occupations that lead to a drop or increase of capita of each race group. This information was obtained from the American Community Survey 2006-2015.
Descriptions of each occupational group:
Management- business and financial operations occupations, management occupations.
Computer Sci- computer and mathematics occupations, architecture and engineering, life physical and social science occupations.
Education- community and social service, legal occupations, education, training and library, arts, entertainment, sports and media.
Healthcare- health diagnostics, technologists, technicians, and health practitioners.
Service- healthcare support, protective service, food preparation and serving occupations. building and grounds maintenance, and personal care.
Sales- sales, office and administrative support.
Maintenance- farming, fishing, forestry, construction and extraction, installation, maintenance and repair.
Production- production, transportation, and material moving.
This visualization explores changes in the languages spoken at home in Connecticut counties over a five year period from 2011 to 2015.
In the last five years, much of Connecticut has seen a slow trend of decreasing English usage at home and an increase in other languages. Spanish is the most prevalent language spoken in Connecticut after English. Counties that are less populous have more limited lingual variation and have seen less growth in non-English language usage. Litchfield, Tolland, and Middlesex counties are the only counties where Spanish is not the most common non-English language spoken at home and is rivaled by the use of other Indo-European languages. These counties also have a very low percentage of people who speak a language other than English in comparison to the rest of the state. Most counties have seen a general increase in the use of Spanish at home, but other language groups have not displayed the same trends. Asian and Pacific Island languages showed a decrease from 2011 to 2013 and an increase from 2013 to 2015. Conversely, Indo-European languages saw increases from 2011 to 2013 and decreases from 2013 to 2015.
Windham county lacked language data for both 2011 and 2013 and had no data for 2015.