lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "a161fe19-e8dd-43fe-89ea-7fe958e53ff4" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1805730 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | INS | Issues related to employer financing of private disability insurance. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-04:00 | |
| 1805731 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | TRD | International trade agreements, specifically the Transatlantic Trade and Investment Partnership (TTIP),TransPacific Partnership (TISA), and Trade in Services Agreement (TISA), and the Bipartisan Congressional Trade Priorities and Accountability Act of 2015. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-04:00 | |
| 1805732 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | TAX | Issues related to corporate taxation; taxation of health benefits and providers of health coverage, including P.L. 111-148 (Patient Protection and Affordable Care Act). In addition, issues relating to the 40% excise tax. Issues relating to Health Savings Accounts: H.R. 4469 the Health Savings Act of 2016, S.2499, the Health Savings Act of 2016, H.R. 4832, the Health Savings Protection Act. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-04:00 | |
| 1805733 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | HCR | Issues relating to mental health and general health and health care legislation and regulation, including P.L. 111-148 (Patient Protection and Affordable Care Act) and P.L. 111-152 (Reconciliation Act of 2010). Issues related to the health insurance excise tax, including H.R. 2050 and H.R. 879, S. 2045, the Middle Class Health Benefits Repeal Act of 2015, and S. 2075, the American Worker Health Care Tax Relief Act of 2015. Issues related to S. 1945, the Mental Health Reform Act of 2015, S. 524, the Comprehensive Addiction and Recovery Act of 2016, and S. 2680, the Mental Health Reform Act of 2016. Issues relating to employer sponsored healthcare. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-04:00 | |
| 1805734 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | MMM | Ongoing implementation of payment and regulatory issues for the Medicare Advantage program. Issues relating to the Medicare Part D prescription drug program, various CMS demonstration programs and of P.L. 111-148 (Patient Protection and Affordable Care Act). Issues relating to Medigap insurance, and H.R. 2, The Medicare Access and CHIP Re authorization Act of 2015. Issues relating to H.R. 2579 - Securing Care for Seniors Act of 2015. Issues related to the introduction of S. 2104, A bill to amend title XVIII of the Social Security Act to provide relief to Medicare Advantage plans with a significant number of dually eligible or low-income subsidy beneficiaries and to prevent the termination of two star plans. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-04:00 | |
| 1805735 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) a161fe19-e8dd-43fe-89ea-7fe958e53ff4 | Q1 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2016 | first_quarter | LBR | Issues related to antitrust and the proposed Cigna-Anthem transaction. | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 1010000 | 0 | 0 | 2016-04-12T17:18:11.563000-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);