Data table via SPARQL

RO - Per capita household expenditure on food and clothing and disposable income in European countries, 2010

Data table via SPARQL Published 14 Aug 2014 Last modified 20 Apr 2016

Data visualisations

Menu

Learn more
Semantic Data Service (data tables via sparql)
- RO - Per capita household expenditure on food and clothing and disposable income in European countries, 2010

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)

ugeo	nasa_nf_tr	demo_pjan	nama_co3_c_food	nama_co3_c_clothing	food_per_capita	clothing_per_capita	household_disposable_income_per_capita
"RO"	"76440"^^<http://www.w3.org/2001/XMLSchema#decimal>	"20294683"^^<http://www.w3.org/2001/XMLSchema#decimal>	"20609"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1979"^^<http://www.w3.org/2001/XMLSchema#decimal>	"1015"^^<http://www.w3.org/2001/XMLSchema#decimal>	"98"^^<http://www.w3.org/2001/XMLSchema#decimal>	"3767"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 1 rows in 0.001 seconds.

JSON Url:
https://www.eea.europa.eu/data-and-maps/daviz/sds/ro-per-capita-household-expenditure/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:
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 property: <http://rdfdata.eionet.europa.eu/eurostat/property#> 
PREFIX coicop: <http://rdfdata.eionet.europa.eu/eurostat/dic/coicop#>
PREFIX unit: <http://rdfdata.eionet.europa.eu/eurostat/dic/unit#>
PREFIX geo: <http://rdfdata.eionet.europa.eu/eurostat/dic/geo#>
PREFIX sex: <http://purl.org/linked-data/sdmx/2009/code#>
PREFIX age: <http://rdfdata.eionet.europa.eu/eurostat/dic/age#>
PREFIX sector: <http://rdfdata.eionet.europa.eu/eurostat/dic/sector#>
PREFIX indic_na: <http://rdfdata.eionet.europa.eu/eurostat/dic/indic_na#>
PREFIX direct: <http://dd.eionet.europa.eu/vocabulary/eurostat/direct/>

SELECT DISTINCT
?ugeo
sum(?nasa_nf_tr) as ?nasa_nf_tr
sum(?demo_pjan) as ?demo_pjan
sum(?nama_co3_c_food) as ?nama_co3_c_food
sum(?nama_co3_c_clothing) as ?nama_co3_c_clothing

round(sum(?nama_co3_c_food) / sum(?demo_pjan)*1000000) as ?food_per_capita
round(sum(?nama_co3_c_clothing) / sum(?demo_pjan)*1000000) as ?clothing_per_capita
round(sum(?nasa_nf_tr) / sum(?demo_pjan)*1000000) as ?household_disposable_income_per_capita

WHERE {
{
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nama_co3_c.rdf.gz> 
   {
     _:nama_co3_c sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2010)
     _:nama_co3_c sdmx-dimension:refArea ?geo . 
     
     _:nama_co3_c sdmx-attribute:unitMeasure unit:MIO_EUR .
     {
       _:nama_co3_c property:coicop coicop:CP011 .
       _:nama_co3_c sdmx-measure:obsValue ?nama_co3_c_food .
     } union {
       _:nama_co3_c property:coicop coicop:CP031 .
       _:nama_co3_c sdmx-measure:obsValue ?nama_co3_c_clothing .
     }
   }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/demo_pjan.rdf.gz> 
   {
     _:demo_pjan sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2010)
     _:demo_pjan sdmx-dimension:refArea ?geo .
     _:demo_pjan sdmx-dimension:age age:TOTAL .
     _:demo_pjan sdmx-dimension:sex sex:sex-T .
     _:demo_pjan sdmx-measure:obsValue ?demo_pjan .

   }
  } UNION {
  GRAPH <http://rdfdata.eionet.europa.eu/eurostat/data/nasa_nf_tr.rdf.gz> 
   {
     _:nasa_nf_tr sdmx-dimension:timePeriod ?date . FILTER (year(?date) = 2010)
     _:nasa_nf_tr property:sector sector:S14_S15 .
     _:nasa_nf_tr property:direct direct:RECV .
     _:nasa_nf_tr property:indic_na indic_na:B6G .
     _:nasa_nf_tr sdmx-dimension:refArea ?geo .
     _:nasa_nf_tr sdmx-attribute:unitMeasure unit:MIO_EUR .
     _:nasa_nf_tr sdmx-measure:obsValue ?nasa_nf_tr .
   }
  }
 ?geo skos:notation ?ugeo 
 FILTER (?geo = geo:RO)
 }
GROUP BY ?ugeo ?geo
ORDER BY ?ugeo