Travis Swicegood's real world data lessons from Texas Tribune

Travis Swicegood

Travis Swicegood, director of technology at  Texas Tribune, spoke this week at the latest Hacks/Hackers Chicago Meet-up about the challenges of working with public data — real world data, as Swicegood calls it.

There are plenty of challenges in collecting, managing and presenting data from a state the size of Texas — 26 million people, 254 counties, five major cities and a gross state economy of $1.2 trillion. Swicegood shared just a few of the challenges of managing and wrangling data:

“Data frequently, frequently, frequently disappears.”

Swicegood described “real world data” as being dirty and unpredictable. Despite those negative attributes, lost data is even worse. He has a copy of every dataset he works with at the Tribune — a habit he formed from after seeing data go missing from local locations as well as government websites. He also distinguished the Texas Tribune’s civic datasets from “big data.” While Tribune datasets may include millions of records, Swicegood noted data collections of, say, social media organizations are much larger and constantly growing.

“Making assumptions about the data is something that can get you in lots of trouble.”

Tribune beat reporters act as domain experts for data and in-depth “explorers.” The dedicated data folks might be best suited to manipulation and vizualization, but a beat reporter can help a developer understand datasets and explain apparent discrepancies. They've also got an ability to understand what makes them really interesting thanks to time on the beat.

“This is why more citizens don't grab big government datasets.”

Swicegood recounted the difficulties of collecting inconsistent school data from the 254 Texas counties for the Tribune's Public Schools Explorer. Not to mention the occasional 700-column wide CSV file and the reports from 141 agencies to compile the Tribune's famous state employee salary database.

Swicegood also shared his data tools and techniques for working with dirty, inconsistent data. He recommended analysts capture their calculations in scripts, document their data munging and use version control so their operations can be replicated when new data is released.

"Our CEO likes to say we're The Boy Who Lived."

The Tribune launched within months of two other non-profit news organizations, Chicago News Cooperative and Bay Citizen. Four years later Texas Tribune is the only one still running as originally envisioned — Chicago News Coop shut down in 2012, and Bay Citizen has partnered and rebranded a few times. Swicegood said the Tribune’s business model and focus on Texas (a state with plenty of wealthy donors) have helped it succeed.

“I like to say we're a technology company that produces a journalism based product.”

Texas Tribune has always been an online only publication. Swicegood’s slowly winning converts to his position … to the chagrin of some in the newsroom, he said.

About the author

Dan Keemahill

Undergraduate Fellow

Latest Posts

  • Prototyping Augmented Reality

    Something that really frustrates me is that, while I’m excited about the potential AR has for storytelling, I don’t feel like I have really great AR experiences that I can point people to. We know that AR is great for taking a selfie with a Pikachu and it’s pretty good at measuring spaces (as long as your room is really well lit and your phone is fully charged) but beyond that, we’re really still figuring...

    Continue Reading

  • Capturing the Soundfield: Recording Ambisonics for VR

    When building experiences in virtual reality we’re confronted with the challenge of mimicking how sounds hit us in the real world from all directions. One useful tool for us to attempt this mimicry is called a soundfield microphone. We tested one of these microphones to explore how audio plays into building immersive experiences for virtual reality. Approaching ambisonics with the soundfield microphone has become popular in development for VR particularly for 360 videos. With it,...

    Continue Reading

  • How to translate live-spoken human words into computer “truth”

    Our Knight Lab team spent three months in Winter 2018 exploring how to combine various technologies to capture, interpret, and fact check live broadcasts from television news stations, using Amazon’s Alexa personal assistant device as a low-friction way to initiate the process. The ultimate goal was to build an Alexa skill that could be its own form of live, automated fact-checking: cross-referencing a statement from a politician or otherwise newsworthy figure against previously fact-checked statements......

    Continue Reading

  • Northwestern is hiring a CS + Journalism professor

    Work with us at the intersection of media, technology and design.

    Are you interested in working with journalism and computer science students to build innovative media tools, products and apps? Would you like to teach the next generation of media innovators? Do you have a track record building technologies for journalists, publishers, storytellers or media consumers? Northwestern University is recruiting for an assistant or associate professor for computer science AND journalism, who will share an appointment in the Medill School of Journalism and the McCormick School...

    Continue Reading

  • Introducing StorylineJS

    Today we're excited to release a new tool for storytellers.

    StorylineJS makes it easy to tell the story behind a dataset, without the need for programming or data visualization expertise. Just upload your data to Google Sheets, add two columns, and fill in the story on the rows you want to highlight. Set a few configuration options and you have an annotated chart, ready to embed on your website. (And did we mention, it looks great on phones?) As with all of our tools, simplicity...

    Continue Reading

  • Join us in October: NU hosts the Computation + Journalism 2017 symposium

    An exciting lineup of researchers, technologists and journalists will convene in October for Computation + Journalism Symposium 2017 at Northwestern University. Register now and book your hotel rooms for the event, which will take place on Friday, Oct. 13, and Saturday, Oct. 14 in Evanston, IL. Hotel room blocks near campus are filling up fast! Speakers will include: Ashwin Ram, who heads research and development for Amazon’s Alexa artificial intelligence (AI) agent, which powers the...

    Continue Reading

Storytelling Tools

We build easy-to-use tools that can help you tell better stories.

View More