ID:18575Full name:LESTER Albert
Forename:AlbertSurname:LESTER
Age:40DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:General labourer in iron foundry
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2063Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- KateSpouse Father:- -
Home parish:Wortham, SuffolkAddress:Gas Works Lane, Victoria Road, Diss
Notes:Married 5 years, 2 children, all still living; 4 rooms in dwelling
TempN1:181TempN2:1000
TempT1:-TempT2:Foundry
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-2345TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 18575


Complete household [2063] ( Gas Works Lane, Victoria Road, Diss )
IDNameNo.RoleAgeOccupation
18575LESTER Albert1Head40General labourer in iron foundry
18576LESTER Kate2Wife31-
18577LESTER Henry3Son5-
18578LESTER Stanley Albert4Son4 mos-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2063) ORDER BY Temp2

Notes: