Account Options>

  1. Sign in
World Bank Linked Data - Interesting SPARQL queries
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
Site: http://worldbank.270a.info/
2
SPARQL Endpoint: http://worldbank.270a.info/sparql
3
4
5
6
QuerySPARQL QuerySPARQL Endpoint QueryComments
7
List of project names for countries which are classified to have low to middle income that are situated above the equator.SELECT ?projectPrefLabel ?countryPrefLabel
WHERE {
GRAPH g-meta: {
?country property:income-level income-level:LMC .
?country wgs:lat ?latitude .
FILTER (?latitude > 0)
?country skos:prefLabel ?countryPrefLabel .
}
GRAPH g-projects: {
?project property:country ?country .
?project skos:prefLabel ?projectPrefLabel .
}
}
ORDER BY ?projectPrefLabel
http://worldbank.270a.info/sparql?query=PREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+wgs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+property%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fproperty%2F%3E%0D%0APREFIX+country%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcountry%2F%3E%0D%0APREFIX+income-level%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fincome-level%2F%3E%0D%0APREFIX+g-projects%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-projects-and-operations%3E%0D%0APREFIX+g-meta%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fmeta%3E%0D%0A%0D%0ASELECT+%3FprojectPrefLabel+%3FcountryPrefLabel%0D%0AWHERE+%7B%0D%0A++++GRAPH+g-meta%3A+%7B%0D%0A++++++++%3Fcountry+property%3Aincome-level+income-level%3ALMC+.%0D%0A++++++++%3Fcountry+wgs%3Alat+%3Flatitude+.%0D%0A++++++++FILTER+%28%3Flatitude+%3E+0%29%0D%0A++++++++%3Fcountry+skos%3AprefLabel+%3FcountryPrefLabel+.%0D%0A++++%7D%0D%0A++++GRAPH+g-projects%3A+%7B%0D%0A++++++++%3Fproject+property%3Acountry+%3Fcountry+.%0D%0A++++++++%3Fproject+skos%3AprefLabel+%3FprojectPrefLabel+.%0D%0A++++%7D%0D%0A%7D%0D%0AORDER+BY+%3FprojectPrefLabel&default-graph-uri=&output=xml&stylesheet=%2Fxml-to-html.xsl
8
Central government's debt percentage of GDP of countries in 2010 that have the highest loans due to IBRDSELECT ?countryURI ?debtPercentageOfGDP ?dueToIBRD
WHERE {

{
SELECT ?countryURI (SUM(?dTI) AS ?dueToIBRD)
WHERE {
GRAPH g-finances: {
?observation
qb:dataSet d-finances:zucq-nrc3 ;
property:loan-status ?loanStatusURI ;
property:end-of-period "2010-06-30T00:00:00"^^xsd:dateTime ;
.
FILTER (?loanStatusURI = loan-status:disbursed || ?loanStatusURI = loan-status:disbursing)
?observation
property:due-to-ibrd ?dTI ;
.
FILTER (?dTI > 0)
?observation
property:country ?countryURI ;
.
}
GRAPH g-meta: {
?countryURI a dbo:Country .
}
}
GROUP BY ?countryURI ?obsValue
}
GRAPH g-indicators: {
?observationIndicator
property:indicator indicator:GC.DOD.TOTL.GD.ZS ;
sdmx-dimension:refArea ?countryURI ;
sdmx-dimension:refPeriod year:2010 ;
sdmx-measure:obsValue ?debtPercentageOfGDP ;
.
}
}
ORDER BY DESC(?debtPercentageOfGDP)
http://worldbank.270a.info/sparql?query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+dcterms%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+wgs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+dcat%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Fdcat%23%3E%0D%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0APREFIX+dbp%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX+dbr%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+sdmx%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%23%3E%0D%0APREFIX+sdmx-attribute%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fattribute%23%3E%0D%0APREFIX+sdmx-code%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fcode%23%3E%0D%0APREFIX+sdmx-concept%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fconcept%23%3E%0D%0APREFIX+sdmx-dimension%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fdimension%23%3E%0D%0APREFIX+sdmx-measure%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmeasure%23%3E%0D%0APREFIX+sdmx-metadata%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmetadata%23%3E%0D%0APREFIX+sdmx-subject%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fsubject%23%3E%0D%0APREFIX+qb%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fcube%23%3E%0D%0APREFIX+year%3A+%3Chttp%3A%2F%2Freference.data.gov.uk%2Fid%2Fyear%2F%3E%0D%0APREFIX+void%3A+%3Chttp%3A%2F%2Frdfs.org%2Fns%2Fvoid%23%3E%0D%0A%0D%0APREFIX+wbld%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2F%3E%0D%0APREFIX+property%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fproperty%2F%3E%0D%0APREFIX+classification%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2F%3E%0D%0APREFIX+indicator%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Findicator%2F%3E%0D%0APREFIX+country%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcountry%2F%3E%0D%0APREFIX+income-level%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fincome-level%2F%3E%0D%0APREFIX+lending-type%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Flending-type%2F%3E%0D%0APREFIX+region%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fregion%2F%3E%0D%0APREFIX+source%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fsource%2F%3E%0D%0APREFIX+topic%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Ftopic%2F%3E%0D%0APREFIX+currency%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcurrency%2F%3E%0D%0APREFIX+project%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fproject%2F%3E%0D%0APREFIX+loan-status%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Floan-status%2F%3E%0D%0APREFIX+variable%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fvariable%2F%3E%0D%0APREFIX+global-circulation-model%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fglobal-circulation-model%2F%3E%0D%0APREFIX+scenario%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fscenario%2F%3E%0D%0A%0D%0APREFIX+d-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-development-indicators%2F%3E%0D%0APREFIX+d-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-finances%2F%3E%0D%0APREFIX+d-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-climates%2F%3E%0D%0A%0D%0A%23USE+THESE+GRAPHS+%3A%29%0D%0APREFIX+g-void%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fvoid%3E%0D%0APREFIX+g-meta%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fmeta%3E%0D%0APREFIX+g-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-climates%3E%0D%0APREFIX+g-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-finances%3E%0D%0APREFIX+g-projects%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-projects-and-operations%3E%0D%0APREFIX+g-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-development-indicators%3E%0D%0A%0D%0A%0D%0ASELECT+%3FcountryURI+%3FdebtPercentageOfGDP+%3FdueToIBRD%0D%0AWHERE+%7B%0D%0A%0D%0A%7B%0D%0ASELECT+%3FcountryURI+%28SUM%28%3FdTI%29+AS+%3FdueToIBRD%29%0D%0AWHERE+%7B%0D%0A++++GRAPH+g-finances%3A+%7B%0D%0A++++++++%3Fobservation%0D%0A++++++++++++qb%3AdataSet+d-finances%3Azucq-nrc3+%3B%0D%0A++++++++++++property%3Aloan-status+%3FloanStatusURI+%3B%0D%0A++++++++++++property%3Aend-of-period+%222010-06-30T00%3A00%3A00%22%5E%5Exsd%3AdateTime+%3B%0D%0A++++++++.%0D%0A++++++++FILTER+%28%3FloanStatusURI+%3D+loan-status%3Adisbursed+%7C%7C+%3FloanStatusURI+%3D+loan-status%3Adisbursing%29%0D%0A++++++++%3Fobservation%0D%0A++++++++++++property%3Adue-to-ibrd+%3FdTI+%3B%0D%0A++++++++.%0D%0A++++++++FILTER+%28%3FdTI+%3E+0%29%0D%0A++++++++%3Fobservation%0D%0A++++++++++++property%3Acountry+%3FcountryURI+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A++++GRAPH+g-meta%3A+%7B%0D%0A++++++++%3FcountryURI+a+dbo%3ACountry+.%0D%0A++++%7D%0D%0A%7D%0D%0AGROUP+BY+%3FcountryURI+%3FobsValue%0D%0A%7D%0D%0A++++GRAPH+g-indicators%3A+%7B%0D%0A++++++++%3FobservationIndicator%0D%0A++++++++++++property%3Aindicator+indicator%3AGC.DOD.TOTL.GD.ZS+%3B%0D%0A++++++++++++sdmx-dimension%3ArefArea+%3FcountryURI+%3B%0D%0A++++++++++++sdmx-dimension%3ArefPeriod+year%3A2010+%3B%0D%0A++++++++++++sdmx-measure%3AobsValue+%3FdebtPercentageOfGDP+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A%7D%0D%0AORDER+BY+DESC%28%3FdebtPercentageOfGDP%29&default-graph-uri=&output=xml&stylesheet=%2Fxml-to-html.xsl
9
Adults who used a mobile phone to pay bills in the past 12 months (% age 15+) in countries, ordered by most to least.SELECT ?countryPrefLabel ?percentageOfAdults
WHERE {
GRAPH g-indicators: {
?obsevation
property:indicator indicator:WP11672.1 ;
sdmx-dimension:refPeriod year:2011 ;
sdmx-dimension:refArea ?countryURI ;
sdmx-measure:obsValue ?percentageOfAdults ;
.
}

GRAPH g-meta: {
?countryURI
a dbo:Country ;
skos:prefLabel ?countryPrefLabel ;
.
}
}
ORDER BY DESC(?percentageOfAdults)
http://worldbank.270a.info/sparql?query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+dcterms%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+wgs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+dcat%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Fdcat%23%3E%0D%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0APREFIX+dbp%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX+dbr%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+sdmx%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%23%3E%0D%0APREFIX+sdmx-attribute%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fattribute%23%3E%0D%0APREFIX+sdmx-code%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fcode%23%3E%0D%0APREFIX+sdmx-concept%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fconcept%23%3E%0D%0APREFIX+sdmx-dimension%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fdimension%23%3E%0D%0APREFIX+sdmx-measure%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmeasure%23%3E%0D%0APREFIX+sdmx-metadata%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmetadata%23%3E%0D%0APREFIX+sdmx-subject%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fsubject%23%3E%0D%0APREFIX+qb%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fcube%23%3E%0D%0APREFIX+year%3A+%3Chttp%3A%2F%2Freference.data.gov.uk%2Fid%2Fyear%2F%3E%0D%0APREFIX+void%3A+%3Chttp%3A%2F%2Frdfs.org%2Fns%2Fvoid%23%3E%0D%0A%0D%0APREFIX+wbld%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2F%3E%0D%0APREFIX+property%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fproperty%2F%3E%0D%0APREFIX+classification%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2F%3E%0D%0APREFIX+indicator%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Findicator%2F%3E%0D%0APREFIX+country%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcountry%2F%3E%0D%0APREFIX+income-level%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fincome-level%2F%3E%0D%0APREFIX+lending-type%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Flending-type%2F%3E%0D%0APREFIX+region%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fregion%2F%3E%0D%0APREFIX+source%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fsource%2F%3E%0D%0APREFIX+topic%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Ftopic%2F%3E%0D%0APREFIX+currency%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcurrency%2F%3E%0D%0APREFIX+project%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fproject%2F%3E%0D%0APREFIX+loan-status%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Floan-status%2F%3E%0D%0APREFIX+variable%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fvariable%2F%3E%0D%0APREFIX+global-circulation-model%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fglobal-circulation-model%2F%3E%0D%0APREFIX+scenario%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fscenario%2F%3E%0D%0A%0D%0APREFIX+d-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-development-indicators%2F%3E%0D%0APREFIX+d-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-finances%2F%3E%0D%0APREFIX+d-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-climates%2F%3E%0D%0A%0D%0A%23USE+THESE+GRAPHS+%3A%29%0D%0APREFIX+g-void%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fvoid%3E%0D%0APREFIX+g-meta%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fmeta%3E%0D%0APREFIX+g-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-climates%3E%0D%0APREFIX+g-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-finances%3E%0D%0APREFIX+g-projects%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-projects-and-operations%3E%0D%0APREFIX+g-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-development-indicators%3E%0D%0A%0D%0A%0D%0ASELECT+%3FcountryPrefLabel+%3FpercentageOfAdults%0D%0AWHERE+%7B%0D%0A++++GRAPH+g-indicators%3A+%7B%0D%0A++++++++%3Fobsevation%0D%0A++++++++++++property%3Aindicator+indicator%3AWP11672.1+%3B%0D%0A++++++++++++sdmx-dimension%3ArefPeriod+year%3A2011+%3B%0D%0A++++++++++++sdmx-dimension%3ArefArea+%3FcountryURI+%3B%0D%0A++++++++++++sdmx-measure%3AobsValue+%3FpercentageOfAdults+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A%0D%0A++++GRAPH+g-meta%3A+%7B%0D%0A++++++++%3FcountryURI%0D%0A++++++++++++a+dbo%3ACountry+%3B%0D%0A++++++++++++skos%3AprefLabel+%3FcountryPrefLabel+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A%7D%0D%0AORDER+BY+DESC%28%3FpercentageOfAdults%29&default-graph-uri=&output=xml&stylesheet=%2Fxml-to-html.xsl
10
Percentage of GDP from agriculture of top 10 countries in 2008SELECT ?countryPrefLabel ?percentageOfGDP
WHERE {
GRAPH g-indicators: {
?observations
property:indicator indicator:NV.AGR.TOTL.ZS ;
sdmx-dimension:refArea ?countryURI ;
sdmx-dimension:refPeriod year:2008 ;
sdmx-measure:obsValue ?percentageOfGDP ;
.
}
GRAPH g-meta: {
?countryURI
a dbo:Country ;
skos:prefLabel ?countryPrefLabel ;
.
}
}
ORDER BY DESC(?percentageOfGDP)
LIMIT 10
http://worldbank.270a.info/sparql?query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+dcterms%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+wgs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2003%2F01%2Fgeo%2Fwgs84_pos%23%3E%0D%0APREFIX+dcat%3A+%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Fdcat%23%3E%0D%0APREFIX+dbo%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2F%3E%0D%0APREFIX+dbp%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX+dbr%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+sdmx%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%23%3E%0D%0APREFIX+sdmx-attribute%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fattribute%23%3E%0D%0APREFIX+sdmx-code%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fcode%23%3E%0D%0APREFIX+sdmx-concept%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fconcept%23%3E%0D%0APREFIX+sdmx-dimension%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fdimension%23%3E%0D%0APREFIX+sdmx-measure%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmeasure%23%3E%0D%0APREFIX+sdmx-metadata%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmetadata%23%3E%0D%0APREFIX+sdmx-subject%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fsubject%23%3E%0D%0APREFIX+qb%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fcube%23%3E%0D%0APREFIX+year%3A+%3Chttp%3A%2F%2Freference.data.gov.uk%2Fid%2Fyear%2F%3E%0D%0APREFIX+void%3A+%3Chttp%3A%2F%2Frdfs.org%2Fns%2Fvoid%23%3E%0D%0A%0D%0APREFIX+wbld%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2F%3E%0D%0APREFIX+property%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fproperty%2F%3E%0D%0APREFIX+classification%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2F%3E%0D%0APREFIX+indicator%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Findicator%2F%3E%0D%0APREFIX+country%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcountry%2F%3E%0D%0APREFIX+income-level%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fincome-level%2F%3E%0D%0APREFIX+lending-type%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Flending-type%2F%3E%0D%0APREFIX+region%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fregion%2F%3E%0D%0APREFIX+source%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fsource%2F%3E%0D%0APREFIX+topic%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Ftopic%2F%3E%0D%0APREFIX+currency%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fcurrency%2F%3E%0D%0APREFIX+project%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fproject%2F%3E%0D%0APREFIX+loan-status%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Floan-status%2F%3E%0D%0APREFIX+variable%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fvariable%2F%3E%0D%0APREFIX+global-circulation-model%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fglobal-circulation-model%2F%3E%0D%0APREFIX+scenario%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Fscenario%2F%3E%0D%0A%0D%0APREFIX+d-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-development-indicators%2F%3E%0D%0APREFIX+d-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-finances%2F%3E%0D%0APREFIX+d-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-bank-climates%2F%3E%0D%0A%0D%0A%23USE+THESE+GRAPHS+%3A%29%0D%0APREFIX+g-void%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fvoid%3E%0D%0APREFIX+g-meta%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fmeta%3E%0D%0APREFIX+g-climates%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-climates%3E%0D%0APREFIX+g-finances%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-finances%3E%0D%0APREFIX+g-projects%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-bank-projects-and-operations%3E%0D%0APREFIX+g-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fgraph%2Fworld-development-indicators%3E%0D%0A%0D%0A%0D%0ASELECT+%3FcountryPrefLabel+%3FpercentageOfGDP%0D%0AWHERE+%7B%0D%0A++++GRAPH+g-indicators%3A+%7B%0D%0A++++++++%3Fobservations%0D%0A++++++++++++property%3Aindicator+indicator%3ANV.AGR.TOTL.ZS+%3B%0D%0A++++++++++++sdmx-dimension%3ArefArea+%3FcountryURI+%3B%0D%0A++++++++++++sdmx-dimension%3ArefPeriod+year%3A2008+%3B%0D%0A++++++++++++sdmx-measure%3AobsValue+%3FpercentageOfGDP+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A++++GRAPH+g-meta%3A+%7B%0D%0A++++++++%3FcountryURI%0D%0A++++++++++++a+dbo%3ACountry+%3B%0D%0A++++++++++++skos%3AprefLabel+%3FcountryPrefLabel+%3B%0D%0A++++++++.%0D%0A++++%7D%0D%0A%7D%0D%0AORDER+BY+DESC%28%3FpercentageOfGDP%29%0D%0ALIMIT+10&default-graph-uri=&output=xml&stylesheet=%2Fxml-to-html.xsl
11
Average energy use per income levelPREFIX sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#>
PREFIX sdmx-measure: <http://purl.org/linked-data/sdmx/2009/measure#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX qb: <http://purl.org/linked-data/cube#>
PREFIX year: <http://reference.data.gov.uk/id/year/>
PREFIX fn: <http://www.w3.org/2005/xpath-functions/#>
PREFIX bank: <http://worldbank.270a.info/property/>
PREFIX d-indicators: <http://worldbank.270a.info/dataset/world-development-indicators>

SELECT ?year (sum(?value)/count(?value) AS ?average) ?incomelevel
WHERE {
?s bank:indicator <http://worldbank.270a.info/classification/indicator/EG.USE.PCAP.KG.OE>.
?s qb:dataSet d-indicators: .
?s a qb:Observation.
?s sdmx-measure:obsValue ?value.
?s sdmx-dimension:refPeriod ?yearurl.
?s sdmx-dimension:refArea ?area.
?area bank:income-level ?incomeuri .
?incomeuri skos:prefLabel ?incomelevel
BIND (SUBSTR(STR(?yearurl),38,4) AS ?year)
} GROUP BY ?year ?incomelevel ORDER BY ?year ?incomelevel
http://worldbank.270a.info/sparql?query=PREFIX+sdmx-dimension%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fdimension%23%3E%0D%0APREFIX+sdmx-measure%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fsdmx%2F2009%2Fmeasure%23%3E%0D%0APREFIX+xsd%3A++%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0APREFIX+qb%3A+%3Chttp%3A%2F%2Fpurl.org%2Flinked-data%2Fcube%23%3E%0D%0APREFIX+year%3A+%3Chttp%3A%2F%2Freference.data.gov.uk%2Fid%2Fyear%2F%3E%0D%0APREFIX+fn%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2005%2Fxpath-functions%2F%23%3E%0D%0APREFIX+bank%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fproperty%2F%3E%0D%0APREFIX+d-indicators%3A+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fdataset%2Fworld-development-indicators%3E%0D%0A%0D%0ASELECT+%3Fyear+%28sum%28%3Fvalue%29%2Fcount%28%3Fvalue%29+AS+%3Faverage%29+%3Fincomelevel%0D%0AWHERE+%7B%0D%0A++%3Fs+bank%3Aindicator+%3Chttp%3A%2F%2Fworldbank.270a.info%2Fclassification%2Findicator%2FEG.USE.PCAP.KG.OE%3E.%0D%0A++%3Fs+qb%3AdataSet++d-indicators%3A+.%0D%0A++%3Fs+a++qb%3AObservation.%0D%0A++%3Fs+sdmx-measure%3AobsValue+%3Fvalue.%0D%0A++%3Fs+sdmx-dimension%3ArefPeriod+%3Fyearurl.%0D%0A++%3Fs+sdmx-dimension%3ArefArea+%3Farea.%0D%0A++%3Farea+bank%3Aincome-level+%3Fincomeuri+.%0D%0A++%3Fincomeuri+skos%3AprefLabel+%3Fincomelevel%0D%0A+BIND+%28SUBSTR%28STR%28%3Fyearurl%29%2C38%2C4%29+AS+%3Fyear%29%0D%0A%7D+GROUP+BY+%3Fyear+%3Fincomelevel+ORDER+BY+%3Fyear+%3Fincomelevel&default-graph-uri=&output=xml&stylesheet=%2Fxml-to-html.xslQuery from http://daviz.eionet.europa.eu/data/local-sparql-queries/averahe-energy-use-per-income-level-world-bank/@@view

See also: http://daviz.eionet.europa.eu/visualisations/average-energy-use-per-income-level-world-bank
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1