home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b16bb1e2-9438-46cb-8a0a-b070b4fd2a35

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
b16bb1e2-9438-46cb-8a0a-b070b4fd2a35 Q1 21131 KANSAS FARM BUREAU 127796 KANSAS FARM BUREAU 2026 first_quarter 2026-04-14T13:42:44-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/b16bb1e2-9438-46cb-8a0a-b070b4fd2a35/", "filing_uuid": "b16bb1e2-9438-46cb-8a0a-b070b4fd2a35", "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/b16bb1e2-9438-46cb-8a0a-b070b4fd2a35/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "90000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Ryan D. Flickner", "dt_posted": "2026-04-14T13:42:44-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "2627 KFB PLAZA", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "MANHATTAN", "registrant_state": "KS", "registrant_zip": "66503", "registrant": {"id": 21131, "url": "https://lda.gov/api/v1/registrants/21131/", "house_registrant_id": 33645, "name": "KANSAS FARM BUREAU", "description": "Agricultural Adovcacy and Education.", "address_1": "2627 KFB PLAZA", "address_2": null, "address_3": null, "address_4": null, "city": "MANHATTAN", "state": "KS", "state_display": "Kansas", "zip": "66503", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RYAN D. FLICKNER", "contact_telephone": "+1 785-587-6327", "dt_updated": "2026-07-15T16:45:58.539298-04:00"}, "client": {"id": 127796, "url": "https://lda.gov/api/v1/clients/127796/", "client_id": 12, "name": "KANSAS FARM BUREAU", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "KS", "state_display": "Kansas", "country": "US", "country_display": "United States of America", "ppb_state": "KS", "ppb_state_display": "Kansas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2014-01-01"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Farm Bill Reauthorization & Supplemental Disaster Aid Farmer Bridge Assistance Program Support the One Big Beautiful Bill Act relating to Farm Bill provisions Conservation Program implementation including Environmental Quality Incentive Program (EQIP), Conservation Stewardship Program (CSP), Conservation Reserve Program (CRP), and Regional Partnership Program (RCPP) Crop Insurance Livestock & Animal disease preparedness, including New World Screwworm (NWS)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Waters of the United States Flint Hills Smoke Management Plan", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR 1, the One Big Beautiful Bill Act Biodiesel Tax Credits Production Tax Credits for Renewable Fuels and Renewable Energy Renewable Energy Tax Credits Capital Gains Taxes & Stepped-up Basis Estate Tax Repeal Reform Like-Kind Exchanges (Section 1031) Clean Fuel Production Tax Credit Sustainable Aviation Fuel Tax Credit Biodiesel Tax Credit", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "US Trade Negotiations with Other Nations (United Kingdom, EU, Canada, Mexico, China, etc PL 480, Food for Peace transferring to USDA Food for Progress McGovern Dole, International Food for Education USMCA Retaliatory Tariffs HR 1, the One Big Beautiful Bill Act Country of Origin Labeling", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "Future highway and transportation funding Infrastructure & Inland Waterways Supply Chain Water Resources Development Act Hours of Service Regulations Proposed railroad mergers", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "General Immigration & Labor Reform Border Security H-2A Legislative Reforms Adverse Effective Wage Rate (AEWR) HR 1, the One Big Beautiful Bill Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Access to agricultural credit USDA-FSA lending and borrowing programs Implementation of the Corporate Transparency Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "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": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Renewable Fuel Standard/Renewable Volume Obligation Production Tax Credits for Renewable Fuels and Renewable Energy Year round E15 Availability Sustainable Aviation Fuel (SAF) Energy generation & energy transmission siting and permitting Fertilizer availability and costs Fuel (diesel) pricing", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60160, "prefix": "mr", "prefix_display": "MR.", "first_name": "RYAN", "nickname": null, "middle_name": "D", "last_name": "FLICKNER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} KS US 33645 KS KS US US   0 0           90000.0

Links from other tables

  • 48 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.448ms · Privacy