home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2cccd489-e899-4c6c-8bc8-b8e966566bbf

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
2cccd489-e899-4c6c-8bc8-b8e966566bbf Q1 6564 SOUTHERN ILLINOIS UNIVERSITY 108781 SOUTHERN ILLINOIS UNIVERSITY 2020 first_quarter 2020-04-13T11:56:23.847000-04:00 11250.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2cccd489-e899-4c6c-8bc8-b8e966566bbf/", "filing_uuid": "2cccd489-e899-4c6c-8bc8-b8e966566bbf", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2cccd489-e899-4c6c-8bc8-b8e966566bbf/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "11250.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "John Charles", "dt_posted": "2020-04-13T11:56:23.847000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "520 SOUTH 2ND STREET", "registrant_address_2": "SUITE 2-110", "registrant_different_address": false, "registrant_city": "SPRINGFIELD", "registrant_state": "IL", "registrant_zip": "62701", "registrant": {"id": 6564, "url": "https://lda.senate.gov/api/v1/registrants/6564/", "house_registrant_id": 32508, "name": "SOUTHERN ILLINOIS UNIVERSITY", "description": null, "address_1": "520 SOUTH 2ND STREET", "address_2": "SUITE 2-110", "address_3": null, "address_4": null, "city": "SPRINGFIELD", "state": "IL", "state_display": "Illinois", "zip": "62701", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DANIEL MAHONY", "contact_telephone": "+1 217-545-8080", "dt_updated": "2026-01-28T10:09:31.482090-05:00"}, "client": {"id": 108781, "url": "https://lda.senate.gov/api/v1/clients/108781/", "client_id": 12, "name": "SOUTHERN ILLINOIS UNIVERSITY", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "IL", "state_display": "Illinois", "country": "US", "country_display": "United States of America", "ppb_state": "IL", "ppb_state_display": "Illinois", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Corresponded with Senator Durbins Congressman LaHood & Congressman Bosts office on a meeting for med students who were in DC for a conference on March 5-7.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59884, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHARLES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "Met with Congressman LaHood on Feb 20 at the Simmons Cancer Institute to talk about 340B pricing and other cancer-related issues including Simmons outreach to the African American community to discuss cancer testing and prevention.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59884, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHARLES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "A letter was sent out to members Congressman LaHood, Bost and Davis on the COVID-19 emergency legislation that Congress is working on. \n\n\nOn behalf of the Southern Illinois University System, I ask for urgent assistance for Illinois students and universities in the COVID-19 emergency legislation that Congress is currently working on.\n\nWhile we are still assembling data, we know already that the financial impact of the COVID-19 pandemic will be substantial. For example:\nSouthern Illinois University Carbondale estimates a potential of $22.3 million in lost revenue, which includes refunding housing and dining costs and other costs which are developing as the pandemic continues.\nSouthern Illinois University Edwardsville estimates that refunding housing and dining costs to students who are going to continue their studies from home and other potential costs could cost approximately $20.8 million.\n \nAccordingly, we ask for the following relief:\n\n1.Make public universities eligible for the refundable tax credits included in the Families First Coronavirus Response Act;\n2.Emergency funding to financially stabilize universities in responding to COVID-19 and to directly support students;\nï\u0192\u02dcWhile we are pleased that the draft bill released by Senate Majority Leader McConnell includes an Education Stabilization Fund, it only provides $6 billion for higher education-far less than the $50+ billion request from the higher ed community;\n3.Technology funding to support move to distance education;\n4.Regulatory flexibility to protect students;\n5.Access to capital through low- or no-interest loans;\n6.Regulatory flexibility and resources on research issues.\n\nFurther information on items 2-5 is in this document compiled by our leading higher education associations-the American Council on Education, the Association of Public and Land-grant Universities, and the Association of American Universities-while this letter discusses item 6.\n \nWe thank you for all that youre doing during this challenging time, and appreciate your considering our urgent request for assistance. Please let us know if we can provide any additional information or answer any questions.\n\nSincerely,\n \nJohn Charles\nDirector of Government & Public Affairs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59884, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHARLES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 6.169ms