Property talk:P1616

Documentation

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

SIREN number
identifier for an organization in the SIRENE register maintained by INSEE

Description	unique string identifying companies and administrations based in France
Applicable "stated in" value	SIRENE (Q3509449)
Data type	External identifier
Domain	organization (Q43229), human (Q5), administrative territorial entity (Q56061), juridical person (Q155076) or enterprise (Q6881511)
Allowed values	\d{9}
Example	City of Lyon (Q3278474) → 216901231 LVMH (Q504998) → 775670417 French Red Cross (Q3003244) → 775672272
Source	https://data.gouv.fr/
Formatter URL	https://annuaire-entreprises.data.gouv.fr/entreprise/$1
Tracking: usage	Category:Pages using Wikidata property P1616 (Q43543664)
Related to country	France (Q142) (See 638 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 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/P1616 Database reports/Constraint violations/P1616 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 124,067 Main statement 121,269 97.7% of uses Qualifier 3 <0.1% of uses Reference 2,795 2.3% 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)

List of violations of this constraint: Database reports/Constraint violations/P1616#Format, hourly updated report, 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/P1616#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/P1616#Single value, SPARQL

Type “organization (Q43229), human (Q5), administrative territorial entity (Q56061), juridical person (Q155076), enterprise (Q6881511)”: item must contain property “instance of (P31)” with classes “organization (Q43229), human (Q5), administrative territorial entity (Q56061), juridical person (Q155076), enterprise (Q6881511)” 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/P1616#Type Q43229, Q5, Q56061, Q155076, Q6881511, SPARQL

Qualifiers “start time (P580), end time (P582), reason for deprecated rank (P2241), subject named as (P1810), end cause (P1534)”: this property should be used only with the listed qualifiers. (Help)

List of violations of this constraint: Database reports/Constraint violations/P1616#allowed qualifiers, hourly updated report, SPARQL

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

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

Check first digit (1 or 2 for public)
First digit need to be 1 or 2 for a public organisation, source (Help)
Violations query: SELECT ?item ?itemLabel ?value ?first ?legalForm ?legalFormLabel ?isPublic ?firstPublic { ?item wdt:P1616 ?value ; wdt:P1454 ?legalForm. { VALUES ?privateClasses { wd:Q4830453 wd:Q197952 wd:Q3591583 wd:Q2867418 } . ?item wdt:P31/wdt:P279* ?privateClasses . BIND(false as ?isPublic) } UNION { VALUES ?publicClasses { wd:Q15343039 wd:Q3244038 wd:Q11513034 } . ?item wdt:P31/wdt:P279* ?publicClasses . BIND(true as ?isPublic) } BIND(substr(str(?value),1,1) AS ?first) BIND((?first = '1' || ?first = '2') AS ?firstPublic) FILTER(?isPublic != ?firstPublic) FILTER(STRLEN(str(?value)) = 9) } ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P1616#Check first digit (1 or 2 for public)

Not having P1454
(Help)
Violations query: SELECT DISTINCT ?item WHERE { ?item wdt:P1616 ?value . FILTER NOT EXISTS { ?item wdt:P1454 [] } MINUS { VALUES ?classes { wd:Q3917681 wd:Q484170 wd:Q18821702 wd:Q21869758 wd:Q423785 wd:Q192350 wd:Q3591564 wd:Q375928 wd:Q11204 wd:Q1641572 } . ?item wdt:P31/wdt:P279* ?classes. } } ORDER BY ?item
List of this constraint violations: Database reports/Complex constraint violations/P1616#Not having P1454

This property is being used by: br:Patrom:Infobox etrekumuniezh fr:Modèle:Infobox Intercommunalité de France Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

The base URL will change

The Website https://entreprise.data.gouv.fr/ will be replaced by https://annuaire-entreprises.data.gouv.fr/ in a few weeks.

VIGNERON
Ayack
Benoît Prieur
Ash Crow
Tubezlob
PAC2
Thierry Caro
Pymouss
Alphos
GAllegre
Jean-Frédéric
Manu1400
Marianne Casamance
Nattes à chat
Pierre André
Bouzinac
Jsamwrites
Baidax
LearnKnowGive1
Mathieu Kappler
Daieuxetdailleurs
Archives nationales DJI
Jmax
LearnKnowGive1
Koxinga
Maxime
Framawiki
Legonin

Notified participants of WikiProject France. We will need to update P1630. PAC2 (talk) 22:42, 13 November 2020 (UTC)

Thanks, and feel free to do so. Nomen ad hoc (talk) 06:44, 14 November 2020 (UTC).

Sparql query to find siren id in annuaire-entreprises.data.gouv.fr

This SPARQL query looks for companies without SIREN number (P1616) value in annuaire-entreprises.data.gouv.fr.

Be careful, sometimes it is difficult to know which entity is the good match.

The following query uses these:

• Items: enterprise (Q6881511)   , France (Q142)   

• Properties: instance of (P31)   , subclass of (P279)   , country (P17)   , headquarters location (P159)   , industry (P452)   , dissolved, abolished or demolished date (P576)   , SIREN number (P1616)   

  SELECT DISTINCT ?item ?itemLabel ?itemDescription ?siegeLabel ?secteurLabel ?search WHERE {
    ?item (wdt:P31/(wdt:P279*)) wd:Q6881511;
      wdt:P17 wd:Q142;
      rdfs:label ?itemLabel;
      wikibase:sitelinks ?sitelinks.
    FILTER((LANG(?itemLabel)) = "fr")
    OPTIONAL { ?item wdt:P159 ?siege. }
    OPTIONAL { ?item wdt:P452 ?secteur. }
    MINUS { ?item wdt:P576 _:b10. }
    MINUS { ?item wdt:P1616 _:b11. }
    BIND(URI(CONCAT(" https://annuaire-entreprises.data.gouv.fr/rechercher?terme=", ENCODE_FOR_URI(?itemLabel))) AS ?search)
    SERVICE wikibase:label { bd:serviceParam wikibase:language "fr". }
  }
  ORDER BY DESC (?sitelinks)
  

Try it!

PAC2 (talk) 05:48, 9 May 2021 (UTC)