andrewxhill/index.html

## index.html
<!DOCTYPE html>
<meta charset="utf-8">
<script src="http://d3js.org/d3.v3.min.js"></script>
<script src="http://libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script>
<style>

body {
  font: 10px sans-serif;
}

svg {
  padding: 10px 0 0 10px;
}

.arc {
  stroke: #fff;
}

</style>
<body>
<script>

var radius = 64,
    padding = 10;


var first_layer = 'unemploy_annual';

var sql = new cartodb.SQL({ user: 'wdbassetmap', format: 'json', dp: 5});

// var color = d3.scale.ordinal()
//     .range(["#98abc5", "#8a89a6", "#7b6888", "#6b486b", "#a05d56", "#d0743c", "#ff8c00"]);

var color = d3.scale.linear()
    .domain([0, 0.03, 0.05, 0.07, 0.10, 0.14, 0.25])
    .range(["916D80","B64880","#C83680", "#DA2480", "#EC1280", "#FF0080", "red"])
    .interpolate(d3.interpolateLab);

var arc = d3.svg.arc()
    .outerRadius(radius)
    .innerRadius(radius - 30);

var pie = d3.layout.pie()
    .sort(null)
    .value(function(d) {
      //return d.val;
      return 40
    });

sql.execute("SELECT name, jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec FROM {{table_name}}", {table_name: first_layer})
  .done(function(collection) {
  var data = collection.rows;

  // color.domain(d3.keys(data[0]).filter(function(key) {
  //   return key !== "name"; }));

  var months = [];
  d3.keys(data[0]).forEach(function(v){
    if (v !== "name") months.push(v)
  });

  data.forEach(function(d) {
    d.ages = d3.values(months).map(function(name) {
      //console.log(d, name)
      return {name: name, val: +d[name]};
    });
  });

  var legend = d3.select("body").append("svg")
      .attr("class", "legend")
      .attr("width", radius * 2)
      .attr("height", radius * 2)
    .selectAll("g")
      .data(color.domain().slice().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", color);

  legend.append("text")
      .attr("x", 24)
      .attr("y", 9)
      .attr("dy", ".35em")
      .text(function(d) { return d; });

  var svg = d3.select("body").selectAll(".pie")
      .data(data)
    .enter().append("svg")
      .attr("class", "pie")
      .attr("width", radius * 2)
      .attr("height", radius * 2)
    .append("g")
      .attr("transform", "translate(" + radius + "," + radius + ")");

  svg.selectAll(".arc")
      .data(function(d) { return pie(d.ages); })
    .enter().append("path")
      .attr("class", "arc")
      .attr("d", arc)
      .style("fill", function(d) {
        return color(d.data.val); });

  svg.append("text")
      .attr("dy", ".35em")
      .style("text-anchor", "middle")
      .text(function(d) { return d.name; });

});

</script>
	<!DOCTYPE html>
	<meta charset="utf-8">
	<script src="http://d3js.org/d3.v3.min.js"></script>
	<script src="http://libs.cartocdn.com/cartodb.js/v2/cartodb.js"></script>
	<style>

	body {
	font: 10px sans-serif;
	}

	svg {
	padding: 10px 0 0 10px;
	}

	.arc {
	stroke: #fff;
	}

	</style>
	<body>
	<script>

	var radius = 64,
	padding = 10;


	var first_layer = 'unemploy_annual';

	var sql = new cartodb.SQL({ user: 'wdbassetmap', format: 'json', dp: 5});

	// var color = d3.scale.ordinal()
	// .range(["#98abc5", "#8a89a6", "#7b6888", "#6b486b", "#a05d56", "#d0743c", "#ff8c00"]);

	var color = d3.scale.linear()
	.domain([0, 0.03, 0.05, 0.07, 0.10, 0.14, 0.25])
	.range(["916D80","B64880","#C83680", "#DA2480", "#EC1280", "#FF0080", "red"])
	.interpolate(d3.interpolateLab);

	var arc = d3.svg.arc()
	.outerRadius(radius)
	.innerRadius(radius - 30);

	var pie = d3.layout.pie()
	.sort(null)
	.value(function(d) {
	//return d.val;
	return 40
	});

	sql.execute("SELECT name, jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec FROM {{table_name}}", {table_name: first_layer})
	.done(function(collection) {
	var data = collection.rows;

	// color.domain(d3.keys(data[0]).filter(function(key) {
	// return key !== "name"; }));

	var months = [];
	d3.keys(data[0]).forEach(function(v){
	if (v !== "name") months.push(v)
	});

	data.forEach(function(d) {
	d.ages = d3.values(months).map(function(name) {
	//console.log(d, name)
	return {name: name, val: +d[name]};
	});
	});

	var legend = d3.select("body").append("svg")
	.attr("class", "legend")
	.attr("width", radius * 2)
	.attr("height", radius * 2)
	.selectAll("g")
	.data(color.domain().slice().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", color);

	legend.append("text")
	.attr("x", 24)
	.attr("y", 9)
	.attr("dy", ".35em")
	.text(function(d) { return d; });

	var svg = d3.select("body").selectAll(".pie")
	.data(data)
	.enter().append("svg")
	.attr("class", "pie")
	.attr("width", radius * 2)
	.attr("height", radius * 2)
	.append("g")
	.attr("transform", "translate(" + radius + "," + radius + ")");

	svg.selectAll(".arc")
	.data(function(d) { return pie(d.ages); })
	.enter().append("path")
	.attr("class", "arc")
	.attr("d", arc)
	.style("fill", function(d) {
	return color(d.data.val); });

	svg.append("text")
	.attr("dy", ".35em")
	.style("text-anchor", "middle")
	.text(function(d) { return d.name; });

	});

	</script>