Property talk:P3125

Documentation

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

EDRPOU code
Ukrainian state registry legal entity identifier

Description	Ukrainian state registry legal entity identifier
Data type	External identifier
Template parameter	|ЄДРПОУ=, in uk:Шаблон:Картка_компанії
Domain	organizations (note: this should be moved to the property statements)
Allowed values	According to this template: up to 8 digits According to statements in the property: ^\d{8}$ When possible, data should only be stored as statements
Example	Naftogaz (Q728513) → 20077720 State University of Trade and Economics (Q694219) → 01566117
Formatter URL	https://opendatabot.ua/c/$1 https://youcontrol.com.ua/catalog/company_details/$1
Robot and gadget jobs	import from wikipedia
Related to country	Ukraine (Q212) (See 57 others)
See also	Textile Connect publication ID (P7110)
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/Complex constraint violations/P3125 Database reports/Constraint violations/P3125 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 883 Main statement 874 99% of uses Qualifier 2 0.2% of uses Reference 7 0.8% of uses
Search for values

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

Format “^\d{8}$”: value must be formatted using this pattern (PCRE syntax). (Help)

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

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

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

Partial validation of checksum
documentation : http://1cinfo.com.ua/Articles/Proverka_koda_po_EDRPOU.aspx (Help)
Violations query: SELECT ?item ?value ?int { { ?item wdt:P3125 ?value } UNION { ?statement pq:P3125 ?value . ?item ?p ?statement . ?prop wikibase:claim ?p } UNION { ?ref pr:P3125 ?value . ?statement prov:wasDerivedFrom ?ref . ?item ?p ?statement . ?prop wikibase:claim ?p } . FILTER(STRLEN(?value) = 8) . BIND(xsd:integer(?value) AS ?int) . BIND(?int > 30000000 AS ?isBig) . BIND( xsd:integer(SUBSTR(?nohyphen, 1, 1)) * 7 + xsd:integer(SUBSTR(?nohyphen, 2, 1)) * 1 + xsd:integer(SUBSTR(?nohyphen, 3, 1)) * 2 + xsd:integer(SUBSTR(?nohyphen, 4, 1)) * 3 + xsd:integer(SUBSTR(?nohyphen, 5, 1)) * 4 + xsd:integer(SUBSTR(?nohyphen, 6, 1)) * 5 + xsd:integer(SUBSTR(?nohyphen, 7, 1)) * 6 AS ?checksum). BIND(FLOOR(?checksum / 11) * 11 AS ?rest). FILTER (?rest = xsd:integer(SUBSTR(?nohyphen, 1, 8))). FILTER (?isBig). }
List of this constraint violations: Database reports/Complex constraint violations/P3125#Partial validation of checksum

This property is being used by: uk:Шаблон:Картка компанії, uk:Шаблон:Орган виконавчої влади, uk:Шаблон:Картка організації, uk:Шаблон:Картка:Бібліотека, uk:Шаблон:Орган виконавчої влади/пісочниця, uk:Шаблон:Газета, uk:Шаблон:Картка:Громадська організація, uk:Шаблон:Картка:Організація, uk:Шаблон:Картка:Організація/пісочниця, uk:Шаблон:Картка компанії тест Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

Need separate VAT id

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

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)

Notified participants of WikiProject Economics

Renamerr (talk) MasterRus21thCentury (talk) Daniel Mietchen (talk) 12:15, 3 March 2022 (UTC) Ѵокан Ноѵак (talk) Perohanych (talk) Leon II (talk) Bogic

Notified participants of WikiProject Ukraine

Vladimir Alexiev (talk) 11:59, 13 March 2017 (UTC) Jonathan Groß (talk) 17:52, 26 March 2017 (UTC) Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits Jneubert (talk) 13:47, 29 April 2017 (UTC) Sic19 (talk) 20:42, 12 July 2017 (UTC) Wikidelo (talk) 21:15, 8 May 2018 (UTC) ArthurPSmith (talk) 19:52, 22 August 2018 (UTC) PKM (talk) 19:40, 23 August 2018 (UTC) Ettorerizza (talk) 06:44, 8 October 2018 (UTC) Fuzheado (talk) 03:47, 19 December 2018 (UTC) Daniel Mietchen (talk) 16:30, 7 April 2019 (UTC) Iwan.Aucamp (talk) 21:48, 3 October 2019 (UTC) Epìdosis (talk) 23:49, 22 November 2019 (UTC) Sotho Tal Ker (talk) 00:52, 1 May 2020 (UTC) Bargioni (talk) 09:48, 02 May 2020 (UTC) Carlobia (talk) 14:34, 11 May 2020 (UTC) Pablo Busatto (talk) 03:22, 23 June 2020 (UTC) Matlin (talk) 10:53, 6 July 2020 (UTC) Msuicat (talk) 21:57, 27 August 2020 (UTC) Uomovariabile (talk) 10:04, 27 October 2020 (UTC) Silva Selva (talk) 17:21, 30 November 2020 (UTC) 1-Byte (talk) 15:52, 14 December 2020 (UTC) Alessandra.Moi (talk) 17:26, 16 February 2021 (UTC) CamelCaseNick (talk) 21:20, 20 February 2021 (UTC) Songceci (talk) 18:45, 24 February 2021 (UTC)]] moz (talk) 10:48, 8 March 2021 (UTC) AhavaCohen (talk) 14:41, 11 March 2021 (UTC) Kolja21 (talk) 17:37, 13 March 2021 (UTC) RShigapov (talk) 14:34, 19 September 2021 (UTC) Jason.nlw (talk) 15:15, 30 September 2021 (UTC) MasterRus21thCentury (talk) 20:22, 18 October 2021 (UTC) Newt713 (talk) 08:42, 13 March 2022 (UTC) Pierre Tribhou (talk) 08:00, 20 March 2022 (UTC) Powerek38 (talk) 17:21, 14 April 2022 (UTC) Ahatd (talk) 08:34, 4 August 2022 (UTC) JordanTimothyJames (talk) 00:54, 31 August 2022 (UTC) --Silviafanti (talk) 17:07, 14 September 2022 (UTC) Back ache (talk) 02:03, 1 November 2022 (UTC) AfricanLibrarian (talk) M.roszkowski (talk) 10:44, 4 January 2023 (UTC) Rhagfyr (talk) 19:36, 9 January 2023 (UTC) — Haseeb (talk) 13:10, 4 August 2023 (UTC) 沈澄心✉ 13:26, 15 November 2023 (UTC) MrBenjo (talk) 15:20, 23 April 2024 (UTC)

Notified participants of WikiProject Authority control

I think we need a separate property "ПДВ ид" (Ukrainian VAT id).

• Eg Energoatom (Q938225) has ЕГРПОУ 24584661 but ПДВ 245846626653. You can see this at https://opendatabot.ua/c/24584661.
• The VAT id is important at least for energy companies, because it's used in Energy Identification Code (P8645) records.
• Eg if you search for "62X205270350215R" at https://www.entsoe.eu/data/energy-identification-codes-eic/eic-approved-codes/, you'll find Energoatom listed with VAT code "UA245846626653".

Does anyone know what's the relation between the two id's? There is a lot of similarity...

Can some Ukrainian participant start a property request? I'll contribute to it. --Vladimir Alexiev (talk) 09:10, 20 July 2022 (UTC)