ID:16237Full name:BLOOMFIELD Elizabeth
Forename:ElizabethSurname:BLOOMFIELD
Age:58DoB:-
Gender:FDisability:-
Marital status:MarriedOccupation:-
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2Order (in Household):2
Other dates:-Role:Wife
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- WilliamSpouse Father:- -
Home parish:Palgrave, SuffolkAddress:Victoria Road, Diss
Notes:Married 35 years, 9 children, all still living
TempN1:1000TempN2:1000
TempT1:-TempT2:-----
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0007TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 16237


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: