Canada mortgages: CMHC-backed portion shrinks, slowly taking taxpayers off the hook

Step line charts

We are excited no announce step line chart support:

Use "Line options" panel to change line style:

Sources:
Canada houseld debt to GDP, Federal Reserve Bank of St Louis
US houseld debt to GDP, Federal Reserve Bank of St Louis
BoC rate
Fed rate

Canada federal policies and housing/debt crisis timeline

Here is a cheatsheet: how selected federal policies have changed and who was at the helm. Updated: March 2021.

Governor of Bank of Canada:
David Dodge February 1, 2001 – January 31, 2008
Mark Carney February 1, 2008 – June 3 2013
Stephen Poloz June 3, 2013 - June 3, 2020
Tiff Macklem June 3, 2020 - now



CMHC President:
Karen Kinsley 2003-2013
Evan Siddal January 1, 2014 - present



Minister of Finance of Canada:
Ralph Goodale December 11, 2003 – February 6, 2006
Jim Flaherty February 6, 2006 – March 18, 2014
Joe Oliver March 19, 2014 – November 4, 2015
Bill Morneau November 4, 2015 - August 18, 2020
Chrystia Freeland August 18, 2020 - now



2004-01 Department of Finance CMHC insurance limit raised The Department of Finance raises the aggregate amount of insurance that CMHC can have outstanding to $300 billion from $250 billion.
2006-01 Department of Finance CMHC insurance limit raised The Department of Finance raises the aggregate amount of insurance that CMHC can have outstanding to $350 billion from $300 billion.
2008-03 Department of Finance CMHC insurance limit raised The Department of Finance raises the aggregate amount of insurance that CMHC can have outstanding to $450 billion from $350 billion.
2009-03 Department of Finance CMHC insurance limit raised The Department of Finance raises the aggregate amount of insurance that CMHC can have outstanding to $600 billion from $450 billion.
2020-12 Department of Finance CMHC insurance limit raised The Department of Finance raises the aggregate amount of insurance that CMHC can have outstanding to $750 billion from $600 billion.

2006-06 CMHC Expansion of inured mortgages The CMHC announces mortgages with amortizations of up to 30 and 35 years can be insured, as well as interest-only mortgages (for the first 10 years of the mortgage).
2006-11 CMHC Expansion of inured mortgages The CHMC announces mortgages with amortizations up to 40 years can be insured, as well as zero-down payment mortgages.
2008-07 Department of Finance Amortization reduction The maximum amortization period is shortened from 40 years to 35 years.
2011-01 Department of Finance Amortization reduction The maximum amortization period is shortened to 30 years from 35 years on insured mortgages.
2012-01 OSFI Amortization reduction The maximum amortization period is shortened to 25 years from 30 years on insured mortgages.

2010-02 Department of Finance Reduction of insured refinancing The maximum amount for insured refinances is reduced to 90% from 95%.
2011-01 Department of Finance Reduction of insured refinancing The maximum amount for insured refinances is reduced to 85% from 90%.
2012-06 OSFI Reduction of insured refinancing The maximum amount for insured refinances is reduced to 80% from 85%.



Sources:
History of Mortgage Rule Changes in Canada, RateSpy.com
Canada houseld debt to GDP, Federal Reserve Bank of St Louis
Teranet Housing Price Index

Collaboration scenario: sharing and cloning

Recently, charte.ca feature set got new additions: chart cloning and chart sharing. Cloning is getting an exact copy of a source chart. Sharing is allowing other users to edit your chart.

Consider an example: Bob is working on a chart and wants Alice to help him. Bob opens the chart in the editor, finds "Sharing" panel and clicks "Share with another user" button. He is presented with a popup that displays a URL of the invitation that Bob has to send Alice so she gets access to his chart. Bob presses "Confirm":

Now, "Sharing" panel displays the invitation in the list. If Bob changes his mind, he can cancel this invitation by clicking the "x" button on the right of the invitation:

Javascript ES6 only please

Starting from May 7, 2018, charte.ca charts are not displayed in browsers that do not support major ES6 features. In plain English: Internet Explorer users will not be able to see charts created by charte.ca, Edge users should be fine. Also, the editor now requires ES6 as well (which is not much of a change since the editor requires data uri support and IE and Edge are both lacking it).

Charts have just become 5-10% smaller in size.

charte.ca as an educational resource: motion charts visualizing World Bank data

High school students extract data from the World Bank dataset and create a motion chart that shows the relationship between life expectancy and expenditure on health in different countries. See discussion in Information Technology Teachers' Mailing List:

https://edulists.com.au/pipermail/yr11it/2017-August/003375.html

A set of instructions for Yr11 Information Technology students:

http://www.edulists.com.au/pipermail/yr11it/attachments/20170820/71ebeb96/VisualisingBigDatausingCharte-steps-0001.docx

Visualizing Google analytics report: motion chart with drilldowns

Below is a motion chart with drilldowns visualizing Google Analytics report for a fictional website. Click and hold on any bubble to see acquisition and conversion details for a specific channel: Direct, Organic Search, Referral, Social.

Why motion charts?

Motion chart allows efficient and interactive exploration and visualization of multi-dimensional data and can make it easier to notice an important trend. Google has done a great job explaining how motion chart can be useful in web analytics and providing a tool for building motion charts based on analytics reports.

Interactive charts in online presentations

Earlier this year, we posted a small research on US and Canada immigration patterns. Let's make a simple online presentation from it.

Using slides.com

We will be using slides.com, which is probably the most flexible and powerful online presentation engine these days. We will re-use all charts from our earlier post without modifications - they are already published and ready to be embedded. The presentation is available here:

http://slides.com/chartecaguy/us-canada-demographics#/

A few things worth noting.

1.  All charts are interactive - move mouse pointer over the curves and see.

2. All charts are embedded with style="width:100%" attribute, which makes them scalable: try running the presentation in full-screen mode or resize your browser window - you will see charts changing their sizes accordingly.

A screenshot of the slides.com editor with embedded chart:

Other online presentation tools

Are there any other online presentation tools that support HTML embedding from arbitrary sources? Unfortunately, not many. So far I have come up with this list:

• Emaze - NO
• Google Slides - NO
• Haiku Deck - NO
• Prezi - NO
• Slides.com- YES
• Sway - NO
• Slidebean - NO
• Visme - YES

Chart background graphics: SVG

We are excited to announce SVG background support. This means that chart authors now can use vector or raster graphics for chart backgrounds. The following example shows gender symbols and generation names behind the population pyramid chart:

This chart uses data from this spreadsheet. Import settings are as follows:

MI, NC, OH, PA congressional elections 1972-2016: district breakdown by % of votes for Democrats

Inspired by Blake Esseltyn's attempt to visualize MI,NC,OH, and PA redistricting results, I copied congressional election results (democratic votes only) in those four states from gerrymander.princeton.edu into a spreadsheet and broke down district results by percentile. For example, for 1972 Michigan congressional elections we have 19 districts with the following votes % for Democrats (in no particular order):

89.08%, 43.57%, 40.24%, 32.75%, 38.14%, 49.36%, 29.89%, 39.93%, 29.83%, 31.63%, 30.05%, 50.82%, 86.54%, 54.86%, 66.68%, 69.58%, 67.15%, 47.38%, 28.93%.

After breaking down buy percentile, we get:
Districts that got between 0% and 10% votes for Democrats: 0 out of 19: 0%
Districts that got between 10% and 20% votes for Democrats: 0 out of 19: 0%
Districts that got between 20% and 30% votes for Democrats: 3 out of 19: 16%
Districts that got between 30% and 40% votes for Democrats: 5 out of 19: 26%
and so on.

The following are four heatmap charts that visualize Democratic votes breakdown for these fours states. Watch districts gravitating towards 30-50 democratic vote percentiles since 2010.

More heatmaps: other types of crime is San Francisco, 2003-2016

This is a follow-up to the earlier post about visualizing SFPD data. Now let's focus on other crime categories: vehicle theft, larceny/theft, burglary, assault.

Animated GIF is not the best way to explore patterns. Check out the original interactive charts for each type of crime below.

SFPD incident database and heatmaps: drug-related incident patterns

San Francisco Police Department provides free access to a great data source:  https://data.sfgov.org/browse?category=Public+Safety. The following couple of charts display drug-related incident distribution by year, weekday, time of day, and district.




Some observations:

• the notorious "welfare Wednesday" effect is present in early years;
• incident numbers drop significantly starting 2010, which may be caused by Proposition 215: Wikipedia says "It was not until March 2009 that federal officials announced that they would no longer try to thwart medical marijuana distribution/use in California".

There is a follow-up post focusing on other types of crime in SF using the same data source.

The following are the steps to create the weekday/time heatmap chart using charte.ca editor.

World Health Organization (WHO): spotting spending patterns in 2000-2015

It took me a while to find and groom WHO spending numbers. All financial reports I used can be found here. There were a few challenges, here are some worth mentioning.

1. Between 2000 and 2011, the WHO published two-year financial reports, and in 2012, they switched to one-year schedule.

2. The list of expenditure categories was changing from year two year. As a result, I could not break down equipment and supplies category into meaningful groups, so medical supplies and furniture fall into the same category. Same with the "Other" category: it includes grants, research contracts, local subsidies and what not.

3. Since 2008, WHO financial reports stopped providing staff costs breakdown, so "Stuff costs" category includes full-time and part-time employees, consultants and even governing body delegates.


Below is the two-axis chart that shows absolute spending numbers as bars and the share of some spending categories as lines:



Key observations:

• the WHO is drifting towards outsourcing some of the activities: watch the staff+equipment spending go down while contractual services going up;
• the share of travel expenses grew three times between 2000 and 2015.

It turned out both observations make sense: just google "world health organization outsourcing" and "world health organization travel expenses".

Animated GIF is alive and well

I have just came across a blog featuring high-quality charts visualizing all kinds of data: https://datasoaring.blogspot.com. Charts are made with plot.ly, highcharts, bokeh, charte.ca and other tools. Some charts are published as high-quality animated GIFs. Apparently, the blogger uses this data format as a last resort - not so many tools out there support animation right out of the box. Anyways, good to see charte.ca in a good company.

Log scale for XY charts

From now on, charte.ca supports log scale in all XY charts (bubble, scatter, motion). Consider the following visualization of World Bank and SIPRI Military Expenditure Database data:

Why log scale? There are a few cases when a log scale is appropriate. The most well known is: log scales allow a large range to be displayed without small values being compressed down into bottom of the graph. Consider the same visualization made using linear scale (this is just a screenshot, not an interactive chart, but it gives you a good idea about the problem):

More fun with motion charts: European top 20 imports and exports, 1990-2016

World Bank Group provides a lot of data to play with. Let's build a motion chart based on export, import, and GDP data for European top 20 economies, grouped by regions - Northern, Western, Eastern, and Southern.

Watch international trade shrinking between 2008 and 2009!

Motion charts: add categories and animate those bubbles

charte.ca now supports motion charts. Motion charts are basically bubble charts with one more dimension added (usually, it's time). In charte.ca, we use category for this dimension, remember category radio buttons in charte.ca pie charts and bar charts? So, our motion charts are bubble charts with category radio buttons.

Recently, Statistics Canada published a quick overview of interprovincial migration data, using simple line charts. Let's make this data look fancier:

Here are the steps to create this motion chart.

Happy Birthday, Canada: animated categories

While Canadians looking for the ultimate party to celebrate Canada's 150th birthday on July 1, we will have a quick look at their spending habits. And we will do that by using charte.ca new feature - animated categories.

Chart options panels went through some reorganization. Now we have "Current category label" panel:

and "Animation" panel:

For charts with multiple data rows that are considered categories (pie, regular bar and comparative histogram charts), charte.ca can walk through all categories and update the appearance, creating an animation effect - see chart below.

Try it for yourself - create a pie, regular bar or comparative histogram chart with multiple data rows and play with animation settings. The feature comes handy when you embed charte.ca visualization into a presentation and do not have a convenient way to click or hover over the chart to navigate between categories.

The case for pie charts

Pie charts get a lot of criticism these days. I must agree that bar charts deliver the message better because:

• bar charts can present data for multiple categories without user interaction;
• human eye is much better at telling differences between lengths than it is at determining differences between areas.

The charts below visualize the same data, and they all have the same size of 640x640 pixels. Decide for yourself which one does it better.

Pie chart in question - move your mouse or tap over radio buttons to change category:

Scalable charts

Great news: charte.ca charts are now fully scalable. Content editors and users can change the size of the container - the chart will scale accordingly, preserving the original aspect ratio, without losing any functionality or quality.

Source code for this test HTML file - pay attention to the 100% width style:

<html>
  <body>
    <div>
      <embed src="example-drinking.svg"  type="image/svg+xml" style="width:100%;" />
    </div>
  <body>
<html>

To see this in action, open http://charte.ca and play with the browser window size - you will see sample charts shrinking and expanding as well.