query-0ff740eb7517bee34cc9ebdf5d1a0ab9

rq turtle/ttl

Congressional districts by affiliation for 115th House of Representatives

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#>
#defaultView:Map
SELECT DISTINCT 
  ?item ?itemLabel 
  ?district ?districtLabel 
  ?shape 
  (SAMPLE(?image) as ?image) 
  ?group ?groupLabel 
  (IF(MIN(?groupID) = "0", "Republican", IF(MIN(?groupID) = "1", "Democrat", "Other")) AS ?layer) 
WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?item p:P39 ?rep.             # Item has position held statement
  ?rep ps:P39 wd:Q13218630.     # Position held statement has Position Held value of US Representative
  ?rep pq:P2937 wd:Q18740945.   # Position held statement has Parliamentary Term value of 115th US Congress
  ?rep pq:P768 ?district.       # Position held statement has Electoral District value
  ?district wdt:P3896 ?shape.   # Electoral District has Geoshape value
  ?rep pq:P4100 ?group.         # Position held statement has Parliamentary Group value
  ?item wdt:P18 ?image.         # Item has Image value
  BIND(IF(?group = wd:Q29468, "0", IF(?group = wd:Q29552, "1", "2")) AS ?groupID)
}
GROUP BY ?item ?itemLabel ?layer ?district ?districtLabel ?shape ?image ?group ?groupLabel

Query found at