Data table via SPARQL

Production of toxic chemicals by toxicity class

Data table via SPARQL Published 14 Dec 2016 Last modified 15 Dec 2016

Data visualisations

Menu

Download this dataset

Formats suitable for human consumption

HTML CSV TSV

Formats suitable for machine-to-machine communication

JSON Exhibit JSON XML XML with Schema

Dataset preview

(Live Query)

date	hazard_label	obsValue
"2005"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"65.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2006"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"64.9"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2007"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"64.8"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2008"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"57.7"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2009"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"54.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2010"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"60"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2011"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"59.2"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2012"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"61.1"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2013"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"58.5"^^<http://www.w3.org/2001/XMLSchema#decimal>
"2014"^^<http://www.w3.org/2001/XMLSchema#int>	"Harmful health hazard"	"62.3"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 70 rows in 0.034 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/production-of-toxic-chemicals-by-1/daviz.json

For system integrators

Linked Data query (SPARQL)

The following info can be used by a system developer / database administrator in order to retrieve this dataset programmatically over the web using a SPARQL client.

Are you new to Linked Data technology? visit http://linkeddata.org

SPARQL Endpoint:
http://semantic.eea.europa.eu/sparql

SPARQL Query:


        PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-attribute: <http://purl.org/linked-data/sdmx/2009/attribute#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX indic_nv: <http://dd.eionet.europa.eu/vocabulary/eurostat/indic_nv/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX hazard: <http://dd.eionet.europa.eu/vocabulary/eurostat/hazard/>

SELECT DISTINCT
year(?date) as ?date
?hazard_label
?obsValue

WHERE {
  { 
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/env_chmhaz.rdf.gz>
    {
      _:env_chmhaz sdmx-dimension:timePeriod ?date . 
      _:env_chmhaz sdmx-attribute:unitMeasure unit:MIO_T . 
      _:env_chmhaz sdmx-dimension:refArea geo:EU28 . 
      _:env_chmhaz property:indic_nv indic_nv:PRD . 
      _:env_chmhaz property:hazard ?hazard .
      FILTER (?hazard in (hazard:HAZ_NHAZ, hazard:HLTH, hazard:HLTH_CMR, hazard:HLTH_CHRTOX,
                          hazard:HLTH_VTOX, hazard:HLTH_TOX, hazard:HLTH_HRM))
      _:env_chmhaz sdmx-measure:obsValue ?obsValue .
    }
  FILTER (year(?date) >= 2005)
  ?hazard rdfs:label ?hazard_label .
  }
}