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=" | ") as ?titles)
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

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.