Open main menu

Wikidata:Database reports/children of dead mothers

< Wikidata:Database reports

List of mother-children pairs, where death date of parent < birth date of child.

Last update: 2018-11-10 23:24, generally updated daily.

This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!

WDQS | PetScan | YASGUI | Find images Recent changes | Query: SELECT ?item ?bdate (CONCAT("{", "{Q\u007C", STRAFTER(STR(?mother), "Q"), "}", "}") AS ?mo) ?mddate (year(?bdate) - year(?mddate) as ?delta) WHERE { ?item wdt:P31 wd:Q5 ; (p:P569/psv:P569) ?bdate_node; wdt:P25 ?mother. ?mother (p:P570/psv:P570) ?mddate_node. ?bdate_node wikibase:timePrecision ?bprec ; wikibase:timeValue ?bdate. ?mddate_node wikibase:timePrecision ?mdprec; wikibase:timeValue ?mddate. FILTER(?bdate > ?mddate) FILTER(?bprec >= 9 && ?mdprec >= 9 && (?bprec = ?mdprec \u007C\u007C year(?bdate) > year(?mddate))) } ORDER BY DESC(?delta) ?mother ?item
number Mother Child Mother death date Child birth date Delta
1 Matilda of Guelders (Q2031173) Elisabeth of Nassau (1225-1295) 0028-10-01 1225-01-01 1197
2 Matilda of Guelders (Q2031173) Walram II of Nassau 0028-10-01 1220-01-01 1192
3 Beatrice of Savoy, Lady of Villena (Q3196667) Don Juan Manuel 1292-01-01 1890-01-01 598
4 Marie de Bourbon, Princess of Achaea (Q576479) Anne Marie Louise d'Orléans 1387-01-01 1627-05-29 240
5 Anna of Glogau (Q2797080) Henry V of Rosenberg 1271-07-02 1456-06-25 185
6 Cleopatra III of Egypt (Q40003) Cleopatra Selene of Syria -100-01-01 0041-01-01 141
7 Elvira Menendez (Q840414) Bermudo III of León 0921-01-01 1017-01-01 96
8 Frances Sheridan (Q5478941) Betsy Sheridan 1766-09-26 1858-01-01 92
9 Menumorut (Q3108309) Taksony of Hungary 0851-01-01 0931-01-01 80
10 Giovanna of Austria (Q56718982) Margherita Branciforte 1630-02-08 1695-01-11 65
11 Apolonia Bielejewicz (Q17278236) Anna Kaźmierczak 1903-01-01 1962-09-22 59
12 Elizabeth Stanhope, Countess of Chesterfield (Q245681) Charles Stanhope 1665-01-01 1708-09-06 43
13 no label (Q16522917) Margit Szekrényessy 1876-02-20 1914-08-01 38
14 no label (Q54812244) Adolf IX of Berg 1258-06-16 1290-01-01 32
15 Princess Iwa (Q1066593) Ingyō 0347-01-01 0376-01-01 29
16 no label (Q54810771) Maria von Wied 1478-03-21 1505-01-01 27
17 Mary Maitland (Q18917748) George Lauder 1596-01-01 1622-01-01 26
18 Fiorenza Crispo (Q12813944) Giorgio Corner 1501-12-08 1524-02-01 23
19 no label (Q54833828) Gerhard I von Sayn 1367-10-22 1390-01-01 23
20 Juana Núñez de Lara (Q6301465) Margarita de Lara 1351-06-20 1373-01-01 22
21 Ulla Tessin (Q440442) Christina Charlotta Wrangel 1768-12-14 1787-12-14 19
22 Margareta Amalia Floor (Q47928409) Johanna Lohm 1728-02-17 1747-07-25 19
23 Halaszka Radziwiłł (Q19683587) Kazimierz Leon Sapieha 1591-01-01 1609-07-15 18
24 Françoise de Jacquesson de Soiry (Q47366824) Marie Claude de Vassinhac d'Imécourt 1679-01-01 1697-01-01 18
25 Lysbeth Adriaens (Q29167089) Elisabeth van Bracht 1679-05-29 1696-01-01 17
26 Halaszka Radziwiłł (Q19683587) Krzysztof Michał Sapieha 1591-01-01 1607-08-10 16
27 Margaret Grey, Lady Bonville (Q6759465) William Bonville, 6th Baron Harington 1426-01-01 1442-01-01 16
28 Juliana of Stolberg (Q202566) Magdalene of Nassau-Dilleburg 1580-06-18 1595-11-13 15
29 Elizabeth Manners (Q15665890) Edward Monckton 1730-03-22 1744-11-03 14
30 Margaret Shelton (Q18674140) Mary Scudamore 1536-01-01 1550-01-01 14
31 Aldonza Alfonso de León (Q8193954) Fernando Rodríguez de Castro 1266-01-01 1280-01-01 14
32 Marguerite de l'Aigle (Q2842845) Margaret of Navarre 1141-06-01 1154-03-05 13
33 Zofia Opalińska (Q9391829) Elżbieta Sieniawska 1657-01-01 1669-01-01 12
34 Bertha of Tübingen (Q106928) Herman V, Margrave of Baden-Baden 1169-02-24 1180-01-01 11
35 Catherine Carey (Q241550) Lettice Digby, 1st Baroness Offaly 1569-02-04 1580-01-01 11
36 Vendela Lohrman (Q47680827) Christina Charlotta Rudbeck 1711-07-08 1722-01-01 11
37 Nicolosia Bellini (Q18507304) Francesco Mantegna 1460-01-01 1470-01-01 10
38 Wuna of Wessex (Q2594962) Saint Walpurga 0700-01-01 0710-01-01 10
39 Constanza Pérez de Aragón (Q774865) Lope de Luna 1311-01-01 1320-01-01 9
40 Basina of Thuringia (Q268562) Bertachar 0477-01-01 0485-01-01 8
41 Rotrude of Trier (Q469702) Auda of France 0725-01-01 0732-01-01 7
42 no label (Q54810771) Johann III von Wied 1478-03-21 1485-01-01 7
43 Al Jawhara bint Musaed Al Jiluwi (Q4704130) Abdul Muhsin bin Abdulaziz Al Saud 1919-01-01 1925-01-01 6
44 Waldrada (Q263164) Ramhilde of Bavaria 0570-01-01 0575-01-01 5
45 Gunnhildr Sveinsdóttir (Q2656291) Niels, King of Denmark 1060-01-01 1065-01-01 5
46 Lysbeth Adriaens (Q29167089) Johan van Bracht 1679-05-29 1684-01-01 5
47 no label (Q54810797) Филип фон Вирнебург 1420-01-01 1425-01-01 5
48 Adelheid von Ziegenhain (Q54824161) Куно III фон Мюнценберг 1226-03-05 1231-01-01 5
49 Gerlod Duncansdatter (Q16726155) Hlodvir Thorfinnsson 0941-01-01 0945-01-01 4
50 Al Jawhara bint Musaed Al Jiluwi (Q4704130) Musa'id bin Abdulaziz Al Saud 1919-01-01 1923-01-01 4
51 Countess Xenia Czernichev-Besobrasov (Q5177075) Catharina de Habsbourg 1968-01-01 1972-09-14 4
52 no label (Q54810522) Albrecht III. von Werdenberg-Heiligenberg-Bludenz 1363-10-14 1367-01-01 4
53 Basina of Thuringia (Q268562) Baderic 0477-01-01 0480-01-01 3
54 Odile de Provence (Q3349265) Peter 2nd Bishop of Nice 1032-01-01 1035-01-01 3
55 Blanca de La Cerda y Lara (Q4924776) Fernando Manuel de Villena 1347-01-01 1350-01-01 3
56 Anneke Hermansz (Q13564504) Frans Hals Junior 1616-01-01 1618-01-01 2
57 Chen Zhaoniang (Q15927532) Zheng Kezang 1662-01-01 1664-01-01 2
58 Gytha of Wessex (Q2995934) Liubava Dmitrievna Zavidich 1098-03-10 1100-01-01 2
59 Urraca di Navarra (Q4006504) Fernando García de Hita 1095-02-07 1097-01-01 2
60 no label (Q51580540) Ελένη Υψηλάντη 1787-01-01 1789-01-01 2
61 Ingund (Q1265586) Palatina of Troyes 0546-01-01 0547-01-01 1
62 Milica Branković (Q19901992) Carlo III Tocco 1464-01-01 1465-01-01 1
63 Anna Porphyrogenita (Q2042216) Maria Dobroniega of Kiev 1011-01-01 1012-01-01 1
64 Petronilla of Aquitaine (Q269961) Eleanor, Countess of Vermandois 1151-01-01 1152-10-14 1
65 Anne de Constantinople (Q2851340) Charles Constantine of Vienne 0900-01-01 0901-01-01 1
66 Shahrbanu (Q2995077) Ali ibn al-Husayn Zayn al-'Abidin 0658-01-01 0659-01-07 1
67 Barbara von Krüdener (Q63784) Juliette von Krüdener 1824-12-13 1825-01-01 1
68 Clemence of Austria (Q771859) Clementia of Hungary 1293-02-07 1293-02-15 0
End of automatically generated list.