home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 338e0d0a-e3ee-4575-a538-7c4ebee5b911

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
338e0d0a-e3ee-4575-a538-7c4ebee5b911 Q4 302778 CVS HEALTH (AND SUBSIDIARIES) 180890 CVS CAREMARK INC 2011 fourth_quarter 2012-01-19T16:16:04-05:00 2845000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/338e0d0a-e3ee-4575-a538-7c4ebee5b911/", "filing_uuid": "338e0d0a-e3ee-4575-a538-7c4ebee5b911", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2011, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/338e0d0a-e3ee-4575-a538-7c4ebee5b911/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "2845000.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Wendy Sussman, Vice President, Government Affairs, CVS Caremark Inc.", "dt_posted": "2012-01-19T16:16:04-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1300 I Street, NW", "registrant_address_2": "Suite 525 West", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 302778, "url": "https://lda.senate.gov/api/v1/registrants/302778/", "house_registrant_id": 39442, "name": "CVS HEALTH (AND SUBSIDIARIES)", "description": "Health Care", "address_1": "1275 Pennsylvania Avenue, NW", "address_2": "Suite 700", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ELIZABETH STRONG", "contact_telephone": "+1 207-749-0299", "dt_updated": "2026-01-30T12:49:05.134019-05:00"}, "client": {"id": 180890, "url": "https://lda.senate.gov/api/v1/clients/180890/", "client_id": 1003157, "name": "CVS CAREMARK INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to restructuring of corporate tax rates.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Medicare/Medicaid-Issues related to plan design and cost savings proposals.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Issues relating to a proposed anti-trust exemption for certain pharmacies and healthcare competition. \nHR 1409 Quality Health Care Coalition Act of 2011\nHR 1839 - Community Pharmacy Fairness Act of 2011\nHR 1946 - Preserving Our Hometown Independent Pharmacies Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Issues related to Medicare Part D and anti-PBM legislation. Other issues include health care delivery system reforms, cost containment, medication adherence, restrictions on PBM cost saving tools like mail order, generics and restrictions on PBM audit practices. \nHR 979 - FEHBP Prescription Drug Integrity, Transparency and Cost Savings Act S 1058 Pharmacy Competition and Consumer Choice\nHR 1971 Pharmacy Competition and Consumer Choice\nHR 605 - Patients' Freedom to Choose Act\nS 312 - Patients' Freedom to Choose Act\nHR 2529-Restoring Access to Medication Act\nS 1368-Restoring Access to Medication Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "Issues related to drug safety and the drug supply chain.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Privacy Issues relating to the inadvertent disclosure of protected health information. \nHR 654-Do Not Track Me Online Act\nS 1151 - Personal Data Privacy and Security Act\nS 1207- Data Security and Breach Notification Act of 2011 HR 2577- SAFE Data Act\nHR 1841-Data Accountability and Trust Act (DATA) of 2011\nS 1408-Data Breach Notification Act of 2011\nS 1535-Personal Data Protection and Breach Accountability Act of 2011", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 39367, "prefix": "mr", "prefix_display": "MR.", "first_name": "RUSSELL", "nickname": null, "middle_name": "CONWELL", "last_name": "RING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 45409, "prefix": null, "prefix_display": null, "first_name": "HEATHER", "nickname": null, "middle_name": null, "last_name": "CUTLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44383, "prefix": null, "prefix_display": null, "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "SIMMON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 34176, "prefix": null, "prefix_display": null, "first_name": "WENDY", "nickname": null, "middle_name": null, "last_name": "SUSSMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 51806, "prefix": null, "prefix_display": null, "first_name": "RAVI", "nickname": null, "middle_name": null, "last_name": "UPADHYAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 2.915ms