Codebook: campaigncontributionsdownload.csv

The campaigncontributionsdownload.csv file is one of a number of data files available for download on the Open Maine Politics website. It is a comma-delimited file that can be opened by any modern spreadsheet or database program.  Much of this data is downloaded from the Maine Ethics Commission, but the dataset has been refined, error-checked and mildly extended. Commercial and non-profit contributions from sources that share a name and address are grouped together for clarity in presentation.  Each row of the dataset represents one contribution by a corporate entity or campaign committee to another committee or to a member of the 127th Maine State Legislature in the 2013-2014 election season.  Contributions by individuals are not included in this data set.  Variables for each row are organized into sixteen columns:

Column 1: ReceiptID: a unique id used by the Maine Ethics Commission to refer to a unique contribution.

Column 2: ReceiptType: monetary, in-kind (a good or service with a monetary value), returned contribution or “Other” (usually accompanied by note in column 16).

Column 3: ReceiptAmount: monetary value of the contribution (negative value if a returned contribution).

Column 4: SourceOrgID — if the source is a political committee officially registered with the Maine Ethics Commission, the commission’s unique id used to refer to the committee.  Otherwise, blank.

Column 5: SourceOtherID — unique ID used by Open Maine Politics to keep track of corporate entities and committees making contributions but not officially registered with the Maine Ethics Commission.

Column 6: SourceName — name of the entity making the contribution.

Column 7: SourceAddress1 — first part of the address of the entity making the contribution.

Column 8: SourceAddress2 — second part of the address of the entity making the contribution (if any).

Column 9: SourceCity — city in which the entity making the contribution is located.

Column 10: SourceState — state in which the entity making the contribution is located.

Column 11: RecipientOrgID — unique id used by the Maine Ethics Commission to refer to the committee or legislator receiving the contribution.

Column 12: RecipientCommitteeType — kind of entity receiving the contribution — PAC, candidate, ballot question committee or party committee.  Classification made by the Maine Ethics Commission.

Column 13: RecipientCommitteeName — if the recipient is a committee, name of the committee.

Column 14: RecipientCandidateName — if the recipient is a candidate, name of the candidate.

Column 15: Amended — has the contribution report been amended? (Y/N)

Column 16: Description — additional notes describing the contribution, entered by the Maine Ethics Commission.

Share this page…Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInShare on TumblrDigg thisShare on RedditEmail this to someonePrint this page

Be the first to comment on "Codebook: campaigncontributionsdownload.csv"

Leave a comment

Democracy thrives on participation; please share your thoughts!
Your email address will not be published. Required fields are marked *

Your email address will not be published.


*