ID:17592Full name:PHILPOT Ernest
Forename:ErnestSurname:PHILPOT
Age:17DoB:-
Gender:MDisability:-
Marital status:SingleOccupation:Auchioneers clerk
Parish:DissParish code:DISS
Event:CensusEvent date:02.04.1911
Household (in Census):1055Order (in Household):6
Other dates:-Role:Son
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:Diss, NorfolkAddress:Mount Street, Diss
Notes:-
TempN1:50TempN2:496
TempT1:-TempT2:Clerk/Auctioneer
TempT3:-TempT4:ALL/DISS
Ref:DISS-1911-Cen-1362TempRef:[100085]
SQL: SELECT * FROM Complete WHERE ID = 17592


Complete household [1055] ( Mount Street, Diss )
IDNameNo.RoleAgeOccupation
17587PHILPOT George1Head60Brushmaker
17588PHILPOT Hannah2Wife58-
17589PHILPOT Florence3Daughter38General shopkeeper, china, glass, etc.
17590PHILPOT Arthur4Son36Soldier, infantry
17591PHILPOT Lily5Daughter20Shop assistant, fancy goods
17592PHILPOT Ernest6Son17Auchioneers clerk
17593COXALL Reginald7Grandson9-
17594PHILPOT Mildred8Daughter33Companion, domestic
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'DISS') AND (EventYear = 1911) AND (Temp1 = 1055) ORDER BY Temp2

Notes: