home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7caaec5c-c2f7-4822-b189-b400a013c7cf

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
7caaec5c-c2f7-4822-b189-b400a013c7cf Q3 24910 TRINITY HEALTH 132604 TRINITY HEALTH 2025 third_quarter 2025-10-17T10:42:24-04:00 240000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7caaec5c-c2f7-4822-b189-b400a013c7cf/", "filing_uuid": "7caaec5c-c2f7-4822-b189-b400a013c7cf", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2025, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7caaec5c-c2f7-4822-b189-b400a013c7cf/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "240000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Margaret Randolph", "dt_posted": "2025-10-17T10:42:24-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "20555 Victor Parkway", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Livonia", "registrant_state": "MI", "registrant_zip": "48152", "registrant": {"id": 24910, "url": "https://lda.senate.gov/api/v1/registrants/24910/", "house_registrant_id": 33088, "name": "TRINITY HEALTH", "description": null, "address_1": "20555 Victor Parkway", "address_2": null, "address_3": null, "address_4": null, "city": "Livonia", "state": "MI", "state_display": "Michigan", "zip": "48152", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MARGARET RANDOLPH", "contact_telephone": "+1 734-846-0610", "dt_updated": "2026-01-19T13:35:30.233505-05:00"}, "client": {"id": 132604, "url": "https://lda.senate.gov/api/v1/clients/132604/", "client_id": 12, "name": "TRINITY HEALTH", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "MI", "state_display": "Michigan", "country": "US", "country_display": "United States of America", "ppb_state": "MI", "ppb_state_display": "Michigan", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-13"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Oppose Medicaid cuts. Oppose Medicare site neutral cuts. S. 1261 CONNECT for Health Act S. 1460/HR 786 Preserving Patient Access to Accountable Care Act (incentive payments for APMs) HR 1683 Protecting Rural Seniors Access to Care Act (SNF minimum staffing standards reg) S 1935 Expanding Access to Palliative Care Act S 1816 Improving Seniors' Timely Access to Care Act S. 1031 Radiation Oncology Case Rate (ROCR) Value Based Program Act S. 1087 Rebuild Americas Health Care Schools Act HR 3890 Resident Physician Shortage Reduction Act HR 538 Critical Access Hospital Relief Act of 2025 HR 3222 SMART Health Care Act HR 4559 Prompt and Fair Pay Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "2010-2013: Senior Legislative Assistant, Rep. Dale Kildee; 2007-2008: Staff Assistant, Senator Carl Levin", "new": true}, {"lobbyist": {"id": 103800, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "NADING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S. 266 Lorna Breen Healthcare Provider Protection Reauthorization S. 998 Medical Supply Chain Resiliency Act HR 2213 tariffs on medical goods", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "2010-2013: Senior Legislative Assistant, Rep. Dale Kildee; 2007-2008: Staff Assistant, Senator Carl Levin", "new": true}, {"lobbyist": {"id": 103800, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "NADING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Funding for gun violence prevention research, CDC Office on Smoking and Health, public health workforce loan repayment Oppose HR 1", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "2010-2013: Senior Legislative Assistant, Rep. Dale Kildee; 2007-2008: Staff Assistant, Senator Carl Levin", "new": true}, {"lobbyist": {"id": 103800, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": null, "last_name": "NADING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "S. 383 JOBS Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "2010-2013: Senior Legislative Assistant, Rep. Dale Kildee; 2007-2008: Staff Assistant, Senator Carl Levin", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "Oppose 340B cuts. HR 4581 340B Patients Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "2010-2013: Senior Legislative Assistant, Rep. Dale Kildee; 2007-2008: Staff Assistant, Senator Carl Levin", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HOU", "general_issue_code_display": "Housing", "description": "HR 2725/S. 1515 Affordable Housing Credit Improvement Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "Senator Levin 2007-8, Rep. Kildee 2010-13", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "HR 2332 SHARE Act HR 3178/S 1600 SAVE Healthcare Workers Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "Senator Carl Levin, Staff Assistant, 2007-2008; Rep. Dale Kildee, Senior Legislative Assistant, 2010-2013", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "HR 1585 Conrad State 30 and Physician Access Reauthorization Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 103799, "prefix": null, "prefix_display": null, "first_name": "MARGARET", "nickname": null, "middle_name": null, "last_name": "RANDOLPH", "suffix": null, "suffix_display": null}, "covered_position": "Senator Levin, Staff Assistant, (2007-08); Rep. Kildee, Senior Legislative Assistant, (2010-2013)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 8 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 7.099ms