You can spend hours pulling StatCan data into Excel and just doing your own spreadsheets, different calculations, historical comparisons, etc. StatCan also always adjusts it's numbers as well, so something pulled a year ago should be updated with the latest data. Anyways, I decided to pull interprovincial migration data for the last 50 years exactly, starting with Q3 1974 up until the latest release, Q2 2024 (200 quarters, the data is always reported quarterly). And like the census does, I broke the data into 5-year groupings for my measurements. But very important to note, my 5-year periods do not correspond to the census periods , I just used the migration for last five years from Q2 2024 backwards (which ended up being Q3 2019). So my periods were all Q3 to Q2 of the following periods:
2019-2024
2014-2019
2009-2014
2004-2009
1999-2004
1994-1999
1989-1994
1984-1989
1979-1984
1974-1979
Basically just a fun comparison of how interprovincial migration has changed over a much more significant span of time. 50 years is just a nice milestone to measure over time, it gives insight into potential trends and overall impact much more than quarter by quarter at the yearly level. Here's some random factoids/achievement (I only included the largest provinces in these comparisons, I don't have the fortitude to do every province):
-of the ten 5-year periods I measured, it appears the most active for movement (ie. most interprovincial migrants nationwide) was the very first period, Q3 1974 to Q2 1979. Even though the in/out numbers don't perfectly line up in StatCan data, there were approx. 1,833,186 interprovincial migrants in this period. Adjusted for population at the time, the # of interprovincial migrants then was significantly higher than now (the latest period had ~1,671,787 migrants). The difference is almost 200,000 in raw numbers, never mind adjusted for current population. Two major events did happen in this period that really affected numbers though. First, the PQ getting elected in QB, causing a huge outflow to ON in record numbers. Second, the oil boom in AB, which changed the province forever, and was so economically and socially important to AB's growth ever since. So these two provinces really stood out in terms of movement (the numbers back this up: for the '74-'79 period, QB had a net loss of -127,394 while AB had a net gain of 150,413. No other province came close to these provinces.
-BC had the most 5-year periods with an interprovincial net gain, with 9 out of 10 periods having gains (the exception being . AB was 2nd with 8/10 periods having gains. QB and MB both have the worst records with 10/10 periods having net loss. On a closer scale, AB has had 56 quarters of losses vs. 144 with gains. BC had an even better record, 47 quarters of losses vs. 153 with gains. On the other end of the scale, QB has only had 6 quarters of gains and 194 losses, while MB has had 16 quarters of gains, 184 of losses. However, like most statistics, this doesn't tell the whole story. Even though BC had more 5-year and quarterly growth periods than AB, AB's total net migration over the 50 years is the winner, gaining 669,907 in the period against BC's 624,228. It's because AB's gains have been so big during their booms, it more than covers the higher frequency of quarterly loss compared to BC. When BC does have negative quarterly migration, the losses are relatively tame, and the stretches of negative are relatively short (except '97 to '03, BC's dark days). But they are both in a different league when it comes to total growth and individual periods of growth. On the other end of the spectrum, the provinces behaved more logically so QB was by far the biggest loser (-587,397) in addition to having the most quarterly losses. Fittingly, MB was 2nd worst for losses (-260,833) but obviously proportionally far far worse given the size differences.
-ON is a real yo-yo, noticeably oscillating between periods of loss and gain, having good and bad periods cyclically over the 50 years, much moreso than BC or AB in fact. They had six five-year periods of loss, and four periods of gains, so quite give and take over the half century. This translates into a 50-year net loss of -83,684, which is honestly quite insignificant given its population, and reflects the periods of ups and downs causing a small net change. Funny that AB gets the reputation for boom and bust cycles, yet by this net migration metric, ON is far more up and down than AB. AB has had a decent frequency of booms and busts in net migration, but Ontario swings up and down far more actually. Interestingly, ON's largest negative net migration period is the most recent 2019-2024 period, losing -101,632 net, far higher than any other 5-year period since 1974. It's impossible to make any claim of a downward trend though, one period does not a trend make. Prior to this latest period, ON had been doing great and gaining interprovincially, it was a sudden reversal in 2020 to losses and hasn't stopped (but is has slowed noticeably in the last year or so already, so nowhere near a trend or pattern).
-the largest ever 5-year loss for a province was QC between '74-'79, losing -127,394 net
-the largest ever 5-year gain for a province was BC between '89-'94, adding 191,421 net
-the 2004-2009 period could be argued as the worst for Canada in terms of interprovincial migration hammering the most places with the most fury. Meaning in this 5-year period, 8 provinces had negative net migration, only two had positive (BC and AB, with AB being the clear winner with +142,528 vs. BC's +56,657). But for everyone else, these were peak Fort Mac/Alberta bound years, and killed basically every jurisdiction (other than BC, which luckily had good exchanges with other provinces to partially offset the AB losses, something the other provinces didn't have). Most periods had 6/7 provinces losing, and 3/4 gaining. So 8 losing was significant, and a clear numerical reflection of what we experienced in real life, with AB just dominating.
On the other end of the scale, in a funny coincidence, the periods with the fewest provinces losing was tied: both '74-'79 and '19-'24 had 6 provinces gaining, and 4 losing. It's a much nicer scenario to have the winners outnumbering the losers. Pretty much a result of the Maritimes turning into growth centres instead of drains, that's 4 provinces switching sides. But of course it isn't all rosy, it masks the fact that all the biggest provinces turned negative in the last 4 quarters, which is much more harmful. With losses nowhere close to being offset by Maritime gains, so definitely more bad than good, no offence to Atlantic, but their individual provincial growth is nowhere near enough to make up for BC, ON, or QB.
-Last musing before I pass out from exhaustion. Turning to NL, interesting to see the figures. It seems like for many years now we have been hearing of NL's popularity, its turnaround, its growth, etc. There are so many younger people now (Gen Z) who have only known the Atlantic Canada of the 2020 and later period, and not how it once was with the young people leaving. Really starts making you feel old realizing these periods you remember so well were long before the young adults of today were born lol! Anyways, when you zoom out on NL and look past the recent years, you will see the hemoragghing out they used to be known for. For example: NL had a net -122,310 loss in the 50 year period, which works out to 22% of current population, the highest in the county. MB and SK weren't too far behind, with -17% and -18% losses compared to population. So while I'm glad NL made a turnaround, but the numbers when taken over a longer period are still generally bleak