Property talk:P3225

Documentation

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

Corporate Number (Japan)
identifier assigned to companies and other organizations by the National Tax Agency of Japan

Represents	Corporate Number (Q18535356)
Applicable "stated in" value	National Tax Agency Corporate Number Publication Site (Q111966960)
Data type	External identifier
Domain	organization (Q43229), administrative territorial entity of Japan (Q1850442) or facility (Q13226383)
Allowed values	[1-9]\d{12}
Example	Toho Cinemas (Q11235261) → 8010001087623 Ministry of Finance (Q1322605) → 8000012050001 Kyoto Prefecture (Q120730) → 2000020260002 Kyoto (Q34600) → 2000020261009 Japanese Red Cross Society (Q4538440) → 6010405002452
Source	https://www.houjin-bangou.nta.go.jp/ https://www.houjin-bangou.nta.go.jp/en/
Formatter URL	https://www.houjin-bangou.nta.go.jp/henkorireki-johoto.html?selHouzinNo=$1 https://www.houjin-bangou.nta.go.jp/en/henkorireki-johoto.html?selHouzinNo=$1
Tracking: differences	no label (Q111990188)
Tracking: local yes, WD no	no label (Q111990194)
Related to country	Japan (Q17) (See 148 others)
See also	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/P3225 Database reports/Constraint violations/P3225 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 51,437 Main statement 48,335 out of 5,208,872 (1% complete) 94% of uses Qualifier 5 <0.1% of uses Reference 3,097 6% of uses
Search for values

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

Format “[1-9]\d{12}|”: value must be formatted using this pattern (PCRE syntax). (Help)

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

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/P3225#single best value, 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/P3225#Unique value, SPARQL (every item), SPARQL (by value)

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/P3225#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/P3225#Scope, SPARQL

Qualifiers “start time (P580), end time (P582), applies to part (P518), subject named as (P1810), headquarters location (P159), street address (P6375), reason for deprecated rank (P2241), reason for preferred rank (P7452), name in kana (P1814), trading name (P6427), end cause (P1534), replaced by (P1366), replaces (P1365), identifier shared with (P4070)”: this property should be used only with the listed qualifiers. (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/P3225#allowed qualifiers, SPARQL

Type “organization (Q43229), administrative territorial entity of Japan (Q1850442), facility (Q13226383)”: item must contain property “instance of (P31)” with classes “organization (Q43229), administrative territorial entity of Japan (Q1850442), facility (Q13226383)” 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/P3225#Type Q43229, Q1850442, Q13226383, SPARQL

Conflicts with “instance of (P31): Wikimedia disambiguation page (Q4167410)”: this property must not be used with the listed properties and values. (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/P3225#Conflicts with P31, search, SPARQL

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

Invalid Corporate Number
Corporate Number that have wrong checksum (see https://www.houjin-bangou.nta.go.jp/documents/checkdigit.pdf) (Help)
Violations query: SELECT ?item ?value { { ?item wdt:P3225 ?value } UNION { ?statement pq:P3225 ?value . ?item ?p ?statement . ?prop wikibase:claim ?p } UNION { ?ref pr:P3225 ?value . ?statement prov:wasDerivedFrom ?ref . ?item ?p ?statement . ?prop wikibase:claim ?p } . FILTER( STRLEN(?value) = 13 ) . BIND( xsd:integer(SUBSTR(?value, 1, 1)) + xsd:integer(SUBSTR(?value, 3, 1)) + xsd:integer(SUBSTR(?value, 5, 1)) + xsd:integer(SUBSTR(?value, 7, 1)) + xsd:integer(SUBSTR(?value, 9, 1)) + xsd:integer(SUBSTR(?value, 11, 1)) + xsd:integer(SUBSTR(?value, 13, 1)) + ( xsd:integer(SUBSTR(?value, 2, 1)) + xsd:integer(SUBSTR(?value, 4, 1)) + xsd:integer(SUBSTR(?value, 6, 1)) + xsd:integer(SUBSTR(?value, 8, 1)) + xsd:integer(SUBSTR(?value, 10, 1)) + xsd:integer(SUBSTR(?value, 12, 1)) ) * 2 AS ?checksum ) . FILTER( FLOOR(?checksum / 9) != (?checksum / 9) ) } ORDER BY ?value
List of this constraint violations: Database reports/Complex constraint violations/P3225#Invalid Corporate Number

This property is being used by: ja:Template:Infobox/法人番号 zh:Template:Infobox 日本的市, zh:Template:Infobox 日本的町村 wuu:Template:日本都市 Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Nissin Food Products Q53293

I am curious as the need for a sublcass to corporation (Q48748864), a Japanese corporate law for Nissin Food Products (Q53293) to avoid an identifier constraint violation, Corporate Number (Japan) (P3225). Thank you for your help. jshieh (talk) 14:01, 16 February 2021 (UTC)