home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 46e07e0f-1ada-4dab-8b50-e9cbc5e29f3c

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 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
46e07e0f-1ada-4dab-8b50-e9cbc5e29f3c Q1 3572 AMERICAN SUGARBEET GROWERS ASSOCIATION 103676 AMERICAN SUGARBEET GROWERS ASSOCIATION 2025 first_quarter 2025-04-16T10:10:09-04:00 130000.0 0 0 0 {"url": "https://lda.gov/api/v1/filings/46e07e0f-1ada-4dab-8b50-e9cbc5e29f3c/", "filing_uuid": "46e07e0f-1ada-4dab-8b50-e9cbc5e29f3c", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/46e07e0f-1ada-4dab-8b50-e9cbc5e29f3c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "130000.00", "expenses_method": "C", "expenses_method_display": "C", "posted_by_name": "Zachary Clark", "dt_posted": "2025-04-16T10:10:09-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1155 15TH STREET, NW", "registrant_address_2": "#1100", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 3572, "url": "https://lda.gov/api/v1/registrants/3572/", "house_registrant_id": 32240, "name": "AMERICAN SUGARBEET GROWERS ASSOCIATION", "description": null, "address_1": "1155 15TH STREET, NW, #1100", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ZACHARY CLARK", "contact_telephone": "+1 202-595-0737", "dt_updated": "2026-01-05T10:31:49.209989-05:00"}, "client": {"id": 103676, "url": "https://lda.gov/api/v1/clients/103676/", "client_id": 12, "name": "AMERICAN SUGARBEET GROWERS ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-01"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Agriculture Improvement Act of 2018-Sugar Provisions Farm, Food, and National Security Act of 2024-Sugar Provisions US Sugar Program Administration at USDA", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70802, "prefix": null, "prefix_display": null, "first_name": "ZACHARY", "nickname": null, "middle_name": null, "last_name": "CLARK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41156, "prefix": "mr", "prefix_display": "MR.", "first_name": "LUTHER", "nickname": null, "middle_name": "ALLAN", "last_name": "MARKWART", "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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "US Sugar Program including Tariff Rate Quota Proposed and executed 2025 tariffs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41156, "prefix": "mr", "prefix_display": "MR.", "first_name": "LUTHER", "nickname": null, "middle_name": "ALLAN", "last_name": "MARKWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70802, "prefix": null, "prefix_display": null, "first_name": "ZACHARY", "nickname": null, "middle_name": null, "last_name": "CLARK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.Con.Res.14 - Establishing the congressional budget for the United States Government for fiscal year 2025 and setting forth the appropriate budgetary levels for fiscal years 2026 through 2034 S.Con.Res.7An original concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2025 and setting forth the appropriate budgetary levels for fiscal years 2026 through 2034.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41156, "prefix": "mr", "prefix_display": "MR.", "first_name": "LUTHER", "nickname": null, "middle_name": "ALLAN", "last_name": "MARKWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70802, "prefix": null, "prefix_display": null, "first_name": "ZACHARY", "nickname": null, "middle_name": null, "last_name": "CLARK", "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": "INS", "general_issue_code_display": "Insurance", "description": "Support for Crop Insurance Support and changes to beet policies related to price election, revenue insurance, and enterprise units", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70802, "prefix": null, "prefix_display": null, "first_name": "ZACHARY", "nickname": null, "middle_name": null, "last_name": "CLARK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 41156, "prefix": "mr", "prefix_display": "MR.", "first_name": "LUTHER", "nickname": null, "middle_name": "ALLAN", "last_name": "MARKWART", "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": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Advocating for the rehiring of ARS beet researchers and technicians", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41156, "prefix": "mr", "prefix_display": "MR.", "first_name": "LUTHER", "nickname": null, "middle_name": "ALLAN", "last_name": "MARKWART", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 70802, "prefix": null, "prefix_display": null, "first_name": "ZACHARY", "nickname": null, "middle_name": null, "last_name": "CLARK", "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": []} DC US 32240 DC DC US US   0 0 969812   normalized_name_state 0.9

Links from other tables

  • 15 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 225.112ms