Hartford-Area Habitat for Humanity has Expanded Construction Outside Hartford Over Time

by Myrian Ayala and Emma Wellins

Last updated on 12/09/2021

for Data Visualization for All
with Prof. Jack Dougherty
Trinity College, Hartford CT, USA



Story


Since 1989, Hartford-Area Habitat for Humanity has been building affordable homes in the city of Hartford and outlying areas. One challenge the organization continually faces is finding land they can purchase and obtain permission to build affordable homes, since some suburban towns have resisted housing for low-income residents. Therefore, we wanted to investigate where Hartford-Area Habitat for Humanity has built homes in North Central Connecticut over time. In order to do this, we were required to collect and visualize data illustrating the build year of the 249 homes that Habitat provided to us in a spreadsheet. From there, we could place these homes in the context of Habitat’s expansion within Hartford as well as outlying towns across a three-decade time span. Through collaboration with our Habitat for Humanity partners, they shared their goal of expanding their reach beyond the city of Hartford, and our data collection and visuaizations present the extent at which they have.

Keeping Habitat’s goal in mind, we have made two charts that provide both a summary that speaks more directly to Habitat’s expansion in North Central Connecticut over the decade as well as Habitat’s data organized by location and corresponding decade of construction.

The following column bar chart examines the percentages of where Habitat built homes by decade. Although we can observe that this chart demonstrates that the majority of Habitat homes built reside in Hartford, we can also see that the percentage of Habitat homes in outlying towns has slowly increased over time.

Figure 1: This chart displays Hartford-Area Habitat for Humanity percentage of homes built by decade in Hartford and outlying towns. This chart was created with Datawrapper. Explore the interactive version

Below, you may see the total numbers of homes built by Hartford-Area Habitat for Humanity for each decade which were used to create the chart above.

Location Pre-2000 2000-2009 2010-present
Hartford city 27 90 61
Outlying areas 3 35 33
Total 30 125 94

Table 1: Numbers of homes built by Hartford-Area Habitat for Humanity in Hartford.

The majority of the data provided by our Habitat parners are of addresses in Hartford--178 out of 249 total addresses--so in order to represent the addresses that lie outside of Hartford, we created a bar chart that provides the number of Habitat homes built in each town by decade, illustrated with colors that correspond to the decade in which they were built. With this visualization, the distinctions between outlying towns become clearer. New Britain stands out as the town that Habitat has done the most work in other than Hartford, which is reasonable given New Britain’s geographic proximity to Hartford. Additionally, New Britain has the largest population of all outlying towns. It is reasonable that Habitat would pursue construction in larger towns given their tendency to work in more population-dense areas such as Hartford.

Figure 2: Numbers of homes built by Hartford-Area Habitat for Humanity in outlying areas by decade. This chart was created with Datawrapper. Explore the interactive version

To have a better understanding of where these 249 Habitat homes are located, we decided to create an interactive choropleth map for each decade. Each map displays the name and the estimated number of homes built in each town. The dark blue represents greater amounts of homes built in a designated town, while the lighter shades represent the presence of fewer Habitat homes in a given town. For example, the dark blue represents the city of Hartford since the largest number of homes in each decade are found in Connecticut’s capital. Towns that appear in gray indicate where Hartford-Area Habitat for Humanity has not built any homes in that location.




Data

To find the 'year built' and/or 'year sold' for the given homes, students Emma Wellins and Myrian Ayala searched the town government's property record databases and Jack Dougherty double-checked our data for accuracy. During the data collection process, there were several addresses whose build years could not be easily identified using the assessor databases found below. Through communication with our Habitat partners as well as more in-depth research, we attempted to identify the build years of as many challenging addresses as possible in order to have the most accurate and complete set of data to visualize.

Hartford Assessor Database
Bloomfield Assessor Database
Bristol Assessor Database
East Hartford Assessor Database
Enfield Assessor Database
Farmington Assessor Database
Glastonbury Assessor Database
Granby Assessor Database
Manchester Assessor Database
New Britain Assessor Database
Plainville Assessor Database
Suffield Assessor Database
Vernon Assessor Database
Windsor Assessor Database

Within each area's assessor database, we searched by house number and street, then viewed PDF's of the provided property records to identify the year built or sold by Habitat and we added to the shared database spreadsheet created.

Credits

Myrian Ayala and Emma Wellins, along with help from classmates Nassar Abdelrahman and Nolan McKenna, shared a spreadsheet that contained each of the 249 Habitat addresses and evenly split the search for year built/sold dates, and Jack Dougherty supervised and double-checked their data collection for accuracy.

Hands on DataVisualization book written by Professor Dourgherty and Independent Technologist Ilya Ilyankou: https://HandsOnDataViz.org

Datawrapper, an open-source tool used to create interactive charts.

MIKE SWIFT Courant, Staff Writer. "Housing for Needy may be Built at Former Poor Farm in Simsbury." The Hartford Courant (1923-), Jun 03, 1989. http://ezproxy.trincoll.edu/login?url=https://www.proquest.com/historical-newspapers/housing-needy-may-be-built-at-former-poor-farm/docview/1638179800/se-2?accountid=14405