lobbying_contributions

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

3,670,570 rows sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

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_lobby_contrib_year ON lobbying_contributions(filing_year);
CREATE INDEX idx_lobby_contrib_recipient ON lobbying_contributions(recipient_name);
CREATE INDEX idx_lobby_contrib_filing ON lobbying_contributions(filing_uuid);