Difference between revisions of "QAWiki:Curation/Quality Control Queries"

From QAWiki
Jump to navigation Jump to search
(Adding links to curation queries)
 
(adding inverses and symmetric property queries)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Quality Control Queries ==
== Quality Control Queries ==


The following is a list of queries intended to help detect specific quality issues on QAWiki using its [http://query.qawiki.dcc.uchile.cl/ SPARQL Query Service]. Not all answers returned are necessarily problematic.
The following is a list of queries intended to help detect specific quality issues on QAWiki using its [http://query.qawiki.org/ SPARQL Query Service]. Not all answers returned are necessarily problematic.


=== Untyped questions ===  
=== Untyped questions ===  


[http://query.qawiki.dcc.uchile.cl/#%23%20untyped%20questions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20untyped%20questions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Questions with no queries ===
=== Questions with no queries ===


[http://query.qawiki.dcc.uchile.cl/#%23%20questions%20with%20no%20queries%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20questions%20with%20no%20queries%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Questions with no entity mentions ===
=== Questions with no entity mentions ===


[http://query.qawiki.dcc.uchile.cl/#%23%20questions%20with%20no%20entity%20mentions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP38%20%3Fobj%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link; not all results are necessarily problematic]
[http://query.qawiki.org/#%23%20questions%20with%20no%20entity%20mentions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP47%2a%2Fwdt%3AP38%20%3Fobj%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link] (not all results are necessarily problematic)


=== Questions with mentions without Wikidata link
=== Questions with mentions without Wikidata link ===


[http://query.qawiki.dcc.uchile.cl/#%23%20mentions%20with%20no%20Wikidata%20item%20ID%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fobj%20pq%3AP17%7Cpq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Fobj2%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20mentions%20with%20no%20Wikidata%20item%20ID%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fobj%20pq%3AP17%7Cpq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Fobj2%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Items with some label but not in (e.g.) Spanish ===
=== Items with some label but not in (e.g.) Spanish ===


[http://query.qawiki.dcc.uchile.cl/#%23%20items%20with%20labels%20but%20no%20Spanish%20label%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20%3Fo%20.%0A%20%20%3Fsbj%20rdfs%3Alabel%20%3Flab%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20rdfs%3Alabel%20%3Flab2%20.%20FILTER%28lang%28%3Flab2%29%3D%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link; can change <code>es</code> to other languages]
[http://query.qawiki.org/#%23%20items%20with%20labels%20but%20no%20Spanish%20label%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20%3Fo%20.%0A%20%20%3Fsbj%20rdfs%3Alabel%20%3Flab%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20rdfs%3Alabel%20%3Flab2%20.%20FILTER%28lang%28%3Flab2%29%3D%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link] (can change <code>es</code> to other languages)


=== Questions with some mentions but not in (e.g.) Spanish ===
=== Questions with some mentions but not in (e.g.) Spanish ===


[http://query.qawiki.dcc.uchile.cl/#%23%20questions%20with%20no%20Spanish%20mentions%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20wdt%3AP38%20%3Fobj%20.%20FILTER%28lang%28%3Fobj%29%20%3D%20%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link; can change <code>es</code> to other languages]
[http://query.qawiki.org/#%23%20questions%20with%20no%20Spanish%20mentions%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20wdt%3AP38%20%3Fobj%20.%20FILTER%28lang%28%3Fobj%29%20%3D%20%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link] (can change <code>es</code> to other languages)


=== Queries with no dataset specified ===
=== Queries with no dataset specified ===


[http://query.qawiki.dcc.uchile.cl/#%23%20queries%20with%20no%20dataset%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP13%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20queries%20with%20no%20dataset%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP13%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Queries with no query language specified ===
=== Queries with no query language specified ===


[http://query.qawiki.dcc.uchile.cl/#%23%20queries%20with%20no%20query%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP12%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20queries%20with%20no%20query%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP12%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Wikidata item IDs that do not start with <code>Q</code> ===
=== Wikidata item IDs that do not start with <code>Q</code> ===


[http://query.qawiki.dcc.uchile.cl/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP17%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22Q%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP17%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22Q%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Wikidata property IDs that do not start with <code>P</code> ===
=== Wikidata property IDs that do not start with <code>P</code> ===


[http://query.qawiki.dcc.uchile.cl/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP50%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22P%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP50%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22P%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]


=== Mentions not contained in question label or alias with the same language ===
=== Mentions not contained in question label or alias with the same language ===


[http://query.qawiki.dcc.uchile.cl/#%23%20Mentions%20not%20contained%20in%20a%20label%20or%20alias%20with%20the%20same%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fsbj%20rdfs%3Alabel%7Cskos%3AaltLabel%20%3Ffull%20.%0A%20%20%20%20FILTER%28lang%28%3Ffull%29%3Dlang%28%3Fmention%29%20%26%26%20contains%28str%28%3Ffull%29%2Cstr%28%3Fmention%29%29%29%0A%20%20%7D%0A%20%20FILTER%28%21contains%28str%28%3Fmention%29%2C%22%2a%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
[http://query.qawiki.org/#%23%20Mentions%20not%20contained%20in%20a%20label%20or%20alias%20with%20the%20same%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fsbj%20rdfs%3Alabel%7Cskos%3AaltLabel%20%3Ffull%20.%0A%20%20%20%20FILTER%28lang%28%3Ffull%29%3Dlang%28%3Fmention%29%20%26%26%20contains%28str%28%3Ffull%29%2Cstr%28%3Fmention%29%29%29%0A%20%20%7D%0A%20%20FILTER%28%21contains%28str%28%3Fmention%29%2C%22%2a%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
 
=== Same mentions across languages with different Wikidata IDs ===
[https://query.qawiki.org/#%23%20Same%20mentions%20across%20languages%20with%20different%20Wikidata%20IDs%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention1%20%3Fmention2%20%3Fwd1%20%3Fwd2%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj1%20.%20%3Fobj1%20ps%3AP38%20%3Fmention1%20.%20%3Fobj1%20pq%3AP17%20%3Fwd1%20.%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj2%20.%20%3Fobj2%20ps%3AP38%20%3Fmention2%20.%0A%20%20FILTER%28%3Fobj1%20%21%3D%20%3Fobj2%20%26%26%20STR%28%3Fmention1%29%20%3D%20STR%28%3Fmention2%29%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fobj2%20pq%3AP17%20%3Fwd1%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]
 
=== Check that all inverse relations are provided ===
[https://query.qawiki.org/#%23%20query%20to%20check%20that%20all%20inverses%20are%20provided%0ASELECT%20%3Fs%20%3Fpd%20%3Fo%20%3Fpdi%20WHERE%20%7B%0A%20%20%3Fp%20a%20wikibase%3AProperty%20.%0A%20%20%3Fp%20wikibase%3AdirectClaim%20%3Fpd%20.%0A%20%20%3Fp%20wdt%3AP31%20%3Fpi%20.%0A%20%20%3Fpi%20wikibase%3AdirectClaim%20%3Fpdi%20.%0A%20%20%3Fs%20%3Fpd%20%3Fo%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fo%20%3Fpdi%20%3Fs%20%7D%0A%7D Link]
 
=== Check that all symmetric relations are provided ===
[https://query.qawiki.org/#%23%20query%20to%20check%20that%20all%20symmetric%20relations%20are%20provided%0ASELECT%20%3Fs%20%3Fpd%20%3Fo%20%3Fpdi%20WHERE%20%7B%0A%20%20%3Fp%20a%20wikibase%3AProperty%20.%0A%20%20%3Fp%20wikibase%3AdirectClaim%20%3Fpd%20.%0A%20%20%3Fp%20wdt%3AP1%20wd%3AQ62%20.%0A%20%20%3Fs%20%3Fpd%20%3Fo%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fo%20%3Fpd%20%3Fs%20.%20%7D%0A%7D Link]

Latest revision as of 02:01, 22 May 2025

Quality Control Queries[edit | edit source]

The following is a list of queries intended to help detect specific quality issues on QAWiki using its SPARQL Query Service. Not all answers returned are necessarily problematic.

Untyped questions[edit | edit source]

Link

Questions with no queries[edit | edit source]

Link

Questions with no entity mentions[edit | edit source]

Link (not all results are necessarily problematic)

Questions with mentions without Wikidata link[edit | edit source]

Link

Items with some label but not in (e.g.) Spanish[edit | edit source]

Link (can change es to other languages)

Questions with some mentions but not in (e.g.) Spanish[edit | edit source]

Link (can change es to other languages)

Queries with no dataset specified[edit | edit source]

Link

Queries with no query language specified[edit | edit source]

Link

Wikidata item IDs that do not start with Q[edit | edit source]

Link

Wikidata property IDs that do not start with P[edit | edit source]

Link

Mentions not contained in question label or alias with the same language[edit | edit source]

Link

Same mentions across languages with different Wikidata IDs[edit | edit source]

Link

Check that all inverse relations are provided[edit | edit source]

Link

Check that all symmetric relations are provided[edit | edit source]

Link

Retrieved from "http://qawiki.org/w/index.php?title=QAWiki:Curation/Quality_Control_Queries&oldid=14743"