Property talk:P3215

Documentation

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

SIRET number
number of a French establishment

Description	SIRET number of a French establishment or company
Data type	External identifier
Template parameter	fr:Infobox Societé has nom identifiant which blends different things.
Domain	According to this template: companies, organisations, establishments According to statements in the property: facility (Q13226383) or human (Q5) When possible, data should only be stored as statements
Allowed values	According to this template: 14 digit number. For Monaco, it can have letters: MONACOCONFO00 According to statements in the property: MONACO[A-Z\d]{5}001|\d{9}([1-7]\d{3}|0[1-9]\d{2}|00[1-9]\d|000[1-9])\d When possible, data should only be stored as statements
Example	Hôtel du Palais (Q3146296) → 62272015900012 Château de Crèvecœur-en-Auge (Q22963851) → 78072481100010 Crématorium de Roost-Warendin (Q68582171) → 54207679917837 Galerie Vrais Rêves (Q20971885) → 32116456800024
Format and edit filter validation	12 digit number composed of the SIREN number (SIREN number (P1616)) and the NIC number
Source	INSEE (French statistics state organisation) (note: this information should be moved to a property statement; use property source website for the property (P1896))
Formatter URL	https://annuaire-entreprises.data.gouv.fr/etablissement/$1 https://www.sirene.fr/sirene/public/recherche?recherche.sirenSiret=$1
Robot and gadget jobs	You can use the last digit to check the SIREN number is valid.
Tracking: usage	Category:Pages using Wikidata property P3215 (Q60536539)
Related to country	France (Q142) (See 638 others)
See also	SIREN number (P1616)
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 Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Database reports/Complex constraint violations/P3215 Database reports/Constraint violations/P3215 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 97,014 Main statement 96,980 >99.9% of uses Qualifier 11 <0.1% of uses Reference 23 <0.1% of uses
Search for values

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

Format “MONACO[A-Z\d]{5}001|\d{9}([1-7]\d{3}|0[1-9]\d{2}|00[1-9]\d|000[1-9])\d|”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Item “country (P17): France (Q142), Monaco (Q235)”: Items with this property should also have “country (P17): France (Q142), Monaco (Q235)”. (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/P3215#Item P17, search

Type “facility (Q13226383), human (Q5)”: item must contain property “instance of (P31)” with classes “facility (Q13226383), human (Q5)” 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/P3215#Type Q13226383, Q5, 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/P3215#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/P3215#Single value, 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/P3215#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/P3215#Scope, SPARQL

Conflicts with “SIREN number (P1616)”: 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/P3215#Conflicts with P1616, search, SPARQL

Constraints

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

Inconsistency between SIRET and SIREN
The first nine digit of the SIREN number should be the same as the SIRET number. (Help)
Violations query: SELECT DISTINCT ?item WHERE { ?item wdt:P3215 ?SIRET; wdt:P1616 ?SIREN . FILTER( substr(?SIRET, 1, 9) != ?SIREN ) }
List of this constraint violations: Database reports/Complex constraint violations/P3215#Inconsistency between SIRET and SIREN