next
previous
items

Data table via SPARQL

Per capita household expenditure on food and clothing and disposable income in European countries, 2012

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

Download this dataset

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
"AT" "192712"^^<http://www.w3.org/2001/XMLSchema#decimal> "8408121"^^<http://www.w3.org/2001/XMLSchema#decimal> "14718"^^<http://www.w3.org/2001/XMLSchema#decimal> "8219"^^<http://www.w3.org/2001/XMLSchema#decimal> "1750"^^<http://www.w3.org/2001/XMLSchema#decimal> "978"^^<http://www.w3.org/2001/XMLSchema#decimal> "22920"^^<http://www.w3.org/2001/XMLSchema#decimal>
"BE" "231779"^^<http://www.w3.org/2001/XMLSchema#decimal> "11094850"^^<http://www.w3.org/2001/XMLSchema#decimal> "23928"^^<http://www.w3.org/2001/XMLSchema#decimal> "8218"^^<http://www.w3.org/2001/XMLSchema#decimal> "2157"^^<http://www.w3.org/2001/XMLSchema#decimal> "741"^^<http://www.w3.org/2001/XMLSchema#decimal> "20891"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CY" "12960"^^<http://www.w3.org/2001/XMLSchema#decimal> "862011"^^<http://www.w3.org/2001/XMLSchema#decimal> "1586"^^<http://www.w3.org/2001/XMLSchema#decimal> "569"^^<http://www.w3.org/2001/XMLSchema#decimal> "1840"^^<http://www.w3.org/2001/XMLSchema#decimal> "660"^^<http://www.w3.org/2001/XMLSchema#decimal> "15035"^^<http://www.w3.org/2001/XMLSchema#decimal>
"CZ" "85886"^^<http://www.w3.org/2001/XMLSchema#decimal> "10505445"^^<http://www.w3.org/2001/XMLSchema#decimal> "11149"^^<http://www.w3.org/2001/XMLSchema#decimal> "1633"^^<http://www.w3.org/2001/XMLSchema#decimal> "1061"^^<http://www.w3.org/2001/XMLSchema#decimal> "155"^^<http://www.w3.org/2001/XMLSchema#decimal> "8175"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DE" "1805220"^^<http://www.w3.org/2001/XMLSchema#decimal> "81843743"^^<http://www.w3.org/2001/XMLSchema#decimal> "149920"^^<http://www.w3.org/2001/XMLSchema#decimal> "60620"^^<http://www.w3.org/2001/XMLSchema#decimal> "1832"^^<http://www.w3.org/2001/XMLSchema#decimal> "741"^^<http://www.w3.org/2001/XMLSchema#decimal> "22057"^^<http://www.w3.org/2001/XMLSchema#decimal>
"DK" "121811"^^<http://www.w3.org/2001/XMLSchema#decimal> "5580516"^^<http://www.w3.org/2001/XMLSchema#decimal> "11692"^^<http://www.w3.org/2001/XMLSchema#decimal> "4421"^^<http://www.w3.org/2001/XMLSchema#decimal> "2095"^^<http://www.w3.org/2001/XMLSchema#decimal> "792"^^<http://www.w3.org/2001/XMLSchema#decimal> "21828"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EA18" "6246447"^^<http://www.w3.org/2001/XMLSchema#decimal> "333861013"^^<http://www.w3.org/2001/XMLSchema#decimal> "650545"^^<http://www.w3.org/2001/XMLSchema#decimal> "227117"^^<http://www.w3.org/2001/XMLSchema#decimal> "1949"^^<http://www.w3.org/2001/XMLSchema#decimal> "680"^^<http://www.w3.org/2001/XMLSchema#decimal> "18710"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EE" "9115"^^<http://www.w3.org/2001/XMLSchema#decimal> "1325217"^^<http://www.w3.org/2001/XMLSchema#decimal> "1586"^^<http://www.w3.org/2001/XMLSchema#decimal> "490"^^<http://www.w3.org/2001/XMLSchema#decimal> "1197"^^<http://www.w3.org/2001/XMLSchema#decimal> "370"^^<http://www.w3.org/2001/XMLSchema#decimal> "6878"^^<http://www.w3.org/2001/XMLSchema#decimal>
"ES" "682498"^^<http://www.w3.org/2001/XMLSchema#decimal> "46818219"^^<http://www.w3.org/2001/XMLSchema#decimal> "83472"^^<http://www.w3.org/2001/XMLSchema#decimal> "24151"^^<http://www.w3.org/2001/XMLSchema#decimal> "1783"^^<http://www.w3.org/2001/XMLSchema#decimal> "516"^^<http://www.w3.org/2001/XMLSchema#decimal> "14578"^^<http://www.w3.org/2001/XMLSchema#decimal>
"EU28" "8439614"^^<http://www.w3.org/2001/XMLSchema#decimal> "506098349"^^<http://www.w3.org/2001/XMLSchema#decimal> "873747"^^<http://www.w3.org/2001/XMLSchema#decimal> "314097"^^<http://www.w3.org/2001/XMLSchema#decimal> "1726"^^<http://www.w3.org/2001/XMLSchema#decimal> "621"^^<http://www.w3.org/2001/XMLSchema#decimal> "16676"^^<http://www.w3.org/2001/XMLSchema#decimal>

Received 25 rows in 0.002 seconds.


https://eea.europa.eu./data-and-maps/daviz/sds/per-capita-household-expenditure-on/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.

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



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 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 .
     _: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 .
     _: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 . 
     _: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 .
   }
  }
 FILTER (year(?date) = 2012)
 #?geo rdfs:label ?ugeo 
 ?geo skos:notation ?ugeo 
 }
GROUP BY ?ugeo ?geo
HAVING sum(?nasa_nf_tr) > 0 and sum(?nama_co3_c_food) > 0 and sum(?nama_co3_c_clothing) > 0
ORDER BY ?ugeo


Permalinks

Document Actions