ID:16696Full name:SOUTER John
Forename:JohnSurname:SOUTER
Age:60DoB:-
Gender:MDisability:Feeble minded from birth
Marital status:MarriedOccupation:Publican (Sun Inn)
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):124Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- JaneSpouse Father:- -
Home parish:Mendham, SuffolkAddress:The Sun Inn, Mere Street, Diss
Notes:Married 24 years, 3 children, 2 still living; 11 rooms in dwelling
TempN1:943TempN2:1000
TempT1:-TempT2:Inn
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0466TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 16696


Complete household [124] ( The Sun Inn, Mere Street, Diss )
IDNameNo.RoleAgeOccupation
16696SOUTER John1Head60Publican (Sun Inn)
16697SOUTER Jane2Wife62-
16698SOUTER John3Son33Working in pub
16699SOUTER Edith4Daughter31Working in pub
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 124) ORDER BY Temp2

Notes: