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

1 2 3 4 5 ... Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
1 King Edward II of England  25 Jan 1308  Boulogne, Hauts-de-Seine, Île-de-France, France  
2 King Edward III of England  24 Jan 1328  York, Yorkshire, England  
3 Philippa, Queen consort of England  24 Jan 1328  York, Yorkshire, England  
4 Queen Isabelle of England  25 Jan 1308  Boulogne, Hauts-de-Seine, Île-de-France, France  
5 +, Anna, Queen consort of France  29 Jan 1050  Reims, Marne, Champagne-Ardenne, France  
6 +, King Henri I de France  29 Jan 1050  Reims, Marne, Champagne-Ardenne, France  
7 Adams, Amy Lavina  16 Jan 1883   
8 Adams, Eliza Lavonia  28 Jan 1876  Hart, Georgia, USA  
9 Adams, Joanna Elinor  4 Jan 1654   
10 Adams, Robert Ephraim  1 Jan 1900  Winnipeg, Manitoba, Canada  
11 Adams +, Henry Proctor  24 Jan 1844   
12 Alway, Austin A.  15 Jan 1879  Henrietta, Jackson, Michigan, USA  
13 Anderson, Charles Peter  12 Jan 1907  Cooperstown, Griggs, North Dakota, USA  
14 Anderson +, Rachel  6 Jan 1774  Darlington, South Carolina, USA  
15 Appling, John  4 Jan 1821  Wilkes, Georgia, USA  
16 Bagwell +, Matilda  17 Jan 1819  Franklin, Georgia, USA  
17 Barber, Samuel  25 Jan 1676/77  Windsor, Hartford, Connecticut, USA  
18 Barrett, Alice  13 Jan 1882  Wilkes, Georgia, USA  
19 Bartlett + ??, Mary  Bet. 1 Jan 1703-4 Feb 1703  Hanover, Virginia, USA  
20 Baskin, Mary Ann  5 Jan 1882  Ardara, Donegal, Ireland  
21 Bateson, Jane  17 Jan 1870  Northumberland, Ontario, Canada  
22 Beauchamp +, Isabel  Bef. 27 Jan 1287   
23 Beech, Martha  24 Jan 1674  Watertown, Middlesex, Massachusetts, USA  
24 Bennett, Tabitha  22 Jan 1752  Holden, Worcester, Massachusetts, USA  
25 Bogle, James  24 Jan 1815  Inver, Donegal, Ireland  
26 Bowler, John Albert  17 Jan 1916  Grey, Ontario, Canada  
27 Bowles, Harriet  2 Jan 1822  Bourbon, Kentucky, USA  
28 Bray, Sallie  29 Jan 1902  Fulton, Georgia, USA  
29 Brent, William  7 Jan 1723/1724   
30 Bridges, Russell J.  9 Jan 1842  Madison, Georgia, USA  
31 Brown, Jacob  9 Jan 1757   
32 Brown, Jesse  17 Jan 1811  Elbert, Georgia, USA  
33 Bryant +, Edith  4 Jan 1832  Madison, Georgia, USA  
34 Bullard + p??, Martha  20 Jan 1822  Flint, Upson, Georgia, USA  
35 Burgess, Hannah  31 Jan 1771  Harvard, Worcester, Massachusetts, USA  
36 Burton, John Newton II  25 Jan 1947  Atlanta, De Kalb, Georgia, USA  
37 Butler +, George Edward I  Abt. Jan 1874  Decatur, Georgia, USA  
38 Butler +, Jacob Charles  22 Jan 1835  Wilmington, New Hanover, North Carolina, USA  
39 Butterfield +, Nathaniel II  18 Jan 1697  Chelmsford, Middlesex, Massachusetts, USA  
40 Callaway, Doctor Brantly Mercer  11 Jan 1859  Washington, Wilkes, Georgia, USA  
41 Callaway, Mary Bethany  18 Jan 1844  Wilkes, Georgia, USA  
42 Carman ??, John  20 Jan 1682  Long Island City, Queens, New York, USA  
43 Carrington, Mary E.  15 Jan 1885  Clarke, Georgia, USA  
44 Cassidy, Margaret  5 Jan 1854  Inver, Donegal, Ireland  
45 Causine ??, Mary  2 Jan 1651/52  St Mary's, Maryland, USA  
46 Ceasar, John II  1 Jan 1868  Grey, Ontario, Canada  
47 Chambers, Thomas Jones  Aft. 5 Jan 1797  Person, North Carolina, USA  
48 Chandler +, Dudley Jones  20 Jan 1831  Franklin, Georgia, USA  
49 Chandler +, Sterling  4 Jan 1832  Madison, Georgia, USA  
50 Chapman, Benjamin  12 Jan 1809  Georgia, USA  


1 2 3 4 5 ... Next»