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 '20') AND (upper(family_id)='49')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 16 items. Showing items 1 to 16. 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  
+ Austin, Kate 50 Nurse Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace Ireland Record census.1901:21770
Marital Status Married Nationality Canadian Employment Employee
Infirmities Blank or None Race Irish Earnings $360.00
Birthdate December 23, 1850 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code 07110
Months in school Speaks English/French Yes / No Immigration year 1872
Relation to head Nurse Religion Roman Catholic Naturalization year
Address Comments None
+ Dunsmuir, Bessie 19 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21763
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate April 15, 1882 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 Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Byrdie 22 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21762
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate November 22, 1878 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 Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Eleanor 13 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21765
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate November 15, 1887 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, James 7 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:21769
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate January 28, 1894 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Son of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, James 49 None or Unknown Victoria City [4 D 20] I 49 CA
 
Gender Male Birthplace British Columbia, Canada Record census.1901:21759
Marital Status Married Nationality Canadian Employment Employer, Own Account
Infirmities Blank or None Race Scot Earnings $
Birthdate July 8, 1851 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 Head of Household Religion Anglican/Church of England Naturalization year
Address '*' Comments None
+ Dunsmuir, Kathleen 8 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21768
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate December 23, 1891 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Laura 42 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21760
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate February 13, 1858 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
+ Dunsmuir, Marian 12 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21766
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate November 25, 1888 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Mary 16 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21764
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate July 3, 1884 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Muriel 9 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:21767
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate July 30, 1890 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code X2100
Months in school 10 Speaks English/French Yes / No Immigration year
Relation to head Daughter of Head Religion Anglican/Church of England Naturalization year
Address Comments None
+ Dunsmuir, Robin W 23 None or Unknown Victoria City [4 D 20] I 49 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:21761
Marital Status Single Nationality Canadian Employment Employee
Infirmities Blank or None Race Scot Earnings $600.00
Birthdate August 21, 1877 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 Anglican/Church of England Naturalization year
Address Comments None
+ Gladding, Ada E 23 Housemaid Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace England/Great Britain Record census.1901:21772
Marital Status Single Nationality Canadian Employment Employee
Infirmities Blank or None Race English Earnings $240.00
Birthdate December 3, 1877 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code 52031
Months in school Speaks English/French Yes / No Immigration year 1888
Relation to head Servant or Domestic Religion Methodist Naturalization year
Address Comments None
+ Hoy, Ah 34 Cook Victoria City [4 D 20] I 49 C
 
Gender Male Birthplace China Record census.1901:21773
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $360.00
Birthdate June 10, 1866 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 53130
Months in school Speaks English/French No / No Immigration year 1891
Relation to head Servant or Domestic Religion Buddhist Naturalization year
Address Comments None
+ Keapock, Mary P 22 Housemaid Victoria City [4 D 20] I 49 C
 
Gender Female Birthplace Dublin, Ireland Record census.1901:21771
Marital Status Single Nationality Canadian Employment Employee
Infirmities Blank or None Race Irish Earnings $240.00
Birthdate October 29, 1878 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue English HISCO Code 52031
Months in school Speaks English/French Yes / No Immigration year 1890
Relation to head Servant or Domestic Religion Roman Catholic Naturalization year
Address Comments None
+ Sing, Wah 48 Gardener Victoria City [4 D 20] I 49 C
 
Gender Male Birthplace China Record census.1901:21774
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $200.00
Birthdate February 6, 1853 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 62740
Months in school Speaks English/French No / No Immigration year 1875
Relation to head Gardener or Stableman Religion Buddhist Naturalization year
Address Comments None