Tracking gunshots, homicides — and public drinking arrests in Hartford

Print More

Among the most interesting users of Hartford’s new data portal has been Kerri Provost at And this week, she took a look at crime in the city, mapping out incidents in the same time frames in 2014 and 2015.

She’s looked at:

Kerri asked us for advice on what tools to use for her visualizations and we pointed her toward CartoDB. We look forward to seeing more data analysis from — but, in the meantime, you should bookmark her site.

And while we’re on that topic: If you’re in Connecticut and working with data, let us know. We’d love to help or show off your work.

Shootings in Hartford timeline via

On to some other data projects we’ve spotted this week:

  • Facebook is the top source for political news among Millennials, according to a report from Pew Research on how young people get their news. [Report]
  • An analysis on what jobs tend to lean more Democrat or Republican [VerdantLabs]
  • Where and how the government can execute people [NPR]
  • Which metro areas have gained the most jobs since the Recession? [PewResearch]
  • The Guardian started a new initiative to track people killed by police in the U.S. [Interactive|Data]
  • FiveThirtyEight did its own analysis using The Guardian’s police data. They located the census tracts of each incident to look at the demographic and economic context of each shooting. [Story]

Lastly, just a reminder: There’s a hackathon happening on Saturday and Sunday. If the word ‘hackathon’ scares you, check out this interesting discussion on TrendCT earlier this week.

What do you think?