query-99d6ccd14c174ceda1c7c3c84949fc32

rq turtle/ttl

Remaining work for Senators. Some of this is due to the fact that the Party system took a few years to be firmly established, but some of it simply requires more work. Also a handful of the names need to be entered. (P4100)parliamentary group qualifier on them. Quite a bit more lack a (P768)electoral district and (P2937)parliamentary term , you can see that all but four outlier cases have both a Project pageRunning the checks on the ) and can largely be gleaned from the senate class a senator's seat is a part of. None of these options are particularly trivial. It might be best to try all of them as a cross check against each other. Georgia, the various lists of senators by state (e.g. (Q1150348)Biographical Directory of the United States Congress qualifier for each of these statements. This information is available spottily in the prose part of the (P2715)elected in for at least all senators who didn't serve out their term. Many of these have been done, but a systematic check has not been taken up. In addition, given the staggered senate terms outlined in the Senate Class system mentioned above it would be good to include an (P1534)end cause Aside from these checks it would be good to have an look strange. I think this is because they hew closely to the items in en-wiki. Which should we use? Is it better to have a consistent set used in Wikidata which reference the Wikipedia items? (Q5510738)1812 and 1813 United States Senate elections . It doesn't look like all the possibilities have been created, the labeling is inconsistent and some items such as (Q24333627)United States Senate election is the organization of (P2715)elected in qualifier. Another issue with providing (P2715)elected in of senators. Prior to that they were elected by the various state legislatures. It's not clear how or if we want to account for that in the use of the direct electionsIt's worth noting that it wasn't until 1913 and the establishment of the 17th Amendment that there were

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?election ?electionLabel WHERE {
  ?election wdt:P31/wdt:P279* wd:Q24333627;
            wdt:P17 wd:Q30.
  ?election wdt:P585 ?pit.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY DESC(?pit)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?election"):::projected v1("?pit") a1((" ")) c8(["bd:serviceParam"]):::iri c5(["wd:Q30"]):::iri c10(["#91;AUTO_LANGUAGE#93;,en"]):::literal c3(["wd:Q24333627"]):::iri v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c3 v2 --"wdt:P17"--> c5 v2 --"wdt:P585"--> v1 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c8 --"wikibase:language"--> c10 end