viHistory Census Search
SQL for ths search
SELECT public."vcensus1881".*, (SELECT count(id) from public.reclinkWHERE ((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(location_02_id) similar to '190') AND (upper(location_03_id) similar to 'a') AND (upper(family_id)='335')
ORDER BY family_name asc, given_name asc, middle_name asc
Your search returned 1 items. Showing items 1 to 1. Showing results for year 1881.
To display more information, click on the 
beside each name.
|
 Name
|
 Age
|
Occupation
|
Location
|
Family
|
||||||||||||||||||||||||||||||||
|
Carne, Frederick | 25 | Store Clerk |
Victoria City Yates Street Ward [190 A]
|
335 |
 |
|||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||