lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
6 rows where filing_uuid = "91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 706967 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | PHA | S. 1505, Affordable Biologics for Consumers Act, issues relating to long term safety and effectiveness of medical devices and drugs. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05:00 | |
| 706968 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | TAX | See attached list. H.R. 914-- Tax Equity and Affordability Act H.R. 3234 --HSA Improvement and Expansion Act H.R. 1424 - As amended The Emergency Economic Stabilization Act of 2008 S. 397 -- Tax Equity and Affordability Act H.R. 3997 -- An act to amend the Internal Revenue Code of 1986 to provide tax relief and protections for military personnel and other purposes. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05:00 | |
| 706969 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | ECN | H.R. 6382 -- To make techinical corrections related to the Pension Protection Act of 2006, and other purposes S. 1974 -- A Bill to make technical corrections related to the Pension Protection Act of 2006. H.R. 7327 -- To make technical corrections related to the Pension Protection Act of 2006, and for other purposes. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05:00 | |
| 706970 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | HCR | See attached list. H.R. 1367/H.R. 1424 -- Paul Wellstone Mental Health and Addiction Equity Act of 2007, as it pertains to health insurance regulations. H.R. 2406 -- Healthcare Information Technology Enterprise Intergration Act, as it relates to the establishment of a single standard for health information technology systems used by health providers. H.R. 758 -- Breast Cancer Patient Protection Act S.1693 -- Wired for Health Care Quality Act S.1693 -- Wired for Health Care Quality Act, as it pertains to the adoption of a nationwide health information system. S.1224 -- SCHIP Reauthorization S.1408 -- Health Information Technology Act of 2007 S.1455 -- National Health Information Technology and Privacy Advancement Act of 2007 S.334/H.R. 3163/ H.R. 6444 -- Healthy Americans Act S.495 -- Personal Data Privacy and Security Act of 2007 S.628 -- Critical Access to Health Information Technology Act of 2007 H.R. 7129 -- Several Approaches to Reduce the Uninsured Act of 2008 | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05:00 | |
| 706971 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | MMM | See attached list Ongoing implementation issues for the Medicare Advantage and Medicare Part D prescription drug programs. Correction-extension of the Medicare support program. CBO- Chronic Care Meidcare Health Support Organizations Estimates. S.558 -- Mental Health Parity Act, as it pertains to the provisions of mental health benefits. Educate specific Members of Congress on CIGNA bid for Meidcare Administrtive contract and any change that wil impact providers in their constituencies as a result of being awarded or losing a bid. "Doc Fix" Bill - H.R. 6331 -- Medicare Improvements for Patients and Provider Act for 2008. | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05:00 | |
| 706972 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) 91e9ca3f-e3df-44be-a2a7-be9f6f4c7fb2 | Q4 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 9237 | THE CIGNA GROUP AND SUBSIDIARIES (FORMERLY CIGNA CORPORATION AND SUBSIDIARIES) | 2008 | fourth_quarter | INS | See attached list H.R. 758 -- Genetic Information Nondiscrimination Act. H.R. 1424 -- Paul Wellstone Mental Health adn Addicition Equity Act, as it pertains to health insurance regulations. H.R. 2761 -- Terrorism Risk Insurance Revision and Extension Act. H.R. 4460 -- Health Care Choice Act. S. 40 -- National Insurance Act. S. 558 -- Mental Health Parity Act. S. 2477 -- Health Care Choice Act. H.R. 7129 -- Several Approaches to Reduce Uninsured Act H.R. 506 -- To provide for innovation in healthcare through State initiatives that expand coverage and access. S.334/H.R. 3163/H.R. 6444 -- Healthy Americans Act | Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 480000 | 0 | 0 | 2009-01-15T15:15:49-05: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);