home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b68efb52-5a30-4d38-ad16-f15670459022

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
b68efb52-5a30-4d38-ad16-f15670459022 Q1 40031264 WASHINGTON UNIVERSITY IN ST. LOUIS 188244 WASHINGTON UNIVERSITY IN ST LOUIS 2022 first_quarter 2022-04-15T14:05:13-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b68efb52-5a30-4d38-ad16-f15670459022/", "filing_uuid": "b68efb52-5a30-4d38-ad16-f15670459022", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b68efb52-5a30-4d38-ad16-f15670459022/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Pamela Lokken", "dt_posted": "2022-04-15T14:05:13-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1 Brookings Drive", "registrant_address_2": "MSC 1191-105-155", "registrant_different_address": true, "registrant_city": "St. Louis", "registrant_state": "MO", "registrant_zip": "63130", "registrant": {"id": 40031264, "url": "https://lda.senate.gov/api/v1/registrants/40031264/", "house_registrant_id": 39910, "name": "WASHINGTON UNIVERSITY IN ST. LOUIS", "description": "Higher education, research, patient care", "address_1": "1 Brookings Drive", "address_2": "MSC 1191-105-155", "address_3": null, "address_4": null, "city": "St. Louis", "state": "MO", "state_display": "Missouri", "zip": "63130", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "J.D. BURTON", "contact_telephone": "+1 314-935-5752", "dt_updated": "2026-01-21T09:52:57.068506-05:00"}, "client": {"id": 188244, "url": "https://lda.senate.gov/api/v1/clients/188244/", "client_id": 48, "name": "WASHINGTON UNIVERSITY IN ST LOUIS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "MO", "state_display": "Missouri", "country": "US", "country_display": "United States of America", "ppb_state": "MO", "ppb_state_display": "Missouri", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-02-28"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "General advocacy in support of student aid and federal research accounts for Fiscal Year 2022 and Fiscal Year 2023, including research supported by the National Science Foundation, Department of Energy Office of Science, Department of Defense, National Aeronautics and Space Administration, Department of Agriculture, and National Institutes of Health. H.R. 2471 -- Consolidated Appropriations Act, 2022 -- An Act making consolidated appropriations for the fiscal year ending September 30, 2022, and for providing emergency assistance for the situation in Ukraine, and for other purposes. Advocacy in support of student aid programs and research and training accounts within the National Institutes of Health, Centers for Disease Control and Prevention, National Science Foundation, Department of Energy Office of Science, Department of Defense, National Aeronautics and Space Administration, and Department of Agriculture. House Draft Bill / Senate Draft Bill -- Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2023 - A bill making appropriations for the Departments of Labor, Health and Human Services, and Education, and related agencies for the fiscal year ending September 30, 2022, and for other purposes. Advocacy in support of student aid programs and overall basic science, research, and training accounts within the National Institutes of Health, Centers for Disease Control and Prevention, and Department of Health and Human Services.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": "SCI", "general_issue_code_display": "Science/Technology", "description": "General advocacy for basic science, research, and education programs within the federal government, including the NSF, DOE Office of Science, DoD, NASA, USDA, and NIH. H.R. 4521 -- America COMPETES Act of 2022 -- An Act to provide for a coordinated Federal research initiative to ensure continued United States leadership in engineering biology. S. 1260 -- United States Innovation and Competition Act of 2021 -- An Act to establish a new Directorate for Technology and Innovation in the National Science Foundation, to establish a regional technology hub program, to require a strategy and report on economic security, science, research, innovation, manufacturing, and job creation, to establish a critical supply chain resiliency program, and for other purposes. General support for increasing resources for federal research agencies, including the National Science Foundation and Office of Energy Office of Science; for regional research and technology competitiveness initiatives; and support for international students receiving U.S. PhDs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": "General advocacy for access to federal student aid programs, including Pell Grants, maintaining the in-school interest subsidy for student borrowers, the Federal Supplemental Education Opportunity Grant (SEOG) program, internships, fellowships, and student loan forgiveness programs.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": "General advocacy for NIH and other biomedical research. General advocacy supporting the continued responsible utilization of research animals. General support for the development of fair and effective organ transplant policies.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": "General advocacy for federal tax provisions impacting universities. General support for efforts to reconsider the excise tax on investment income of private colleges and universities.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": "IMM", "general_issue_code_display": "Immigration", "description": "General advocacy for immigration and visa policies that allow universities to continue the recruitment and retention of talented international students and scholars. Advocacy for action to support those individuals eligible for the Deferred Action for Childhood Arrivals program and for the Optional Practical Training Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43362, "prefix": "mr", "prefix_display": "MR.", "first_name": "JASON", "nickname": null, "middle_name": "M", "last_name": "VAN WEY", "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": []} MO US 39910 MO MO US US   0 0           10000.0

Links from other tables

  • 6 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.563ms · Privacy