Home > Search > 

viHistory Census Search

SQL for ths search

SELECT "vcensus1881".*, (SELECT count(id) from 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 "vcensus1881"
WHERE (upper(occupation_description) similar to 'teacher%') AND (upper(location_03) similar to 'victoria%') AND (upper(marital_status) similar to 'widow%') AND (upper(sex)='f')
ORDER BY family_name asc, given_name asc, middle_name asc

Your search returned 5 items. Showing items 1 to 5. Showing results for year 1881.

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  
+ Caldwell, Letitia M 36 Teacher Victoria City James Bay Ward [190 C] I 200 C
 
Gender Female Band Not applicable Record census.1881:56704
Marital Status Widow/Widower Origin Ireland Case number 1350
Infirmities Blank or None Birthplace New Brunswick, Canada Building House
At School No Religion Anglican/Church of England HISCO Code 13320
Comments None
+ Henderson, Mary Anna 43 Teacher Victoria City James Bay Ward [190 C] I 86 C
 
Gender Female Band Not applicable Record census.1881:58412
Marital Status Widow/Widower Origin England/Great Britain Case number 1236
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 13320
Comments None
+ Holmes, Emily 39 Teacher Victoria City James Bay Ward [190 C] I 127 C
 
Gender Female Band Not applicable Record census.1881:58540
Marital Status Widow/Widower Origin England/Great Britain Case number 1277
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 13320
Comments None
+ Kurtz, Martha 29 Teacher Victoria City James Bay Ward [190 C] I 355 C
 
Gender Female Band Not applicable Record census.1881:59182
Marital Status Widow/Widower Origin England/Great Britain Case number 1505
Infirmities Blank or None Birthplace England/Great Britain Building House
At School No Religion Anglican/Church of England HISCO Code 13320
Comments None
+ Rappertie, Rebecca 61 Teacher Victoria City Johnson Street Ward [190 B] I 617 C
 
Gender Female Band Not applicable Record census.1881:60821
Marital Status Widow/Widower Origin England/Great Britain Case number 980
Infirmities Blank or None Birthplace United States Building House
At School No Religion Anglican/Church of England HISCO Code 13320
Comments None