lobbying_filings_raw: 8e81f816-c5d6-49da-9ab5-f72c0cf01fd3

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
8e81f816-c5d6-49da-9ab5-f72c0cf01fd3 Q4 35800 THE SMITH-FREE GROUP, LLC 144601 AMERICAN DENTAL ASSOCIATION 2017 fourth_quarter 2018-01-18T16:40:34.950000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/8e81f816-c5d6-49da-9ab5-f72c0cf01fd3/", "filing_uuid": "8e81f816-c5d6-49da-9ab5-f72c0cf01fd3", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2017, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/8e81f816-c5d6-49da-9ab5-f72c0cf01fd3/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Alicia W. Smith, Sr. VP & Corp. Secretary", "dt_posted": "2018-01-18T16:40:34.950000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "1401 K Street NW Suite 1200", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 35800, "url": "https://lda.senate.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": 144601, "url": "https://lda.senate.gov/api/v1/clients/144601/", "client_id": 1001023, "name": "AMERICAN DENTAL ASSOCIATION", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "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": "2013-06-03"}, "lobbying_activities": [{"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "HR 372 Competitive Health Insurance Reform Act of 2017 (all sections of full text)(support)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 17533, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "FREE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 24818, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "HICKMOTT", "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": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "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": "Discussions pertaining to the cost of dental care in America\n\nHR 2422 Action for Dental Health Act of 2017 (all sections of full text)(support)\n\nHR 1606 DOC Access Act (all sections of full text)(support)\n\nDiscussions on efforts to revise regulatory barriers specifically impacting dentists and their patients \n\nMonitored HR 1628 American Health Care Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 17533, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "FREE", "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": 24818, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "HICKMOTT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "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}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Monitored issues relating to opioid prescriptions through Medicare programs", "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": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Discussions involving funding of alternative dental provider programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 17533, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": "C", "last_name": "FREE", "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": 24818, "prefix": null, "prefix_display": null, "first_name": "ROBERT", "nickname": null, "middle_name": null, "last_name": "HICKMOTT", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "P.L. 115-97 Tax Cuts and Jobs Act; issues involving taxation of pass-through entities", "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": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "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": "EDU", "general_issue_code_display": "Education", "description": "Discussions pertaining to financing of graduate-level education", "foreign_entity_issues": "", "lobbyists": [{"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": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "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": "IND", "general_issue_code_display": "Indian/Native American Affairs", "description": "Monitored HR 2662 Restoring Accountability in the Indian Health Service Act of 2017 \nMonitored S 1250 Restoring Accountability in the Indian Health Service Act of 2017 \nMonitored issues pertaining to streamlined credentialing process for volunteer dental providers", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61816, "prefix": null, "prefix_display": null, "first_name": "SUMMER", "nickname": null, "middle_name": null, "last_name": "MERSINGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30770 DC   US US   0 0         40000.0  

Links from other tables