ID:17135Full name:SORE Charles
Forename:CharlesSurname:SORE
Age:42DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Mat maker
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):232Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- AlbenaerSpouse Father:- -
Home parish:Melford, SuffolkAddress:Denmark Street, Diss
Notes:Married 17 years, 5 children, all still living; 4 rooms in dwelling
TempN1:866TempN2:1000
TempT1:-TempT2:Brush and mat factory
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0905TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17135


Complete household [232] ( Denmark Street, Diss )
IDNameNo.RoleAgeOccupation
17135SORE Charles1Head42Mat maker
17136SORE Albenaer2Wife39-
17137SORE Mabel3Daughter14Factory hand in mat factory
17138SORE Percy4Son11Scholar
17139SORE Gwendoline5Daughter8-
17140SORE Laura6Daughter5-
17141SORE Lily7Daughter2-
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 232) ORDER BY Temp2

Notes: