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 'b-4') AND (upper(location_04_id) similar to '4') AND (upper(family_id)='116')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 5 items. Showing items 1 to 5. 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  
+ Carne, Agnes M 26 Homemaker Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Female Band Not applicable Record census.1891:14649
Marital Status Married Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 10
Religion Methodist Employment HISCO Code 52010
Case number 4386 Employees 0 Relation to head Wife of Head
Comments None
+ Carne, August W 2 None or Unknown Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Male Band Not applicable Record census.1891:14651
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write No / No Mother British Columbia, Canada Floors/Rooms 2 / 10
Religion Methodist Employment HISCO Code X2100
Case number 4386 Employees 0 Relation to head Son of Head
Comments None
+ Carne, August 3 None or Unknown Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Male Band Not applicable Record census.1891:14650
Marital Status Single Birthplace British Columbia, Canada Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write No / No Mother British Columbia, Canada Floors/Rooms 2 / 10
Religion Methodist Employment HISCO Code X2100
Case number 4386 Employees 0 Relation to head Son of Head
Comments None
+ Carne, Frederick Jnr. 34 Grocer Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Male Band Not applicable Record census.1891:14652
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 / 10
Religion Methodist Employment Employer HISCO Code 41040
Case number 4386 Employees 2 Relation to head Head of Household
Comments None
+ Chinese 20 Servant (male) Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Male Band Not applicable Record census.1891:15350
Marital Status Single Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 2 / 10
Religion Not Given Employment HISCO Code 54090
Case number 4386 Employees 0 Relation to head Servant or Domestic
Comments None