query-1af991eb6c4467a9dc0c2c54a5d21b29

rq turtle/ttl

set preferred rank 15:35, 29 June 2019 (UTC) Jura: who seem to have worked with it. --- IvanP (most recent value should have preferred rank, all others normal rank). However, I don't use it myself and it's a different type of data. @(P1081)Human Development Index When looking at the data for the previous request, it occurred to me that maybe the same as above should be done for 16:33, 29 June 2019 (UTC)) talk (IvanP added current estimates but the outdated ones should be deleted. (I am not familiar with OpenRefine yet and actually did the HDI stuff manually back then. 😲) -- Bodhisattwa: I just wanted to note that HDI estimates for certain years have changed, e.g., the HDI of Germany in 1995 was given as 0.830 at the time I added the value to Wikidata, now it is 0.834. Jura1@

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT (URI(CONCAT("https://www.wikidata.org/wiki/",strafter(str(?item), "y/"),"#P1081")) as ?click) 
        ?year ?v ?url ?rank 
        ?statedin
WHERE
{
    BIND(wd:Q1025 as ?item) 
    ?item p:P1081 ?st . 
    ?st ps:P1081 ?v .
    OPTIONAL { ?st prov:wasDerivedFrom/pr:P854 ?url }
    OPTIONAL { ?st pq:P585 ?year } .
    OPTIONAL { ?st prov:wasDerivedFrom/pr:P248 ?statedin } .
    ?st wikibase:rank ?rank 
}
ORDER BY ?year

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v8("?click") v2("?item"):::projected v7("?rank"):::projected v3("?st") v6("?statedin"):::projected v5("?url"):::projected v4("?v"):::projected v1("?year"):::projected a1((" ")) a2((" ")) bind0[/"'wd:Q1025'"/] bind0 --as--o v2 v2 --"p:P1081"--> v3 v3 --"p:statement/P1081"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."prov:wasDerivedFrom".-> a1 a1 --"p:reference/P854"--> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."p:qualifier/P585".-> v1 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v3 -."prov:wasDerivedFrom".-> a2 a2 --"p:reference/P248"--> v6 end v3 --"wikibase:rank"--> v7 bind1[/"concat('https://www.wikidata.org/wiki/',substring-after(str(?item),'y/'),'#P1081')"/] v2 --o bind1 bind1 --as--o v8