query-1bd6c6513f4d5593f48a5b6f3621a313
Everyone with gender, dates, and Historic Hansard IDsThis contains everyone in Historic Hansard, plus some MPs known to have served between 1803 and 2005 who do not, for whatever reason, have Historic Hansard entries. It does not include Lords without Historic Hansard entries, and may have some gaps for pre-1886 MPs without Historic Hansard entries (as those years have not yet been fully validated). markers. ;Unknown birth/death years are shown as blank. Historic Hansard IDs (where several exist) are shown separated by
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 rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 distinct ?person ?personLabel ?genderLabel ?birthyear ?deathyear (GROUP_CONCAT(distinct ?hh; separator="; ") as ?historic_hansard)
WHERE {
{ ?person wdt:P2015 ?hh . }
# anyone in Historic Hansard (includes Lords)
union
{ ?position wdt:P279 wd:Q16707842 . ?person p:P39 ?positionStatement .
?positionStatement ps:P39 ?position ; pq:P580 ?start .
bind(year(?start) as ?startyear) . filter (?startyear < 2005 ) . filter (?startyear > 1802 ) }
# plus anyone elected as an MP between 1803 and 2004, but not otherwise in Historic Hansard.
optional {?person wdt:P21 ?gender } .
optional {?person wdt:P569 ?born . bind(year(?born) as ?birthyear) } .
optional {?person wdt:P570 ?died . bind(year(?died) as ?deathyear) } .
# gender and dates
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" .
?person rdfs:label ?personLabel .
?gender rdfs:label ?genderLabel . }
# labels
} group by ?person ?personLabel ?genderLabel ?birthyear ?deathyear
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v9("?birthyear"):::projected
v8("?born")
v11("?deathyear"):::projected
v10("?died")
v7("?gender")
v13("?genderLabel"):::projected
v2("?hh"):::projected
v14("?historic_hansard")
v1("?person"):::projected
v12("?personLabel"):::projected
v4("?position")
v5("?positionStatement")
v6("?start")
v7("?startyear")
c5(["wd:Q16707842"]):::iri
c15(["en"]):::literal
c13(["bd:serviceParam"]):::iri
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
f0[["?startyear > '1802^^xsd:integer'"]]
f0 --> v7
f1[["?startyear < '2005^^xsd:integer'"]]
f1 --> v7
v4 --"p:direct/P279"--> c5
v1 --"p:P39"--> v5
v5 --"p:statement/P39"--> v4
v5 --"p:qualifier/P580"--> v6
bind2[/"year-from-dateTime(?start)"/]
v6 --o bind2
bind2 --as--o v7
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v1 --"p:direct/P2015"--> v2
end
union0r <== or ==> union0l
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v1 -."p:direct/P21".-> v7
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v1 -."p:direct/P569".-> v8
bind3[/"year-from-dateTime(?born)"/]
v8 --o bind3
bind3 --as--o v9
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
v1 -."p:direct/P570".-> v10
bind4[/"year-from-dateTime(?died)"/]
v10 --o bind4
bind4 --as--o v11
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
v1 --"rdfs:label"--> v12
v7 --"rdfs:label"--> v13
end
bind6[/"?hh"/]
v2 --o bind6
bind6 --as--o v14