ID:17001Full name:CATTERMOLE James
Forename:JamesSurname:CATTERMOLE
Age:29DoB:-
Gender:MDisability:-
Marital status:MarriedOccupation:Mineral water carter
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):197Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- Beatrice ESpouse Father:- -
Home parish:Diss, NorfolkAddress:8 Denmark Street, Diss
Notes:Married 6 years, 2 children, all still living; 5 rooms in dwelling
TempN1:70TempN2:932
TempT1:-TempT2:Carter/Water
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-0771TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17001


Complete household [197] ( 8 Denmark Street, Diss )
IDNameNo.RoleAgeOccupation
17001CATTERMOLE James1Head29Mineral water carter
17002CATTERMOLE Beatrice E2Wife30-
17003CATTERMOLE Hedley3Son3-
17004CATTERMOLE Cissie4Daughter1-
17005PARRY William5Boarder11-
17006WILBY Daisy6Sister21School teacher
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 197) ORDER BY Temp2

Notes: