Table 001-0010 131
Estimated areas, yield, production and average farm price of principal field crops, in metric units
annual


Data table

The data below is a part of CANSIM table  001-0010.  Use the  Add/Remove data  tab to customize your table.

Selected items [Add/Remove data]
Harvest disposition = Production (metric tonnes)
by Geography; by Type of crop; Harvest disposition= Production (metric tonnes)
Estimated areas, yield, production and average farm price of principal field crops, in metric units, annual
Geography Type of crop 2013 2014 2015 2016 2017
footnotes
Canada Barley 29 10,237,100 7,119,000 8,225,700 8,783,600 7,305,500
Canary seed 131,000 124,900 148,600 140,300 116,300
Canola 226 18,551,000 16,410,100 18,376,500 19,600,500 19,707,900
Chick peas 2 169,400 123,000 83,500 75,200 75,000
Corn for grain 215 14,193,800 11,486,800 13,559,100 13,193,100 14,312,600
Flaxseed 220 730,700 872,500 942,300 588,000 501,200
Lentils 2,261,700 1,987,000 2,540,500 3,248,200 2,438,600
Mustard seed 24 154,500 198,000 123,400 235,600 114,900
Oats 29 3,905,600 2,979,000 3,427,700 3,194,600 3,802,200
Soybeans 221 5,358,900 6,048,600 6,459,100 6,552,100 8,321,100
Sunflower seed 27 51,900 55,000 72,600 50,600 52,300
Wheat, all 2434 37,529,600 29,419,600 27,594,100 31,728,600 27,129,800
Wheat, durum 2 6,504,500 5,192,700 5,388,700 7,761,800 4,299,300
Wheat, spring 235 27,238,700 21,297,700 19,962,300 20,453,800 20,075,900
Wheat, winter remaining 2632 3,786,400 2,929,200 2,243,100 3,513,000 2,754,600
Maritime provinces Barley 29 133,200 102,400 112,900 106,500 99,200
Corn for grain 215 126,200 72,400 84,500 118,900 140,600
Oats 29 34,200 39,900 50,100 45,000 44,200
Soybeans 221 86,700 88,500 72,200 76,500 81,200
Wheat, all 2434 42,900 51,200 73,600 72,900 73,000
Wheat, spring 235 27,500 35,500 49,700 46,100 50,700
Wheat, winter remaining 2632 15,400 15,700 23,900 26,800 22,300
Prince Edward Island Barley 29 103,600 78,400 82,700 80,600 74,900
Corn for grain 215 27,200 .. .. 30,500 39,600
Oats 29 11,600 8,500 14,100 10,900 13,000
Soybeans 221 61,500 60,100 47,200 49,000 45,800
Wheat, all 2434 25,100 32,900 44,500 48,600 52,600
Wheat, spring 235 21,200 26,400 35,800 34,700 41,700
Wheat, winter remaining 2632 3,900 6,500 8,700 13,900 10,900
Nova Scotia Barley 29 5,000 3,900 4,100 3,300 5,400
Corn for grain 215 71,100 48,000 55,900 52,800 57,000
Oats 29 2,700 2,700 2,100 3,300 3,100
Soybeans 221 12,000 14,800 12,800 12,800 15,400
Wheat, all 2434 10,500 9,200 15,200 12,900 11,400
Wheat, spring 235 1,200 .. .. .. ..
Wheat, winter remaining 2632 9,300 9,200 15,200 12,900 11,400
New Brunswick Barley 29 24,600 20,100 26,100 22,600 18,900
Canola 226 6,100 .. .. .. ..
Corn for grain 215 27,900 24,400 28,600 35,600 44,000
Oats 29 19,900 28,700 33,900 30,800 28,100
Soybeans 221 13,200 13,600 12,200 14,700 20,000
Wheat, all 2434 7,300 9,100 13,900 11,400 9,000
Wheat, spring 235 5,100 9,100 13,900 11,400 9,000
Wheat, winter remaining 2632 2,200 .. .. .. ..
Quebec Barley 29 221,000 163,500 168,000 175,000 175,900
Canola 226 33,500 27,500 26,000 34,000 31,600
Corn for grain 215 3,775,000 3,027,000 3,760,000 3,790,000 3,691,500
Flaxseed 220  (T)  (T)  (T)  (T)  (T)
Oats 29 189,000 191,500 249,000 200,000 146,700
Soybeans 221 847,000 898,000 1,088,100 1,129,400 1,105,100
Wheat, all 2434 183,300 204,500 281,500 310,000 312,800
Wheat, spring 235 158,500 184,000 245,000 257,000 252,700
Wheat, winter remaining 2632 24,800 20,500 36,500 53,000 60,100
Ontario Barley 29 134,600 151,300 158,900 130,600 114,100
Canola 226 49,900 31,300 34,000 37,100 42,400
Corn for grain 215 9,007,300 7,600,000 8,839,600 8,052,200 8,977,000
Flaxseed 220  (T)  (T)  (T)  (T)  (T)
Oats 29 75,600 70,900 154,200 64,800 65,200
Soybeans 221 3,238,600 3,791,100 3,728,500 3,374,700 4,105,700
Wheat, all 2434 2,391,500 1,750,000 1,551,300 2,541,900 2,266,600
Wheat, spring 235 113,600 122,500 217,700 130,600 140,800
Wheat, winter remaining 2632 2,277,900 1,627,500 1,333,600 2,411,300 2,125,800
East Barley 29 488,800 417,200 439,800 412,100 389,200
Canola 226 89,500 58,800 60,000 71,100 74,000
Corn for grain 215 12,908,500 10,699,400 12,684,100 11,961,100 12,809,100
Oats 29 298,800 302,300 453,300 309,800 256,100
Soybeans 221 4,172,300 4,777,600 4,888,800 4,580,600 5,292,000
Wheat, all 2434 2,617,700 2,005,700 1,906,400 2,924,800 2,652,400
Wheat, spring 235 299,600 342,000 512,400 433,700 444,200
Wheat, winter remaining 2632 2,318,100 1,663,700 1,394,000 2,491,100 2,208,200
Prairie provinces 33 Barley 29 9,662,500 6,659,100 7,718,400 8,312,700 6,875,200
Canary seed 131,000 124,900 148,600 140,300 116,300
Canola 226 18,372,800 16,279,400 18,245,700 19,447,800 19,559,500
Chick peas 2 169,400 123,000 83,500 75,200 75,000
Corn for grain 215 1,285,300 787,400 875,000 1,232,000 1,503,500
Flaxseed 220 730,700 872,500 942,300 588,000 501,200
Lentils 2,261,700 1,987,000 2,540,500 3,248,200 2,438,600
Mustard seed 24 154,500 198,000 123,400 235,600 114,900
Oats 29 3,520,900 2,624,900 2,916,400 2,828,500 3,489,100
Soybeans 221 1,186,600 1,271,000 1,570,300 1,971,500 3,029,100
Sunflower seed 27 51,900 55,000 72,600 50,600 52,300
Wheat, all 2434 34,760,100 27,304,500 25,552,800 28,664,200 24,418,600
Wheat, durum 2 6,504,500 5,192,700 5,388,700 7,761,800 4,299,300
Wheat, spring 235 26,787,300 20,846,300 19,315,000 19,880,500 19,572,900
Wheat, winter remaining 2632 1,468,300 1,265,500 849,100 1,021,900 546,400
Manitoba Barley 29 705,400 354,900 566,100 540,000 407,600
Canary seed .. .. .. .. ..
Canola 226 3,025,500 2,510,600 2,857,600 2,608,200 3,007,700
Corn for grain 215 1,219,300 696,000 787,400 1,168,500 1,382,600
Flaxseed 220 72,800 78,700 71,100 59,700 34,600
Lentils .. .. .. .. ..
Mustard seed 24 .. .. .. .. ..
Oats 29 590,700 524,400 595,300 550,600 795,800
Soybeans 221 1,068,200 1,107,700 1,390,700 1,769,000 2,482,100
Sunflower seed 27 51,900 55,000 72,600 50,600 52,300
Wheat, all 2434 5,160,000 3,797,500 4,218,300 4,217,500 3,848,800
Wheat, durum 2 .. .. .. .. ..
Wheat, spring 235 4,376,200 3,326,700 3,850,900 3,895,000 3,732,000
Wheat, winter remaining 2632 783,800 470,800 367,400 322,500 116,800
Saskatchewan Barley 29 3,411,700 2,172,900 2,863,100 3,374,700 2,672,900
Canary seed 131,000 124,900 148,600 140,300 116,300
Canola 226 9,178,400 7,971,900 9,536,800 10,682,100 9,744,500
Chick peas 2 169,400 123,000 83,500 75,200 75,000
Corn for grain 215     .. .. ..
Flaxseed 220 584,200 706,200 787,400 473,700 404,600
Lentils 2,151,400 1,902,600 2,364,100 2,742,000 2,187,300
Mustard seed 24 117,300 138,600 91,500 162,300 85,300
Oats 29 2,328,700 1,557,600 1,927,800 1,653,300 2,077,400
Soybeans 221 118,400 163,300 179,600 202,500 547,000
Sunflower seed 27 .. .. .. .. ..
Wheat, all 2434 18,298,300 14,158,100 13,044,500 14,548,500 10,905,800
Wheat, durum 2 5,633,600 4,485,100 4,572,200 6,177,900 3,230,400
Wheat, spring 235 12,241,500 9,150,500 8,216,500 7,989,600 7,414,800
Wheat, winter remaining 2632 423,200 522,500 255,800 381,000 260,600
Alberta Barley 29 5,545,400 4,131,300 4,289,200 4,398,000 3,794,700
Canary seed .. .. .. .. ..
Canola 226 6,168,900 5,796,900 5,851,300 6,157,500 6,807,300
Chick peas 2 .. .. .. .. ..
Corn for grain 215 66,000 91,400 87,600 63,500 120,900
Flaxseed 220 73,700 87,600 83,800 54,600 62,000
Lentils 110,300 84,400 176,400 506,200 251,300
Mustard seed 24 37,200 59,400 31,900 73,300 29,600
Oats 29 601,500 542,900 393,300 624,600 615,900
Sunflower seed 27 .. .. .. .. ..
Wheat, all 2434 11,301,800 9,348,900 8,290,000 9,898,200 9,664,000
Wheat, durum 2 870,900 707,600 816,500 1,583,900 1,068,900
Wheat, spring 235 10,169,600 8,369,100 7,247,600 7,995,900 8,426,100
Wheat, winter remaining 2632 261,300 272,200 225,900 318,400 169,000
British Columbia Barley 29 85,800 42,700 67,500 58,800 41,100
Canola 226 88,700 71,900 70,800 81,600 74,400
Flaxseed 220  (T)  (T)  (T)  (T)  (T)
Oats 29 85,900 51,800 58,000 56,300 57,000
Wheat, all 2434 151,800 109,400 134,900 139,600 58,800
Wheat, spring 235 151,800 109,400 134,900 139,600 58,800
Wheat, winter remaining 2632 .. .. .. .. ..
West Barley 29 9,748,300 6,701,800 7,785,900 8,371,500 6,916,300
Canary seed 131,000 124,900 148,600 140,300 116,300
Canola 226 18,461,500 16,351,300 18,316,500 19,529,400 19,633,900
Chick peas 2 169,400 123,000 83,500 75,200 75,000
Corn for grain 215 1,285,300 787,400 875,000 1,232,000 1,503,500
Flaxseed 220 730,700 872,500 942,300 588,000 501,200
Lentils 2,261,700 1,987,000 2,540,500 3,248,200 2,438,600
Mustard seed 24 154,500 198,000 123,400 235,600 114,900
Oats 29 3,606,800 2,676,700 2,974,400 2,884,800 3,546,100
Soybeans 221 1,186,600 1,271,000 1,570,300 1,971,500 3,029,100
Sunflower seed 27 51,900 55,000 72,600 50,600 52,300
Wheat, all 2434 34,911,900 27,413,900 25,687,700 28,803,800 24,477,400
Wheat, durum 2 6,504,500 5,192,700 5,388,700 7,761,800 4,299,300
Wheat, spring 235 26,939,100 20,955,700 19,449,900 20,020,100 19,631,700
Wheat, winter remaining 2632 1,468,300 1,265,500 849,100 1,021,900 546,400


Note: As of October 4, 2017, data for reference year 2017 in this CANSIM table 001-0010 has been updated and now reflects field crops data as published on September 19 in CANSIM table 001-0075 (Model-based Principal Field Crop Estimates). Also, in the fall of 2017, data from CANSIM table 001-0010 (field crops data expressed in metric units of measure) will be transfered over to CANSIM table 001-0017. Therefore all of the crops data on areas, yields and production, whether expressed in imperial or metric units of measure, will be available from then on under CANSIM table 001-0017 only. Table 001-0010 will then be deleted as a result of this merge process.

Symbol legend:

..
Not available
(T) 
Series is terminated

Footnotes:

Farm surveys collect data from Quebec, Ontario, Manitoba, Saskatchewan and Alberta at all five survey occasions during the crop year (which extends from the December to the following November occasion). However, data are collected twice a year (in the June Farm survey on seeded areas and in the November Farm survey on final crop production) for Newfoundland and Labrador, Prince Edward Island, Nova Scotia, New Brunswick and British Columbia, which represent between 2% and 4% of national totals. As of July 2014 for the Atlantic provinces and British Columbia, July and September production estimates are calculated using the final estimates of the last three crop years. The harvested area is first estimated based on the ratio obtained from the sum of harvested areas of the last three years over the sum of the seeded areas of the last three years. This average ratio is applied to their current year's reported seeded acreage from the June survey. This estimated harvested area is then multiplied by the average yield of the last three years to estimate production.
For imperial data see CANSIM table 001-0017.
Seeded area, yield and production of all wheat in Alberta include relatively small estimates of winter wheat for years 1921 to 1977.
Data begin in 1908 for Ontario, in 1976 for Canada, Prairies and Alberta, in 1981 for Saskatchewan, in 1986 for Prince Edward Island, Nova Scotia, New Brunswick, Quebec and Manitoba. Average farm price began in 1978.
Data for British Columbia begin in 1910.
Data for Nova Scotia were discontinued in 1931, re-activated in 1981 and discontinued again in 1986. Data for New Brunswick were also discontinued in 1931. Data for Quebec were discontinued in 1981 and re-activated in 1991. Data for British Columbia begin in 1910.
Data for Quebec were discontinued in 1981 and re-activated in 1991. Data for Nova Scotia begin in 1981 and ends in 1986. Data for the Prairies begin in 1976. Prior to 1977, data for Quebec, Ontario and British Columbia are the same as all rye.
Data for Manitoba were discontinued in 1987.
Data for the three Prairie provinces and British Columbia begin in 1910. Nova Scotia, New Brunswick and British Columbia data were discontinued in 1987, but data for New Brunswick were re-activated in 1991.
Data were discontinued between 1932 and 1966 for Quebec. Data began in 1941 for Manitoba, in 1979 for Alberta and in 1983 for Nova Scotia.
Data were discontinued in 1941 for Prince Edward Island and Nova Scotia. Ontario data were discontinued in 1980 and re-activated in 1986. Data for Manitoba begin in 1925.
Data were discontinued in 1931 for Prince Edward Island, Nova Scotia and New Brunswick, in 1974 for Ontario and in 1975 for Quebec. Saskatchewan and Alberta data begin in 1910. Data for British Columbia also begin in 1910 but were discontinued in 1977 and re-activated in 1995.
Data were discontinued in 1931 for Nova Scotia, in 1939 for Saskatchewan and in 1941 for New Brunswick and British Columbia. Data for Alberta were discontinued in 1941 and re-activated in 1991. Data for Quebec were discontinued in 1976 and re-activated in 1991. Data begin in 1991 for Manitoba, in 1918 for Saskatchewan and Alberta and in 1910 for British Columbia.
Data for Quebec begin in 1910 and were discontinued in 1972. Data for Ontario also begin in 1910, but were discontinued in 1973, and data for British Columbia begin in 1924 and were discontinued in 1972.
Most of the soybean crop is grown in Ontario but it was also grown in small areas in other provinces in the years 1942 to 1945. The total for Canada includes this production but provincial data are not shown. Data begin in 1991 for Prince Edward Island and in 1986 for Quebec. Data for Manitoba begin in 1956 and were discontinued in 1960.
Data begin in 1952 for Manitoba and in 1960 for Saskatchewan.
Estimates are not available for small area, which were grown in Alberta and Ontario between 1943 and 1945. Data begin in 1996 for Quebec, in 1983 for Ontario, in 1955 for Alberta and in 1967 for British Columbia.
Data for Saskatchewan begin in 1943 and were discontinued in 1946, and began again in 1963. Data for Alberta begin in 1958 and were discontinued in 1974, and began again in 1986.
Data for Quebec begin in 1944 and were discontinued in 1986. Data for Ontario were discontinued in 1968 due to shutdown of processing facilities at Chatham. Data for Manitoba begin in 1940 and were discontinued in 1997.
Data for Prince Edward Island, Nova Scotia and New Brunswick were discontinued in 1941 and re-activated in 1975. Data for Prince Edward Island and New Brunswick were discontinued again in 1987 and data for New Brunswick were re-reactivated in 1991. Data were discontinued in 1972 for Saskatchewan and in 1953 for Alberta. Data for the Prairie provinces and British Columbia begin in 1910. Data for Canada do not include production data for the Maritime provinces in 1975.
Totals may not equal the sum of their parts due to the use of conversion factors or rounding of fractions to whole numbers.
Winter wheat remaining and fall rye remaining indicate the areas seeded in the fall of the previous year that are remaining after winterkill.
Prairies includes Manitoba, Alberta and Saskatchewan, but excludes British Columbia.
All wheat includes spring wheat, durum wheat and winter wheat seeded in the fall.
The spring wheat breakdown is only available for the Western provinces. The spring wheat total at the Canada level includes spring wheat from the Eastern provinces and the spring wheat breakdown from the Western provinces.
All rye includes spring rye and fall rye seeded in the fall.
Respondents are asked to report the percentage moisture of their harvested fodder corn. Estimates of production for fodder corn are calculated using a standard percentage moisture content of 70%.
Respondents are asked to report the percentage moisture of their harvested hay for silage. Estimates of production for total hay is reported at a standard dry matter content of 90%.
The category Tame hay above represents the sum of estimates originally reported under the 2 following questionnaire categories: Alfalfa and alfalfa mixtures and Other tame hay.

Source:  Statistics Canada. Table  001-0010 -  Estimated areas, yield, production and average farm price of principal field crops, in metric units, annual,  CANSIM (database). (accessed: )
Back to search

Add/Remove data

Select the specific items from each step to create your customized CANSIM table.

Step 1- Select: Geography  

(15 of 15 items selected)
D1-picklist-container

Step 2- Select: Harvest disposition  

(1 of 5 items selected)
D2-picklist-container

Step 3- Select: Type of crop  

(15 of 44 items selected)
D3-picklist-container

Step 4 - Select the time frame

By default, only data for the most recent periods available will be retrieved. You may use the lists below to select a different time frame.
From :  To : (Annual data)

Step 5 - Select the Screen output format






Step 6

 

Download

Select an option to download data in the desired format.

Option 1 - Download data as displayed in the Data table tab
 

 

 




Option 2 - Download entire table
(Files modified on 2017-10-04)



Data table will contain:
Note: 
Statistics Canada assumes responsibility for the quality of data as retrieved with the frequency unchanged. Clients take responsibility for any manipulations made to the original data.
Frequency of data is already of annual frequency or greater, therefore no frequency conversion options are presented.
View additional information related to this table.

Related data tables
Crops and horticulture
Display list of  Summary tables derived from this table.

Related publications
View latest article from The Daily related to this table.
View list of related publications.

Additional information on the survey or statistical program


Help

Data table

When first opening a CANSIM table, the data that is shown is considered the initial view. Depending on the size of the CANSIM table, this table might only represent a summary with five reference periods, if available. You can use the Add/Remove data tab to add or remove data.

To download the entire table, select option 2 in the Download tab.

Add/Remove data

The Add/Remove data tab is a pick list where you choose which subset of the selected table you want to work with. There is one scrollable pick list for each dimension in the table and you must select at least one item from each list before selecting Apply.

An All checkbox appears under each dimension title and just above the scrollable list. Level checkboxes will appear for dimensions containing hierarchies. An Expand/Collapse option is available near the scrollable list which lets you open a dimension to see the list of its members/items.

Before proceeding with the request, check the data ranges for which data is available and reduce this range if you wish; data retrievals are faster when the time period is short. Also, you can select one of four options of a screen output format, default being HTML table, times as column.

Once done with your selections, select Apply to view your customized selection, or select Back to original table to return the selections back to the CANSIM initial view that was shown when first opening the table.

Note: There is no guarantee that data exist for every intersection of every dimension; so it is possible that even if you have selected at least one member/item from all the lists you might still be warned that your retrieval contains no series.

Note: If the designation (Terminated) appears at the end of a member/item name that member/item is terminated. Time series attached to a terminated member/item may be revised, but are no longer updated and may not contain data for the most recent time periods.

Tips for selecting members/items:

  • You can select all members/items in a hierarchical level by selecting the corresponding level.

Note: If you receive an error message after selecting your members from the pick list it's either because your request does not contain series or one member/item has not been selected from a dimension.

Manipulate

Statistics Canada assumes responsibility for the quality of data as retrieved with the frequency unchanged. Clients take responsibility for any manipulations made to the original data.

Frequency of output data will be:

The frequency conversion options are particularly useful to convert data from one frequency to another for comparability purposes.

Note: When frequency of data is already of annual frequency or greater, then no frequency conversion options are presented. Certain series can only be aggregated by specific methods. If the frequency conversion chosen is not allowed, resultant data will appear as "..".

Converted to:

The frequency designates how often data observations are published. A table can contain only one frequency. By default, the frequency of output data will be left unchanged.

Frequency can be converted by these choices:

  • Annual average: Conversion by averaging is more appropriate for "balance"-type data such as "Population as of July 1" as well as rates and indexes.
  • Annual sum: Conversion to a sum should not be performed on a rate or index. Conversion by summing is more appropriate for "count"-type data, such as "Number of cars sold" or "Number of births".
  • Quarterly average: Conversion by averaging is more appropriate for "balance"-type data such as "Population as of July 1" as well as rates and indexes.)
  • Quarterly sum: Conversion by summing is more appropriate for "count"-type data, such as "Number of cars sold" or "Number of births".
  • Annual - convert to annual by selecting a specific month or quarter: This type of calculation is most useful when data for a specific sub-annual period (month or quarter) is used to state an annual figure such as "Population as of July 1".

When converting frequency by summing or averaging:

Two choices are offered when converting frequency using either a sum or an average:

  • Use calendar year: This is a normal calendar year starting in January and ending in December.
  • Use fiscal year ending with last month retrieved: The annual non-calendar fiscal year average manipulation permits users to calculate the average value for the last twelve months ending with the most recent reference period selected. In order to complete this calculation, please follow these steps:
    • In the section entitled "Frequency of output data will be:" sub-section "Standard frequency conversion options" select "Annual (average)".
    • In the section "When converting frequency by summing or averaging:" select "Use fiscal year ending with last month retrieved".
    • If you wish the output of your data as a percentage change from the previous year please select "Percent changes, year-to-year" found below "Data table will contain:"

Data table will contain:

Select one of these data transformations options to convert your data:

  • Percent changes, period-over-period: If the frequency of the data is monthly, the calculation would measure the change of the data value in percent between consecutive time periods, (for example: between July 1998 and August 1998.)
  • Percent changes, year-over-year: If the frequency of the data is monthly, the calculation would measure the change of the data value in percent between consecutive years, (for example: between July 1998 and July 1999).
  • Year-to-date sums: Data for each sub-annual period is added consecutively to the previous period showing cumulative sums for each period.
  • Year-to-date average: Data for each sub-annual period is averaged consecutively to the previous period showing cumulative averages for each period.

Note: CANSIM rounds data using statistician's rounding (also known as round-to-even method, unbiased rounding, convergent rounding and banker's rounding) which may differ from rounding methods used by common spreadsheet software.

Statistician's rounding rounds the following way:

  • If the second decimal is larger than 5, the first decimal is incremented by 1 (see example 1).
  • If the second decimal is smaller than 5, the first decimal stays unchanged (see example 2).
  • When the second decimal is exactly 5, the "odd/even" rules apply. The first decimal is incremented by 1 if it is odd (see example 4), and left unchanged if it is even (see example 3).
  • Example:
    1. 4.46 rounded to one decimal equals 4.5
    2. 4.44 rounded to one decimal equals 4.4
    3. 4.45 rounded to one decimal equals 4.4
    4. 4.15 rounded to one decimal equals 4.2

Once you made your selections select the Apply button.

Download

Option 1 - Download data as displayed in the Data table tab

This option downloads your selection and is displayed in the Data table tab or you can modify using the download options.

Three download options are available:

  • Select the language: You have the choice of the English or French language for the textual content.
  • Select the data output format type: You have the choice of the following six format types:
    • time as columns, where the time frame you have selected will be displayed in columns
    • time as rows, where the time frame you have selected will be displayed in rows.
    • for database loading, where you will download a flat format file ready for database loading
    • for database loading with data quality indicators, where you will download a flat format file including data quality indicators
    • time as columns with data quality indicators, where the time frame you have selected will be displayed in columns including data quality indicators
    • time as rows with data quality indicators, where the time frame you have selected will be displayed in rows including data quality indicators
  • Select the file format: you will have the choice of the following two output separator types:
    • CSV (comma-separated values) English spreadsheet is usually used when retrieving English tables with computers having their Regional set to English.

If your objective is to load the data into a spreadsheet package the best choice for output format is a comma-separated values (CSV) file.

Note: CSV and Semicolon-Separated Values (SCSV) files are produced differently whether you perform the retrieval in English or French. This is because, in French, the comma is used to indicate decimals; a different separator (a semicolon) must therefore be used. SCSV files retrieved in French will parse correctly only if the Regional Settings are set to French.

Once you made your selections select the Download data button.

Option 2 - Download entire table

You will have the option to Download entire table as a CSV file or a Beyond 20/20 or SDMX file which will open a new window.

This table represents all of the items in the CANSIM table. To get an initial view (summary) of the CANSIM table, select the Data table tab.

Note: Downloading tables in Beyond 20/20 output format requires the Beyond 20/20 Table Browser.

Once you made your selections select the Download entire table button.

Related information

This page contains links to items related to your CANSIM table. Select the various links to view these related items.

Related data tables

View a list of related CANSIM tables that are related to this CANSIM table.

Related publications

View the latest article from The Daily and a list of related publications from Statistics Canada.

The Daily is Statistics Canada's official release bulletin, the Agency's first line of communication with the media and the public. The Daily issues news releases on current social and economic conditions and announces new products. It provides a comprehensive one-stop overview of new information available from Statistics Canada.

Additional information on the survey or statistical program

Definitions, data sources and methods: Here is where you will find a link to the Integrated Meta Data Base (IMDB) where you may view details for the survey number(s) assigned to the CANSIM table.

The Integrated Meta Data Base (IMDB) contains information about the surveys and statistical programs carried out by Statistics Canada and other agencies to collect assemble process and disseminate statistical information.

The IMDB may be used to find out how data for particular CANSIM tables are collected or to identify contacts for questions on the data or survey methodology. The IMDB contains descriptions of over 450 surveys and statistical programs each identified by a unique four-digit survey number.

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