ID:48687Full name:POTTER David
Forename:DavidSurname:POTTER
Age:44DoB:00.00.1847
Gender:MDisability:-
Marital status:MOccupation:Agricultural labourer
Parish:ShelfangerParish code:SHLF
Event:CensusEvent date:31.03.1901
Household (in Census):31Order (in Household):1
Other dates:-Role:Head
Signature:-Consent:-
Father:- -Occupation:-
Mother:-Maiden name:-
Spouse:- -Spouse Father:- -
Home parish:Burston, NorfolkAddress:The Street, Shelfanger, Norfolk
Notes:-
TempN1:0TempN2:0
TempT1:-TempT2:-
TempT3:-TempT4:ALL/DISS
Ref:SHLF-1901-Cen-0104TempRef:[100046]
SQL: SELECT * FROM Complete WHERE ID = 48687


Complete household [31] ( The Street, Shelfanger, Norfolk )
IDNameNo.RoleAgeOccupation
48687POTTER David1Head44Agricultural labourer
48688POTTER Anna2Wife48-
48689POTTER Harry3Son24Horseman on farm
48690POTTER Gad4Son22Stcckman
48691POTTER Charles5Son17Agricultural labourer
48692POTTER Amelia6Daughter14-
48693POTTER Festina7Daughter12-
48694POTTER Florence8Daughter10-
48695POTTER Western9Son7-
48696COBB Stimpson10Boarder78Shoemaker (retired)
SQL: SELECT * FROM Complete WHERE (EventType = 'Census') AND (ParishCode = 'SHLF') AND (EventYear = 1901) AND (Temp1 = 31) ORDER BY Temp2

Notes: