Home > Search > 

viHistory Census Search

SQL for ths search

(SELECT public."vcensus1881".*, (SELECT count(id) from public.reclink
WHERE ((reclink.table1_name='census' AND reclink.table1_year='1881' AND reclink.table1_id="vcensus1881".census_record_id) or (reclink.table2_name='census' AND reclink.table2_year='1881' AND reclink.table2_id="vcensus1881".census_record_id))) as link_count from public."vcensus1881"
WHERE (upper(religion) similar to 'infidel'))
UNION all (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(religion) similar to 'infidel'))
UNION all (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(religion) similar to 'infidel'))
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 23 items. Showing items 1 to 20.

To display more information, click on the + beside each name.

+ + Sort ascending Sort descending Name Sort ascending Sort descending Census Sort ascending Sort descending Age Sort ascending Sort descending Occupation Sort ascending Sort descending Location Sort ascending Sort descending Family  
+ Bacon, John S 1891 20 Logger Cowichan Lake [3 d-2 21] I 17 C
 
Gender Male Band Not applicable Record census.1891:6343
Marital Status Single Birthplace England/Great Britain Building Shanty
Infirmities Blank or None Father Not Given Construction No Information
Read/Write Yes / Yes Mother Not Given Floors/Rooms /
Religion Infidel Employment Employee HISCO Code 63110
Case number 7297 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Clark, Nicklas S 1901 37 Miner Cowichan (Cowichan District) [3 C 3] I 87 C
 
Gender Male Birthplace Ontario, Canada Record census.1901:41167
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race Irish Earnings $
Birthdate June 7, 1863 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code 71100
Months in school Speaks English/French No / No Immigration year
Relation to head Head of Household Religion Infidel Naturalization year
Address Comments None
+ Davis, David 1891 42 Miner Mountain & South Wellington [3 j 4] I 32 C
 
Gender Male Band Not applicable Record census.1891:8423
Marital Status Single Birthplace Wales Building House
Infirmities Blank or None Father Wales Construction Wood
Read/Write Yes / Yes Mother Wales Floors/Rooms 1 / 4
Religion Infidel Employment Employee HISCO Code 71100
Case number 7728 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Davis, Thomas H 1891 47 Miner Mountain & South Wellington [3 j 4] I 284 C
 
Gender Male Band Not applicable Record census.1891:9629
Marital Status Married Birthplace Wales Building House
Infirmities Blank or None Father Wales Construction Wood
Read/Write Yes / Yes Mother Wales Floors/Rooms 1 / 3
Religion Infidel Employment Employee HISCO Code 71100
Case number 7975 Employees 0 Relation to head Head of Household
Comments None
+ Davis, Thomas 1891 19 Miner Mountain & South Wellington [3 j 4] I 284 C
 
Gender Male Band Not applicable Record census.1891:9631
Marital Status Single Birthplace Wales Building House
Infirmities Blank or None Father Wales Construction Wood
Read/Write Yes / Yes Mother Wales Floors/Rooms 1 / 3
Religion Infidel Employment Employee HISCO Code 71100
Case number 7975 Employees 0 Relation to head Son of Head
Comments None
+ Duck, Ada O 1901 28 None or Unknown Victoria City [4 D 12] I 235 C
 
Gender Female Birthplace New Zealand Record census.1901:14560
Marital Status Married Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate June 29, 1872 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 Infidel Naturalization year
Address Comments None
+ Duck, William 1901 35 None or Unknown Victoria City [4 D 12] I 235 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:14559
Marital Status Married Nationality Canadian Employment Own Means
Infirmities Blank or None Race English Earnings $
Birthdate April 3, 1866 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 Infidel Naturalization year
Address '38 North Park' Comments None
+ Fracey, Joseph 1901 37 Market Gardener Victoria (Oak Bay and Cedar Hill) [4 C 2] I 44 C
 
Gender Male Birthplace Ontario, Canada Record census.1901:46489
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Irish Earnings $
Birthdate April 10, 1865 Colour White Extra earnings $
Read/Write No / No Mother tongue Missing/Not Given HISCO Code 62720
Months in school Speaks English/French No / No Immigration year
Relation to head Head of Household Religion Infidel Naturalization year
Address Comments Age & Birthdate Inconsistent (Calculated at 36)
+ Hastings, Matilda C 1881 32 Homemaker Victoria City Yates Street Ward [190 A] I 4 C
 
Gender Female Band Not applicable Record census.1881:58334
Marital Status Married Origin France Case number 4
Infirmities Blank or None Birthplace France Building House
At School No Religion Infidel HISCO Code 52010
Comments None
+ Hastings, O C 1881 34 Photographer Victoria City Yates Street Ward [190 A] I 4 C
 
Gender Male Band Not applicable Record census.1881:58333
Marital Status Married Origin United States Case number 4
Infirmities Blank or None Birthplace United States Building House
At School No Religion Infidel HISCO Code 16310
Comments None
+ Hastings, Oregon C 1891 45 Photographer Victoria City Yates Street Ward [4 c-3 6] I 23 C
 
Gender Male Band Not applicable Record census.1891:18718
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 / 8
Religion Infidel Employment Employer HISCO Code 16310
Case number 5326 Employees 1 Relation to head Head of Household
Comments None
+ Hastings, Sylvestria T 1891 45 Homemaker Victoria City Yates Street Ward [4 c-3 6] I 23 C
 
Gender Female Band Not applicable Record census.1891:18720
Marital Status Married Birthplace Australia Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 8
Religion Infidel Employment HISCO Code 52010
Case number 5326 Employees 0 Relation to head Wife of Head
Comments None
+ Haston, George 1891 28 Miner Wellington [3 k-5 5] I 93 C
 
Gender Male Band Not applicable Record census.1891:10648
Marital Status Single Birthplace United States Building House
Infirmities Blank or None Father United States Construction Wood
Read/Write Yes / No Mother United States Floors/Rooms 1 / 4
Religion Infidel Employment Employee HISCO Code 71100
Case number 8169 Employees 0 Relation to head Head of Household
Comments None
+ John, Gomer 1901 59 None or Unknown Victoria (Oak Bay and Cedar Hill) [4 C 2] I 112 C
 
Gender Male Birthplace Wales Record census.1901:850
Marital Status Married Nationality Canadian Employment Own Means
Infirmities Blank or None Race Welsh Earnings $
Birthdate June 23, 1841 Colour White Extra earnings $
Read/Write Yes / Yes Mother tongue Welsh HISCO Code X2100
Months in school Speaks English/French Yes / No Immigration year 1862
Relation to head Head of Household Religion Infidel Naturalization year
Address 'Cadboro Bay' Comments None
+ Keene, Robert 1891 31 Miner Wellington [3 k-5 5] I 153 C
 
Gender Male Band Not applicable Record census.1891:10906
Marital Status Single Birthplace Ontario, Canada Building House
Infirmities Blank or None Father Ontario, Canada Construction Wood
Read/Write Yes / Yes Mother Ontario, Canada Floors/Rooms 2 / 23
Religion Infidel Employment Employee HISCO Code 71100
Case number 8229 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Lee, John 1901 21 Coal Miner Nanaimo City (South Ward; Chinatown; Protection Island) [3 E 4] I 166 C
 
Gender Male Birthplace United States Record census.1901:34085
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate August 27, 1879 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 1882
Relation to head Boarder or Lodger Religion Infidel Naturalization year
Address Comments None
+ McDermott, James 1891 34 Miner Mountain & South Wellington [3 j 4] I 278 C
 
Gender Male Band Not applicable Record census.1891:9602
Marital Status Single Birthplace United States Building House
Infirmities Blank or None Father Ireland Construction Wood
Read/Write Yes / Yes Mother Ireland Floors/Rooms 2 / 8
Religion Infidel Employment Employee HISCO Code 71100
Case number 7969 Employees 0 Relation to head Boarder or Lodger
Comments None
+ McKinnon, William 1881 44 Poultry Farmer Cowichan & Salt Spring Island [191 C] I 36 C
 
Gender Male Band Not applicable Record census.1881:66495
Marital Status Single Origin Scotland Case number 2696
Infirmities Blank or None Birthplace Scotland Building House
At School No Religion Infidel HISCO Code 61260
Comments An avowed Infidel
+ Mitchell, Charles J 1891 60 Tinsmith Nanaimo City Middle Ward [3 k-2 2] I 21 C
 
Gender Male Band Not applicable Record census.1891:118
Marital Status Single Birthplace United States Building House
Infirmities Blank or None Father United States Construction Brick
Read/Write Yes / Yes Mother United States Floors/Rooms 2 / 29
Religion Infidel Employment Employee HISCO Code 87340
Case number 5750 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Saunders, William 1881 26 Cook Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:61121
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Infidel HISCO Code 53130
Comments None