ID:6854Full name:TURNER Joseph
Forename:JosephSurname:TURNER
Age:-DoB:03.03.1902
Gender:MDisability:-
Marital status:SOccupation:Horseman on farm
Parish:DissParish code:DISS
Event:Reg 1939Event date:29.09.1939
Temp 1:2228Temp 2:6
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:DissAddress:Hill House, Shelfanger Road, Diss
Notes:Wartime role: Air raid warden
TempN1:0TempN2:0
TempT1:Shelfanger Road, Hill HouseTempT2:-
TempT3:-TempT4:ALL/DISS
Ref:DISS-Reg-1939-1120TempRef:[100008]
SQL: SELECT * FROM Complete WHERE ID = 6854


Complete household [2228] ( Hill House, Shelfanger Road, Diss )
IDNameNo.DoBStatusOccupation
6851FORD Alfred G126.10.1901MHorseman on farm
6852FORD Ethel Maud220.05.1910MUnpaid domestic duties
6853FORD Henry G322.03.1928SAt school
6854TURNER Joseph603.03.1902SHorseman on farm
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'DISS') AND (EventYear = 1939) AND (Temp1 = 2228) ORDER BY Temp2

Notes: