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

1 row where contribution_type = "pic" and filing_year = 2010 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

  • 2010 · 1 ✖

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
629722 721a2f63-c987-42af-8472-cea7c731b70e   HAWKINS, DANIEL RONALD JR DEMOCRATIC SENATORIAL CAMPAIGN COMMITTEE   pic 250 2010-01-15 2010 mid_year NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2011-04-26T12:49:43.043000-04: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);