Property talk:P12627

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

British Comedy Guide person ID
Identifier of a person on comedy.co.uk

Data type	External identifier
Domain	human (Q5)
Allowed values	[a-z_-]+
Example	Phil Whelans (Q125361470) → phil_whelans Willis Hall (Q3569123) → willis_hall Gina Yashere (Q4990811) → gina_yashere
Source	https://www.comedy.co.uk/
Formatter URL	https://www.comedy.co.uk/people/$1
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Mix'n'match (Report) Database reports/Constraint violations/P12627 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 3,792 Main statement 3,788 99.9% of uses Qualifier 3 <0.1% of uses Reference 1 <0.1% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Type “human (Q5)”: item must contain property “instance of (P31)” with classes “human (Q5)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P12627#Type Q5, hourly updated report, SPARQL

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12627#Scope, SPARQL

Format “[a-z_-]+”: value must be formatted using this pattern (PCRE syntax). (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12627#Format, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P12627#Entity types

Single value: this property generally contains a single value. (Help)

List of violations of this constraint: Database reports/Constraint violations/P12627#Single value, hourly updated report, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P12627#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Show comedians that are alive and British citizens

SELECT DISTINCT ?item ?itemLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
  {
    SELECT DISTINCT ?item WHERE {
      ?item p:P106 ?statement0.
      ?statement0 (ps:P106/(wdt:P279*)) wd:Q245068.
      ?item p:P27 ?statement1.
      ?statement1 (ps:P27/(wdt:P279*)) wd:Q145.
      MINUS {
        ?item p:P12627 ?statement2.
        ?statement2 (ps:P12627) _:anyValueP12627.
      }
      MINUS {
        ?item p:P570 ?statement_3.
        ?statement_3 psv:P570 ?statementValue_3.
        ?statementValue_3 wikibase:timeValue ?P570_3.
      }
    }
    LIMIT 100
  }
}

Try it!

Back ache (talk) 14:01, 18 April 2024 (UTC)