Main Page: Difference between revisions
From clb-lod
No edit summary |
|||
Line 12: | Line 12: | ||
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | ||
select ?wikibase_item (group_concat(?title;SEPARATOR=" | select ?wikibase_item ?pubtype ?1stauthor (group_concat(?title;SEPARATOR=" == ") as ?titles) | ||
where { | where { | ||
?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P6 ?title. | ?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P58 ?type; clbdp:P6 ?title. | ||
} group by ?wikibase_item ?titles | ?type rdfs:label ?pubtype . filter(lang(?pubtype)="en") | ||
optional {?wikibase_item clbp:P12 [clbps:P12 ?1stau; clbpq:P14 "1"] . | |||
?1stau clbdp:P48 ?1stauthor.} | |||
} group by ?wikibase_item ?pubtype ?1stauthor ?titles | |||
</sparql> | </sparql> | ||
=== Creators in CLB-LOD === | === Creators in CLB-LOD === | ||
<sparql tryit="1"> | <sparql tryit="1"> |
Revision as of 13:10, 19 September 2022
Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on wikibase.cloud. This is a sandbox for working towards MARC bibliographical records LOD-ification, with the final goal of their integration in Wikidata, with CLB Czech Literary Bibliography MARC-XML data as showcase. This is a project carried out in the framework of DARIAH WG Bibliodata.
SPARQL Queries
MARC records in CLB-LOD
PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
select ?wikibase_item ?pubtype ?1stauthor (group_concat(?title;SEPARATOR=" == ") as ?titles)
where {
?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P58 ?type; clbdp:P6 ?title.
?type rdfs:label ?pubtype . filter(lang(?pubtype)="en")
optional {?wikibase_item clbp:P12 [clbps:P12 ?1stau; clbpq:P14 "1"] .
?1stau clbdp:P48 ?1stauthor.}
} group by ?wikibase_item ?pubtype ?1stauthor ?titles
Creators in CLB-LOD
PREFIX clbwb: <https://clb-lod.wikibase.cloud/entity/>
PREFIX clbdp: <https://clb-lod.wikibase.cloud/prop/direct/>
PREFIX clbp: <https://clb-lod.wikibase.cloud/prop/>
PREFIX clbps: <https://clb-lod.wikibase.cloud/prop/statement/>
PREFIX clbpq: <https://clb-lod.wikibase.cloud/prop/qualifier/>
PREFIX clbpr: <https://clb-lod.wikibase.cloud/prop/reference/>
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/>
select ?wikibase_item ?label ?nkcr (iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link) (count(?bibitem) as ?authored_publications)
where {
?wikibase_item clbdp:P5 clbwb:Q5; rdfs:label ?label. filter (lang(?label)="en")
?wikibase_item clbdp:P8 ?nkcr .
optional {?wikibase_item clbdp:P1 ?wikidata .}
?bibitem clbdp:P12 ?wikibase_item.
} group by ?wikibase_item ?label ?nkcr ?wikidata ?authored_publications order by desc(?authored_publications)
See also some more SPARQL examples.