Home > Search > 

viHistory Census Search

SQL for ths search

SELECT public."vcensus1891".*, (SELECT count(id) from public.reclink
WHERE ((reclink.table1_name='census' AND reclink.table1_year='1891' AND reclink.table1_id="vcensus1891".census_record_id) or (reclink.table2_name='census' AND reclink.table2_year='1891' AND reclink.table2_id="vcensus1891".census_record_id))) as link_count from public."vcensus1891"
WHERE (upper(location_02_id) similar to '4') AND (upper(location_03_id) similar to 'c-3') AND (upper(location_04_id) similar to '6') AND (upper(family_id)='37')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 10 items. Showing items 1 to 10. Showing results for year 1891.

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  
+ Dunsmuir, Alexander 37 Coal Merchant Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Male Band Not applicable Record census.1891:16791
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / Yes Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment Employer HISCO Code 41130
Case number 5340 Employees 0 Relation to head Son of Head
Comments None
+ Dunsmuir, Annie U 22 None or Unknown Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Female Band Not applicable Record census.1891:16792
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / No Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment HISCO Code X2100
Case number 5340 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Jessie S 24 None or Unknown Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Female Band Not applicable Record census.1891:16793
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / Yes Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment HISCO Code X2100
Case number 5340 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Maud H 19 None or Unknown Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Female Band Not applicable Record census.1891:16794
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / No Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment HISCO Code X2100
Case number 5340 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Olive 62 None or Unknown Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Female Band Not applicable Record census.1891:16795
Marital Status Widow/Widower Birthplace Scotland Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 3 / 10
Religion Presbyterian Employment Employer HISCO Code X2100
Case number 5340 Employees 6 Relation to head Head of Household
Comments None
+ Harvey, Elizabeth 17 None or Unknown Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Female Band Not applicable Record census.1891:18690
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / No Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment HISCO Code X2100
Case number 5340 Employees 0 Relation to head Granddaughter of Head
Comments None
+ Harvey, Robert D 13 Student Victoria City Yates Street Ward [4 c-3 6] I 37 C
 
Gender Male Band Not applicable Record census.1891:18696
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write Yes / No Mother Scotland Floors/Rooms 3 / 10
Religion Presbyterian Employment HISCO Code 19990
Case number 5340 Employees 0 Relation to head Grandson of Head
Comments None
+ McDonald, Kate 24 Servant (female) Victoria City Yates Street Ward [4 c-3 6] I 37 CA
 
Gender Female Band Not applicable Record census.1891:21513
Marital Status Single Birthplace Ontario, Canada Building House
Infirmities Blank or None Father Ontario, Canada Construction Wood
Read/Write Yes / No Mother Ontario, Canada Floors/Rooms 3 / 10
Religion Roman Catholic Employment HISCO Code 54020
Case number 5340 Employees 0 Relation to head Servant or Domestic
Comments None
+ Nash, Isaac 19 Stableman Victoria City Yates Street Ward [4 c-3 6] I 37 CA
 
Gender Male Band Not applicable Record census.1891:22612
Marital Status Single Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / No Mother England/Great Britain Floors/Rooms 3 / 10
Religion Anglican/Church of England Employment HISCO Code 62490
Case number 5340 Employees 0 Relation to head Servant or Domestic
Comments None
+ Smith, Esther 19 Servant (female) Victoria City Yates Street Ward [4 c-3 6] I 37 CA
 
Gender Female Band Not applicable Record census.1891:25091
Marital Status Single Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / No Mother England/Great Britain Floors/Rooms 3 / 10
Religion Anglican/Church of England Employment HISCO Code 54020
Case number 5340 Employees 0 Relation to head Servant or Domestic
Comments None