home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 71a9d8d6-28d4-4a8e-a0b8-fb6069b56ef4

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
71a9d8d6-28d4-4a8e-a0b8-fb6069b56ef4 MM 78436 UBS AMERICAS INC. 170235 UBS AMERICAS INC 2007 mid_year 2007-07-25T14:53:31-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/71a9d8d6-28d4-4a8e-a0b8-fb6069b56ef4/", "filing_uuid": "71a9d8d6-28d4-4a8e-a0b8-fb6069b56ef4", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/71a9d8d6-28d4-4a8e-a0b8-fb6069b56ef4/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "340000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-07-25T14:53:31-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 78436, "url": "https://lda.senate.gov/api/v1/registrants/78436/", "house_registrant_id": 36329, "name": "UBS AMERICAS INC.", "description": null, "address_1": "1150 17th St. NW", "address_2": "5th Floor", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JOHN NOLAN", "contact_telephone": "+1 202-585-8986", "dt_updated": "2026-01-30T14:00:08.616462-05:00"}, "client": {"id": 170235, "url": "https://lda.senate.gov/api/v1/clients/170235/", "client_id": 12, "name": "UBS AMERICAS INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-25"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "\r\n(S 1624/ HR 2785 Continued)...adviser and related asset management services\";\n\n HR 2834, \"To amend the Internal Revenue Code of 1986 to treat income received by partners for performing investment management services as ordinary income received for the performance of services\" (Carried interest);\n\nHR 2/ S 2, Minimum Wage Legislation (tax titles);\n\nS 601/ HR 878, \"Simplification Through Additional Reporting Tax Act of 2007\" (Basis reporting);\n\nHR 2136/ S 681, \"Stop Tax Haven Abuse Act\" (including economic substance);\n\nHR 1672, \"To deny qualified dividend income treatment to certain foreign dividends\" (qualified dividend);\n\nHR 2470, \"America's Better Classroom Act of 2007\" (tax credit bonds).\n\n\r\nHR 556 ENR, \"Foreign Investment and National Security Act of 2007\"; Trade issues between the United States and Switzerland.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "\r\nAddressed proposed Treasury Reg. 133254-02 on reporting of deposit interest paid to non-resident aliens.\nHR 698, \" Industrial Bank Holding Company Act of 2007.\"\r\nHR 948, \"Social Security Number Protection Act,\" HR 958, \"Data Accountability and Trust Act,\"\nHR 3046, \"Social Security Number Privacy and Identity Theft Prevention Act,\"\nS 1260, \"Data Security Act of 2007,\" \n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "\r\nAddressed SEC with respect to implementation of rulemaking involving Rule 202 of the Investment Advisors Act;\nIssues relating to 401(k) Plan Fee Disclosures; Issues relating to hedge funds and private equity governance; Addressed SEC with respect to proposal to eliminate US GAAP Requirement.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nS 1624/ HR 2785, \"To amend the Internal Revenue Code of 1986 to provide that the exception from the treatment of publicly traded partnerships as corporations for partnerships with passive-type income shall not apply to partnerships directly or indirectly deriving income from providing investment...", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "\r\nHR 1427, \"Federal Housing Finance Reform Act;\"\n\nHR 3012, \"Fair Mortgage Practices Act of 2007;\"\n\nS 1299, \"Borrower's Protection Act;\"\n\nU.S. Sanctions policy- consulted with staff from Treasury, SEC and Capitol Hill regarding U.S. sanctions policy;\n\nHR 1527, \"Shareholder Vote Executive Compensation Act.\"\r\nS. 1348, \"Comprehensive Immigration Reform Act of 2007\"", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "\r\nS 190, \"To provide a technical correction to the Pension Protection Act of 2006.\"", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 18326, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": null, "last_name": "ROWAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 32185, "prefix": null, "prefix_display": null, "first_name": "WILLIAM", "nickname": null, "middle_name": "PHILIP", "last_name": "GRAMM", "suffix": null, "suffix_display": null}, "covered_position": "FORMER US SENATOR (R-TX)", "new": null}, {"lobbyist": {"id": 3437, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "SAVERCOOL", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 13200, "prefix": null, "prefix_display": null, "first_name": "JASON", "nickname": null, "middle_name": null, "last_name": "COLE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 36329 DC DC US US   0 0           340000.0

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.262ms · Privacy