Motion Charts


I discovered Gapminder, and its wonderful Gapminder World Motion Chart:$majorMode=chart$is;shi=t;ly=2003;lb=f;il=t;fs=11;al=30;stl=t;st=t;nsl=t;se=t$wst;tts=C$ts;sp=6;ti=2007$zpv;v=0$inc_x;mmid=XCOORDS;iid=phAwcNAVuyj1jiMAkmq1iMg;by=ind$inc_y;mmid=YCOORDS;iid=phAwcNAVuyj2tPLxKvvnNPA;by=ind$inc_s;uniValue=8.21;iid=phAwcNAVuyj0XOoBL%5Fn5tAQ;by=ind$inc_c;uniValue=255;gid=CATID0;by=grp$map_x;scale=log;dataMin=194;dataMax=96846$map_y;scale=lin;dataMin=23;dataMax=86$map_s;sma=49;smi=2.65$cd;bd=0$inds=



It is a Flash animation, displaying a HUGE amount of data, and I thought it would be excellent for displaying FHFA House Price Indexes ( ).


Previously I made a movie showing US_MSAs Housing Index 1995-1 through 2009-2 (; the 1-second-interval is good, but it shows Geography (shape-and-location), and the colors are tied to the Price Index:



These maps do not show either Income Levels (is this phenomena only affecting High-Income areas?) or Population Levels. The Nevada non-MSA area is only 9% smaller than all the MSAs in California, but it has 99.2% less people. Similarly, the non-MSA area of Nebraska is 1.8 times the size of all the MSAs in Florida, but it has 95.7% less people (population numbers from 2009 Projected Demographics).


A Motion Chart can display Price Index movement along the x-axis, MSA Median Family Income along the y-axis, Population (size of the circles), and the color of the circles can be unique (if displaying MSAs within a State) or thematic (a different color for each Region [Nationwide data] or State [Regional data]).


Google has purchased the technology from Gapminder, and has made it available only through Google Docs. I made a data set for the 22 MSAs in Florida, plus the non-MSA area.

Before playing I recommend you, in the upper-right, change Color to Unique colors (click on totpers), and change Size to totpers (click on Same size). Then click the play button



You can see how the Housing Index jumped out to the far right, before crashing back to the (current) middle. For more-specific insight, check the boxes for Naples and non-msaFlorida, and click play again;



This a GREAT tool for Data Exploration, and a lot more fun than this spreadsheet:



Jan 14, 2009: I have made Motion Charts, at the National and Regional levels, of the data for MSAs/MDs/non-MSA areas, and for States, and for Regions.