Quality control queries: Difference between revisions

From Black Bibliography Project
Jump to navigation Jump to search
(A list of SPARQL queries that can be used to hone in on data that is ready to be cleaned up or enhanced.)
 
 
(46 intermediate revisions by 2 users not shown)
Line 1: Line 1:
QC Sparql Time
=Missing Required Statements=
==Works==
===Missing Literary Form===
Get a list of works that lack an accurate "Literary Form" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without accurate Instance of statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P11 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel
</pre>
 
===Missing Language===
Get a list of works that lack an "language" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without Language statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel
</pre>
 
==Editions==
=== Missing "edition of" statements ===
 
Get a list of editions that lack an "edition of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Edition of statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P13 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel
</pre>
 
===Missing Format Statements===
Get a list of editions that lack a "Format" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Format statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P37 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel
</pre>
 
===Missing Series Title Statements===
Get a list of editions that are part of a series, but lack a "Series Title" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions in series without series title statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 ;
            wdt:P25 [].
    MINUS { ?edition wdt:P26 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel
</pre>
 
==Copies==
 
=== Missing "copy of" statements ===
 
Get a list of copies that lack an "copy of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P41 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel
</pre>
 
===Missing "Held By" Statements ===
 
Get a list of copies that lack an "copy of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P43 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel
</pre>
 
==Issues==
=== Missing "issue of" statements ===
 
Get a list of copies that lack an "copy of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Issues without Issue of statement.
SELECT ?issue ?issueLabel
WHERE
{
    ?issue wdt:P8 wd:Q739 .
    MINUS { ?issue wdt:P111 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?issueLabel
</pre>
 
==Translations==
=== Missing "translation of" statements ===
 
Get a list of translated works that lack an "translation of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P130 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel
</pre>
 
=== Missing Language Statements ===
 
Get a list of translated works that lack a "language" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel
</pre>
 
== Oration ==
=== Missing "oration of" statements ===
 
Get a list of oration that lack an "oration of" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P142 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel
</pre>
 
=== Missing "Orator" statements ===
 
Get a list of oration that lack an "orator" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P141 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel
</pre>
 
== Missing instance statements (NEEDS REVISION) ==
Get a list of Item pages that lack an "instance of" declaration:
<pre>
# Return all items that are missing an "instance of" statement
prefix wbb: <http://wikiba.se/ontology-beta#>
prefix wb: <http://wikiba.se/ontology#>
 
SELECT ?label ?link
WHERE
{
?item rdf:type ?wbitem ;
      rdfs:label ?label .   
FILTER(?wbitem in (wbb:Item, wb:Item))
FILTER((LANG(?label)) = "en")
FILTER NOT EXISTS { ?item wdt:P8 ?type }
BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?item) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
order by ?label
</pre>
[http://172.17.10.220:8834/embed.html#prefix%20wbb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology-beta%23%3E%20%0Aprefix%20wb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%20%0A%0ASELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdf%3Atype%20%3Fwbitem%20%3B%0A%20%20%20%20%20%20%20rdfs%3Alabel%20%3Flabel%20.%20%20%20%20%0A%20FILTER%28%3Fwbitem%20in%20%28wbb%3AItem%2C%20wb%3AItem%29%29%0A%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22en%22%29%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP8%20%3Ftype%20%7D%0A%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fitem%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Aorder%20by%20%3Flabel Try it out!]
 
==Authorities==
 
===Missing Wikidata Identifiers===
 
====Humans Without a Wikidata Identifier====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a Wikidata Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel
</pre>
 
====Corporate Bodies Without a Wikidata Identifier====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a Wikidata Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel
</pre>
 
====Places Without a Wikidata Identifier====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a Wikidata Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel
</pre>
 
===Missing Library of Congress Authority IDs===
 
====Humans Without a Library of Congress Authority ID====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a LOC Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel
</pre>
 
====Corporate Bodies Without a Library of Congress Authority ID====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a LOC Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel
</pre>
 
====Places Without a Library of Congress Authority ID====
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a LOC Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel
</pre>
 
== Checking in on the Andrews List editions (NEEDS REVISION)==
<pre>
# list of editions associated with the Andrews bibliography
SELECT
?editionLabel
?link
(group_concat(distinct ?publisherLabel;separator='; ') as ?publishers)
(group_concat(distinct ?pubPlaceLabel;separator='; ') as ?publishedPlaces)
(group_concat(distinct ?pubDate;separator='; ') as ?publishedDates)
 
(group_concat(distinct ?printerLabel;separator='; ') as ?printers)
(group_concat(distinct ?printPlaceLabel;separator='; ') as ?printedPlaces)
(group_concat(distinct ?printDate;separator='; ') as ?printedDates)
 
WHERE {
?edition wdt:P121 wd:Q1176 ; #wd:Q1176 is the Andrews bibliography
          rdfs:label ?editionLabel .
 
  OPTIONAL {?edition wdt:P29 ?publisher . ?publisher rdfs:label ?publisherLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P30 ?pubPlace . ?pubPlace rdfs:label ?pubPlaceLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P31 ?pubDate }.
 
  OPTIONAL {?edition wdt:P32 ?printer . ?printer rdfs:label ?printerLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P30 ?printPlace . ?printPlace rdfs:label ?printPlaceLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P31 ?printDate }.
 
 
  BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?edition) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
group by ?editionLabel ?link
</pre>
[http://172.17.10.220:8834/embed.html#%23%20list%20of%20editions%20associated%20with%20the%20Andrews%20biography%20that%20lack%20a%20pubilshed%20by%20statement%2C%20but%20might%20have%20a%20printed%20by%20statement%0ASELECT%20%0A%3FeditionLabel%0A%3Flink%20%0A%28group_concat%28distinct%20%3FpublisherLabel%3Bseparator%3D%27%3B%20%27%29%20as%20%3Fpublishers%29%20%0A%28group_concat%28distinct%20%3FpubPlaceLabel%3Bseparator%3D%27%3B%20%27%29%20as%20%3FpublishedPlaces%29%0A%28group_concat%28distinct%20%3FpubDate%3Bseparator%3D%27%3B%20%27%29%20as%20%3FpublishedDates%29%0A%0A%28group_concat%28distinct%20%3FprinterLabel%3Bseparator%3D%27%3B%20%27%29%20as%20%3Fprinters%29%20%0A%28group_concat%28distinct%20%3FprintPlaceLabel%3Bseparator%3D%27%3B%20%27%29%20as%20%3FprintedPlaces%29%0A%28group_concat%28distinct%20%3FprintDate%3Bseparator%3D%27%3B%20%27%29%20as%20%3FprintedDates%29%0A%0AWHERE%20%7B%0A%20%3Fedition%20wdt%3AP121%20wd%3AQ1176%20%3B%20%23wd%3AQ1176%20is%20the%20Andrews%20bibliography%0A%20%20%20%20%20%20%20%20%20%20rdfs%3Alabel%20%3FeditionLabel%20.%0A%20%20%20%0A%20%20OPTIONAL%20%7B%3Fedition%20wdt%3AP29%20%3Fpublisher%20.%20%3Fpublisher%20rdfs%3Alabel%20%3FpublisherLabel%20%7D.%0A%20%20OPTIONAL%20%7B%3Fedition%20%3Fhas%20%3FpubStmt%20.%20%3FpubStmt%20ps%3AP29%20%3Fpublisher%20%3B%20pq%3AP30%20%3FpubPlace%20.%20%3FpubPlace%20rdfs%3Alabel%20%3FpubPlaceLabel%20%7D.%0A%20%20OPTIONAL%20%7B%3Fedition%20%3Fhas%20%3FpubStmt%20.%20%3FpubStmt%20ps%3AP29%20%3Fpublisher%20%3B%20pq%3AP31%20%3FpubDate%20%7D.%0A%20%20%0A%20%20OPTIONAL%20%7B%3Fedition%20wdt%3AP32%20%3Fprinter%20.%20%3Fprinter%20rdfs%3Alabel%20%3FprinterLabel%20%7D.%0A%20%20OPTIONAL%20%7B%3Fedition%20%3Fhas%20%3FprintStmt%20.%20%3FprintStmt%20ps%3AP32%20%3Fprinter%20%3B%20pq%3AP30%20%3FprintPlace%20.%20%3FprintPlace%20rdfs%3Alabel%20%3FprintPlaceLabel%20%7D.%0A%20%20OPTIONAL%20%7B%3Fedition%20%3Fhas%20%3FprintStmt%20.%20%3FprintStmt%20ps%3AP32%20%3Fprinter%20%3B%20pq%3AP31%20%3FprintDate%20%7D.%0A%20%20%0A%20%20%0A%20%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fedition%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Agroup%20by%20%3FeditionLabel%20%3Flink Try it out!]
 
=Incorrectly Linked Statements (NEEDS REVISION)=
 
=="Edition of" Statements==
 
Get a list of editions that include an "edition of" statement for something other than a work:
 
=="Copy of" Statements==
 
Get a list of copies that include a "copy of" statement for something other than an edition or issue:
 
=="Issue of" Statements==
 
Get a list of serial issues that include an "issue of" statement for something other than a serial:

Latest revision as of 14:19, 20 June 2025

Missing Required Statements

Works

Missing Literary Form

Get a list of works that lack an accurate "Literary Form" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without accurate Instance of statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P11 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel

Missing Language

Get a list of works that lack an "language" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without Language statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel

Editions

Missing "edition of" statements

Get a list of editions that lack an "edition of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Edition of statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P13 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Missing Format Statements

Get a list of editions that lack a "Format" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Format statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P37 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Missing Series Title Statements

Get a list of editions that are part of a series, but lack a "Series Title" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions in series without series title statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 ;
             wdt:P25 [].
    MINUS { ?edition wdt:P26 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Copies

Missing "copy of" statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P41 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel

Missing "Held By" Statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P43 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel

Issues

Missing "issue of" statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Issues without Issue of statement.
SELECT ?issue ?issueLabel
WHERE
{
    ?issue wdt:P8 wd:Q739 .
    MINUS { ?issue wdt:P111 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?issueLabel

Translations

Missing "translation of" statements

Get a list of translated works that lack an "translation of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P130 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel

Missing Language Statements

Get a list of translated works that lack a "language" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel

Oration

Missing "oration of" statements

Get a list of oration that lack an "oration of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P142 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel

Missing "Orator" statements

Get a list of oration that lack an "orator" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P141 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel

Missing instance statements (NEEDS REVISION)

Get a list of Item pages that lack an "instance of" declaration: 

# Return all items that are missing an "instance of" statement
prefix wbb: <http://wikiba.se/ontology-beta#> 
prefix wb: <http://wikiba.se/ontology#> 

SELECT ?label ?link
WHERE
{
 ?item rdf:type ?wbitem ;
       rdfs:label ?label .    
 FILTER(?wbitem in (wbb:Item, wb:Item))
 FILTER((LANG(?label)) = "en")
 FILTER NOT EXISTS { ?item wdt:P8 ?type }
 BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?item) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
order by ?label

Try it out!

Authorities

Missing Wikidata Identifiers

Humans Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a Wikidata Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel

Corporate Bodies Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a Wikidata Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel

Places Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a Wikidata Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel

Missing Library of Congress Authority IDs

Humans Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a LOC Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel

Corporate Bodies Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a LOC Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel

Places Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a LOC Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel

Checking in on the Andrews List editions (NEEDS REVISION)

# list of editions associated with the Andrews bibliography
SELECT 
?editionLabel
?link 
(group_concat(distinct ?publisherLabel;separator='; ') as ?publishers) 
(group_concat(distinct ?pubPlaceLabel;separator='; ') as ?publishedPlaces)
(group_concat(distinct ?pubDate;separator='; ') as ?publishedDates)

(group_concat(distinct ?printerLabel;separator='; ') as ?printers) 
(group_concat(distinct ?printPlaceLabel;separator='; ') as ?printedPlaces)
(group_concat(distinct ?printDate;separator='; ') as ?printedDates)

WHERE {
 ?edition wdt:P121 wd:Q1176 ; #wd:Q1176 is the Andrews bibliography
          rdfs:label ?editionLabel .
   
  OPTIONAL {?edition wdt:P29 ?publisher . ?publisher rdfs:label ?publisherLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P30 ?pubPlace . ?pubPlace rdfs:label ?pubPlaceLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P31 ?pubDate }.
  
  OPTIONAL {?edition wdt:P32 ?printer . ?printer rdfs:label ?printerLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P30 ?printPlace . ?printPlace rdfs:label ?printPlaceLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P31 ?printDate }.
  
  
  BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?edition) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
group by ?editionLabel ?link

Try it out!

Incorrectly Linked Statements (NEEDS REVISION)

"Edition of" Statements

Get a list of editions that include an "edition of" statement for something other than a work:

"Copy of" Statements

Get a list of copies that include a "copy of" statement for something other than an edition or issue:

"Issue of" Statements

Get a list of serial issues that include an "issue of" statement for something other than a serial:

Retrieved from "http://blackbibliog.rutgers.edu/w/index.php?title=Quality_control_queries&oldid=285373"