Home > Search > 

viHistory Census Search

SQL for ths search

SELECT public."vcensus1901".*, (SELECT count(id) from public.reclink
WHERE ((reclink.table1_name='census' AND reclink.table1_year='1901' AND reclink.table1_id="vcensus1901".census_record_id) or (reclink.table2_name='census' AND reclink.table2_year='1901' AND reclink.table2_id="vcensus1901".census_record_id))) as link_count from public."vcensus1901"
WHERE (upper(location_02_id) similar to '4') AND (upper(location_03_id) similar to 'd') AND (upper(location_04_id) similar to '10') AND (upper(family_id)='65')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 8 items. Showing items 1 to 8. Showing results for year 1901.

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  
+ Ah, Young 22 General Servant Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace China Record census.1901:11344
Marital Status Single Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $120.00
Birthdate Unknown Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 54000
Months in school Speaks English/French Yes / Yes Immigration year
Relation to head Servant or Domestic Religion Buddhist Naturalization year
Address Comments None
+ Carne, Agness 1 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:11343
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate August 1, 1899 Colour White Extra earnings $
Read/Write No / No Mother tongue None HISCO Code X2100
Months in school Speaks English/French No / No Immigration year
Relation to head Daughter of Head Religion Methodist Naturalization year
Address Comments None
+ Carne, Agness 35 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:11338
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate September 9, 1865 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Wife of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Carne, August W 13 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:11339
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate May 10, 1887 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Son of Head Religion Methodist Naturalization year
Address Comments None
+ Carne, Fred 44 Grocer Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace England/Great Britain Record census.1901:11337
Marital Status Married Nationality Canadian Employment Employer
Infirmities Blank or None Race English Earnings $
Birthdate August 18, 1856 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code 41040
Months in school Speaks English/French Yes / No Immigration year 1860
Relation to head Head of Household Religion Methodist Naturalization year
Address '284 Yates' Comments None
+ Carne, Frederick 11 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:11340
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate August 26, 1889 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Son of Head Religion Methodist Naturalization year
Address Comments None
+ Carne, Harold 3 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:11342
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate September 1, 1897 Colour White Extra earnings $
Read/Write No / No Mother tongue None HISCO Code X2100
Months in school Speaks English/French No / No Immigration year
Relation to head Son of Head Religion Methodist Naturalization year
Address Comments None
+ Carne, Marjory 9 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:11341
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate June 1, 1891 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Methodist Naturalization year
Address Comments None