CANSIM - Help (Boolean search)

Help using this page - Advanced search

1. Select the fields you wish to search (if you do not select any fields all fields will be searched).

Note: It is important to understand the distinction between the dimension titles field and the member/item names field. The dimension titles field describes the dimension itself (for example: geography, industry, type of employee). The member/item names field contains the description of each member of each dimension (for example: Canada, Newfoundland and Ontario for the geography dimension or public employees and private employees for the type of employee dimension).

2. Indicate whether you wish to include all tables, only active tables or only terminated tables in your search. A terminated table refers to a table that is no longer being updated.

3. By default, all tables regardless of frequency will be included in the result. To filter the result by a frequency, select the appropriate frequency in the list.

4. Enter a full Boolean query then select Find tables. You may use the words AND, OR and NOT as well as parentheses to specify your search query. Use an asterisk for wildcard searches; for example you might search for harvest* to find tables containing harvested harvesting harvests.

Keep the following points in mind when you perform Boolean searches:

  • Searches are not case-sensitive or accent-sensitive.
  • If you prefer you can use symbols instead of words for the operators as follows: & for AND, | for OR and ~ for NOT.
  • When you use AND between two words, both words must be found in the same field for the search to be considered successful. For example if you want to search in both table titles and dimension member descriptions and you search for Livestock AND Ontario although there is a table about livestock that includes Ontario as a member of the geography dimension the search will not find it because Livestock is found in the table title while Ontario is found as a member of the geography dimension.
  • The NOT operator has a peculiar syntax: it really stands for AND NOT. You should therefore not have it as the first word of a search and you should also not prefix it with the word AND. For example if you want to search for construction excluding residential construction the syntax is construction NOT residential not construction AND NOT residential.