home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 2b8a118a-00ec-4e7b-bfd3-4334fcdc71d9

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
2b8a118a-00ec-4e7b-bfd3-4334fcdc71d9 Q2 401105575 TAIWAN SEMICONDUCTOR MANUFACTURING COMPANY (TSMC) 205733 TAIWAN SEMICONDUCTOR MANUFACTURING COMPANY (TSMC) 2023 second_quarter 2023-07-20T10:30:39-04:00 770000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/2b8a118a-00ec-4e7b-bfd3-4334fcdc71d9/", "filing_uuid": "2b8a118a-00ec-4e7b-bfd3-4334fcdc71d9", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2023, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/2b8a118a-00ec-4e7b-bfd3-4334fcdc71d9/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "770000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Peter Cleveland", "dt_posted": "2023-07-20T10:30:39-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "700 K Street, NW Suite 610", "registrant_address_2": null, "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 401105575, "url": "https://lda.senate.gov/api/v1/registrants/401105575/", "house_registrant_id": null, "name": "TAIWAN SEMICONDUCTOR MANUFACTURING COMPANY (TSMC)", "description": "Semiconductor manufacturing", "address_1": "700 K Street, NW Suite 610", "address_2": null, "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": "PETER CLEVELAND", "contact_telephone": "+1 202-309-0914", "dt_updated": "2026-01-20T11:58:39.141381-05:00"}, "client": {"id": 205733, "url": "https://lda.senate.gov/api/v1/clients/205733/", "client_id": 12, "name": "TAIWAN SEMICONDUCTOR MANUFACTURING COMPANY (TSMC)", "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": "2020-01-01"}, "lobbying_activities": [{"general_issue_code": "ECN", "general_issue_code_display": "Economics/Economic Development", "description": "HR4346 - CHIPS & Science Act Department of Commerce - Export Administration Regulations - changes to Entity List and other amendments Department of Commerce and USTR - Indo-Pacific Economic Framework Department of Commerce and USTR - World Trade Organization Department of Commerce and USTR - 21st Century Trade Initiative with Taiwan Department of Commerce and USTR - US-EU Trade & Technology Council", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 144894, "prefix": "ms", "prefix_display": "MS.", "first_name": "CLAIRE", "nickname": null, "middle_name": "SANDERSON", "last_name": "HAMBRICK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138131, "prefix": "mr", "prefix_display": "MR.", "first_name": "PETER", "nickname": null, "middle_name": "MATTHEWS", "last_name": "CLEVELAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 74546, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "MONTELLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143414, "prefix": null, "prefix_display": null, "first_name": "STEFANIE", "nickname": null, "middle_name": null, "last_name": "DEARIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR 4346 - CHIPS & Science Act Discussions with congressional staff on global tax issues and a US-Taiwan tax treaty. Discussions with Treasury officials on implementation of 25% investment tax credit for advanced semiconductor manufacturing", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138131, "prefix": "mr", "prefix_display": "MR.", "first_name": "PETER", "nickname": null, "middle_name": "MATTHEWS", "last_name": "CLEVELAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 74546, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "MONTELLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143414, "prefix": null, "prefix_display": null, "first_name": "STEFANIE", "nickname": null, "middle_name": null, "last_name": "DEARIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144894, "prefix": "ms", "prefix_display": "MS.", "first_name": "CLAIRE", "nickname": null, "middle_name": "SANDERSON", "last_name": "HAMBRICK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Discussions with the Department of Commerce Bureau of Information Security on changes to the \"Entity List\" and other amendments to the Export Administration Regulations (85 Fed. Reg. 23460). Discussions related to the Department of Commerce, the National Institute of Standards and Technology regarding the planning and design of programs to implement the CHIPS for America Act. Discussions with the Department of Commerce and the United States Trade Representative regarding the United States and European Union Trade & Technology Council, the proposed Indo-Pacific Economic Framework, the World Trade Organization, and the 21st Century Trade Initiative with Taiwan.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138131, "prefix": "mr", "prefix_display": "MR.", "first_name": "PETER", "nickname": null, "middle_name": "MATTHEWS", "last_name": "CLEVELAND", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 74546, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "MONTELLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144894, "prefix": "ms", "prefix_display": "MS.", "first_name": "CLAIRE", "nickname": null, "middle_name": "SANDERSON", "last_name": "HAMBRICK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "IMM", "general_issue_code_display": "Immigration", "description": "Discussions related to general manufacturing workforce development issues, including high skilled immigration reform, talent pipeline programs,and education needs for advanced semiconductor manufacturers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 74546, "prefix": null, "prefix_display": null, "first_name": "NICHOLAS", "nickname": null, "middle_name": null, "last_name": "MONTELLA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144894, "prefix": "ms", "prefix_display": "MS.", "first_name": "CLAIRE", "nickname": null, "middle_name": "SANDERSON", "last_name": "HAMBRICK", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CHM", "general_issue_code_display": "Chemicals/Chemical Industry", "description": "Discussions on policy changes affecting the use of certain chemicals in the semiconductor manufacturing process.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 144894, "prefix": "ms", "prefix_display": "MS.", "first_name": "CLAIRE", "nickname": null, "middle_name": "SANDERSON", "last_name": "HAMBRICK", "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": []}

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 17.372ms