How Data Can Become an Evergreen Source for Newsrooms

Newsrooms don't fear too much news. They fear not enough news. With news on demand 24/7, the stream of information that journalists work with is becoming the commodity upon which they rely -- which is why "evergreen" stories are becoming a staple for the modern newsroom. What they need now are evergreen news sources. So how can data be an evergreen news source? Traditionally, data was hard to work with. It had to be collected, cleaned, organized, and once the effort was made to produce something consumable, it was left to stagnate and rot over time. With "ScraperWiki":http://www.scraperwiki.com, we've structured our site so that incoming data on the web renews your database and the infrastructure organizing your data flow does not rot. For use in the newsroom, however, the _output_ needs to be streamed. Here a couple of things you can do: h2. Data Stress to RSS Our Web API now has an option to make "RSS feeds":http://blog.scraperwiki.com/2011/09/21/make-rss-with-an-sql-query/ as a format. For example, a ScraperWiki user made a scraper that "gets alcohol licensing applications for Islington":https://scraperwiki.com/scrapers/islington_business_licences/ in London. She wanted an RSS feed to keep track of new applications using Google Reader. Now all she needs to do is go to the Web API explorer, choose "rss2″ for the format, and enter a SQL statement into the query box. That way, she gets only what she wants into her reader without having to change the database. h2. The Early Data Bird Catches The Story One of our savvy users then used "ifttt":http://ifttt.com/ to turn an RSS feed into a Twitter feed. For food safety inspections in Walsall, follow "@EatSafeWalsall":https://twitter.com/EatSafeWalsall. In fact, we have a couple of accounts tweeting out scraped data. For ministers', permanent secretaries' and special advisers' meetings, gifts and hospitalities at No.10 Downing Street, follow "@Scrape_No10":https://twitter.com/Scrape_No10. For Edinburgh planning applications, follow "@PlanningAppMap":https://twitter.com/PlanningAppMap. For complaints made against judges in the U.K., follow "@OJCstatements":https://twitter.com/#!/OJCstatements. Because you can get data in the way you want, you can push data out the way you want and also keep the integrity of the original database. The sources of data for these accounts are very different, and the output scripts need to reflect the timing of the data release. However, all this work means sentences can be formed and hashtags attached. So if they start trending, you've got a story lead. h2. A New Breed of Data Reporter I've been experimenting with data output from ScraperWiki. In fact, I've been talking to it. In preparation for our U.S. tour, I've created a new member of the virtual newsroom. So here's a little something I made earlier: It's not what you can do for your data, it's what your data can do for you! _If you'd like to be a host or sponsor for a scraping event, email nicola[at]scraperwiki.com._