A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Site: http://worldbank.270a.info/ | |||||||||||||||||||
2 | SPARQL Endpoint: http://worldbank.270a.info/sparql | |||||||||||||||||||
3 | ||||||||||||||||||||
4 | ||||||||||||||||||||
5 | ||||||||||||||||||||
6 | Query | SPARQL Query | SPARQL Endpoint Query | Comments | ||||||||||||||||
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 IBRD | SELECT ?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 2008 | SELECT ?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 level | PREFIX 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.xsl | Query 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 |