lobbying_filings_raw: 232e9725-1722-406b-8673-bfbf3bf59cf7
This data as json
| filing_uuid | filing_type | registrant_id | registrant_name | client_id | client_name | filing_year | filing_period | received_date | is_amendment | is_no_activity | is_termination | raw_json | registrant_state | registrant_country | registrant_house_id | client_state | client_ppb_state | client_country | client_ppb_country | client_general_description | client_government_entity | affiliated_org_count | client_entity_id | client_government_unit_id | client_match_method | client_match_confidence | income_amount | expense_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 232e9725-1722-406b-8673-bfbf3bf59cf7 | MM | 352 | AETNA INC. | 100406 | AETNA INC | 2007 | mid_year | 2007-08-08T15:19:46-04:00 | 0 | 0 | 0 | {"url": "https://lda.senate.gov/api/v1/filings/232e9725-1722-406b-8673-bfbf3bf59cf7/", "filing_uuid": "232e9725-1722-406b-8673-bfbf3bf59cf7", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/232e9725-1722-406b-8673-bfbf3bf59cf7/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "1219469.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-08-08T15:19:46-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 352, "url": "https://lda.senate.gov/api/v1/registrants/352/", "house_registrant_id": 32157, "name": "AETNA INC.", "description": null, "address_1": "151 FARMINGTON AVENUE", "address_2": null, "address_3": null, "address_4": null, "city": "HARTFORD", "state": "CT", "state_display": "Connecticut", "zip": "06156", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "GLEN CHAMBERS", "contact_telephone": "+1 202-419-7044", "dt_updated": "2022-04-06T16:06:09.074354-04:00"}, "client": {"id": 100406, "url": "https://lda.senate.gov/api/v1/clients/100406/", "client_id": 12, "name": "AETNA INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "CT", "state_display": "Connecticut", "country": "US", "country_display": "United States of America", "ppb_state": "CT", "ppb_state_display": "Connecticut", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-08"}, "lobbying_activities": [{"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "\r\nRetirement Savings Pension Reform; Cash Balance Regulation.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "\r\nHR 1368, S. 459/HR 758, S. 242/HR 380, HR 1076/S. 616, S. 400, HR 506/S. 325, S. 334, HR 676, HR 1368, S. 1490, S. 1544, S. 1693\r\nHealth care and managed care. Patient's Bill of Rights; AHPs; Generic Drugs; Confidentiality; Health Mandates; Patient Safety; Drug Importation, Biogenerics, TRICARE, HR 3162, S. 1893, HR 976, S. 558, HR 1424, HR 241, HR 1082, HR 1038/S. 623, S. 316,\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nProposals to change tax status of HMOs; tax credits for the uninsured; pension plans; long term care; FSA carryforward; tax reform; retirement security. HR 914, HR 2639, S. 397", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "\r\nMedicare Payment and operational issues. HR 3162, Children's Health Insurance Program Reauthorization Act of 2007, HR 1591, S. 706, S. 130, HR 1990, HR 4, S. 3, S. 1102, HR 1663, HR 594, HR 976, HR 1843", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "\r\nGenetic Testing; Pension Reform; SSA Reform; Disability; Optional Federal Chartering; eHealth; Data Security. HR 493, HR 2761, S. 358, HR 836, HR 948, HR 958, S. 239, S. 495, S. 1178, S. 1260, S. 1408", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "\r\nMedical Malpractice, Health Courts", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 33900, "prefix": null, "prefix_display": null, "first_name": "CHARLYN", "nickname": null, "middle_name": null, "last_name": "IOVINO", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 41157, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "TOPODAS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} | CT | US | 32157 | CT | CT | US | US | 0 | 0 | 1219469.0 |