Google Public Data Explorer: Is it the first step toward a universal data format?

Inside the Internet.
Feb. 16 2011 6:00 PM

An HTML for Numbers

Is Google's Public Data Explorer the first step toward a universal data format?

(Continued from Page 1)

I've since discovered better ways to crunch these figures, but I had to learn a lot of programming to get there. If the job data I wanted for my map had already been represented in Google's format, I would have saved days of work getting it into shape (even if I wanted to use my own software to visualize it instead one of the four display options that Google offers).

Even more compelling is the possibility that data could join the ranks of text, images, and video in Google search results. This happens in a very basic form now. If you Google "population of Italy," you see a simple graph of population over time at the top of the results page, which you can click for more detail. This is the exact same tool that's opening up to the public today. Imagine if Google's spiders, forever crawling the Web to index its contents, could smartly identify and sort data? Let's say I publish an article on YouTube view counts that includes proprietary data I collected for the piece. If it's formatted according to Google's standards, it might show up as a little bar graph when someone searches for "YouTube views," even if my article itself isn't at the top of the results. (By the way, Public Data Explorer allows you to choose whether to share your figures—despite the name, your data won't be public if you don't want it to be.)

Thebreadth and relative complexity of Google's format will become clearer over time, but it can already represent many common types of information. For example, it can account for hierarchical data—a set in which the number of jobs in King County, Wash., is represented as a subset of jobs in Washington, which is in turn a subset of jobs in the United States. (This is useful for things like treemaps.) It's also good for time-lapse data, allowing you to show change over time in animated charts and graphs. While Google's system will have to evolve to accommodate less-traditional visualizations like network diagrams, its relative simplicity is a good thing. In a format like RDF, the author needs to add a ton of extra information to the source code to help computers figure out what's what. Google, by contrast, wants most of the burden to be on its shoulders.


Public Data Explorer is important because not many people care to read data in its raw form. A simple presentation tool—essentially, an HTML for numbers instead of words—might not be sexy, but it could do a lot to elevate data to the same importance as text in search results.Then, fingers crossed, mashing it all up could end up being just like mashing together a couple of balls of putty.

Like Slate on Facebook. Follow us on Twitter.


Medical Examiner

The Most Terrifying Thing About Ebola 

The disease threatens humanity by preying on humanity.

I Bought the Huge iPhone. I’m Already Thinking of Returning It.

Scotland Is Just the Beginning. Expect More Political Earthquakes in Europe.

Students Aren’t Going to College Football Games as Much Anymore

And schools are getting worried.

Global Marches Demand Action on Climate Change


Blacks Don’t Have a Corporal Punishment Problem

Americans do. But when blacks exhibit the same behaviors as others, it becomes part of a greater black pathology. 

Why a Sketch of Chelsea Manning Is Stirring Up Controversy

How Worried Should Poland, the Baltic States, and Georgia Be About a Russian Invasion?

Sept. 19 2014 1:11 PM Americans' Inexplicable Aversion to the 1990s
  News & Politics
Sept. 20 2014 11:13 AM -30-
Business Insider
Sept. 20 2014 6:30 AM The Man Making Bill Gates Richer
Sept. 20 2014 7:27 AM How Do Plants Grow Aboard the International Space Station?
  Double X
The XX Factor
Sept. 19 2014 4:58 PM Steubenville Gets the Lifetime Treatment (And a Cheerleader Erupts Into Flames)
  Slate Plus
Tv Club
Sept. 21 2014 1:15 PM The Slate Doctor Who Podcast: Episode 5  A spoiler-filled discussion of "Time Heist."
Brow Beat
Sept. 21 2014 2:00 PM Colin Farrell Will Star in True Detective’s Second Season
Future Tense
Sept. 19 2014 6:31 PM The One Big Problem With the Enormous New iPhone
  Health & Science
Bad Astronomy
Sept. 21 2014 8:00 AM An Astronaut’s Guided Video Tour of Earth
Sports Nut
Sept. 18 2014 11:42 AM Grandmaster Clash One of the most amazing feats in chess history just happened, and no one noticed.