Property talk:P3215
Jump to navigation
Jump to search
Documentation
SIRET number
number of a French establishment
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
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:
When possible, data should only be stored as statementsMONACO[A-Z\d]{5}001|\d{9}([1-7]\d{3}|0[1-9]\d{2}|00[1-9]\d|000[1-9])\d | ||||||||||||
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 641 others) | ||||||||||||
See also | SIREN number (P1616) | ||||||||||||
Lists |
| ||||||||||||
Proposal discussion | Proposal discussion | ||||||||||||
Current uses |
| ||||||||||||
Search for values |
[create Create a translatable help page (preferably in English) for this property to be included here]
Format “
List of violations of this constraint: Database reports/Constraint violations/P3215#Format, hourly updated report, SPARQLMONACO[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)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), 1) ORDER BY DESC(?ct) LIMIT 100 } ?item wdt:P3215 ?value . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . ?item rdfs:label ?itemLabel . ?value rdfs:label ?valueLabel . } } GROUP BY ?value ORDER BY DESC(?ct)">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
[edit]Validate SIRET numbers
Report organizations with incorrect SIRET numbers, found by validating the checksum (Help)
Violations query:
List of this constraint violations: Database reports/Complex constraint violations/P3215#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:
List of this constraint violations: Database reports/Complex constraint violations/P3215#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
Discussion
[edit]Categories:
- France-related properties
- All Properties
- Properties with external-id-datatype
- Properties used on 100000+ items
- Properties with format constraints
- Properties with constraints on items using them
- Properties with constraints on type
- Properties with unique value constraints
- Properties with single value constraints
- Properties with entity type constraints
- Properties with scope constraints
- Properties with conflicts with constraints
- Properties with complex constraints