lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
8 rows where filing_uuid = "fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1521915 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | RET | Retirement plans in tax reform debate; Pension Benefits Guarantee Corporation premium increase; Nondiscrimination testing in pension plans; Preserving the tax treatment of retirement savings; Multiemployer defined benefit pension plan reform | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521916 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | SMB | S Corporation Modernization; Tax reform; Private company access to capital and tax structure; Consumer financial protection bureau; Healthcare law and its impact on business; Paperwork burden; Jobs act; Small business tax cut act, estate tax H.R. 2429; S.1183 | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521917 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | GOV | Federal acquisition and contracting policy; Compensation caps for government contractors NDAA | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521918 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | ECN | Economis recovery; Job creation; Tax policy; Debt ceiling; Burdensome regulations negatively impacting economy; The need to go beyond the 1.2 trillion in deficit reductions: Financial regulatory; Implementation of the Affordable Care Act | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521919 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | DEF | The National Defense Authorization Act, Various sections and ammendments having to do with defense acquisitions, e.g., commerical items definition, allowable costs of compensation; limitations on cost type contracts, etc. | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521920 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | ACC | Complexity in financial reporting; Auditor liability; SEC's interpretive guidance; Accounting Standards (FASB & IASB); Convergence/International Financial Reporting Standards; Dodd-Frank Act; Hedge Accounting; Repeal of Last-In, First-Out (LIFO) accounting methodMoney Market Funds Reform; -The Volcker Rule H.R. 677, The Inter-Affiliate Swap Clarification Act; H.R. 634 and S.888 The Business Risk Mitigation and Prica Stabilization Act | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521921 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | FIN | Volcker rule; Proposed money market fund reforms; Dodd-Frank Act over-the-counter derivatives regulation; Dodd-Frank Title VII; Extra territoriality issues in swaps regulation; Too big to fail; H.R. 634 and S. 888, The Business Risk Mitigation and Price Stabilization Act; H.R. 677, The Inter-Affiliate Swap Clarification Act | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-04:00 | |
| 1521922 | FINANCIAL EXECUTIVES INTERNATIONAL fcbb109c-6c0c-4e8f-bc9d-de5c0bf94deb | Q1 | FINANCIAL EXECUTIVES INTERNATIONAL | 14520 | FINANCIAL EXECUTIVES INTERNATIONAL | 2014 | first_quarter | TAX | Corporate and individual rate reduction and reform; Proposals to adopt a territorial tax system; Enactment of expired individual and business tax provisions (i.e., the extenders package); Estate tax H.R. 2429; Deductibility of interest; Pension funding stabilization; PBGC premium increase; H.R. 1129 and S. 1645, the Mobile Workforce State Income Tax Simplification Act; Preserving the tax treatment of employer-provided retirement and healthcare plans; Expire ActRetirement savings tax incentives; Making research and development credit permanent Base erosion and profit sharing | Commodity Futures Trading Commission (CFTC),Defense, Dept of (DOD),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 80701 | 0 | 0 | 2014-04-17T11:54:28.423000-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);