Property talk:P1045

Documentation

Sycomore ID
identifier in the Sycomore database of French MPs, National Assembly (France)

Description

members of French Parliaments since 1789

Represents

member of the French National Assembly (Q3044918)

Applicable "stated in" value

Sycomore (Q15271528)

Data type

External identifier

Domain

human (Q5) (note: this should be moved to the property statements)

Allowed values

[1-9]\d{0,4}

Example

Jean-Paul Virapoullé (Q3168709) → 7400
Adrien Victor Feuchères (Q2825279) → 10338

Source

http://www2.assemblee-nationale.fr/sycomore/recherche

Formatter URL

https://www2.assemblee-nationale.fr/sycomore/fiche/(num_dept)/$1

Tracking: usage

Category:Pages using Wikidata property P1045 (Q47005084)

Related to country

France (Q142) (See 652 others)

See also

senat.fr ID (P1808), French National Assembly ID (P4123), NosDéputés.fr identifiant (P7040)

Lists

Proposal discussion

Current uses

Total	30,413
Main statement	17,472 out of 17,438 (100% complete)	57.4% of uses
Qualifier	2	<0.1% of uses
Reference	12,939	42.5% 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{0,4}”: value must be formatted using this pattern (PCRE syntax). (Help)

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

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P1045#Unique value, hourly updated report, 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). Known exceptions: André-Louis Deprez (Q2847076), Jean-Pierre Pont (Q3169663), Léonard-Philippe Rivet (Q15967357)
List of violations of this constraint: Database reports/Constraint violations/P1045#Single value, SPARQL

Item “instance of (P31): human (Q5)”: Items with this property should also have “instance of (P31): human (Q5)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P1045#Item P31, hourly updated report, search, SPARQL

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (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/P1045#Item P21, search, SPARQL

Item “date of birth (P569)”: Items with this property should also have “date of birth (P569)”. (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/P1045#Item P569, SPARQL

Item “place of birth (P19)”: Items with this property should also have “place of birth (P19)”. (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/P1045#Item P19, search, SPARQL

Item “country of citizenship (P27): France (Q142), First French Empire (Q71084)”: Items with this property should also have “country of citizenship (P27): France (Q142), First French Empire (Q71084)”. (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/P1045#Item P27, search

Item “occupation (P106): politician (Q82955)”: Items with this property should also have “occupation (P106): politician (Q82955)”. (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/P1045#Item P106, search, SPARQL

Item “given name (P735)”: Items with this property should also have “given name (P735)”. (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/P1045#Item P735, 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/P1045#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/P1045#Scope, SPARQL

This property is being used by:

Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Number of current mandates
Number of current mandates should equal 577. (Help)
Violations query:

SELECT (wd:Q5 as ?item) (COUNT(DISTINCT ?p) as ?nombre) (?nombre<=577 as ?check_577) { ?p p:P39 ?fonction . ?fonction ps:P39 wd:Q3044918 . ?fonction pq:P580 ?start . FILTER NOT EXISTS  {?fonction pq:P582 ?end} } GROUP BY ?item

List of this constraint violations: Database reports/Complex constraint violations/P1045#Number of current mandates

Too old mandates
Start date before 22 June 2022 without any end date (Help)
Violations query:

SELECT ?item ?nom ?start ?Sycomore ?LienSycomore {?item p:P39 ?fonction . ?fonction ps:P39 wd:Q3044918 . ?fonction pq:P580 ?start . OPTIONAL {?item wdt:P1045 ?Sycomore} . FILTER NOT EXISTS {?fonction pq:P582 ?end} FILTER("2022-06-22"^^xsd:dateTime > ?start) BIND(URI(CONCAT("https://www2.assemblee-nationale.fr/sycomore/fiche/(num_dept)/", ENCODE_FOR_URI(?Sycomore))) AS ?LienSycomore) #Link to the Sycomore base ?item rdfs:label ?nom .  FILTER (LANG(?nom)="fr") #Label in French }

List of this constraint violations: Database reports/Complex constraint violations/P1045#Too old mandates

Replacement during the current mandate, but no end date
For mandates starting on 22 June 2022 of later, (Help)
Violations query:

SELECT ?item ?name ?start  {?item p:P39 ?fonction . ?fonction ps:P39 wd:Q3044918 . ?fonction pq:P580 ?start . ?fonction pq:P1366 ?replacement . FILTER NOT EXISTS {?fonction pq:P582 ?end} FILTER("2022-06-22"^^xsd:dateTime <= ?start) ?item rdfs:label ?name .  FILTER (LANG(?name)="fr") #Label in French }

List of this constraint violations: Database reports/Complex constraint violations/P1045#Replacement during the current mandate, but no end date

Add topic