Table 378-0122
National Balance Sheet Accounts, credit market summary table at book value
quarterly (dollars x 1,000,000)


Data table

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

Selected items [Add/Remove data]
Geography = Canada
by Categories; Geography= Canada
National Balance Sheet Accounts, credit market summary table at book value, quarterly (dollars x 1,000,000)
Categories 2014 2015 2016 2017
Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1
footnotes
Households 1,783,185 1,810,821 1,828,310 1,835,946 1,873,208 1,906,131 1,928,666 1,942,852 1,979,048 2,003,732 2,027,762 2,041,121
Consumer credit 1 552,459 557,715 561,392 558,990 567,259 573,172 575,609 576,293 586,223 588,618 595,357 595,268
Non-mortgage loans 1 84,226 86,382 87,597 90,118 96,043 97,063 98,037 101,687 102,468 101,733 103,059 104,385
Mortgages 1 1,146,500 1,166,724 1,179,321 1,186,838 1,209,906 1,235,896 1,255,020 1,264,872 1,290,357 1,313,381 1,329,346 1,341,468
Non-profit institutions serving households 13,765 14,181 14,170 14,822 16,559 16,695 16,811 17,338 17,387 17,286 17,952 18,200
Non-mortgage loans 2 9,475 9,872 9,837 10,449 12,136 12,214 12,268 12,742 12,743 12,596 13,218 13,421
Mortgages 2 4,290 4,309 4,333 4,373 4,423 4,481 4,543 4,596 4,644 4,690 4,734 4,779
Non-financial private corporations 1,140,987 1,181,908 1,201,790 1,280,095 1,298,864 1,338,296 1,381,133 1,381,362 1,406,513 1,432,276 1,440,826 1,451,035
Short-term paper 3 75,689 81,558 78,431 84,020 85,646 80,499 82,934 78,727 83,482 82,722 74,115 76,363
Bonds 3 418,836 432,960 445,701 489,573 488,695 512,951 520,637 511,062 517,319 525,877 540,063 536,577
Non-mortgage loans 3 396,439 414,584 423,377 450,245 466,089 470,432 499,982 510,980 521,964 535,186 534,042 542,928
Mortgages 3 250,023 252,806 254,281 256,257 258,434 274,414 277,580 280,593 283,748 288,491 292,606 295,167
Non-financial government enterprises 79,465 79,595 78,625 78,457 84,560 82,867 82,222 82,169 80,429 82,066 81,021 83,234
Short-term paper 4 2,810 3,000 3,150 3,179 2,777 3,352 4,460 3,651 3,697 4,078 3,200 3,101
Bonds 4 73,015 73,893 73,486 73,206 78,218 76,831 76,037 74,800 74,021 74,407 76,332 78,189
Non-mortgage loans 4 3,624 2,686 1,973 2,056 3,550 2,669 1,711 3,705 2,698 3,569 1,477 1,932
Mortgages 4 16 16 16 16 15 15 14 13 13 12 12 12
Federal general government 667,502 666,613 657,991 663,160 666,716 684,684 683,652 685,227 698,780 707,774 708,028 710,426
Short-term paper 5 162,378 155,978 149,497 139,266 145,675 154,413 152,318 142,740 157,955 156,945 141,628 140,077
Bonds 5 500,194 506,858 505,364 519,100 516,495 526,180 527,354 537,251 536,164 546,809 562,763 564,799
Non-mortgage loans 5 4,930 3,777 3,130 4,794 4,546 4,091 3,980 5,236 4,661 4,020 3,637 5,550
Other levels of general government 773,151 784,825 790,218 793,050 819,571 831,076 843,914 851,515 859,972 874,448 879,858 891,582
Short-term paper 6 61,183 66,878 62,053 56,570 76,974 74,584 72,312 69,131 71,436 72,442 75,464 68,200
Bonds 6 660,766 665,490 674,646 682,380 687,489 701,465 715,622 727,891 733,082 746,752 748,455 768,075
Non-mortgage loans 6 44,152 45,394 46,442 47,010 47,965 47,845 48,756 47,277 48,213 47,982 48,636 47,975
Mortgages 6 7,050 7,063 7,077 7,090 7,143 7,182 7,224 7,216 7,241 7,272 7,303 7,332
Total debt outstanding of domestic non-financial sectors 4,458,055 4,537,943 4,571,104 4,665,530 4,759,478 4,859,749 4,936,398 4,960,463 5,042,129 5,117,582 5,155,447 5,195,598
Short-term paper 7 302,060 307,414 293,131 283,035 311,072 312,848 312,024 294,249 316,570 316,187 294,407 287,741
Bonds 7 1,652,811 1,679,201 1,699,197 1,764,259 1,770,897 1,817,427 1,839,650 1,851,004 1,860,586 1,893,845 1,927,613 1,947,640
Consumer credit 7 552,459 557,715 561,392 558,990 567,259 573,172 575,609 576,293 586,223 588,618 595,357 595,268
Non-mortgage loans 7 542,846 562,695 572,356 604,672 630,329 634,314 664,734 681,627 692,747 705,086 704,069 716,191
Mortgages 7 1,407,879 1,430,918 1,445,028 1,454,574 1,479,921 1,521,988 1,544,381 1,557,290 1,586,003 1,613,846 1,634,001 1,648,758
Non-residents 336,891 359,016 400,279 442,799 448,418 493,627 535,163 503,489 519,495 513,361 521,611 516,486
Short-term paper 8 11,957 9,598 10,231 11,730 12,882 12,991 14,841 10,668 11,804 11,856 12,419 13,344
Bonds 8 218,819 239,797 265,549 293,516 298,971 332,713 369,546 350,350 365,445 368,787 364,441 365,099
Non-mortgage loans 8 106,115 109,621 124,499 137,553 136,565 147,923 150,776 142,471 142,246 132,718 144,751 138,043
Total debt outstanding excluding domestic financial institutions 4,794,946 4,896,959 4,971,383 5,108,329 5,207,896 5,353,376 5,471,561 5,463,952 5,561,624 5,630,943 5,677,058 5,712,084
Domestic financial institutions 1,278,290 1,297,814 1,339,445 1,365,774 1,419,902 1,476,685 1,517,196 1,557,952 1,578,194 1,575,262 1,632,412 1,642,075
Short-term paper 9 113,577 103,807 107,854 116,324 122,295 134,163 139,807 138,914 142,646 137,825 141,236 144,918
Bonds 9 1,037,401 1,064,770 1,099,061 1,120,075 1,167,241 1,206,534 1,235,185 1,273,942 1,286,332 1,288,366 1,338,164 1,349,906
Non-mortgage loans 9 119,719 121,493 124,609 121,357 122,319 127,800 133,923 136,809 140,825 140,532 144,602 138,666
Mortgages 9 7,593 7,744 7,921 8,018 8,047 8,188 8,281 8,287 8,391 8,539 8,410 8,585
Total debt outstanding 6,073,236 6,194,773 6,310,828 6,474,103 6,627,798 6,830,061 6,988,757 7,021,904 7,139,818 7,206,205 7,309,470 7,354,159

Footnotes:

Households.
Non-profit institutions serving households.
Non-financial private corporations.
Non-financial government enterprises.
Federal general government.
Other levels of general government.
Total debt outstanding of domestic non-financial sectors.
Non-residents.
Domestic financial institutions.

Source:  Statistics Canada. Table  378-0122 -  National Balance Sheet Accounts, credit market summary table at book value, quarterly (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 1 items selected)
D1-picklist-container

Step 2- Select: Categories  

(43 of 43 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.
Start Period From: 
End Period  To: 
(Quarterly 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 2017-06-14)

Convert the data from one frequency to another.

Frequency of output data will be:

When converting frequency by summing or averaging:

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.
Certain series can only be aggregated by specific methods. If the frequency conversion chosen is not allowed, resultant data will appear as "..".
View additional information related to 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.