home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a81fd3ca-31cb-464b-b42c-d82783387416

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
a81fd3ca-31cb-464b-b42c-d82783387416 Q1 35800 THE SMITH-FREE GROUP, LLC 204430 THE KROGER CO. 2025 first_quarter 2025-04-17T09:57:26-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/a81fd3ca-31cb-464b-b42c-d82783387416/", "filing_uuid": "a81fd3ca-31cb-464b-b42c-d82783387416", "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/a81fd3ca-31cb-464b-b42c-d82783387416/print/", "filing_document_content_type": "text/html", "income": "70000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "John Christie, Senior Vice President", "dt_posted": "2025-04-17T09:57:26-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1001 G Street, NW", "registrant_address_2": "Suite 375 West", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 35800, "url": "https://lda.gov/api/v1/registrants/35800/", "house_registrant_id": 30770, "name": "THE SMITH-FREE GROUP, LLC", "description": "Government relations and business consulting", "address_1": "1001 G Street NW", "address_2": "Suite 375 West", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOHN CHRISTIE", "contact_telephone": "+1 202-393-4760", "dt_updated": "2026-01-30T13:49:07.819808-05:00"}, "client": {"id": 204430, "url": "https://lda.gov/api/v1/clients/204430/", "client_id": 1004292, "name": "THE KROGER CO.", "general_description": "American retail company", "client_government_entity": false, "client_self_select": null, "state": "OH", "state_display": "Ohio", "country": "US", "country_display": "United States of America", "ppb_state": "OH", "ppb_state_display": "Ohio", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2020-04-03"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Discussions relating to the Farm Bill Monitored executive branch nominations to federal agencies and commissions Monitored 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.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143170, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHRISTIE", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63331, "prefix": null, "prefix_display": null, "first_name": "TREVOR", "nickname": null, "middle_name": "W.", "last_name": "KOLEGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44116, "prefix": "mr", "prefix_display": "MR.", "first_name": "JACK", "nickname": null, "middle_name": "S", "last_name": "DEUSER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 146563, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "MAXWELL", "last_name": "BECKER", "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": "BAN", "general_issue_code_display": "Banking", "description": "Discussions related to credit card swipe fees", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143170, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHRISTIE", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44116, "prefix": "mr", "prefix_display": "MR.", "first_name": "JACK", "nickname": null, "middle_name": "S", "last_name": "DEUSER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Discussions relating to privacy legislation Discussions inv0lving organized retail crime Monitored discussions involving pending business transacations", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143170, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHRISTIE", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44116, "prefix": "mr", "prefix_display": "MR.", "first_name": "JACK", "nickname": null, "middle_name": "S", "last_name": "DEUSER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 63331, "prefix": null, "prefix_display": null, "first_name": "TREVOR", "nickname": null, "middle_name": "W.", "last_name": "KOLEGO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66549, "prefix": null, "prefix_display": null, "first_name": "W.", "nickname": null, "middle_name": "TIMOTHY", "last_name": "LOCKE", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "HR 1317 Improving Care and Access to Nurses (I CAN) Act (all sections of full text) HR 2495 Medical Nutrition Therapy Act (all sections of full text) Discussions pertaining to pharmacy reimbursement Discussions regarding Pharmacy Benefit Managers", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 146563, "prefix": "mr", "prefix_display": "MR.", "first_name": "JEFFREY", "nickname": null, "middle_name": "MAXWELL", "last_name": "BECKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143170, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHRISTIE", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Monitored discussions regarding labor relations Monitored discussions regarding minimum wage Monitored discussions regarding Department of Labor FLSA overtime rule Monitored discussions regarding Supplemental Security Income (SSI) labor savings penalty elimination", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143170, "prefix": "mr", "prefix_display": "MR.", "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "CHRISTIE", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": []}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Monitored discussions involving tax reform", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 44116, "prefix": "mr", "prefix_display": "MR.", "first_name": "JACK", "nickname": null, "middle_name": "S", "last_name": "DEUSER", "suffix": "jr", "suffix_display": "JR"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 107000, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "A.", "last_name": "GAFFIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": []}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30770 OH OH US US American retail company 0 0         70000.0  

Links from other tables

  • 18 rows from filing_uuid in lobbying_activities
  • 18 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.367ms · Privacy