Tas Valley Data - Individual Record

ID:	18654	Full name:	Sister Saint Alenandre
Forename:	Sister Saint Alenandre	Surname:	-
Age:	36	DoB:	-
Gender:	F	Disability:	-
Marital status:	Single	Occupation:	-
Parish:	Diss	Parish code:	DISS
Event:	Census	Event date:	02.04.1911
Household (in Census):	2078	Order (in Household):	9
Other dates:	-	Role:	Inmate
Signature:	-	Consent:	-
Father:	- -	Occupation:	-
Mother:	-	Maiden name:	-
Spouse:	- -	Spouse Father:	- -
Home parish:	France	Address:	Ursuline Convent School, Vistoria Road, Diss
Notes:	-
TempN1:	441	TempN2:	425
TempT1:	-	TempT2:	-----
TempT3:	-	TempT4:	ALL/DISS
Ref:	DISS-1911-Cen-2424	TempRef:	[100085]
SQL: SELECT * FROM Complete WHERE ID = 18654

Complete household [2078] ( Ursuline Convent School, Vistoria Road, Diss )
ID	Name	No.	Role	Age	Occupation
18646	BOMPAS George	1	-	34	Chaplain to the Ursulines
18647	Sister Maria Theophila	2	Head	50	Teacher
18648	Sister M de L Assumption	3	Inmate	68	-
18649	Sister M de L Incarnation	4	Inmate	58	-
18650	Sister Marie Agnes	5	Inmate	51	-
18651	Sister St, J Berchmans	6	Inmate	57	-
18652	Sister Maria Samuel	7	Inmate	46	-
18653	Sister Marguerite Marie	8	Inmate	38	-
18654	Sister Saint Alenandre	9	Inmate	36	-
18655	Sister Daint Henri	10	Inmate	35	-
18656	Sister Germaine	11	Inmate	71	-
18657	Sister Marie-Anne	12	Inmate	38	-
18658	Sister Monique	13	Inmate	42	-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2078) ORDER BY Temp2