ID:16236Full name:BLOOMFIELD William
Forename:WilliamSurname:BLOOMFIELD
Age:62DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Coal porter
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- ElizabethSpouse Father:- -
Home parish:Scole, NorfolkAddress:Victoria Road, Diss
Notes:Married 35 years, 9 children, all still living; 4 rooms in dwelling
TempN1:557TempN2:598
TempT1:-TempT2:Coal
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0006TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 16236


Complete household [2] ( Victoria Road, Diss )
IDNameNo.RoleAgeOccupation
16236BLOOMFIELD William1Head62Coal porter
16237BLOOMFIELD Elizabeth2Wife58-
16238BLOOMFIELD William3Son23Farm labourer
16239BLOOMFIELD Edith4Daughter21-
16240BLOOMFIELD Nellie5Daughter18Corset maker
16241BLOOMFIELD George6Son15Errand boy (brush maker)
16242BLOOMFIELD Edward7Son10Scholar
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2) ORDER BY Temp2

Notes: