query-0b95520a9879e18608e74adefe4d3c5b

rq turtle/ttl

US senators occupying an office until a successor is namedHello, : ) Shinnin: @Jura1: @Oravrattas:　@M2Ys4U: @(P1534)end cause are the current uses, FWIW. ( Pinging a few people who have used this value of Here when a senator has not made it to the end of a term. Is it worth distinguishing someone who completed a term of office from someone finishing a "term of service" if you understand my meaning? (P1534)end cause for this? Obviously the vast majority of senators were "not re-elected" at some point, but I'm guessing marking them all is overkill. My focus has been supplying an (P1534)end cause the appropriate (Q22087114)not re-elected . Is "appointed to the United States Senate to fill the vacancy caused by the resignation of James Jackson and served from November 16, 1795, to April 12, 1796, when a duly elected successor presented his credentials and took his oath" have statements such as (Q1150348)Biographical Directory of the United States Congress whose entry in the (Q878512)George Walton There are a lot of senators such as

Use at

https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 * WHERE {
    VALUES ?bioid {
        "W000059" "W000114" "N000142" "T000086" "J000220" "G000489" "B001051" "W000324" "P000322" "E000136"
        "H000226" "R000378" "B000058" "F000304" "M000889" "B000168" "W000646" "S000905" "F000174" "M000596"
        "M000650" "R000368" "C000656" "F000174" "W000138" "B000960" "F000106" "S000809" "W000609" "J000103"
        "W000629" "C000952" "E000185" "P000530" "A000279" "B000331" "P000557" "E000046" "H000428" "C000343"
        "M000165" "C000357" "J000063" "P000141" "T000324" "R000450" "G000112" "B000386" "S000917" "E000109"
        "P000570" "H000457" "S000038" "M000229" "J000196" "Y000046" "P000238" "J000030" "W000305" "D000495"
        "G000522" "B000360" "W000471" "C000657" "R000075" "F000069" "A000028" "B001196" "W000499" "C001028"
        "G000510" "B000053" "A000126" "M000392" "S001060" "M000993" "W000069" "P000091" "C000597" "E000202"
        "T000225" "L000400" "B000389" "H000612" "H000646" "R000099" "M000787" "B000417" "S000478" "B001061"
        "B000099" "R000443" "W000096" "J000026" "W000248" "H000913" "S001117" "S000792" "B001069" "D000522"
        "L000173" "D000048" "P000575" "S000517" "B000966" "M000236" "F000438" "C001099"
    }
    ?sen p:P39 ?ps;
         wdt:P1157 ?bioid.
    ?ps ps:P39 wd:Q4416090;
        pq:P2937 ?term;
        pq:P582 ?end;
        pq:P580 ?start.
    ?term wdt:P580 ?termStart;
          wdt:P582 ?termEnd;
          (p:P31/pq:P1545) ?termNum.
      BIND(URI(CONCAT("https://bioguideretro.congress.gov/Home/MemberDetails?memIndex=", ?bioid)) AS ?bioURL)
      SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY (xsd:integer(?termNum))

Query found at

https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2020/12

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?bioURL"):::projected v2("?bioid"):::projected v6("?end"):::projected v4("?ps"):::projected v3("?sen"):::projected v7("?start"):::projected v5("?term"):::projected v9("?termEnd"):::projected v1("?termNum"):::projected v8("?termStart"):::projected a1((" ")) c13(["bd:serviceParam"]):::iri c4(["wd:Q4416090"]):::iri c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal bind0[/VALUES ?bioid/] bind0-->v2 bind00(["W000059"]) bind00 --> bind0 bind01(["W000114"]) bind01 --> bind0 bind02(["N000142"]) bind02 --> bind0 bind03(["T000086"]) bind03 --> bind0 bind04(["J000220"]) bind04 --> bind0 bind05(["G000489"]) bind05 --> bind0 bind06(["B001051"]) bind06 --> bind0 bind07(["W000324"]) bind07 --> bind0 bind08(["P000322"]) bind08 --> bind0 bind09(["E000136"]) bind09 --> bind0 bind010(["H000226"]) bind010 --> bind0 bind011(["R000378"]) bind011 --> bind0 bind012(["B000058"]) bind012 --> bind0 bind013(["F000304"]) bind013 --> bind0 bind014(["M000889"]) bind014 --> bind0 bind015(["B000168"]) bind015 --> bind0 bind016(["W000646"]) bind016 --> bind0 bind017(["S000905"]) bind017 --> bind0 bind018(["F000174"]) bind018 --> bind0 bind019(["M000596"]) bind019 --> bind0 bind020(["M000650"]) bind020 --> bind0 bind021(["R000368"]) bind021 --> bind0 bind022(["C000656"]) bind022 --> bind0 bind023(["F000174"]) bind023 --> bind0 bind024(["W000138"]) bind024 --> bind0 bind025(["B000960"]) bind025 --> bind0 bind026(["F000106"]) bind026 --> bind0 bind027(["S000809"]) bind027 --> bind0 bind028(["W000609"]) bind028 --> bind0 bind029(["J000103"]) bind029 --> bind0 bind030(["W000629"]) bind030 --> bind0 bind031(["C000952"]) bind031 --> bind0 bind032(["E000185"]) bind032 --> bind0 bind033(["P000530"]) bind033 --> bind0 bind034(["A000279"]) bind034 --> bind0 bind035(["B000331"]) bind035 --> bind0 bind036(["P000557"]) bind036 --> bind0 bind037(["E000046"]) bind037 --> bind0 bind038(["H000428"]) bind038 --> bind0 bind039(["C000343"]) bind039 --> bind0 bind040(["M000165"]) bind040 --> bind0 bind041(["C000357"]) bind041 --> bind0 bind042(["J000063"]) bind042 --> bind0 bind043(["P000141"]) bind043 --> bind0 bind044(["T000324"]) bind044 --> bind0 bind045(["R000450"]) bind045 --> bind0 bind046(["G000112"]) bind046 --> bind0 bind047(["B000386"]) bind047 --> bind0 bind048(["S000917"]) bind048 --> bind0 bind049(["E000109"]) bind049 --> bind0 bind050(["P000570"]) bind050 --> bind0 bind051(["H000457"]) bind051 --> bind0 bind052(["S000038"]) bind052 --> bind0 bind053(["M000229"]) bind053 --> bind0 bind054(["J000196"]) bind054 --> bind0 bind055(["Y000046"]) bind055 --> bind0 bind056(["P000238"]) bind056 --> bind0 bind057(["J000030"]) bind057 --> bind0 bind058(["W000305"]) bind058 --> bind0 bind059(["D000495"]) bind059 --> bind0 bind060(["G000522"]) bind060 --> bind0 bind061(["B000360"]) bind061 --> bind0 bind062(["W000471"]) bind062 --> bind0 bind063(["C000657"]) bind063 --> bind0 bind064(["R000075"]) bind064 --> bind0 bind065(["F000069"]) bind065 --> bind0 bind066(["A000028"]) bind066 --> bind0 bind067(["B001196"]) bind067 --> bind0 bind068(["W000499"]) bind068 --> bind0 bind069(["C001028"]) bind069 --> bind0 bind070(["G000510"]) bind070 --> bind0 bind071(["B000053"]) bind071 --> bind0 bind072(["A000126"]) bind072 --> bind0 bind073(["M000392"]) bind073 --> bind0 bind074(["S001060"]) bind074 --> bind0 bind075(["M000993"]) bind075 --> bind0 bind076(["W000069"]) bind076 --> bind0 bind077(["P000091"]) bind077 --> bind0 bind078(["C000597"]) bind078 --> bind0 bind079(["E000202"]) bind079 --> bind0 bind080(["T000225"]) bind080 --> bind0 bind081(["L000400"]) bind081 --> bind0 bind082(["B000389"]) bind082 --> bind0 bind083(["H000612"]) bind083 --> bind0 bind084(["H000646"]) bind084 --> bind0 bind085(["R000099"]) bind085 --> bind0 bind086(["M000787"]) bind086 --> bind0 bind087(["B000417"]) bind087 --> bind0 bind088(["S000478"]) bind088 --> bind0 bind089(["B001061"]) bind089 --> bind0 bind090(["B000099"]) bind090 --> bind0 bind091(["R000443"]) bind091 --> bind0 bind092(["W000096"]) bind092 --> bind0 bind093(["J000026"]) bind093 --> bind0 bind094(["W000248"]) bind094 --> bind0 bind095(["H000913"]) bind095 --> bind0 bind096(["S001117"]) bind096 --> bind0 bind097(["S000792"]) bind097 --> bind0 bind098(["B001069"]) bind098 --> bind0 bind099(["D000522"]) bind099 --> bind0 bind0100(["L000173"]) bind0100 --> bind0 bind0101(["D000048"]) bind0101 --> bind0 bind0102(["P000575"]) bind0102 --> bind0 bind0103(["S000517"]) bind0103 --> bind0 bind0104(["B000966"]) bind0104 --> bind0 bind0105(["M000236"]) bind0105 --> bind0 bind0106(["F000438"]) bind0106 --> bind0 bind0107(["C001099"]) bind0107 --> bind0 v3 --"p:P39"--> v4 v3 --"p:direct/P1157"--> v2 v4 --"p:statement/P39"--> c4 v4 --"p:qualifier/P2937"--> v5 v4 --"p:qualifier/P582"--> v6 v4 --"p:qualifier/P580"--> v7 v5 --"p:direct/P580"--> v8 v5 --"p:direct/P582"--> v9 v5 --"p:P31"--> a1 a1 --"p:qualifier/P1545"--> v1 bind1[/"concat('https://bioguideretro.congress.gov/Home/MemberDetails?memIndex=',?bioid)"/] v2 --o bind1 bind1 --as--o v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end