Skip to content

Instantly share code, notes, and snippets.

@karbar09
Last active June 29, 2016 00:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save karbar09/b3a8bc136b6571dc81848a0d0b0f32a4 to your computer and use it in GitHub Desktop.
Save karbar09/b3a8bc136b6571dc81848a0d0b0f32a4 to your computer and use it in GitHub Desktop.

Visualizing Prosper Loan Data with D3

Summary

I take a geographic approach to visualizing loan origination volumne (in dollars) by state and year for Prosper Loans between 2006 and 2014. We will be able to see that 4 major states (California, New York, Texas and Florida) states have the highest origination volumes by year. Furthermore, certain states (North Dakota, Iowa and Maine) used to originate moderate originations, but as of 2013/2014, they originate $0 in loans. A closer look at North Dakota, Iowa and Maine revealed that changes in state law enacted in 2013 made borrowing from Prosper illegal in these states; this explains the abrupt dropoff in loan originations.

Design

The core of this visualization is a Choropleth of the United States of America. The smallest unit or entity is each State and the measured variable is the total loan origination amount in the state over a given period of time. Time is controlled by the user via the use of a slider (ranging from 2006 - 2014).

/*
Function that accepts datasets/selected year, and returns
a GeoJSON USA data along with the loan origination amount for each state, given a year
*/
function filtered_data(prosper_sum_data, abbrev_data,usa_data,i_year) {
//filter the prosper summary data by year
var state_loan_data = [];
for(var i=0;i<prosper_sum_data.length;i++) {
var state = prosper_sum_data[i];
var state_dict = {
'key':state.key,
'values':0
};
for(var j =0;j<state.values.length;j++) {
var year = state.values[j]
if(year.key==i_year) {
state_dict['key'] = state.key;
state_dict['values'] = year.values
break;
}
}
state_loan_data.push(state_dict)
}
//prosper data contains the state abbreviations. we need the full name to use the GeoJSON data.
//create a dict that maps the abbreviations to the full name
var state_abbrev_data = {};
for (var i = 0; i < abbrev_data.length; i++) {
state_abbrev_data[abbrev_data[i].Abbreviation] = abbrev_data[i].State;
}
//Finally, update the GeoJSON data to include a the loan origination amount for each state
for (var i = 0; i < state_loan_data.length; i++) {
var state_name = state_abbrev_data[state_loan_data[i].key];
for (var j = 0; j < usa_data.features.length; j++) {
var usa_state_name = usa_data.features[j].properties.name;
if (state_name == usa_state_name) {
usa_data.features[j].properties.originated = state_loan_data[i].values;
break;
}
}
}
return(usa_data)
};
//Function to get color string from loan origination amount
function get_color(d){
var value = d.properties.originated;
if (value) {
return color(value);
} else {
//if the state does not have a value, we return different color.
//return "ffffe0";
return "fff7fb"
}
}
//Updates visualization with new data
function update(usa_data_new) {
//data join with new data
var paths = svg.selectAll("path")
.data(usa_data_new.features);
//ENTER
paths.enter()
.append("path")
.attr("d", path);
//ENTER + UPDATE
paths.style("fill",get_color);
//EXIT OLD Data
paths.exit().remove();
}
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link rel="stylesheet" href="http://rawgit.com/MasterMaps/d3-slider/master/d3.slider.css" />
<link rel="stylesheet" href="main.css" />
<script src="http://d3js.org/d3.v3.min.js"></script>
<script src="https://d3js.org/d3-queue.v3.min.js"></script>
<script src="http://labratrevenge.com/d3-tip/javascripts/d3.tip.v0.6.3.js"></script>
<script src="http://raw.githack.com/lukius/d3.slider/master/d3.slider.js"></script>
<script src="helper.js"></script>
</head>
<body>
<h1><span id="slider3text">2006</span> Prosper Originations (in $) By State </h1>
<h4>Try the slider below the map for to see the originations for other years from 2006-2014.</h4>
<div id="wrapper">
<div id="map"></div>
<div id="slider"></div>
<br>
<p>Prosper loans originations seem to increase across the US states over time, except for a dip during 2009 (due to the temporary halting of the loan business). As of 2013, there are no loans in North Dakota, Iowa and Maine. In previous years (e.g. 2008), there were loan originations in these states. In fact, according to this source (http://www.lendingmemo.com/lending-club-and-prosper-states/), 3 states are not open to p2p lending: North Dakota, Iowa and Maine. So, legislation has actually closed these states off from certain lending marketplaces. Aside from this, we can see that California, Texas, New York and Florida are the hotbeds of loan originations. It’s no coincidence that these states also have the highest electoral counts. This is probably more so a testament to the large populations of these states, rather than the level of “p2p lending interest” in these regions (compared to others).
</p>
</div>
<script type="text/javascript">
var margin = 0,
width = 980 - margin;
height = 540 - margin;
var projection = d3.geo.albersUsa()
.translate([width/2, height/2])
.scale([1000]);
var path = d3.geo.path()
.projection(projection);
var svg = d3.select("#map")
.append("svg")
.attr("width", width + margin)
.attr("height", height + margin);
//Set color scheme based on loan origination values. Create 8 buckets based on values.
var color_domain = [0,1,100000,1000000,10000000,20000000,50000000];
//var color_range = ['#ffffe0','#ffdaa3','#ffb27c','#fb8768','#eb5f5b','#d3394a','#b3152f','#8b0000'];
var color_range = [
"#eff3ff",
"#c6dbef",
"#9ecae1",
"#6baed6",
"#3182bd",
"#08519c"
];
var color_range_strings = ["$0 - Due to Lending Restrictions","$1 - $100,000","$100,000 - $1,000,000","$1 Million - $10 Million","$10 Million - $20 Millon","$20-50 Million"]
var color = d3.scale.log()
.domain(color_domain)
.range(color_range);
/*
Setup Tool Tip to show originations for each state on hover.
Format number to be expressed as a dollar amount.
*/
var number_format = d3.format("$,0")
var tip = d3.tip()
.attr('class', 'd3-tip')
.offset([-10, 0])
.html(function(d) {
return "<strong>" + d.properties.name + ":</strong> <span style='color:red'> " + number_format(d.properties.originated) + "</span>";
})
svg.call(tip);
//Load Datasets
d3.queue()
.defer(d3.json, "prosperLoanDataSum.json")
.defer(d3.csv, "states.csv")
.defer(d3.json, "us-states.json")
.await(draw);
//Initial data will show for 2006
var init_year = 2006;
function draw(error, prosper_sum_data, abbrev_data, usa_data) {
//See js/helper.js for the filtered_data function
var usa_data = filtered_data(prosper_sum_data, abbrev_data,usa_data,init_year);
svg.selectAll("path")
.data(usa_data.features)
.enter()
.append("path")
.attr("d", path)
.style("stroke", "black")
.style("stroke-width", "0.5")
.style("fill", get_color)
.on('mouseover', tip.show)
.on('mouseout', tip.hide);
//LEGEND
var legend = d3.select("body").append("svg")
.attr("class", "legend")
.attr("width", 300)
.attr("height", 300)
.selectAll("g")
.data(color_range.reverse())
.enter()
.append("g")
.attr("transform", function(d, i) { return "translate(0," + i * 20 + ")"; });
legend.append("rect")
.attr("width", 18)
.attr("height", 18)
.style("fill", function(d) {return d;});
legend.append("text")
//.data(["$100,000,000","$1","0$ (Due to Lending Restrictions)"])
.data(color_range_strings.reverse())
.attr("x", 24)
.attr("y", 9)
.attr("dy", ".35em")
.text(function(d) { return d; })
.style("font-size","8px");
//SLIDER
//To move between years
var min = 2006;
var max = 2014;
var ticks = max - min;
var tickFormat = d3.format(".0");
var axis = d3.svg.axis().ticks(ticks).tickFormat(tickFormat);
var slider = d3.slider()
.axis(axis)
.min(min)
.max(max)
.step(1)
.value(init_year)
.on("slide", function(evt,value) {
d3.select('#slider3text').text(value);
var usa_data_new = filtered_data(prosper_sum_data, abbrev_data,usa_data,value);
//see helper.js for the update function
update(usa_data_new);
});
d3.select('#slider').call(slider);
};
</script>
</body>
</html>
h1 {
margin-left:25%;
margin-right:25%;
}
h4 {
margin-left:25%;
margin-right:25%;
}
#wrapper {
margin-left: 10%;
margin-right: 10%;
}
/* On mouse hover, lighten state color */
path:hover {
fill-opacity: .7;
}
/* Style for Custom Tooltip */
div.tooltip {
position: absolute;
text-align: center;
width: 60px;
height: 28px;
padding: 2px;
font: 12px sans-serif;
background: white;
border: 0px;
border-radius: 8px;
pointer-events: none;
}
.d3-tip {
line-height: 1;
font-weight: bold;
padding: 12px;
background: rgba(0, 0, 0, 0.8);
color: #fff;
border-radius: 2px;
}
/* Creates a small triangle extender for the tooltip */
.d3-tip:after {
box-sizing: border-box;
display: inline;
font-size: 10px;
width: 100%;
line-height: 1;
color: rgba(0, 0, 0, 0.8);
content: "\25BC";
position: absolute;
text-align: center;
}
/* Style northward tooltips differently */
.d3-tip.n:after {
margin: -1px 0 0 0;
top: 100%;
left: 0;
}
/* Legend Font Style */
body {
font: 14px sans-serif;
}
/* Legend Position Style */
.legend {
position:absolute;
left:1000px;
top:350px;
}
[
{
"key": "CO",
"values": [
{
"key": "2006",
"values": 321300
},
{
"key": "2007",
"values": 1421582
},
{
"key": "2008",
"values": 1422422
},
{
"key": "2009",
"values": 283838
},
{
"key": "2010",
"values": 552280
},
{
"key": "2011",
"values": 1559369
},
{
"key": "2012",
"values": 3070110
},
{
"key": "2013",
"values": 7337806
},
{
"key": "2014",
"values": 3034693
}
]
},
{
"key": "GA",
"values": [
{
"key": "2006",
"values": 1441680
},
{
"key": "2007",
"values": 5683178
},
{
"key": "2008",
"values": 4604571
},
{
"key": "2009",
"values": 628843
},
{
"key": "2010",
"values": 1290855
},
{
"key": "2011",
"values": 3439605
},
{
"key": "2012",
"values": 6622327
},
{
"key": "2013",
"values": 12851830
},
{
"key": "2014",
"values": 5318325
}
]
},
{
"key": "MN",
"values": [
{
"key": "2006",
"values": 5600
},
{
"key": "2007",
"values": 1449282
},
{
"key": "2008",
"values": 2350638
},
{
"key": "2009",
"values": 247050
},
{
"key": "2010",
"values": 491350
},
{
"key": "2011",
"values": 1399019
},
{
"key": "2012",
"values": 2928502
},
{
"key": "2013",
"values": 6587417
},
{
"key": "2014",
"values": 2781834
}
]
},
{
"key": "NM",
"values": [
{
"key": "2006",
"values": 81857
},
{
"key": "2007",
"values": 438992
},
{
"key": "2008",
"values": 291662
},
{
"key": "2009",
"values": 22250
},
{
"key": "2010",
"values": 93850
},
{
"key": "2011",
"values": 322704
},
{
"key": "2012",
"values": 507400
},
{
"key": "2013",
"values": 1497899
},
{
"key": "2014",
"values": 866075
}
]
},
{
"key": "KS",
"values": [
{
"key": "2006",
"values": 90330
},
{
"key": "2007",
"values": 445050
},
{
"key": "2008",
"values": 593583
},
{
"key": "2009",
"values": 14000
},
{
"key": "2010",
"values": 216249
},
{
"key": "2011",
"values": 656497
},
{
"key": "2012",
"values": 1502873
},
{
"key": "2013",
"values": 3779234
},
{
"key": "2014",
"values": 1533985
}
]
},
{
"key": "CA",
"values": [
{
"key": "2006",
"values": 2898995
},
{
"key": "2007",
"values": 14176618
},
{
"key": "2008",
"values": 11671928
},
{
"key": "2009",
"values": 1268231
},
{
"key": "2010",
"values": 3556800
},
{
"key": "2011",
"values": 9107971
},
{
"key": "2012",
"values": 19355947
},
{
"key": "2013",
"values": 49978473
},
{
"key": "2014",
"values": 20060190
}
]
},
{
"key": "IL",
"values": [
{
"key": "2006",
"values": 730202
},
{
"key": "2007",
"values": 4765101
},
{
"key": "2008",
"values": 4612309
},
{
"key": "2009",
"values": 580232
},
{
"key": "2010",
"values": 1533279
},
{
"key": "2011",
"values": 4590740
},
{
"key": "2012",
"values": 7637371
},
{
"key": "2013",
"values": 18509050
},
{
"key": "2014",
"values": 6754023
}
]
},
{
"key": "MD",
"values": [
{
"key": "2006",
"values": 276630
},
{
"key": "2007",
"values": 2627900
},
{
"key": "2008",
"values": 2328557
},
{
"key": "2009",
"values": 241479
},
{
"key": "2010",
"values": 831652
},
{
"key": "2011",
"values": 2043844
},
{
"key": "2012",
"values": 4343005
},
{
"key": "2013",
"values": 9544832
},
{
"key": "2014",
"values": 3856324
}
]
},
{
"key": "",
"values": [
{
"key": "2005",
"values": 78687
},
{
"key": "2006",
"values": 13857663
},
{
"key": "2007",
"values": 15717119
},
{
"key": "2008",
"values": 193926
}
]
},
{
"key": "AL",
"values": [
{
"key": "2006",
"values": 347427
},
{
"key": "2007",
"values": 1312161
},
{
"key": "2008",
"values": 843362
},
{
"key": "2009",
"values": 100920
},
{
"key": "2010",
"values": 375764
},
{
"key": "2011",
"values": 932236
},
{
"key": "2012",
"values": 2197082
},
{
"key": "2013",
"values": 4789856
},
{
"key": "2014",
"values": 1787642
}
]
},
{
"key": "AZ",
"values": [
{
"key": "2006",
"values": 342475
},
{
"key": "2007",
"values": 1572793
},
{
"key": "2008",
"values": 1745357
},
{
"key": "2009",
"values": 110067
},
{
"key": "2010",
"values": 431071
},
{
"key": "2011",
"values": 857195
},
{
"key": "2012",
"values": 2326308
},
{
"key": "2013",
"values": 5621513
},
{
"key": "2014",
"values": 2580958
}
]
},
{
"key": "VA",
"values": [
{
"key": "2006",
"values": 175067
},
{
"key": "2007",
"values": 690189
},
{
"key": "2008",
"values": 2159779
},
{
"key": "2009",
"values": 293497
},
{
"key": "2010",
"values": 1117591
},
{
"key": "2011",
"values": 3034087
},
{
"key": "2012",
"values": 5267099
},
{
"key": "2013",
"values": 11929091
},
{
"key": "2014",
"values": 4741972
}
]
},
{
"key": "FL",
"values": [
{
"key": "2006",
"values": 814478
},
{
"key": "2007",
"values": 3035290
},
{
"key": "2008",
"values": 4977954
},
{
"key": "2009",
"values": 579820
},
{
"key": "2010",
"values": 1602445
},
{
"key": "2011",
"values": 5459903
},
{
"key": "2012",
"values": 10036414
},
{
"key": "2013",
"values": 20544291
},
{
"key": "2014",
"values": 8103540
}
]
},
{
"key": "PA",
"values": [
{
"key": "2006",
"values": 30100
},
{
"key": "2007",
"values": 6000
},
{
"key": "2008",
"values": 1423868
},
{
"key": "2009",
"values": 241000
},
{
"key": "2010",
"values": 646360
},
{
"key": "2011",
"values": 2236237
},
{
"key": "2012",
"values": 4444542
},
{
"key": "2013",
"values": 11339680
},
{
"key": "2014",
"values": 4659771
}
]
},
{
"key": "OR",
"values": [
{
"key": "2006",
"values": 384144
},
{
"key": "2007",
"values": 1794180
},
{
"key": "2008",
"values": 1329821
},
{
"key": "2009",
"values": 192120
},
{
"key": "2010",
"values": 430300
},
{
"key": "2011",
"values": 979222
},
{
"key": "2012",
"values": 2175621
},
{
"key": "2013",
"values": 4784335
},
{
"key": "2014",
"values": 1578821
}
]
},
{
"key": "MI",
"values": [
{
"key": "2006",
"values": 488062
},
{
"key": "2007",
"values": 2691368
},
{
"key": "2008",
"values": 2170424
},
{
"key": "2009",
"values": 207399
},
{
"key": "2010",
"values": 785995
},
{
"key": "2011",
"values": 1942976
},
{
"key": "2012",
"values": 4718311
},
{
"key": "2013",
"values": 10261213
},
{
"key": "2014",
"values": 4203482
}
]
},
{
"key": "NY",
"values": [
{
"key": "2006",
"values": 626389
},
{
"key": "2007",
"values": 2032832
},
{
"key": "2008",
"values": 2816704
},
{
"key": "2009",
"values": 454113
},
{
"key": "2010",
"values": 1646857
},
{
"key": "2011",
"values": 4947712
},
{
"key": "2012",
"values": 11129172
},
{
"key": "2013",
"values": 25978132
},
{
"key": "2014",
"values": 9805577
}
]
},
{
"key": "LA",
"values": [
{
"key": "2006",
"values": 93050
},
{
"key": "2007",
"values": 282414
},
{
"key": "2008",
"values": 246449
},
{
"key": "2009",
"values": 51476
},
{
"key": "2010",
"values": 246125
},
{
"key": "2011",
"values": 659681
},
{
"key": "2012",
"values": 1735652
},
{
"key": "2013",
"values": 3457162
},
{
"key": "2014",
"values": 1405256
}
]
},
{
"key": "WI",
"values": [
{
"key": "2006",
"values": 167150
},
{
"key": "2007",
"values": 615759
},
{
"key": "2008",
"values": 989926
},
{
"key": "2009",
"values": 146350
},
{
"key": "2010",
"values": 393550
},
{
"key": "2011",
"values": 1446214
},
{
"key": "2012",
"values": 2806346
},
{
"key": "2013",
"values": 6501753
},
{
"key": "2014",
"values": 2445126
}
]
},
{
"key": "OH",
"values": [
{
"key": "2006",
"values": 14863
},
{
"key": "2007",
"values": 2103278
},
{
"key": "2008",
"values": 2684222
},
{
"key": "2009",
"values": 226988
},
{
"key": "2010",
"values": 979288
},
{
"key": "2011",
"values": 2787743
},
{
"key": "2012",
"values": 5724785
},
{
"key": "2013",
"values": 13647464
},
{
"key": "2014",
"values": 5735817
}
]
},
{
"key": "NC",
"values": [
{
"key": "2006",
"values": 358900
},
{
"key": "2007",
"values": 1331828
},
{
"key": "2008",
"values": 1996385
},
{
"key": "2009",
"values": 289810
},
{
"key": "2010",
"values": 964490
},
{
"key": "2011",
"values": 2377336
},
{
"key": "2012",
"values": 4762351
},
{
"key": "2013",
"values": 8727953
},
{
"key": "2014",
"values": 3849435
}
]
},
{
"key": "WA",
"values": [
{
"key": "2006",
"values": 440247
},
{
"key": "2007",
"values": 2249643
},
{
"key": "2008",
"values": 2600545
},
{
"key": "2009",
"values": 318756
},
{
"key": "2010",
"values": 699980
},
{
"key": "2011",
"values": 1865512
},
{
"key": "2012",
"values": 3946381
},
{
"key": "2013",
"values": 8419276
},
{
"key": "2014",
"values": 3566900
}
]
},
{
"key": "NV",
"values": [
{
"key": "2008",
"values": 372300
},
{
"key": "2009",
"values": 52075
},
{
"key": "2010",
"values": 263785
},
{
"key": "2011",
"values": 728983
},
{
"key": "2012",
"values": 1402273
},
{
"key": "2013",
"values": 4930314
},
{
"key": "2014",
"values": 1838216
}
]
},
{
"key": "NJ",
"values": [
{
"key": "2006",
"values": 195125
},
{
"key": "2007",
"values": 903499
},
{
"key": "2008",
"values": 1280297
},
{
"key": "2009",
"values": 184250
},
{
"key": "2010",
"values": 767773
},
{
"key": "2011",
"values": 2320012
},
{
"key": "2012",
"values": 4976516
},
{
"key": "2013",
"values": 13655132
},
{
"key": "2014",
"values": 5228769
}
]
},
{
"key": "TX",
"values": [
{
"key": "2006",
"values": 1848019
},
{
"key": "2007",
"values": 3755086
},
{
"key": "2008",
"values": 1243434
},
{
"key": "2009",
"values": 503897
},
{
"key": "2010",
"values": 1638557
},
{
"key": "2011",
"values": 4726986
},
{
"key": "2012",
"values": 9476702
},
{
"key": "2013",
"values": 27773163
},
{
"key": "2014",
"values": 11213244
}
]
},
{
"key": "AR",
"values": [
{
"key": "2006",
"values": 7000
},
{
"key": "2007",
"values": 27600
},
{
"key": "2008",
"values": 293150
},
{
"key": "2009",
"values": 75800
},
{
"key": "2010",
"values": 151522
},
{
"key": "2011",
"values": 560015
},
{
"key": "2012",
"values": 1128683
},
{
"key": "2013",
"values": 2997453
},
{
"key": "2014",
"values": 1339625
}
]
},
{
"key": "SC",
"values": [
{
"key": "2006",
"values": 13800
},
{
"key": "2007",
"values": 127825
},
{
"key": "2008",
"values": 541582
},
{
"key": "2009",
"values": 99757
},
{
"key": "2010",
"values": 379083
},
{
"key": "2011",
"values": 905459
},
{
"key": "2012",
"values": 1842448
},
{
"key": "2013",
"values": 4111419
},
{
"key": "2014",
"values": 1414662
}
]
},
{
"key": "DE",
"values": [
{
"key": "2006",
"values": 5000
},
{
"key": "2007",
"values": 25575
},
{
"key": "2008",
"values": 153799
},
{
"key": "2009",
"values": 20500
},
{
"key": "2010",
"values": 80600
},
{
"key": "2011",
"values": 238450
},
{
"key": "2012",
"values": 484442
},
{
"key": "2013",
"values": 1075000
},
{
"key": "2014",
"values": 568810
}
]
},
{
"key": "MO",
"values": [
{
"key": "2006",
"values": 535150
},
{
"key": "2007",
"values": 1834812
},
{
"key": "2008",
"values": 1698222
},
{
"key": "2009",
"values": 222297
},
{
"key": "2010",
"values": 670379
},
{
"key": "2011",
"values": 1718338
},
{
"key": "2012",
"values": 2959783
},
{
"key": "2013",
"values": 6503683
},
{
"key": "2014",
"values": 2482484
}
]
},
{
"key": "NE",
"values": [
{
"key": "2006",
"values": 19200
},
{
"key": "2007",
"values": 264300
},
{
"key": "2008",
"values": 316841
},
{
"key": "2009",
"values": 57350
},
{
"key": "2010",
"values": 127750
},
{
"key": "2011",
"values": 447636
},
{
"key": "2012",
"values": 858133
},
{
"key": "2013",
"values": 2282525
},
{
"key": "2014",
"values": 1123892
}
]
},
{
"key": "UT",
"values": [
{
"key": "2006",
"values": 199426
},
{
"key": "2007",
"values": 1208009
},
{
"key": "2008",
"values": 869304
},
{
"key": "2009",
"values": 87850
},
{
"key": "2010",
"values": 257700
},
{
"key": "2011",
"values": 477915
},
{
"key": "2012",
"values": 743300
},
{
"key": "2013",
"values": 2097500
},
{
"key": "2014",
"values": 932950
}
]
},
{
"key": "DC",
"values": [
{
"key": "2008",
"values": 371099
},
{
"key": "2009",
"values": 83500
},
{
"key": "2010",
"values": 102600
},
{
"key": "2011",
"values": 466077
},
{
"key": "2012",
"values": 881574
},
{
"key": "2013",
"values": 1390315
},
{
"key": "2014",
"values": 572872
}
]
},
{
"key": "MA",
"values": [
{
"key": "2006",
"values": 386923
},
{
"key": "2007",
"values": 1394336
},
{
"key": "2008",
"values": 1360315
},
{
"key": "2009",
"values": 139251
},
{
"key": "2010",
"values": 611615
},
{
"key": "2011",
"values": 1403286
},
{
"key": "2012",
"values": 3512872
},
{
"key": "2013",
"values": 8839555
},
{
"key": "2014",
"values": 3684101
}
]
},
{
"key": "CT",
"values": [
{
"key": "2006",
"values": 30800
},
{
"key": "2007",
"values": 168159
},
{
"key": "2008",
"values": 581124
},
{
"key": "2009",
"values": 207450
},
{
"key": "2010",
"values": 444249
},
{
"key": "2011",
"values": 1236129
},
{
"key": "2012",
"values": 2727822
},
{
"key": "2013",
"values": 6940607
},
{
"key": "2014",
"values": 2517600
}
]
},
{
"key": "IN",
"values": [
{
"key": "2006",
"values": 302634
},
{
"key": "2007",
"values": 1029175
},
{
"key": "2008",
"values": 1206851
},
{
"key": "2009",
"values": 182549
},
{
"key": "2010",
"values": 605474
},
{
"key": "2011",
"values": 1504443
},
{
"key": "2012",
"values": 3084095
},
{
"key": "2013",
"values": 6435317
},
{
"key": "2014",
"values": 2414900
}
]
},
{
"key": "KY",
"values": [
{
"key": "2006",
"values": 2000
},
{
"key": "2007",
"values": 271707
},
{
"key": "2008",
"values": 442687
},
{
"key": "2009",
"values": 32000
},
{
"key": "2010",
"values": 213434
},
{
"key": "2011",
"values": 638390
},
{
"key": "2012",
"values": 1874384
},
{
"key": "2013",
"values": 3622258
},
{
"key": "2014",
"values": 1303258
}
]
},
{
"key": "OK",
"values": [
{
"key": "2006",
"values": 87904
},
{
"key": "2007",
"values": 633774
},
{
"key": "2008",
"values": 527739
},
{
"key": "2009",
"values": 80801
},
{
"key": "2010",
"values": 232750
},
{
"key": "2011",
"values": 554293
},
{
"key": "2012",
"values": 1367661
},
{
"key": "2013",
"values": 2911553
},
{
"key": "2014",
"values": 1339394
}
]
},
{
"key": "MS",
"values": [
{
"key": "2006",
"values": 17750
},
{
"key": "2007",
"values": 165950
},
{
"key": "2008",
"values": 377289
},
{
"key": "2009",
"values": 36680
},
{
"key": "2010",
"values": 181100
},
{
"key": "2011",
"values": 606673
},
{
"key": "2012",
"values": 1123985
},
{
"key": "2013",
"values": 2865027
},
{
"key": "2014",
"values": 1130656
}
]
},
{
"key": "WV",
"values": [
{
"key": "2006",
"values": 38650
},
{
"key": "2007",
"values": 120850
},
{
"key": "2008",
"values": 218790
},
{
"key": "2009",
"values": 43250
},
{
"key": "2010",
"values": 64200
},
{
"key": "2011",
"values": 283683
},
{
"key": "2012",
"values": 586982
},
{
"key": "2013",
"values": 1388761
},
{
"key": "2014",
"values": 431969
}
]
},
{
"key": "RI",
"values": [
{
"key": "2008",
"values": 94871
},
{
"key": "2009",
"values": 24500
},
{
"key": "2010",
"values": 121500
},
{
"key": "2011",
"values": 377964
},
{
"key": "2012",
"values": 642921
},
{
"key": "2013",
"values": 1858642
},
{
"key": "2014",
"values": 687065
}
]
},
{
"key": "TN",
"values": [
{
"key": "2006",
"values": 37300
},
{
"key": "2007",
"values": 76000
},
{
"key": "2008",
"values": 856595
},
{
"key": "2009",
"values": 121800
},
{
"key": "2010",
"values": 610785
},
{
"key": "2011",
"values": 1638637
},
{
"key": "2012",
"values": 2971738
},
{
"key": "2013",
"values": 5484716
},
{
"key": "2014",
"values": 2298304
}
]
},
{
"key": "ID",
"values": [
{
"key": "2006",
"values": 89650
},
{
"key": "2007",
"values": 455742
},
{
"key": "2008",
"values": 558203
},
{
"key": "2009",
"values": 67950
},
{
"key": "2010",
"values": 189299
},
{
"key": "2011",
"values": 316639
},
{
"key": "2012",
"values": 539600
},
{
"key": "2013",
"values": 1556879
},
{
"key": "2014",
"values": 733800
}
]
},
{
"key": "MT",
"values": [
{
"key": "2006",
"values": 51900
},
{
"key": "2007",
"values": 278934
},
{
"key": "2008",
"values": 239950
},
{
"key": "2009",
"values": 7685
},
{
"key": "2010",
"values": 51250
},
{
"key": "2011",
"values": 190986
},
{
"key": "2012",
"values": 332473
},
{
"key": "2013",
"values": 926700
},
{
"key": "2014",
"values": 289792
}
]
},
{
"key": "HI",
"values": [
{
"key": "2006",
"values": 24950
},
{
"key": "2007",
"values": 196700
},
{
"key": "2008",
"values": 262204
},
{
"key": "2009",
"values": 22500
},
{
"key": "2010",
"values": 41100
},
{
"key": "2011",
"values": 263205
},
{
"key": "2012",
"values": 567400
},
{
"key": "2013",
"values": 1723680
},
{
"key": "2014",
"values": 639700
}
]
},
{
"key": "NH",
"values": [
{
"key": "2006",
"values": 127108
},
{
"key": "2007",
"values": 490359
},
{
"key": "2008",
"values": 438127
},
{
"key": "2009",
"values": 18715
},
{
"key": "2010",
"values": 87900
},
{
"key": "2011",
"values": 343361
},
{
"key": "2012",
"values": 804132
},
{
"key": "2013",
"values": 1994833
},
{
"key": "2014",
"values": 909600
}
]
},
{
"key": "VT",
"values": [
{
"key": "2007",
"values": 50500
},
{
"key": "2008",
"values": 103100
},
{
"key": "2009",
"values": 14500
},
{
"key": "2010",
"values": 28100
},
{
"key": "2011",
"values": 91600
},
{
"key": "2012",
"values": 283938
},
{
"key": "2013",
"values": 804900
},
{
"key": "2014",
"values": 321858
}
]
},
{
"key": "WY",
"values": [
{
"key": "2006",
"values": 10250
},
{
"key": "2007",
"values": 59450
},
{
"key": "2008",
"values": 70174
},
{
"key": "2009",
"values": 7750
},
{
"key": "2010",
"values": 30650
},
{
"key": "2011",
"values": 75700
},
{
"key": "2012",
"values": 166428
},
{
"key": "2013",
"values": 600386
},
{
"key": "2014",
"values": 205000
}
]
},
{
"key": "ME",
"values": [
{
"key": "2006",
"values": 27150
},
{
"key": "2007",
"values": 149900
},
{
"key": "2008",
"values": 312758
}
]
},
{
"key": "AK",
"values": [
{
"key": "2006",
"values": 5000
},
{
"key": "2007",
"values": 91800
},
{
"key": "2008",
"values": 107574
},
{
"key": "2009",
"values": 12000
},
{
"key": "2010",
"values": 49700
},
{
"key": "2011",
"values": 170700
},
{
"key": "2012",
"values": 278447
},
{
"key": "2013",
"values": 710500
},
{
"key": "2014",
"values": 436640
}
]
},
{
"key": "IA",
"values": [
{
"key": "2006",
"values": 51001
},
{
"key": "2007",
"values": 473827
},
{
"key": "2008",
"values": 517129
}
]
},
{
"key": "SD",
"values": [
{
"key": "2009",
"values": 9500
},
{
"key": "2010",
"values": 51500
},
{
"key": "2011",
"values": 206650
},
{
"key": "2012",
"values": 318785
},
{
"key": "2013",
"values": 601200
},
{
"key": "2014",
"values": 266629
}
]
},
{
"key": "ND",
"values": [
{
"key": "2006",
"values": 31900
},
{
"key": "2007",
"values": 91360
},
{
"key": "2008",
"values": 91950
}
]
}
]
State Abbreviation
Alabama AL
Alaska AK
Arizona AZ
Arkansas AR
California CA
Colorado CO
Connecticut CT
Delaware DE
District of Columbia DC
Florida FL
Georgia GA
Hawaii HI
Idaho ID
Illinois IL
Indiana IN
Iowa IA
Kansas KS
Kentucky KY
Louisiana LA
Maine ME
Montana MT
Nebraska NE
Nevada NV
New Hampshire NH
New Jersey NJ
New Mexico NM
New York NY
North Carolina NC
North Dakota ND
Ohio OH
Oklahoma OK
Oregon OR
Maryland MD
Massachusetts MA
Michigan MI
Minnesota MN
Mississippi MS
Missouri MO
Pennsylvania PA
Rhode Island RI
South Carolina SC
South Dakota SD
Tennessee TN
Texas TX
Utah UT
Vermont VT
Virginia VA
Washington WA
West Virginia WV
Wisconsin WI
Wyoming WY
Display the source blob
Display the rendered blob
Raw
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@zyenge
Copy link

zyenge commented Jun 26, 2016

It's very clear that the map is showing the changes in loans in different states overtime, the overall trend seems to be growing, but the comparison is a little weak, it's a little hard to tell which states grew faster than the others.

  1. the size of the chart and text are a little off due to laptop resolution
  2. the type of the legend is a little confusing, it's not heat map, should use spectrum for heatmap.
  3. there is no color difference between NC (>300k) and Kentucky (2k)
  4. title says it's from 2008, the chart starts from 2006

@karbar09
Copy link
Author

@zyenge - Thanks so much for the feedback - all of your suggestions have been incorporated. Please check out the updated visualization here!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment