Main Page: Difference between revisions
From clb-lod
| Line 32: | Line 32: | ||
PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | PREFIX clbno: <https://clb-lod.wikibase.cloud/prop/novalue/> | ||
select ?wikibase_item ?label | select ?wikibase_item ?label | ||
(iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link) | |||
(iri(concat("https://aleph.nkp.cz/F/?func=find-c&local_base=aut&ccl_term=ica=",?nkcr)) as ?nkcr_link) | |||
(count(?bibitem) as ?author_roles) | |||
where { | where { | ||
| Line 38: | Line 41: | ||
?wikibase_item clbdp:P8 ?nkcr . | ?wikibase_item clbdp:P8 ?nkcr . | ||
optional {?wikibase_item clbdp:P1 ?wikidata .} | optional {?wikibase_item clbdp:P1 ?wikidata .} | ||
?bibitem clbdp:P12 ?wikibase_item. | optional {?bibitem clbdp:P12 ?wikibase_item .} | ||
} group by ?wikibase_item ?label ?nkcr ?wikidata ? | } group by ?wikibase_item ?label ?nkcr ?wikidata ?author_roles order by desc(?author_roles) | ||
</sparql> | </sparql> | ||
See also some more [[SPARQL examples]]. | See also some more [[SPARQL examples]]. | ||
Revision as of 13:15, 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
(iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link)
(iri(concat("https://aleph.nkp.cz/F/?func=find-c&local_base=aut&ccl_term=ica=",?nkcr)) as ?nkcr_link)
(count(?bibitem) as ?author_roles)
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 .}
optional {?bibitem clbdp:P12 ?wikibase_item .}
} group by ?wikibase_item ?label ?nkcr ?wikidata ?author_roles order by desc(?author_roles)
See also some more SPARQL examples.
