home / lobbying

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 = 2014 sorted by contribution_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contribution_date (date)

filing_year 1

  • 2014 · 1 ✖

contribution_type 1

  • pic · 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
1268755 4c3ac6d5-b71e-4c1a-9d39-50910f9b5a1f   ATLANTIC STRATEGIES GROUP NO CONTRIBUTION   pic 0 2014-06-29 2014 mid_year ATLANTIC STRATEGIES GROUP LLC 2014-07-28T19:28:22.563000-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);
Powered by Datasette · Queries took 1904.384ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API