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(occupation_description) similar to '%smith')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 85 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  
+ Badger, William 30 Blacksmith Victoria City Johnson Street Ward [190 B] I 678 C
 
Gender Male Band Not applicable Record census.1881:56166
Marital Status Single Origin United States Case number 1041
Infirmities Blank or None Birthplace United States Building House
At School No Religion Methodist HISCO Code 83110
Comments None
+ Ball, Charles 44 Blacksmith Victoria City James Bay Ward [190 C] I 439 C
 
Gender Male Band Not applicable Record census.1881:56215
Marital Status Married Origin England/Great Britain Case number 1589
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Reformed Episcopal HISCO Code 83110
Comments None
+ Batterman, Peter 52 Blacksmith North & South Saanich [191 D] I 6 C
 
Gender Male Band Not applicable Record census.1881:66803
Marital Status Widow/Widower Origin Scotland Case number 2285
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Presbyterian HISCO Code 83110
Comments None
+ Bertren, Alexander 40 Blacksmith Victoria City Johnson Street Ward [190 B] I 69 C
 
Gender Male Band Not applicable Record census.1881:56376
Marital Status Single Origin France Case number 434
Infirmities Blank or None Birthplace France Building House
At School No Religion None/No Religion HISCO Code 83110
Comments None
+ Bissell, John 76 Tinsmith Victoria City James Bay Ward [190 C] I 383 C
 
Gender Male Band Not applicable Record census.1881:56390
Marital Status Married Origin England/Great Britain Case number 1533
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Free Thinker HISCO Code 87340
Comments None
+ Borde, August 27 Blacksmith Victoria City Johnson Street Ward [190 B] I 593 CA
 
Gender Male Band Not applicable Record census.1881:56488
Marital Status Married Origin France Case number 956
Infirmities Blank or None Birthplace United States Building House
At School No Religion Roman Catholic HISCO Code 83110
Comments None
+ Brennan, Peter 21 Blacksmith Nanaimo & Nanoose Bay [191 A] I 494 C
 
Gender Male Band Not applicable Record census.1881:63557
Marital Status Married Origin Ireland Case number 2434
Infirmities Blank or None Birthplace Ireland Building House
At School No Religion Methodist HISCO Code 83110
Comments None
+ Bryant, William 47 Blacksmith Victoria City Johnson Street Ward [190 B] I 459 C
 
Gender Male Band Not applicable Record census.1881:56606
Marital Status Married Origin England/Great Britain Case number 822
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 83110
Comments None
+ Carter, C E 32 Blacksmith Victoria City Yates Street Ward [190 A] I 209 C
 
Gender Male Band Not applicable Record census.1881:56828
Marital Status Single Origin Africa Case number 209
Infirmities Blank or None Birthplace Ontario, Canada Building More than one above
At School No Religion Baptist HISCO Code 83110
Comments None
+ Carter, Charles 32 Blacksmith Victoria City Yates Street Ward [190 A] I 189 C
 
Gender Male Band Not applicable Record census.1881:56827
Marital Status Single Origin Africa Case number 189
Infirmities Blank or None Birthplace Ontario, Canada Building House
At School No Religion Baptist HISCO Code 83110
Comments None
+ Casher, Charles 30 Tinsmith Victoria City Yates Street Ward [190 A] I 295 C
 
Gender Male Band Not applicable Record census.1881:56861
Marital Status Married Origin Ireland Case number 295
Infirmities Blank or None Birthplace United States Building More than one above
At School No Religion Congregational HISCO Code 87340
Comments None
+ Charters, John F 20 Blacksmith Sooke, Lake & Highlands [191 E] I 36 C
 
Gender Male Band Not applicable Record census.1881:67299
Marital Status Single Origin Scotland Case number 2404
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Presbyterian HISCO Code 83110
Comments None
+ Charters, William B. 52 Blacksmith Sooke, Lake & Highlands [191 E] I 36 C
 
Gender Male Band Not applicable Record census.1881:67297
Marital Status Married Origin Scotland Case number 2404
Infirmities Blank or None Birthplace Scotia, Nova Scotia, Canada Building House
At School No Religion Presbyterian HISCO Code 83110
Comments None
+ Chauvois, August 78 Blacksmith Victoria City James Bay Ward [190 C] I 232 C
 
Gender Male Band Not applicable Record census.1881:56947
Marital Status Widow/Widower Origin France Case number 1382
Infirmities Blank or None Birthplace France Building House
At School No Religion Roman Catholic HISCO Code 83110
Comments None
+ Clarke, James B 47 Tinsmith Victoria City Johnson Street Ward [190 B] I 435 C
 
Gender Male Band Not applicable Record census.1881:57048
Marital Status Married Origin England/Great Britain Case number 798
Infirmities Blank or None Birthplace Ontario, Canada Building House
At School No Religion Baptist HISCO Code 87340
Comments None
+ Clyde, Albert 25 Tinsmith Victoria City Johnson Street Ward [190 B] I 421 C
 
Gender Male Band Not applicable Record census.1881:57084
Marital Status Married Origin Scotland Case number 784
Infirmities Blank or None Birthplace Ontario, Canada Building House
At School No Religion Baptist HISCO Code 87340
Comments None
+ Clyde, Alexander 47 Blacksmith Victoria City Johnson Street Ward [190 B] I 731 C
 
Gender Male Band Not applicable Record census.1881:57068
Marital Status Married Origin Scotland Case number 1094
Infirmities Blank or None Birthplace Québec, Canada Building House
At School No Religion Baptist HISCO Code 83110
Comments Originally entered as Clide
+ Clyde, George 21 Blacksmith Victoria City Johnson Street Ward [190 B] I 731 C
 
Gender Male Band Not applicable Record census.1881:57071
Marital Status Single Origin Scotland Case number 1094
Infirmities Blank or None Birthplace Québec, Canada Building House
At School No Religion Baptist HISCO Code 83110
Comments Originally entered as Clide
+ Craig, Ralph 34 Blacksmith Nanaimo & Nanoose Bay [191 A] I 460 C
 
Gender Male Band Not applicable Record census.1881:63714
Marital Status Married Origin Scotland Case number 2400
Infirmities Blank or None Birthplace New Brunswick, Canada Building House
At School No Religion Presbyterian HISCO Code 83110
Comments None
+ Draney, Robert 29 Blacksmith Victoria City James Bay Ward [190 C] I 184 C
 
Gender Male Band Not applicable Record census.1881:57522
Marital Status Married Origin Ireland Case number 1334
Infirmities Blank or None Birthplace Ontario, Canada Building House
At School No Religion Anglican/Church of England HISCO Code 83110
Comments None