ID:17170Full name:DIXON George
Forename:GeorgeSurname:DIXON
Age:55DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Bricklayer
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):239Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- KateSpouse Father:- -
Home parish:Burston, NorfolkAddress:Denmark Street, Diss
Notes:Married 28 years, 11 children, all still living; 6 rooms in dwelling
TempN1:220TempN2:1000
TempT1:-TempT2:Bricklaying
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0940TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17170


Complete household [239] ( Denmark Street, Diss )
IDNameNo.RoleAgeOccupation
17170DIXON George1Head55Bricklayer
17171DIXON Kate2Wife50-
17172DIXON George3Son18Bricklayers labourer
17173DIXON Spencer4Son16Matting assistant
17174DIXON Mabel5Daughter14-
17175DIXON Arnold6Son12Scholar
17176DIXON Dorothy7Daughter10Scholar
17177DIXON Ethel8Daughter7Scholar
17178DIXON Reginald9Grandson1-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 239) ORDER BY Temp2

Notes: