Links to House earmark disclosures in one database
By Bill Allison Apr 06 2009 6:19 p.m. 12 commentsHouse members had to post their earmark requests for fiscal year 2010 online this weekend; the original deadline was Friday, but that was extended to Saturday at 5 p.m., according to CNN.
So how many members made the deadline? I can't be sure, but I tried to find out over the weekend. I went through 430-some Web sites (there are a few vacancies right now -- Rahm Emanuel's seat, Hilda Solis' seat, and Kirsten Gillibrand's seat) looking for those disclosures (sometimes it was really interesting, sometimes it was thankless drudgery). On 116 Web pages, I couldn't find any earmark disclosures (some of these may be from members who don't disclose earmarks -- I used the Club for Growth's list of earmark abstainers, but found that some members on it -- like Rep. Duncan Hunter -- did request earmarks. There were also four members who looked like they were set up to disclose earmarks, but hadn't posted any content.
As I suspected, the disclosures are useless if you want to aggregate them for the entire House. Some members posted unreadable pdfs (I indicated this sometimes in the notes). Some posted charts. Some have press releases for every single earmark, others have downloadable Word documents. Some members posted the complete request letters (again, I tried to indicate this), others posted the bare minimum amount of information.
Have a look at what I found, and if I've missed things, please leave them in comments below. I suspect a lot of members will be adding disclosures to their sites today.
The most amazing thing (which I thought about as I did this) is that I believe this is the first time members have been required to use their official Web sites for disclosure. Next time, let's hope they plan a little better so that the information is easier to get to.
Update: You can download my data here in an Excel spreadsheet. Another note: in some of the comments, I noted whether or not the disclosure was hard to find. This was largely subjective, but basically, if I had to scroll to the bottom of a lengthy page that seemed to have nothing do with earmarks to find the disclosure, I labeled it hard to find. These were definitely hard for me to find, anyway...
Update 2: There are 292 members who had earmark disclosures online when I finished my work. That figure does not include an erroneous link to a Don Young disclosure, linked from his home page. That was for FY 2009 requests, not FY 2010.
Update 3: Rep. Allyson Schwartz's list of earmark requests is under a section titled "Fighting For My Constituents' Priorities." Just updated the database.
Search the Blog
Related Content
- Earmarks 121
- Handy Tools 72
- online disclosure 4
- Research 120
Real Time Ticker
Recent Posts
Reporting we're watching
- OpenSecrets: Millionaire Freshmen Make Congress Even Wealthier
- Sunlight Foundation: The Political Spending of 501(c)(4) Nonprofits in the 2012 Election
- Sunlight Foundation: Watch TransparencyCamp ideas grow!
- Sunlight Foundation: Integrating the US' Documents
- Sunlight Foundation: 2Day in #OpenGov 5/20/2013




This is great work. It would be nice to be able to filter your dataset by state; the search doesn't seem to support that.
Would you consider making the dataset available as a CSV file or similar?
Congressman Dennis Moore's funding requests are available on his website, as are previous lists. Please see the "In Focus" section on the main page of his website.
I took a crack at scraping a few of them and produced 3 datafiles. It's annoying, but it's not so insurmountable.
http://blog.germuska.com/2009/04/06/more-like-translucent-than-transparent/
[...] ← Links to House earmark disclosures in one database [...]
Congressman Jo Bonner's requests are available at http://bonner.house.gov/HoR/AL01/Funding+Opportunities/FY10Appropriations.htm - under 'Funding Opportunities - Appropriations'
[...] For a list of all Members’ earmarks that were available, see the Sunlight Foundation’s ‘Real Time Investigations’ blog. [...]
Thanks so much for this hard work you put. I am looking through all of South Carolina now to see what my representatives are asking for.
Thank you, much needed work.
[...] we go along (hashtag: #wheremark), and see whether deadlines make a difference. When I looked for appropriations earmark requests, I found earmark request disclosures or indications that members weren’t requesting earmarks [...]
[...] continue to update the database, at a much slower rate, throughout the week, but as with our previous efforts in this area, I’d much rather be looking at actual earmark requests than criticizing the [...]
[...] agenda this year. Still, government watchdog groups such as the Sunlight Foundation have had a devil of a time trying to create a centralized database of Congress' project requests that could bring local [...]
[...] agenda this year. Still, government watchdog groups such as the Sunlight Foundation have had a devil of a time trying to create a centralized database of Congress' project requests that could bring local [...]