Wikidata:WikiProject property constraints/reports/many exceptions

This report lists constraints with many (>=25) exceptions defined. This may indicate a poor property constraint definition.

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | TABernacle | Find images Recent changes | Query: SELECT ?item ?property ?propertyLink ?propertyLabel ?constraint ?deeplink (COUNT(?s) AS ?exceptions) WHERE { ?property p:P2302 ?s . ?s ps:P2302 ?constraint; pq:P2303 ?exception . SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } BIND(CONCAT('[[Property:', STRAFTER(STR(?property), 'entity/'), '|', STRAFTER(STR(?property), 'entity/'), ']]') AS ?propertyLink) . BIND(CONCAT('[[Property:', STRAFTER(STR(?property), 'entity/'), '#', STRAFTER(STR(?property), 'entity/'), '$', SUBSTR(STR(?s), STRLEN(STR(?s))-35), '|Constraint definition]]') AS ?deeplink) . BIND(IRI(CONCAT('http://www.wikidata.org/entity/Q', STR(xsd:integer(SUBSTR(REPLACE(STRAFTER(STR(?s), 'statement/'), '[a-zA-Z\\-]', ''), 5, 8))))) AS ?item) . } GROUP BY ?item ?property ?propertyLabel ?s ?constraint ?deeplink ?propertyLink HAVING (?exceptions >= 25) ORDER BY DESC(?exceptions)
Property Label Constraint Number of exceptions Constraint definition
P225 taxon name distinct values constraint 2095 Constraint definition
P579 IMA status and/or rank item requires statement constraint 683 Constraint definition
P650 RKDartists ID item requires statement constraint 228 Constraint definition
P650 RKDartists ID item requires statement constraint 228 Constraint definition
P650 RKDartists ID item requires statement constraint 227 Constraint definition
P771 Swiss municipality code item requires statement constraint 190 Constraint definition
P380 Mérimée ID distinct values constraint 189 Constraint definition
P301 category's main topic distinct values constraint 172 Constraint definition
P227 GND ID distinct values constraint 127 Constraint definition
P350 RKDimages ID single value constraint 124 Constraint definition
P484 IMA Number, broad sense single value constraint 123 Constraint definition
P345 IMDb ID single value constraint 120 Constraint definition
P14 traffic sign distinct values constraint 111 Constraint definition
P434 MusicBrainz artist ID single value constraint 109 Constraint definition
P988 Philippine Standard Geographic Code format constraint 108 Constraint definition
P1828 IPI name number single value constraint 96 Constraint definition
P778 Church of Sweden parish code distinct values constraint 96 Constraint definition
P345 IMDb ID conflicts-with constraint 85 Constraint definition
P1451 motto text single value constraint 74 Constraint definition
P1795 Smithsonian American Art Museum person/institution ID item requires statement constraint 70 Constraint definition
P1795 Smithsonian American Art Museum person/institution ID item requires statement constraint 70 Constraint definition
P1795 Smithsonian American Art Museum person/institution ID item requires statement constraint 70 Constraint definition
P1795 Smithsonian American Art Museum person/institution ID item requires statement constraint 70 Constraint definition
P2626 Danish National Filmography person ID single value constraint 64 Constraint definition
P771 Swiss municipality code item requires statement constraint 63 Constraint definition
P245 Union List of Artist Names ID single value constraint 55 Constraint definition
P4288 UK National Fruit Collection ID distinct values constraint 55 Constraint definition
P649 NRHP reference number single value constraint 54 Constraint definition
P350 RKDimages ID distinct values constraint 48 Constraint definition
P690 space group single value constraint 47 Constraint definition
P4200 Christie's creator ID item requires statement constraint 46 Constraint definition
P4200 Christie's creator ID item requires statement constraint 46 Constraint definition
P4200 Christie's creator ID item requires statement constraint 46 Constraint definition
P1256 Iconclass notation distinct values constraint 45 Constraint definition
P8449 Churches in Limburg distinct values constraint 44 Constraint definition
P902 HDS ID item requires statement constraint 42 Constraint definition
P712 Nickel-Strunz 9th edition (updated 2009) item requires statement constraint 41 Constraint definition
P1971 number of children range constraint 40 Constraint definition
P1566 GeoNames ID item requires statement constraint 40 Constraint definition
P18 image format constraint 40 Constraint definition
P1679 Art UK artwork ID single value constraint 38 Constraint definition
P711 Strunz 8th edition (series ID, updated) item requires statement constraint 37 Constraint definition
P6665 Pro-Linux.de DBApp ID single value constraint 36 Constraint definition
P3371 Observatoire du Patrimoine Religieux ID single value constraint 36 Constraint definition
P2018 Teuchos ID single value constraint 36 Constraint definition
P5161 Trustpilot company ID item requires statement constraint 35 Constraint definition
P22 father single best value constraint 34 Constraint definition
P2611 TED speaker ID item requires statement constraint 33 Constraint definition
P605 NUTS code item requires statement constraint 31 Constraint definition
P3614 DigDag ID single value constraint 31 Constraint definition
P1014 Art & Architecture Thesaurus ID distinct values constraint 30 Constraint definition
P1138 Kunstindeks Danmark Artist ID item requires statement constraint 29 Constraint definition
P1138 Kunstindeks Danmark Artist ID item requires statement constraint 29 Constraint definition
P1138 Kunstindeks Danmark Artist ID item requires statement constraint 29 Constraint definition
P1138 Kunstindeks Danmark Artist ID item requires statement constraint 29 Constraint definition
P771 Swiss municipality code item requires statement constraint 28 Constraint definition
P771 Swiss municipality code item requires statement constraint 28 Constraint definition
P4887 Web umenia creator ID single value constraint 27 Constraint definition
P8406 Grove Art Online ID distinct values constraint 26 Constraint definition
P866 Perlentaucher ID single value constraint 26 Constraint definition
P541 office contested contemporary constraint 26 Constraint definition
P2843 Benezit ID item requires statement constraint 25 Constraint definition
P2843 Benezit ID item requires statement constraint 25 Constraint definition
P345 IMDb ID distinct values constraint 25 Constraint definition
P885 origin of the watercourse item requires statement constraint 25 Constraint definition
End of automatically generated list.