lobbying_contributions

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

45 rows where contribution_type = "pic" and filing_year = 2017 sorted by contribution_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

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);