home / lobbying / lobbying_filings_raw

lobbying_filings_raw: a6818f0f-6562-4096-9710-692df71cc662

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
a6818f0f-6562-4096-9710-692df71cc662 Q1 400901635 HUAWEI TECHNOLOGIES USA INC. 196076 HUAWEI TECHNOLOGIES USA INC. 2022 first_quarter 2022-04-12T15:36:58-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/a6818f0f-6562-4096-9710-692df71cc662/", "filing_uuid": "a6818f0f-6562-4096-9710-692df71cc662", "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/a6818f0f-6562-4096-9710-692df71cc662/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "756000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Jeff Hogg", "dt_posted": "2022-04-12T15:36:58-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "5700 Tennyson Parkway", "registrant_address_2": "Suite 600", "registrant_different_address": false, "registrant_city": "Plano", "registrant_state": "TX", "registrant_zip": "75024", "registrant": {"id": 400901635, "url": "https://lda.senate.gov/api/v1/registrants/400901635/", "house_registrant_id": null, "name": "HUAWEI TECHNOLOGIES USA INC.", "description": "Telecommunications networks and products", "address_1": "875 15th Street NW", "address_2": "Suite 825", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DENNIS J. AMARI", "contact_telephone": "+1 202-302-5043", "dt_updated": "2023-04-03T15:25:08.895754-04:00"}, "client": {"id": 196076, "url": "https://lda.senate.gov/api/v1/clients/196076/", "client_id": 12, "name": "HUAWEI TECHNOLOGIES USA INC.", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "TX", "state_display": "Texas", "country": "US", "country_display": "United States of America", "ppb_state": "TX", "ppb_state_display": "Texas", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2012-03-09"}, "lobbying_activities": [{"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "The Information Transparency and Personal Data Control Act (H.R. 1816); Issues related to privacy and data security. Leading Infrastructure For Tomorrows America Act (H.R. 1848); Issues related to privacy and data security. The Accessible, Affordable Internet for All Act (H.R. 1783; S. 745); Issues related to access to broadband internet and other telecommunication services. Secure Equipment Act (H.R. 3919); Monitoring implementation of Public Law No: 117-55 - funding for removal of equipment and services that pose a national security threat.", "foreign_entity_issues": "Huawei Technologies Co., Ltd. is an international telecommunications corporation with a U.S. presence that is engaged in business matters related to telecommunication services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Technologies Co., Ltd. has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace. Huawei Technologies Canada Co., Ltd. is an international telecommunications corporation that is engaged in business matters throughout North America related to telecommunications services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Canada has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace.", "lobbyists": [{"lobbyist": {"id": 98455, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "HOGG", "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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Innovation and Competition Act (S. 1260); Issues related to semiconductor manufacturing, research and development, and supply chain security.", "foreign_entity_issues": "Huawei Technologies Co., Ltd. is an international telecommunications corporation with a U.S. presence that is engaged in business matters related to telecommunication services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Technologies Co., Ltd. has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace. Huawei Technologies Canada Co., Ltd. is an international telecommunications corporation that is engaged in business matters throughout North America related to telecommunications services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Canada has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace.", "lobbyists": [{"lobbyist": {"id": 105513, "prefix": null, "prefix_display": null, "first_name": "BO", "nickname": null, "middle_name": null, "last_name": "PENG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 98455, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "HOGG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138273, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONALD", "nickname": null, "middle_name": "J.", "last_name": "MORRISSEY", "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": "SCI", "general_issue_code_display": "Science/Technology", "description": "Innovation and Competition Act (S. 1260); Issues related to semiconductor manufacturing, research and development, and supply chain security.", "foreign_entity_issues": "Huawei Technologies Co., Ltd. is an international telecommunications corporation with a U.S. presence that is engaged in business matters related to telecommunication services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Technologies Co., Ltd. has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace. Huawei Technologies Canada Co., Ltd. is an international telecommunications corporation that is engaged in business matters throughout North America related to telecommunications services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Canada has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace.", "lobbyists": [{"lobbyist": {"id": 98455, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "HOGG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 105513, "prefix": null, "prefix_display": null, "first_name": "BO", "nickname": null, "middle_name": null, "last_name": "PENG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138273, "prefix": "mr", "prefix_display": "MR.", "first_name": "DONALD", "nickname": null, "middle_name": "J.", "last_name": "MORRISSEY", "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": "DEF", "general_issue_code_display": "Defense", "description": "The National Defense Authorization Act (H.R. 4350); Issues related to funding for Science, Technology, Engineering, and Mathematics (STEM), Artificial Intelligence (AI), and Research & Development (R&D).", "foreign_entity_issues": "Huawei Technologies Co., Ltd. is an international telecommunications corporation with a U.S. presence that is engaged in business matters related to telecommunication services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Technologies Co., Ltd. has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace. Huawei Technologies Canada Co., Ltd. is an international telecommunications corporation that is engaged in business matters throughout North America related to telecommunications services, technical support, software, hardware, and cybersecurity. In undertaking such business matters, Huawei Canada has an interest in public policy issues related to the regulation of trade, commerce, science and technology in the U.S. marketplace.", "lobbyists": [{"lobbyist": {"id": 98455, "prefix": null, "prefix_display": null, "first_name": "JEFFREY", "nickname": null, "middle_name": null, "last_name": "HOGG", "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   TX TX US US   0 0           756000.0

Links from other tables

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