Now You Can See Your Congressman’s Spending

Data

Now You Can See Your Congressman’s Spending

HouseSpendDataSmallUSCongressExpensesV3As part of our Federal government’s commitment to greater transparency, The US House of Representatives released its Statement of Disbursements (SOD) in electronic format, late November, covering July 1, 2009 through September 20, 2009.

The government has been required by law to publish this information since 1964. But, this is the first time the data has been available in a convenient electronic form. The main file I used to build the workbook was created The Sunlight Foundation and Socrata.

What is the SOD?

The (SOD) details what each Congressman spends for office staff salaries, travel expenses, office supplies, mailing services (Franked Mail), and other office-related expenses.

Today, Tableau published a Tableau Public version of the workbook on their website blog. You can download a copy of the packaged workbook and the source spreadsheet file I used to create the analysis at the bottom of this post.

What I added

The (SOD) file detailed every line item of expense by congressmen sorted by category. The Sunlight Foundation file that I used didn’t include information on each congressman’s state, district or party affiliation, so I downloaded and appended that data into the set.

Start Investigating

The workbook includes (3) dashboards. You can see how varied the spending has been by category, by state, by party affiliation from using high-level view. Alternatively you can explore the details of each congressman’s spending within your own state.

You will need the free Tableau Reader to view the files and If your not running Office 2007 you may also need to download and install the Office 2007 Connectivity Components.

Do you have any thoughts on how this analysis might be improved? Post a comment. I’d love to hear your ideas.

Source Spreadsheet – HouseSpendDataSmall

Tableau Packaged Workbook – USCongressExpensesV3

More About the Author

Dan Murray

Director of Strategic Innovations
A Data Viz of U.S. Lumber Prices in 2021 My wife and I moved into our downsized home three years ago. Our timing was good. There was some available inventory, and we were able ...
Tableau Conference 2020: Keynote Recap I’ve been going to Tableau Conferences ever since the first one at the Edgewater Hotel in Seattle in 2008. There were around 200 total ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072