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 ?nkcr (iri(concat("http://www.wikidata.org/entity/",?wikidata)) as ?wikidata_link) (count(?bibitem) as ?authored_publications)
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 ?authored_publications order by desc(?authored_publications)
} 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

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
  (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)

Try it!


See also some more SPARQL examples.