home / lobbying / lobbying_filings_raw

lobbying_filings_raw: dd770ed2-ddb1-4be5-a32b-78432b950161

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
dd770ed2-ddb1-4be5-a32b-78432b950161 Q1 40013105 OHIO FARM BUREAU FEDERATION 187816 OHIO FARM BUREAU FEDERATION 2026 first_quarter 2026-04-15T15:35:09-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/dd770ed2-ddb1-4be5-a32b-78432b950161/", "filing_uuid": "dd770ed2-ddb1-4be5-a32b-78432b950161", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2026, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/dd770ed2-ddb1-4be5-a32b-78432b950161/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "75000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Steven Bales", "dt_posted": "2026-04-15T15:35:09-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "280 North High Street", "registrant_address_2": "6th Floor", "registrant_different_address": false, "registrant_city": "Columbus", "registrant_state": "OH", "registrant_zip": "43215", "registrant": {"id": 40013105, "url": "https://lda.gov/api/v1/registrants/40013105/", "house_registrant_id": 39822, "name": "OHIO FARM BUREAU FEDERATION", "description": "Agricultural association", "address_1": "280 North High Street", "address_2": null, "address_3": null, "address_4": null, "city": "Columbus", "state": "OH", "state_display": "Ohio", "zip": "43215", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVEN BALES", "contact_telephone": "+1 614-246-8247", "dt_updated": "2026-08-31T11:46:33.870808-04:00"}, "client": {"id": 187816, "url": "https://lda.gov/api/v1/clients/187816/", "client_id": 48, "name": "OHIO FARM BUREAU FEDERATION", "general_description": "Agricultural association", "client_government_entity": false, "client_self_select": true, "state": "OH", "state_display": "Ohio", "country": "US", "country_display": "United States of America", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2020-12-07"}, "lobbying_activities": [{"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Protecting American Farmland Act (H.R. 3313) HR 1 Eminent Domain for Hydrogen and CO2 amendment opposition E15 Letter of Support, Sign-On Consideration", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 197, "name": "Federal Energy Regulatory Commission (FERC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "2025 Farm Bill Letter re: Executive Order establishing the Make America Healthy Again Commission Support Letter for Stephen Vaden for USDA Deputy Secretary Secretary Rollins letter of support MAHA Commission Stakeholder Letter Ag Labeling Uniformity Act Letter 2026 AWER Freeze Letter 2025 American Farm Bureau Federation Farm Economy Letter Agriculture and Related Agencies: FY2025 Appropriations Letter to USEPA re: Over the Top Use of \"dicamba-tolerant soybeans and dicamba-tolerant cotton\" Argentine Beef Imports Position Email to Aides Economic Assistance for Agricultural Industry 2025 E-15 Letter of Support, Sign on opportunity Coalition Letter on H-2a delays Market Relief for Farmers Pesticide Letter urging prompt approval from Administrator Zeldin", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 45, "name": "Commodity Futures Trading Commission (CFTC)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Ag Inputs & Pest Management Tools Congressional Letter FWS-R3-ES-2024-0137, Endangered Species Status for Monarch Butterfly HR1 Letter to USEPA supporting the Environmental Protection Agencys proposed Renewable Volume Obligations (RVOs) under the Renewable Fuel Standard (RFS) Set 2 rule Letter to USEPA re: Over the Top Use of \"dicamba-tolerant soybeans and dicamba-tolerant cotton\" Pesticide Letter to Admin Zeldin re: prompt approval for decamba", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Adverse Effect Wage Rate Letter H-2A Reform HR1 2025 American Farm Bureau Federation letter on Farm Economy H-2A Delays Letter", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "USMCA Tariffs Retaliatory Tariffs Chinese Tariffs HR1 2025 American Farm Bureau Federation letter on Farm Economy Argentine Beef Imports Email to Aides Response to Iran Conflict and the costs of Fuel/Fertilizer", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 98, "name": "U.S. International Trade Commission (ITC)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "2017 Tax Cuts and Jobs Act Renewal Corporate Transparency Act Section 199A Permanence Trade Association Letter HR1 Provide economic assistance to farmers due to Iran Conflict", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "2017 Tax Cuts and Jobs Act HR 1 199A Small Business Tax Deduction Estate Tax Exemption", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 64748, "prefix": null, "prefix_display": null, "first_name": "JACK", "nickname": null, "middle_name": null, "last_name": "IRVIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145324, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "BRADLEY", "last_name": "BALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} OH US 39822 OH OH US US Agricultural association 0 0           75000.0

Links from other tables

  • 42 rows from filing_uuid in lobbying_activities
  • 12 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.478ms · Privacy