Beaver County Times (Penn.)
Star Tribune (Minneapolis, Minn.)
Essential Twin Cities Guide: We put together this digital guide for visitors coming to Minneapolis for the Super Bowl. Led by newsroom developer Alan Palazzolo and digital designer Anna Boone.
Find the hottest Twin Cities housing markets of 2017: Data editor MaryJo Webster calculated a custom index of hot housing markets in the Twin Cities, which data reporter Jeff Hargarten later visualized and turned into a tool for readers.
Minnesota Picks the Super Bowl: Digital designer Rahul Mukherjee, alongside reporters from the sports staff and across the newsroom, collected Super Bowl predictions from prominent Minnesotans and displayed them in this nifty layout.
The North Score: Did you know the Star Tribune has an entire beat focused on sports analytics? You should find reporter Chris Hine here at the conference and ask him about it.
Where to watch the Vikings when you’re not in Minnesota Matt DeLong, C.J. Sinner and Jeff Hargarten compiled and organized this tool for Minnesota expats who were looking for bars to watch the Vikings/Eagles NFC championship game.
Bozeman Daily Chronicle
I called every bar in my paper’s gentrifying college town to calculate the average price of a draft microbrew. And then I did it again a year later so I could publish an inflation index.
Also, for a separate cost-of-living project, I coded a React-based interactive calculator that readers could use to estimate a living wage for their family.
The Seattle Times
- For this story, we wanted to tell the story of the Profanity Peak wolf pack as a 3D visualization. I’ve written a little bit about the making of this project here, but basically we merged multiple DEM files into a single heightmap, saved that out as the red channel of a JPG, added wolf range data to the blue channel, then loaded that into a custom WebGL renderer for display.
Seven Days newspaper (Vermont)
- Vermont is a small state with a large tourism industry, so we wondered how home-sharing apps were altering the landscape. I figured out how to get point-in-time Vermont listings from the site, which let us look at the distribution across the state. We expected to see the most listings in Burlington, our biggest city, but it turned out listings in the tiny ski towns were off the charts.
Arizona Center for Investigative Reporting
- In 2016, AZCIR designed and executed the automated twitter account @AZDarkMoneyBot, which sent tweets containing information about state-level “Dark Money” campaign finance filings in as close to real time as the state’s campaign finance laws allowed. This required us to write some code to parse emails, store data, fetch filings with a headless browser, read them as PDFs, re-store new data, then arrange and send the data to the twitter account. We will be running it this year, but because of changes in reporting laws made in the middle of the 2016 election cycle (🤔), these filings are no longer made in real time, but instead, at regular quarterly-ish reporting intervals. Obviously, this hinders the utility of our twitter account, but hopefully it will also serve to demonstrate what campaign finance laws actually mean for the public, in terms of transparency.
Although CBC is a large public broadcaster in Canada, I work out of the Montreal English newsroom, which is like a small town newsroom. We put out a few data-driven pieces that we’re proud of recently.
Using a calendar map (like GitHub’s activity graph) to show extreme cold days over 40 years
The Spokesman-Review (Spokane, Wash.)
A series we started working on after the election and dropped the day of the first travel ban. The relevant part is the news game where you can try to immigrate to the U.S. based on actual visa data
Not the most exciting data work, but a fun topic, looking at roadkill salvage in WA and ID. Map by me in Mapbox with no prior experience.
ABC10 (KXTV-TV, Sacramento, Calif.)
N.J. Advance Media
Basically, I built a scraper that scrapes all four major utility companies in New Jersey every 15 minutes and showcase the number of people who are experiencing power outages in a series of charts and graphics. It is embeddable, but also lives in its own project page. Note: This is Phase 1 of the project. Phase 2 involves scraping town-by-town and ETA estimates. There will also be a quick load version for people who are experiencing power outages.
- We took blockgroup data from FEMA and property data from Harris County. I rolled up the property data to those blockgroups and used the resulting analysis to direct reporters to areas with a history of flooding but lots of new construction. Also overlaid property data with federal floodplain shapes to show billions in development in the the most dangerous areas.
The Chicago Reporter
- We created this interactive to help community members, political leaders, and other journalists track the progress the city is making on the recommendations for police reform made by the DOJ. This project was done by 3 people: a reporter (myself), a developer (Geoff Hing) and an editor (Matt Kiefer).
- This election guide combines FEC, Inside Elections race rating and newsroom reporting to present a definitive guide to all the elections taking place in 2018.
DATUM (Vienna, Austria)
Academic collaborations: Are there gender-biased networks in academia? I.e. Is there a tendency for men to work with men and women with other women?
The Chicago Reporter
Chi Census: compiles Census data from tracts into community areas (neighborhoods)
N.J. Advance Media