Ever wonder about the federal government’s checkbook? Well now you can take a peak inside for each day using Treasury.io. “Every day at 4pm, the United States Treasury publishes data tables summarizing the cash spending, deposits, and borrowing of the federal government.” Those data tables “catalog all the money taken in that day from taxes, the programs, and how much debt the government took out.”
One hitch: The Treasury’s data tables are (subjectively) ugly and (objectively) spreadsheet-unfriendly. So Treasury.io — an open-source civic project complete with a github repository! — continuously converts the files into good ol’ tabular data. You can download individual tables as CSVs, get the whole dataset as a big SQLite database, or query the API. There’s also a data dictionary and a Twitter bot.
HT to Jeremy Singer-Vine and his amazing Data Is Plural weekly newsletter of useful/curious datasets. If you haven’t subscribed, then you ought to go over there right now and do so post haste!
Every day at 4pm, the United States Treasury publishes data tables summarizing the cash spending, deposits, and borrowing of the Federal government. These files catalog all the money taken in that day from taxes, the programs, and how much debt the government took out to make it happen. It comes from a section of the U.S. Treasury called the Bureau of the Fiscal Service.
At a time of record fiscal deficits and continual debates over spending, taxation, and the debt, this daily accounting of our government’s main checking account is an essential data point that the public should have ready access to.
Here’s some good news from our friends at the Sunlight Foundation. After much work by Sunlight, the Congressional Data Coalition, and many others, the “Open, Public, Electronic, and Necessary Government Data Act” or the “OPEN Government Data Act” (S.2852) just passed the US Senate with an amendment by unanimous consent. The OPEN Government Data Act has been a core priority of the Sunlight Foundation in Washington in 2016. The OPEN Government Data Act would put into law a set of enduring open data principles upon which we can all agree! Hopefully, in early 2017, the US House will introduce a similar bill and send the bill to the President — and then they can get to work on making CRS reports publicly available too!
From Sunlight’s daily newsletter:
…the Senate has provided a unanimous endorsement of a set of enduring open data principles that the Sunlight Foundation has advanced and defended for a decade: that data created using the funds of the people should be available to the people in open formats online, without cost or restriction. We hope that the U.S. House will quickly move to re-introduce the bill in the 115th Congress and work across the aisle to enact it within the first week of public business. We expect the members of Congress who stood up for open government data this fall to continue do so in 2017.
A new report by the Data Foundation and Grant Thornton LLP “seeks to capture the moment, provide a vision of the future, and catalyze further efforts for the open data movement.” It includes interviews with more than 40 Congressional and agency leaders, open data experts and advocates, and private sector leaders. It also has a a brief history and timeline of the open data movement
- The State Of The Union Of Open Data, 2016, by Alison Gill, Hudson Hollister, and Adam Hughes, The Data Foundation and Grant Thornton.
NextGov has a brief summary of the report:
- The Progress and Pitfalls of Government’s Open Data Efforts By Frank Konkel NextGov (November 2, 2016)
“[I]t’s one thing to put the data out there for the public to consume or to potentially spark new industries; it’s another to standardize those data sets.”
Sign up now for this year’s Legislative Data and Transparency Conference (#LDTC16) held in Washington DC. In years past, they’ve streamed the proceedings, so definitely sign up for free if you’re interested in open legislative data, even if you’re not in the DC area!
The 2016 Legislative Data and Transparency Conference (#LDTC16), hosted by the Committee on House Administration, will take place on Tuesday, June 21, 2016, from 9 a.m. to 4 p.m. in the Capitol Visitor Center Congressional Auditorium.
The #LDTC16 brings individuals from Legislative Branch agencies together with data users and transparency advocates to foster a conversation about the use of legislative data – addressing how agencies use technology well and how they can use it better in the future.
Tuesday, June 21, 2016 from 9:00 AM to 4:00 PM (EDT) – Add to Calendar
Capitol Visitor Center Congressional Auditorium
I’ve had a tab open to this ProPublica post “A New Way to Keep an Eye on Who Represents You in Congress” for a couple of weeks and just now getting around to sharing. Their new project called “Represent” is a great way to track on lawmakers, the bills they consider and the votes they take (and miss). Search for your legislators by address, ZIP code or name. A very handy tool indeed. But 2 things stand out especially about this new effort: 1) “Represent” not only collates data from a variety of government resources (see below) but they also point out to other sites that offer valuable features like individual lawmaker and bill pages on GovTrack and C-SPAN; and 2) They’re making available all the data that they use through their API. Their data sources include:
- The official Web site of the Office of the Clerk of the U.S. House of Representatives, for vote data
- The official Web site of the United States Senate, for vote data
- The Biographical Directory of the United States Congress, for member biographical information
- The United States Project, for social media account names in member lists and some member biographical information
- MIT Professor Charles Stewart’s collection of Congressional data, for some role information
- Congress.gov (The Library of Congress) and the Government Publishing Office, for bill data and nomination data
Check it out, bookmark it, and let your library patrons know about it!
Today ProPublica is launching a new interactive database that will help you keep track of the officials who represent you in Congress.
The project is the continuation of two projects I worked on at The New York Times — the first is the Inside Congress database, which we are taking over at ProPublica starting today.
But we also have big plans for it. While the original interactive database at The Times focused on bills and votes, our new project adds pages for each elected official, where you can find their latest votes, legislation they support and statistics about their voting. As we move forward we want to add much more data to help you understand how your elected officials represent you, the incentives that drive them and the issues they care about.
In that way, it is also a continuation of another project I worked on at the Times. In late 2008, The New York Times launched an app called Represent that connected city residents with the officials who represented them at the local, state and federal levels. It was an experiment in trying to make it easier to keep track of what elected officials were doing.
Because ProPublica is rekindling that effort, we’re calling the new project Represent.
The new Represent will help you track members, votes and bills in the House of Representatives and Senate. We’re also launching a Congress API, or Application Programming Interface, so developers can get data about what Congress is doing, too.