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

7 rows where contribution_type = "pic" and filing_year = 2012 sorted by contribution_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_uuid, contributor_name, payee_name, contribution_date, filing_period, registrant_name, received_date, contribution_date (date), received_date (date)

filing_year 1

  • 2012 · 7 ✖

contribution_type 1

  • pic · 7 ✖
id filing_uuid lobbyist_name contributor_name payee_name recipient_name contribution_type amount contribution_date ▲ filing_year filing_period registrant_name received_date
1004826 ad7c3c1d-9eab-4c1e-9e7f-84c8f48deac8   AT&T SERVICES INC AND ITS AFFILIATES PRESIDENTIAL INAUGURAL COMMITTEE 2013   pic 3000000 2012-12-20 2012 year_end AT&T SERVICES, INC. AND ITS AFFILIATES 2013-01-30T16:21:07.790000-05:00
1028587 c19a63e1-1507-4ab1-b44e-fc5658074a81   MARS INCORPORATED PRESIDENTIAL INAUGURAL COMMITTEE 2013   pic 10000 2012-12-19 2012 year_end MARS, INCORPORATED 2013-08-08T15:09:49.313000-04:00
1029594 044372df-3e57-4aa8-9250-c2f062626811   MICROSOFT CORPORATION PRESIDENTIAL INAUGURAL COMMITTEE   pic 1000000 2012-12-19 2012 year_end MICROSOFT CORPORATION 2013-09-25T18:21:14.543000-04:00
1020017 06e08405-0dd4-4af2-9161-80b43fb8d75a   AMAZON CORPORATE LLC PRESIDENT INAUGURAL COMMITTEE (IN-KIND CONTRIBUTION, AMAZON WEB SERVICES)   pic 10040 2012-12-17 2012 year_end AMAZON.COM SERVICES LLC 2013-02-01T09:51:33.527000-05:00
1004891 ad7c3c1d-9eab-4c1e-9e7f-84c8f48deac8   AT&T SERVICES INC AND ITS AFFILIATES PRESIDENTIAL INAUGURAL COMMITTEE 2013   pic 123061 2012-12-01 2012 year_end AT&T SERVICES, INC. AND ITS AFFILIATES 2013-01-30T16:21:07.790000-05:00
1022137 bb24d5fd-d3e1-4dbc-8fc8-aa2cd5213c74   CONNORS, SUSAN H SUSAN CONNORS   pic 101 2012-07-20 2012 year_end BRAIN INJURY ASSOCIATION OF AMERICA (FKA BRAIN INJURY ASSOCIATION) 2013-02-08T13:55:42.323000-05:00
839291 a481fed9-9cdb-49e6-bef0-8b6c9fec7c84   WORRALL, THOMAS ROMNEY VICTORY COMMITEE   pic 2500 2012-05-01 2012 mid_year WHITMER & WORRALL, LLC 2012-07-17T17:27:36.760000-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 1377.609ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API