Property talk:P1059

Documentation

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

CVR number
unique identifier for a business in Denmark's Central Business Register (CVR), the official database of Danish businesses.

Represents	CVR number (Q114079473)
Associated item	Danish Business Authority (Q12310258)
Applicable "stated in" value	Danish Central Business Register (Q795419)
Data type	External identifier
Template parameter	Cvr in w:da:Skabelon:Infoboks virksomhed
Domain	According to this template: Category:Organizations based in Denmark (Q7314882) Danish organizations According to statements in the property: organization (Q43229) When possible, data should only be stored as statements
Allowed values	\d{8}|A/S\d{3,6} (8 digits or "A/S" followed by 3-6 digits)
Example	Wikimedia Denmark (Q18559647) → 41380551 Det Danske Filmstudie (Q12308319) → 28516797 Danish Red Cross (Q12307527) → 20700211 Novonesis (Q45576) → 10007127
Source	https://datacvr.virk.dk/data/
Formatter URL	http://datacvr.virk.dk/data/visenhed?enhedstype=virksomhed&id=$1 https://datacvr.virk.dk/data/visenhed?language=en-gb&enhedstype=virksomhed&id=$1
Tracking: usage	Category:Pages using Wikidata property P1059 (Q50415153)
Related to country	Denmark (Q35) (See 85 others) Greenland (Q223)
See also	P-number (P2814), OpenCorporates ID (P1320), CVR person ID (P7972)
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/P1059 Database reports/Constraint violations/P1059 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 10,693 Main statement 4,744 44.4% of uses Qualifier 5 <0.1% of uses Reference 5,944 55.6% 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/P1059#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/P1059#Single value, SPARQL

Format “\d{8}|A/S\d{3,6}”: 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/P1059#Format, SPARQL

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

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

Item “OpenCorporates ID (P1320)”: Items with this property should also have “OpenCorporates ID (P1320)”. (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/P1059#Item P1320, search, SPARQL

Item “legal form (P1454): aktieselskab (Q2624520), Andelsselskab med begrænset ansvar (Q12301349), anpartsselskab (Q15649047), no label (Q113296579), erhvervsdrivende fond (Q23000060), no label (Q114170495), Fonde og andre selvejende institutioner (Q114169398), forening (Q111142392), non-profit organization in Denmark (Q113513472), iværksætterselskab (Q18586645), kommanditselskab (Q17050380), municipality of Denmark (Q2177636), medarbejderinvesteringsselskab (Q26702423), partnerselskab (Q12331028), selskab med begrænset ansvar (Q12334948), region of Denmark (Q62326), no label (Q23000150), governmental administrative unit in Denmark (Q21268738), interessentskab (Q114216672), særlig finansiel virksomhed (Q114310294), county of Denmark (Q876730), forening med begrænset ansvar (Q114310114), no label (Q114310316)”: Items with this property should also have “legal form (P1454): aktieselskab (Q2624520), Andelsselskab med begrænset ansvar (Q12301349), anpartsselskab (Q15649047), no label (Q113296579), erhvervsdrivende fond (Q23000060), no label (Q114170495), Fonde og andre selvejende institutioner (Q114169398), forening (Q111142392), non-profit organization in Denmark (Q113513472), iværksætterselskab (Q18586645), kommanditselskab (Q17050380), municipality of Denmark (Q2177636), medarbejderinvesteringsselskab (Q26702423), partnerselskab (Q12331028), selskab med begrænset ansvar (Q12334948), region of Denmark (Q62326), no label (Q23000150), governmental administrative unit in Denmark (Q21268738), interessentskab (Q114216672), særlig finansiel virksomhed (Q114310294), county of Denmark (Q876730), forening med begrænset ansvar (Q114310114), no label (Q114310316)”. (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/P1059#Item P1454

Label required in languages: da: Entities using this property should have labels in one of the following languages: da (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/P1059#Label in 'da' language, search, SPARQL

Validate danish organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query: SELECT ?item #?itemLabel ?cvrnr ?checksum ?checksum2 ?checksum3 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P1059 ?cvrnr . FILTER(strlen(?cvrnr) = 8) BIND(xsd:integer(substr(?cvrnr, 1, 1))*2 + xsd:integer(substr(?cvrnr, 2, 1))*7 + xsd:integer(substr(?cvrnr, 3, 1))*6 + xsd:integer(substr(?cvrnr, 4, 1))*5 + xsd:integer(substr(?cvrnr, 5, 1))*4 + xsd:integer(substr(?cvrnr, 6, 1))*3 + xsd:integer(substr(?cvrnr, 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) BIND(IF(?checksum2 = 11, "0", IF(?checksum2 = 10, "-", STR(?checksum2))) AS ?checksum3) FILTER(?checksum2 = 10 || substr(?cvrnr, 8, 1) != ?checksum3) } #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/P1059#Validate danish organization numbers

This property is being used by: da:Skabelon:Infoboks avis, da:Skabelon:Infoboks biograf, da:Skabelon:Infoboks campingplads, da:Skabelon:Infoboks dyrepark og zoo, da:Skabelon:Infoboks flyselskab, da:Skabelon:Infoboks forening, da:Skabelon:Infoboks forlystelsespark, da:Skabelon:Infoboks golfturnering, da:Skabelon:Infoboks hotel, da:Skabelon:Infoboks indkøbscenter, da:Skabelon:Infoboks museum, da:Skabelon:Infoboks restaurant, da:Skabelon:Infoboks stadion, da:Skabelon:Infoboks teater, da:Skabelon:Infoboks tårn, da:Skabelon:Infoboks undervisningsinstitution, da:Skabelon:Infoboks virksomhed, da:Skabelon:Infoboks fodboldklub en:Template:Cvr fo:Fyrimynd:Infoboks Fyritøka no:Mal:Infoboks firma Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Justification

Most larger Danish companies (i.e., companies with more than one employee) have a CVR-number that uniquely identifies the company or organization, e.g., the Danish Chapter of Wikimedia has a CVR number and the company Lundbeck (Q902171) has the number 56759913. The number can be resolved to a lookup on the Danish site cvr.dk, e.g., for Lundbeck (Q902171) it is http://cvr.dk/Site/Forms/PublicService/DisplayCompany.aspx?cvrnr=56759913. This allows for further access to headquarters address, type, branch, starting date, board members, etc. Finn Årup Nielsen (fnielsen) (talk) 13:11, 8 November 2013 (UTC)

Why presently format violations?

Presently, the report "Constraint violations" mentions that all present values are wrong wrt. format, e.g., "56759913" is listed even though the regular expresion, "\d{8}" looks ok to me. Why? — Finn Årup Nielsen (fnielsen) (talk) 18:01, 21 January 2014 (UTC)

The error seems no longer to be present. Thanks for the fix. — Finn Årup Nielsen (fnielsen) (talk) 13:59, 8 April 2014 (UTC)

API

Udover det officielle API er der flere private der trækker på det offentlige system og stiller service tilrådighed: http://cvrapi.dk/ er forholdsvist nemt at bruge. — Finn Årup Nielsen (fnielsen) (talk) 15:47, 7 December 2015 (UTC)

extra format ?

@Fnielsen:

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)

Notified participants of WikiProject Economics

https://www.wikidata.org/wiki/Wikidata:Database_reports/Constraint_violations/P1059#%22Format%22_violations shows a number of violations where the ID is formatted as A/S\d{4,5} , eg http://datacvr.virk.dk/data/visenhed?enhedstype=virksomhed&id=A/S46887 . I checked 4 and:

• They all are dissolved companies.
• They resolve ok at datacvr.virk.dk
• They don't resolve at OpenCorporates.com
• I checked by replacing "A/S" with 3 leading zeros http://datacvr.virk.dk/data/visenhed?enhedstype=virksomhed&id=00046887 , doesn't work
• This "dissolved company number" is called "Registration number" rather than "CVR number" but it's passed in the same query param "id="
• I submit it's not smart on part of DK CVR to change the format of id upon dissolution. But in any case, shouldn't we add this extra format?

--Vladimir Alexiev (talk) 15:44, 5 November 2021 (UTC)

•  Support ArthurPSmith (talk) 16:46, 5 November 2021 (UTC)
•  Support - PKM (talk) 21:07, 5 November 2021 (UTC)
•  Support Yes, we can add this format. I believe it is not because the company is desolved, I think it is because it is an old company. I do not think they change the ID based on status. Most recent companies that are "Opløst efter fusion" should maintain the CVR number. If my understanding is correct. — Finn Årup Nielsen (fnielsen) (talk) 22:02, 14 November 2021 (UTC)
• From the explanation above, it seems to me that is an additional, different type of identifier, that I'd expect to be in another property. --- Jura 22:26, 14 November 2021 (UTC)
• It seems that companies with old-style identifiers also have an 8-digit “pseudo” CVR number, which is visible in the URL on cvr.dk. E.g Privatbanken (Q12332389), A/S227, has the URL https://datacvr.virk.dk/enhed/virksomhed/10453356. The 8-digit number is used in the OpenCorporates ID, dk/10453356. We may want to use this number in the CVR number (P1059) property as well, possibly with a qualifier indicating that it is not a real CVR number. At least this will make auto-linking to cvr.dk work. --C960657 (talk) 16:29, 28 September 2022 (UTC)