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 151 to 200 of 229  » Comma-delimited CSV file

«Prev 1 2 3 4 5 Next»

# Last Name, Given Name(s) Marriage Date Marriage Place
151 Porter, James Clifton  19 Aug 1962  Gackle, Logan, North Dakota, USA  
152 Power, Reverend James Mankin  6 Aug 1829  Madison, Georgia, USA  
153 Pratt, Elizabeth  18 Aug 1623  Walsgrave on Sowe, Warwickshire, England  
154 Preston, John A.  10 Aug 1915  Orleans, New York, USA  
155 Ray +, Thomas Marcus II  22 Aug 1854  Lowndes, Georgia, USA  
156 Redout + ??, Mary  31 Aug 1658  Milton Abbas, Dorset, England  
157 Reid, Rosa Talbot  23 Aug 1917  Putnam, Georgia, USA  
158 Rice, Elijah  12 Aug 1762   
159 Richings, Lillian  21 Aug 1917  York, Ontario, Canada  
160 Robbins, Betsey  4 Aug 1799  Harvard, Worcester, Massachusetts, USA  
161 Roberson, Susanah  19 Aug 1782  Granville, North Carolina, USA  
162 Ruff + ??, George Hendrick  29 Aug 1758  South Carolina, USA  
163 Saunders + p??, Winifred  17 Aug 1809  Elbert, Georgia, USA  
164 Sawtell +, Elizabeth  25 Aug 1691  Stow, Middlesex, Massachusetts, USA  
165 Schnacky, Caroline B.  2 Aug 1934  Wisconsin, USA  
166 Schoepplin + ??, Anna  29 Aug 1758  South Carolina, USA  
167 Scovel, Alfred  24 Aug 1893  Petoskey, Emmet, Michigan, USA  
168 Seay, John Hartwell  5 Aug 1790   
169 Seay, Sarah  5 Aug 1790  Virginia, USA  
170 Sharpe, Halvor  29 Aug   
171 Sharpe, ^ Sergeant William  Aft. Aug 1620  Virginia, USA  
172 Shipp, Emma Grant  28 Aug 1807  Woodford, Kentucky, USA  
173 Sirmons, John Chester  20 Aug 1912  Berrien, Georgia, USA  
174 Spratlin, Effie Sarah  26 Aug 1900  Clarke, Georgia, USA  
175 Spratlin, Mary Ann  12 Aug 1841  Marion, Georgia, USA  
176 Spratlin, Mary Brown  30 Aug 1839  Wilkes, Georgia, USA  
177 Spratling, James II  Aft. 26 Aug 1828   
178 Spratling, Mary  28 Aug 1796  Hogansville, Troup, Georgia, USA  
179 Spratling, Randolph D.  11 Aug 1872  Coweta, Georgia, USA  
180 Stanley + |, Thomas  3 Aug 1630  Ashford, Kent, England  
181 Staples +, Tabitha  15 Aug 1811  Elbert, Georgia, USA  
182 Stephens +, Arminda  27 Aug 1840  Madison, Georgia, USA  
183 Stephens + p??, ^ Private Haley  4 Aug 1812  Oglethorpe, Georgia, USA  
184 Strain, Louisa E.  22 Aug 1837  Marion, Indiana, USA  
185 Strain, Thomas Boston  13 Aug 1846  Montgomery, Indiana, USA  
186 Taliaferro, Lawrence  Bef. 31 Aug 1706   
187 Tarleton, Judith  "John Woodson … married Judith Tarleton, daughter    
188 Taylor, Oliver II  12 Aug 1800  Boxborough, Middlesex, Massachusetts, USA  
189 Thornton, Sarah Alice  Bef. 31 Aug 1706   
190 Touslee, Marilyn Elizabeth  3 Aug 1952  Colby, Thomas, Kansas, USA  
191 Treherne + ??, Mary  17 Aug 1584  Frome, Somerset, England  
192 Tretson, Wayne Irwin  26 Aug 1944  Fort Snelling, Hennepin, Minnesota, USA  
193 Tritton + |, Benet  3 Aug 1630  Ashford, Kent, England  
194 Truman, Anderson Shipp  13 Aug 1846  Shelby, Kentucky, USA  
195 Truman, William  28 Aug 1807  Woodford, Kentucky, USA  
196 Turner, Grace  10 Aug 1915  Orleans, New York, USA  
197 Tutt, Frances Ann  13 Aug 1835  Richmond, Georgia, USA  
198 Tyre, Hazel Muriel  29 Aug 1923  Lakefield, Jackson, Minnesota, USA  
199 Van Nice, Elmer  11 Aug 1923  Tramping Lake, Saskatchewan, Canada  
200 Vatne |, Georgianna  29 Aug   


«Prev 1 2 3 4 5 Next»