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(religion) similar to 'free+thinker'))
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 'free+thinker'))
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 'free+thinker'))
ORDER BY family_name asc, given_name asc, middle_name asc
Your search returned no records.
Check spelling, try variations, or use "wild cards" to improve the search results.
Also check that you have not used fields that are not applicable to the selected census years. If colored dots appear next to the field label, that field is not applicable to all census years.
See the search tips page for more help.