TCS has created a database and analysis/commentary for FY2008 earmarks in appropriations and authorizations. The spreadsheet columns for each House and Senate appropriations includes the earmark dollar amount, budget request (Administration requested earmarks), description of the earmarks, city/location-county-state, bill section (department), bill subsection (agency), requesting Member, party affiliation, state, and a note column. Most of the columns can be customized, show the top ten in each category, amounts in ascending or descending order, or in alphabetical order.The “Notes” column shows when the Committee did not fund an administration requested earmark and will sometimes provide a link to the OMB website that provides further information about the specific earmark. The column also notes when an earmark is divided between more than one state.
The Calculations page shows the total dollar amounts by state and will often give the total dollar amount of earmarks, the total number of earmarks, the number and value of disclosed earmarks and the number and value of undisclosed earmarks.
The Analysis link provides commentary on the bill and at the end will sometimes provide a list of earmark dollar amounts and numbers for each subcommittee member as well as for the leadership.
OMB Database Page – FY2005 complete and FY2008 estimated:
OMB’s earmark databases for appropriations and authorizations covers FY2005 and FY2008 (estimates). Each database provide dollar amounts and the number of earmarks by bill, department or agency, and by appropriation account, but does not provide information on Members or earmarks requested by the Administration.
The FY2005 earmark list can be searched by agency or state and has a link to download the data. A link also provides a summary of earmarks and dollar amounts for each FY2005 appropriations bill. It also shows whether the earmark is continuing or first-time and whether the earmark had been reduced by an across-the-board rescission, whether a lesser amount was awarded, or has not been awarded yet.
