lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "6f42e751-efd9-4774-bbdb-ed3768f0937e" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1891185 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | BAN | Issues generally related to merchant pricing and contract regulation Issues, including prepaid regulation, an arbitration study, the complaints database, related to the Consumer Financial Protection Bureau (CFPB) Issues related to potential Senate legislation that may revise certain prudential bank regulations Issues related to FY 2016 Financial Services Appropriations H.R. 1309, Systemic Risk Designation Improvement Act of 2015, provisions to amend the Dodd-Frank Wall Street Reform and Consumer Financial Protection Act of 2010 to specify when bank holding companies may be subject to certain enhanced supervision H.R. 1195, Bureau of Consumer Financial Advisory Board Act, provisions to amend the Consumer Financial Protection Act of 2010 to establish an advisory opinion process for the Bureau of Consumer Financial Protection S. 1484, Financial Regulatory Improvement Act of 2015, provisions related to systemically important bank holding companies Issues related to Basel Liquidity and Advanced Approach Rules H.R. 5453, Bureau Advisory Opinion Act of 2016, provisions related to CFPB's process on advisory opinions Provisions of CHOICE Act discussion draft | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 | |
| 1891186 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | FIN | The Data Security and Breach Notification Act of 2015, provisions related to data security and breach notification. S. 1890, the Defend Trade Secrets Act, provisions related to trade secrets protection S. 2607, the Developing Innovation and Growing the Internet of Things Act, provisions related to IoT S. 3017, the Intelligence Authorization Act for Fiscal Year 2017, provisions/amendments related to cybersecurity S. 2943, National Defense Authorization Act for Fiscal Year 2017, provisions/amendments related to cybersecurity | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 | |
| 1891187 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | TAX | S. 386, Mobile Workforce State Income Tax Simplification Act, Legislation that would simplify and standardize state income tax collection for employees who travel outside of their home state for temporary work assignments. H.R. 4377, American Business Competitiveness Act of 2015,legislation to reform the Internal Revenue Code of 1986 OECD Beps Project, provision targeted at curtailing foreign base erosion. Senate Finance Chairman's proposal to promote corporate integration House Ways & Means proposal to reform the Internal Revenue Code of 1986 Issues related to corporate tax reform; Section 385 regulations | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 | |
| 1891188 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | CPT | S. 1137, the PATENT Act, provisions related to patent trolls S. 2733, the Venue Equity and Non-Uniformity Elimination Act, provisions related to patent venue reform H.R. 9, the Innovation Act, provisions related to patent reform. | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 | |
| 1891189 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | POS | H.R. 5714, the Postal Reform Act of 2016, provisions related to the US Postal Service | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 | |
| 1891190 | AMERICAN EXPRESS COMPANY 6f42e751-efd9-4774-bbdb-ed3768f0937e | Q3 | AMERICAN EXPRESS COMPANY | 2274 | AMERICAN EXPRESS COMPANY | 2016 | third_quarter | SMB | H.Res.886, Recognizing November 26, 2016, as "Small Business Saturday" and supporting efforts to increase awareness of the value of locally owned small businesses. S.Res.569, A resolution recognizing November 26, 2016, as "Small Business Saturday" and supporting the efforts of the Small Business Administration to increase awareness of the value of locally owned small businesses Resolution honoring Small Business Saturday | Consumer Financial Protection Bureau (CFPB),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of | 210000 | 0 | 0 | 2016-10-20T08:47:25.020000-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);