home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bb3e3ea2-a2d8-4e7f-b294-6b5306cb4985

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
bb3e3ea2-a2d8-4e7f-b294-6b5306cb4985 Q3 401103191 GUIDEWELL MUTUAL HOLDING CORPORATION 198096 GUIDEWELL MUTUAL HOLDING CORPORATION 2022 third_quarter 2022-10-19T12:13:43-04:00   0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bb3e3ea2-a2d8-4e7f-b294-6b5306cb4985/", "filing_uuid": "bb3e3ea2-a2d8-4e7f-b294-6b5306cb4985", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2022, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bb3e3ea2-a2d8-4e7f-b294-6b5306cb4985/print/", "filing_document_content_type": "text/html", "income": null, "expenses": null, "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Kelly James", "dt_posted": "2022-10-19T12:13:43-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "4800 Deerwood Campus Parkway", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Jacksonville", "registrant_state": "FL", "registrant_zip": "32246", "registrant": {"id": 401103191, "url": "https://lda.senate.gov/api/v1/registrants/401103191/", "house_registrant_id": null, "name": "GUIDEWELL MUTUAL HOLDING CORPORATION", "description": "Health insurance", "address_1": "4800 Deerwood Campus Parkway", "address_2": null, "address_3": null, "address_4": null, "city": "Jacksonville", "state": "FL", "state_display": "Florida", "zip": "32246", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MAI-KIM NORMAN", "contact_telephone": "+1 240-889-5388", "dt_updated": "2026-01-21T14:14:59.686132-05:00"}, "client": {"id": 198096, "url": "https://lda.senate.gov/api/v1/clients/198096/", "client_id": 12, "name": "GUIDEWELL MUTUAL HOLDING CORPORATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "FL", "state_display": "Florida", "country": "US", "country_display": "United States of America", "ppb_state": "FL", "ppb_state_display": "Florida", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2014-01-01"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Medicare; Medicare Advantage Reform; Prior Authorization; Medicare Advantage; Medicaid; Part D Reform HR 2166 (117th Congress), Ensuring Parity in MA and PACE for Audio-Only Telehealth Act of 2021, by Rep. Terri Sewell (D-AL). Amends title XVIII of the Social Security Act to require the inclusion of certain audio-only diagnoses in the determination of risk adjustment for Medicare Advantage plans and PACE programs. HR 3173 (117th Congress), Improving Seniors Timely Access to Care Act of 2021, by Rep. Susan DelBene (D-WA). Amends title XVIII of the Social Security Act to establish requirements with respect to the use of prior authorization under Medicare Advantage plans. S 3018 (117th Congress), Improving Seniors Timely Access to Care Act of 2021, by Sen. Roger Marshall (R-KS). Amends title XVIII of the Social Security Act to establish requirements with respect to the use of prior authorization under Medicare Advantage plans.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65282, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "GILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "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": "PHA", "general_issue_code_display": "Pharmacy", "description": "COVID-19 Testing; Prescription Drugs; Insulin; Coverage of COVID-19 Testing and Vaccines HR 3 (117th Congress), Elijah E. Cummings Lower Drug Costs Now Act, by Rep. Frank Pallone (D-NJ). Establishes a fair price negotiation program, protect the Medicare program from excessive price increases, and establish an out-of-pocket maximum for Medicare part D enrollees. The Improving Needed Safeguards for Users of Lifesaving Insulin Now (INSULIN) Act, by Sen. Jeanne Shaheen (D-NH) and Sen. Susan Collins (R-ME). Increases measures to encourage insulin manufacturers to reduce list prices, while extending patient protections that will foster competition and broader access to insulin products.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65282, "prefix": null, "prefix_display": null, "first_name": "THOMAS", "nickname": null, "middle_name": null, "last_name": "GILES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"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": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 8.603ms