query-77c980a0a403f84042a289a0b2803817

rq turtle/ttl

TODO

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
select ?MP ?MPLabel ?districtLabel ?partyLabel ?assumedOffice ?endTime (sample(?image) as ?image) ?legislatureLabel ?pgroupLabel where {

 # Get all senators
 ?MP p:P39 ?posheld; # With position held
          p:P102 ?partystatement. # And with a certain party

 # Get the party
 ?partystatement ps:P102 ?party.
 #minus { ?partystatement pq:P582 ?partyEnd. } # but minus the ones the senator is no longer a member of
 #minus { ?party wdt:P361 ?partOf. } # and the 'Minnesota Democratic–Farmer–Labor Party' and such

 # define which legislatures are of interest
  VALUES ?legislature {wd:Q77345372} 

 # Check on the position in the CD
 ?posheld ps:P39 wd:Q18171345; # Position held is in the CD
          pq:P768 ?district;
          pq:P580 ?assumedOffice; # And should have a starttime
          pq:P582 ?endTime .
  ?posheld pq:P2937 ?legislature . 
  OPTIONAL { ?posheld pq:P4100 ?pgroup . }

 #minus { ?posheld pq:P582 ?endTime. } # But not an endtime 

 # Add an image
 #optional { ?senator wdt:P18 ?image. }

 service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} group by ?MP ?MPLabel ?districtLabel ?partyLabel ?assumedOffice ?endTime  ?legislatureLabel ?pgroupLabel order by ?deputy

Query found at

• https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service/queries