Property talk:P2333

Documentation

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

Norwegian organisation number
organisation's purely numerical identifier in the Norwegian Register for Legal Entities, issued by the Brønnøysund Register Centre

Associated item	Brønnøysund Register Centre (Q1770101)
Applicable "stated in" value	unknown
Data type	External identifier
Domain	According to this template: organisation According to statements in the property: organization (Q43229) When possible, data should only be stored as statements
Allowed values	(\d{9}|\d{3} \d{3} \d{3})
Usage notes	9 digits only. (No spaces!)
Example	Wikimedia Norge (Q6985258) → 993101583 Vy (Q83825) → 984661177 Norwegian Red Cross (Q927391) → 864139442
Source	According to this template: external reference According to statements in the property: https://www.brreg.no/ When possible, data should only be stored as statements
Formatter URL	https://w2.brreg.no/enhet/sok/detalj.jsp?orgnr=$1
Tracking: usage	Category:Pages using Wikidata property P2333 (Q53729795)
Related to country	Norway (Q20) (See 97 others)
See also	Firmenbuchnummer (P5285), OpenCorporates ID (P1320)
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/P2333 Database reports/Constraint violations/P2333 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 13,153 Main statement 7,777 out of 1,780,106 (0% complete) 59.1% of uses Qualifier 3 <0.1% of uses Reference 5,373 40.8% of uses
Search for values

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

Format “\d{9}”: 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/P2333#Format, 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/P2333#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/P2333#single best value, SPARQL

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/P2333#Type Q43229, SPARQL

Item “country (P17): Norway (Q20)”: Items with this property should also have “country (P17): Norway (Q20)”. (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/P2333#Item P17, search, SPARQL

Item “inception (P571)”: Items with this property should also have “inception (P571)”. (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/P2333#Item P571, SPARQL

Item “legal form (P1454)”: Items with this property should also have “legal form (P1454)”. (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/P2333#Item P1454, search, SPARQL

Item “headquarters location (P159)”: Items with this property should also have “headquarters location (P159)”. (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/P2333#Item P159, search, SPARQL

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

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

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/P2333#Scope, 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/P2333#Entity types

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

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

Validate norwegian organization numbers
Report organizations with incorrect organization numbers, found by validating the checksum (Help)
Violations query: SELECT ?item #?itemLabel ?orgnr ?checksum ?checksum2 ?checksum3 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P2333 ?orgnr . FILTER(strlen(?orgnr) = 9) BIND(xsd:integer(substr(?orgnr, 1, 1))*3 + xsd:integer(substr(?orgnr, 2, 1))*2 + xsd:integer(substr(?orgnr, 3, 1))*7 + xsd:integer(substr(?orgnr, 4, 1))*6 + xsd:integer(substr(?orgnr, 5, 1))*5 + xsd:integer(substr(?orgnr, 6, 1))*4 + xsd:integer(substr(?orgnr, 7, 1))*3 + xsd:integer(substr(?orgnr, 8, 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(?orgnr, 9, 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/P2333#Validate norwegian organization numbers

Pattern ^(\d{3}) (\d{3}) (\d{3})$ will be automatically replaced to \1\2\3. Testing: TODO list

This property is being used by: nnwiki: nn:Mal:Infoboks firma nn:Mal:Infoboks organisasjon nn:Mal:Infoboks verksemd nowiki: no:Mal:Infoboks firma no:Mal:Infoboks offentlig forvaltning no:Mal:Infoboks organisasjon no:Mal:Infoboks myndighet no:Mal:Infoboks forening no:Mal:Infoboks kirkesamfunn no:Mal:Infoboks organisasjon grunnmal Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

applicable 'stated in' value (P9073) value

If several are possible, I don't think this can easily be captured with the property. I currently set "unknown" to prefer. What is the relation between the two other values? BTW for ISBN I added "no value", as ISBN alone in the reference of a statement doesn't point to any centralized database. --- Jura 13:23, 22 January 2021 (UTC)

When referencing current data, which applies to most of the references, Norwegian Central Coordinating Register for Legal Entities (Q5380556) is where the information is found. But for references to something that changed, like the date of a new official name or a legal type, the information is found in Norwegian Register of Business Enterprises (Q17773282). In cases where the information relates to an old company where the company entity has been reused for a totally different company (which is why we have several false positives on the distinct values constraint), all information is found in Norwegian Register of Business Enterprises (Q17773282). (Between 1988 and 1995, all information was found in Norwegian Register of Business Enterprises (Q17773282), but we didn't read the information back then, so that's irrelevant in this case.) Some information is also found in some external databases where the Norwegian organization number (Q11994066) is mentioned, but one usually have to look it up through the name.

I guess the way you changed P9073 on this looks okay. It is kind of self-explanatory, and suggests that the user has to be aware that the ID is actually used by more than one single database. (Yet, it is not an "ownerless" identifier, like ISBN or vehicle identification number (P6322).) Bergenga (talk) 17:43, 22 January 2021 (UTC)

If everything is in Norwegian Register of Business Enterprises (Q17773282), maybe that should be the default. --- Jura 12:01, 23 January 2021 (UTC)

Sorry for late answer. I've been off from Wiki for a while.

No, I guess I was a bit unclear, but Norwegian Register of Business Enterprises (Q17773282) does not contain everything. It is a registry only for buisnesses/enterprises, while Norwegian Central Coordinating Register for Legal Entities (Q5380556) is for all types of organizations. We don't get historical information for assocations, foundations, government organizations, etc.. If a foundation changes its name, we will not see a record of when it happened.

On 1 January 2021, the registry included 350 000 limited companies, 420 000 sole proprietorships and around 35 000 other types of buisnesses. It also included 110 000 voluntary associations (sports clubs, advocacy groups, political parties, religious organizations, etc.), 6000 foundations, 9000 housing cooperatives, 23000 condos, around 1800 government organizations and some thousand other entities of different types. It also has more than 600 000 sub-entities. (All organizations that have employees need to have at least one sub-entity. They also use Norwegian organization number (Q11994066) as identifier.)

If only businesses were relevant for Wikidata, it wouldn't be a problem, but that's definitely not the case. Bergenga (talk) 17:24, 24 February 2021 (UTC)

Address as required statement

This identifier requires the data objects for which it is used as a value to have a statement street address (P6375).... This constraint is marked as suggestion constraint (Q62026391). I am in favor of removing this constraint because I believe an organization should not use the property street address (P6375) as a value, only as a qualifier for the property headquarters location (P159). --Gymnicus (talk) 10:00, 9 February 2022 (UTC)

I agree, so I just removed it. However, the property should be kept on item level for elements that don't just represent an organization, like for example a school, that also has a building that is inevitably connected to it. Bergenga (talk) 11:14, 11 September 2022 (UTC)