Report: Kings and Queens in the Family Tree
Description:
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,firstname, lastname,(if(sex='M',families1.wife,families2.husband)) as spouse,e4.info as info4,birthdate,birthplace,deathdate,deathplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) LEFT JOIN tng_events e4 ON tng_people.personID = e4.persfamID AND tng_people.gedcom = e4.gedcom AND e4.eventtypeID = "4" WHERE ((title LIKE "%king%" OR title LIKE "%emperor%" OR title LIKE "%roi%" OR title LIKE "%empereur%" OR title LIKE "%könig%" OR title LIKE "%kaiser%" OR title LIKE "%czar%" OR title LIKE "%tsar%" OR title LIKE "%queen%" OR title LIKE "%empress%" OR title LIKE "%reine%" OR title LIKE "%impératrice%" OR title LIKE "%königin%" OR title LIKE "%kaiserin%" OR title LIKE "%czarina%" OR title LIKE "%tsarina%") AND ((tng_people.living !=1 && tng_people.private != 1))) ORDER BY firstname,lastname
Matches 1 to 100 of 172
# | Full Name | Spouse Name | Description | Birth Date | Birth Place | Death Date | Death Place |
---|---|---|---|---|---|---|---|
1 | Queen Audofleda | Abt 467 | Abt 511 | Ravenna, Emilia-Romagna, Italy ![]() |
|||
2 | Queen Caretene | King Gundobad | Abt 456 | 16 Sep 506 | |||
3 | Queen Consort Luitgard | Emperor Charlemagne De Herstal | 4 Jun 800 | ||||
4 | ![]() |
Living | Abt 475 | 524 | Orléans, Loiret, Centre, France ![]() |
||
5 | Queen Teudelinda | King Godegisel | 501 | ||||
6 | King Adalbert D'Italie, I dit le Captif | Queen Gerberge De Chalon | Abt 934 | 30 Apr 971 | Autun, Saône-et-Loire, Bourgogne, France ![]() |
||
7 | Queen Adelaide D'Aquitaine | King Hugues De France, I | 945 | Poitiers, Vienne, Poitou-Charentes, France ![]() |
15 Jun 1004 | Paris, Paris, Île-de-France, France ![]() |
|
8 | Queen Adelaïde De Paris | Emperor Louis De France, II dit le Bègue (the Stutterer) | DECEASED | ||||
9 | Queen Adélaïde De Provence | King Conrad, dit le Pacifique | 930 | 963 | |||
10 | ![]() |
Raymond De Toulouse, V | Abt 947 | Arles, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France ![]() |
1026 | Avignon, Vaucluse, Provence-Alpes-Côte d'Azur, France ![]() |
|
11 | ![]() |
Vicomte Etienne de Brioude De Gévaudan, II | Abt 947 | Arles, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France ![]() |
1026 | Avignon, Vaucluse, Provence-Alpes-Côte d'Azur, France ![]() |
|
12 | ![]() |
King Louis De France, V dit le Fainéant (the Do-Nothing) | Abt 947 | Arles, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France ![]() |
1026 | Avignon, Vaucluse, Provence-Alpes-Côte d'Azur, France ![]() |
|
13 | ![]() |
Count William De Provence, I dit le Libérateur (the Liberator) | Abt 947 | Arles, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France ![]() |
1026 | Avignon, Vaucluse, Provence-Alpes-Côte d'Azur, France ![]() |
|
14 | Queen Adèle D'Austrasie | King Eudes D'Aquitaine De Gascogne, dit le Grand | 670 | 24 Dec 734 | |||
15 | Queen Adeltrude De Soissons | King Clotaire De France, II | 586 | DECEASED | |||
16 | ![]() |
King Robert De France, I | Abt 870 | 895 | |||
17 | Queen Alice De Champagne | Abt 1193 | 1246 | ||||
18 | Queen Andregote Galindez D'Aragon | King Garcia Sanchez De Navarre, II | Abt 910 | 972 | |||
19 | Queen Anna Laroslavna De Kiev | King Henri De France, I | 1024 | Kiev, Ukraine ![]() |
1078 | Verneuil-l'Etang, Seine-et-Marne, Île-de-France, France ![]() |
|
20 | Queen Ansa | King Desiderius | Aft 774 | ||||
21 | Queen Ansa De Brescia | Roi Didier De Lombardie | DECEASED | ||||
22 | ![]() |
Emperor Louis De France, II dit le Bègue (the Stutterer) | Abt 840 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
18 Dec 879 | ||
23 | Saint and Queen Balthild | King Clovis De France, II | Between 626 and 627 | 30 Jan 680 | Abbaye de Chelles, Chelles, Seine-et-Marne, Île-de-France, France ![]() |
||
24 | Queen Basina De Thuringia | King Childeric, I | Abt 438 | 477 | |||
25 | Queen Beatrice De Vermandois | King Robert De France, I | 26 Mar 880 | Vermandois, Aisne, Picardie, France ![]() |
31 Mar 931 | Paris, Paris, Île-de-France, France ![]() |
|
26 | ![]() |
Queen Cunégonde De Gellone | 797 | Bohain-en-Vermandois, Aisne, Picardie, France ![]() |
17 Apr 818 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
27 | Saint and Queen Bertha | Saint and King Æthelberht Of Kent | DECEASED | ||||
28 | Queen Bertha De Swabia | King Rudolf, II | 907 | Bourgogne, France ![]() |
967 | ||
29 | Queen Bertha De Swabia | King Hugh De Provence | 907 | Bourgogne, France ![]() |
967 | ||
30 | ![]() |
King Pépin De France, III dit le Bref | Abt 720 | Laon, Aisne, Picardie, France ![]() |
21 Jul 783 | Choisy-au-Bac, Oise, Picardie, France ![]() |
|
31 | Queen Berthe De Hollande | King Philippe De France, I | 1054 | 30 Jul 1093 | Montreuil, Pas-de-Calais, Nord-Pas-de-Calais, France ![]() |
||
32 | ![]() |
King Pépin Carloman De Herstal, I | 776 | Toulouse, Haute-Garonne, Midi-Pyrénées, France ![]() |
871 | ||
33 | ![]() |
King Clotaire De France, II | 582 | 618 | |||
34 | Queen Bilichilde De Metz | 675 | |||||
35 | ![]() |
Queen Richilde D'Arles | Abt 822 | 877 | |||
36 | ![]() |
Ermengarde D'Italie | Abt 842 | Metz, Moselle, Lorraine, France ![]() |
23 Feb 887 | Vienne, Isère, Rhône-Alpes, France ![]() |
|
37 | King Carloman De France, II | Queen Gerberga | 28 Jun 751 | 4 Dec 771 | |||
38 | King Charibert, I | Queen Ingoberga | Abt 517 | Dec 567 | |||
39 | ![]() |
Queen Désirée De Lombardie | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
40 | ![]() |
Queen Consort Himiltrude D'Alémanie | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
41 | ![]() |
Queen Hildegard Von Vinzgau De Bavière | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
42 | ![]() |
Gersuinda | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
43 | ![]() |
Queen Consort Luitgard | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
44 | ![]() |
Régina | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
45 | ![]() |
Ethelind | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
46 | ![]() |
Queen Fastrada De Franconie | 2 Apr 748 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
28 Jan 814 | Aachen, Aachen, Nordrhein-Westfalen, Germany ![]() |
|
47 | King Charles De France, III dit le Simple | Queen Frederune Von Rheingelheim | 29 Sep 879 | Péronne, Somme, Picardie, France ![]() |
DECEASED | Monastere de Saint-Fursy, Péronne, Somme, Picardie, France ![]() |
|
48 | King Charles De Herstal, dit le Jeune | Abt 772 | 4 Dec 811 | ||||
49 | King Charles De Provence | 845 | 863 | ||||
50 | King Charles Constantin De Provence | Queen Theutbarge De Sens | 902 | Arles, Bouches-du-Rhône, Provence-Alpes-Côte d'Azur, France ![]() |
963 | ||
51 | ![]() |
Queen Ermentrude D'Orléans | 13 Jun 823 | Frankfurt am Main, Hessen, Germany ![]() |
6 Oct 877 | Avrieux, Savoie, Rhône-Alpes, France ![]() |
|
52 | ![]() |
Queen Richilde De Metz | 13 Jun 823 | Frankfurt am Main, Hessen, Germany ![]() |
6 Oct 877 | Avrieux, Savoie, Rhône-Alpes, France ![]() |
|
53 | King Childebert, I | Abt 496 | Reims, Marne, Champagne-Ardenne, France ![]() |
13 Dec 558 | Vézeronce, Isère, Rhône-Alpes, France ![]() |
||
54 | King Childeric, I | Queen Basina De Thuringia | Abt 437 | 481 | Tournai, Hainaut, Belgium ![]() |
||
55 | King Childeric De France, II | 675 | |||||
56 | King Chilperic De Bourgogne, II | Caretene | Abt 450 | 493 | |||
57 | King Chlodio | Living | Abt 390 | Abt 450 | |||
58 | King Chlothar, I | Queen Ingund | Abt 497 | 29 Nov 561 | Compiègne, Oise, Picardie, France ![]() |
||
59 | Queen Chrotais | King Pépin Carloman De Herstal, I | DECEASED | ||||
60 | ![]() |
Queen Adeltrude De Soissons | 584 | 18 Oct 629 | Paris, Paris, Île-de-France, France ![]() |
||
61 | ![]() |
Queen Bertrude Des Francs | 584 | 18 Oct 629 | Paris, Paris, Île-de-France, France ![]() |
||
62 | Roi (King) Clothar De France, III | 673 | |||||
63 | Queen Clotilda De Herstal | King Theuderic De Neustrie, III | 650 | 699 | |||
64 | ![]() |
Saint and King Clovis, I | Abt 474 | Lyon, Rhône, Rhône-Alpes, France ![]() |
3 Jun 548 | Basilique de Saint-Martin, Tours, Indre-et-Loire, Centre, France ![]() |
|
65 | ![]() |
Evochildis De Cologne | Abt 466 | 27 Nov 511 | |||
66 | ![]() |
Saint and Queen Clotilde | Abt 466 | 27 Nov 511 | |||
67 | ![]() |
Saint and Queen Balthild | 635 | 1 Jan 657 | |||
68 | King Conrad, dit le Pacifique | Queen Adélaïde De Provence | 928 | 993 | |||
69 | Queen Constance D'Arles | King Robert De France, II dit le Pieux (the Pious) or le Sage (the Wise) | 986 | 25 Jul 1032 | France ![]() |
||
70 | ![]() |
King Bernard de Carolingian D'Italie | 795 | DECEASED | |||
71 | King Dagobert D'Austrasie, II | Queen Mechthilde De Kent D'Angleterre | 652 | 1 Jan 680 | Foret de Woëvre, Meuse, Lorraine, France ![]() |
||
72 | King Dagobert D'Austrasie, II | Gisèle De Razes | 652 | 1 Jan 680 | Foret de Woëvre, Meuse, Lorraine, France ![]() |
||
73 | ![]() |
Queen Nanthilde De France | 602 | 19 Jan 639 | Saint-Denis, Seine-Saint-Denis, Île-de-France, France ![]() |
||
74 | ![]() |
Queen Ragnetrude D'Ardennes | 602 | 19 Jan 639 | Saint-Denis, Seine-Saint-Denis, Île-de-France, France ![]() |
||
75 | ![]() |
Queen Izdunda De Gilan D'Iran | 602 | 19 Jan 639 | Saint-Denis, Seine-Saint-Denis, Île-de-France, France ![]() |
||
76 | King Desiderius | Queen Ansa | 786 | ||||
77 | Queen Désirée De Lombardie | Emperor Charlemagne De Herstal | DECEASED | ||||
78 | ![]() |
Queen Ansa De Brescia | 710 | 778 | |||
79 | King Egbert Of England | Queen Redburge De Toulouse | Between 770 and 775 | 12 Feb 839 | |||
80 | Queen Eleanor d'Aquitaine | King Louis De France, VII | 1123 | 1 Apr 1204 | |||
81 | Queen Emma De Baviere | King Louis De Germainie, II dit le Germanique | 809 | 876 | |||
82 | ![]() |
Emperor Louis D'Italie, II | 837 | Abt 900 | |||
83 | ![]() |
Emperor Louis, I dit le Pieux | Between 778 and 780 | Jupille-sur-Meuse, Liege, Belgium ![]() |
3 Oct 818 | Angers, Maine-et-Loire, Pays de la Loire, France ![]() |
|
84 | Empress Ermengarde De Tours | Emperor Lothaire De Germainie, I | 804 | 851 | |||
85 | ![]() |
King Ranulf De Poitiers, II | Abt 857 | Poitiers, Vienne, Poitou-Charentes, France ![]() |
935 | Poitiers, Vienne, Poitou-Charentes, France ![]() |
|
86 | Queen Ermentrude D'Orléans | Emperor Charles De France II dit le Chauve (the Bald) | 27 Sep 830 | Orléans, Loiret, Centre, France ![]() |
6 Oct 869 | ||
87 | Queen Estrid Of the Obotrites | King Olof Skötkonung "Olaf the Swede" | 979 | 1035 | |||
88 | King Eudes D'Aquitaine De Gascogne, dit le Grand | Queen Adèle D'Austrasie | Abt 660 | 735 | |||
89 | Queen Fastrada De Franconie | Emperor Charlemagne De Herstal | Abt 765 | 10 Aug 794 | Frankfurt am Main, Hessen, Germany ![]() |
||
90 | Queen Frederune Von Rheingelheim | King Charles De France, III dit le Simple | 885 | 25 Feb 921 | |||
91 | King Fruela Perez Des Asturies, I | Queen Munia Lopez De Gascogne | 772 | 778 | |||
92 | King Garcia Sanchez De Navarre, II | Queen Thérésa De Leon | 919 | 970 | |||
93 | King Garcia Sanchez De Navarre, II | Queen Andregote Galindez D'Aragon | 919 | 970 | |||
94 | Queen Gerberga | King Carloman De France, II | DECEASED | ||||
95 | Queen Gerberge De Chalon | King Adalbert D'Italie, I dit le Captif | Abt 940 | Mâcon, Saône-et-Loire, Bourgogne, France ![]() |
11 Dec 991 | Château de Pouilly, Pouilly-sur-Saône, Côte-d'Or, Bourgogne, France ![]() |
|
96 | Queen Gerberge De Saxe | Duc Giselbert De Lorraine, II | 18 Sep 914 | Nordhausen, Thüringen, Germany ![]() |
10 May 984 | Reims, Marne, Champagne-Ardenne, France ![]() |
|
97 | Queen Gerberge De Saxe | King Louis De France D'Outremer, IV | 18 Sep 914 | Nordhausen, Thüringen, Germany ![]() |
10 May 984 | Reims, Marne, Champagne-Ardenne, France ![]() |
|
98 | King Godegisel | Queen Teudelinda | 501 | Vienne, Isère, Rhône-Alpes, France ![]() |
|||
99 | King Godomar | DECEASED | |||||
100 | King Gondioc | Living | Abt 420 | Abt 473 |
1 2 Next»