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 'a-3') AND (upper(location_04_id) similar to '9') AND (upper(family_id)='22')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 13 items. Showing items 1 to 13. 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  
+ Austin, Kate 41 Nurse Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:13253
Marital Status Married Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 13
Religion Roman Catholic Employment HISCO Code 07110
Case number 556 Employees 0 Relation to head Servant or Domestic
Comments None
+ Chinese 26 Cook, Domestic Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Male Band Not applicable Record census.1891:15227
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 2 / 13
Religion Not Given Employment HISCO Code 53140
Case number 556 Employees 0 Relation to head Servant or Domestic
Comments None
+ Dunsmuir, Bessie 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, Elinor 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, James 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, Jessie 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, Laura 33 Homemaker Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16786
Marital Status Married Birthplace United States 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 52010
Case number 556 Employees 0 Relation to head Wife of Head
Comments None
+ Dunsmuir, Marion 2 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16787
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, May 7 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16788
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, Robert 13 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Male Band Not applicable Record census.1891:16789
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 Son of Head
Comments None
+ Dunsmuir, Sarah B 12 None or Unknown Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:16790
Marital Status Single Birthplace United States 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
+ Fletcher, Muriam 23 Servant (female) Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:17328
Marital Status Single Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 13
Religion Methodist Employment HISCO Code 54020
Case number 556 Employees 0 Relation to head Servant or Domestic
Comments None
+ Gladding, Florence 17 Nurse Victoria City James Bay Ward [4 a-3 9] I 22 C
 
Gender Female Band Not applicable Record census.1891:17872
Marital Status Single Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 13
Religion Methodist Employment HISCO Code 07110
Case number 556 Employees 0 Relation to head Servant or Domestic
Comments None