Report: Marriages This Month
Description: Their anniversary is this month. [NOTE: Marriage Dates containing Abt., Bef., Bet., or Aft. may not have occurred this month.]
SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,sex,if(sex='M',families1.marrdate,families2.marrdate),if(sex='M',families1.marrplace,families2.marrplace), 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 ) WHERE ((( if(sex='M',families1.marrdate,families2.marrdate) LIKE "%JAN%" ) ) AND ((tng_people.living !=1 && tng_people.private != 1))) AND tng_people.gedcom = "OurFamilyTree" ORDER BY lastname,firstname,if(sex='M',families1.marrdatetr,families2.marrdatetr)
Matches 1 to 50 of 360 » Comma-delimited CSV file
| # | Last Name, Given Name(s) | Marriage Date | Marriage Place | |
| 1 | King Edward II of England | M | 25 Jan 1308 | Boulogne, Hauts-de-Seine, Île-de-France, France  |
| 2 | King Edward III of England | M | 24 Jan 1328 | York, Yorkshire, England |
| 3 | Philippa, Queen consort of England | F | 24 Jan 1328 | York, Yorkshire, England |
| 4 | Queen Isabelle of England | F | 25 Jan 1308 | Boulogne, Hauts-de-Seine, Île-de-France, France |
| 5 | +, Anna, Queen consort of France | F | 29 Jan 1050 | Reims, Marne, Champagne-Ardenne, France |
| 6 | +, King Henri I de France | M | 29 Jan 1050 | Reims, Marne, Champagne-Ardenne, France |
| 7 | Adams, Amy Lavina | F | 16 Jan 1883 | |
| 8 | Adams, Eliza Lavonia | F | 28 Jan 1876 | Hart, Georgia, USA |
| 9 | Adams, Joanna Elinor | F | 4 Jan 1654 | |
| 10 | Adams, Robert Ephraim | M | 1 Jan 1900 | Winnipeg, Manitoba, Canada |
| 11 | Adams +, Henry Proctor | M | 24 Jan 1844 | |
| 12 | Alway, Austin A. | M | 15 Jan 1879 | Henrietta, Jackson, Michigan, USA |
| 13 | Anderson, Charles Peter | M | 12 Jan 1907 | Cooperstown, Griggs, North Dakota, USA |
| 14 | Anderson +, Rachel | F | 6 Jan 1774 | Darlington, South Carolina, USA |
| 15 | Appling, John | M | 4 Jan 1821 | Wilkes, Georgia, USA |
| 16 | Bagwell +, Matilda | F | 17 Jan 1819 | Franklin, Georgia, USA |
| 17 | Barber, Samuel | M | 25 Jan 1676/77 | Windsor, Hartford, Connecticut, USA |
| 18 | Barrett, Alice | F | 13 Jan 1882 | Wilkes, Georgia, USA |
| 19 | Bartlett + ??, Mary | F | Bet. 1 Jan 1703-4 Feb 1703 | Hanover, Virginia, USA |
| 20 | Baskin, Mary Ann | F | 5 Jan 1882 | Ardara, Donegal, Ireland |
| 21 | Bateson, Jane | F | 17 Jan 1870 | Northumberland, Ontario, Canada |
| 22 | Beauchamp +, Isabel | F | Bef. 27 Jan 1287 | |
| 23 | Beech, Martha | F | 24 Jan 1674 | Watertown, Middlesex, Massachusetts, USA |
| 24 | Bennett, Tabitha | F | 22 Jan 1752 | Holden, Worcester, Massachusetts, USA |
| 25 | Bogle, James | M | 24 Jan 1815 | Inver, Donegal, Ireland |
| 26 | Bowler, John Albert | M | 17 Jan 1916 | Grey, Ontario, Canada |
| 27 | Bowles, Harriet | F | 2 Jan 1822 | Bourbon, Kentucky, USA |
| 28 | Bray, Sallie | F | 29 Jan 1902 | Fulton, Georgia, USA |
| 29 | Brent, William | M | 7 Jan 1723/1724 | |
| 30 | Bridges, Russell J. | M | 9 Jan 1842 | Madison, Georgia, USA |
| 31 | Brown, Jacob | M | 9 Jan 1757 | |
| 32 | Brown, Jesse | M | 17 Jan 1811 | Elbert, Georgia, USA |
| 33 | Bryant +, Edith | F | 4 Jan 1832 | Madison, Georgia, USA |
| 34 | Bullard + p??, Martha | F | 20 Jan 1822 | Flint, Upson, Georgia, USA |
| 35 | Burgess, Hannah | F | 31 Jan 1771 | Harvard, Worcester, Massachusetts, USA |
| 36 | Burton, John Newton II | M | 25 Jan 1947 | Atlanta, De Kalb, Georgia, USA |
| 37 | Butler +, George Edward I | M | Abt. Jan 1874 | Decatur, Georgia, USA |
| 38 | Butler +, Jacob Charles | M | 22 Jan 1835 | Wilmington, New Hanover, North Carolina, USA |
| 39 | Butterfield +, Nathaniel II | M | 18 Jan 1697 | Chelmsford, Middlesex, Massachusetts, USA |
| 40 | Callaway, Doctor Brantly Mercer | M | 11 Jan 1859 | Washington, Wilkes, Georgia, USA |
| 41 | Callaway, Mary Bethany | F | 18 Jan 1844 | Wilkes, Georgia, USA |
| 42 | Carman ??, John | M | 20 Jan 1682 | Long Island City, Queens, New York, USA |
| 43 | Carrington, Mary E. | F | 15 Jan 1885 | Clarke, Georgia, USA |
| 44 | Cassidy, Margaret | F | 5 Jan 1854 | Inver, Donegal, Ireland |
| 45 | Causine ??, Mary | F | 2 Jan 1651/52 | St Mary's, Maryland, USA |
| 46 | Ceasar, John II | M | 1 Jan 1868 | Grey, Ontario, Canada |
| 47 | Chambers, Thomas Jones | M | Aft. 5 Jan 1797 | Person, North Carolina, USA |
| 48 | Chandler +, Dudley Jones | M | 20 Jan 1831 | Franklin, Georgia, USA |
| 49 | Chandler +, Sterling | M | 4 Jan 1832 | Madison, Georgia, USA |
| 50 | Chapman, Benjamin | M | 12 Jan 1809 | Georgia, USA |
1 2 3 4 5 ... 8» Next»