lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2" and issue_code = "TAX" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2870991 | DAVIS & HARMAN LLP ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2 | Q3 | DAVIS & HARMAN LLP | 11674 | TRANSAMERICA LIFE INSURANCE COMPANY | 2022 | third_quarter | TAX | Proposals related to retirement plans for small business. Proposals to reform the multiple employer plan rules. Proposals related to ABLE accounts. Issues related to defined benefit plan funding. Guidance related to nondiscrimination rules for defined contribution plan annuity investment products. Issues related to tax incentives for retirement savings. Issues related to income investment options. Proposals related to electronic disclosure. Plan consolidation. Issues related to PEP trustees. Issues related to audits of groups of plans. Proposals to reform 403(b) plan investments. Proposals to amend the Internal Revenue Code and ERISA to avoid duplicative annual reporting, including H.R. 982 and S. 354. S. 1770, Retirement Security and Savings Act. S. 1011, to modify the requirements for multiple employer plans, and for other purposes (116th Congress). S. 321, Retirement Security Act. H.R. 4523, the Automatic Retirement Plan Act (115th Congress). H.R. 4637, the SAVE Act (115th Congress). H.R. 4610/S. 3759, RETIRE Act (115th Congress). Issues related to e-notarization. H.R. 2741, Public Service Retirement Fairness Act. S. 1625, Securing and Enabling Commerce Using Remote and Electronic Notarization Act. S. 1703, Improving Access to Retirement Savings. H.R. 2954, Securing a Strong Retirement Act. H.R. 8606, To defer the tax of certain sales of employer stock and reduce certain retirement-related excise taxes, and for other purposes (116th Congress). H.R. 423/H.R. 409, Emergency Pension Plan Relief Act. H.R. 1319, the American Rescue Plan Act. H.R. 5376, Build Back Better Act. H.R. 5891, Retirement Improvement and Savings Enhancement Act. H.R. 6912, Pooled Employer Plan Fix Act. H.R. 2741, Public Service Retirement Fairness Act of 2021. H.R. 7146/S. 1870, Enhancing Emergency and Retirement Savings Act. H.R. 7310, Protecting Americas Retirement Security Act. H.R. 6782/S. 3712, Auto Reenrollment Act. S. 4154, Simplifying Small Business Retirement Savings Act. S. 4153, Incentivizing Small Business Retirement Savings Act… | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 0 | 2022-10-18T12:28:13-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);