ID:17648Full name:BRIGHTON William
Forename:WilliamSurname:BRIGHTON
Age:61DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Town Hall Keeper, army pensioner
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):1071Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- ElizaSpouse Father:- -
Home parish:Diss, NorfolkAddress:Lawn Cottage, Mount Street, Diss
Notes:Married 28 years, 4 children, all still living; 4 rooms in dwelling
TempN1:409TempN2:1000
TempT1:-TempT2:-
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-1418TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17648


Complete household [1071] ( Lawn Cottage, Mount Street, Diss )
IDNameNo.RoleAgeOccupation
17648BRIGHTON William1Head61Town Hall Keeper, army pensioner
17649BRIGHTON Eliza2Wife55-
17650BRIGHTON Jesse Frances3Son18Clerk at brush factory
17651BRIGHTON Maude Elizabeth4Daughter13Scholar
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 1071) ORDER BY Temp2

Notes: