lobbying_filings_raw: f8ee48d7-5fff-4f1f-9d84-386916c5c5cd

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
f8ee48d7-5fff-4f1f-9d84-386916c5c5cd Q1 13882 ETKA CONSULTING 119405 RURAL ADVANCEMENT FOUND INTL-USA ON BEHALF OF CAMPAIGN FOR CONTRACT AG REFORM 2022 first_quarter 2022-04-12T14:38:16-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f8ee48d7-5fff-4f1f-9d84-386916c5c5cd/", "filing_uuid": "f8ee48d7-5fff-4f1f-9d84-386916c5c5cd", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f8ee48d7-5fff-4f1f-9d84-386916c5c5cd/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "STEVEN D. ETKA", "dt_posted": "2022-04-12T14:38:16-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1301 Hancock Avenue", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Alexandria", "registrant_state": "VA", "registrant_zip": "22301", "registrant": {"id": 13882, "url": "https://lda.senate.gov/api/v1/registrants/13882/", "house_registrant_id": 33841, "name": "ETKA CONSULTING", "description": "lobbying firm", "address_1": "1301 Hancock Avenue", "address_2": null, "address_3": null, "address_4": null, "city": "Alexandria", "state": "VA", "state_display": "Virginia", "zip": "22301", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "STEVEN D. ETKA", "contact_telephone": "+1 703-519-7772", "dt_updated": "2026-01-29T17:54:14.178008-05:00"}, "client": {"id": 119405, "url": "https://lda.senate.gov/api/v1/clients/119405/", "client_id": 51, "name": "RURAL ADVANCEMENT FOUND INTL-USA ON BEHALF OF CAMPAIGN FOR CONTRACT AG REFORM", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "NC", "state_display": "North Carolina", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-15"}, "lobbying_activities": [{"general_issue_code": "AGR", "general_issue_code_display": "Agriculture", "description": "Packers and Stockyards Act regulations Justice for Black Farmers (S. 300 and H.R. 1393) Coronavirus Food Assistance Program (contract grower provisions) Pandemic Assistance for Farmers Farm Service Agency guaranteed lending for livestock and poultry", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46862, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "D", "last_name": "ETKA", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "American Rescue Plan Act of 2021 (Pandemic relief bill), H.R. 1319, implementation Fiscal Year 2023 Agriculture Appropriations bills (House and Senate)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46862, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "D", "last_name": "ETKA", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Competition and Antitrust Law Enforcement Reform Act (S. 225) merger moratorium legislation for large food and agriculture mergers opposition to pending mergers in the poultry sector", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46862, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "D", "last_name": "ETKA", "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": 37, "name": "Justice, Dept of (DOJ)"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SMB", "general_issue_code_display": "Small Business", "description": "Reform of Small Business Administration 7(a) loan guarantee program for poultry", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 46862, "prefix": "mr", "prefix_display": "MR.", "first_name": "STEVEN", "nickname": null, "middle_name": "D", "last_name": "ETKA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 23, "name": "Agriculture, Dept of (USDA)"}, {"id": 255, "name": "Consumer Financial Protection Bureau (CFPB)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 90, "name": "Small Business Administration (SBA)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} VA US 33841 NC   US US   0 0         10000.0  

Links from other tables