@WSJ financial investigations team. @ProPublica and @Reuters alum. Data diver, finance geek. Views my own. email@example.com / PGP 0x186a257ab948e1be
Cezary’s work on Source
Articles by Cezary
How we made a daily data feed for the U.S. TreasuryPosted on
The U.S. Treasury’s Daily Treasury Statement lists actual cash spending down to the million on everything the government spent money on each day, as well as how it funded the spending. But, the Treasury only releases these files in PDF or fixed-width text files like this one, making any analysis very difficult. To liberate the data and make it easy to analyze federal money flows across time, we created Treasury.IO. The system we built downloads and parses the fixed-width files into a standard schema, creating a SQLite database that can be directly queried via a URL endpoint.