ID:6400Full name:JONES Alice Jane
Forename:Alice JaneSurname:JONES
Age:-DoB:21.11.1890
Gender:FDisability:-
Marital status:SOccupation:Childrens nurse
Parish:DissParish code:DISS
Event:Reg 1939Event date:29.09.1939
Temp 1:2069Temp 2:3
Other dates:-Role:-
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:DissAddress:24 St Nicholas Street, Diss
Notes:-
TempN1:0TempN2:0
TempT1:St Nicholas Street 024TempT2:-
TempT3:-TempT4:ALL/DISS
Ref:DISS-Reg-1939-0666TempRef:[100008]
SQL: SELECT * FROM Complete WHERE ID = 6400


Complete household [2069] ( 24 St Nicholas Street, Diss )
IDNameNo.DoBStatusOccupation
6398GARNHAM William J108.10.1862WBoot and shoe dealer
6399POLLARD Daisy M215.10.1887SHousekeeper
6400JONES Alice Jane321.11.1890SChildrens nurse
6401PARKINSON Lilian M425.05.1926SAt school
SQL: SELECT * FROM Complete WHERE (EventType = 'Reg 1939') AND (ParishCode = 'DISS') AND (EventYear = 1939) AND (Temp1 = 2069) ORDER BY Temp2

Notes: