Property talk:P1059

Documentation

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

Proposal discussion

Current uses

Total	10,756
Main statement	4,802	44.6% of uses
Qualifier	5	<0.1% of uses
Reference	5,949	55.3% 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

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

Justification

Latest comment: 11 years ago1 comment1 person in discussion

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)Reply

Why presently format violations?

Latest comment: 10 years ago2 comments1 person in discussion

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)Reply

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

API

Latest comment: 8 years ago1 comment1 person in discussion

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)Reply

extra format ?

Latest comment: 2 years ago7 comments7 people in discussion

@Fnielsen:

Notified participants of WikiProject Companies

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)Reply

Support ArthurPSmith (talk) 16:46, 5 November 2021 (UTC)Reply
Support - PKM (talk) 21:07, 5 November 2021 (UTC)Reply
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)Reply
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)Reply
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)Reply

Add topic