Property talk:P4156

Latest comment: 7 months ago by Jklamo in topic RES database

Documentation

Czech Registration ID (IČO)
8-digit identifier for an organization (or self-employed entrepreneur) in the Czech Republic, conferred by the Czech Statistical Office
Associated itemCzech Statistical Office (Q3504917)
Data typeExternal identifier
Template parameter|IČO= in cs:šablona:Infobox - firma
Domainorganization (Q43229), juridical person (Q155076) or human (Q5)
Allowed values[0-9]{8}
ExampleČEZ Group (Q336735)45274649
Ministry of Education, Youth and Sports (Q11781505)00022985
Czech Red Cross (Q4515418)00426547
Formatter URLhttps://ares.gov.cz/ekonomicke-subjekty?ico=$1
Related to country  Czech Republic (Q213) (See 154 others)
See alsoLegal Entity Identifier (P1278), EU VAT number (P3608), Slovak Registration ID (P8174), OpenCorporates ID (P1320), Czech electoral party ID (P11031)
Lists
Proposal discussionProposal discussion
Current uses
Total50,623
Main statement50,37499.5% of uses
Qualifier6<0.1% of uses
Reference2430.5% of uses
Search for values
[create Create a translatable help page (preferably in English) for this property to be included here]
Format “[0-9]{8}|: value must be formatted using this pattern (PCRE syntax). (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Format, hourly updated report, SPARQL
Type “organization (Q43229), juridical person (Q155076), human (Q5): item must contain property “instance of (P31)” with classes “organization (Q43229), juridical person (Q155076), human (Q5)” 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/P4156#Type Q43229, Q155076, Q5, 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/P4156#Unique value, SPARQL (every item), SPARQL (by value)
Single best value: this property generally contains a single value. If there are several, one would have preferred rank (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/P4156#single best value, SPARQL
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/P4156#Item P17, search
Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410), Wikimedia category (Q4167836): this property must not be used with the listed properties and values. (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Conflicts with P31, hourly updated report, SPARQL
Item “instance of (P31): Items with this property should also have “instance of (P31)”. (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Item P31, hourly updated report, 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/P4156#Entity types
Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)
List of violations of this constraint: Database reports/Constraint violations/P4156#Scope, hourly updated report, SPARQL
Label required in languages: cs: Entities using this property should have labels in one of the following languages: cs (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/P4156#Label in 'cs' language, search, SPARQL
 
Validate czech organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query: SELECT ?item #?itemLabel ?iconr ?checksum ?checksum2 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P4156 ?iconr . FILTER(strlen(?iconr) = 8) BIND(xsd:integer(substr(?iconr, 1, 1))*8 + xsd:integer(substr(?iconr, 2, 1))*7 + xsd:integer(substr(?iconr, 3, 1))*6 + xsd:integer(substr(?iconr, 4, 1))*5 + xsd:integer(substr(?iconr, 5, 1))*4 + xsd:integer(substr(?iconr, 6, 1))*3 + xsd:integer(substr(?iconr, 7, 1))*2 AS ?checksum) #BIND(floor(?checksum/11) AS ?quot) #BIND(?checksum - 11*?quot AS ?rem) BIND(11 - ?checksum + 11*floor(?checksum/11) AS ?checksum2) FILTER(substr(?iconr, 8, 1) != substr(?checksum2, strlen(?checksum2), 1)) } #LIMIT 1000 } AS %i WHERE { INCLUDE %i SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . } }
List of this constraint violations: Database reports/Complex constraint violations/P4156#Validate czech organization numbers
  Pattern ^(\d{7})$ will be automatically replaced to 0\1.
Testing: TODO list
  Pattern ^(\d{6})$ will be automatically replaced to 00\1.
Testing: TODO list
  Pattern ^(\d{5})$ will be automatically replaced to 000\1.
Testing: TODO list
  Pattern ^(\d{4})$ will be automatically replaced to 0000\1.
Testing: TODO list
  Pattern ^(\d{3})$ will be automatically replaced to 00000\1.
Testing: TODO list
 
This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

RES database edit

Czech Statistical Office (Q3504917) has finally updated its RES database GUI so that it is now possible to refer directly to the IČO and thus have formatter URL. Also, the amount of information about the subject has been slightly expanded. So I suggest to change the formatter URL to https://apl.czso.cz/res/detail?ico=$. There is more information in the business registry, but not all types of entities are there. Jklamo (talk) 21:36, 27 August 2023 (UTC)Reply

I have added the RES link about half a year ago as a “third-party formatter URL”. So if the question is “should we switch the primary”… I don’t care really; the same question has been raised for the ARES link and… it doesn’t matter to me, but yes, it makes some sense to have a formatter link which works for (almost?) all values, not only for juridical persons. --Mormegil (talk) 08:51, 28 August 2023 (UTC)Reply
Me neither, but I remember there was a discussion somewhere (I can't remember where) about limited business registry coverage. RES looks like it's struggling with long-denfunct entities (see [1] vs [2], but otherwise it's probably complete. Jklamo (talk) 19:35, 28 August 2023 (UTC)Reply
Return to "P4156" page.