home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c8e58186-b78e-4bbe-87fb-3bc695acdc8d

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

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
c8e58186-b78e-4bbe-87fb-3bc695acdc8d Q1 401104765 GREEN PLAINS INC. 202660 GREEN PLAINS 2022 first_quarter 2022-04-12T10:21:33-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c8e58186-b78e-4bbe-87fb-3bc695acdc8d/", "filing_uuid": "c8e58186-b78e-4bbe-87fb-3bc695acdc8d", "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/c8e58186-b78e-4bbe-87fb-3bc695acdc8d/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "380000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Devin Mogler", "dt_posted": "2022-04-12T10:21:33-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1811 Aksarben Drive", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Omaha", "registrant_state": "NE", "registrant_zip": "68106", "registrant": {"id": 401104765, "url": "https://lda.senate.gov/api/v1/registrants/401104765/", "house_registrant_id": null, "name": "GREEN PLAINS INC.", "description": "ethanol production, marketing and commodities company.", "address_1": "1811 Aksarben Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Omaha", "state": "NE", "state_display": "Nebraska", "zip": "68106", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRIS KNUTSON", "contact_telephone": "+1 402-952-4847", "dt_updated": "2026-01-27T12:43:32.682281-05:00"}, "client": {"id": 202660, "url": "https://lda.senate.gov/api/v1/clients/202660/", "client_id": 12, "name": "GREEN PLAINS", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "NE", "state_display": "Nebraska", "country": "US", "country_display": "United States of America", "ppb_state": "NE", "ppb_state_display": "Nebraska", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2018-01-31"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Issues related to the RFS; Issues related to ethanol exports; Issues related to distiller grain exports; Issues related to 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2021 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2022 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2023 and beyond Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery exemptions from RFS compliance; Issues related to Reid Vapor Pressure (RVP) waiver extension from E10 to E15 blends; Issues related to COVID-19 including economic impact on ethanol supply and demand; Issues related to the USDA Higher Blends Infrastructure Incentive Program; Issues related to the 10th circuit small refinery exemption decision and SCOTUS review; Issues related to the Biofuel Producer Program; Issues related to life cycle assessment modeling for crops used to make biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Issues related to bills to fund the government, specifically policy items related to tax provisions; Issues related to bills to fund the government, specifically small refinery hardship waivers from the Renewable Fuel Standard (RFS) in report language; Issues related to COVID-19 including appropriations to the USDA for CCC; Issues related to the USDA Higher Blends Infrastructure Incentive Program; Issues related to the 10th circuit small refinery exemption decision; Issues related to the Biofuel Producer Program; Issues related to carbon capture and sequestration, including 45Q tax credits and direct payment options; Issues related to life cycle assessment modeling for biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel; Issues related to tax treatment for master limited partnerships; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) fix for mid-level ethanol-blended fuels; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2021 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2022 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2023 and beyond Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN caps, export credits, transparency, and other measures to influence RIN values; Issues related to higher octane fuels; Issues related to COVID-19 including economic impact on ethanol supply and demand; Issues related to funding for refueling infrastructure capable of handling higher blends of ethanol; Issues related to the USDA Higher Blends Infrastructure Incentive Program; Issues related to the 10th circuit small refinery exemption decision and SCOTUS review; Issues related to carbon capture and sequestration, including 45Q tax credits and direct payment options; Issues related to life cycle assessment modeling for crops used to make biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) fix for mid-level ethanol-blended fuels; Issues related to partial waivers for a 15 percent ethanol fuel (E15); Issues related to E15 fueling infrastructure; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2021 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2022 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2023 and beyond Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN reforms, including transparency, price caps and export credits; Issues related to higher octane fuels; Issues related to Carbon Capture and Sequestration (CCS) technology, including 45Q tax credits and the SCALE Act, the CATCH Act and others; Issues related to COVID-19 including economic impact on ethanol supply and demand; Issues related to the USDA Higher Blends Infrastructure Incentive Program; Issues related to the 10th circuit small refinery exemption decision and SCOTUS review; Issues related to biofuels in reconciliation bills; Issues related to life cycle assessment modeling for crops used to make biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "Issues related to the RFS; Issues related to a Reid Vapor Pressure (RVP) waiver for mid-level ethanol-blended fuels; Issues related to partial waivers for a 15 percent ethanol fuel (E15); Issues related to E10 and E15 infrastructure and labeling; Issues related to the 2020 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2021 Renewable Volume Obligation (RVO) under the RFS; Issues related to 2022 Renewable Volume Obligation (RVO) under the RFS; Issues related to unwarranted small refinery RFS compliance waivers; Issues related to proposed RIN reforms; Issues related to higher octane fuels; Issues related to Carbon Capture and Sequestration (CCS) technology, including 45Q tax credits and the SCALE Act, the CATCH Act and others; Issues related to COVID-19 including economic impact on ethanol supply and demand; Issues related to funding for refueling infrastructure capable of handling higher blends of ethanol; Issues related to the USDA Higher Blends Infrastructure Incentive Program; Issues related to the 10th circuit small refinery exemption decision and SCOTUS review; Issues related to biofuels in reconciliation bills; Issues related to life cycle assessment modeling for crops used to make biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Issues related to ethanol exports; Issues related to ethanol imports; Issues related to dried distillers grains (DDGS) exports; Issues related to agricultural commodity exports and tariffs; Issues related to trade negotiations with China, specifically purchase commitments and tariffs on ethanol and DDGS as part of the Phase I deal; Issues related to trade with Brazil, specifically tariff rate quotas on ethanol; Issues related to enforcement of USMCA; Issues related to trade with various nations; Issues related to COVID-19 including economic impact on ethanol supply and demand; Issues related to imports of biofuels and biofuel feedstocks", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst", "new": true}], "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"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to COVID-19; Issues related to Carbon Capture and Sequestration (CCS) technology, including 45Q tax credits and the SCALE Act, the CATCH Act and others; Issues related to tax incentives for fuel retailers to sell higher blends of ethanol; Issues related to tax incentives for car manufacturers to produce flex fuel vehicles; Issues related to Master Limited Partnerships (MLP) tax treatment; Issues related to life cycle assessment modeling for crops used to make biofuels including ethanol, biodiesel, renewable diesel and sustainable aviation fuel (SAF), particularly as it relates to proposed tax credits for SAF; Issues related to proposed clean fuel production tax credits", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "Senator Joni Ernst (R-IA)", "new": false}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "AVI", "general_issue_code_display": "Aviation/Airlines/Airports", "description": "Issues related to life cycle assessment modeling for crops used to make biofuels including sustainable aviation fuel (SAF); Issues related to tax credits for the production of SAF", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "Sen. Joni Ernst (R-IA)", "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Issues related to the OSHA workplace COVID vaccination, testing and masking rule for employers over 100 employees;", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67889, "prefix": null, "prefix_display": null, "first_name": "DEVIN", "nickname": null, "middle_name": null, "last_name": "MOGLER", "suffix": null, "suffix_display": null}, "covered_position": "U.S. Senator Joni Ernst (R-IA)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} NE US   NE NE US US   0 0           380000.0

Links from other tables

  • 9 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.256ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy