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(family_name) similar to 'carne') AND (upper(given_name) similar to 'frederick'))
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(family_name) similar to 'carne') AND (upper(given_name) similar to 'frederick'))
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(family_name) similar to 'carne') AND (upper(given_name) similar to 'frederick'))
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 6 items. Showing items 1 to 6.

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  
+ Carne, Frederick Jnr. 1891 34 Grocer Victoria City Johnson Street Ward [4 b-4 4] I 116 C
 
Gender Male Band Not applicable Record census.1891:14652
Marital Status Married Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 2 / 10
Religion Methodist Employment Employer HISCO Code 41040
Case number 4386 Employees 2 Relation to head Head of Household
Comments None
+ Carne, Frederick 1881 25 Store Clerk Victoria City Yates Street Ward [190 A] I 335 C
 
Gender Male Band Not applicable Record census.1881:56800
Marital Status Single Origin England/Great Britain Case number 335
Infirmities Blank or None Birthplace British Columbia, Canada Building House
At School No Religion Methodist HISCO Code 45130
Comments None
+ Carne, Frederick 1881 22 Store Clerk Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:56779
Marital Status Single Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Methodist HISCO Code 45130
Comments None
+ Carne, Frederick 1881 51 Hotel Keeper Victoria City Yates Street Ward [190 A] I 71 C
 
Gender Male Band Not applicable Record census.1881:56776
Marital Status Married Origin England/Great Britain Case number 71
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Methodist HISCO Code 51020
Comments None
+ Carne, Frederick 1891 62 Hotel Keeper Victoria City Yates Street Ward [4 c-1 5] I 29 C
 
Gender Male Band Not applicable Record census.1891:14865
Marital Status Married Birthplace England/Great Britain Building House
Infirmities Blank or None Father England/Great Britain Construction Wood
Read/Write Yes / Yes Mother England/Great Britain Floors/Rooms 3 / 27
Religion Methodist Employment Employer HISCO Code 51020
Case number 5026 Employees 2 Relation to head Head of Household
Comments None
+ Carne, Frederick 1901 11 None or Unknown Victoria City [4 D 10] I 65 C
 
Gender Male Birthplace British Columbia, Canada Record census.1901:11340
Marital Status Single Nationality Canadian Employment
Infirmities Blank or None Race English Earnings $
Birthdate August 26, 1889 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 Methodist Naturalization year
Address Comments None