Dataset 10050

From Data-gov Wiki

Jump to: navigation, search
Metadata
  • Title: Tobacco Control Policy and Prevalence Data (1991-2007)
  • Publisher:
  • Description: state-level smoking-related results aggregated from several data sources including BRFSS and TUS
  • Keywords: health
  • Homepage:
  • Source: Http://www.impacteen.org/tobaccodata.htm
  • Parent Dataset:
RDF data
Links
  • Demos:
NOTES: This dataset covers data with following features: state.This dataset covers temporal data from 1991 to 2007.
Infobox (Other Government Dataset) edit with form
  • name: Tobacco Control Policy and Prevalence Data (1991-2007)


http://logd.tw.rpi.edu/sparql

Contents

Facts

impacteen data (covering every state & U.S. for 18-29, 30+ and 18+) is a repository of state-level smoking-related results aggregated from several data sources including BRFSS and TUS. It also contains state-level policy information including tax data, youth restrictions, and smoke-free laws in addition to the prevalence results.

Sample raw data

File:Impacteen-org-alaska-tax-prevalence.png

Sample RDF Data

tobacco-control-policy-and-prevalence-alabama:thing_3_2 
       dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> ;
       e1:measure <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/State_excise_tax_per_pack> ;
       e1:year "1991"^^xsd:gYear ;
       rdf:value "0.17"^^xsd:decimal ;
       ov:csvRow "3"^^xsd:integer ;
       ov:csvCol "2"^^xsd:integer ;
       ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/Alabama> .

tobacco-control-policy-and-prevalence-alabama:thing_3_3 
       dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> ;
       e1:measure <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/State_excise_tax_per_pack> ;
       e1:year "1992"^^xsd:gYear ;
       rdf:value "0.17"^^xsd:decimal ;
       ov:csvRow "3"^^xsd:integer ;
       ov:csvCol "3"^^xsd:integer ;
       ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/Alabama> .

tobacco-control-policy-and-prevalence-alabama:thing_3_4 
       dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> ;
       e1:measure <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/State_excise_tax_per_pack> ;
       e1:year "1993"^^xsd:gYear ;
       rdf:value "0.17"^^xsd:decimal ;
       ov:csvRow "3"^^xsd:integer ;
       ov:csvCol "4"^^xsd:integer ;
       ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/Alabama> .

Sample Queries

Query for available Measures

prefix ov:          <http://open.vocab.org/terms/>
prefix raw:         <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/vocab/raw/> 
prefix e1:          <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/vocab/enhancement/1/> 
prefix measure:     <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/>
prefix spreadsheet: <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/>

select distinct ?measure ?measureL
where {
  graph <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> {
     ?cell    e1:measure ?measure .
     ?measure rdfs:label ?measureL .
  }
} order by str(?measure)

We are currently only concerned with

measure:Total_cigarette_tax_per_pack_adjusted_for_inflation, 
measure:Average_price_per_pack_adjusted_for_inflation_generic_included, and 
measure:BRFSS_Current_smokers_Overall

Query for values of three Measures (Tax/Pack, Cost/Pack, Prevalence) for each state and for each year

see http://logd.tw.rpi.edu/query/demo-tobacco-impacteen-price-prevenlance-logd.sparql

prefix ov:          <http://open.vocab.org/terms/>
prefix ie1:         <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/vocab/enhancement/1/> 
prefix measure:     <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/>
prefix spreadsheet: <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/>

select distinct ?measureL ?statename ?year ?value  
where {
  graph <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> {
     ?cell ie1:measure             ?measure ;
           ov:subjectDiscriminator ?spreadsheet ;
           ie1:year                ?year ;
           rdf:value               ?value .
     ?spreadsheet rdfs:label ?statename .
     ?measure     rdfs:label ?measureL .
	  filter(?measure = measure:Average_price_per_pack_adjusted_for_inflation_generic_included || 
         ?measure = measure:State_excise_tax_per_pack_adjusted_for_inflation               || 
         ?measure = measure:BRFSS_Current_smokers_Overall)
  } 
  
} order by ?measureL ?statename ?year 


Query for values of four Measures (Tax/Pack, Cost/Pack, Prevalence, Policy Coverage) for each state and for each year

this query aggregates results from two named graphs

prefix ov:          <http://open.vocab.org/terms/>
prefix void:        <http://rdfs.org/ns/void#>
prefix conversion:  <http://purl.org/twc/vocab/conversion/> 
prefix ne1:         <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/enhancement/1/>
prefix tab:         <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/discriminator/>
prefix ie1:          <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/vocab/enhancement/1/> 
prefix measure:     <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/value-of/measure/>
prefix spreadsheet: <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/discriminator/>

select distinct ?policy_coverage ?stateL ?year ?measureL ?spreadsheetL ?value
where {
 {graph <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/version/2010-Aug-25> {
   ?c ov:subjectDiscriminator tab:us-state-tobacco-law-coverage;
      ne1:year   ?year;
      ne1:state  ?state;
      rdf:value ?policy_coverage .
   ?state owl:sameAs ?dbState ; rdfs:label ?stateL .
   filter(regex(str(?dbState),"^http://dbpedia"))
 }
 }union{
  graph <http://logd.tw.rpi.edu/source/impacteen-org/dataset/tobacco-control-policy-and-prevalence/version/2009-Jun-09> {
     ?cell ie1:measure             ?measure ;
           ov:subjectDiscriminator ?spreadsheet ;
           ie1:year                ?year ;
           rdf:value               ?value .
     ?spreadsheet rdfs:label ?spreadsheetL .
     ?measure     rdfs:label ?measureL .
  }
  filter(?measure = measure:Average_price_per_pack_adjusted_for_inflation_generic_included || 
         ?measure = measure:State_excise_tax_per_pack_adjusted_for_inflation               || 
         ?measure = measure:BRFSS_Current_smokers_Overall)
 }
} order by ?measureL ?stateL ?spreadsheetL ?year 

Notes

There are TUS-CPS data estimates available for download for every state & U.S. for 18-29, 30+ and 18+ (http://www.impacteen.org/tobaccodata.htm) and from this site I have attached a zip file with the states' excel spreadsheets and the overall US spreadsheet is included as well.

Facts about Dataset 10050RDF feed
Dc:identifierdgtwc10050  +
Dcterms:created25 August 2010  +
Dcterms:descriptionstate-level smoking-related results aggregated from several data sources including BRFSS and TUS
Dcterms:modified2010-8-30  +
Dcterms:relationPopSciGrid  +
Dcterms:sourcehttp://www.impacteen.org/tobaccodata.htm  +
Dcterms:subjecthealth  +
Dgtwc:linked data entry pointHttp://data-gov.tw.rpi.edu/vocab/Dataset 10050  +
Dgtwc:sparql endpointHttp://logd.tw.rpi.edu/sparql  +
Dgtwc id10050  +
Foaf:nameTobacco Control Policy and Prevalence Data (1991-2007)
Has end year2007  +
Has featureState  +
Has start year1991  +
Skos:altLabelTobacco Control Policy and Prevalence Data (1991-2007)  +, tobacco control policy and prevalence data (1991-2007)  +, and TOBACCO CONTROL POLICY AND PREVALENCE DATA (1991-2007)  +
Personal tools
internal pages