[ Launch: Canada Assets 2012 ] 9252789 by DeBraid
-
-
Save DeBraid/9252789 to your computer and use it in GitHub Desktop.
Canada Assets 2012
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"description":"Canada Assets 2012","endpoint":"","display":"svg","public":true,"require":[],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"nw.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12},"_.md":{"default":true,"vim":false,"emacs":false,"fontSize":12},"config.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"nw2.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"fullscreen":false,"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"pingpong","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"thumbnail":"http://i.imgur.com/r4S7CmF.png"} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* data from statscan http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2050001&pattern=&csid= | |
* basic sortable bar chart bl.ocks.org/mbostock/1584697 | |
* | |
* | |
* | |
* | |
* | |
*/ | |
var data = tributary.nw2; | |
var years = d3.keys(data[0]).filter(function(key){ | |
return key !== "Type"; | |
}); | |
data.forEach(function(d){ | |
// do stuff | |
d.groups = years.map(function(year) { | |
return {year: year, total: +d[year]} | |
}); | |
}); | |
console.log(years); | |
/* | |
var svg = d3.select("svg") | |
.attr("width", width + margin.left + margin.right) | |
.attr("height", height + margin.top + margin.bottom) | |
.append("g") | |
.attr("transform", "translate(" + margin.left + "," + margin.top + ")"); | |
var chart = function (data) { | |
var ageNames = d3.keys(data[0]).filter(function(key) { return key !== "State"; }); | |
data.forEach(function(d) { | |
d.ages = ageNames.map(function(name) { return {name: name, value: +d[name]}; }); | |
}); | |
x0.domain(data.map(function(d) { return d.State; })); | |
x1.domain(ageNames).rangeRoundBands([0, x0.rangeBand()]); | |
y.domain([0, d3.max(data, function(d) { return d3.max(d.ages, function(d) { return d.value; }); })]); | |
svg.append("g") | |
.attr("class", "x axis") | |
.attr("transform", "translate(0," + height + ")") | |
.call(xAxis); | |
*/ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Type | 1999 | 2005 | 2012 | |
---|---|---|---|---|
Total assets | 4489109 | 6395134 | 9410656 | |
Private pension assets | 1309523 | 1856089 | 2829705 | |
Registered Plans (RRSPs RRIFs LIRA) | 536422 | 674706 | 958571 | |
Employer-sponsored Pension Plans | 773101 | 1181383 | 1871134 | |
Non-pension Financial assets | 554126 | 664900 | 1047214 | |
Bank Deposits | 207339 | 269929 | 343984 | |
Mutual and investment funds + income trusts | 103102 | 152129 | 239468 | |
Stocks | 117919 | 117222 | 204864 | |
Bonds | 33172 | 39375 | 24378 | |
TFSA | 0 | 0 | 65939 | |
Other financial assets | 92595 | 86246 | 168580 | |
Non-financial assets | 2176597 | 3203286 | 4744580 | |
Principal residence | 1418971 | 2137890 | 3254275 | |
Other real estate | 302863 | 546886 | 931762 | |
Vehicles | 161343 | 194726 | 245520 | |
Other non-financial assets | 293420 | 323785 | 313023 | |
Equity in business | 448863 | 670859 | 789158 | |
Total debts | 586095 | 864625 | 1337071 | |
Mortgages | 453557 | 650751 | 1029811 | |
Principal residence | 388119 | 552849 | 821010 | |
Other real estate | 65438 | 97901 | 208801 | |
Line of credit | 33220 | 77492 | 144946 | |
Credit card and installment debt | 18507 | 29316 | 35321 | |
Student loans | 19623 | 22718 | 28272 | |
Vehicle loans | 37093 | 52439 | 75814 | |
Other debt | 24096 | 31909 | 22908 | |
Net Worth | 3903014 | 5530509 | 8073585 |
We can make this file beautiful and searchable if this error is corrected: It looks like row 11 should actually have 6 columns, instead of 7 in line 10.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Type,1999,2005,2012,pc2005,pc2012 | |
Total assets,4489109,6395134,9410656,42.5,47.2 | |
Private pension assets,1309523,1856089,2829705,41.7,52.5 | |
Registered Plans (RRSPs RRIFs LIRA),536422,674706,958571,25.8,42.1 | |
Employer-sponsored Pension Plans,773101,1181383,1871134,52.8,58.4 | |
Non-pension Financial assets,554126,664900,1047214,20.0,57.5 | |
Bank Deposits,207339,269929,343984,30.2,27.4 | |
Mutual and investment funds + income trusts,103102,152129,239468,47.6,57.4 | |
Stocks,117919,117222,204864,-0.6,74.8 | |
Bonds,33172,39375,24378,18.7,-38.1 | |
TFSA,0,0,65939,,0,65939 | |
Other financial assets,92595,86246,168580,-6.9,95.5 | |
Non-financial assets,2176597,3203286,4744580,47.2,48.1 | |
Principal residence,1418971,2137890,3254275,50.7,52.2 | |
Other real estate,302863,546886,931762,80.6,70.4 | |
Vehicles,161343,194726,245520,20.7,26.1 | |
Other non-financial assets,293420,323785,313023,10.3,-3.3 | |
Equity in business,448863,670859,789158,49.5,17.6 | |
Total debts,586095,864625,1337071,47.5,54.6 | |
Mortgages,453557,650751,1029811,43.5,58.2 | |
Principal residence,388119,552849,821010,42.4,48.5 | |
Other real estate,65438,97901,20880,149.6,113.3 | |
Line of credit,33220,77492,144946,133.3,87.0 | |
Credit card and installment debt,18507,29316,35321,58.4,20.5 | |
Student loans,19623,22718,28272,15.8,24.4 | |
Vehicle loans,37093,52439,75814,41.4,44.6 | |
Other debt,24096,31909,22908,32.4,-28.2 | |
Net Worth,3903014,5530509,8073585,41.7,46.0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment