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 'heathen'))
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 'heathen'))
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 'heathen'))
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 59 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  
+ Ah, Gen 1891 14 Cook Nanaimo City North Ward [3 k-1 1] I 255 C
 
Gender Male Band Not applicable Record census.1891:2694
Marital Status Single Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write No / No Mother China Floors/Rooms 1 / 2
Religion Heathen Employment Employee HISCO Code 53130
Case number 6391 Employees 0 Relation to head Servant or Domestic
Comments None
+ Bing, Ah 1881 24 Cook, Domestic Victoria City James Bay Ward [190 C] I 456 C
 
Gender Male Band Not applicable Record census.1881:56387
Marital Status Single Origin China Case number 1606
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Boo, Ah 1881 16 Gardener Victoria City James Bay Ward [190 C] I 193 C
 
Gender Male Band Not applicable Record census.1881:56475
Marital Status Single Origin China Case number 1343
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 62740
Comments None
+ Boy, Ah 1881 24 Cook, Domestic Victoria City James Bay Ward [190 C] I 335 C
 
Gender Male Band Not applicable Record census.1881:56530
Marital Status Single Origin China Case number 1485
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Chinese 1891 99 Cook, Domestic Victoria City Johnson Street Ward [4 b-1 1] I 85 C
 
Gender Male Band Not applicable Record census.1891:15238
Marital Status Single Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write No / No Mother China Floors/Rooms 2 / 13
Religion Heathen Employment HISCO Code 53140
Case number 1082 Employees 0 Relation to head Servant or Domestic
Comments None
+ Chong, Ah Chinese 1891 43 None or Unknown Mountain & South Wellington [3 j 4] I 66 C
 
Gender Male Band Not applicable Record census.1891:8584
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 3
Religion Heathen Employment HISCO Code X2100
Case number 7761 Employees 0 Relation to head Head of Household
Comments None
+ Chong, Ah 1881 23 Cook, Domestic Victoria City James Bay Ward [190 C] I 276 C
 
Gender Male Band Not applicable Record census.1881:56986
Marital Status Single Origin China Case number 1426
Infirmities Blank or None Birthplace Hong Kong Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Chong, Tong 1881 25 Market Gardener Victoria City James Bay Ward [190 C] I 442 C
 
Gender Male Band Not applicable Record census.1881:56987
Marital Status Single Origin China Case number 1592
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 62720
Comments None
+ Choo, Ah 1881 33 Cook, Domestic Victoria City James Bay Ward [190 C] I 424 C
 
Gender Male Band Not applicable Record census.1881:56990
Marital Status Married Origin China Case number 1574
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Chu, T 1881 22 Cook, Domestic Victoria City James Bay Ward [190 C] I 49 C
 
Gender Male Band Not applicable Record census.1881:57014
Marital Status Single Origin China Case number 1199
Infirmities Blank or None Birthplace Hong Kong Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Chueng, Ye 1901 11 Domestic Servant Victoria City [4 D 1] I 124 C
 
Gender Male Birthplace China Record census.1901:2054
Marital Status Single Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $48.00
Birthdate February 10, 1889 Colour Yellow Extra earnings $
Read/Write Yes / Yes Mother tongue Chinese HISCO Code 54005
Months in school Speaks English/French Yes / No Immigration year 1899
Relation to head Servant or Domestic Religion Heathen Naturalization year
Address Comments None
+ Chung 1881 18 General Labourer Victoria City James Bay Ward [190 C] I 49 C
 
Gender Male Band Not applicable Record census.1881:57021
Marital Status Single Origin China Case number 1199
Infirmities Blank or None Birthplace Hong Kong Building House
At School No Religion Heathen HISCO Code 99910
Comments None
+ Cow, Ah 1891 50 Mine Labourer Mountain & South Wellington [3 j 4] I 36 C
 
Gender Male Band Not applicable Record census.1891:8444
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write No / No Mother China Floors/Rooms 1 / 3
Religion Heathen Employment Employee HISCO Code 71140
Case number 7732 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Foo, Mar (China) 1891 34 Wharf Labourer Nanaimo City North Ward [3 k-1 1] I 257 C
 
Gender Male Band Not applicable Record census.1891:2704
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write No / No Mother China Floors/Rooms 1 / 3
Religion Heathen Employment Employee HISCO Code 97160
Case number 6393 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Fow, Ah 1881 30 Cook, Domestic Victoria City James Bay Ward [190 C] I 296 C
 
Gender Male Band Not applicable Record census.1881:57857
Marital Status Single Origin China Case number 1446
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Gong, Tong 1881 30 Market Gardener Victoria City James Bay Ward [190 C] I 442 C
 
Gender Male Band Not applicable Record census.1881:58055
Marital Status Married Origin China Case number 1592
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 62720
Comments None
+ Goon, Ah 1881 23 Cook, Domestic Victoria City James Bay Ward [190 C] I 179 C
 
Gender Male Band Not applicable Record census.1881:58092
Marital Status Single Origin China Case number 1329
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 53140
Comments None
+ Hong, Ah 1881 25 Market Gardener Victoria City James Bay Ward [190 C] I 442 C
 
Gender Male Band Not applicable Record census.1881:58561
Marital Status Married Origin China Case number 1592
Infirmities Blank or None Birthplace China Building House
At School No Religion Heathen HISCO Code 62720
Comments None
+ How, Ah Chinese 1891 34 Cook Mountain & South Wellington [3 j 4] I 66 C
 
Gender Male Band Not applicable Record census.1891:8590
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 3
Religion Heathen Employment Employee HISCO Code 53130
Case number 7761 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Hung, Ah 1891 24 Mine Labourer Mountain & South Wellington [3 j 4] I 36 C
 
Gender Male Band Not applicable Record census.1891:8443
Marital Status Single Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 3
Religion Heathen Employment Employee HISCO Code 71140
Case number 7732 Employees 0 Relation to head Boarder or Lodger
Comments None