Table 384-0042
Selected indicators - Households
annual (dollars unless otherwise noted)


Data table

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

Selected items [Add/Remove data]
by Geography; by Estimates;
Selected indicators - Households, annual (dollars unless otherwise noted)
Geography Estimates 2010 2011 2012 2013 2014 2015
footnotes
Canada 3 Household income (x 1,000,000) 1,368,072 1,433,722 1,496,424 1,556,048 1,610,994 1,677,218
Compensation of employees (x 1,000,000) 6 835,940 881,145 921,490 959,181 995,737 1,023,722
Net mixed income (x 1,000,000) 147,213 153,535 158,536 162,998 166,007 173,233
Property income received (x 1,000,000) 152,519 162,165 170,336 175,342 182,442 196,004
Current transfers received (x 1,000,000) 232,400 236,877 246,062 258,527 266,808 284,259
Household outlays (x 1,000,000) 1,367,349 1,439,676 1,494,613 1,548,774 1,619,212 1,670,619
Property income paid (x 1,000,000) 54,143 54,580 55,598 56,232 55,577 55,229
Current transfers paid (x 1,000,000) 389,755 421,185 443,969 457,738 480,087 499,425
Household final consumption expenditure (x 1,000,000) 923,451 963,911 995,046 1,034,804 1,083,548 1,115,965
Interest paid (x 1,000,000) 1 73,377 75,350 75,273 76,560 76,948 76,533
Mortgage interest paid (x 1,000,000) 1 38,482 39,086 39,194 40,200 40,500 39,252
Non-mortgage interest paid (x 1,000,000) 1 34,895 36,264 36,079 36,360 36,448 37,281
Divided by: household disposable income (x 1,000,000) 12 997,551 1,033,307 1,072,130 1,118,638 1,152,278 1,199,097
Equals: debt service ratio, interest only (ratio) 1 7.36 7.29 7.02 6.85 6.68 6.39
Newfoundland and Labrador Household income (x 1,000,000) 19,424 20,905 22,403 23,530 24,315 25,260
Compensation of employees (x 1,000,000) 6 11,760 12,756 13,755 14,648 15,259 15,746
Net mixed income (x 1,000,000) 1,772 1,997 2,100 2,216 2,273 2,407
Property income received (x 1,000,000) 1,333 1,451 1,524 1,507 1,556 1,588
Current transfers received (x 1,000,000) 4,559 4,701 5,024 5,159 5,227 5,519
Household outlays (x 1,000,000) 19,268 20,539 21,746 22,807 23,630 24,206
Property income paid (x 1,000,000) 567 571 597 615 605 645
Current transfers paid (x 1,000,000) 5,455 6,015 6,519 6,890 7,084 7,344
Household final consumption expenditure (x 1,000,000) 13,246 13,953 14,630 15,302 15,941 16,217
Interest paid (x 1,000,000) 1 808 835 846 876 860 902
Mortgage interest paid (x 1,000,000) 1 380 368 385 395 409 430
Non-mortgage interest paid (x 1,000,000) 1 428 467 461 481 451 472
Divided by: household disposable income (x 1,000,000) 12 14,210 15,154 16,133 16,901 17,486 18,173
Equals: debt service ratio, interest only (ratio) 1 5.69 5.51 5.24 5.18 4.92 4.96
Prince Edward Island Household income (x 1,000,000) 4,894 5,119 5,324 5,441 5,608 5,846
Compensation of employees (x 1,000,000) 6 2,752 2,905 3,016 3,122 3,240 3,360
Net mixed income (x 1,000,000) 566 605 642 632 627 662
Property income received (x 1,000,000) 479 491 501 492 512 517
Current transfers received (x 1,000,000) 1,097 1,118 1,165 1,195 1,229 1,307
Household outlays (x 1,000,000) 5,086 5,397 5,559 5,739 5,913 6,051
Property income paid (x 1,000,000) 159 185 171 176 168 166
Current transfers paid (x 1,000,000) 1,337 1,448 1,519 1,576 1,628 1,677
Household final consumption expenditure (x 1,000,000) 3,590 3,764 3,869 3,987 4,117 4,208
Interest paid (x 1,000,000) 1 224 264 241 244 230 229
Mortgage interest paid (x 1,000,000) 1 88 114 97 99 95 91
Non-mortgage interest paid (x 1,000,000) 1 136 150 144 145 135 138
Divided by: household disposable income (x 1,000,000) 12 3,622 3,750 3,875 3,933 4,042 4,232
Equals: debt service ratio, interest only (ratio) 1 6.18 7.04 6.22 6.20 5.69 5.41
Nova Scotia Household income (x 1,000,000) 34,509 35,668 36,686 37,690 38,695 39,924
Compensation of employees (x 1,000,000) 6 19,739 20,429 20,910 21,706 22,246 22,754
Net mixed income (x 1,000,000) 3,794 3,897 4,005 4,049 4,114 4,281
Property income received (x 1,000,000) 4,118 4,279 4,347 4,359 4,524 4,581
Current transfers received (x 1,000,000) 6,858 7,063 7,424 7,576 7,811 8,308
Household outlays (x 1,000,000) 36,586 38,309 39,309 40,240 41,568 42,485
Property income paid (x 1,000,000) 1,277 1,289 1,305 1,233 1,183 1,162
Current transfers paid (x 1,000,000) 10,222 10,797 11,095 11,245 11,790 12,346
Household final consumption expenditure (x 1,000,000) 25,087 26,223 26,909 27,762 28,595 28,977
Interest paid (x 1,000,000) 1 1,786 1,844 1,817 1,775 1,663 1,629
Mortgage interest paid (x 1,000,000) 1 783 782 769 789 772 722
Non-mortgage interest paid (x 1,000,000) 1 1,003 1,062 1,048 986 891 907
Divided by: household disposable income (x 1,000,000) 12 24,796 25,426 26,103 26,987 27,385 28,045
Equals: debt service ratio, interest only (ratio) 1 7.20 7.25 6.96 6.58 6.07 5.81
New Brunswick Household income (x 1,000,000) 26,653 27,637 28,600 29,351 30,130 31,292
Compensation of employees (x 1,000,000) 6 15,936 16,569 17,033 17,465 17,967 18,518
Net mixed income (x 1,000,000) 2,372 2,558 2,625 2,643 2,683 2,782
Property income received (x 1,000,000) 2,383 2,466 2,548 2,546 2,582 2,592
Current transfers received (x 1,000,000) 5,962 6,044 6,394 6,697 6,898 7,400
Household outlays (x 1,000,000) 27,136 28,427 29,210 30,053 31,049 32,014
Property income paid (x 1,000,000) 793 795 831 842 793 778
Current transfers paid (x 1,000,000) 7,497 7,890 8,166 8,395 8,703 9,226
Household final consumption expenditure (x 1,000,000) 18,846 19,742 20,213 20,816 21,553 22,010
Interest paid (x 1,000,000) 1 1,133 1,173 1,178 1,183 1,109 1,096
Mortgage interest paid (x 1,000,000) 1 489 470 496 509 490 453
Non-mortgage interest paid (x 1,000,000) 1 644 703 682 674 619 643
Divided by: household disposable income (x 1,000,000) 12 19,496 20,125 20,781 21,297 21,743 22,384
Equals: debt service ratio, interest only (ratio) 1 5.81 5.83 5.67 5.55 5.10 4.90
Quebec Household income (x 1,000,000) 290,604 304,487 318,665 327,421 337,170 347,738
Compensation of employees (x 1,000,000) 6 175,012 184,385 192,758 198,975 204,093 208,929
Net mixed income (x 1,000,000) 26,796 27,653 28,131 28,710 28,766 29,383
Property income received (x 1,000,000) 32,095 33,522 35,465 34,700 36,806 38,318
Current transfers received (x 1,000,000) 56,701 58,927 62,311 65,036 67,505 71,108
Household outlays (x 1,000,000) 296,697 310,890 322,428 332,060 343,091 350,953
Property income paid (x 1,000,000) 9,491 9,313 10,189 10,596 10,197 9,707
Current transfers paid (x 1,000,000) 92,889 99,840 105,095 107,419 112,148 116,206
Household final consumption expenditure (x 1,000,000) 194,317 201,737 207,144 214,045 220,746 225,040
Interest paid (x 1,000,000) 1 13,021 12,887 13,788 14,248 14,081 13,618
Mortgage interest paid (x 1,000,000) 1 7,181 6,815 7,580 7,775 7,348 6,770
Non-mortgage interest paid (x 1,000,000) 1 5,840 6,072 6,208 6,473 6,733 6,848
Divided by: household disposable income (x 1,000,000) 12 201,245 208,221 217,169 223,654 228,906 235,443
Equals: debt service ratio, interest only (ratio) 1 6.47 6.19 6.35 6.37 6.15 5.78
Ontario Household income (x 1,000,000) 537,935 558,599 574,627 593,755 614,027 642,357
Compensation of employees (x 1,000,000) 6 330,202 345,308 356,566 367,928 380,876 396,857
Net mixed income (x 1,000,000) 55,466 57,048 58,267 59,253 60,564 62,048
Property income received (x 1,000,000) 60,319 64,080 66,675 68,149 71,176 75,755
Current transfers received (x 1,000,000) 91,948 92,163 93,119 98,425 101,411 107,697
Household outlays (x 1,000,000) 531,035 557,403 575,670 593,135 622,285 647,583
Property income paid (x 1,000,000) 21,736 22,360 22,397 22,409 22,593 22,879
Current transfers paid (x 1,000,000) 151,114 161,972 170,346 173,992 183,303 192,046
Household final consumption expenditure (x 1,000,000) 358,185 373,071 382,927 396,734 416,389 432,658
Interest paid (x 1,000,000) 1 29,740 31,078 30,475 30,673 31,371 31,692
Mortgage interest paid (x 1,000,000) 1 14,717 15,745 15,348 15,742 16,421 16,271
Non-mortgage interest paid (x 1,000,000) 1 15,023 15,333 15,127 14,931 14,950 15,421
Divided by: household disposable income (x 1,000,000) 12 394,825 405,345 412,359 428,027 439,502 459,124
Equals: debt service ratio, interest only (ratio) 1 7.53 7.67 7.39 7.17 7.14 6.90
Manitoba Household income (x 1,000,000) 44,014 46,076 48,658 50,739 52,010 54,397
Compensation of employees (x 1,000,000) 6 26,648 27,936 29,320 30,634 31,518 32,565
Net mixed income (x 1,000,000) 5,129 5,376 5,834 6,052 6,086 6,571
Property income received (x 1,000,000) 4,459 4,716 4,982 5,026 5,260 5,463
Current transfers received (x 1,000,000) 7,778 8,048 8,522 9,027 9,147 9,797
Household outlays (x 1,000,000) 45,344 47,557 49,600 51,770 53,911 55,463
Property income paid (x 1,000,000) 1,538 1,503 1,596 1,606 1,520 1,510
Current transfers paid (x 1,000,000) 12,621 13,491 14,299 14,884 15,502 16,081
Household final consumption expenditure (x 1,000,000) 31,185 32,563 33,705 35,280 36,889 37,872
Interest paid (x 1,000,000) 1 2,063 2,088 2,162 2,165 2,047 2,047
Mortgage interest paid (x 1,000,000) 1 1,051 970 1,043 1,070 1,039 990
Non-mortgage interest paid (x 1,000,000) 1 1,012 1,118 1,119 1,095 1,008 1,057
Divided by: household disposable income (x 1,000,000) 12 31,918 33,170 34,925 36,414 37,035 38,853
Equals: debt service ratio, interest only (ratio) 1 6.46 6.29 6.19 5.95 5.53 5.27
Saskatchewan Household income (x 1,000,000) 42,302 45,854 48,844 52,210 52,846 55,143
Compensation of employees (x 1,000,000) 6 24,581 26,758 28,584 30,170 31,251 31,881
Net mixed income (x 1,000,000) 5,656 6,364 6,562 7,582 6,602 7,461
Property income received (x 1,000,000) 4,613 4,929 5,376 5,619 5,979 6,179
Current transfers received (x 1,000,000) 7,452 7,803 8,322 8,839 9,013 9,622
Household outlays (x 1,000,000) 42,136 44,849 47,719 50,405 52,608 53,660
Property income paid (x 1,000,000) 1,426 1,465 1,543 1,589 1,648 1,680
Current transfers paid (x 1,000,000) 11,861 13,061 14,265 15,097 15,511 15,938
Household final consumption expenditure (x 1,000,000) 28,849 30,323 31,911 33,719 35,449 36,042
Interest paid (x 1,000,000) 1 1,900 1,988 2,044 2,123 2,207 2,243
Mortgage interest paid (x 1,000,000) 1 844 823 867 889 969 979
Non-mortgage interest paid (x 1,000,000) 1 1,056 1,165 1,177 1,234 1,238 1,264
Divided by: household disposable income (x 1,000,000) 12 30,915 33,316 35,080 37,647 37,894 39,768
Equals: debt service ratio, interest only (ratio) 1 6.15 5.97 5.83 5.64 5.82 5.64
Alberta Household income (x 1,000,000) 182,706 195,856 211,858 225,923 239,003 246,781
Compensation of employees (x 1,000,000) 6 121,209 130,787 142,389 152,069 161,778 160,671
Net mixed income (x 1,000,000) 18,493 19,805 20,587 20,853 21,649 22,659
Property income received (x 1,000,000) 20,513 22,569 24,561 26,755 28,385 33,616
Current transfers received (x 1,000,000) 22,491 22,695 24,321 26,246 27,191 29,835
Household outlays (x 1,000,000) 172,603 185,188 195,868 208,745 221,079 224,624
Property income paid (x 1,000,000) 7,606 7,568 7,460 7,422 7,771 7,718
Current transfers paid (x 1,000,000) 49,600 55,453 59,641 64,018 67,138 68,934
Household final consumption expenditure (x 1,000,000) 115,397 122,167 128,767 137,305 146,170 147,972
Interest paid (x 1,000,000) 1 10,155 10,332 10,055 10,311 10,920 10,866
Mortgage interest paid (x 1,000,000) 1 5,453 5,387 5,151 5,283 5,726 5,554
Non-mortgage interest paid (x 1,000,000) 1 4,702 4,945 4,904 5,028 5,194 5,312
Divided by: household disposable income (x 1,000,000) 12 135,655 143,167 154,812 164,794 175,014 180,995
Equals: debt service ratio, interest only (ratio) 1 7.49 7.22 6.49 6.26 6.24 6.00
British Columbia Household income (x 1,000,000) 178,905 187,041 194,052 203,107 210,099 221,137
Compensation of employees (x 1,000,000) 6 103,864 108,841 112,543 117,735 122,616 127,436
Net mixed income (x 1,000,000) 26,532 27,547 29,063 30,266 31,879 34,193
Property income received (x 1,000,000) 21,889 23,318 23,991 25,809 25,272 26,965
Current transfers received (x 1,000,000) 26,620 27,335 28,455 29,297 30,332 32,543
Household outlays (x 1,000,000) 186,272 195,578 201,746 207,944 217,999 227,312
Property income paid (x 1,000,000) 9,427 9,404 9,382 9,624 8,976 8,857
Current transfers paid (x 1,000,000) 45,312 49,203 50,942 52,127 55,094 57,361
Household final consumption expenditure (x 1,000,000) 131,533 136,971 141,422 146,193 153,929 161,094
Interest paid (x 1,000,000) 1 12,384 12,685 12,495 12,788 12,288 12,038
Mortgage interest paid (x 1,000,000) 1 7,413 7,520 7,370 7,559 7,134 6,895
Non-mortgage interest paid (x 1,000,000) 1 4,971 5,165 5,125 5,229 5,154 5,143
Divided by: household disposable income (x 1,000,000) 12 136,550 141,119 146,223 154,144 158,317 166,957
Equals: debt service ratio, interest only (ratio) 1 9.07 8.99 8.55 8.30 7.76 7.21
Yukon Household income (x 1,000,000) 1,808 1,942 2,032 2,065 2,119 2,191
Compensation of employees (x 1,000,000) 6 1,120 1,219 1,261 1,289 1,321 1,334
Net mixed income (x 1,000,000) 252 274 290 307 326 331
Property income received (x 1,000,000) 146 159 168 135 141 178
Current transfers received (x 1,000,000) 290 290 313 334 331 348
Household outlays (x 1,000,000) 1,621 1,756 1,861 1,873 1,922 1,977
Property income paid (x 1,000,000) 47 51 54 53 57 58
Current transfers paid (x 1,000,000) 511 566 598 588 594 611
Household final consumption expenditure (x 1,000,000) 1,063 1,139 1,209 1,232 1,271 1,308
Interest paid (x 1,000,000) 1 64 72 72 73 76 78
Mortgage interest paid (x 1,000,000) 1 31 36 36 37 42 41
Non-mortgage interest paid (x 1,000,000) 1 33 36 36 36 34 37
Divided by: household disposable income (x 1,000,000) 12 1,314 1,397 1,452 1,497 1,544 1,600
Equals: debt service ratio, interest only (ratio) 1 4.87 5.16 4.96 4.88 4.92 4.87
Northwest Territories 5 Household income (x 1,000,000) 2,419 2,520 2,561 2,682 2,769 2,902
Compensation of employees (x 1,000,000) 6 1,662 1,716 1,738 1,817 1,875 1,958
Net mixed income (x 1,000,000) 246 262 273 274 275 285
Property income received (x 1,000,000) 124 131 138 183 184 183
Current transfers received (x 1,000,000) 387 411 412 408 434 475
Household outlays (x 1,000,000) 2,196 2,352 2,434 2,495 2,604 2,691
Property income paid (x 1,000,000) 54 58 57 50 49 53
Current transfers paid (x 1,000,000) 766 855 887 907 966 1,005
Household final consumption expenditure (x 1,000,000) 1,376 1,439 1,490 1,538 1,589 1,633
Interest paid (x 1,000,000) 1 72 79 77 77 73 73
Mortgage interest paid (x 1,000,000) 1 36 43 41 42 43 45
Non-mortgage interest paid (x 1,000,000) 1 36 36 36 35 30 28
Divided by: household disposable income (x 1,000,000) 12 1,671 1,686 1,694 1,802 1,827 1,917
Equals: debt service ratio, interest only (ratio) 1 4.31 4.68 4.55 4.27 4.00 3.81
Nunavut 5 Household income (x 1,000,000) 1,287 1,375 1,433 1,473 1,542 1,611
Compensation of employees (x 1,000,000) 6 871 924 970 989 1,052 1,092
Net mixed income (x 1,000,000) 141 149 156 161 162 168
Property income received (x 1,000,000) 48 54 60 62 65 68
Current transfers received (x 1,000,000) 227 248 247 261 263 282
Household outlays (x 1,000,000) 1,014 1,094 1,131 1,177 1,212 1,251
Property income paid (x 1,000,000) 22 18 16 17 17 16
Current transfers paid (x 1,000,000) 359 404 411 429 447 464
Household final consumption expenditure (x 1,000,000) 633 672 704 731 748 771
Interest paid (x 1,000,000) 1 27 25 23 24 23 22
Mortgage interest paid (x 1,000,000) 1 16 13 11 11 12 11
Non-mortgage interest paid (x 1,000,000) 1 11 12 12 13 11 11
Divided by: household disposable income (x 1,000,000) 12 933 978 1,029 1,051 1,101 1,153
Equals: debt service ratio, interest only (ratio) 1 2.89 2.56 2.23 2.28 2.09 1.91
Outside Canada Household income (x 1,000,000) 614 643 680 661 661 639
Compensation of employees (x 1,000,000) 6 584 612 647 634 645 621
Net mixed income (x 1,000,000) 0 0 0 0 0 0
Property income received (x 1,000,000) 0 0 0 0 0 0
Current transfers received (x 1,000,000) 30 31 33 27 16 18
Household outlays (x 1,000,000) 355 337 332 332 342 349
Property income paid (x 1,000,000) 0 0 0 0 0 0
Current transfers paid (x 1,000,000) 211 190 186 172 180 186
Household final consumption expenditure (x 1,000,000) 144 147 146 160 162 163

Footnotes:

Household debt service indicators.
Disposable income has been adjusted for interest on consumer credit.
Canada totals in the provincial and territorial gross domestic product by income and by expenditure accounts (PTEA) do not correspond to the national gross domestic product by income and by expenditure accounts (IEA) estimates at certain times of the year. The two accounts are brought back in line when annual revisions are incorporated.
Terminated with the 1998 data.
Prior to 1999, see Northwest Territories including Nunavut.
Includes compensation of employees of all resident households.

Source:  Statistics Canada. Table  384-0042 -  Selected indicators - Households, annual (dollars unless otherwise noted),  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 16 items selected)
D1-picklist-container

Step 2- Select: Estimates  

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

Step 3 - 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 4 - Select the Screen output format






Step 5

 

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 2016-11-09)



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 publications
View latest article from The Daily related to this table.
View list of related publications.



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.