query-f60001a6dc646b4a72e32422f2f4f1a3

rq turtle/ttl

All MPs born since 1945, sorted by month of birth

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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?month (count(?item) as ?total)
{
 ?item wdt:P31 wd:Q5 ; p:P39 ?ps . ?ps ps:P39 ?term .
 ?term wdt:P279* wd:Q16707842 .     # all UK MPs
 ?item wdt:P569 ?born .             # with a known birthday
 BIND( MONTH(?born) AS ?month )     # identify the month of birth
 BIND( YEAR(?born) AS ?year )       # identify the year of birth
 FILTER (?year > 1945 ) 
 ?item p:P569/psv:P569 ?date_node .
 ?date_node wikibase:timePrecision "11"^^xsd:integer .  # filter only day-precision records
 SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
GROUP BY ?month
ORDER BY ?month
#defaultView:LineChart

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_British_Politicians/Sample_Queries