home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 5e21bc3f-1d08-4c54-b5b5-22a4bade01fc

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
5e21bc3f-1d08-4c54-b5b5-22a4bade01fc Q4 80510 CMFG LIFE INSURANCE COMPANY 170973 CMFG LIFE INSURANCE COMPANY 2019 fourth_quarter 2020-01-14T13:50:55.143000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/5e21bc3f-1d08-4c54-b5b5-22a4bade01fc/", "filing_uuid": "5e21bc3f-1d08-4c54-b5b5-22a4bade01fc", "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/5e21bc3f-1d08-4c54-b5b5-22a4bade01fc/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "120000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Christopher P. Roe", "dt_posted": "2020-01-14T13:50:55.143000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "P.O. BOX 391, MAIL STOP 5910 4 A2", "registrant_address_2": "5910 MINERAL POINT ROAD", "registrant_different_address": false, "registrant_city": "MADISON", "registrant_state": "WI", "registrant_zip": "53701", "registrant": {"id": 80510, "url": "https://lda.senate.gov/api/v1/registrants/80510/", "house_registrant_id": 36270, "name": "CMFG LIFE INSURANCE COMPANY", "description": "Financial products and services.", "address_1": "P.O. BOX 391, MAIL STOP 5910 4 A2", "address_2": "5910 MINERAL POINT ROAD", "address_3": null, "address_4": null, "city": "MADISON", "state": "WI", "state_display": "Wisconsin", "zip": "53701", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRISTOPHER P. ROE", "contact_telephone": "+1 608-665-8684", "dt_updated": "2026-01-28T16:31:41.700104-05:00"}, "client": {"id": 170973, "url": "https://lda.senate.gov/api/v1/clients/170973/", "client_id": 12, "name": "CMFG LIFE INSURANCE 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": "2002-11-06"}, "lobbying_activities": [{"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Work to keep insurance regulated by the states and not by the Consumer Financial Protection Bureau. Advocate for stronger data security, particularly with regard to merchant plastic card data breaches. Support a best interest fiduciary standard for retirement advice and products as proposed by the SEC that is effectively and efficiently workable in the market. Support passage of RESA (S.972) and SECURE Act (H.R. 1994). Advocate for stronger data security, particularly with regard to merchant plastic card data breaches. Advocate for privacy measures in line with GLBA and HIPAA as applied to financial services. Encourage Department of Justice to issue regulations under the Americans with Disability Act in order to provide clear guidance for compliance. Comment on National Credit Union Administration regulatory proposal regarding the credit union fidelity bond. Seek passage of the Terrorism Risk Insurance Program Reauthorization Act of 2019, H.R. 4634.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47628, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ROE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 71, "name": "Natl Credit Union Administration (NCUA)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "Work to keep insurance regulated by the states and not by the Consumer Financial Protection Bureau or set by international bodies. Oppose legislation to repeal the McCarran-Ferguson antitrust exemption for the business of insurance. Support a best interest fiduciary standard for retirement advice and products as proposed by the SEC that is effectively and efficiently workable in the market. Support passage of RESA (S.972) and SECURE Act (H.R. 1994). Advocate for stronger data security, particularly with regard to merchant plastic card data breaches. Advocate for privacy measures in line with GLBA and HIPAA as applied to financial services. Encourage Department of Justice to issue regulations under the Americans with Disability Act in order to provide clear guidance for compliance. Comment on National Credit Union Administration regulatory proposal regarding the credit union fidelity bond. Seek passage of the Terrorism Risk Insurance Program Reauthorization Act of 2019, H.R. 4634.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47628, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ROE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 71, "name": "Natl Credit Union Administration (NCUA)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Oppose federal taxation of credit unions. Address the 21 percent excise tax that retroactively impacts executive benefits plans.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 47628, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "ROE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 71, "name": "Natl Credit Union Administration (NCUA)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} WI US 36270 WI WI US US   0 0           120000.0

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.417ms · Privacy