ID:19307Full name:KNIGHTS Frederick George
Forename:Frederick GeorgeSurname:KNIGHTS
Age:34DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Boot repairer
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2230Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- DoraSpouse Father:- -
Home parish:Diss, NorfolkAddress:Chapel Street, Diss
Notes:Married 12 years, 6 children, all still living; 4 rooms in dwelling
TempN1:300TempN2:1000
TempT1:-TempT2:Shoemaker
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-3077TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 19307


Complete household [2230] ( Chapel Street, Diss )
IDNameNo.RoleAgeOccupation
19307KNIGHTS Frederick George1Head34Boot repairer
19308KNIGHTS Dora2Wife29-
19309KNIGHTS Isabella3Daughter11Scholar
19310KNIGHTS Lily4Daughter8-
19311KNIGHTS Elsie5Daughter7-
19312KNIGHTS Ruby6Daughter4-
19313KNIGHTS Frederick7Son3-
19314KNIGHTS Alfred James8Son1 mo-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2230) ORDER BY Temp2

Notes: