ID:19187Full name:POTTER Edward Arthur
Forename:Edward ArthurSurname:POTTER
Age:45DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Grocery
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):2202Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- Alice ClaraSpouse Father:- -
Home parish:?????Address:Church Street, Diss
Notes:Married 8 years, 3 children, 2 still living; 12 rooms in dwelling
TempN1:320TempN2:1000
TempT1:-TempT2:Grocery
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-2957TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 19187


Complete household [2202] ( Church Street, Diss )
IDNameNo.RoleAgeOccupation
19187POTTER Edward Arthur1Head45Grocery
19188POTTER Alice Clara2Wife37-
19189POTTER Alice3Daughter4-
19190POTTER Edward Taylor4Son2-
19191HAWES Louisa Annie Maria5Servant16General domestic servant
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 2202) ORDER BY Temp2

Notes: