GalleyCat FishbowlNY FishbowlDC UnBeige MediaJobsDaily SocialTimes AllFacebook AllTwitter LostRemote TVNewser TVSpy AgencySpy PRNewser

News databases: Turning numbers into knowledge

Posting large amounts of data on the web violates the very reason the internet exists. Creating a well-presented news database requires a lot of time and effort, but in the end provides an unmatched service. Here a few news sites that have taken advantage of new media technology to create exceptional databases:

Los Angeles Times Homicide Map

The tales of murder recounted in Jill Leovy’s Homicide Report blog were compiled into a database that visually illustrates the city’s lethal trend. The figures are sortable by age, race, gender and a number of other factors.

BBC News: Mapping UK’s teen murder toll

The BBC tells the same story — the startling number of teenagers killed in the country — four different ways with narrative text, a tabled list, a map, and an infographic of the statistics. The entire project is founded on a database of information that otherwise would be a list of faceless names.

HeraldTribune.com: Broken Trust

Two years of investigative reporting and hundreds of man hours went into creating an index of Florida teachers accused of misconduct. The more than 750 teachers in the database are searchable right down to the street level.

Las Vegas Sun: Flight Delay Calculator

The Sun’s interactive map shows the frequency of delayed flights to and from McCarran Airport over a 12-year period. Users can search either for a particular flight route or click a city to discover the number of delays for that airport.

The New York Times: Casualties of War

The more than 4,000 U.S. service members who died in the Iraq war can seem like an overwhelming number. This interactive infographic lets users break down that number to determine when and where those deaths occurred.

Des Moines Register: Parkersburg Tornado

The Register combined text, photo and video accounts into a chilling, yet awe-inspiring database of the devastation and aftermath of the May 2008 tornado.

Cincinnati.com: CinciNavigator

Cincinnati.com has created what is sure to be the future of online journalism: multi-level, searchable databases in which users can view layers of information on top of an interactive map. It sounds like a lot because it is, but the service and others like it will be incredibly useful for years to come.

For more information on what makes a good news database, check out Rich Gordon’s Data as journalism, journalism as data. Also, be sure to check out the work at EveryBlock and washingtonpost.com.

Previously on 10,000 Words:
Tracking down criminals with crime maps
10 Mind-blowing maps (and 3 ways to create them)

Mediabistro Course

Book Promotion and Publicity Boot Camp

Book Promotion and Publicity Boot CampDevelop a plan for your book's success in our online boot camp, Book Promotion & Publicity! Starting November 3, publishing and publicity experts will teach you the best practices for a successful book launch using various promotional techniques. Register now!
http://www.mediabistro.com/10000words/news-databases-turning-numbers-into_b278
www.mediabistro.com
crawl=CC-MAIN-2014-42
51058
application/http; msgtype=response
sha1:ECROOAKEAWOCCIBYQ26JKS2X2EPRIZTC
<urn:uuid:19eaed12-3dd1-4bcf-a042-e304dde75141>
2014-10-23T02:17:25Z
38.126.102.81
sha1:3GV7RFTES4N7NJH2THAMCLIXLLEMDBIT
<urn:uuid:f232d770-b5d2-4738-b7a7-1b37adb3651e>
http://www.mediabistro.com/10000words/news-databases-turning-numbers-into_b278
length
response
<urn:uuid:13786287-02c5-40d4-b0c5-7fb39b358124>
robots: classic
hostname: ip-10-16-133-185.ec2.internal
software: Nutch 1.6 (CC)/CC WarcExport 1.0
isPartOf: CC-MAIN-2014-42
operator: CommonCrawl Admin
description: Wide crawl of the web with URLs provided by Blekko for October 2014
publisher: CommonCrawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf