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

From QAWiki
Jump to navigation Jump to search
(adding inverses and symmetric property queries)
 
(5 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"