ID:6497Full name:STURGEON James W
Forename:James WSurname:STURGEON
Age:-DoB:09.09.1884
Gender:MDisability:-
Marital status:MOccupation:General labourer diss w
Parish:DissParish code:DISS
Event:Reg 1939Event date:29.09.1939
Temp 1:2106Temp 2:1
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:DissAddress:29 Mount Street, Diss
Notes:-
TempN1:0TempN2:0
TempT1:Mount Street 029TempT2:-
TempT3:-TempT4:ALL/DISS
Ref:DISS-Reg-1939-0763TempRef:[100008]
SQL: SELECT * FROM Complete WHERE ID = 6497


Complete household [2106] ( 29 Mount Street, Diss )
IDNameNo.DoBStatusOccupation
6497STURGEON James W109.09.1884MGeneral labourer diss w
6498STURGEON Emma T228.09.1886MDomestic duties at home
6499STURGEON Annie E314.09.1913SShop assistant clerk
6500STURGEON Ivy C426.12.1916SShop assistant confect
6501STURGEON Charles W513.02.1918SPainter and decorator
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'DISS') AND (EventYear = 1939) AND (Temp1 = 2106) ORDER BY Temp2

Notes: