lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
2 rows where filing_uuid = "fe4adcd3-cdd2-4c8f-9609-e4a1991b1bb5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1377780 | AMERICAN BENEFITS COUNCIL fe4adcd3-cdd2-4c8f-9609-e4a1991b1bb5 | Q1 | AMERICAN BENEFITS COUNCIL | 4675 | AMERICAN BENEFITS COUNCIL | 2013 | first_quarter | RET | Budget employer-sponsored retirement and health care benefits Path to Prosperity: A Responsible, Balanced Budget House Budget Committee proposed FY2014 budget resolutionFoundation for Growth: Restoring the Promise of American Opportunity Senate Budget Committee FY 2014 budget blueprint American Taxpayer Relief Act of 2012 (ATRA) fiscal cliff, employee benefits provisions American Family Economic Protection Act Senate Sequester offset package Tax reform/Deficit reduction tax incentives for employer-sponsored pension and retirement savings plans Financial Services Reform implementation of Dodd-Frank Wall Street Reform and Consumer Protection (Dodd-Frank) Act Pension Funding/Stabilization defined benefit pension funding stabilization and related plan issues - de-risking defined benefit (DB) plans, Nondiscrimination rules applicable to defined benefit (DB) plans Moving Ahead for Progress in the 21st Century (MAP-21) Act of 2012 Retirement Savings Plan Issues Retirement Coverage & Adequacy Shrinking Emergency Account Losses Act of 2013 (SEAL Act) S. 606 Savings for American Families Future Act of 2013 H.R. 837 Pension modernization - The Retirement Crisis and a Plan to Solve It USA Retirement Funds Senate Health, Education, Labor & Pensions Committee Draft bi-partisan concurrent resolution tax incentives for retirement savings discussions Pension Benefit Guaranty Corporation (PBGC) premiums, calculation of deficit and related governance issues, proposed ERISA Section 4062 (e) regulations, rules for companies in bankruptcy Investment Advice defined contribution plans, plan fees, definition of a fiduciary, investment options in 401(k) and similar participant-directed individual account plans, electronic communication and related issues Other Issues Hybrid retirement plan designs implementation of the Pension Protection Act (PPA), finalization of proposed regulations Health care provider compensation Internal Revenue Code Section 162 (m) (6) performance-based compensation Foreign bank account re… | Centers For Medicare and Medicaid Services (CMS),Commodity Futures Trading Commission (CFTC),Equal Employment Opportunity Commission (EEOC),Federal Accounting Standards Advisory Board (FASAB),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Office of Management & Budget (OMB),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 245686 | 0 | 0 | 2013-04-18T14:49:03.167000-04:00 | |
| 1377781 | AMERICAN BENEFITS COUNCIL fe4adcd3-cdd2-4c8f-9609-e4a1991b1bb5 | Q1 | AMERICAN BENEFITS COUNCIL | 4675 | AMERICAN BENEFITS COUNCIL | 2013 | first_quarter | HCR | Health Care Reform ongoing implementation of the Patient Protection and Affordable Care Act (PPACA) Healthy Lifestyles and Prevention America (HeLP Act) S. 39 Preserving our Hometown Independent Pharmacies Act of 2013 H.R. 1188Tax parity for health plan beneficiaries Budget - employer-sponsored retirement and health care benefits Path to Prosperity: A Responsible, Balanced Budget House Budget Committee proposed FY2014 budget resolution Foundation for Growth: Restoring the Promise of American Opportunity Senate Budget Committee FY 2014 budget blueprint Other Issues Health care provider compensation Internal Revenue Code Section 162 (m) (6) Electronic disclosure, communication by employee benefit plans Consumer directed health care plans HDHPs, HSAs, HRAs FSA Plan Year Limit transition guidance Mental Health Parity Rules finalization HIPAA Privacy Regulations/HITECH Act, GINA | Centers For Medicare and Medicaid Services (CMS),Commodity Futures Trading Commission (CFTC),Equal Employment Opportunity Commission (EEOC),Federal Accounting Standards Advisory Board (FASAB),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Office of Management & Budget (OMB),Pension Benefit Guaranty Corporation (PBGC),Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 245686 | 0 | 0 | 2013-04-18T14:49:03.167000-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);