jonchretien · December 31, 2013 17:46
diff --git a/README.md b/README.md
diff --git a/index.html b/index.html
 <!DOCTYPE html>
 <meta charset="utf-8">
 <style>

 .axis text {
  font: 10px sans-serif;
 }

 .axis path,
 .axis line {
  fill: none;
  stroke: #000;
  shape-rendering: crispEdges;
 }

 .axis--y path {
  display: none;
 }

 .cities {
  fill: none;
  stroke: #777;
  stroke-linejoin: round;
  stroke-linecap: round;
  stroke-opacity: .15;
  stroke-width: 1.5px;
 }

 </style>
 <body>
 <script src="http://d3js.org/d3.v3.min.js"></script>
 <script>

 var months,
    monthFormat = d3.time.format("%Y-%m");

 var margin = {top: 20, right: 30, bottom: 30, left: 40},
    width = 960 - margin.left - margin.right,
    height = 500 - margin.top - margin.bottom;

 var x = d3.time.scale()
    .range([0, width]);

 var y = d3.scale.linear()
    .range([height, 0]);

 var line = d3.svg.line()
    .x(function(d) { return x(d.date); })
    .y(function(d) { return y(d.value); });

 var svg = d3.select("body").append("svg")
    .attr("width", width + margin.left + margin.right)
    .attr("height", height + margin.top + margin.bottom)
  .append("g")
    .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

 d3.tsv("unemployment.tsv", type, function(error, cities) {
  x.domain(d3.extent(months));
  y.domain([0, d3.max(cities, function(c) { return d3.max(c.values, function(d) { return d.value; }); })]);

  svg.append("g")
      .attr("class", "axis axis--x")
      .attr("transform", "translate(0," + height + ")")
      .call(d3.svg.axis()
        .scale(x)
        .orient("bottom"));

  svg.append("g")
      .attr("class", "axis axis--y")
      .call(d3.svg.axis()
        .scale(y)
        .orient("left")
        .ticks(10, "%"))
    .append("text")
      .attr("x", 4)
      .attr("y", 7)
      .attr("dy", ".35em")
      .style("font-weight", "bold")
      .text("Unemployment Rate");

  svg.append("g")
      .attr("class", "cities")
    .selectAll("path")
      .data(cities)
    .enter().append("path")
      .attr("d", function(d) { return line(d.values); });
 });

 function type(d, i) {
  if (!i) months = Object.keys(d).map(monthFormat.parse).filter(Number);
  return {
    name: d.name,
    values: months.map(function(m) {
      return {
        date: m,
        value: d[monthFormat(m)] / 100
      };
    })
  };
 }

 </script>
diff --git a/Makefile b/Makefile
 GENERATED_FILES = \
 	unemployment.tsv

 .PHONY: all clean

 all: $(GENERATED_FILES)

 clean:
 	rm -rf -- $(GENERATED_FILES)

 # http://www.bls.gov/lau/metrossa.htm
 build/ssamatab1.txt:
 	mkdir -p build
 	curl -o $@ 'http://www.bls.gov/lau/ssamatab1.txt'

 unemployment.tsv: process-data build/ssamatab1.txt
 	./process-data build/ssamatab1.txt > $@
diff --git a/package.json b/package.json
 {
  "name": "anonymous",
  "version": "0.0.1",
  "private": true,
  "devDependencies": {
    "d3": "3"
  }
 }
diff --git a/process-data b/process-data
 #!/usr/bin/env node

 var fs = require("fs"),
    d3 = require("d3");

 // Parse lines.
 var lines = fs.readFileSync(process.argv[2], "utf8").split(/[\r\n]+/);

 // Parse fixed-width columns.
 var data = lines.filter(function(d, i) {
  return i >= 3 && i <= lines.length - 4;
 }).map(function(line) {
  var fields = line.split(/\s{2,}/), i = -1;
  return {
    "LAUS Code": fields[++i],
    "State FIPS Code": fields[++i],
    "Area FIPS Code": fields[++i],
    "Area": fields[++i],
    "Year": fields[++i],
    "Month": fields[++i],
    "Civilian Labor Force": +fields[++i].replace(/,/g, ""),
    "Employment": +fields[++i].replace(/,/g, ""),
    "Unemployment": +fields[++i].replace(/,/g, ""),
    "Unemployment Rate": +fields[++i]
  };
 });

 // Extract the available dates.
 var dates = d3.set(data.map(function(d) { return d["Year"] + "-" + d["Month"]; })).values().sort();

 // Nest unemployment rate by area and date.
 var rateByNameAndDate = d3.nest()
    .key(function(d) { return d["Area"]; })
    .key(function(d) { return d["Year"] + "-" + d["Month"]; })
    .rollup(function(v) { return v[0]["Unemployment Rate"]; }) // leaf is unique
    .map(data, d3.map);

 // Recast data into a wide table.
 var rows = rateByNameAndDate.entries().sort(function(a, b) { return d3.ascending(a.key, b.key); }).map(function(area) {
  return [area.key].concat(dates.map(function(d) {
    return area.value.get(d);
  }));
 });

 process.stdout.write(d3.tsv.formatRows([["name"].concat(dates)].concat(rows)));
diff --git a/thumbnail.png b/thumbnail.png
diff --git a/unemployment.tsv b/unemployment.tsv
	<!DOCTYPE html>
	<meta charset="utf-8">
	<style>

	.axis text {
	font: 10px sans-serif;
	}

	.axis path,
	.axis line {
	fill: none;
	stroke: #000;
	shape-rendering: crispEdges;
	}

	.axis--y path {
	display: none;
	}

	.cities {
	fill: none;
	stroke: #777;
	stroke-linejoin: round;
	stroke-linecap: round;
	stroke-opacity: .15;
	stroke-width: 1.5px;
	}

	</style>
	<body>
	<script src="http://d3js.org/d3.v3.min.js"></script>
	<script>

	var months,
	monthFormat = d3.time.format("%Y-%m");

	var margin = {top: 20, right: 30, bottom: 30, left: 40},
	width = 960 - margin.left - margin.right,
	height = 500 - margin.top - margin.bottom;

	var x = d3.time.scale()
	.range([0, width]);

	var y = d3.scale.linear()
	.range([height, 0]);

	var line = d3.svg.line()
	.x(function(d) { return x(d.date); })
	.y(function(d) { return y(d.value); });

	var svg = d3.select("body").append("svg")
	.attr("width", width + margin.left + margin.right)
	.attr("height", height + margin.top + margin.bottom)
	.append("g")
	.attr("transform", "translate(" + margin.left + "," + margin.top + ")");

	d3.tsv("unemployment.tsv", type, function(error, cities) {
	x.domain(d3.extent(months));
	y.domain([0, d3.max(cities, function(c) { return d3.max(c.values, function(d) { return d.value; }); })]);

	svg.append("g")
	.attr("class", "axis axis--x")
	.attr("transform", "translate(0," + height + ")")
	.call(d3.svg.axis()
	.scale(x)
	.orient("bottom"));

	svg.append("g")
	.attr("class", "axis axis--y")
	.call(d3.svg.axis()
	.scale(y)
	.orient("left")
	.ticks(10, "%"))
	.append("text")
	.attr("x", 4)
	.attr("y", 7)
	.attr("dy", ".35em")
	.style("font-weight", "bold")
	.text("Unemployment Rate");

	svg.append("g")
	.attr("class", "cities")
	.selectAll("path")
	.data(cities)
	.enter().append("path")
	.attr("d", function(d) { return line(d.values); });
	});

	function type(d, i) {
	if (!i) months = Object.keys(d).map(monthFormat.parse).filter(Number);
	return {
	name: d.name,
	values: months.map(function(m) {
	return {
	date: m,
	value: d[monthFormat(m)] / 100
	};
	})
	};
	}

	</script>
	GENERATED_FILES = \
	unemployment.tsv

	.PHONY: all clean

	all: $(GENERATED_FILES)

	clean:
	rm -rf -- $(GENERATED_FILES)

	# http://www.bls.gov/lau/metrossa.htm
	build/ssamatab1.txt:
	mkdir -p build
	curl -o $@ 'http://www.bls.gov/lau/ssamatab1.txt'

	unemployment.tsv: process-data build/ssamatab1.txt
	./process-data build/ssamatab1.txt > $@
	{
	"name": "anonymous",
	"version": "0.0.1",
	"private": true,
	"devDependencies": {
	"d3": "3"
	}
	}
	#!/usr/bin/env node

	var fs = require("fs"),
	d3 = require("d3");

	// Parse lines.
	var lines = fs.readFileSync(process.argv[2], "utf8").split(/[\r\n]+/);

	// Parse fixed-width columns.
	var data = lines.filter(function(d, i) {
	return i >= 3 && i <= lines.length - 4;
	}).map(function(line) {
	var fields = line.split(/\s{2,}/), i = -1;
	return {
	"LAUS Code": fields[++i],
	"State FIPS Code": fields[++i],
	"Area FIPS Code": fields[++i],
	"Area": fields[++i],
	"Year": fields[++i],
	"Month": fields[++i],
	"Civilian Labor Force": +fields[++i].replace(/,/g, ""),
	"Employment": +fields[++i].replace(/,/g, ""),
	"Unemployment": +fields[++i].replace(/,/g, ""),
	"Unemployment Rate": +fields[++i]
	};
	});

	// Extract the available dates.
	var dates = d3.set(data.map(function(d) { return d["Year"] + "-" + d["Month"]; })).values().sort();

	// Nest unemployment rate by area and date.
	var rateByNameAndDate = d3.nest()
	.key(function(d) { return d["Area"]; })
	.key(function(d) { return d["Year"] + "-" + d["Month"]; })
	.rollup(function(v) { return v[0]["Unemployment Rate"]; }) // leaf is unique
	.map(data, d3.map);

	// Recast data into a wide table.
	var rows = rateByNameAndDate.entries().sort(function(a, b) { return d3.ascending(a.key, b.key); }).map(function(area) {
	return [area.key].concat(dates.map(function(d) {
	return area.value.get(d);
	}));
	});

	process.stdout.write(d3.tsv.formatRows([["name"].concat(dates)].concat(rows)));