home / lobbying / lobbying_filings_raw

lobbying_filings_raw: bcfc8907-4bef-4d15-b2b1-cf1783ed7908

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
bcfc8907-4bef-4d15-b2b1-cf1783ed7908 Q2 39564 UNIVERSITY OF WISCONSIN-MADISON 147166 UNIVERSITY OF WISCONSIN-MADISON 2018 second_quarter 2018-07-16T15:41:48.687000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/bcfc8907-4bef-4d15-b2b1-cf1783ed7908/", "filing_uuid": "bcfc8907-4bef-4d15-b2b1-cf1783ed7908", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/bcfc8907-4bef-4d15-b2b1-cf1783ed7908/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "70000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Michael Lenn, Director of Federal Relations", "dt_posted": "2018-07-16T15:41:48.687000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "97 BASCOM HALL", "registrant_address_2": "500 LINCOLN DRIVE", "registrant_different_address": false, "registrant_city": "MADISON", "registrant_state": "WI", "registrant_zip": "53706", "registrant": {"id": 39564, "url": "https://lda.senate.gov/api/v1/registrants/39564/", "house_registrant_id": 30155, "name": "UNIVERSITY OF WISCONSIN-MADISON", "description": "Public University", "address_1": "97 BASCOM HALL", "address_2": "500 LINCOLN DRIVE", "address_3": null, "address_4": null, "city": "MADISON", "state": "WI", "state_display": "Wisconsin", "zip": "53706", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CODY KASTORFF", "contact_telephone": "+1 608-890-4880", "dt_updated": "2026-01-20T15:42:45.158474-05:00"}, "client": {"id": 147166, "url": "https://lda.senate.gov/api/v1/clients/147166/", "client_id": 12, "name": "UNIVERSITY OF WISCONSIN-MADISON", "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": "2017-01-03"}, "lobbying_activities": [{"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "FY19 Commerce, Justice and Science Appropriations bills (H.R.5952 / S.3072).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "FY19 Agricultural Appropriations bills in House and Senate (H.R.5961/ S.2976), Support for the AFRI, Hatch and Smith-Lever programs in the FY19 Appropriations bills, support for the Genomes to Phenomes initiative in the FY19 Appropriations bills, support for the Crop Improvement Laboratory in the FY19 Appropriations bills, support for ARS cranberry research in the FY19 Appropriations bills, Farm Bill in House and Senate (H.R. 2/S.3042), Support for the Genomes to Phenomes initiative in the 2018 House Farm, Support for the Genomes to Phenomes initiative in the 2018 Senate Farm.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Support for autonomous and connected vehicle research and development, support for support for local infrastructure improvements. S.2836, Preventing Emerging Threats Act of 2018 (UAS provisions).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "Federal Communications Commission, oppose moving forward with rule making in the 1675-1680 MHz portion of the spectrum.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "FY19 Labor, Health and Human Services, and Education and Related Agencies Appropriations bills (S.3158), support of the National Institutes of Health, Facilities and Administrative (F&A) costs, Rural Health, Graduate Medical Education, Pandemic and All Hazards Preparedness reauthorization, tobacco cessation, regulatory burden relief, Medicare payment issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "Implementation of PL 115-48 - the Forever GI Bill, officially known as the Harry W. Colmery Veterans Education Assistance Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Increased federal funding for Research and Development, FY19 Energy and Water Appropriations Bills (H.R.5895 / S.2975), support for Department of Energys Office of Sciences Bioenergy Research Centers, support for ARPA-E, the Energy and Natural Resources Act of 2017 (ENRA) (S. 1460), support for the Department of Energys Office of Science.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "No specific bill - Executive Orders and issues pertaining to H-1B, Dreamers/DACA, travel ban and impact to university community.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Reauthorization of the Higher Education Act (PROSPER ACT, H.R. 4508), Pell Grants/Year-Round Pell Grants, Campus-Based Student Aid programs, including the Perkins Student Loan Program, the Federal Perkins Loan Program Extension Act of 2017 (H.R. 2482/S. 1808), the FY19 Labor, Health and Human Services, and Education and Related Agencies Appropriations bills (S.3158), Endowments, Student Right to Know Before You Go Act, the College Transparency Act (H.R. 2434/S. 1121), maintain Public Service Loan Forgiveness program. S. 2255 \"Advancing International and Foreign Language Education Act\" to reauthorize Title VI of the Higher Education Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Increased federal funding for Research and Development, the Energy and Natural Resources Act of 2017 (ENRA) (S. 1460), the Water Resources Research Institutes program, the National Sea Grant College Program, FY19 Commerce, Justice and Science Appropriations bills (H.R.5952 / S.3072), support for the National Science Foundation, support for the National Environmental Satellite, Data, and Information Service (NESDIS) at NOAA.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "FY19 House and Senate National Defense Authorization Act (H.R.5515/ S.2987).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Tax Cuts and Jobs Act (H.R. 1), Endowments.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "The Bayh-Dole Act & Stronger Patents Act (S. 1390/H.R. 5340).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ART", "general_issue_code_display": "Arts/Entertainment", "description": "Support for the National Endowment for the Humanities, support for the National Endowment for the Arts, FY19 Interior and Environment (H.R.6147/ S.3073).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "FY19 Interior and Environment (H.R.6147/ S.3073), the Water Resources Research Institutes program, the National Sea Grant College Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65659, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "LENN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 53, "name": "Federal Communications Commission (FCC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} WI US 30155 WI WI US US   0 0           70000.0

Links from other tables

  • 15 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.797ms · Privacy