Your Schools database II
Database of school-level data allowing easy comparison to similar schools and schools statewide on a number of important metrics.
Visit: https://schools.ctmirror.org
Built with: Django, D3, Pandas
Cartoon: How the hospital tax works
Cartoon explainer describes how hospitals once benefited from the state’s hospital tax, but those days are long gone.
Youtube: https://www.youtube.com/watch?v=eVZHH88SvlE Story: Hospital lawsuit no longer an obstacle to new CT budget deal Visit: https://projects.ctmirror.org/content/…
Built with: ToonBoom Harmony, iMovie
The growing, and srhinking of CT tax revenue
This visual was inspired by tree rings to show the year-to-year growth – and shrinking – of Connecticut tax revenue.
Visit: https://ctmirror.org/2017/04/27/ct-tax-revenue-in-free-fall-adding-1-1b-in-red-ink-for-next-2-years/
Built with: D3
Bailing out: D3 force illustration of pretrial outflow
This graphic uses d3 force simulation and scrolly story-telling to illustrate the number of people let out on bail at each pretrial phase in Connecticut.
Visit: https://projects.ctmirror.org/content/…
Built with: D3, graph-scroll
CT Election Headquarters
As far as I know, this was the most comprehensive election liveblog of any news outlet in the state of Connecticut.
Since we don’t have an AP subscription, I found an undocumented way of extracting live election results from the Secretary of the State’s then-new election results portal in real-time. We had live results from the presidential, Senate and Congress races, as well the state legislature races, with the ability for our chief political reporter to manually call elections for any candidate in the system.
In addition to major races, I created a ballot page that shows the results of every item on every ballot in every town in Connecticut, down to races for treasurer, registrar, and even positions that only exist in a few towns, such as representative town meeting (“RTM”) seats.
Visit: https://blogotron.ctmirror.org/election-2016/page/state-house/
Built with: Django, D3, deployed to AWS Lambda/S3 and then later migrated to Heroku.
Guess the risk posed by defendant X
This graphic uses a reader-challenge to illustrate the state’s pretrial risk assessment in more concrete terms.
Visit: https://trendct.org/2017/02/22/in-connecticut-a-formula-helps-make-bail-decisions/
Built with: D3, typewriter-js
Would you make more in a different state? How far would that money go?
This app seeks to answer the question – would you be better off doing your job in another state? It compares location-adjusted income data for various occupations, and generates story copy dynamically based on the state and occupation you select.
Visit: http://occupation.trendct.org/
Built with: Django, D3
Visualizing foliage
This was a fun one – daily photographs from state park cameras to illustrate the changing season.
I built a scrubber, which each day indicated by a thin rectangle whose color was based on the most dominant color of that day.
Colleague Andrew Ba Tran computed the most dominant colors and I built the web interface.
Visit: https://projects.ctmirror.org/…
Built with: D3
Cops, stops and race
This was an ambitious blog and database combiantion, with profile pages for traffic stop data for three levels – statewide, police department-wide, and individual officer stats.
Visit: http://trafficstops.trendct.org/data/
Built with: Django, Highcharts, D3
Presidential contributions database
This database contains individual presidential campaign contributions from Connecticut residents during the 2016 election cycle.
In addition to retrieving the individual contribution records, this database offers useful transformations – you can group contributions by town, candidate, contributor occupation and view summaries for each grouping.
This was an ambitious feature set, but I think most users did not realize how or why to use these transformations.
Visit: https://trendct.org/2016/02/09/new-database-campaign-contributions/
Standalone: https://projects.ctmirror.org/content/…
Built with: PHP, MySQL, datatables