Table 203-0028 3456
Survey of household spending (SHS), detailed food expenditures, Canada, regions and provinces
annual (dollars)


Data table

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

Selected items [Add/Remove data]
Geography = Canada 7
Statistic = Average expenditure per household
by Food expenditures, summary-level categories; Geography= Canada; Statistic= Average expenditure per household
Survey of household spending (SHS), detailed food expenditures, Canada, regions and provinces, annual (dollars)
Food expenditures, summary-level categories 2012 2013 2014 2015 2016
footnotes
Food expenditures 1 7,760 7,934 8,109 8,629 8,784
Food purchased from stores 5,564 5,718 5,880 6,126 6,176
Bakery products 531 567 562 574 578
Bread and unsweetened rolls and buns 251 264 257 256 264
Cookies and crackers 126 118 115 126 123
Other bakery products 154 185 191 192 192
Other bakery products (except frozen) 140 170 173 175 169
Frozen bakery products 13 16 18 17 22
Cereal grains and cereal products 359 320 327 341 347
Rice and rice mixes 34 35 41 40 44
Pasta products 70 55 54 53 59
Pasta (fresh or dry) 49 36 39 39 42
Pasta (canned) 5 6 4 4 3
Pasta mixes 15 13 11 11 14
Other cereal grains and cereal products 256 230 231 248 244
Flour and flour-based mixes 24 23 28 23 26
Breakfast cereal and other grain products (except infant) 233 207 204 225 218
Breakfast cereal (except infant cereals) 110 93 85 103 89
Cereal bars 50 45 45 47 53
Cereal-based snack food 63 61 63 61 64
Other cereal grains (unmilled or milled) 10 7 10 13 12
Fruit, fruit preparations and nuts 696 698 719 755 781
Fresh fruit 420 432 465 473 492
Apples (fresh) 60 62 64 70 69
Bananas and plantains (fresh) 52 58 57 57 53
Grapes (fresh) 48 44 49 52 53
Peaches and nectarines (fresh) 15 14 23 15 20
Peaches (fresh) 9 9 12 10 9
Nectarines (fresh) 6 5 11 5 11
Pears (fresh) 14 13 15 18 17
Berries (fresh) 108 105 120 105 117
Strawberries (fresh) 41 38 38 39 42
Other berries (fresh) 67 67 82 66 74
Citrus fruit (fresh) 57 66 72 81 80
Other fruit (fresh) 64 71 64 74 83
Preserved fruit and fruit preparations 208 191 173 187 203
Fruit juice 107 105 90 93 97
Ready-to-drink citrus juice 49 50 38 40 40
Other ready-to-drink fruit juices 58 53 50 51 56
Concentrated fruit juice (frozen) 1 F 2 2 1
Other preserved fruit and fruit preparations 101 85 82 94 106
Preserved fruit (including canned fruit pie filling and frozen fruit) 30 33 31 37 48
Canned or bottled fruit 19 20 18 18 21
Fruit pie filling 2 1 1 1 2
Frozen fruit 9 11 12 19 25
Dried or other preserved fruit 30 17 17 22 23
Raisins 5 5 5 5 6
Other dried or preserved fruit 25 12 12 17 17
Jams, jellies, marmalades and similar preserves 15 11 14 14 14
Fruit drinks (canned, bottled or frozen) 26 24 21 20 21
Nuts and seeds 68 76 81 96 85
Peanuts (shelled or unshelled) 8 10 11 11 13
Other nuts and seeds 60 66 70 84 72
Vegetables and vegetable preparations 578 652 675 710 718
Fresh vegetables 422 497 515 537 551
Potatoes (except sweet potatoes) 46 48 48 43 46
Tomatoes (fresh) 49 62 60 60 65
Lettuce (fresh) 32 36 39 41 42
Cabbage (fresh) 11 14 14 16 19
Carrots (fresh) 24 26 27 27 26
Onions (fresh) 33 38 42 39 48
Celery (fresh) 12 12 11 13 13
Cucumber (fresh) 23 29 28 28 30
Mushrooms (fresh) 26 28 29 27 30
Broccoli (fresh) 17 17 19 21 20
Other vegetables (fresh) 115 145 151 176 163
Frozen and dried vegetables 46 40 43 40 48
Potato products (frozen) 16 17 17 16 15
Other frozen vegetables 22 18 19 17 23
Dried vegetables and legumes 7 5 6 7 10
Canned vegetables and other vegetable preparations 110 115 117 133 118
Canned or bottled vegetables 43 43 42 47 44
Tomatoes (canned or bottled, including tomato paste) 13 13 14 15 13
Peas (canned or bottled) 4 4 3 4 3
Beans (canned or bottled) 6 6 6 6 6
Other vegetables or legumes (canned or bottled, except infant food) 20 19 18 22 21
Ready-to-serve or ready-to-cook prepared salads and side dishes, fruit or vegetable based 52 59 64 72 69
Vegetable juice (canned or bottled) 14 13 11 14 6
Tomato juice (canned or bottled) 5 5 3 4 1
Other vegetable juice (canned or bottled) 10 7 8 10 5
Dairy products and eggs 855 876 864 903 888
Cheese 292 274 281 287 293
Cheddar cheese 74 80 72 79 78
Mozzarella cheese 28 23 32 28 28
Processed cheese 43 36 38 35 35
Other cheeses 148 136 140 145 153
Milk 223 218 202 217 195
Butter 34 38 38 42 43
Ice cream and ice milk (including novelties) 51 57 61 60 59
Other dairy products 182 211 204 213 209
Dairy product substitutes 19 24 23 24 29
Eggs and other egg products 72 78 76 84 89
Meat 1,042 1,044 1,182 1,194 1,163
Beef 262 258 315 301 316
Pork 106 113 137 130 110
Poultry 247 265 271 295 263
Other meat and poultry 25 27 41 33 29
Processed meat 401 380 419 435 445
Bacon and ham 54 49 63 63 63
Other processed meat 348 331 356 372 382
Sausage and wieners 67 73 77 77 83
Deli and deli-style meat 166 143 149 159 148
Other meat preparations 114 115 130 135 150
Other meat preparations (frozen or prepared) 104 104 123 126 137
Meat stew and other meat preparations (canned) 10 11 7 10 14
Fish and seafood 178 200 211 213 203
Fresh or frozen fish 87 99 99 114 96
Salmon (fresh or frozen, uncooked) 43 51 50 54 45
Other fish (fresh or frozen, uncooked) 29 36 33 43 32
Canned fish or other preserved fish 35 37 37 37 35
Tuna (canned) 19 16 19 16 17
Salmon (canned) 8 6 6 8 5
Cured fish 4 10 8 8 10
Other fish (canned or bottled) 4 4 5 6 3
Seafood and other marine products 55 64 75 61 72
Shrimp and prawns 29 36 41 34 42
Other seafood and marine products 27 27 34 27 30
Non-alcoholic beverages and other food products 1,326 1,362 1,342 1,437 1,499
Non-alcoholic beverages and beverage mixes 356 361 373 396 424
Coffee and tea 128 131 153 163 175
Roasted and ground coffee 77 80 98 114 109
Instant and other coffee 27 22 22 18 30
Tea (including herbal) 24 29 33 30 35
Non-alcoholic beverages 228 230 220 233 249
Carbonated soft drinks 100 104 96 97 103
Carbonated water and flavoured water 19 11 11 14 14
Bottled water 44 48 41 41 41
Meal replacement (powder and drink) 28 33 27 32 48
Sports and energy drinks 14 15 14 24 21
Other non-alcoholic beverages 24 19 29 25 22
Sugar and confectionery 249 244 248 270 275
Sugar, syrups and sugar substitutes 47 52 47 45 50
Sugar 19 20 20 15 18
Artificial sweeteners 4 5 4 3 F
Syrups and molasses 12 16 13 18 13
Sugar preparations for baking and desserts 4 5 4 4 6
Other sugar, confections and preparations 7 6 5 5 10
Candies and chocolates 202 191 201 225 224
Chocolate bars 70 70 73 85 82
Other chocolate confections 47 49 45 53 57
Baking chocolate, cocoa and chocolate substitutes 10 9 10 11 11
Sugar candy 56 47 58 57 54
Gum 19 16 15 18 20
Margarine, oils and fats (excluding butter) 61 69 60 69 67
Margarine 26 27 21 25 21
Cooking and salad oils 30 38 36 40 43
Other oils and fats 5 4 4 5 3
Condiments, spices and vinegars 208 218 229 237 240
Mayonnaise, salad dressings and dips 54 56 51 55 54
Pasta and pizza sauces (canned, bottled or dried) 27 26 29 26 29
Other sauces and gravies (canned, bottled or dried) 35 39 43 37 35
Dried herbs and spices 15 20 22 19 20
Food seasonings (including table salt) 22 26 28 32 36
Ketchup 11 9 10 10 9
Pickled vegetables (including olives) 16 19 18 23 25
Fresh herbs 8 8 14 12 12
Other condiments (including vinegar) 21 16 16 22 20
Infant food 31 31 14 27 16
Frozen prepared food 133 147 116 121 140
Soup (except infant soup) 59 54 54 56 56
Ready-to-serve prepared food 68 59 65 75 81
Snack food 71 75 80 83 86
Potato-based snack foods 59 67 69 72 66
Other snack foods 12 9 11 11 19
Other food preparations 91 105 104 102 114
Peanut butter and other nut butters 23 30 25 26 30
Honey 8 10 17 11 12
Dessert powders 14 15 15 13 14
Tofu 7 7 9 8 15
Other canned, bottled or dried meals 6 5 4 5 5
Other materials for food preparation 17 17 18 21 18
Food purchased from restaurants 2,195 2,216 2,229 2,502 2,608
Restaurant meals 1,921 1,963 1,959 2,222 2,303
Restaurant snacks and beverages 274 253 270 281 305

Symbol legend:

F
Too unreliable to be published

Footnotes:

Does not include day board paid to other private households, which is now included in childcare expenses in household operations.
This table includes the data previously found in CANSIM table 203-0029, which has been archived.
For more information about survey methodology, data quality, variable definitions and data products, see the Survey of Household Spending User Guide (catalogue number 62F0026MIE) available free on the Statistics Canada website: http://www5.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=62F0026M&chropg=1&lang=eng, Household expenditures research papers series.
The Survey of Household Spending uses survey weights which take into account population projections from the 2011 Census.
To ensure data quality, suppression of expenditure estimates is based on the coefficient of variation (CV). Expenditures that have a CV greater than or equal to 35% are suppressed as they are too unreliable to be published.
Canada-level statistics include the 10 provinces only.

Source:  Statistics Canada. Table  203-0028 -  Survey of household spending (SHS), detailed food expenditures, Canada, regions and provinces, annual (dollars),  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  

(1 of 13 items selected)
D1-picklist-container

Step 2- Select: Statistic  

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

Step 3- Select: Food expenditures, summary-level categories  

(174 of 256 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-12-13)



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
Household spending and savings 
Household characteristics
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.