CANSIM - Help (search method)

Help using this page - Initial view

Navigation bar for Statistics Canada web site

The navigation bar helps you navigate anywhere on Statistics Canada's Web site.

CANSIM navigation bar

From the CANSIM navigation bar, access these following options by selecting:

  • Help using this page Get context-sensitive detailed information for the active page
  • About CANSIM Profile of CANSIM product:
    • CANSIM Table directory is a table listing of the content on the CANSIM data base
    • Release dates for major economic indicators
  • Today's releases Is used to announce the release of new tables as well as to announce the routine update and revision patterns of individual CANSIM tables.

Search methods

Type the information in the search box and select the Search button.

You can use one of the following methods:

  • Text search: Enter the phrase or word(s) in the search box. Select the type of search you want to perform (exact phrase, all of these word and any of these words) to perform a Boolean search or have access to more options, select the Advanced search hyperlink.
  • Table number: Enter one or more CANSIM table numbers, separated by commas (do not use any spaces or other punctuation; the hyphen before the last four digits of a table number is optional). To retrieve related tables, use first three digits of the table number followed by for example: 385*. To select a range of tables, enter the first table number followed by . . and then the last table of the range. For example 2820001..2820010 retrieves all the tables in that range.
  • Series number: Enter one or more CANSIM series/vector numbers starting with "v" numbers (separated by commas). The selected series do not all have to come from the same CANSIM table, but for most outputs, they do need to have the same frequency (periodicity). To select a range of series, enter the first series number followed by . . and then the last series number of the range. For example: v1..v6 retrieves all the series in that range.

Note: All search methods, except Series number search, result in the display of one or more CANSIM tables. You are then prompted to select one table from the list displayed and proceed from there.

Text search

Select the type of search you want to perform by selecting the arrow to see the drop down menu:

  • Exact phrase: looks for the exact string you type including punctuation and spaces.
  • All of these words: looks for tables that contain all the words you enter (functions like the Boolean AND).
  • Any of these words: looks for tables that contain any of the words you enter (functions like the Boolean OR).

Enter the phrase or word(s) you are searching for then select the Search button. The results of the search will be the same whether you use upper-case or lower-case letters or whether you use accents or not.

All text in a table will be searched, including table titles, dimension descriptions, and member descriptions. A member is a discrete component in a dimension (for example: Ontario in a "geography" dimension, or mining in an "industry" dimension). All tables, both active and archived, will be returned.

Note: Time is not a dimension and you cannot search by date. You will be able to select the available data ranges in the "customize" tab.

Note: Words have to be matched exactly. You can use an asterisk as a wildcard character to search for different forms of a word. (For example, you might search for harvest* to find tables containing harvest, harvests, harvesting, harvested, etcetera).

Table number search

Enter one or more CANSIM table numbers, separated by commas (do not use any spaces or other punctuation; the hyphen before the last four digits of a table number is optional). If you enter more than one table number, you will be prompted to select the desired table from a list; if you enter only one table number, you will be brought directly to the "data table" tab.

After entering your table numbers, select the Search button to access the "search results" page.

Series number search

Enter one or more CANSIM series/vectors numbers preceded by "v" and separated by commas. The selected series do not all have to come from the same CANSIM table, but for most outputs, they do need to have the same frequency (periodicity).

When you request several series, each series number must be entered separately separated by commas. To select a range of series, enter the first series number followed by .. and then the last series number of the range. For example: v1.. v6 retrieves all the series in that range.

If you have finished entering your series number, select the Search button to access the confirmation page for your series list.

CANSIM by subject

The browse CANSIM by subject method contains over 30 main subjects. When you search by subject, you are presented with a listing of major subjects. This subject list consists of high-level and second-level terms. The list was developed to provide a broad subject approach to the information holdings on Statistics Canada's Website and to allow you to locate and access Statistics Canada data by subject.

CANSIM by survey

The browse CANSIM by survey opens a page with a list of surveys. This list contains descriptions of over 450 surveys and statistical programs each identified by a unique four-digit survey number. You may sort this list alphabetically by selecting the button Sort by record number.

The Definitions, data sources and methods database contains information about the surveys and statistical programs carried out by Statistics Canada and other agencies to collect, assemble, process and disseminate statistical information.

After selecting a survey or program from the list you may choose to either retrieve the list of CANSIM tables for that survey or program, or consult the Definitions, data sources and methods for more information.

CANSIM - Combine series

Through the Combine series hyperlink, you may select additional series from any table on the database. These series will be added to the list of series you have already selected, but the combined list of series can only be used in the Time Series view.

Any retrieval done using the Table view uses only data selected from the most recently retrieved table.

You can find tables of interest by entering a few words in the textbox and select Search. You can also invoke one of the two Browse methods by using the corresponding button. Note that the search box will also accept CANSIM table numbers (for example: 282-0001) and series numbers (for example: v1,v2,v3).

Unless you enter individual series numbers (sometimes also referred to as vector numbers), the result of a search is a list of one or more tables. Selecting a table from the list opens it and allows you to subset it by selecting members of interest from its dimensions.

Select the type of search you want to perform by selecting the radio button:

  • Exact phrase: looks for the exact string you type including punctuation and spaces.
  • All of these words: looks for tables that contain all the words you enter (functions like the Boolean AND).
  • Any of these words: looks for tables that contain any of the words you enter (functions like the Boolean OR).

Enter the phrase or word(s) you are searching for then select the Search button. The results of the search will be the same whether you use upper-case or lower-case letters or whether you use accents or not.