query-8cdc42d2e7b5c894fefebf2a842aa7e2

rq turtle/ttl

Completing the list of historical House of Representatives members and compared that against what's in Wikidata. There are a few entries which don't exist in the Biographical Directory but are mentioned in entries for other members (see above). I've contacted them about this. Other than those, there are 11029 members which are in Wikidata and 1778 (funny number) which are missing. If anyone has any advice on how to add new entries or any template they'd like me to use, please let me know. Otherwise, I'll try to figure it out and post back here. Regards, 23:29, 27 November 2020 (UTC) Biographical Directory I just grabbed the list of all ids for members of the House from the instead.the WikiProject's talk page. Please post on couldn't be pinged has more than 50 participants and WikiProject every politician Trying to reconcile the two sites against each other turned up only a handful of discrepancies which should be easy to manual follow up on. 23:26, 6 December 2020 (UTC)) talk (Gettinwikiwidit does at least back to 1974. I'm currently scraping this data. Wikipedia itself can be scraped for older terms, but I'm unable to track down from which sources this information was derived. this siteSadly the Biographical directory does not have information about which districts were served. However

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 schema: <http://schema.org/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?rep ?repLabel ?bioid ?missingDirectoryTerm ?bioURL ?congressURL ?article WHERE {
  VALUES (?bioid ?missingDirectoryTerm ) {
    ("S000847" "96")
    ("T000410" "92")
    ("H001092" "116")
    ("Z000001" "98")
    ("M000249" "109")
    ("M000388" "111")
    ("C000542" "101")
    ("S000716" "97")
    ("D000211" "80")
    ("B000966" "99")
    ("R000249" "94")
    ("D000373" "107")
    }
  ?rep wdt:P1157 ?bioid;
       p:P39 ?stmt.
  OPTIONAL {
?rep       ^schema:about ?article. }
  ?article schema:isPartOf <https://en.wikipedia.org/>.

  OPTIONAL { ?stmt ps:P39 wd:Q13218630. }
  OPTIONAL { ?stmt prov:wasDerivedFrom/pr:P854 ?ref. }
  OPTIONAL { ?stmt pq:P2937 ?term. }
  OPTIONAL { ?stmt pq:P4100 ?party. }
  BIND(URI(CONCAT("https://www.congress.gov/member/william-steiger/",?bioid,"?searchResultViewType=expanded")) AS ?congressURL)
  BIND(URI(CONCAT("http://bioguide.congress.gov/scripts/biodisplay.pl?index=",?bioid)) AS ?bioURL )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
} ORDER BY ?repLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_every_politician/United_States_of_America/Archive/2021/01