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 "%AUG%" )) 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 223  » Comma-delimited CSV file

1 2 3 4 5 Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
1 +, Constance, Queen consort of France  25 Aug 1003   
2 +, Isabelle, Queen consort of England  24 Aug 1200  Bordeaux, Gironde, Aquitaine, France  
3 +, King John of England  24 Aug 1200  Bordeaux, Gironde, Aquitaine, France  
4 +, King Robert II de France  25 Aug 1003   
5 Adams, George Washington  23 Aug 1852  Peel, Wellington, Ontario, Canada  
6 Adams, John Quincy  3 Aug 1892   
7 Adams, Robert  Aug 1695   
8 Adams, Roger William  19 Aug 1934   
9 Adams +, Reverend Ezra  8 Aug 1833  Grimsby, Niagara, Ontario, Canada  
10 Armstrong, Roy Hudson  9 Aug 1947  Saskatoon, Saskatchewan, Canada  
11 Atkinson +, Thomas  5 Aug 1719   
12 Balcom +, Henry  12 Aug 1666  Charlestown, Suffolk, Massachusetts, USA  
13 Ball, Henry Durrell  31 Aug 1910  Chautauqua, New York, USA  
14 Benjamin, Hartwell  24 Aug 1910  Muskegon, Muskegon, Michigan, USA  
15 Bevys +, Alice  30 Aug 1595  Exeter, Devon, England  
16 Bird, Homer Bartow  6 Aug 1911  Camak, Warren, Georgia, USA  
17 Boots, Anna Elda  13 Aug 1846  Montgomery, Indiana, USA  
18 Box, Lenzena  24 Aug 1893  Petoskey, Emmet, Michigan, USA  
19 Boyum, Hazel Alvera  21 Aug 1931  Ottertail, Otter Tail, Minnesota, USA  
20 Boyum, Hazel Alvera  1 Aug 1982  Charlotte, Florida, USA  
21 Brandon, Emily Elizabeth  10 Aug 1862  Berrien, Georgia, USA  
22 Bray, Benjamin Asbury  10 Aug 1879  Clarke, Georgia, USA  
23 Bray +, ^ Private Benjamin  27 Aug 1840  Madison, Georgia, USA  
24 Brent, William  9 Aug 1734   
25 Brewer +, Catherine  4 Aug 1812  Oglethorpe, Georgia, USA  
26 Bridges, Nathaniel C.  6 Aug 1850  Oglethorpe, Georgia, USA  
27 Brooks, Frank D.  20 Aug 1923  Washington, Wilkes, Georgia, USA  
28 Brown, Timothy  30 Aug 1750  Stow, Middlesex, Massachusetts, USA  
29 Browning, Sarah  22 Aug 1837  Clarke, Georgia, USA  
30 Burt, Salley  Bef. Aug 1788   
31 Burton +, Judith  "He married Judith Burton, daughter of Robert and    
32 Bush, Senator Preston Sheldon  6 Aug 1921  Kennebunkport, York, Maine, USA  
33 Carter, Charles T.  19 Aug 1782  Granville, North Carolina, USA  
34 Catherwood, Beatrice  11 Aug 1923  Tramping Lake, Saskatchewan, Canada  
35 Chapman, Amazon Elizabeth  20 Aug 1923  Washington, Wilkes, Georgia, USA  
36 Chapman, Luna C.  6 Aug 1911  Camak, Warren, Georgia, USA  
37 Chapman, Robert Augustus I  24 Aug 1893  Sparta, Hancock, Georgia, USA  
38 Chapman + ??, William Gulielmus  17 Aug 1584  Frome, Somerset, England  
39 Clement +, Elizabeth  1 Aug 1734   
40 Cluet + ??, William  31 Aug 1658  Milton Abbas, Dorset, England  
41 Colbert, Martha W.  Aft. 26 Aug 1828   
42 Coolidge, Elizabeth  21 Aug 1740  Watertown, Middlesex, Massachusetts, USA  
43 Corneliusdatter Vatne, Karen  5 Aug 1854  Stavanger, Rogaland, Norway  
44 Crow, Martin Towne II  22 Aug 1837  Clarke, Georgia, USA  
45 Davidson, Agnes  19 Aug 1793  Acton, Middlesex, Massachusetts, USA  
46 Davis, Mabel Irene  13 Aug 1932   
47 de Burghersh +, Dame Elizabeth  Bef. 2 Aug 1354   
48 Drake, Herbert Marcus  22 Aug 1925  Lakota, Nelson, North Dakota, USA  
49 Dudley + |, William  24 Aug 1636  Ockley, Surrey, England  
50 Duncan, Mary  17 Aug 1757  Petersham, Worcester, Massachusetts, USA  


1 2 3 4 5 Next»