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