ID:816Full name:BLOOMFIELD Spencer
Forename:SpencerSurname:BLOOMFIELD
Age:-DoB:06.10.1903
Gender:MDisability:-
Marital status:MOccupation:Horseman on farm
Parish:BillingfordParish code:BILL
Event:Reg 1939Event date:30.09.1939
Temp 1:105Temp 2:1
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:BillingfordAddress:Low Street, Billingford
Notes:-
TempN1:0TempN2:0
TempT1:-TempT2:-
TempT3:-TempT4:DISS/BILL
Ref:BILL-1939-Reg-0288TempRef:[100081]
SQL: SELECT * FROM Complete WHERE ID = 816


Complete household [105] ( Low Street, Billingford )
IDNameNo.DoBStatusOccupation
816BLOOMFIELD Spencer106.10.1903MHorseman on farm
817BLOOMFIELD Hilda H220.05.1903MUnpaid domestic duties
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'BILL') AND (EventYear = 1939) AND (Temp1 = 105) ORDER BY Temp2

Notes: