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)='283')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 7 items. Showing items 1 to 7. 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  
+ Clark, Robert 50 General Labourer Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Male Band Not applicable Record census.1881:63672
Marital Status Single Origin England/Great Britain Case number 2223
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion None/No Religion HISCO Code 99910
Comments None
+ Dunsmuir, James 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, Joan Olive 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, Laura 23 Homemaker Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Female Band Not applicable Record census.1881:63838
Marital Status Married Origin Scotland Case number 2223
Infirmities Blank or None Birthplace United States Building House
At School No Religion Presbyterian HISCO Code 52010
Comments None
+ Dunsmuir, Robert 3 None or Unknown Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Male Band Not applicable Record census.1881:63839
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, Sarah B 2 None or Unknown Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Female Band Not applicable Record census.1881:63840
Marital Status Single Origin Scotland Case number 2223
Infirmities Blank or None Birthplace United States Building House
At School No Religion Presbyterian HISCO Code X2100
Comments None
+ Long, Tru 17 Cook, Domestic Nanaimo & Nanoose Bay [191 A] I 283 C
 
Gender Male Band Not applicable Record census.1881:65429
Marital Status Single Origin China Case number 2223
Infirmities Blank or None Birthplace China Building House
At School No Religion Not Given HISCO Code 53140
Comments None