home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 5531bddf-e3f0-4e75-bc40-8239642562bb

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
5531bddf-e3f0-4e75-bc40-8239642562bb Q1 401106120 SCHERTZ STRATEGIES, LLC 211618 MINN-DAK FARMERS COOPERATIVE 2025 first_quarter 2025-04-16T16:30:14-04:00 90000.0 0 0 0 {"url": "https://lda.gov/api/v1/filings/5531bddf-e3f0-4e75-bc40-8239642562bb/", "filing_uuid": "5531bddf-e3f0-4e75-bc40-8239642562bb", "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/5531bddf-e3f0-4e75-bc40-8239642562bb/print/", "filing_document_content_type": "text/html", "income": "90000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Matt Schertz", "dt_posted": "2025-04-16T16:30:14-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "11 College Circle", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Staunton", "registrant_state": "VA", "registrant_zip": "24401", "registrant": {"id": 401106120, "url": "https://lda.gov/api/v1/registrants/401106120/", "house_registrant_id": null, "name": "SCHERTZ STRATEGIES, LLC", "description": "Lobbying and consulting firm.", "address_1": "11 College Circle", "address_2": null, "address_3": null, "address_4": null, "city": "Staunton", "state": "VA", "state_display": "Virginia", "zip": "24401", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ELIZABETH WHITE", "contact_telephone": "+1 202-251-2980", "dt_updated": "2026-01-30T12:28:03.700954-05:00"}, "client": {"id": 211618, "url": "https://lda.gov/api/v1/clients/211618/", "client_id": 12, "name": "MINN-DAK FARMERS COOPERATIVE", "general_description": "Sugarbeet processor.", "client_government_entity": false, "client_self_select": null, "state": "ND", "state_display": "North Dakota", "country": "US", "country_display": "United States of America", "ppb_state": "ND", "ppb_state_display": "North Dakota", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2021-07-26"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY 2026 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations. HR 10545, American Relief Act, regarding agriculture. FY 2025 Budget process regarding agriculture. H. Con. Res. 14 and S. Con. Res. 7, FY 2025 Budget Resolution.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 121820, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SCHERTZ", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives, Committee on Agriculture - Staff Director", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "H.R.8467 Farm, Food, and National Security Act of 2024. Issues and bills regarding the development of the 2025 Farm Bill. Farm Bill implementation and administration of U.S. sugar policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 121820, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SCHERTZ", "suffix": null, "suffix_display": null}, "covered_position": "U.S. House of Representatives, Committee on Agriculture - Staff Director.", "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": "Administration of US sugar policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 121820, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SCHERTZ", "suffix": null, "suffix_display": null}, "covered_position": "US House of Representatives, Committee on Agriculture - Staff Director", "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": "IMM", "general_issue_code_display": "Immigration", "description": "Issues related to the H-2A Temporary Agriculture Worker Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 121820, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SCHERTZ", "suffix": null, "suffix_display": null}, "covered_position": "US House of Representatives, Committee on Agriculture - Staff Director.", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US   ND ND US US Sugarbeet processor. 0 0 2169785   normalized_name_state 0.9

Links from other tables

  • 12 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 15.724ms