Ken Cooper | Teaching Innovation.

Alex Howard

I first met Alex Howard in Los Angeles at Gov20LA a few years ago. This was shortly before he joined O’Reilly Media as its Washington correspondent covering the open government/Gov 2.0 beat.

Since then, he has covered every...

This animation visualizes one week’s worth of turnstile data for the New York City Subway. The MTA compiles data weekly and makes it available here.

The data is far from usable in its raw format, and is broken into week-long chunks for a specific control area and also includes running counts for a turnstile at a given time (like an odometer).

Using a Ruby script and a lot of Excel-mashing, we can pull out...