Google’s Public Data: Much Improved

Google recently released some major improvements in its public data efforts. If you click on over to Public Data, you will find a much broader range of data sets including economic information from the OECD and World Bank, key economic statistics for the United States, and some education statistics for California. Google has also included more tools for visualizing these data, from standard line charts to the evolving bubble charts that have made Hans Rosling such a hit at TED.

As an example, I made a flash chart of state unemployment rates from 1990 to the present. Puerto Rico (which counts as a state for these purposes), Michigan, Nevada, and Rhode Island currently have the highest unemployment rates, so I thought it would be interesting to see how they stacked up against the other states over the past twenty years.

WordPress doesn’t allow me to embed Flash, but if you click on the image above and then click play, you will see the evolution of state unemployment rates over time. (Spoiler alert: All those colored bars move sharply upward toward the end of the “movie”.)

Long-time readers may recall my series of posts criticizing Google for directing its users to unemployment data that have not been seasonally adjusted. Happily, Google now allows the user to use either seasonally adjusted or non adjusted data. Two cheers for Google.

Why only two cheers rather than three? Because Google still directs unsuspecting users to unadjusted data–without the ability to switch to seasonally adjusted–if they do a Google search on “unemployment rate United States“. That’s a big deal, particularly for February 2010 when the official unemployment rate was 9.7%, but the unadjusted figure reported by Google was 10.4%.

Clearly, the two parts of Public Data need to integrate a bit more.

2 thoughts on “Google’s Public Data: Much Improved”

  1. Dear Sir,

    I have the pleasure to brief on our Data Visualization software
    “Trend Compass”.

    TC is a new concept in viewing statistics and trends in an animated
    way by displaying 5 axis (X, Y, Time, Bubble size & Bubble color)
    instead of just the traditional X and Y axis. It could be used in
    analysis, research, presentation etc. In the banking sector, we have
    Deutsche Bank New York as our client.

    This a link on weather data :

    http://www.epicsyst.com/test/v2/aims/

    This is a bank link to compare Deposits, Withdrawals and numbers of
    Customers for different branches over time ( all in 1 Chart) :

    http://www.epicsyst.com/test/v2/bank-trx/

    Misc Examples :

    http://www.epicsyst.com/test/v2/airline/
    http://www.epicsyst.com/test/v2/stockmarket1/
    http://www.epicsyst.com/test/v2/tax/
    http://www.epicsyst.com/test/v2/football/
    http://www.epicsyst.com/test/v2/swinefludaily/
    http://www.epicsyst.com/test/v2/flu/
    http://www.epicsyst.com/test/v2/babyboomers/
    http://www.epicsyst.com/test/v2/bank-trx/
    http://www.epicsyst.com/test/v2/advertising/

    This is a project we did with Princeton University on US unemployment :
    http://www.epicsyst.com/main3.swf

    A 3 minutes video presentation of above by Professor Alan Krueger
    Bendheim Professor of Economics and Public Affairs at Princeton
    University and currently Chief Economist at the US Treasury using
    Trend Compass :
    http://epicsyst.com/trendcompass/princeton.aspx?home=1

    Latest financial links on the Central Bank of Egypt:

    http://www.epicsyst.com/trendcompass/samples/Aggregate-balance-sheet/
    http://www.epicsyst.com/trendcompass/samples/balance-sheet
    http://www.epicsyst.com/trendcompass/samples/banks-deposits-by-maturity/
    http://www.epicsyst.com/trendcompass/samples/egyptian-banks/
    http://www.epicsyst.com/trendcompass/samples/currency-by-denomination/

    I hope you could evaluate it and give me your comments. So many ideas
    are there.

    You can download a trial version. It has a feature to export
    EXE,PPS,HTML and AVI files. The most impressive is the AVI since you
    can record Audio/Video for the charts you create.

    http://epicsyst.com/trendcompass/FreeVersion/TrendCompassv1.2_DotNet.zip

    All the best.

    Epic Systems
    http://www.epicsyst.com

Comments are closed.