Property talk:P232

Documentation

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

EC number
identifier for a chemical compound per EINECS or ELINCS

Description	chemical compound identification number per EINECS
Associated item	European Commission (Q8880)
Applicable "stated in" value	EC inventory (Q130623166)
Data type	External identifier
Domain	chemical compound (Q11173) (note: this should be moved to the property statements)
Allowed values	(\d{3}-){2}\d
Example	formaldehyde (Q161210) → 200-001-8 ethanol (Q153) → 200-578-6
Source	https://echa.europa.eu/information-on-chemicals/ec-inventory
Formatter URL	https://echa.europa.eu/information-on-chemicals/ec-inventory/-/dislist/details/$1
Tracking: same	no label (Q32085230)
Tracking: differences	Category:P232 different on Wikidata (Q20636206)
Tracking: usage	Category:Pages using Wikidata property P232 (Q20636214)
Tracking: local yes, WD no	no label (Q20636198)
Related to country	European Union (Q458) (See 49 others)
See also	ECHA Substance Infocard ID (P2566), JECFA number (P9557), FL number (P9066), CAS Registry Number (P231)
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/P232 Database reports/Constraint violations/P232 Map Random list
Proposal discussion	[not applicable Proposal discussion]
Current uses	Total 55,861 Main statement 55,857 out of 106,212 (53% complete) >99.9% of uses Qualifier 2 <0.1% of uses Reference 2 <0.1% of uses
Search for values

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

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). Known exceptions: (S)-N-nitrosonornicotine (Q55135137)
List of violations of this constraint: Database reports/Constraint violations/P232#Single 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/P232#Unique value, SPARQL (every item), SPARQL (by value)

Format “(\d{3}-){2}\d”: 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/P232#Format, SPARQL

Qualifiers “reason for deprecated rank (P2241), reason for preferred rank (P7452), intended subject of deprecated statement (P8327)”: this property should be used only with the listed qualifiers. (Help)

List of violations of this constraint: Database reports/Constraint violations/P232#allowed qualifiers, hourly updated report, 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/P232#Entity types

Scope is as main value (Q54828448): 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/P232#Scope, SPARQL

This property is being used by: it:Template:Composto chimico ru:Шаблон:Изомеры, ru:Шаблон:Вещество ar:قالب:معلومات كيمياء -معرفات, ar:قالب:معلومات كيمياء -معرفات/ملعب, ar:قالب:معلومات كيمياء - معرفات/ملعب, ar:قالب:معلومات كيمياء - معرفات be:Шаблон:Рэчыва hy:Կաղապար:Տեղեկաքարտ Նյութ tt:Калып:Матдә2 de:Vorlage:Infobox Chemikalie, de:Vorlage:Infobox Chemikalie/Test, de:Vorlage:Infobox Chemisches Element, de:Vorlage:Infobox Chemisches Element/Wikidata be-x-old:Шаблён:Рэчыва tg:Шаблон:Моддаи кимиёӣ uk:Шаблон:Речовина Ідентифікатори, uk:Шаблон:Хімічні властивості cy:Nodyn:Cyffuriau mn:Загвар:Инфобокс химийн нэгдэл ca:Plantilla:Identificadors química vec:Modeło:Infobox de Conposto chìmego be-tarask:Шаблён:Рэчыва Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Validate EC numbers
Report incorrect EC numbers, found by validating the checksum (Help)
Violations query: SELECT ?item #?itemLabel ?ecnr ?checksum ?checksum2 ?checksum3 ?quot ?rem WITH { SELECT DISTINCT * WHERE { ?item wdt:P232 ?ecnr . FILTER(strlen(?ecnr) = 9) BIND(xsd:integer(substr(?ecnr, 1, 1))*1 + xsd:integer(substr(?ecnr, 2, 1))*2 + xsd:integer(substr(?ecnr, 3, 1))*3 + xsd:integer(substr(?ecnr, 5, 1))*4 + xsd:integer(substr(?ecnr, 6, 1))*5 + xsd:integer(substr(?ecnr, 7, 1))*6 AS ?checksum) #BIND(floor(?checksum/11) AS ?quot) #BIND(?checksum - 11*?quot AS ?rem) BIND(?checksum - 11*floor(?checksum/11) AS ?checksum2) BIND(IF(?checksum2 = 10, "1", str(?checksum2)) AS ?checksum3) FILTER(substr(?ecnr, 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/P232#Validate EC numbers

Sources

Use this document to source value of this property. Snipre (talk) 21:34, 25 July 2013 (UTC)

Creation of a link to ECHA

@Pasleim: Hi I saw your work about URL for ZVG number (P679). Do you think it is possible to do the same for this property using ECHA as website ? Normally you provide the EINECS number in the Search for Chemicals engine (on the right) and you get a page with the corresponding chemical and the links to different european databases. Snipre (talk) 12:02, 21 August 2015 (UTC)

I couldn't find a stable formatter URL for ZVG number (P679). On [1] you can directly enter the EC number but you always have to accept the legal notice which produces a temporary URL and can therefore not bu used for our purpose. --Pasleim (talk) 12:32, 24 August 2015 (UTC)

The helpdesk may be contacted. --Leyo 12:49, 24 August 2015 (UTC)

Brenntag

@Teolemon: The URL formatter does not work anymore.--Kopiersperre (talk) 18:35, 3 March 2016 (UTC)

Mandatory constraint

@Pasleim: Why did you delete the mandatory feature of the single constraint ? Until now there is only one exception which has to be checked so I don't understand. The problem is not the mandatory feture of the single constraint but the mandatory feature of the unique constraint. Here we have several exceptions like hydrogen fluoride and hydrfluoric acid. Snipre (talk) 09:58, 30 April 2016 (UTC)

Renaming to EC number

The common name used for this number is “EC number”, e.g. in SDS. It consists of ELINCS numbers, too. See https://echa.europa.eu/information-on-chemicals/registered-substances/information for more information. Hence, I suggest renaming this property. Otherwise, we would need to restrict this property to 2xx-xxx-x and 3xx-xxx-x. I do clearly prefer the renaming option. --Leyo 18:22, 9 October 2016 (UTC)

Done. --Leyo 12:48, 17 October 2016 (UTC)

@Leyo: And how can we do the difference between EC enzyme number (P591) and EC number (P232) ? This is a huge risk that people don't use the correct property and take the first in the list without reading carefully the description. Snipre (talk) 13:58, 17 October 2016 (UTC)

The formatting of the number is different (\d\.\d{1,2}\.\d{1,2}\.\d{1,3} vs. [2-5]\d\d-\d\d\d-\d).

To avoid confusion, we could use the long names, i.e. „Enzyme Commission number“ vs. „European Community number“, either just like this or as an addition in brackets. --Leyo 14:39, 17 October 2016 (UTC)