Main Page: Difference between revisions

From clb-lod
No edit summary
Line 1: Line 1:
Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on [https://wikibase.cloud wikibase.cloud].
Welcome to CLB-LOD Wikibase, a Wikibase instance hosted on [https://wikibase.cloud wikibase.cloud]. This is a sandbox for working towards MARC bibliographical records LOD-ification, with the final goal of their integration in Wikidata, with [https://clb.ucl.cas.cz/en/ CLB Czech Literary Bibliography] MARC-XML data as showcase. This is a project carried out in the framework of [https://www.dariah.eu/activities/working-groups/bibliographical-data-bibliodata/ DARIAH WG Bibliodata].


== SPARQL Queries ==
== SPARQL Queries ==
See some [[SPARQL examples]].
=== MARC records in CLB-LOD ===
<sparql tryit="1">
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 (group_concat(?title;SEPARATOR=" | ") as ?titles)
     
where {
  ?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P6 ?title.
  } group by ?wikibase_item ?titles
</sparql>
=== Creators in CLB-LOD ===
<sparql tryit="1">
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)
</sparql>
 
 
See also some more [[SPARQL examples]].

Revision as of 15:10, 31 August 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 (group_concat(?title;SEPARATOR=" | ") as ?titles)
       
where { 
  ?wikibase_item clbdp:P5 clbwb:Q3; clbdp:P6 ?title.
  } group by ?wikibase_item ?titles

Try it!

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)

Try it!


See also some more SPARQL examples.