lobbying_filings_raw: 32b45dc0-7dd7-43d3-8ba5-c8bcd3b2e61f

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

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
32b45dc0-7dd7-43d3-8ba5-c8bcd3b2e61f Q1 400676018 VSP 194056 VSP 2023 first_quarter 2023-04-12T09:41:28-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/32b45dc0-7dd7-43d3-8ba5-c8bcd3b2e61f/", "filing_uuid": "32b45dc0-7dd7-43d3-8ba5-c8bcd3b2e61f", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2023, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/32b45dc0-7dd7-43d3-8ba5-c8bcd3b2e61f/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "120000.00", "expenses_method": "C", "expenses_method_display": "C", "posted_by_name": "Cecil Swamidoss", "dt_posted": "2023-04-12T09:41:28-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "3333 Quality Drive", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Rancho Cordova", "registrant_state": "CA", "registrant_zip": "95670", "registrant": {"id": 400676018, "url": "https://lda.senate.gov/api/v1/registrants/400676018/", "house_registrant_id": null, "name": "VSP", "description": "Vision insurance plan providing vision care benefits to over 55 million members nationwide", "address_1": "3333 Quality Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Rancho Cordova", "state": "CA", "state_display": "California", "zip": "95670", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STUART THOMPSON", "contact_telephone": "+1 916-851-4922", "dt_updated": "2026-01-29T16:11:13.634268-05:00"}, "client": {"id": 194056, "url": "https://lda.senate.gov/api/v1/clients/194056/", "client_id": 12, "name": "VSP", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2010-10-20"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Monitor issues related to standalone vision plans, including H.R. 1385 DOC Access Act of 2023. Montior issues related to prior authorization reform. Monitor issues related to the expansion of Medicare vision benefits.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52825, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Monitor competition in the global eyewear market.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52825, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Monitor competition in the global eyewear market.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 52825, "prefix": null, "prefix_display": null, "first_name": "CECIL", "nickname": null, "middle_name": null, "last_name": "SWAMIDOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} CA US   CA CA US US   0 0           120000.0

Links from other tables