lobbying_contributions

Political contributions reported by lobbyists on LD-203 forms. Includes contribution amounts, recipients, and dates — required disclosures for registered lobbyists.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

2 rows where contribution_type = "pic" and filing_year = 2011 sorted by contribution_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_date (date), received_date (date)

filing_year 1

  • 2011 · 2 ✖

contribution_type 1

id filing_uuid lobbyist_name contributor_name payee_name recipient_name contribution_type amount contribution_date ▲ filing_year filing_period registrant_name received_date
804456 7b88e5f7-eae5-484b-80b0-96247b3dac00   MOSHER, ROBERT ROBERT J. MOSHER   pic 0 2011-12-31 2011 year_end ALLIANCE TO SAVE ENERGY 2012-01-30T18:35:21.020000-05:00
812076 ee06ed84-76f2-4688-88a0-ccab8b04a264   LEFEVERS, DANIEL RICK PERRY FOR PRESIDENT   pic 500 2011-09-30 2011 year_end GAS TECHNOLOGY INSTITUTE 2012-02-01T17:49:28.460000-05:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE lobbying_contributions (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            lobbyist_name TEXT,
            contributor_name TEXT,
            payee_name TEXT,
            recipient_name TEXT,
            contribution_type TEXT,
            amount INTEGER,
            contribution_date TEXT,
            filing_year INTEGER,
            filing_period TEXT,
            registrant_name TEXT,
            received_date TEXT
        );
CREATE INDEX idx_contrib_lobbyist ON lobbying_contributions(lobbyist_name COLLATE NOCASE);
CREATE INDEX idx_contrib_recipient ON lobbying_contributions(recipient_name COLLATE NOCASE);
CREATE INDEX idx_contrib_year ON lobbying_contributions(filing_year);