Home > Search > 

viHistory Census Search

SQL for ths search

SELECT "vcensus1881".*, (SELECT count(id) from reclink
WHERE ((reclink.table1_name='census' AND reclink.table1_year='1881' AND reclink.table1_id="vcensus1881".census_record_id) or (reclink.table2_name='census' AND reclink.table2_year='1881' AND reclink.table2_id="vcensus1881".census_record_id))) as link_count from "vcensus1881"
WHERE (upper(family_name) similar to 'sm_th%')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 157 items. Showing items 1 to 20.

To display more information, click on the + beside each name.

+ + Sort ascending Sort descending Name Sort ascending Sort descending Age Sort ascending Sort descending Occupation Sort ascending Sort descending Location Sort ascending Sort descending Family  
+ Smethurst, Alice 15 Nurse Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Female Band Not applicable Record census.1881:61395
Marital Status Single Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Not Given HISCO Code 07110
Comments None
+ Smethurst, Henry 7 None or Unknown Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Male Band Not applicable Record census.1881:61398
Marital Status Single Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Not Given HISCO Code X2100
Comments None
+ Smethurst, James 14 None or Unknown Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Male Band Not applicable Record census.1881:61396
Marital Status Single Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Not Given HISCO Code X2100
Comments None
+ Smethurst, Joshua 13 None or Unknown Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Male Band Not applicable Record census.1881:61397
Marital Status Single Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Not Given HISCO Code X2100
Comments None
+ Smethurst, Martha 46 None or Unknown Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Female Band Not applicable Record census.1881:61393
Marital Status Married Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion None/No Religion HISCO Code X2100
Comments None
+ Smethurst, Mary 18 Nurse Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Female Band Not applicable Record census.1881:61394
Marital Status Single Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Not Given HISCO Code 07110
Comments None
+ Smethurst, William 36 General Labourer Victoria City Johnson Street Ward [190 B] I 732 C
 
Gender Male Band Not applicable Record census.1881:61392
Marital Status Married Origin England/Great Britain Case number 1095
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion None/No Religion HISCO Code 99910
Comments None
+ Smith, Agnes E 16 Servant (female) Victoria City James Bay Ward [190 C] I 479 C
 
Gender Female Band Not applicable Record census.1881:61486
Marital Status Single Origin England/Great Britain Case number 1629
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Anglican/Church of England HISCO Code 54020
Comments None
+ Smith, Agnes E 10 None or Unknown Victoria District [190 D] I 67 C
 
Gender Female Band Not applicable Record census.1881:61508
Marital Status Single Origin England/Great Britain Case number 1698
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Presbyterian HISCO Code X2100
Comments None
+ Smith, Agnes 15 None or Unknown Victoria City Johnson Street Ward [190 B] I 291 C
 
Gender Female Band Not applicable Record census.1881:61419
Marital Status Single Origin England/Great Britain Case number 656
Infirmities Blank or None Birthplace Québec, Canada Building House
At School No Religion Methodist HISCO Code X2100
Comments None
+ Smith, Agnes 41 Homemaker Victoria District [190 D] I 13 C
 
Gender Female Band Not applicable Record census.1881:61488
Marital Status Married Origin England/Great Britain Case number 1644
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Reformed Episcopal HISCO Code 52010
Comments None
+ Smith, Agnes 8 None or Unknown Victoria District [190 D] I 13 C
 
Gender Female Band Not applicable Record census.1881:61496
Marital Status Single Origin England/Great Britain Case number 1644
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Reformed Episcopal HISCO Code X2100
Comments None
+ Smith, Alfred 16 None or Unknown Victoria City Johnson Street Ward [190 B] I 610 C
 
Gender Male Band Not applicable Record census.1881:61429
Marital Status Single Origin England/Great Britain Case number 973
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Spiritualist HISCO Code X2100
Comments None
+ Smith, Alice 0 None or Unknown Victoria City Johnson Street Ward [190 B] I 674 C
 
Gender Female Band Not applicable Record census.1881:61445
Marital Status Single Origin Ireland Case number 1037
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Not Given HISCO Code X2100
Comments None
+ Smith, Alice 19 None or Unknown Victoria District [190 D] I 13 C
 
Gender Female Band Not applicable Record census.1881:61490
Marital Status Single Origin England/Great Britain Case number 1644
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Reformed Episcopal HISCO Code X2100
Comments None
+ Smith, Andrew Johnsto 42 Housebuilder/Contractor Victoria City James Bay Ward [190 C] I 1 C
 
Gender Male Band Not applicable Record census.1881:61454
Marital Status Married Origin Scotland Case number 1151
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Presbyterian HISCO Code 95910
Comments None
+ Smith, Andrew Johnsto 5 None or Unknown Victoria City James Bay Ward [190 C] I 1 C
 
Gender Male Band Not applicable Record census.1881:61459
Marital Status Single Origin Scotland Case number 1151
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Presbyterian HISCO Code X2100
Comments None
+ Smith, Andrew Levolya 19 Baker Victoria City James Bay Ward [190 C] I 54 C
 
Gender Male Band Not applicable Record census.1881:61466
Marital Status Single Origin Scotland Case number 1204
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Presbyterian HISCO Code 77610
Comments None
+ Smith, Andrew 14 None or Unknown Victoria District [190 D] I 105 C
 
Gender Male Band Not applicable Record census.1881:61510
Marital Status Single Origin England/Great Britain Case number 1736
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Protestant HISCO Code X2100
Comments None
+ Smith, Anna Alice 0 None or Unknown Nanaimo & Nanoose Bay [191 A] I 237 C
 
Gender Female Band Not applicable Record census.1881:65259
Marital Status Single Origin England/Great Britain Case number 2177
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Methodist HISCO Code X2100
Comments None