Property talk:P3608

Documentation

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

EU VAT number
VAT number assigned in the EU

Description	EU VAT number
Data type	External identifier
Domain	According to this template: organizations According to statements in the property: organization (Q43229) or juridical person (Q155076) When possible, data should only be stored as statements
Allowed values	According to this template: First two letters are the country code where the organization is registered, followed by the VAT number of the organization within that country. According to statements in the property: [A-Z]{2}[A-Z\d*]+|ATU\d{8}|^(?!AT).+|BE0\d{9}|^(?!BE).+|BG\d{9,10}|^(?!BG).+|CY\d{8}[A-Z]|^(?!CY).+|CZ\d{8,10}|^(?!CZ).+|DE\d{9}|^(?!DE).+|DK\d{8}|^(?!DK).+|EE\d{9}|^(?!EE).+|(EL|GR)\d{9}|^(?!EL|GR).+|ES[\dA-Z]\d{7}[\dA-Z]|^(?!ES).+|FI\d{8}|^(?!FI).+|FR[\dA-Z]{2}\d{9}|^(?!FR).+|GB\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!GB).+|HR\d{11}|^(?!HR).+|HU\d{8}|^(?!HU).+|IE(\d[A-Z*+]\d{5}[A-Z]|\d{7}([A-Z]W?|[A-Z]{2}))|^(?!IE).+|IS[\dA-Z]{6}|^(?!IS).+|IT\d{11}|^(?!IT).+|LI\d{5}|^(?!LI).+|LT(\d{9}|\d{12})|^(?!LT).+|LU\d{8}|^(?!LU).+|LV\d{11}|^(?!LV).+|MT\d{8}|^(?!MT).+|NL\d{9}B\d{2}|^(?!NL).+|NO\d{9}(MVA)?|^(?!NO).+|PL\d{10}|^(?!PL).+|PT\d{9}|^(?!PT).+|RO\d{2,10}|^(?!RO).+|SE\d{12}|^(?!SE).+|SI\d{8}|^(?!SI).+|SK\d{10}|^(?!SK).+|XN\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!XN).+|^(?!CH).+| When possible, data should only be stored as statements
Example	Sanoma Corporation (Q1540297) → FI15243611 Ontotext (Q7095072) → BG200356710 Red Cross of Burgenland, Austria (Q105580734) → ATU16274500
Source	http://ec.europa.eu/taxation_customs/vies
Formatter URL	https://wikidata-externalid-url.toolforge.org/index.php?url=https%3A%2F%2Fec.europa.eu%2Ftaxation_customs%2Fvies%2Frest-api%2Fms%2F%251%2Fvat%2F%252&exp=(%5BA-Z%5D%5BA-Z%5D)(.*)&id=$1
Tracking: usage	Category:Pages using Wikidata property P3608 (Q50415106)
Related to country	European Union (Q458) (See 49 others)
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 Database reports/Constraint violations/P3608 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 13,827 Main statement 13,404 96.9% of uses Qualifier 6 <0.1% of uses Reference 417 3% of uses
Search for values

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

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).
List of violations of this constraint: Database reports/Constraint violations/P3608#Unique value, SPARQL (every item), SPARQL (by value)

Item “instance of (P31)”: Items with this property should also have “instance of (P31)”. (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/P3608#Item P31, search, SPARQL

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/P3608#Single value, SPARQL

Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410), Wikimedia category (Q4167836), Wikimedia template (Q11266439), Wikimedia module (Q15184295)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3608#Conflicts with P31, hourly updated report, SPARQL

Item “country (P17)”: Items with this property should also have “country (P17)”. (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/P3608#Item P17, search, SPARQL

Type “organization (Q43229), juridical person (Q155076)”: item must contain property “instance of (P31)” with classes “organization (Q43229), juridical person (Q155076)” 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/P3608#Type Q43229, Q155076, 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/P3608#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/P3608#Scope, SPARQL

Item “headquarters location (P159)”: Items with this property should also have “headquarters location (P159)”. (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/P3608#Item P159, search, SPARQL

Format “[A-Z]{2}[A-Z\d*]+|”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3608#Format, hourly updated report, SPARQL

Format “ATU\d{8}|^(?!AT).+|”: 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/P3608#Format, SPARQL

Format “BE0\d{9}|^(?!BE).+|”: 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/P3608#Format, SPARQL

Format “BG\d{9,10}|^(?!BG).+|”: 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/P3608#Format, SPARQL

Format “CY\d{8}[A-Z]|^(?!CY).+|”: 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/P3608#Format, SPARQL

Format “CZ\d{8,10}|^(?!CZ).+|”: 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/P3608#Format, SPARQL

Format “DE\d{9}|^(?!DE).+|”: 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/P3608#Format, SPARQL

Format “DK\d{8}|^(?!DK).+|”: 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/P3608#Format, SPARQL

Format “EE\d{9}|^(?!EE).+|”: 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/P3608#Format, SPARQL

Format “(EL|GR)\d{9}|^(?!EL|GR).+|”: 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/P3608#Format, SPARQL

Format “ES[\dA-Z]\d{7}[\dA-Z]|^(?!ES).+|”: 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/P3608#Format, SPARQL

Format “FI\d{8}|^(?!FI).+|”: 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/P3608#Format, SPARQL

Format “FR[\dA-Z]{2}\d{9}|^(?!FR).+|”: 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/P3608#Format, SPARQL

Format “GB\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!GB).+|”: 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/P3608#Format, SPARQL

Format “HR\d{11}|^(?!HR).+|”: 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/P3608#Format, SPARQL

Format “HU\d{8}|^(?!HU).+|”: 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/P3608#Format, SPARQL

Format “IE(\d[A-Z*+]\d{5}[A-Z]|\d{7}([A-Z]W?|[A-Z]{2}))|^(?!IE).+|”: 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/P3608#Format, SPARQL

Format “IS[\dA-Z]{6}|^(?!IS).+|”: 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/P3608#Format, SPARQL

Format “IT\d{11}|^(?!IT).+|”: 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/P3608#Format, SPARQL

Format “LI\d{5}|^(?!LI).+|”: 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/P3608#Format, SPARQL

Format “LT(\d{9}|\d{12})|^(?!LT).+|”: 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/P3608#Format, SPARQL

Format “LU\d{8}|^(?!LU).+|”: 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/P3608#Format, SPARQL

Format “LV\d{11}|^(?!LV).+|”: 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/P3608#Format, SPARQL

Format “MT\d{8}|^(?!MT).+|”: 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/P3608#Format, SPARQL

Format “NL\d{9}B\d{2}|^(?!NL).+|”: 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/P3608#Format, SPARQL

Format “NO\d{9}(MVA)?|^(?!NO).+|”: 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/P3608#Format, SPARQL

Format “PL\d{10}|^(?!PL).+|”: 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/P3608#Format, SPARQL

Format “PT\d{9}|^(?!PT).+|”: 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/P3608#Format, SPARQL

Format “RO\d{2,10}|^(?!RO).+|”: 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/P3608#Format, SPARQL

Format “SE\d{12}|^(?!SE).+|”: 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/P3608#Format, SPARQL

Format “SI\d{8}|^(?!SI).+|”: 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/P3608#Format, SPARQL

Format “SK\d{10}|^(?!SK).+|”: 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/P3608#Format, SPARQL

Format “XN\d{9}(\d{3})?|[A-Z]{2}\d{3}|^(?!XN).+|”: 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/P3608#Format, SPARQL

Format “^(?!CH).+|”: 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/P3608#Format, SPARQL

Formatter URL doesn't work

The formatter URL needs two parameters: the code of the state and the rest of the VAT numbers. For now instead is just one parameter so the link doesn't work properly. --AlessioMela (talk) 08:33, 20 May 2017 (UTC)

+1 AlessioMela --Deansfa (talk) 18:09, 24 November 2017 (UTC)

@AlessioMela, Deansfa: Thanks to ArthurPSmith and it's Wikidata External ID redirector, the property now links to the EU website properly. Tubezlob (🙋) 16:16, 10 April 2018 (UTC)

Format-constraints no longer mandatory

Hi Ivan A. Krestinin, you've removed constraint status (P2316)mandatory constraint (Q21502408) from all per-country regular expressions. Could you please elaborate, why they shouldn't be mandatory, i.e. there are exceptions to the constraints? If I'm not mistaken, each regular expression describes exactly the language of valid VAT numbers for a country. --Nw520 (talk) 22:41, 4 April 2022 (UTC)

There seem to be some false-positives (namely for HU and NO) but that was due to errornous regular expressions. --Nw520 (talk) 22:48, 4 April 2022 (UTC)

Ivan A. Krestinin? --Nw520 (talk) 21:16, 29 August 2022 (UTC)

formatter URL broken

https://ec.europa.eu/taxation_customs/vies/vatResponse.html is no longer available and the new service at https://ec.europa.eu/taxation_customs/vies/ doesn't seem to accept query parameters. Requests are made to https://ec.europa.eu/taxation_customs/vies/rest-api/ms/{COUNTRY_CODE}/vat/{VAT_ID} which seems to be stable but doesn't provide a nice UI. --Nw520 (talk) 21:16, 29 August 2022 (UTC)

@Nw520: thanks for raising this! I found it today. Examples:

• https://ec.europa.eu/taxation_customs/vies/vatResponse.html?memberStateCode=AT&number=U16274500 is now broken
• https://ec.europa.eu/taxation_customs/vies/rest-api/ms/AT/vat/U16274500 is JSON payload. On their website, it's displayed as a simple table.

MD Imtiaz Ahammad Kopiersperre Jklamo ArthurPSmith S.K. Givegivetake fnielsen rjlabs ChristianKl Vladimir Alexiev Parikan User:Cardinha00 MB-one User:Simonmarch User:Jneubert Mathieudu68 User:Kippelboy User:Datawiki30 User:PKM User:RollTide882071 Andber08 Sidpark SilentSpike Susanna Ånäs (Susannaanas) User:Johanricher User:Celead User:Finnusertop cdo256 Mathieu Kappler RShigapov User:So9q User:1-Byte pmt Rtnf econterms Dollarsign8 User:Izolight maiki c960657 User:Automotom applsdev Bubalina Fordaemdur DaxServer Laurenz Sommerlad

Notified participants of WikiProject Companies

Mcnabber091 (talk) 00:29, 18 June 2014 (UTC) Tobias1984 (talk) 10:23, 8 November 2015 (UTC) Note 1 PAC2 (talk) 09:29, 26 September 2016 (UTC) Rjlabs (talk) 20:30, 14 March 2017 (UTC) Datawiki30 (talk) 11:55, 2 September 2018 (UTC) Sidpark (talk) 09:31, 2 December 2018 (UTC) Mathieu Kappler (talk) 11:44, 6 September 2021 (UTC) Jeanne Noiraud (talk) 12:02, 4 December 2024 (UTC)

Notified participants of WikiProject Economics

Does anyone know how to fix this, short of deploying a web server with a simple app? Could copy some JS logic from their site.

--Vladimir Alexiev (talk) 11:31, 14 September 2022 (UTC)

• @Vladimir Alexiev: if we were ok with the JSON response I could update the external-id redirect service to point there. But it sounds like you're hoping for something different? ArthurPSmith (talk) 17:38, 14 September 2022 (UTC)

  Please do! Vladimir Alexiev (talk) 10:52, 19 September 2022 (UTC)

  +1 --Nw520 (talk) 20:25, 23 February 2023 (UTC)

JSON response is not an ideal outcome (for human), but still much better than nothing. Jklamo (talk) 23:08, 14 September 2022 (UTC)

Agree, https://ec.europa.eu/taxation_customs/vies/rest-api/ms/AT/vat/U64807427 is not bad. Firefox at least displays JSON in a somewhat 'pretty' way (not sure about others) ; at the very least I imagine browsers would not force a file-download.

IDs do not have to web-resolve ; but if they do, in my view it is for 2 purposes: 1/ giving more information to the reader ; 2/ confirm that the value is actually correct. With a broken formatter URL I thought I must have made a mistake entering `ATU64807427`, or perhaps the ID was withdrawn, or perhaps Austria opted-out of the EU registry etc. That the URL works at all is already great I think. Jean-Fred (talk) 08:22, 23 February 2023 (UTC)

I've changed P3608 to now instead use wikidata-externalid-url.toolforge.org with custom regex functionality to generate the link to the JSON at least. I've also made a cleaner PR #34 to accomplish the same thing. Let me know if it doesn't work for you, or if you find a more user friendly way to display data than raw JSON (that can be done via HTTP GET request). You can test at e.g. Q652564, as it might take some time for other links to become clickable (adding ?action=purge to page you're interested in and waiting a bit might help speed it up) --Mnalis (talk) 13:14, 29 May 2024 (UTC)

"Replacement property" in format constraint

Hi, I removed replacement property (P6824) parameter from the format constraint since the constraint does not accept such parameter, and it results in an error of the violations report. Samoasambia ✎ 10:26, 27 August 2024 (UTC)