Crash (with City of Hartford) and Trash (with Center for Leadership and Justice)
For our Crash projects, Grace Yi (Senior Planner, Bike & Ped) and Owen Deutsch (Principal Planner), from the Planning Division, City of Hartford, asked us to help visualize answers to this question: When and where are the highest frequency of motor vehicle crash injuries and fatalities in Hartford, and what can we learn about traffic-calming measures?
Analyzing The Impact of Hartford’s Traffic Calming Installations by Keelyn McNamara (Teaching Assistant)
Has the Installation of Speed Humps on Flatbush Avenue Affected Crash Data? by Alison MacDougall & Caroline Lally
When Do Hartford Crashes Happen? by Theodora Tatsi
Which Hartford Corridors Have the Most Crashes? by Isaac Frank and Chris Horkan
Crashes at Major Hartford Intersections in 2018-2022 by Jess Cruz and Mia Rodriguez
For our Trash projects, Sarah McCoy from the Center for Leadership and Justice in Hartford has asked us to help visualize answers to this environmental racism question: Where does our trash go, whose neighborhoods are affected, and how much can we reduce solid waste?
Where Does Hartford Waste Go? by Rashaud Conway and Travis Martin
Environmental Racism in Hartford County by Rachel Kim and Liv Crowley
Note: Two students below were assigned to explore patterns in 2021 CT DEEP Municipal Solid Waste town-level data estimates, which includes many questionable outliers marked in yellow in the instructor’s spreadsheet.
Where Most of Our Recycling Comes from Near the Hartford Area by James Yarussi
The Relationship Between Waste and Recycling in Connecticut by Colin Hedge
Center for Leadership and Justice (CLJ) and Education Funding Inequities
Our partners at CLJ asked us to help them analyze and visualize student residency and school district funding for their Greater Hartford Interfaith Action Alliance (GHIAA) Education Research team. We defined the metro Hartford area as a contiguous 33-town region, which includes 38 public school districts when counting magnets and charters. Also, we appreciate expert guidance on Connecticut education funding provided by the School + State Finance Project.
Exploring the Relationship Between School Type and Per-Student Spending, by Keelyn McNamara
What is the Relation Between Racial & Ethnic Enrollment and Per-Student District Spending? by Liam O’Connor and Ben Bejoian
Where are High-Needs Students in the Hartford Region? by Natalie J. S-G
How Has Enrollment Changed in Towns and School Types from 2016-2022? by Faris Matraji
The Changes in Student Population and Per Pupil Expenditure in Hartford Region by Robert E. Groebel IV and Shayla Whitaker
Locating Our Schools by Julianna and Viv
Sheff v O’Neill 2022 School Integration Settlement
Since several students who completed the DataViz For All course later enrolled in my Educ 308: Cities Suburbs and Schools course, we worked together on another community-learning partnership. Our mission was to communicate the goals of the January 2022 Sheff v. O’Neill school integration settlement to broad audiences. Students designed and revised five data visualizations based on feedback collected from individual members of the Sheff Movement, and published final versions in this May 2022 story by Jacqueline Rabe Thomas for CT Public Investigative News.
CT Coalition Against Domestic Violence (CCADV)
Our partners at CCADV asked us to help them analyze and visualize the first two years of de-identified data from CTSafeConnect.com, a new statewide hotline for people requesting help regarding intimate partner violence. To protect confidentiality, CCADV created a masked dataset with 50,000 rows of individual contacts between clients and staff, which we masked further by aggregating into 15 regions that resemble local service areas for use in students’ data stories.
Additional data stories:
Racial Demographics of Callers to CT Safe Connect, by Daisy Li
CT Safe Connect Repeat Callers by Demographics and Services, by Alberlis Hernandez
Where are CCADV’s frequent callers and what do they want?, by Archana Adhikari and Azka Hassan
CCADV Support Services Across Connecticut, by Burke Hinton and Jeff Pendergast
CT Safe Connect Minutes Spent Per Region, by Chris Perry and Lachlan Berry
Is Regional Income Linked to CT Safe Connect Calls?, by Ryan Wiley
White CTSafeConnect Contacts Based on Region and Population Density, by Timothy Hall and Peter Keigher
CT SafeConnect’s Services Provided and Last Instances, by Michael Kulik and Jack Impronto
Center for Leadership and Justice (CLJ) and #NoMoreSlumlords
Our partners at CLJ asked us to help them analyze and visualize data related to their Greater Hartford Interfaith Action Alliance (GHIAA) organizing and their #NoMoreSlumlords campaign for stronger housing code accountability by the Hartford city government.
DataVizForAll students at Trinity cleaned and geocoded CLJ data for this map. View full-size version.
Hartford Housing Legislation and When Neighborhoods Will Be Impacted by Elizabeth “Bonnie” LaBonte and Lachlan Clark
Who Are the Largest Hartford-Based Apartment Owners?, by Steven Ramsden
Hartford Housing Cases, by Ifham Majeed and Greg Linton
Hartford Area Habitat for Humanity and Housing
Our partners at Hartford Area Habitat for Humanity asked us to help them compile and visualize data on the 250 homes they constructed or fully rehabilitated in the region since 1990.
DataVizForAll students at Trinity compiled, cleaned, and geocoded Habitat data for this map. View full-size version.
Hartford-Area Habitat for Humanity has Expanded Construction Outside Hartford Over Time by Myrian Ayala and Emma Wellins
Neighborhoods Where Hartford Habitat Has Built Homes And Why It Matters: Examining Opportunity and Income in Census Tracts by Victoria Asfalg and Riley Nichols
Where has Habitat been building homes and why does this matter? by Theodore Komjathy