lobbying_filings_raw: 617b15bc-1b01-4b60-bf9c-f69729270579

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
617b15bc-1b01-4b60-bf9c-f69729270579	Q4	401104022	SENTRY INSURANCE COMPANY (FORMERLY SENTRY INSURANCE A MUTUAL COMPANY)	200646	SENTRY INSURANCE COMPANY (FORMERLY SENTRY INSURANCE A MUTUAL COMPANY)	2019	fourth_quarter	2020-01-15T14:27:24.303000-05:00	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/617b15bc-1b01-4b60-bf9c-f69729270579/", "filing_uuid": "617b15bc-1b01-4b60-bf9c-f69729270579", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2019, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/617b15bc-1b01-4b60-bf9c-f69729270579/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "42500.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Kip J. Kobussen", "dt_posted": "2020-01-15T14:27:24.303000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1800 Deming Way", "registrant_address_2": "Suite 400", "registrant_different_address": false, "registrant_city": "Middleton", "registrant_state": "WI", "registrant_zip": "53562", "registrant": {"id": 401104022, "url": "https://lda.senate.gov/api/v1/registrants/401104022/", "house_registrant_id": null, "name": "SENTRY INSURANCE COMPANY (FORMERLY SENTRY INSURANCE A MUTUAL COMPANY)", "description": "Insurance Company", "address_1": "1800 Deming Way", "address_2": "Suite 400", "address_3": null, "address_4": null, "city": "Middleton", "state": "WI", "state_display": "Wisconsin", "zip": "53562", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS MLECZKO", "contact_telephone": "+1 608-826-3275", "dt_updated": "2026-01-29T12:57:13.100628-05:00"}, "client": {"id": 200646, "url": "https://lda.senate.gov/api/v1/clients/200646/", "client_id": 12, "name": "SENTRY INSURANCE COMPANY (FORMERLY SENTRY INSURANCE A MUTUAL COMPANY)", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "WI", "state_display": "Wisconsin", "country": "US", "country_display": "United States of America", "ppb_state": "WI", "ppb_state_display": "Wisconsin", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-05-01"}, "lobbying_activities": [{"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "Monitoring the following bill\nS. 1108 - Algorithmic Accountability Act of 2019, all provisions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "S. 1989 and H.R. 1575, PAID Act, all provisions - We support this bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "INS", "general_issue_code_display": "Insurance", "description": "US S 2877 Terrorism Risk Insurance Program Reauthorization Act\nUS HR 4634 Terrorism Risk Insurance Program Reauthorization Act \nDiscussions related to the Federal Insurance Office \nH.R. 2093, STATES Act, all provisions H.R. 1595, SAFE Banking Act of 2019, all provisions - monitoring these bills \nH.R. 2684, FAIR RATES Act of 2019, all provisions - monitoring this bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "Monitoring the following bills related to data privacy: \nHR 1282 The Data Accountability and Trust Act, all provisions\nS 189 Social Media Privacy Protection Act, all provisions\nHR 331 Protecting Consumer Information Act of 2019, all provisions\nS 142 American Data Dissemination Act of 2019, all provisions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "TOR", "general_issue_code_display": "Torts", "description": "S 471 Litigation Funding Transparency Act of 2019, all provisions \nS 228 Non-Emergency Ambulance Transportation Sustainability and Accountability (NEATSA) Act of 2019, all provisions - monitoring these bills", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "PHA", "general_issue_code_display": "Pharmacy", "description": "Monitoring the folllowing bills\nH.R 3947, Competition Prescription Act of 2019, all provisions\nH.R. 2296 METRIC Act, all provisions", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "TRU", "general_issue_code_display": "Trucking/Shipping", "description": "H.R. 3781 INSURANCE Act, all provisions - monitoring this bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": "RET", "general_issue_code_display": "Retirement", "description": "HR 1994 Setting Every Community Up for Retirement Enhancement Act of 2019, all provisions - monitoring this bill", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64473, "prefix": null, "prefix_display": null, "first_name": "ANTHONY", "nickname": null, "middle_name": "J.", "last_name": "TRENZELUK", "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": []}	WI	US		WI	WI	US	US		0	0						42500.0

Links from other tables

8 rows from filing_uuid in lobbying_activities
1 row from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs