Banns - data sheet

Records found = 12 from 80563
ID	Name	Gender	Role	Status	Date	Other Dates	Spouse	Notes
4475	MEARS Amelia	F	B	S	23.09.1883	30.09.1883 + 07.10.1883	HEROD Henry	Marriage: 25.10.1883
4561	MEARS Ellen	F	B	S	21.10.1900	28.10.1900 + 04.11.1900	REYNOLDS Albert George	-
4506	MEARS Frederick	M	G	S	08.12.1889	15.12.1889 + 22.12.1889	JAMES Rebecca	Marriage: 25.12.1889
4502	MEARS George	M	G	S	20.10.1889	27.10.1889 + 03.11.1889	WOODS Eleanor	Marriage: 12.11.1889
4519	MEARS Harriett	F	B	S	01.10.1893	08.10.1893 + 15.10.1893	SKOYLES William Thomas	Marriage date: 19.10.1893
4338	MEARS James	M	G	S	03.10.1858	10.10.1858 + 17.10.1858	HUNT Susannah	-
4350	MEARS James	M	G	S	30.09.1860	07.10.1860 + 14.10.1860	HUNT Susanna	Marriage: 28.10.1860
4412	MEARS James	M	G	W	19.03.1871	26.03.1871 + 02.04.1871	FRANCIS Sarah	Marriage: 16.04.1871
4462	MEARS James	M	G	W	22.10.1882	29.01.1882 + 05.02.1882	FEEK Elizabeth	Marriage: 12.02.1882
4356	MEARS John	M	G	S	20.10.1861	27.01.1861 + 03.02.1861	LUDKIN Eliza	-
4385	MEARS Mary	F	B	S	29.07.1866	05.08.1866 + 12.08.1866	BUCK John Pettifer	Marriage: 17.10.1866
4306	MEARS Robert	M	G	S	17.10.1852	24.10.1852 + 31.10.1852	VINCE Eliza Amelia	Marriage: 14.11.1852
SQL: " SELECT * FROM Complete WHERE ParishCode='THAR' AND EventType = 'Banns' AND Surname = 'MEARS' ORDER BY FullName, EventYear, EventMonth, EventDay"