lobbying_filings_raw: 17e68856-43c8-453c-b5b9-740e99eafd7e

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
17e68856-43c8-453c-b5b9-740e99eafd7e Q3 49191 UNIVERSITY OF IOWA 156117 UNIVERSITY OF IOWA 2022 third_quarter 2022-10-13T12:13:40-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/17e68856-43c8-453c-b5b9-740e99eafd7e/", "filing_uuid": "17e68856-43c8-453c-b5b9-740e99eafd7e", "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/17e68856-43c8-453c-b5b9-740e99eafd7e/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "60000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Leanne Hotek", "dt_posted": "2022-10-13T12:13:40-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "105 JESSUP HALL", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "IOWA CITY", "registrant_state": "IA", "registrant_zip": "52242", "registrant": {"id": 49191, "url": "https://lda.senate.gov/api/v1/registrants/49191/", "house_registrant_id": 34573, "name": "UNIVERSITY OF IOWA", "description": null, "address_1": "105 JESSUP HALL", "address_2": null, "address_3": null, "address_4": null, "city": "IOWA CITY", "state": "IA", "state_display": "Iowa", "zip": "52242", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LEANNE HOTEK", "contact_telephone": "+1 319-467-1175", "dt_updated": "2026-01-20T10:38:38.509933-05:00"}, "client": {"id": 156117, "url": "https://lda.senate.gov/api/v1/clients/156117/", "client_id": 12, "name": "UNIVERSITY OF IOWA", "general_description": null, "client_government_entity": true, "client_self_select": true, "state": "IA", "state_display": "Iowa", "country": "US", "country_display": "United States of America", "ppb_state": "IA", "ppb_state_display": "Iowa", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Funding for the Rural Policy Research Institute", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 23 robust funding for all federal research agencies including, NIH, CDC, NSF, Department of Defense (Army RDT&E), NASA (support for Heliophysics division and Science Mission Directorate), National Institute of Occupational Health and Safety (NIOSH), Injury Control Research Centers, Public Health Training Centers, National Endowment for the Humanities, Educational and Cultural Affairs program at Department of State (including Fulbright Program), NOAA, Department of Energy Office of Science, and federal student aid programs including Pell Grant program, Federal Work-Study, Graduate Areas of National Need program, Supplemental Educational Opportunities Grant program (SEOG), and TRIO and Gear Up Support for Advanced Hydrologic Monitoring, Assessment, and Flood Forecasting for Eastern Iowa Community Funding project", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "FY 23 appropriations support for research arms of DOD Support for university collaboration for simulation and training programs at Department of Defense Support for university research regarding fitness assessments and training", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "EDU", "general_issue_code_display": "Education", "description": "Support for federal financial aid programs, including the Pell Grant program Support for graduate education programs Support for international student programs Support for research funding and graduate research opportunities Support for STEM programming", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Support for Palliative Care and Hospice Education Support for programs to support and treat student mental health", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "HOM", "general_issue_code_display": "Homeland Security", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": []}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Support for international students and current visa programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "Support for robust funding for federal agencies that fund medical and disease research", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "ROD", "general_issue_code_display": "Roads/Highway", "description": "Support for data on impaired driving Support for studies to improve and ensure the safe deployment of automated vehicles on rural roads", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "FY 23 appropriations for all federal agencies supporting science and technology research, including NASA, NSF, NOAA, NIST, DOD and DOE Support for investments at NSF, including provisions included in the United States Innovation and Competition Act (USICA), and NSF for the Future Act Support for investments at DOE, including in the DOE Science for the Future Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "TRA", "general_issue_code_display": "Transportation", "description": "Support for research and data on impaired driving.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": []}, {"general_issue_code": "MIA", "general_issue_code_display": "Media (information/publishing)", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": []}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "ART", "general_issue_code_display": "Arts/Entertainment", "description": "Support for robust funding for the National Endowment of the Humanities", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "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": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "N/A", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 137942, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "ALYSE", "nickname": null, "middle_name": null, "last_name": "GRAY PARKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64775, "prefix": null, "prefix_display": null, "first_name": "LEANNE", "nickname": null, "middle_name": null, "last_name": "HOTEK", "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": []} IA US 34573 IA IA US US   1 0           60000.0

Links from other tables