query-64ea961f689cdec88e2479243502fc2a

rq turtle/ttl

Ancestry of MPs who have an unbroken line of MPs as direct ancestors (usually fathers)

Report worked in 2017-18 or so but timed out by 2020, due to increasing numbers.

SELECT DISTINCT ?person1 ?person2 ?person3 ?person4 ?person5 ?person6 ?person7 ?person8 ?person9 ?person10 WHERE { { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] } # UK MP UNION { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] } # British MP UNION { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] } # English MP # person 1 is an MP { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person1 } UNION { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person1 } UNION { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person1 } # person 2 is an MP, and person 1 is their child
{ ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person2 } UNION { ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person2 } UNION { ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person2 }
# person 3 is an MP, and person 2 is their child { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person3 } UNION { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person3 } UNION { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person3 }
# person 4 is an MP, and person 3 is their child { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person4 } UNION { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person4 } UNION { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person4 }
# person 5 is an MP, and person 6 is their child { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person5 } UNION { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person5 } UNION { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person5 } # person 6 is an MP, and person 5 is their child { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person6 } UNION { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person6 } UNION { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person6 }
# person 7 is an MP, and person 6 is their child { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person7 } UNION { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person7 } UNION { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person7 } # person 8 is an MP, and person 7 is their child { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person8 } UNION { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person8 } UNION { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person8 } # person 9 is an MP, and person 8 is their child { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person9 } UNION { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18015642 ] ; wdt:P40 ?person9 } UNION { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q18018860 ] ; wdt:P40 ?person9 } # person 10 is an MP, and person 9 is their child

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
#Ancestry of MPs who have an unbroken line of MPs as direct ancestors (usually fathers)
# Report worked in 2017-18 or so but timed out by 2020, due to increasing numbers.
SELECT DISTINCT ?person1 ?person2 ?person3 ?person4 ?person5 ?person6 ?person7 ?person8 ?person9 ?person10
WHERE {
            { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] } # UK MP
      UNION { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] } # British MP
      UNION { ?person1 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] } # English MP
  # person 1 is an MP
            { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person1 }
      UNION { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person1 }
      UNION { ?person2 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person1 }
  # person 2 is an MP, and person 1 is their child      
            { ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person2 }
      UNION { ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person2 }
      UNION { ?person3 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person2 }   
  # person 3 is an MP, and person 2 is their child
            { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person3 }
      UNION { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person3 }
      UNION { ?person4 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person3 }  
  # person 4 is an MP, and person 3 is their child
            { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person4 }
      UNION { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person4 }
      UNION { ?person5 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person4 }  
  # person 5 is an MP, and person 6 is their child
            { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person5 }
      UNION { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person5 }
      UNION { ?person6 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person5 }
  # person 6 is an MP, and person 5 is their child
            { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person6 }
      UNION { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person6 }
      UNION { ?person7 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person6 }  
  # person 7 is an MP, and person 6 is their child
            { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person7 }
      UNION { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person7 }
      UNION { ?person8 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person7 }
  # person 8 is an MP, and person 7 is their child
            { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person8 }
      UNION { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person8 }
      UNION { ?person9 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person8 }
  # person 9 is an MP, and person 8 is their child
            { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279 wd:Q16707842 ] ; wdt:P40 ?person9 }
      UNION { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18015642 ] ; wdt:P40 ?person9 }
      UNION { ?person10 wdt:P31 wd:Q5 ; wdt:P39 [ wdt:P279* wd:Q18018860 ] ; wdt:P40 ?person9 }
  # person 10 is an MP, and person 9 is their child

Query found at

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