Sunday, September 25, 2016

Google Fusion Tables and Medicare Fine Data


The federal government makes datasets on Medicare facilities, survey results, and fines available on https://data.medicare.gov/. I downloaded the dataset on identified deficiencies at nationwide facilities, filtered the data for the state of Florida,



The subset of data filtered on Florida was saved on a local Excel document and then uploaded to Google Fusion Tables. With the creation of the new data column containing the concatenated full address record for each facility Fusion successfully geolocated all 347 records.


With the records imported Fusion Tables rendered the below point map from the 347 records of Florida facilities assessed fines.



After zooming in we can see more detailed view and select individual facility points for details.


Switching to Fusion Table's Heatmap view offers the below visualization of the Florida data.





No comments:

Post a Comment