Google Fusion Tables

Recent posts

Mapping the Birthplaces of U.S. Presidents

Since I get the day off, I figured I should repay our presidents by honoring their birthplaces with two maps made with Google Fusion Tables. This first map places points on their home towns (see larger interactive version): 

Here’s the same data but aggregated by state and mapped with polygons. Darker shades represent more presidents (see larger interactive version): 

Data source: Wikipedia

RELATED: 

Union Membership by State

In the early 1970s, one in four American workers belong to a labor union. Last year, they represented about 12 percent of the workforce, according to the Bureau of Labor Statistics

This map shows membership by state, with darker shades representing higher proportions of the workforce in unions. North Carolina has the lowest percentage of union workers: 3.2 percent. New York has the highest: 24.2 percent. 

See larger version

This map has the same data, but in an interactive format: 

See larger version

Source: Bureau of Labor Statistics | Download data

Florida Teacher Pay

A map for our NPR project, StateImpact

This map visualizes how much the average teacher’s salary has changed since the 2007-08 school year. Darker reds represent deeper pay cuts, while darker greens represent larger salary increases. Click on individual counties to see more specific information about their teachers’ average salaries.

Full-screen version

Mapping London Riots, ‘Deprivation’

This interactive map, made with Google Fusion Tables, shows recent riot locations in greater London as red points. The colors represent “indices of deprivation” by “lower super output areas,” which appear similar to blocks or tracts in the U.S. Census. Deeper reds represent higher poverty, while blues represent more income. 

Data via the Guardian: Riots | Deprivation

Drug Deaths In England

From the Guardian’s Data Blog

The death of Amy Winehouse, widely reported as due to a suspected drug overdose, has drawn attention to drug misuse across the country. How bad are the figures? 

This Google Fusion Tables map, posted by James Ball and Simon Rogers, shows drug poisoning per 100,000 population, with darker shades representing higher rates:

This stack graph, made with the Google’s Chart Tools API, shows misuse over time (view interactive version): 

Download the data

Mapping D.C. Schools

UMBC professor Lou Paladino made this interesting map that visualizes academic performance by Washington, D.C., school districts. Darker cool colors represent higher scores; darker warm colors represent lower scores. This shows that the separation of population in D.C. by race, poverty and crime also translates to schools: 

Download data

World Internet Stats

The U.S. is among the most wired countries in the world, with three out of every four Americans having access to the Internet, according to these stats. Only Japan, Germany and the United Kingdom have higher rates of Internet use. 

This charts shows the top 25 most populous countries in the world, and plots the percentage of Internet users on the x axis (bottom), and the population of total Internet users on the y axis (left).

The U.S. is the orange dot. Notice that China, which has about 450 million users, still lags behind other counties in penetration rate. It’s the large dot at the top middle. So does India, the larger dot at the bottom left. (See an interactive version): 

Here’s the view as a map (see an interactive version): 

BTW: Iceland has the highest Internet penetration (98 percent). East Timor has the lowest rate (.2 percent). 

Source: Internet World Stats | Download data