Property talk:P12496

Documentation

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

WhatPub pub ID
identifier for a pub on WhatPub

Represents	WhatPub (Q112305367)
Associated item	WhatPub (Q112305367)
Applicable "stated in" value	WhatPub (Q112305367)
Data type	External identifier
Domain	alcohol drinking establishment (Q5307737)
Allowed values	^[A-Z]{3}/[\w-]+$
Example	Jamaica Inn (Q1328052) → COR/23 Kings Head Hotel (Q1045316) → NEW/494 The White Hart Public House (Q26410012) → OXF/N-31 Ye Olde Cheshire Cheese (Q1771680) → ELC/14927
Source	https://whatpub.com
Formatter URL	https://camra.org.uk/$1 https://whatpub.com/pubs/$1
Related to country	United Kingdom (Q145) (See 351 others)
See also	Pubs Galore ID (P7411)
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 Items with deprecated claims Usage history (total) Usage history (main statement) Chart by item creation date Database reports/Constraint violations/P12496 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 33,965 Main statement 15,400 out of 54,802 (28% complete) 45.3% of uses Qualifier 13 <0.1% of uses Reference 18,552 54.6% of uses
Search for values

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

Single value: this property generally contains a single value. (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/P12496#Single value, SPARQL

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

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: The Travellers Rest (Q131312045), Curious Cow (Q131312055)
List of violations of this constraint: Database reports/Constraint violations/P12496#Unique value, SPARQL (every item), SPARQL (by value)

Format “^[A-Z]{3}/[\w-]+$”: 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/P12496#Format, SPARQL

Type “alcohol drinking establishment (Q5307737)”: item must contain property “instance of (P31)” with classes “alcohol drinking establishment (Q5307737)” or their subclasses (defined using subclass of (P279)). (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/P12496#Type Q5307737, SPARQL

Item “country (P17): United Kingdom (Q145), Isle of Man (Q9676), Jersey (Q785), Guernsey (Q25230)”: Items with this property should also have “country (P17): United Kingdom (Q145), Isle of Man (Q9676), Jersey (Q785), Guernsey (Q25230)”. (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/P12496#Item P17, search

Item “located in the administrative territorial entity (P131)”: Items with this property should also have “located in the administrative territorial entity (P131)”. (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/P12496#Item P131, search, SPARQL

Item “Pubs Galore ID (P7411)”: Items with this property should also have “Pubs Galore ID (P7411)”. (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/P12496#Item P7411, search, 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/P12496#Entity types

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/P12496#Scope, SPARQL

Item “CAMRA pub ID (P13516)”: Items with this property should also have “CAMRA pub ID (P13516)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: The Under Milk Wood (Q80582145), Chiquito (Q80584783), Cafe Rouge (Q80859081), Mimosa (Q80859116)
List of violations of this constraint: Database reports/Constraint violations/P12496#Item P13516, search, SPARQL

Label required in languages: en: Entities using this property should have labels in one of the following languages: en (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/P12496#Label in 'en' language, search, SPARQL

Description required in languages: en: Entities using this property should have descriptions in one of the following languages: en (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/P12496#Description in 'en' language, search, SPARQL

Closing

@Jheald, Kirilloparma, Lewis Hulbert, Tæppa: WhatPub will be closing on 25 August like what happened to Canmore. I guess we can just move this to CAMRA pub ID (P13516). Lucywood (talk) 21:58, 29 July 2025 (UTC)

The URL match pattern @Back_ache: attempted to add should work [1].

For example The Eagle and Child (Q82190) has WhatPub pub ID (P12496) OXF/C-15 , which can be injected into the CAMRA URL as https:// camra.org.uk/OXF/C-15 in order to redirect to the working URL of https:// camra.org.uk/pubs/eagle-child-oxford-156969 . Tæppa (talk) 13:49, 30 July 2025 (UTC)

The ~250 [2] regional CAMRA branches are still issuing new "WhatPub" codes, which CAMRA then turn into a unique number for their website, so it's still in scope for Wikidata. I would say the only constraint should be that an item also has CAMRA pub ID (P13516), and the issued by (P2378) statement for WhatPub pub ID (P12496) could be remodelled to reflect that it's regional branches, not CAMRA, that come up with the code. This could be done by creating a Q Item for each branch and using catalog code (P528) to identify their 3 letter code, which I'd be happy to do if a correct format can be agreed on. Tæppa (talk) 13:57, 30 July 2025 (UTC)

The website now says whatpub.com will automatically redirect to the "CAMRA website" (camra.org.uk) from October 1st. Therefore the formatter URL (P1630) of https://camra.org.uk/pubs/$1 will be correct. The URL match pattern (P8966) of ^https?:\/\/(?:www\.)?whatpub\.com\/pubs\/([A-Z]{3}\/[\w-]+)\/?(?:[a-z\d]+(?:\-[a-z\d]+)*\/?)? and ^https?:\/\/(?:www\.)?camra\.org\.uk\/pubs\/([^?#\/]+) may both be valid, although I'm not able to decipher them to verify they are specifically correct.

For documentation purposes, I've just checked the Swindon Branch of CAMRA (as a random example), and they seem to link to pubs using the WhatPub pub ID (P12496) formatted to the camra.org.uk website. for example on their map ([3])The Green Dragon Public House (Q26647086) is hyperlinked with the URL https://camra.org.uk/SWN/241 , which re-formats to https://camra.org.uk/pubs/green-dragon-marlborough-138649 , where CAMRA pub ID (P13516) gets their by re-formatting https://camra.org.uk/pubs/138649 . Tæppa (talk) 21:54, 22 August 2025 (UTC)