User:Mfilot/Wikidata Query Service Queries Nationalrat

Nationalräte

SELECT ?personLabel ?person ?parlamID ?kanton ?start ?ende ?legislatur ?dateofbirth
WHERE {
  ?person p:P39 ?statement1.
   ?statement1 ps:P39 wd:Q18510612.
   OPTIONAL {?person wdt:P569 ?dateofbirth}
   OPTIONAL { ?statement1 pq:P580 ?start}
   OPTIONAL { ?statement1 pq:P582 ?ende }
   OPTIONAL { ?statement1 pq:P768 ?kanton }
   OPTIONAL { ?statement1 pq:P2937 ?legislatur}
   OPTIONAL { ?person wdt:P1307 ?parlamID }
   OPTIONAL { ?person wdt:P102 ?partei }   
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "de,fr,it" . 
	 }
 }
 ORDER BY DESC(?dateofbirth)

Nationalräte der 51. Legislaturperiode

SELECT ?personLabel ?person ?parlamID ?kanton ?start ?ende ?legislatur ?dateofbirth
WHERE {
  ?person p:P39 ?statement1.
   ?statement1 ps:P39 wd:Q18510612.
   ?statement1 pq:P2937 wd:Q21511406.
   OPTIONAL {?person wdt:P569 ?dateofbirth}
   OPTIONAL { ?statement1 pq:P580 ?start}
   OPTIONAL { ?statement1 pq:P582 ?ende }
   OPTIONAL { ?statement1 pq:P768 ?kanton }
   OPTIONAL { ?statement1 pq:P2937 ?legislatur} 
   OPTIONAL { ?person wdt:P1307 ?parlamID }
   OPTIONAL { ?person wdt:P102 ?partei }   
	SERVICE wikibase:label {
		bd:serviceParam wikibase:language "de,fr" . 
	 }
 }
 ORDER BY DESC(?dateofbirth)