query-f5ce4e19e7dc7303020d8825eee8d9a7

rq turtle/ttl

reference URL (P854) → Holocaust.cz person ID (P9109) (2021-02-05) Daniel Baránek: Request date: 5 February 2021, byTask description here: (P9109)Holocaust.cz person ID value and value for (P854)reference URL . It is 285,282 references. You can see all references, their this in references can be replaced by this new identificator. The result of edits should be like (P854)reference URL , (P9109)Holocaust.cz person ID After intoducing

Use at

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
SELECT ?ref ?url ?id WHERE {
  ?ref prov:wasDerivedFrom [ pr:P248 wd:Q104074149 ; pr:P854 ?url ].
  BIND (REPLACE(STR(?url),"^.*/([0-9]+)[-/].*$","$1") as ?id)
  }

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?id"):::projected v2("?ref"):::projected v1("?url"):::projected a1((" ")) c2(["wd:Q104074149"]):::iri a1 --"pr:P248"--> c2 a1 --"pr:P854"--> v1 v2 --"prov:wasDerivedFrom"--> a1 bind0[/"replace(str(?url),'^.*/(#91;0-9#93;+)#91;-/#93;.*$','$1')"/] v1 --o bind0 bind0 --as--o v3