ID:17538Full name:LUSH Alfred
Forename:AlfredSurname:LUSH
Age:57DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Draper
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):1044Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- EdnaSpouse Father:- -
Home parish:Andover, HampshireAddress:St. Nicholas Street, Diss
Notes:Married 27 years, 6 children, all still living; 5 rooms in dwelling
TempN1:260TempN2:1000
TempT1:-TempT2:Draper
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-1308TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17538


Complete household [1044] ( St. Nicholas Street, Diss )
IDNameNo.RoleAgeOccupation
17538LUSH Alfred1Head57Draper
17539LUSH Edna2Wife53Draper
17540LUSH Vera Hilda3Daughter15Scholar
17541LUSH Frank Victor4Son14Scholar
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 1044) ORDER BY Temp2

Notes: