Dataset 1623

From Data-gov Wiki

Jump to: navigation, search

Contents

Facts

NOTES: This dataset covers data with following features: state,region.This dataset covers temporal data from 2006 to 2009.
Metadata
RDF data
Links

Sample Data

File:Data-gov Dataset 1623 header.png

 <rdf:Description rdf:about="#entry35">
   <fiscal_year_06>0</fiscal_year_06>
   <fiscal_year_07>2</fiscal_year_07>
   <fiscal_year_08>0</fiscal_year_08>
   <fiscal_year_09>1</fiscal_year_09>
   <region>Southern</region>
   <state>Virgin Islands</state>
   <total>3</total>
   <rdf:type rdf:resource="http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#DataEntry"/>
 </rdf:Description>
 <rdf:Description rdf:about="#entry19">
   <fiscal_year_06>103</fiscal_year_06>
   <fiscal_year_07>388</fiscal_year_07>
   <fiscal_year_08>462</fiscal_year_08>
   <fiscal_year_09>317</fiscal_year_09>
   <region>Mid-West</region>
   <state>Vermont</state>
   <total>1270</total>
   <rdf:type rdf:resource="http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#DataEntry"/>
 </rdf:Description>

Sample SPARQL Queries

List medicare claims per state in fiscal year 2007

PREFIX dgp1623: <http://data-gov.tw.rpi.edu/vocab/p/1623/>
PREFIX xsd:  	<http://www.w3.org/2001/XMLSchema#>
SELECT ?state_name ?region ?claims07
WHERE {
 graph <http://data-gov.tw.rpi.edu/vocab/Dataset_1623>
 {            
  ?s2 dgp1623:state ?state_name .
  ?s2 dgp1623:region ?region .
  ?s2 dgp1623:fiscal_year_07 ?claims07 .
 }
}
order by ?state_name

More Information


Suggested Enrichment

@prefix rdf:         <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix rdfs:        <http://www.w3.org/2000/01/rdf-schema#> .
@prefix xsd:         <http://www.w3.org/2001/XMLSchema#> .
@prefix ov:          <http://open.vocab.org/terms/> .
@prefix ds1623:      <http://data-gov.tw.rpi.edu/data-gov/dataset/1623/> .
@prefix vocab1623e1: <http://data-gov.tw.rpi.edu/data-gov/dataset/1623/vocab/enrichment/1/> .
@prefix val1623:     <http://data-gov.tw.rpi.edu/data-gov/dataset/1623/value/> .

vocab1623e1:Region 
        rdfs:range  rdfs:Resource;
	rdfs:label "Region";
	ov:csvCol  "1"^^xsd:int .

vocab1623e1:State 
        rdfs:range  rdfs:Resource;
	rdfs:label "State" ;
	ov:csvCol  "2"^^xsd:int .

vocab1623e1:Fiscal_Year_06 
        rdfs:range  xsd:integer;
	rdfs:label "Fiscal Year 06";
	ov:csvCol  "3"^^xsd:int .

vocab1623e1:Fiscal_Year_07 
        rdfs:range  xsd:integer;
	rdfs:label "Fiscal Year 07";
	ov:csvCol  "4"^^xsd:int .

vocab1623e1:Fiscal_Year_08 
        rdfs:range  xsd:integer;
	rdfs:label "Fiscal Year 08";
	ov:csvCol  "5"^^xsd:int .

vocab1623e1:Fiscal_Year_09 
        rdfs:range  xsd:integer;
	rdfs:label "Fiscal Year 09";
	ov:csvCol  "6"^^xsd:int .

vocab1623e1:Total 
        rdfs:range  xsd:integer;
	rdfs:label "Total";
	ov:csvCol  "7"^^xsd:int .

ds1623:thing_1  
        vocab1623e1:Region         val1623:Mid-Atlantic;
	vocab1623e1:State          val1623:District_of_Columbia;
	vocab1623e1:Fiscal_Year_06 "12"^^xsd:int;
	vocab1623e1:Fiscal_Year_07 "289"^^xsd:int;
	vocab1623e1:Fiscal_Year_08 "342"^^xsd:int;
	vocab1623e1:Fiscal_Year_09 "376"^^xsd:int;
	vocab1623e1:Total          "1019"^^xsd:int;
	ov:csvRow                  "1"^^xsd:int .

ds1623:thing_2 
        vocab1623e1:State          val1623:Maryland;
	vocab1623e1:Fiscal_Year_06 "1029"^^xsd:int;
	vocab1623e1:Fiscal_Year_07 "3565"^^xsd:int;
	vocab1623e1:Fiscal_Year_08 "4014"^^xsd:int;
	vocab1623e1:Fiscal_Year_09 "2403"^^xsd:int;
	vocab1623e1:Total          "11011"^^xsd:int;
	ov:csvRow                  "2"^^xsd:int .

...

val1623:Mid-Atlantic         rdfs:label "Mid-Atlantic" .
val1623:District_of_Columbia rdfs:label "District of Columbia" .
val1623:Maryland             rdfs:label "Maryland" .
Facts about Dataset 1623RDF feed
92/additional metadataN/A  +
92/agencyDepartment of Health and Human Services  +
92/agency data series pagehttp://www.hhs.gov  +
92/agency program pagehttp://www.hhs.gov/omha  +
92/applicable agency information quality guideline designationDepartment of Health and Human Services
92/categorySocial Insurance and Human Services  +
92/citationN/A  +
92/collection modeComputer
92/data collection instrumentN/A
92/data dictionary variable listN/A  +
92/data gov data category typeRaw Data Catalog  +
92/data quality certificationYes  +
92/date released21-Jan-2010  +
92/date updated07-Jan-2010  +
92/descriptionTotal count of Claims received by Region, State and fiscal year.
92/frequencyMonthly  +
92/geographic coverageUnited States
92/granularityN/A  +
92/keywordsOffice of Medicare Hearings and Appeals, OMHA, Medicare, Appeals, Claims, Region, State
92/privacy and confidentialityYes  +
92/specialized data category designationAdministrative
92/technical documentationN/A
92/time periodCumulative Data, 10/01/05 - 01/07/10
92/titleOMH Claims Listed by State  +
92/unique id1623  +
92/unit of analysisClaims
92/urlhttp://www.data.gov/details/1623  +
92/xls access pointhttp://www.hhs.gov/omha/resources/claimslistbystate.xls  +
92/xls file size.022MB  +
ConsideredForDemo: Big Data in Healthcare  +
Datagov id1623  +
Dc:identifierdgtwc1623  +
Dcterms:identifierdgtwc1623, and datagov1623
Dcterms:publisherDepartment of Health and Human Services  +
Dcterms:relationURLSHA1/f38e5b3a1ee16443ed5d3d8168a0d8ed8af0fd5d  +
Dcterms:sourceHttp://data-gov.tw.rpi.edu/raw/92/data-92.rdf  +
Dcterms:subjectOffice of Medicare Hearings and Appeals  +, OMHA  +, Medicare  +, Appeals  +, Claims  +, Region  +, and State  +
Dgtwc:complete datahttp://data-gov.tw.rpi.edu/raw/1623/data-1623.nt.gz  +, and http://data-gov.tw.rpi.edu/raw/1623/data-1623.rdf  +
Dgtwc:linked data entry pointHttp://data-gov.tw.rpi.edu/vocab/Dataset 1623  +
Dgtwc:number of entries55  +
Dgtwc:number of properties7  +
Dgtwc:number of triples446  +
Dgtwc:uses property1623/region  +, 1623/state  +, 1623/fiscal year 08  +, 1623/fiscal year 09  +, 1623/total  +, 1623/fiscal year 07  +, and 1623/fiscal year 06  +
Dgtwc id1623  +
Foaf:nameOMH_Claims_Listed_by_State
Has demoDemo: Medicare Claims versus Interstate Migration  +, and Demo: State Adjusted Gross Income Versus Medicare Claims (2007)  +
Has end year2009  +
Has featureState  +, and Region  +
Has start year2006  +
Rdfs:seeAlsoHttp://data-gov.tw.rpi.edu/raw/1623/index.rdf  +
Personal tools
internal pages