lobbying_filings_raw: 710aa309-0d38-4a04-9f41-c7bb4cfd4eaf

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
710aa309-0d38-4a04-9f41-c7bb4cfd4eaf	Q4	35800	THE SMITH-FREE GROUP, LLC	144543	MASTERCARD WORLDWIDE	2016	fourth_quarter	2017-01-09T16:24:59-05:00	0	0	0	{"url": "https://lda.senate.gov/api/v1/filings/710aa309-0d38-4a04-9f41-c7bb4cfd4eaf/", "filing_uuid": "710aa309-0d38-4a04-9f41-c7bb4cfd4eaf", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2016, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/710aa309-0d38-4a04-9f41-c7bb4cfd4eaf/print/", "filing_document_content_type": "text/html", "income": "70000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Alicia W. Smith, Sr. VP & Corp. Secretary", "dt_posted": "2017-01-09T16:24:59-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "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": 144543, "url": "https://lda.senate.gov/api/v1/clients/144543/", "client_id": 90, "name": "MASTERCARD WORLDWIDE", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "NY", "state_display": "New York", "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-13"}, "lobbying_activities": [{"general_issue_code": "GAM", "general_issue_code_display": "Gaming/Gambling/Casino", "description": "Monitored H.R.707, Restoration of Americas Wire Act \nMonitored S.1668, Restoration of Americas Wire Act \nMonitored discussions involving Daily Fantasy Sports", "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}], "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": "Monitored H.R.1560, To improve cybersecurity in the United States through enhanced sharing of information about cybersecurity threats, and for other purposes (The Protecting Cyber Networks Act)\n\nMonitored H.R.1770, Data Security and Breach Notification Act of 2015 \nMonitored H.R.2205, Data Security Act of 2015 \nMonitored H.R.4528, ENCRYPT Act of 2016\nMonitored H.R.4651, Digital Security Commission Act of 2016 \nMonitored H.R.4663, No Taxpayer Support for Apple Act \nMonitored H.R.4839, Protect Our Devices Act of 2016 \nMonitored S.177, Data Security and Breach Notification Act of 2015 \nMonitored S.754, Cybersecurity Information Sharing Act of 2015 \nMonitored S.2604, Digital Security Commission Act of 2016", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61430, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "BARBOUR", "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": 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}, {"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": "BAN", "general_issue_code_display": "Banking", "description": "Discussions relating to EMV and liability shift\n\nMonitored H.R.5465, To repeal section 1075 of the Consumer Financial Protection Act of 2010 relating to rules for payment card transactions, and for other purposes.", "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}, {"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": 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": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "H.R.5983, Financial CHOICE Act of 2016 (All sections of full text)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61430, "prefix": null, "prefix_display": null, "first_name": "ANDREW", "nickname": null, "middle_name": null, "last_name": "BARBOUR", "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": 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}, {"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	NY		US	US		0	0					70000.0

Links from other tables

4 rows from filing_uuid in lobbying_activities
5 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs