query-c0eda7a7b4c0b8a9deaa0c512eff10f0

rq turtle/ttl

أعضاء الولايات المتحدة الحاليين في مجلس الشيوخ مع مقاطعة وحزب وتاريخ توليهم المنصب Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Současní členové Senátu USA s uvedením obvodu, strany a data nástupu do funkce Current U.S. members of the Senate with district, party and date they assumed office Aktuelle Mitglieder des U. S. Senats nach Distrikt, Parte und Amtsantritt Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Membres actuels du Sénat américain avec le district, le parti et la date de leur entrée en fonction Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Attuali membri del Senato degli Stati Uniti con distretto, partito e data di inizio della carica Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Huidige Amerikaanse leden van de Senaat met district, partij en datum waarop ze in functie zijn getreden Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Текущие члены Сената США, у которых указаны округ, партия и дата вступления в должность Current U.S. members of the Senate with district, party and date they assumed office Nuvarande medlemmar i amerikanska senaten med distrikt, parti och datumet de anträdde posten Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office Current U.S. members of the Senate with district, party and date they assumed office

Use at

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 ?senator ?senatorLabel ?districtLabel ?partyLabel ?assumedOffice (sample(?image) as ?image) where {
  # Get all senators
  ?senator 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

  # Check on the position in the senate
  ?posheld ps:P39 wd:Q4416090; # Position held is in the senate
           pq:P768 ?district;
           pq:P580 ?assumedOffice. # And should have a starttime

  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],mul,en". }
} GROUP BY ?senator ?senatorLabel ?districtLabel ?partyLabel ?assumedOffice ORDER BY ?senatorLabel

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v9("?assumedOffice"):::projected v8("?district") v10("?endTime") v12("?image"):::projected v7("?partOf") v5("?party") v6("?partyEnd") v4("?partystatement") v3("?posheld") v2("?senator"):::projected v1("?senatorLabel"):::projected c14(["#91;AUTO_LANGUAGE#93;,mul,en"]):::literal c12(["bd:serviceParam"]):::iri c7(["wd:Q4416090"]):::iri v2 --"p:P39"--> v3 v2 --"p:P102"--> v4 v4 --"p:statement/P102"--> v5 subgraph minus0["MINUS"] style minus0 stroke-width:6px,fill:pink,stroke:red; v4 --"p:qualifier/P582"--> v6 end subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v5 --"p:direct/P361"--> v7 end v3 --"p:statement/P39"--> c7 v3 --"p:qualifier/P768"--> v8 v3 --"p:qualifier/P580"--> v9 subgraph minus2["MINUS"] style minus2 stroke-width:6px,fill:pink,stroke:red; v3 --"p:qualifier/P582"--> v10 end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v2 -."p:direct/P18".-> v12 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind4[/"sample(?image)"/] v12 --o bind4 bind4 --as--o v12