DOWNLOAD FY 2008 EARMARKS FILE FOR ADDITIONAL ANALYSIS
This file is in CSV (comma space delimited) format.
It can be imported into almost any database model or spreadsheet program.
It is provided for purposes of performing more robust analysis
than can be supported on this website.
The "Earmarks Field Definition" file provides definitions of the data.
The viewer may use the Field Definition file when drilling down to
view individual Earmarks or when examining the CSV file.
The total number of lines in the CSV file is greater than the total number
of earmarks due to the fact that some earmarks have multiple recipients
and/or sponsors.
Each recipient and/or sponsor shows up as a separate row in the CSV file. The key thing
to look at in the CSV file is the earmark "short description"
and "earmark ID," which in combination define a unique earmark.
When the entries in those two columns are the same for multiple rows, then
each row represents a different recipient within that earmark.
For some earmarks with multiple recipients, the amount has not yet been allocated
among the intended recipients. In these cases, the aggregate is listed
under one (usually the primary) recipient. The "amount" column for
other recipients is left blank, in order to maintain the total amount of
earmarked funds correctly.
The legal citation, if included in the database as a pdf file, will not be
included in the downloaded CSV file. To see the
pdf file, use the links on this website.
In the CSV file, under the recipient type column, an "R" value stand for
recipient/beneficiary information and a "C" value stands for sponsor data.
