Data table via SPARQL
Manufacturing and service GVA
Data table via SPARQL
Published 24 Mar 2016
Last modified 22 Aug 2016
Download this dataset
Dataset preview
(Live Query)
Received 12 rows in 0.001 seconds.
https://www.eea.europa.eu/data-and-maps/daviz/sds/manifacturing-services-gva-1/daviz.json
For system integrators
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.
http://semantic.eea.europa.eu/sparql
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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#>
PREFIX geo: <http://dd.eionet.europa.eu/vocabulary/eurostat/geo/>
PREFIX unit: <http://dd.eionet.europa.eu/vocabulary/eurostat/unit/>
PREFIX nace_r2: <http://dd.eionet.europa.eu/vocabulary/eurostat/nace_r2/>
SELECT DISTINCT
year(?date) as ?date
#sum(?nama_10_a10_C) as ?nama_10_a10_C
#sum(?nama_10_a10_G_U) as ?nama_10_a10_G_U
#sum(?nama_10_a10_C_idx) as ?nama_10_a10_C_idx
#sum(?nama_10_a10_G_U_idx) as ?nama_10_a10_G_U_idx
round(( sum(?nama_10_a10_C) / sum(?nama_10_a10_C_idx) )*1000)/10.0 as ?manufacturing_gva
round(( sum(?nama_10_a10_G_U) / sum(?nama_10_a10_G_U_idx) )*1000)/10.0 as ?services_gva
WHERE {{
GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_10_a10.rdf.gz>
{{
_:nama_10_a10 sdmx-dimension:timePeriod ?date .
FILTER (year(?date) >= 2004)
_:nama_10_a10 sdmx-dimension:refArea geo:EU28 .
_:nama_10_a10 sdmx-attribute:unitMeasure unit:CLV_I10 .
{
_:nama_10_a10 property:nace_r2 nace_r2:C .
_:nama_10_a10 sdmx-measure:obsValue ?nama_10_a10_C .
} UNION {
_:nama_10_a10 property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:G-I, nace_r2:J, nace_r2:K, nace_r2:L,
nace_r2:M_N, nace_r2:O-Q, nace_r2:R-U ))
_:nama_10_a10 sdmx-measure:obsValue ?nama_10_a10_G_U .
}
_:nama_10_a10_idx sdmx-dimension:timePeriod ?date_idx .
FILTER (year(?date_idx) = 2004)
_:nama_10_a10_idx sdmx-dimension:refArea geo:EU28 .
_:nama_10_a10_idx sdmx-attribute:unitMeasure unit:CLV_I10 .
{
_:nama_10_a10_idx property:nace_r2 nace_r2:C .
_:nama_10_a10_idx sdmx-measure:obsValue ?nama_10_a10_C_idx .
} UNION {
_:nama_10_a10_idx property:nace_r2 ?nace_r2 .
FILTER (?nace_r2 in (nace_r2:G-I, nace_r2:J, nace_r2:K, nace_r2:L,
nace_r2:M_N, nace_r2:O-Q, nace_r2:R-U ))
_:nama_10_a10_idx sdmx-measure:obsValue ?nama_10_a10_G_U_idx .
}
}}
}}
GROUP BY ?date
ORDER BY ?date
Permalinks
- Permalink to this version
- a995758315f14c4eb46760ba9613f1d1
- Permalink to latest version
- OJG54CBQTM
Older versions
For references, please go to https://www.eea.europa.eu/data-and-maps/daviz/sds/manifacturing-services-gva-1 or scan the QR code.
PDF generated on 29 Jan 2023, 11:03 AM
Document Actions
Share with others