1 / 17

Web and Database Tools : Investigative Reporting

Web and Database Tools : Investigative Reporting. Steven Rich, IRE and DocumentCloud @ thestevenrich #SABEW # drillingdeep. SYW. S how Y our W ork Data is not a dirty word People want to see documents Readers love interactivity Journalists as gatekeepers still exists but...

sorley
Download Presentation

Web and Database Tools : Investigative Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web and Database Tools:Investigative Reporting Steven Rich, IRE and DocumentCloud @thestevenrich #SABEW #drillingdeep

  2. SYW • Show Your Work • Data is not a dirty word • People want to see documents • Readers love interactivity • Journalists as gatekeepers still exists but... • We need a wider gate, especially with investigative pieces

  3. Investigating the Energy Industry • Must read: “The History of the Standard Oil Company” by Ida Tarbell • Ida only used words, but who knows what she'd do now? • If you have the tools, use them • It's a complicated subject • If you don't use it (tools) • You risk losing it (readers)

  4. Types of Tools • Audio, Photo and Video • Google • Document Presentation • Web Scraping • Data Wrangling • Database Managers • Data Visualization • Mapping • Advanced → DIY

  5. The best things in life ARE FREE

  6. Audio, Photo and Video • Audio • Audacity • Photo • Gimp • Video • iMovie • Open Movie Editor

  7. Google Advanced Search Insights for Search Trends Public Data Explorer Google Fusion Always coming out with more

  8. DocumentCloud • Upload your documents • Analyze, annotate and publish • Turn your documents into data • Used in newsrooms across the world • See others' documents • Request an account today: free • Request an account any other time: free

  9. Data Wrangling • Just because someone gives you data, it doesn't mean it's clean • If it's not, there are solutions • Mr. People • Google Refine • Mr. Data Converter • CSV to HTML

  10. Database Managers • SQLite • SQLiteMan • MySQL • Libre Office (Calc) • PostgreSQL

  11. Web Scraping • There's a lot of data out there, but it's not always easy to get • Always easier to ask for data than to scrape it • Scraping is good for constantly updating data • Make friends with your developers • Does require some programming language • But Google can help

  12. Mapping/Data Viz • The energy industry affects many • Mapping helps answer “so what?” for more • Google Fusion • It'll do the trick, but if you want personalization • Cloudmade/Leaflet • Mapstraction • Tableau Public

  13. Advanced • Looking to customize user experience? • Like to play around with code? • APIs • Django CMS • Ruby on Rails • Github

  14. Questions? Download slides: http://bit.ly/SABEWtools @thestevenrich|http://stevenri.ch serich@mizzou.edu

More Related