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 '3') AND (upper(location_03_id) similar to 'g') AND (upper(location_04_id) similar to '1') AND (upper(family_id)='301')
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  
+ Bolton, E William 29 Coal Miner Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace Wales Record census.1901:30887
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate December 22, 1871 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code 71105
Months in school Speaks English/French No / No Immigration year 1897
Relation to head Boarder or Lodger Religion Baptist Naturalization year
Address Comments None
+ Dunsmuir, Isabella 9 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Female Birthplace British Columbia, Canada Record census.1901:30188
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate July 28, 1891 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year
Relation to head Daughter of Head Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, John 5 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:30041
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate September 21, 1895 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year
Relation to head Son of Head Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, Martin 35 Coal Miner Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace Scotland Record census.1901:31069
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate October 6, 1865 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code 71105
Months in school Speaks English/French No / No Immigration year 1886
Relation to head Head of Household Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, Martin 3 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:29953
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate September 1, 1897 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year
Relation to head Son of Head Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, Mary 34 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Female Birthplace Scotland Record census.1901:31028
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate January 7, 1867 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year 1885
Relation to head Wife of Head Religion Presbyterian Naturalization year
Address Comments None
+ Dunsmuir, W Steward 1 Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:29854
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Scot Earnings $
Birthdate January 17, 1900 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code None
Months in school Speaks English/French No / No Immigration year
Relation to head Son of Head Religion Presbyterian Naturalization year
Address Comments None
+ Reeder, Frank 26 Coal Miner Nanaimo South (Cedar and Oyster District) [3 G 1] I 301 C
 
Gender Male Birthplace Illinois, United States Record census.1901:30762
Marital Status Single Nationality United States Employment
Infirmities Blank or None Race German Earnings $
Birthdate June 18, 1874 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code 71105
Months in school Speaks English/French No / No Immigration year 1900
Relation to head Boarder or Lodger Religion Roman Catholic Naturalization year
Address Comments None