ID:8691Full name:TURNER Lewis
Forename:LewisSurname:TURNER
Age:-DoB:04.04.1891
Gender:MDisability:-
Marital status:MOccupation:Lawyer
Parish:DissParish code:DISS
Event:Reg 1939Event date:29.09.1939
Temp 1:4200Temp 2:1
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:DissAddress:18 Chapel Street, Diss
Notes:Wartime role: A.R.P. Service
TempN1:0TempN2:0
TempT1:Chapel Street 018TempT2:-
TempT3:-TempT4:ALL/DISS
Ref:DISS-Reg-1939-2957TempRef:[100008]
SQL: SELECT * FROM Complete WHERE ID = 8691


Complete household [4200] ( 18 Chapel Street, Diss )
IDNameNo.DoBStatusOccupation
8691TURNER Lewis104.04.1891MLawyer
8692TURNER Emma217.06.1890MUnpaid domestic duties
8693TURNER Sidney J301.08.1919SShop assistant (clothing)
8694TURNER George H L428.05.1918SShop assistant (clothing)
8695TURNER Annie L510.12.1878MUnpaid domestic duties
8696NUNN Ernest R612.02.1913SShop assistant (ironmongers)
8697HART Beatrice M704.05.1920SShop massistant (library and sweets)
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'DISS') AND (EventYear = 1939) AND (Temp1 = 4200) ORDER BY Temp2

Notes: