232
edits
Line 46: | Line 46: | ||
group by ?marc_creator_role ?marc_creator_role_label ?number_of_creator_statements | group by ?marc_creator_role ?marc_creator_role_label ?number_of_creator_statements | ||
order by desc(?number_of_creator_statements) | order by desc(?number_of_creator_statements) | ||
</sparql> | |||
=== How many NKCR creators don't have are not on Wikidata? === | |||
This gives the number of NKCR-disambiguated authors not found on Wikidata. | |||
<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 | |||
(count(?nkcr) as ?nkcr_count) | |||
(count(?wikidata) as ?wikidata_count) | |||
where { | |||
?wikibase_item clbdp:P5 clbwb:Q5; | |||
clbdp:P8 ?nkcr . | |||
optional {?wikibase_item clbdp:P1 ?wikidata .} | |||
</sparql> | </sparql> |