lobbying_contributions
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
This data as json, CSV (advanced)
Suggested facets: contribution_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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);