home / lobbying / lobbying_filings_raw

lobbying_filings_raw: fde363d7-e5a2-4f7f-a572-76ae2bf5f861

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
fde363d7-e5a2-4f7f-a572-76ae2bf5f861 Q2 286451 CHS INC. 176515 CHS, INC 2018 second_quarter 2018-07-18T10:51:59.053000-04:00 260000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/fde363d7-e5a2-4f7f-a572-76ae2bf5f861/", "filing_uuid": "fde363d7-e5a2-4f7f-a572-76ae2bf5f861", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/fde363d7-e5a2-4f7f-a572-76ae2bf5f861/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "260000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "John T. Engelen", "dt_posted": "2018-07-18T10:51:59.053000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "5500 Cenex Drive", "registrant_address_2": "ms 411", "registrant_different_address": false, "registrant_city": "Inver Grove Heights", "registrant_state": "MN", "registrant_zip": "55077", "registrant": {"id": 286451, "url": "https://lda.senate.gov/api/v1/registrants/286451/", "house_registrant_id": 36960, "name": "CHS INC.", "description": "Agricultural Services", "address_1": "5500 Cenex Drive", "address_2": "ms 411", "address_3": null, "address_4": null, "city": "Inver Grove Heights", "state": "MN", "state_display": "Minnesota", "zip": "55077", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ANGELA TANGEN", "contact_telephone": "+1 612-710-0160", "dt_updated": "2026-01-13T12:07:17.951503-05:00"}, "client": {"id": 176515, "url": "https://lda.senate.gov/api/v1/clients/176515/", "client_id": 12, "name": "CHS, INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "MN", "state_display": "Minnesota", "country": "US", "country_display": "United States of America", "ppb_state": "MN", "ppb_state_display": "Minnesota", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2012-07-18"}, "lobbying_activities": [{"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "All provisions of H.R. 5988, Common Sense Certification Reform Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRU", "general_issue_code_display": "Trucking/Shipping", "description": "All provisions of H.R. 5358, DRIVE-Safe Act, the Developing Responsible Individuals for a Vibrant Economy Act", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Issues related to potential abuse of extradition treaties and Interpol processes", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56674, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "T", "last_name": "ENGELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Issues related to apprenticeship programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "All provisions of H.R. 3264, The Biodiesel, Renewable Diesel and Alternative Fuels Extension Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56674, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "T", "last_name": "ENGELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Issues related to the North American Free Trade Agreement\nIssues related to soybean trade with China\nIssues related to Section 232 steel and aluminum tariffs\nIssues related to USTR's Section 301 investigation", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56674, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "T", "last_name": "ENGELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "H.R. 2, Agriculture and Nutrition Act of 2018, provisions related to the conservation title and crop insurance and provisions related to trade promotion programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 56674, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": "T", "last_name": "ENGELEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "MAR", "general_issue_code_display": "Marine/Maritime/Boating/Fisheries", "description": "Issues relating to the Merchant Marine Act of 1920 (Jones Act)\nAll provisions of H.R. 8, Water Resources Development Act of 2018 \nIssues relating to the U.S. Coast Guard's Great Lakes Pilotage Division", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 57200, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "WYATT", "last_name": "COBB", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FOO", "general_issue_code_display": "Food Industry (safety, labeling, etc.)", "description": "P.L. 114-216, National Bioengineered Food Disclosure Standard, provisions related to highly refined products\nP.L. 111-353, Food Safety Modernization Act, provisions related to exemptions for grain elevators", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 59244, "prefix": "ms", "prefix_display": "MS.", "first_name": "SARAH", "nickname": null, "middle_name": "TERESA", "last_name": "GALLO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 1, "name": "SENATE"}, {"id": 171, "name": "U.S. Coast Guard (USCG)"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 9 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 4.104ms