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(location_02_id) similar to '191') AND (upper(location_03_id) similar to 'a') AND (upper(family_id)='540')
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 1881.

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, Emily 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 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 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, Jessie 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, Joannah 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
+ Dunsmuir, Mary 19 None or Unknown Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:63844
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, Robert 55 Colliery Proprietor Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Male Band Not applicable Record census.1881:63842
Marital Status Married Origin Scotland Case number 2480
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Presbyterian HISCO Code 21112
Comments None
+ Fredrickson, John 31 Gardener Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Male Band Not applicable Record census.1881:63952
Marital Status Single Origin Sweden Case number 2480
Infirmities Blank or None Birthplace Sweden Building House
At School No Religion Lutheran HISCO Code 62740
Comments None
+ Hooper, Sarah 22 Servant (female) Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Female Band Not applicable Record census.1881:64295
Marital Status Single Origin England/Great Britain Case number 2480
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 54020
Comments None
+ Jun 25 Cook, Domestic Nanaimo & Nanoose Bay [191 A] I 540 C
 
Gender Male Band Not applicable Record census.1881:64473
Marital Status Single Origin China Case number 2480
Infirmities Blank or None Birthplace China Building House
At School No Religion Not Given HISCO Code 53140
Comments None