ID:17149Full name:DIXON William
Forename:WilliamSurname:DIXON
Age:27DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:General labourer
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):235Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- CeciliaSpouse Father:- -
Home parish:Arminghall, NorfolkAddress:Denmark Street, Diss
Notes:Married 5 years, 3 children, all still living; 4 rooms in dwelling
TempN1:330TempN2:1000
TempT1:-TempT2:Labourer
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0919TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17149


Complete household [235] ( Denmark Street, Diss )
IDNameNo.RoleAgeOccupation
17149DIXON William1Head27General labourer
17150DIXON Cecilia2Wife28-
17151DIXON Sidney3Son5-
17152DIXON Marjorie4Daughter2-
17153DIXON George5Son6 mos-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 235) ORDER BY Temp2

Notes: