lobbying_filings_raw: ad007bb9-caf3-4e61-8d96-3c490df356d0

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
ad007bb9-caf3-4e61-8d96-3c490df356d0 Q1 401104549 APPALACHIAN CITIZENS LAW CENTER INC. 202032 APPALACHIAN CITIZENS LAW CENTER INC. 2026 first_quarter 2026-04-01T09:39:30-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/ad007bb9-caf3-4e61-8d96-3c490df356d0/", "filing_uuid": "ad007bb9-caf3-4e61-8d96-3c490df356d0", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2026, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/ad007bb9-caf3-4e61-8d96-3c490df356d0/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "10000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Rebecca Shelton", "dt_posted": "2026-04-01T09:39:30-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "317 Main Street", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Whitesburg", "registrant_state": "KY", "registrant_zip": "41858", "registrant": {"id": 401104549, "url": "https://lda.gov/api/v1/registrants/401104549/", "house_registrant_id": null, "name": "APPALACHIAN CITIZENS LAW CENTER INC.", "description": "Non-profit law firm.", "address_1": "317 Main Street", "address_2": null, "address_3": null, "address_4": null, "city": "Whitesburg", "state": "TN", "state_display": "Tennessee", "zip": "41858", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "REBECCA SHELTON", "contact_telephone": "+1 606-633-3929", "dt_updated": "2026-07-23T12:37:46.597483-04:00"}, "client": {"id": 202032, "url": "https://lda.gov/api/v1/clients/202032/", "client_id": 12, "name": "APPALACHIAN CITIZENS LAW CENTER INC.", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "KY", "state_display": "Kentucky", "country": "US", "country_display": "United States of America", "ppb_state": "KY", "ppb_state_display": "Kentucky", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2017-07-01"}, "lobbying_activities": [{"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "topics related to the reclamation of mine lands, including bonding and water treatment.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71758, "prefix": null, "prefix_display": null, "first_name": "REBECCA", "nickname": null, "middle_name": null, "last_name": "SHELTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "topics related to coal mine safety and health, specifically improvements to the black lung benefits system.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71758, "prefix": null, "prefix_display": null, "first_name": "REBECCA", "nickname": null, "middle_name": null, "last_name": "SHELTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143346, "prefix": null, "prefix_display": null, "first_name": "BRENDAN", "nickname": null, "middle_name": null, "last_name": "MUCKIAN-BATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Funding programs related to flood mitigation and response, including funding for the Appalachian Regional Reforestation Initiative, the USGS streamgage program, funding for FEMA FMA and BRIC programs, funding for FEMA flood mapping, and funding for the USDA rural disaster home repair program. Funding programs related to miner safety and health including Mine Safety and Health Administration operating budget, funding for black lung clinics, and funding for coal worker health and screening programs at NIOSH. Funding programs related to the office of surface mining reclamation and enforcement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71758, "prefix": null, "prefix_display": null, "first_name": "REBECCA", "nickname": null, "middle_name": null, "last_name": "SHELTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143346, "prefix": null, "prefix_display": null, "first_name": "BRENDAN", "nickname": null, "middle_name": null, "last_name": "MUCKIAN-BATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DIS", "general_issue_code_display": "Disaster Planning/Emergencies", "description": "The Championing Local Efforts to Increase Resilience Act, the Fixing Emergency Management for Americans (FEMA) Act of 2025, and other initiatives related to flood mitigation and recovery in Appalachia.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143346, "prefix": null, "prefix_display": null, "first_name": "BRENDAN", "nickname": null, "middle_name": null, "last_name": "MUCKIAN-BATES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 71758, "prefix": null, "prefix_display": null, "first_name": "REBECCA", "nickname": null, "middle_name": null, "last_name": "SHELTON", "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": "UTI", "general_issue_code_display": "Utilities", "description": "Advocate for customer assistance for drinking water.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71758, "prefix": null, "prefix_display": null, "first_name": "REBECCA", "nickname": null, "middle_name": null, "last_name": "SHELTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} TN US   KY KY US US   0 0           10000.0

Links from other tables