home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 0b1a4f83-8f88-4fed-a8bb-1e1382f8de8c

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
0b1a4f83-8f88-4fed-a8bb-1e1382f8de8c Q2 38847 UNITED STATES TELECOM ASSN 147037 UNITED STATES TELECOM ASSN 2018 second_quarter 2018-07-15T10:51:19.040000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/0b1a4f83-8f88-4fed-a8bb-1e1382f8de8c/", "filing_uuid": "0b1a4f83-8f88-4fed-a8bb-1e1382f8de8c", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2018, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/0b1a4f83-8f88-4fed-a8bb-1e1382f8de8c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "480000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Galen Roehl", "dt_posted": "2018-07-15T10:51:19.040000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "601 New Jersey Ave., NW, Suite 600", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 38847, "url": "https://lda.senate.gov/api/v1/registrants/38847/", "house_registrant_id": 30703, "name": "UNITED STATES TELECOM ASSN", "description": null, "address_1": "601 New Jersey Avenue, NW", "address_2": "Suite 600", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "2000", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BRANDON HEINER", "contact_telephone": "+1 202-326-7300", "dt_updated": "2026-02-05T18:41:50.815381-05:00"}, "client": {"id": 147037, "url": "https://lda.senate.gov/api/v1/clients/147037/", "client_id": 12, "name": "UNITED STATES TELECOM ASSN", "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-08-14"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to broadband infrastructure (House and Senate)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42938, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARC", "nickname": null, "middle_name": "C", "last_name": "GONZALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60322, "prefix": null, "prefix_display": null, "first_name": "GALEN", "nickname": null, "middle_name": null, "last_name": "ROEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66392, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "PEDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67512, "prefix": null, "prefix_display": null, "first_name": "HAWLEY", "nickname": null, "middle_name": null, "last_name": "STANTON", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Correspondent, U.S. Rep. Robert E. Latta (2014-2017)", "new": false}, {"lobbyist": {"id": 68260, "prefix": null, "prefix_display": null, "first_name": "KELLY", "nickname": null, "middle_name": null, "last_name": "MISSELWITZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Sen. Jeanne Shaheen (2015-2018)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TEC", "general_issue_code_display": "Telecommunications", "description": "H.R. 288, Small Business Broadband Deployment Act\nH.R. 290, Federal Communications Commission Process Reform Act of 2017\nH.R. 460, Improving Rural Call Quality and Reliability Act of 2017\nH.R. 557, FCC \"ABCs\" Act of 2017 \nH.R. 588, Securing Access to Networks in Disasters Act\nH.R. 599, Federal Communications Commission Consolidated Reporting Act of 2017 \nH.R. 1300, U.S. Call Center Worker and Consumer Protection Act of 2017\nH.R. 1324, Securing IoT Act of 2017\nH.R. 1335, Cybersecurity Responsibility Act of 2017\nH.R. 1340, Interagency Cybersecurity Cooperation Act\nH.R. 1534, To establish a program that provides dislocated workers with a subsidy or coupon that may be applied towards obtaining broadband Internet access service, and for other purposes. \nH.R. 1546, To direct the Federal Communications Commission to establish a methodology for the collection by the Commission of mobile service coverage data.\nH.R. 1576, To direct the Secretary of Commerce to establish a job-training grant program for workers displaced by automation and to establish an Innovation Corps to enable recent college graduates to volunteer in job-training programs for workers displaced by automation, and for other purposes.\nH.R. 1581, To amend the Communications Act of 1934 to add access to telecommunications and information services in Indian country and areas with high populations of Indian people to the universal service principle relating to access to such services in rural, insular, and high cost areas.\nH.R. 1591, To direct the Federal Communications Commission to adopt rules and conduct outreach to offer recipients of assistance under the Lifeline Assistance Program mobile devices that are capable of receiving a WiFi signal and are capable of tethering with other WiFi compatible hardware or devices, and for other purposes.\nH.R. 2520, Browser Act of 2017\nH.R. 3994, the ACCESS BROADBAND Act\nH.R. 4747, Defending U.S. Government Communications Act\nH.R. 4795, Communications Facilities Deployment on Federal Property Act of 2018\nH.R. 4798, Inventory of Assets for Communications Facilities Act of 2018 \nH.R. 4810, Making Available Plans to Promote Investment in Next Generation Networks without Overbuilding and Waste Act\nH.R. 4817, Promoting Exchanges for Enhanced Routing of Information so Networks are Great Act\nH.R. 4842, The Streamlining Permitting to Enable Efficient Deployment of Broadband Infrastructure\nH.R. 4881, Precision Agriculture Connectivity Act\nH.J.Res.86 - Providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Communications Commission relating to \"Protecting the Privacy of Customers of Broadband and Other Telecommunications Services\".\n\nS. 19, MOBILE NOW Act\nS. 96, Improving Rural Call Quality and Reliability Act of 2017\nS. 102, Securing Access to Networks in Disasters Act of 2017 \nS. 134, Spoofing Prevention Act of 2017\nS. 174, Federal Communications Commission Consolidated Reporting Act of 2017\nS. 228, Small Business Broadband Deployment Act of 2017\nS. 277, Rural Telecommunications and Broadband Service Act of 2017\nS. 604, Highway Rights-of-Way Permitting Efficiency Act of 2017\nS. 624, A bill to allow servicemembers to terminate their cable, satellite television, and Internet access service contracts while deployed.\nS. 1013, Gigabit Opportunity Act of 2017\nS. 1693, Stop Enabling Sex Traffickers Act of 2017\nS. 2343, Precision Agriculture Connectivity Act\nS.J.Res.34, A joint resolution providing for congressional disapproval under chapter 8 of title 5, United States Code, of the rule submitted by the Federal Communications Commission relating to \"Protecting the Privacy of Customers of Broadband and Other Telecommunications Services\". \nIssues related to net neutrality (House and Senate)\nIssues related to oversight of the Federal Communications Commission (House and Senate)\nIssues related to privacy (House and Senate)\nIssues related to the privacy CRA (House and Senate)\nIssues related to cybersecurity (House and Senate)\nIssues related to robocalling (House and Senate)\nIssues related to broadband infrastructure (House and Senate)\nIssues related to broadband deployment (House and Senate)\nIssues related to the Internet of Things (IoT) (House and Senate)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42938, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARC", "nickname": null, "middle_name": "C", "last_name": "GONZALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60322, "prefix": null, "prefix_display": null, "first_name": "GALEN", "nickname": null, "middle_name": null, "last_name": "ROEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66392, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "PEDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67512, "prefix": null, "prefix_display": null, "first_name": "HAWLEY", "nickname": null, "middle_name": null, "last_name": "STANTON", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Correspondent, U.S. Rep. Robert E. Latta (2014-2017)", "new": false}, {"lobbyist": {"id": 68260, "prefix": null, "prefix_display": null, "first_name": "KELLY", "nickname": null, "middle_name": null, "last_name": "MISSELWITZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Sen. Jeanne Shaheen (2015-2018)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Issues related to patent reform (House and Senate)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 42938, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARC", "nickname": null, "middle_name": "C", "last_name": "GONZALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60322, "prefix": null, "prefix_display": null, "first_name": "GALEN", "nickname": null, "middle_name": null, "last_name": "ROEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66392, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "PEDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67512, "prefix": null, "prefix_display": null, "first_name": "HAWLEY", "nickname": null, "middle_name": null, "last_name": "STANTON", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Correspondent, U.S. Rep. Robert E. Latta (2014-2017)", "new": false}, {"lobbyist": {"id": 68260, "prefix": null, "prefix_display": null, "first_name": "KELLY", "nickname": null, "middle_name": null, "last_name": "MISSELWITZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Sen. Jeanne Shaheen (2015-2018)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "Issues related to video and communications (House and Senate)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 68260, "prefix": null, "prefix_display": null, "first_name": "KELLY", "nickname": null, "middle_name": null, "last_name": "MISSELWITZ", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Assistant, U.S. Sen. Jeanne Shaheen (2015-2018)", "new": false}, {"lobbyist": {"id": 42938, "prefix": "mr", "prefix_display": "MR.", "first_name": "MARC", "nickname": null, "middle_name": "C", "last_name": "GONZALES", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 60322, "prefix": null, "prefix_display": null, "first_name": "GALEN", "nickname": null, "middle_name": null, "last_name": "ROEHL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66392, "prefix": null, "prefix_display": null, "first_name": "JEREMY", "nickname": null, "middle_name": null, "last_name": "PEDERSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67512, "prefix": null, "prefix_display": null, "first_name": "HAWLEY", "nickname": null, "middle_name": null, "last_name": "STANTON", "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 30703 DC DC US US   0 0           480000.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
Powered by Datasette · Queries took 0.555ms · Privacy