Dataset 10049

From Data-gov Wiki

Jump to: navigation, search
Metadata
  • Title: Tobacco Policy Coverage by State (1990- 2009)
  • Publisher:
  • Description: Tobacco policy coverage (workplace, bar and restaurant) in each state.
  • Keywords: health
  • Homepage:
  • Source:
  • Parent Dataset:
RDF data
Links
  • Demos:
NOTES: This dataset covers data with following features: state.This dataset covers temporal data from 1990 to 2009.
Infobox (Other Government Dataset) edit with form
  • name: Tobacco Policy Coverage by State (1990- 2009)

  • description: Tobacco policy coverage (workplace, bar and restaurant) in each state.
  • keyword(s): health
  • created: 2010/08/25
  • modified: 2010-8-30


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

Contents

Sample Data

spreadsheet 1 - itemized

  • i.e. workplace, bar, and restaurant

RDF data from raw conversion

@prefix raw: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/raw/> .
@prefix e1: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/enhancement/1/> .
@prefix tobacco-law-coverage-us-state-policy: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/us-state-policy/version/2010-Aug-25/> .
@prefix ov: <http://open.vocab.org/terms/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
....

tobacco-law-coverage-us-state-policy:thing_6 dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/version/2010-Aug-25> ;
        raw:state "6" ;
        raw:name "California" ;
        raw:abr "CA" ;
        raw:work90 "3" ;
        raw:work91 "3" ;
        raw:work92 "3" ;
        raw:work93 "9" ;
        raw:work94 "17" ;
        raw:work95 "18" ;
        raw:work96 "18" ;
        raw:work97 "18" ;
        raw:work98 "18" ;
        raw:work99 "19" ;
        raw:work00 "19" ;
        raw:work01 "19" ;
        raw:work02 "20" ;
        raw:work03 "20" ;
        raw:work04 "21" ;
        raw:work05 "22" ;
        raw:work06 "23" ;
        raw:work07 "24" ;
        raw:work08 "24" ;
        raw:work09 "24" ;
        raw:rest90 "0" ;
        raw:rest91 "1" ;
        raw:rest92 "1" ;
        raw:rest93 "1" ;
        raw:rest94 "4" ;
        raw:rest95 "4" ;
        raw:rest96 "4" ;
        raw:rest97 "7" ;
        raw:rest98 "94" ;
        raw:rest99 "94" ;
        raw:rest00 "94" ;
        raw:rest01 "94" ;
        raw:rest02 "94" ;
        raw:rest03 "94" ;
        raw:rest04 "94" ;
        raw:rest05 "94" ;
        raw:rest06 "94" ;
        raw:rest07 "94" ;
        raw:rest08 "94" ;
        raw:rest09 "94" ;
        raw:bar90 "0" ;
        raw:bar91 "1" ;
        raw:bar92 "1" ;
        raw:bar93 "1" ;
        raw:bar94 "1" ;
        raw:bar95 "1" ;
        raw:bar96 "1" ;
        raw:bar97 "1" ;
        raw:bar98 "94" ;
        raw:bar99 "94" ;
        raw:bar00 "94" ;
        raw:bar01 "94" ;
        raw:bar02 "94" ;
        raw:bar03 "94" ;
        raw:bar04 "94" ;
        raw:bar05 "94" ;
        raw:bar06 "94" ;
        raw:bar07 "94" ;
        raw:bar08 "94" ;
        raw:bar09 "94" ;
        ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/discriminator/us-state-policy> ;
        ov:csvRow "6"^^xsd:integer .

RDF data from enhanced conversion (taking cell-based table conversion)

tobacco-law-coverage-us-state-policy:thing_6_9 dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/version/2010-Aug-25> ;
	e1:state <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/us-state-policy/value-of/state/6> ;
	e1:cnt_staten "California" ;
	e1:sum_cnty_p "3" ;
	e1:min_state "3" ;
	e1:min_state1 "9" ;
	e1:year "1991"^^xsd:gYear ;
	e1:venue "Work" ;
	rdf:value "18.0"^^xsd:decimal ;
	ov:csvRow "6"^^xsd:integer ;
	ov:csvCol "9"^^xsd:integer ;
	ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/discriminator/us-state-policy> .

spreadsheet 2 - aggregated

  • i.e. (workplace + bar + restaurant)/3

raw

@prefix raw: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/raw/> .
@prefix e1: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/enhancement/1/> .
@prefix tobacco-law-coverage-us-state-tobacco-law-coverage: <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/us-state-tobacco-law-coverage/version/2010-Aug-25/> .
@prefix ov: <http://open.vocab.org/terms/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
...

tobacco-law-coverage-us-state-tobacco-law-coverage:thing_3 dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/version/2010-Aug-25> ;
        raw:statename "Alaska" ;
        raw:p_1990 "0" ;
        raw:p_1991 "0" ;
        raw:p_1992 "0" ;
        raw:p_1993 "0" ;
        raw:p_1994 "0" ;
        raw:p_1995 "0" ;
        raw:p_1996 "0" ;
        raw:p_1997 "0" ;
        raw:p_1998 "0" ;
        raw:p_1999 "0" ;
        raw:p_2000 "0" ;
        raw:p_2001 "0" ;
        raw:p_2002 "0" ;
        raw:p_2003 "0" ;
        raw:p_2004 "2" ;
        raw:p_2005 "4" ;
        raw:p_2006 "4" ;
        raw:p_2007 "46" ;
        raw:p_2008 "48" ;
  ...

enhanced

tobacco-law-coverage-us-state-tobacco-law-coverage:thing_3_3 dcterms:isReferencedBy <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/version/2010-Aug-25> ;
        e1:state typed_state:Alaska ;
        e1:year "1991"^^xsd:gYear ;
        rdf:value "0.0"^^xsd:decimal ;
        ov:csvRow "3"^^xsd:integer ;
        ov:csvCol "3"^^xsd:integer ;
        ov:subjectDiscriminator <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/discriminator/us-state-tobacco-law-coverage> .

Sample SPARQL Queries

List averaged policy coverage by state and year

  • query RDF data from enhancement conversion, return DBPedia state URI if needed
  • query spreadsheet 2 "averaged policy coverage"
 prefix ov:         <http://open.vocab.org/terms/>
 prefix e1:         <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/>
 
 select distinct ?dbState ?stateL ?year ?policy_coverage 
 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;
       e1:year   ?year;
       e1:state  ?state;
       rdf:value ?policy_coverage .
      ?state owl:sameAs ?dbState ; rdfs:label ?stateL .
    filter(regex(str(?dbState),"^http://dbpedia"))
  }
 } order by ?state ?year

List all kinds of policy coverage (workplace, bar, restaurant) by state and year

  • query RDF data from raw conversion, need post-processing to separate year and kind of policy coverage in predicate (identified by ?p)
  • query spreadsheet 1 "all kinds of policy coverage"


prefix ov:         <http://open.vocab.org/terms/>
prefix raw:         <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/vocab/raw/>
prefix tab:        <http://logd.tw.rpi.edu/source/nci-nih-gov/dataset/tobacco-law-coverage/discriminator/>

select distinct ?statename ?p ?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-policy;
      raw:name ?statename;
      ?p ?value .
 filter ( regex (str(?p),"[0-9]$") )
 }
} order by ?statename ?p

Facts about Dataset 10049RDF feed
Dc:identifierdgtwc10049  +
Dcterms:created25 August 2010  +
Dcterms:descriptionTobacco policy coverage (workplace, bar and restaurant) in each state.
Dcterms:modified2010-8-30
Dcterms:subjecthealth  +
Dgtwc:linked data entry pointhttp://data-gov.tw.rpi.edu/vocab/Dataset_10049  +
Dgtwc:sparql endpointhttp://logd.tw.rpi.edu/sparql  +
Dgtwc id10049  +
Foaf:nameTobacco Policy Coverage by State (1990- 2009)
Has end year2009  +
Has featureState  +
Has start year1990  +
Skos:altLabelTobacco Policy Coverage by State (1990- 2009)  +, tobacco policy coverage by state (1990- 2009)  +, and TOBACCO POLICY COVERAGE BY STATE (1990- 2009)  +
Personal tools
internal pages