Home > Search > 

viHistory Census Search

SQL for ths search

(SELECT public."vcensus1881".*, (SELECT count(id) from public.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 public."vcensus1881"
WHERE (upper(family_name) similar to 'dunsmuir'))
UNION all (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(family_name) similar to 'dunsmuir'))
UNION all (SELECT public."vcensus1901".*, (SELECT count(id) from public.reclink
WHERE ((reclink.table1_name='census' AND reclink.table1_year='1901' AND reclink.table1_id="vcensus1901".census_record_id) or (reclink.table2_name='census' AND reclink.table2_year='1901' AND reclink.table2_id="vcensus1901".census_record_id))) as link_count from public."vcensus1901"
WHERE (upper(family_name) similar to 'dunsmuir'))
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 44 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 Census Sort ascending Sort descending Age Sort ascending Sort descending Occupation Sort ascending Sort descending Location Sort ascending Sort descending Family  
+ Dunsmuir, Alexander 1891 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 1891 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, Bessie 1891 9 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16782
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father United States Construction Wood
Read/Write Yes / Yes Mother United States Floors/Rooms 2 / 13
Religion Presbyterian Employment HISCO Code X2100
Case number 556 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Bessie 1901 19 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21763
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate April 15, 1882 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Byrdie 1901 22 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21762
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate November 22, 1878 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Eleanor 1901 13 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21765
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate November 15, 1887 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Elinor 1891 3 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16783
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father United States Construction Wood
Read/Write No / No Mother United States Floors/Rooms 2 / 13
Religion Presbyterian Employment HISCO Code X2100
Case number 556 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Emily 1881 17 None or Unknown Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63845
Marital Status Single Origin Scotland Case number 2480
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Presbyterian HISCO Code X2100
Comments None
+ Dunsmuir, Euphemia 1881 13 None or Unknown Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63847
Marital Status Single Origin Scotland Case number 2480
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Presbyterian HISCO Code X2100
Comments None
+ Dunsmuir, Henrietta M 1881 9 None or Unknown Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63848
Marital Status Single Origin Scotland Case number 2480
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Presbyterian HISCO Code X2100
Comments None
+ Dunsmuir, Isabella 1901 9 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:30188
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate July 28, 1891 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year
Relation to head Daughter of Head Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, James 1891 39 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Male Band Not applicable Record census.1891:16784
Marital Status Married Birthplace United States Building House
Infirmities Blank or None Father Scotland Construction Wood
Read/Write No / No Mother Scotland Floors/Rooms 2 / 13
Religion Presbyterian Employment HISCO Code X2100
Case number 556 Employees 0 Relation to head Head of Household
Comments None
+ Dunsmuir, James 1901 7 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:21769
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate January 28, 1894 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Son of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, James 1901 49 None or Unknown Victoria City [4 D 20] I 49 CA
 
Gender Male Birthplace British Columbia, Canada Record census.1901:21759
Marital Status Married Nationality Canadian Employment Employer, Own Account
Infirmities Blank or None Race Scot Earnings $
Birthdate July 8, 1851 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Head of Household Religion Anglican/Church of England Naturalization year
Address '*' Comments None
+ Dunsmuir, James 1881 30 Mine Superintendant Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Male Band Not applicable Record census.1881:63837
Marital Status Married Origin Scotland Case number 2223
Infirmities Blank or None Birthplace United States Building House
At School No Religion Presbyterian HISCO Code 27150
Comments None
+ Dunsmuir, Jessie S 1891 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, Jessie 1881 15 None or Unknown Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63846
Marital Status Single Origin Scotland Case number 2480
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Presbyterian HISCO Code X2100
Comments None
+ Dunsmuir, Jessie 1891 1 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16785
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father United States Construction Wood
Read/Write No / No Mother United States Floors/Rooms 2 / 13
Religion Presbyterian Employment HISCO Code X2100
Case number 556 Employees 0 Relation to head Daughter of Head
Comments None
+ Dunsmuir, Joan Olive 1881 1 None or Unknown Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Female Band Not applicable Record census.1881:63841
Marital Status Single Origin Scotland Case number 2223
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Presbyterian HISCO Code X2100
Comments None
+ Dunsmuir, Joannah 1881 52 Homemaker Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63843
Marital Status Married Origin Scotland Case number 2480
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Presbyterian HISCO Code 52010
Comments None