ID:882Full name:COTTON Emma
Forename:EmmaSurname:COTTON
Age:-DoB:22.12.1879
Gender:FDisability:-
Marital status:WOccupation:Unpaid domestic duties
Parish:BillingfordParish code:BILL
Event:Reg 1939Event date:30.09.1939
Temp 1:126Temp 2:1
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:BillingfordAddress:Upper Billingford
Notes:-
TempN1:0TempN2:0
TempT1:-TempT2:-
TempT3:-TempT4:DISS/BILL
Ref:BILL-1939-Reg-0354TempRef:[100081]
SQL: SELECT * FROM Complete WHERE ID = 882


Complete household [126] ( Upper Billingford )
IDNameNo.DoBStatusOccupation
882COTTON Emma122.12.1879WUnpaid domestic duties
883COTTON Wilfred A209.08.1912SFarm horseman
884COTTON Herbert K306.07.1915SFarm labourer
885COTTON Gordon A420.03.1918SFarm cowman
886COTTON Benjamin C517.07.1921SFarm labourer
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'BILL') AND (EventYear = 1939) AND (Temp1 = 126) ORDER BY Temp2

Notes: