Demo: State Adjusted Gross Income Versus Medicare Claims (2007)

From Data-gov Wiki

Jump to: navigation, search

Infobox (featured demo) edit with form
  • name: State's Adjusted Gross Income per Medicare Claim

  • description: Compares the adjusted gross income (AGI) of state residents and the number of Medicare claims made within that state by residents in 2007.
  • keyword(s): internet,health
  • creator(s): Peter Coons,Li Ding
  • created: 2010/03/28
  • modified: 2010-5-28

live demo here

Facts about this Demonstration

Live Demo(s)
Video Demo(s)
Data.gov Data source(s)
Other Data source(s)
Technology Used
Related SPARQL
Related Demo(s)

Observations

This map shows a comparison between the amount of adjusted gross income (AGI) earned by state residents and the number of Medicare claims made within that state by residents in 2007. From this visualization, we can see the following observations:

  • darker states, such as Montana, California and Florida, are the states with low average AGI per Medicare claim. California has a very huge AGI, but it also has high Medicare claims far above national average.
  • lighter states, such as Oregon, Wyoming, and Hawaii, are the states with high average AGI per Medicare claim. With fair amount of population, people in these states may be more healthy?
For further investigation, we can read some related News articles

Technology Highlights

Portable Interactive Google Visualization Design

This demo uses Google Visualization API to integrate the following types of charts. This demo is also interactive such that users can see more details about a state when clicking the state on the map. We also notice that currently Google GeoMap has some limitations, e.g. it does not show Washington, D.C. on map.

  • GeoMap
  • Column Chart
  • Table

This demo is highly portable as also code are encoded in a HTML file and the computations are implemented using javascript.

Connect Different State Reference using SPARQL

The SPARQL query leverages several datasets, and different states are connected using our socially maintained US location dataset (also see http://data-gov.tw.rpi.edu/wikidata/United_States_and_Territories). In particular, state_name1356 and state_name1623 cannot be simply connected because they use different capitalization styles.

PREFIX dgp1356: <http://data-gov.tw.rpi.edu/vocab/p/1356/>
PREFIX dgp1623: <http://data-gov.tw.rpi.edu/vocab/p/1623/>
PREFIX dgp353:  <http://data-gov.tw.rpi.edu/vocab/p/353/>
PREFIX skos:  <http://www.w3.org/2004/02/skos/core#>
SELECT ?state_name1623 ?state_agi07 ?state_medicareclaims07 ?state_population
WHERE {
 graph <http://data-gov.tw.rpi.edu/vocab/Dataset_1356>
 {
   ?s dgp1356:county_code "000" .
   ?s dgp1356:year "2007" .
   ?s dgp1356:county_name ?state_name1356 .
   ?s dgp1356:agi ?state_agi07 .
   ?s dgp1356:state_code  ?state_fipscode .
 }
 graph <http://data-gov.tw.rpi.edu/vocab/Dataset_1623>
 {             
    ?s2 dgp1623:state ?state_name1623 .
    ?s2 dgp1623:fiscal_year_07 ?state_medicareclaims07 .
 }
 GRAPH <http://data-gov.tw.rpi.edu/wikidata/United_States_and_Territories>
 {
    ?s3  skos:altLabel  ?state_name1356 . 
    ?s3  skos:altLabel  ?state_name1623 .    
 }
 graph <http://data-gov.tw.rpi.edu/vocab/Dataset_353>
 {             
     ?entry dgp353:pub_fips ?state_fipscode .
     ?entry dgp353:popu_st ?state_population. 
 }
}
order by ?state_name1623
Facts about Demo: State Adjusted Gross Income Versus Medicare Claims (2007)RDF feed
Data sourceDataset 1356  +, Dataset 1623  +, Dataset 353  +, and Dataset 10011  +
Dcterms:created28 March 2010  +
Dcterms:creatorPeter Coons  +, and Li Ding  +
Dcterms:descriptionCompares the adjusted gross income (AGI) of state residents and the number of Medicare claims made within that state by residents in 2007.
Dcterms:modified2010-5-28
Dcterms:subjectinternet  +, and health  +
Foaf:depictionhttps://data-gov.tw.rpi.edu/w/images/6/6e/Demo-1356_1623.png  +
Foaf:nameState's Adjusted Gross Income per Medicare Claim
ImageDemo-1356 1623.png  +
Live demohttp://data-gov.tw.rpi.edu/demo/stable/demo-1356-1623-health-claim-vs-income.html  +
Skos:altLabelState's Adjusted Gross Income per Medicare Claim  +, state's adjusted gross income per medicare claim  +, and STATE'S ADJUSTED GROSS INCOME PER MEDICARE CLAIM  +
Sparqlhttp://data-gov.tw.rpi.edu/demo/stable/demo-1356-1623-health-claim-vs-income.sparql  +
Technology usedRDF  +, SPARQL  +, SparqlProxy  +, Google Visualization API  +, TDB Triple Store  +, and Google Visualization GeoMap  +
Personal tools
internal pages