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 '190') AND (upper(location_03_id) similar to 'a') AND (upper(family_id)='71')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 15 items. Showing items 1 to 15. 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  
+ Boggs, Arthur 23 Surveyors Assistant Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:56458
Marital Status Single Origin Ireland Case number 71
Infirmities Blank or None Birthplace Ontario, Canada Building House
At School No Religion Anglican/Church of England HISCO Code 03160
Comments None
+ Carne, Amelia 15 None or Unknown Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Female Band Not applicable Record census.1881:56780
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Methodist HISCO Code X2100
Comments None
+ Carne, Anne Maria 6 None or Unknown Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Female Band Not applicable Record census.1881:56782
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Methodist HISCO Code X2100
Comments None
+ Carne, Elizabeth 24 None or Unknown Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Female Band Not applicable Record census.1881:56778
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace United States Building House
At School No Religion Methodist HISCO Code X2100
Comments None
+ Carne, Frederick 51 Hotel Keeper Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:56776
Marital Status Married Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Methodist HISCO Code 51020
Comments None
+ Carne, Frederick 22 Store Clerk Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:56779
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Methodist HISCO Code 45130
Comments None
+ Carne, Harriet 48 Homemaker Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Female Band Not applicable Record census.1881:56777
Marital Status Married Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Methodist HISCO Code 52010
Comments None
+ Carne, Mary Jane 13 None or Unknown Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Female Band Not applicable Record census.1881:56781
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School Yes Religion Methodist HISCO Code X2100
Comments None
+ Cliapin, James 49 Miner Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:57067
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Not Given HISCO Code 71100
Comments None
+ Graham, Allan 44 Salesman/Saleslady Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:58133
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 45100
Comments None
+ Henderson, Alex 29 Carpenter Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:58411
Marital Status Single Origin Scotland Case number 71
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Presbyterian HISCO Code 95410
Comments None
+ Rowke, W H 31 Surveyors Assistant Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:61053
Marital Status Single Origin Ireland Case number 71
Infirmities Blank or None Birthplace United States Building House
At School No Religion Anglican/Church of England HISCO Code 03160
Comments None
+ Saunders, William 26 Cook Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:61121
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Infidel HISCO Code 53130
Comments None
+ Smythe, William 43 Boot and Shoe Maker Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:61513
Marital Status Single Origin Ireland Case number 71
Infirmities Blank or None Birthplace Ireland Building House
At School No Religion Not Given HISCO Code 80110
Comments None
+ Wickens, Arthur 41 Cabinet Maker Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:62279
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 81120
Comments None