ID:18748Full name:OFFORD Frederic Arthur
Forename:Frederic ArthurSurname:OFFORD
Age:44DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Master baker
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2099Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- MariaSpouse Father:- -
Home parish:Diss, NorfolkAddress:Victoria Road, Diss
Notes:Married 4 years, no children; 6 rooms in dwelling
TempN1:926TempN2:1000
TempT1:-TempT2:Baking
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-2518TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 18748


Complete household [2099] ( Victoria Road, Diss )
IDNameNo.RoleAgeOccupation
18748OFFORD Frederic Arthur1Head44Master baker
18749OFFORD Maria2Wife47Assisting in bakery business
18750OFFORD Arthur3Son23Hawker, fish etc
18751OFFORD Harolk4Son16Assisting in bakery business
18752BRIGHTON Florence Emily5Daughter22Assisting in bakery business
18753BRIGHTON James6Son17Miller
18754BRIGHTON William7Son13Scholar
18755BRIGHTON Arthur8Son7Scholar
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2099) ORDER BY Temp2

Notes: