query-629e094e38cb35c1f3e425fe1504b8bc

rq turtle/ttl

title: Organizations GHG emissions using scopes (as defined by the GHG protocol) SELECT ?item ?itemLabel ?scopeLabel ?emission_amount ?unitLabel ?typeLabel WHERE { ?scope wdt:P279* wd:Q120897419 . # Finds all scope items ?item p:P5991 ?p . # Finds all items with carbon footprint statements ?p pq:P3831 ?scope ; # ..but only use those qualified with one of the scopes ps:P5991 ?emission_amount ; # Get the emission amount psv:P5991 / wikibase:quantityUnit ?unit . # Get the emission unit OPTIONAL {?p pq:P518 ?type} # Get the type of scope (for Scope 3 emissions) SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". } } ORDER BY ?itemLabel ?scopeLabel

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title: Organizations GHG emissions using scopes (as defined by the GHG protocol) 
SELECT ?item ?itemLabel ?scopeLabel ?emission_amount ?unitLabel ?typeLabel WHERE {
  ?scope wdt:P279* wd:Q120897419 . # Finds all scope items
  ?item p:P5991 ?p . # Finds all items with carbon footprint statements
  ?p pq:P3831 ?scope ; # ..but only use those qualified with one of the scopes
     ps:P5991 ?emission_amount ; # Get the emission amount
     psv:P5991 / wikibase:quantityUnit ?unit . # Get the emission unit
  OPTIONAL {?p pq:P518 ?type} # Get the type of scope (for Scope 3 emissions)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sv,en". }
} ORDER BY ?itemLabel ?scopeLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Climate_Change/Models
• https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_Climate_Change