Property talk:P3608

From Wikidata
Jump to navigation Jump to search

Documentation

DescriptionEU VAT number
Data typeExternal 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
ExampleSanoma Corporation (Q1540297)FI15243611
Ontotext (Q7095072)BG200356710
Red Cross of Burgenland, Austria (Q105580734)ATU16274500
Sourcehttp://ec.europa.eu/taxation_customs/vies
Formatter URLhttps://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: usageCategory:Pages using Wikidata property P3608 (Q50415106)
Related to country European Union (Q458) (See 49 others)
Lists
Proposal discussionProposal discussion
Current uses
Total13,715
Main statement13,29296.9% of uses
Qualifier6<0.1% of uses
Reference4173% 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
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

[edit]

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)[reply]

+1 AlessioMela --Deansfa (talk) 18:09, 24 November 2017 (UTC)[reply]
@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)[reply]

Format-constraints no longer mandatory

[edit]

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)[reply]

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)[reply]
Ivan A. Krestinin? --Nw520 (talk) 21:16, 29 August 2022 (UTC)[reply]

formatter URL broken

[edit]

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)[reply]

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

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)[reply]

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)[reply]

JSON response is not an ideal outcome (for human), but still much better than nothing. Jklamo (talk) 23:08, 14 September 2022 (UTC)[reply]
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)[reply]
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)[reply]

"Replacement property" in format constraint

[edit]

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)[reply]