Lopham - People info

ID:	37604	Full name:	FOSTER Emily
Forename:	Emily	Surname:	FOSTER
Age:	49	DoB:	-
Gender:	F	Disability:	-
Marital status:	M	Occupation:	-
Parish:	North Lopham	Parish code:	NLOP
Event:	Census	Event date:	02.04.1911
Household (in Census):	103	Order (in Household):	2
Other dates:	-	Role:	Wife
Signature:	-	Consent:	-
Father:	- -	Occupation:	-
Mother:	-	Maiden name:	-
Spouse:	- -	Spouse Father:	- -
Home parish:	Shalford, Essex	Address:	The Street, North Lopham
Notes:	Married 13 years, 3 children, all still living
TempN1:	4	TempN2:	2
TempT1:	-	TempT2:	-
TempT3:	-	TempT4:	ALL/DISS
Ref:	NLOP-1911-Cen-0423	TempRef:	[100094]
SQL: SELECT * FROM Complete WHERE ID = 37604

Complete household [103] ( The Street, North Lopham )
ID	Name	No.	Role	Age	Occupation
37603	FOSTER Joseph Philip	1	Head	48	Builder (own account)
37604	FOSTER Emily	2	Wife	49	-
37605	FOSTER Oliver Victor	3	Son	12	Scholar
37606	FOSTER Elizabeth Hilda May	4	Daughter	11	Scholar
37607	FOSTER Ruby Olive	5	Daughter	4	Scholar
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'NLOP') AND (EventYear = 1911) AND (Temp1 = 103) ORDER BY Temp2

Diss Family History Group