Andrew Ba Tran

Andrew Tran is the senior data editor for TrendCT.org at The Connecticut Mirror. Previously, he was a data producer for The Boston Globe Data Desk.

I get data (sometimes from FOIA requests and sometimes from scraping). I clean and analyze it, write stories with it and sometimes I visualize it or figure out ways to let others explore it.

I also taught a data journalism class at Central Connecticut State University.

I'm active at local data-related workshops, meetups, and hackathons. Sometimes I play around with Twitter bots (or write about them when I spot them doing something interesting out in the wild).

Lately, I've been trying to apply the best practices of data science to journalism. That includes making the data and scripts used to write a story open source and having clean documentation for reproducibility. I'm also kind of an R evangelist and I write packages for R that make my life easier and hopefully for others, too.

Pretty much I like working with cool people to make fun quirky stuff for news sites. Sometimes, I go biking.

Projects - Filter by type

June 2016

TrendCT.org series on racial profiling in Connecticut

#story
#data
#charts
#maps
April 2016

Analyzing Connecticut’s Democratic primary results

#story
#data
#charts
#maps
May 2016

CT’s members of Congress report free trips here and abroad

#story
#data
#tables
Story
April 2016

Analyzing Connecticut’s Democratic primary results

#story
#data
#charts
#maps
April 2016

Sanders, Clinton campaigns ramp up ad buys before CT primaries

#story
#data
#charts
#maps
April 2016

Which neighborhoods have the highest risk of lead poisoning in CT?

#story
#data
#charts
#maps
April 2016

Drinking water violations across Connecticut

#story
#data
#maps
March 2016

TrendCT.org series on opioid overdoses in Connecticut

#story
#data
#charts
#maps
February 2016

Where Connecticut politicians spent their campaign money

#story
#data
#charts
#maps
January 2016

CT police fire stun guns at blacks, Hispanics at a higher rate

#story
#data
#charts
#maps
#tables
January 2016

What your neighbors are charging strangers on Airbnb to stay in their homes

#story
#data
#charts
#maps
December 2015

Mass shootings, legislation often spur gun purchases in Connecticut

#story
#data
#charts
September 2015

Which college is the best financial investment in Connecticut?

#story
#data
#charts
August 2015

How hot has it been in Connecticut this summer?

#story
#data
#charts
August 2015

Quiz: What correlates with traffic tickets per town?

#data
#charts
July 2015

Who gets off with a warning after a traffic stop in Connecticut?

#story
#data
#charts
#tables
July 2015

Minorities were disproportionately charged for drug possession in urban Connecticut

#story
#data
#charts
#tables
#maps
June 2015

Dunkin’ Donuts owns name rights to Hartford ball park, already owns New England

#story
#data
#charts
#maps
#tables
April 2015

Unlike in the cities, more police doesn’t mean less crime in suburbs

#story
#data
#charts
#maps
#tables
Story
March 2015

The most popular meet-up groups in Connecticut cities

#story
#data
#charts
#maps
February 2015

How bad was the commute on the Red Line after snow shut down the MBTA?

#story
#data
#charts
#maps
January 2015

How much did the I-93 protests hinder traffic?

#story
#data
#charts
#maps
#tables
January 2015

Social media analysis of the opposition to the Boston Olympics

#story
#data
#charts
#tables
November 2014

Mass. Pike traffic trends before Thanksgiving

#data
#charts
November 2014

Timelapse of results for Massachusetts gubernatorial race

#charts
#maps
#multimedia
November 2014

Running for Massachusetts governor: where candidates stand on issues

#data
#tables
October 2014

How much more will city councilors earn than those they represent?

#story
#data
#tables
#maps
October 2014

How much worse is Turnpike traffic thanks to construction?

#story
#data
#charts
#tables
#maps
September 2014

Diversity in ranks limited in Massachusetts police that need it most

#data
#charts
August 2014

Starbucks vs. Dunkin Donuts

#data
#maps
July 2014

City employees flaunt residency rules, live outside of Boston

#story
#data
#maps
June 2014

Mayor of Boston's hires have been mostly white males

#story
#data
#charts
June 2014

Squishify - Knight-Mozilla-MIT Hack Day

#hackaton
April 2014

A selfie at every Boston Marathon mile marker

#multimedia
October 2013

Cinemagraphs: People of Red Sox Nation and Cardinal Way

#multimedia
October 2013

Dreamschool Finder

#story
#data
#tables
#multimedia
June 2013

Coffee Week

#story
#data
#multimedia
April 2013

Dreamtown Finder

#story
#data
#tables

About me

I'm Andrew Tran, a data editor for TrendCT.org at The Connecticut Mirror who wears many hats in the newsroom. I like projects. It started out with a few offbeat data-driven projects on Boston.com that an unofficial team of us put together while juggling our normal jobs with different departments (A couple online producers, a data reporter, a news developer). In 2014, our bosses made us official by switching us over to BostonGlobe.com and calling us a data team. We've even got our own vertical and twitter account. In the spring of 2015, I became a data editor at The Connecticut Mirror. Read my resume.