Home > Search > 

viHistory Directory Search

SQL for ths search

SELECT "vdirectory".* , (SELECT count(id) from reclink
WHERE ((reclink.table1_name='directory' AND reclink.table1_id="vdirectory".business_record_id) or (reclink.table2_name='directory' AND reclink.table2_id="vdirectory".business_record_id))) as link_count from "vdirectory"
WHERE (upper(record_year) similar to '1882') AND (upper(business_address) similar to '%broad st%')
ORDER BY sort_name asc

Your search returned 22 items. Showing items 1 to 20. Showing results for year 1882.

+ + Sort ascending Sort descending Name Sort ascending Sort descending Year Sort ascending Sort descending City Sort ascending Sort descending Occupation Sort ascending Sort descending Employer Sort ascending Sort descending Address Sort ascending Sort descending Type  
+ Bull, Wm K 1882 Victoria General agent View st Person C
 
Residence address View st Occupation code Unknown
Employer address Broad st, near Fort Record bd.1882:866
Comments None
+ Burgess, J P 1882 Victoria Carpenter and builder Broad st Person C
 
Residence address Broad st Occupation code Unknown
Employer address N W cor Fort and Broad sts Record bd.1882:871
Comments None
+ Crowther, R A 1882 Victoria Stencil cutter and sign writer Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st, bet Trounce and Fort Record bd.1882:1056
Comments None
+ Daily Evening Post 1882 Victoria Office N W cor Yates and Broad sts Business C
 
Business name Daily Evening Post Proprietor McDowell W J & M C (Proprietors)    
Business address office N W cor Yates and Broad sts Description Unknown Record bd.1882:598
Comments None
+ Directory of British Columbia 1882 Victoria Publication Office Government and Broad sts Business C
 
Business name Directory of British Columbia Proprietor R T Williams (Publisher)    
Business address Publication Office Government and Broad sts Description Unknown Record bd.1882:542
Comments located bet Trounce and Fort
+ Eaton, Thomas 1882 Victoria Employee W G Bowman Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st, bet Yates and View Record bd.1882:1138
Comments None
+ Fell & Co 1882 Victoria S E cor Fort and Broad sts Business C
 
Business name Fell & Co Proprietor Unknown    
Business address S E cor Fort and Broad sts Description Wholesale and Retail Grocers, Wines and Liquors Record bd.1882:551
Comments None
+ Ferrand, B 1882 Victoria Sausage factory View st Person C
 
Residence address View st Occupation code Unknown
Employer address N E cor Johnson and Broad sts Record bd.1882:1183
Comments None
+ Golding, B 1882 Victoria Candies, tobaccos and cigars Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st, near Yates Record bd.1882:1271
Comments None
+ Hall, Philip J 1882 Victoria Proprietor Beehive saloon Yates st, above Douglas Person C
 
Residence address Yates st, above Douglas Occupation code Unknown
Employer address N E cor Fort and Broad sts Record bd.1882:1329
Comments None
+ Hart, Oakley 1882 Victoria Custom shoemaker Person C
 
Residence address Unknown Occupation code Unknown
Employer address Johnson and Broad sts Record bd.1882:1361
Comments None
+ Lawson, Wm George 1882 Victoria Painter Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st, bet Trounce and Fort Record bd.1882:1592
Comments None
+ Lenneker, Charles 1882 Victoria Employee Lettice & Sears Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st Record bd.1882:1608
Comments None
+ Lenneker, Edward 1882 Victoria Painter Lettice & Sears Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st Record bd.1882:1609
Comments None
+ Lettice & Sears 1882 Victoria Broad st, near Fort Business C
 
Business name Lettice & Sears Proprietor Unknown    
Business address Broad st, near Fort Description Painters and Glaziers Record bd.1882:584
Comments None
+ Lettice, Robert 1882 Victoria Proprietor Lettice & Sears Kane st Person C
 
Residence address Kane st Occupation code Unknown
Employer address Broad st Record bd.1882:1619
Comments None
+ Mann & Heron 1882 Victoria Res cor Fort and Broad sts Business C
 
Business name Mann & Heron Proprietor Unknown    
Business address res cor Fort and Broad sts Description Saddlers and Harness Makers Record bd.1882:593
Comments None
+ Paul, Roland H 1882 Victoria Employee W G Bowman Person C
 
Residence address Unknown Occupation code Unknown
Employer address Broad st, bet Yates and View Record bd.1882:1952
Comments None
+ Stenhouse, L 1882 Victoria Rubber stamp manufacturer Person C
 
Residence address Unknown Occupation code Unknown
Employer address Government and Broad sts Record bd.1882:2236
Comments None
+ Tilbury, G F 1882 Victoria Veterinary surgeon and livery stables Opp stable Person C
 
Residence address opp stable Occupation code Unknown
Employer address Broad st, near Fort Record bd.1882:2294
Comments None