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

Your search returned 4219 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, Ah 1901 49 Laundryman Victoria City [4 D 14] I 441 C
 
Gender Male Birthplace China Record census.1901:17108
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $168.00
Birthdate December 3, 1851 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 56011
Months in school Speaks English/French No / No Immigration year 1900
Relation to head Boarder or Lodger Religion Confucian Naturalization year
Address Comments None
+ Ah, Bahk 1901 33 Barber Victoria City [4 D 14] I 407 C
 
Gender Male Birthplace China Record census.1901:16930
Marital Status Married Nationality Chinese Employment Employer
Infirmities Blank or None Race Chinese Earnings $
Birthdate November 8, 1867 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 57030
Months in school Speaks English/French No / No Immigration year 1891
Relation to head Head of Household Religion Confucian Naturalization year
Address '16 Cormorant' Comments None
+ Ah, Bing Chinese 1891 34 Miner Union Mines [3 g-2 19] I 97 C
 
Gender Male Band Not applicable Record census.1891:7616
Marital Status Single Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 5
Religion Confucian Employment Employee HISCO Code 71100
Case number 7538 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Ah, Bing 1901 51 General Labourer Victoria City [4 D 14] I 365 C
 
Gender Male Birthplace China Record census.1901:16705
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $160.00
Birthdate December 18, 1849 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 99910
Months in school Speaks English/French Yes / No Immigration year 1882
Relation to head Inmate Religion Confucian Naturalization year
Address Comments None
+ Ah, Boo 1901 7 None or Unknown Victoria City [4 D 14] I 299 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:16371
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race Chinese Earnings $
Birthdate September 2, 1893 Colour Yellow Extra earnings $
Read/Write Yes / Yes Mother tongue Chinese HISCO Code X2100
Months in school 12 Speaks English/French Yes / No Immigration year
Relation to head Son of Head Religion Confucian Naturalization year
Address Comments None
+ Ah, Bow 1901 30 General Labourer Victoria City [4 D 14] I 480 C
 
Gender Male Birthplace China Record census.1901:17396
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $250.00
Birthdate November 20, 1870 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 99910
Months in school Speaks English/French Yes / No Immigration year 1891
Relation to head Boarder or Lodger Religion Confucian Naturalization year
Address Comments None
+ Ah, Chan 1901 29 Cannery Labourer Victoria City [4 D 14] I 513 C
 
Gender Male Birthplace China Record census.1901:17662
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $120.00
Birthdate October 9, 1871 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 77473
Months in school Speaks English/French Yes / No Immigration year 1883
Relation to head Boarder or Lodger Religion Confucian Naturalization year
Address Comments None
+ Ah, Chang 1901 44 Street Vendor/Pedlar Victoria City [4 D 14] I 300 C
 
Gender Male Birthplace China Record census.1901:16382
Marital Status Married Nationality Chinese Employment Own Account
Infirmities Blank or None Race Chinese Earnings $300.00
Birthdate September 15, 1856 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 45220
Months in school Speaks English/French Yes / No Immigration year 1886
Relation to head Head of Household Religion Confucian Naturalization year
Address '197 Government' Comments None
+ Ah, Chang 1901 44 Pedlar Victoria City [4 D 14] I 300 C
 
Gender Male Birthplace China Record census.1901:16382
Marital Status Married Nationality Chinese Employment Own Account
Infirmities Blank or None Race Chinese Earnings $300.00
Birthdate September 15, 1856 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 45220
Months in school Speaks English/French Yes / No Immigration year 1886
Relation to head Head of Household Religion Confucian Naturalization year
Address '197 Government' Comments None
+ Ah, Chay Chinese 1891 28 Coal Runner Union Mines [3 g-2 19] I 102 C
 
Gender Male Band Not applicable Record census.1891:7638
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 4
Religion Confucian Employment Employee HISCO Code 71210
Case number 7543 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Ah, Chee Chinese 1891 28 Coal Runner Union Mines [3 g-2 19] I 99 C
 
Gender Male Band Not applicable Record census.1891:7624
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 Confucian Employment Employee HISCO Code 71210
Case number 7540 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Ah, Chee 1901 49 Ostler Victoria City [4 D 14] I 577 C
 
Gender Male Birthplace China Record census.1901:17765
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $300.00
Birthdate May 15, 1851 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 62492
Months in school Speaks English/French Yes / No Immigration year 1886
Relation to head Illegible Religion Confucian Naturalization year
Address Comments None
+ Ah, Cheong 1881 54 General Labourer Victoria District [190 D] I 123 C
 
Gender Male Band Not applicable Record census.1881:56057
Marital Status Single Origin China Case number 1754
Infirmities Blank or None Birthplace China Building House
At School No Religion Confucian HISCO Code 99910
Comments None
+ Ah, Cheung 1901 37 Tailor Victoria City [4 D 14] I 381 C
 
Gender Male Birthplace China Record census.1901:16812
Marital Status Married Nationality Canadian Employment Own Account
Infirmities Blank or None Race Chinese Earnings $
Birthdate July 7, 1863 Colour Yellow Extra earnings $
Read/Write Yes / Yes Mother tongue Chinese HISCO Code 79120
Months in school Speaks English/French Yes / No Immigration year 1885
Relation to head Head of Household Religion Confucian Naturalization year 1898
Address '48 Fisguard' Comments None
+ Ah, Chew Chinese 1891 40 Railway Labourer Union Mines [3 g-2 19] I 118 C
 
Gender Male Band Not applicable Record census.1891:7709
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 Confucian Employment Employee HISCO Code 97130
Case number 7559 Employees 0 Relation to head Boarder or Lodger
Comments None
+ Ah, Chi 1901 40 General Labourer Victoria City [4 D 14] I 333 C
 
Gender Male Birthplace China Record census.1901:16517
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $300.00
Birthdate July 15, 1860 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 99910
Months in school Speaks English/French Yes / No Immigration year 1897
Relation to head Head of Household Religion Confucian Naturalization year
Address '30/1/2 Herald' Comments None
+ Ah, Chin 1901 50 Boot and Shoe Maker Victoria City [4 D 14] I 577 C
 
Gender Male Birthplace China Record census.1901:17758
Marital Status Married Nationality Chinese Employment Own Account
Infirmities Blank or None Race Chinese Earnings $500.00
Birthdate May 10, 1850 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 80110
Months in school Speaks English/French Yes / No Immigration year 1883
Relation to head Illegible Religion Confucian Naturalization year
Address Comments None
+ Ah, Ching Chinese 1891 36 Coal Runner Union Mines [3 g-2 19] I 91 C
 
Gender Male Band Not applicable Record census.1891:7588
Marital Status Married Birthplace China Building House
Infirmities Blank or None Father China Construction Wood
Read/Write Yes / Yes Mother China Floors/Rooms 1 / 5
Religion Confucian Employment Employee HISCO Code 71210
Case number 7532 Employees 0 Relation to head Head of Household
Comments None
+ Ah, Ching 1901 18 Domestic Servant Victoria City [4 D 14] I 443 C
 
Gender Male Birthplace China Record census.1901:17133
Marital Status Single Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $96.00
Birthdate June 4, 1882 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 54005
Months in school Speaks English/French Yes / No Immigration year 1900
Relation to head Boarder or Lodger Religion Confucian Naturalization year
Address Comments None
+ Ah, Ching 1901 48 General Labourer Victoria City [4 D 14] I 577 C
 
Gender Male Birthplace China Record census.1901:17768
Marital Status Married Nationality Chinese Employment Employee
Infirmities Blank or None Race Chinese Earnings $250.00
Birthdate September 3, 1852 Colour Yellow Extra earnings $
Read/Write No / No Mother tongue Chinese HISCO Code 99910
Months in school Speaks English/French Yes / No Immigration year 1885
Relation to head Illegible Religion Confucian Naturalization year
Address Comments None