Accidental Opioid-related deaths in CT and the importance of data cleaning

I'd like to call out one data set in particular that requires a little extra attention; explain some of the things we see in the raw data, and share some of my data cleaning steps. The data set I will be talking about is the Accidental Drug Related Deaths by Drug Type data set, sourced from the Connecticut Office of the Chief Medical Examiner, accessed via

Accidental Drug Related Deaths by ...

New Housing Data Portal

Today we are launching what is the beginning of a housing data portal:! This project began as a quest to understand the difference between multiple data sources for a particular indicator. The inquiry evolved into this new data portal focused on multiple sources of housing data. This housing data portal gives users the ability to explore, download, and analyze housing data in your town.

We examined the strengths and weaknesses of different ...

Support Open Data Legislation

On Monday, February 26th at 11am in Room 2A of the LOB, the General Administration and Elections Committee will have a public hearing for H.B. 5172, "An Act Concerning State Agency Data Management and Processes, the Transmittal of Town Property Assessment Information and the Suspension of Certain Regulatory Requirements." This legislation will codify the Open Data Executive Order #39.

When a new Governor is elected Governor Malloy's Executive Orders become obsolete. Therefore, we ...

Launch of the New CONNECT Dashboard

These dashboards display selected indicators by DCF region and for the state. In partnership with the Connecticut Network of Care Transformation (CONNECT) project, we are pleased to announce the launch of our new and improved CONNECT dashboards.

In the dashboard, you will find aggregated data on such topics as -- Juvenile Justice, Behavioral Health, and Education-- and then within each topic, indicator data by DCF region. For example, you can explore utilization of Birth to Three ...

What's new and upcoming: February updates

Dear Data Inspiration

Earlier this month, we issued a challenge to our users: show us your data! And we're not talking about the data you collect for your work. We want users to find the data in their everyday lives! Inspired by the Dear Data book and blog, we want to help our users find creative ways to explore data and share visualizations with other users.

As promised, we have an example of a Dear Data visualization ...

Are the Outcomes of Stops Different Across Racial Groups?

This is a re-release of the original post from November. The diagram below now includes Hispanic drivers. When distinguishing between Hispanic and Non-Hispanic drivers, you can observe a more accurate representation of the population across Connecticut.

In this data story, we explore the outcomes of traffic stops. Is there a difference by race in the issuance rate of warnings, tickets or some other outcome? In particular, is there a difference by race in terms of ...

We've got a project for you! Join us for a monthly Dear Data challenge!

The Dear Data project started as collaboration between Georgia Lupi and Stefanie Posavec. Both Lupi and Posavec have connections to data visualization through information and graphic design and they decided to embark on a project that brought them together as friends: collect data on an aspect of their lives every week and make a hand drawn visualization. Then, send the visualization by snail mail to their friend.

It was an exercise in observation and creativity ...

Income Leaving CT? Not really — Understanding IRS Migration Data

I'm republishing this blog post that I originally published in June 2016. IRS migration data continues to be misinterpreted and assumptions made that are not entirely accurate as seen in today's Hartford Courant editorial section. This content is still relevant and worth republishing.

Earlier this week, I received an email from The Yankee Institute with the subject: “Leaving Connecticut” and I let out a sigh. The flurry of data around migration patterns in ...

It's a happy new year for CT Data!

It has been a productive 2017 for the Data Collaborative. We have been busy liberating data and bringing our CT Data Academy workshops to data users across the state. Check out our 2017 Annual Report for a summary of our progress and products!

Subscribe to our newsletter to stay in touch and to hear about upcoming workshops and events:

annual report pg1

annual report pg2

Page 2 of 6