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://clarity-project.info/edr/$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 899 Main statement 889 98.9% of uses Qualifier 2 0.2% of uses Reference 8 0.9% 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 Jonathan Groß Andy Mabbett Jneubert Sic19 Wikidelo ArthurPSmith PKM Ettorerizza Fuzheado Daniel Mietchen Iwan.Aucamp Epìdosis Sotho Tal Ker Bargioni Carlobia Pablo Busatto Matlin Msuicat Uomovariabile Silva Selva 1-Byte Alessandra.Moi CamelCaseNick Songceci moz AhavaCohen Kolja21 RShigapov Jason.nlw MasterRus21thCentury Newt713 Pierre Tribhou Powerek38 Ahatd JordanTimothyJames Silviafanti Back ache AfricanLibrarian M.roszkowski Rhagfyr 沈澄心 MrBenjo S.v.Mering

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)