home / lobbying

lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

12,274 rows where filing_period = "fourth_quarter" and issue_code = "TEC" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

filing_year 18

  • 2021 876
  • 2019 821
  • 2020 807
  • 2022 807
  • 2023 758
  • 2018 738
  • 2024 726
  • 2025 707
  • 2017 679
  • 2011 650
  • 2009 621
  • 2015 605
  • 2016 596
  • 2008 595
  • 2010 580
  • 2014 576
  • 2012 571
  • 2013 561

issue_code 1

  • TEC · 12,274 ✖

filing_period 1

  • fourth_quarter · 12,274 ✖
id filing_uuid filing_type registrant_name registrant_id client_name filing_year ▲ filing_period issue_code specific_issues government_entities income_amount expense_amount is_no_activity is_termination received_date
3476723 MEHLMAN CONSULTING, INC. 6cedd90e-4569-48eb-ad3b-cb1f454f792e 4T MEHLMAN CONSULTING, INC. 284950 DISH NETWORK, LLC 2025 fourth_quarter TEC Monitor legislation and regulations related to the wireless industry, including wireless technologies, spectrum management, infrastructure, broadband funding, and competition. Policies to promote 5G deployment based on technologies leveraging Open RAN standards. HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2025-12-16T11:01:47-05:00
3477102 LOBBYIT.COM 8c7e37cd-62b6-428d-9ac8-d193f2b06d97 Q4 LOBBYIT.COM 400487397 AMERICAN CASE MANAGEMENT ASSOCIATION 2025 fourth_quarter TEC N/A Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-12-22T09:22:37-05:00
3477107 LOBBYIT.COM ac23cdf2-add3-4072-8bdc-328ac7440607 Q4 LOBBYIT.COM 400487397 SMALL COMPANY COALITION 2025 fourth_quarter TEC N/A HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-12-22T09:29:42-05:00
3477313 MEHLMAN CONSULTING, INC. cd089b71-0c9d-4e53-b503-ae85e3eeaca7 4T MEHLMAN CONSULTING, INC. 284950 NETFLIX, INC. 2025 fourth_quarter TEC Issues related to media and telecommunications. Federal data privacy. Educational outreach. Broadband. HOUSE OF REPRESENTATIVES,SENATE 50000   0 1 2025-12-23T12:12:36-05:00
3477441 DUNKEL GOVERNMENT RELATIONS b360b505-ad39-4333-a20a-52b9aa8b3ac0 Q4 DUNKEL GOVERNMENT RELATIONS 304337 DISH NETWORK LLC 2025 fourth_quarter TEC Satellite Issues. Wireless Issues. Video Issues. HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2025-12-30T12:27:18-05:00
3477442 DUNKEL GOVERNMENT RELATIONS 8b9c00e2-3bc6-4666-bac3-b0011c209bd9 Q4 DUNKEL GOVERNMENT RELATIONS 304337 LUMEN TECHNOLOGIES FORMERLY CENTURYLINK 2025 fourth_quarter TEC Broadband Deployment Issues. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-12-30T12:28:55-05:00
3477446 DUNKEL GOVERNMENT RELATIONS 966e6264-b7eb-44df-ae2d-13f8594a997e Q4 DUNKEL GOVERNMENT RELATIONS 304337 UNITED STATES TELECOM ASSOCIATION 2025 fourth_quarter TEC Privacy Issues. Cybersecurity Issues. Broadband Deployment. Universal Service Issues. HOUSE OF REPRESENTATIVES,SENATE 22500   0 0 2025-12-30T12:33:48-05:00
3477447 DUNKEL GOVERNMENT RELATIONS b77c86d9-58bf-49c7-bd9f-0852b5d0fa18 Q4 DUNKEL GOVERNMENT RELATIONS 304337 AT&T SERVICES INC 2025 fourth_quarter TEC Spectrum Issues. Wireless Issues. Privacy Issues. Broadband Issues. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-12-30T12:34:40-05:00
3477571 NORTHFORK STRATEGIES fd2fb88b-9c8d-4c51-bf80-c3f18601180f Q4 NORTHFORK STRATEGIES 400508502 IDEATEK TELCOM 2025 fourth_quarter TEC Broadband Infrastructure. IP Interconnection. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE 10000   0 0 2026-01-01T15:45:56-05:00
3477573 NORTHFORK STRATEGIES 26ed7b97-7ac0-490e-be9d-506d1bf98c4c 4T NORTHFORK STRATEGIES 400508502 ZAYO GROUP, LLC 2025 fourth_quarter TEC Telecommunication Issues. IP Interconnection Issues. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE     0 1 2026-01-01T15:46:42-05:00
3477664 RYAN COSTELLO STRATEGIES 0ecb338b-7c89-43a0-adb2-a9c012d4f44a Q4 RYAN COSTELLO STRATEGIES 401105569 T-MOBILE USA, INC. 2025 fourth_quarter TEC review relevant telecommunications legislative proposals; monitor telecommunications cybsersecurity legislation; outreach to legislative offices on House letter to NTIA regarding BEAD program; monitor relevant congressional hearings on telecommunications policy, including public safety, BEAD and cybersecurity matters. HOUSE OF REPRESENTATIVES 40000   0 0 2026-01-02T10:51:13-05:00
3477671 RYAN COSTELLO STRATEGIES 58350409-ad84-4221-99e7-6f29765bcc0b Q4 RYAN COSTELLO STRATEGIES 401105569 COGECO U.S. FINANCE, LLC D/B/A BREEZELINE 2025 fourth_quarter TEC Advocate for reforms to Broadband Equity, Access and Development Program Act contained within permitting reform legislative package, specifically relating to permitting reforms and pole attachment concerns; advocate against inclusion of Retaliatory Tax. Monitor relevant legislation relating to telecommunications/cable/internet industry. HOUSE OF REPRESENTATIVES 30000   0 0 2026-01-02T10:58:35-05:00
3477696 MARSHALL BRACHMAN d2f8d0df-fc17-4b84-ad6a-57a9746b9760 Q4 MARSHALL BRACHMAN 6848 ENCOURA (FORMERLY NAT'L RESEARCH CTR FOR COLLEGE AND UNIVERSITY ADMISSIONS) 2025 fourth_quarter TEC monitor legislation regarding internet privacy and COPPA HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-02T11:54:13-05:00
3477736 GALLANT GOVERNMENT & LAW GROUP, LLC 65e3dc24-38b0-4578-9b6f-9e90417bbf8e Q4 GALLANT GOVERNMENT & LAW GROUP, LLC 401104782 8X8, INC. 2025 fourth_quarter TEC Issues pertaining to Universal Service Fund (USF) reform. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-02T12:41:56-05:00
3477794 SUMMIT STRATEGIES GOVERNMENT AFFAIRS LLC a569d649-beaa-4b0d-ac75-e7e2e6f39353 Q4 SUMMIT STRATEGIES GOVERNMENT AFFAIRS LLC 401103550 NATIONAL UTILITY CONTRACTORS ASSOCIATION (NUCA) 2025 fourth_quarter TEC Broadband Equity, Access, and Deployment Program (BEAD) HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-02T15:30:32-05:00
3477892 DS2 GROUP, LLC 0ff1b239-4da2-4e95-bf62-8a68362dd221 Q4 DS2 GROUP, LLC 400694066 UTILITIES TECHNOLOGY COUNCIL 2025 fourth_quarter TEC spectrum issues; rural broad band infrastructure; cyber security; Homeland security appropriations HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-03T22:54:52-05:00
3477935 THE PETRIZZO GROUP, INC. bb5ff032-956e-49c8-9ebc-844c0348ff12 Q4 THE PETRIZZO GROUP, INC. 305932 ROKU, INC. 2025 fourth_quarter TEC Issues related to the technology industry, including competition in the digital and streaming marketplaces. Issues related to privacy legislation. Issues related to potential copyright legislation. Issues related to telecommunications policy. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-01-04T19:38:39-05:00
3478073 MCDERMOTT+ LLC 6c302c69-2a4c-431f-9fcc-f67e071099a1 Q4 MCDERMOTT+ LLC 401103287 THE PARTNERSHIP TO ADVANCE VIRTUAL CARE (PAVC) 2025 fourth_quarter TEC Efforts relating to expanded access to virtual care services. Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-05T11:36:31-05:00
3478516 CARPENTER STRATEGIC CONSULTING LLC 33c64838-8e9b-46a1-a53a-ab5f8c11b788 Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 ZIXI LLC 2025 fourth_quarter TEC Spectrum policy and issues related to repurposing the Upper C-Band (3.98-4.2 GHz) Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-06T10:30:31-05:00
3478521 CARPENTER STRATEGIC CONSULTING LLC c0ce3e51-f915-4ebc-bef7-692a28b7292f Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 PDV WIRELESS (NOW DBA ANTERIX) 2025 fourth_quarter TEC Issues related to spectrum policy and the deployment of broadband service in the 900 MHz band Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-01-06T10:32:59-05:00
3478527 CORNERSTONE GOVERNMENT AFFAIRS, INC. ea6c584e-dd57-4ab3-bf16-82a9cbccd5d9 Q4 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 LUMEN TECHNOLOGIES 2025 fourth_quarter TEC Issues related to cybersecurity, Connect America Fund funding, universal service, business data services, and supply chain management. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-06T10:34:51-05:00
3478648 CARPENTER STRATEGIC CONSULTING LLC 40098424-77c2-492e-892d-bbda6b4ea72a Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 MOSAIK SOLUTIONS LLC (NOW DBA OOKLA) 2025 fourth_quarter TEC Matters related to implementation of the Broadband DATA Act (PL 116-130) Issues related to broadband mapping and data collection Issues regarding implementation of the Infrastructure Investment and Jobs Act (PL 117-58, Division F, related to broadband deployment) Issues regarding implementation of the American Rescue Plan Act (PL 117-2, Subtitle M, Capital Projects Fund) Issues related to legislation to create a national framework for privacy policy Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE 10000   0 0 2026-01-06T11:51:44-05:00
3478667 D&P CREATIVE STRATEGIES, LLC c7249bef-2471-4242-b3d3-d64d34cc7609 Q4 D&P CREATIVE STRATEGIES, LLC 304554 COMCAST CORPORATION 2025 fourth_quarter TEC Net Neutrality, Broadband, Privacy, Wireless, Spectrum, BEAD HOUSE OF REPRESENTATIVES 20000   0 0 2026-01-06T12:02:12-05:00
3478701 D&P CREATIVE STRATEGIES, LLC 6a3c1189-5a9a-4df1-99fe-87dff69d022b Q4 D&P CREATIVE STRATEGIES, LLC 304554 MICROSOFT CORPORATION 2025 fourth_quarter TEC ECPA, CS for All, STEM, TV White Spaces, Airband, Rural Broadband HOUSE OF REPRESENTATIVES 50000   0 0 2026-01-06T12:27:13-05:00
3478724 GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS fdcf2e0f-4dcc-498c-8f1c-a827d75ec41a 4T GORDON THOMAS HONEYWELL GOVERNMENTAL AFFAIRS 314738 SNOHOMISH COUNTY COUNCIL 2025 fourth_quarter TEC telecommunications HOUSE OF REPRESENTATIVES,SENATE 20000   0 1 2026-01-06T13:15:45-05:00
3479018 AND PARTNERS LLC bdf830d6-53ae-4dfa-b9a6-86319c3277a4 Q4 AND PARTNERS LLC 401106757 TIKTOK INC. 2025 fourth_quarter TEC Issues related to internet technology and regulation of content platforms SENATE 60000   0 0 2026-01-07T10:00:41-05:00
3479084 CORNERSTONE GOVERNMENT AFFAIRS, INC. ff5204c4-ea25-40a4-9f10-2752df4b5d9f Q4 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 GREAT CITY MISSISSIPPI FOUNDATION 2025 fourth_quarter TEC Policies that expand workforce development in support of AI economy. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2026-01-07T11:25:21-05:00
3479327 PERSPECTIVE STRATEGIES 8706d70a-3fba-4990-ba12-b16fed94e67b Q4 PERSPECTIVE STRATEGIES 401106802 INTERDIGITAL 2025 fourth_quarter TEC Patent infringement HOUSE OF REPRESENTATIVES,SENATE,White House Office 30000   0 0 2026-01-07T17:33:38-05:00
3479584 VERSA GOVERNMENTAL STRATEGIES, LLC a37fc356-3101-4642-919e-c834c33e6f08 Q4 VERSA GOVERNMENTAL STRATEGIES, LLC 401110047 REDBIRD NETWORK, LLC 2025 fourth_quarter TEC Matters related to the Broadband Equity, Access, and Deployment (BEAD) Program administered by the Department of Commerce. SENATE     0 0 2026-01-08T12:48:41-05:00
3479610 MANATOS & MANATOS b14e8134-90e8-436c-a7fa-a394b235c67d Q4 MANATOS & MANATOS 23634 AMERICAN NETWORK SOLUTIONS 2025 fourth_quarter TEC US telecommunications and trade HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-08T13:05:26-05:00
3479650 HALL, RENDER, KILLIAN, HEATH & LYMAN, P.C. 36bd2ac7-251a-4e63-99ff-aa2da2425dfb Q4 HALL, RENDER, KILLIAN, HEATH & LYMAN, P.C. 17352 NINESTAR CONNECT 2025 fourth_quarter TEC Utility expansion and reform; rural broadband funding. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2026-01-08T13:25:26-05:00
3479658 I STREET ADVOCATES 7464e4ab-f146-4c19-b663-286a3fbdeff4 Q4 I STREET ADVOCATES 51753 COMMUNICATIONS WORKERS OF AMERICA 2025 fourth_quarter TEC anti-trust reform; support for tax credits for local journalists HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2026-01-08T13:28:19-05:00
3479663 I STREET ADVOCATES edefb907-dcca-4550-846f-769eb247d2a2 Q4 I STREET ADVOCATES 51753 ENTERTAINMENT STUDIOS NETWORKS INC 2025 fourth_quarter TEC Independent Programmer Policy Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-08T13:29:14-05:00
3479665 I STREET ADVOCATES 4b62cbb2-336e-45e8-8bef-6014860ee4d9 Q4 I STREET ADVOCATES 51753 WEATHER GROUP TELEVISION, LLC D/B/A THE WEATHER CHANNEL 2025 fourth_quarter TEC Independent programmer policy HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-08T13:30:00-05:00
3479669 I STREET ADVOCATES a90dc95d-e2fb-480a-a8bb-0b90881baf28 Q4 I STREET ADVOCATES 51753 PAYPAL 2025 fourth_quarter TEC internet competition policy HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-08T13:30:46-05:00
3479718 CORNERSTONE GOVERNMENT AFFAIRS, INC. 8d014e99-f1ef-4cbc-b3c7-51cec5af425c Q4 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 C SPIRE 2025 fourth_quarter TEC H.R. 5166, S. 3290 FY 26 Financial Services, General Government Appropriations. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-08T14:01:17-05:00
3479830 MONSTER WORLDWIDE d2655aed-2833-47da-9f80-0bb53a3b8406 Q4 MONSTER WORLDWIDE 299310 MONSTER WORLDWIDE 2025 fourth_quarter TEC Internet access HOUSE OF REPRESENTATIVES,SENATE   25000 0 0 2026-01-08T15:38:27-05:00
3479844 CARPENTER STRATEGIC CONSULTING LLC 7c7abf16-2b81-4e3f-939a-2fc11d8221e2 Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 WIRELESS INFRASTRUCTURE ASSOCIATION 2025 fourth_quarter TEC Issues related to the deployment of wireless broadband infrastructure HR 2289, the American Broadband Deployment Act HR 1343, the Federal Broadband Deployment Tracking Act HR 1588, the Facilitating DIGITAL Applications Act HR 1665, the DIGITAL Applications Act HR 1681, the Expediting Federal Broadband Deployment Act HR 1731, the Standard FEES Act Issues related to telecommunications apprenticeships and workforce training Implementation of the Infrastructure Investment and Jobs Act (PL 117-58, Division F, relating to broadband deployment) Issues related to the reauthorization of spectrum auction authority for the Federal Communications Commission HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-08T15:45:58-05:00
3479904 RSM US LLP (FORMERLY KNOWN AS MCGLADREY LLP) 06f2ea3a-620f-4ab0-937b-5d4421da2749 Q4 RSM US LLP (FORMERLY KNOWN AS MCGLADREY LLP) 401103642 RSM US LLP (FORMERLY KNOWN AS MCGLADREY LLP) 2025 fourth_quarter TEC BEAD implementation & use of non-deployment dollars: 1. RECAPTURE Act - S.3259 by Ernst, Cruz, Lee - would pull back $21 billion in BEAD program funds targeted for non-deployment uses. 2. SUCCESS for BEAD Act - S.3565 by Wicker & Capito - would authorize states to use remaining BEAD funding for specific purposes that enhance public safety, improve resiliency, strength national security, and develop a qualified workforce for emerging technologies. HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2026-01-08T16:49:28-05:00
3480049 TELNYX LLC a592be67-7cd6-48a9-b690-e1cc1591c7c2 Q4 TELNYX LLC 401109286 TELNYX LLC 2025 fourth_quarter TEC We do not generally advocate for the passage of specific bills, we advocate on policy principles, including a free and open environment for the development of AI innovation, a fairer telecommunications ecosystem, and anti-fraud measures within VoIP and carrier systems. HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-09T09:42:10-05:00
3480056 CARPENTER STRATEGIC CONSULTING LLC e1ab8556-29ca-4036-a3da-58c70e19fe7d Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 CTIA 2025 fourth_quarter TEC Issues related to spectrum policy and the importance of American leadership in 5G for the US economy and competitiveness Implementation of PL 119-21, the One Big Beautiful Bill Act, specifically provisions relating to spectrum auction authority H.R. 2350, the Cellphone Jamming Reform Act H.R. 3577, the END CELLS Act Issues related to permitting reform and the deployment of wireless telecommunications networks HR 2289. the American Broadband Deployment Act HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-01-09T10:23:33-05:00
3480066 CARPENTER STRATEGIC CONSULTING LLC 37644801-dd2c-4a11-a0c6-e5771214fc46 Q4 CARPENTER STRATEGIC CONSULTING LLC 401104143 AT&T SERVICES INC. 2025 fourth_quarter TEC Issues related oversight and licensing of the FirstNet Authority Issues related to spectrum policy and spectrum auction authority Implementation of PL 119-21, the One Big Beautiful Bill Act, specifically provisions relating to spectrum auction authority Issues related to permitting reform and the deployment of wireless telecommunications networks HR 2289. the American Broadband Deployment Act HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-09T10:27:41-05:00
3480081 THE O TEAM LLC d18511a3-03e5-495a-b8bc-f40025ab1f83 Q4 THE O TEAM LLC 400783359 K-LOVE 2025 fourth_quarter TEC Spectrum Issues. Music Licensing Issues. Religious Freedom Issues. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-09T10:44:16-05:00
3480094 SQUIRE PATTON BOGGS 06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15 Q4 SQUIRE PATTON BOGGS 30906 AMERICA'S POISON CENTERS (APC) 2025 fourth_quarter TEC Issues related to the improper routing of calls to poison centers. Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-01-09T10:57:50-05:00
3480271 COUNCIL FOR CITIZENS AGAINST GOVERNMENT WASTE be5d7865-8f35-4644-b735-ea392e269529 Q4 COUNCIL FOR CITIZENS AGAINST GOVERNMENT WASTE 11003 COUNCIL FOR CITIZENS AGAINST GOVERNMENT WASTE 2025 fourth_quarter TEC Support S.J.Res. 7 HOUSE OF REPRESENTATIVES   20000 0 0 2026-01-09T15:41:51-05:00
3480365 GORMAN STRATEGY GROUP, TOO 9c44397a-b2a1-46a8-b864-d7efe8f1949e Q4 GORMAN STRATEGY GROUP, TOO 401106115 VIASAT, INC. 2025 fourth_quarter TEC Advocated on issues related to satellite communications, specifically the value of satellite services HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-09T16:52:13-05:00
3480392 SHAWNEE COMMUNICATIONS 5fac0f03-db73-43e0-839e-8d05cc1e6d8b Q4 SHAWNEE COMMUNICATIONS 401104672 SHAWNEE COMMUNICATIONS 2025 fourth_quarter TEC Telecommunications - broadband Contributions Reform FCC USF HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-09T17:36:45-05:00
3480609 HOLLAND & KNIGHT LLP 44e1b4c5-64a6-40b2-b2fa-a0ed87f25c6b Q4 HOLLAND & KNIGHT LLP 18466 VERISIGN, INC. 2025 fourth_quarter TEC Issues related to internet governance policy; issues related to online privacy. HOUSE OF REPRESENTATIVES,SENATE 90000   0 0 2026-01-10T17:59:49-05:00
3480682 KEYSIGHT TECHNOLOGIES, INC ce85f2fc-4e2d-450c-9d2a-cf0d129d8995 Q4 KEYSIGHT TECHNOLOGIES, INC 401103416 KEYSIGHT TECHNOLOGIES, INC 2025 fourth_quarter TEC Policy rules regarding spectrum sharing and use of frequencies above 95GHz and NextG standards. Defense, Dept of (DOD),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),Office of Science & Technology Policy (OSTP),SENATE     0 0 2026-01-11T10:55:14-05:00
3480731 PENN AVENUE PARTNERS ae088fa1-6f1a-4f7b-9da6-e1aea69e90a1 Q4 PENN AVENUE PARTNERS 400918672 CHARTER COMMUNICATIONS, INC. 2025 fourth_quarter TEC Communications and Technology Issues. Rural Broadband Issues. Broadband Adoption Issues. Infrastructure Issues. Spectrum Issues. Security Act CISA Reauthorization. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-01-11T14:53:35-05:00
3480829 MILLER & WENHOLD CAPITOL STRATEGIES dec89753-8404-4451-baac-865dbbcbbe5a Q4 MILLER & WENHOLD CAPITOL STRATEGIES 307034 ASSOCIATION OF TELESERVICES INTERNATIONAL 2025 fourth_quarter TEC USF reform Keep Call Centers in America Act Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-11T18:02:46-05:00
3480971 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO 9eb347a7-1fe9-4acc-8756-88c02ce2c94b Q4 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO 400348604 EIGHT ELEVEN GROUP, LLC 2025 fourth_quarter TEC Advocacy related to workforce development issues in telecommunications and utilities sector; specifically the Broadband Equity, Access, and Deployment Program. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-12T09:09:50-05:00
3480974 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO f24cb3b2-a62f-43d5-9fb8-08ae3e3c14db Q4 TAFT STETTINIUS & HOLLISTER LLP DBA TAFT ADVISORS LLC FKA (TAFT, STETTINIUS & HO 400348604 AI FOR ALL, LLC D/B/A AI OWL 2025 fourth_quarter TEC Issues pertaining to advancing AI integration within the workforce and education/workforce sectors. Additionally, working to advance AI adoption in critical industry sectors. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2026-01-12T09:10:45-05:00
3481220 HILLNORTH LLC fec911ea-3a80-4016-97e2-96b27e07f3aa Q4 HILLNORTH LLC 401105493 NATIONAL ASSOCIATION OF BROADCASTERS (NAB) 2025 fourth_quarter TEC Issues related to the broadcast industry. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-12T11:12:49-05:00
3481401 NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS 9a1893ca-6dfa-4c7a-b02e-23532f06d362 Q4 NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS 27183 NATIONAL ASSOCIATION OF SURETY BOND PRODUCERS 2025 fourth_quarter TEC Generally, advocated for introduction of legislation to establish the use of surety bonds as acceptable security on federally-funded broadband infrastructure programs administered by the Department of Agriculture, the Federal Communications Commission, and the Department of Commerce. HOUSE OF REPRESENTATIVES,SENATE   10000 0 0 2026-01-12T13:14:50-05:00
3481636 VENABLE LLP 9f5eb976-07c9-4046-a326-55ba1bfbe36e Q4 VENABLE LLP 39941 INCOMPAS 2025 fourth_quarter TEC Broadband permitting reform HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2026-01-12T15:30:50-05:00
3481867 BROYDRICK & ASSOCIATES 9cf5e0b6-d11d-475b-81e3-2c49d5dfcce0 Q4 BROYDRICK & ASSOCIATES 7268 KULR TECHNOLOGY GROUP 2025 fourth_quarter TEC Feasibility of coverage through DOD. Exploring DOT or Congressional rule for product use. HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-12T17:32:35-05:00
3481943 121 STRATEGIES & GOVERNMENT RELATIONS 151b0648-c1cb-43e7-94ef-f310d1eefd9c Q4 121 STRATEGIES & GOVERNMENT RELATIONS 40022170 ULTRA WIDE BAND ALLIANCE 2025 fourth_quarter TEC Ultra-wideband radio communications: optimized spectrum-sharing benefits. Ultra-Wide Band spectrum rules under Part 15. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE     0 0 2026-01-12T21:33:51-05:00
3481948 121 STRATEGIES & GOVERNMENT RELATIONS 02f47898-a0a3-4b60-9f07-8a8a2f3a1415 Q4 121 STRATEGIES & GOVERNMENT RELATIONS 40022170 ZEBRA TECHNOLOGIES 2025 fourth_quarter TEC FCC spectrum policy and band allocation at 900MHz.Positioning, Navigation, and Timing Resilience. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-12T21:41:13-05:00
3482096 MITCHELL LAW PLLC ed55ea49-8d32-4ec6-af5e-55d23e412cae Q4 MITCHELL LAW PLLC 401110084 HEALTHCONNECT NETWORKS 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-13T09:59:29-05:00
3482144 CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES 1e4413a3-13f7-4894-bf61-13cbdc719c2e Q4 CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES 401105291 CINCINNATI BELL INC (DBA ALTAFIBER) AND ITS SUBSIDIARIES 2025 fourth_quarter TEC BEAD, ROW Permitting, Access to Poles, Railroad Crossings, Video Issues HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE   10000 0 0 2026-01-13T10:16:10-05:00
3482245 HSA STRATEGIES 36ffd991-83c9-437e-b1f2-3d59ff0df58d Q4 HSA STRATEGIES 401106545 AMAZON.COM SERVICES LLC 2025 fourth_quarter TEC Satellite related issues, NGSO related issues Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-01-13T11:15:19-05:00
3482246 HSA STRATEGIES 309a03ef-ae2a-4216-9f31-a190cb024cb2 Q4 HSA STRATEGIES 401106545 AT&T SERVICES, INC. AND ITS AFFILIATES 2025 fourth_quarter TEC Broadband issues Public safety related issues Telecommunications policy issues, including internet and communications services, broadband and infrastructure deployment Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2026-01-13T11:16:00-05:00
3482247 HSA STRATEGIES b6bfa6c7-7ace-4a70-9088-23c41ef795d3 4T HSA STRATEGIES 401106545 COMCAST CORPORATION 2025 fourth_quarter TEC Broadband issues Internet and communications services Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 51000   0 1 2026-01-13T11:16:29-05:00
3482249 HSA STRATEGIES 8496868a-7058-4bf8-b3e5-3d8461d90fa6 Q4 HSA STRATEGIES 401106545 NEXSTAR MEDIA GROUP, INC. 2025 fourth_quarter TEC Broadcast content issues Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2026-01-13T11:16:57-05:00
3482250 HSA STRATEGIES 35c0d2da-4fb5-461e-8292-7c5416bd739a Q4 HSA STRATEGIES 401106545 SATELLITE INDUSTRY ASSOCIATION 2025 fourth_quarter TEC Satellite related issues Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-13T11:17:22-05:00
3482258 MITCHELL LAW PLLC d12b129b-d4f9-41f2-bb12-16c144f980d6 Q4 MITCHELL LAW PLLC 401110084 NORTH CAROLINA TELEHEALTH NETWORK ASSOCIATION 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-13T11:25:59-05:00
3482270 CASSIDY & ASSOCIATES, INC. 141de77f-a8a3-4461-a87e-12de197473e9 Q4 CASSIDY & ASSOCIATES, INC. 8453 CHARTER COMMUNICATIONS OPERATING, LLC 2025 fourth_quarter TEC Privacy, internet policy, spectrum, infrastructure, workforce development, rural broadband. HOUSE OF REPRESENTATIVES,SENATE,White House Office 50000   0 0 2026-01-13T11:33:43-05:00
3482274 HORIZON GOVERNMENT AFFAIRS 1ae47897-6b94-4b41-a6d7-baf175aea5f2 4T HORIZON GOVERNMENT AFFAIRS 315592 FIRST PRINCIPLES STRATEGIES, LLC ON BEHALF OF VALIDAS, LLC 2025 fourth_quarter TEC Education of federal telecommunications policies Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES     0 1 2026-01-13T11:34:51-05:00
3482291 MITCHELL LAW PLLC 1c91d560-5517-45aa-b452-4faecad1e8af Q4 MITCHELL LAW PLLC 401110084 NEW ENGLAND TELEHEALTH CONSORTIUM 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-13T11:41:49-05:00
3482302 THE PETRIZZO GROUP, INC. 2f1819e8-e612-42b3-ad8a-2110812b0159 Q4 THE PETRIZZO GROUP, INC. 305932 DISH NETWORK CORPORATION 2025 fourth_quarter TEC Issues relating to the wireless industry, such as spectrum technologies, spectrum management, infrastructure. Issues relating to broadband access, competition, and funding. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-13T11:49:12-05:00
3482327 MITCHELL LAW PLLC a0b79ba2-7476-4bc1-bce3-00d63356f9e6 Q4 MITCHELL LAW PLLC 401110084 ADS ADVANCED DATA SERVICES, INC. 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-13T12:10:03-05:00
3482377 KELLER AND HECKMAN, LLP 797870a7-cc29-4268-b6bd-3ac8480220d3 Q4 KELLER AND HECKMAN, LLP 21313 AMERICAN PUBLIC POWER ASSOCIATION (APPA) 2025 fourth_quarter TEC Met with House Energy and Commerce Committee professional staff to discuss APPA's concerns that HR 278, the Broadband Leadership Act, would subject public power utility poles to regulation by the FCC. HOUSE OF REPRESENTATIVES     0 0 2026-01-13T12:56:50-05:00
3482382 MITCHELL LAW PLLC d77e3224-7dcf-4162-b603-d3222e7757e6 Q4 MITCHELL LAW PLLC 401110084 COMMUNITY HOSPITAL CORPORATION 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-13T13:01:19-05:00
3482520 TWILIO INC. 75749587-44d2-47f5-a204-b51e322bee90 Q4 TWILIO INC. 401105202 TWILIO INC. 2025 fourth_quarter TEC Issues related to STIR/SHAKEN; Issues related to robocall fraud prevention and voice communication services. Federal Communications Commission (FCC)   200000 0 0 2026-01-13T13:45:39-05:00
3482745 COALITION ON HUMAN NEEDS 4b5d15aa-fb7b-4544-b1a6-56a9aae30174 Q4 COALITION ON HUMAN NEEDS 401105224 COALITION ON HUMAN NEEDS 2025 fourth_quarter TEC CHN supports additional funding for the Affordable Connectivity Program (ACP). HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-01-13T15:32:47-05:00
3482760 EQUINIX, INC. 291573e1-b9f6-4480-ae5e-c26fae679bad Q4 EQUINIX, INC. 401104350 EQUINIX, INC. 2025 fourth_quarter TEC Issues related to data centers and related internet connectivity (no specific legislation). Commerce, Dept of (DOC),Executive Office of the President (EOP),General Services Administration (GSA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS)   500000 0 0 2026-01-13T15:36:11-05:00
3482811 A LEARNED HAND, LLC 09fcff72-1159-40a6-8e5f-650a323a8cf1 Q4 A LEARNED HAND, LLC 400428076 AMERICAN LIBRARY ASSOCIATION 2025 fourth_quarter TEC Safeguard USF & E-Rate; protect open, secure networks; leverage libraries for digital opportunity/skills Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 12375   0 0 2026-01-13T15:49:36-05:00
3482849 KOUNTOUPES DENHAM CARR & REID, LLC 60a08274-5ad8-4b09-b1b6-be03fbb746f8 Q4 KOUNTOUPES DENHAM CARR & REID, LLC 320918 CHARTER COMMUNICATIONS OPERATING, LLC 2025 fourth_quarter TEC Issues related to telecommunications and broadband access, deployment and adoption, including H.R. 2784, Stopping the Theft and Destruction of Broadband Act of 2025. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-13T16:06:18-05:00
3482894 COBANK, ACB 5f5fd5f0-7d5e-4872-8ae4-f82eb136b496 Q4 COBANK, ACB 9738 COBANK ACB 2025 fourth_quarter TEC Broadband Deployment Farm Bill Reauthorization USF Funding and Reform Agriculture, Dept of (USDA),Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE   280000 0 0 2026-01-13T16:20:37-05:00
3483108 THORSEN FRENCH ADVOCACY LLC 9caa022a-768a-48a2-8a63-255af3a0ed97 Q4 THORSEN FRENCH ADVOCACY LLC 400599826 BRIA ARTIFICIAL INTELLIGENCE INC. 2025 fourth_quarter TEC Public policy issues related to artificial intelligence technology. Implementation of H.R.1 - One Big Beautiful Bill Act. H.R.3921/S.1829 - STOP CSAM Act of 2025. S.278 - Kids Off Social Media Act. H.R.2794 - NO FAKES Act of 2025. S.1748 - Kids Online Safety Act. S.1396 - Content Origin Protection and Integrity from Edited and Deepfaked Media Act of 2025. S.836 - Children and Teens Online Privacy Protection Act. S.2367 - AI Accountability and Personal Data Protection Act. S.2937 - AI LEAD Act. S.2455 - TRAIN Act. HOUSE OF REPRESENTATIVES,SENATE,U.S. Copyright Office 40000   0 0 2026-01-13T19:08:09-05:00
3483139 THE PETRIZZO GROUP, INC. 61d6b8c1-42aa-441d-982f-68c8049bb095 4A THE PETRIZZO GROUP, INC. 305932 DISH NETWORK CORPORATION 2025 fourth_quarter TEC Issues relating to the wireless industry, such as spectrum technologies, spectrum management, infrastructure. Issues relating to broadband access, competition, and funding. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-13T20:35:26-05:00
3483269 MITCHELL LAW PLLC e7b20cca-e4bf-44a9-9b08-695b4fc5eff8 Q4 MITCHELL LAW PLLC 401110084 COLORADO HOSPITAL ASSOCIATION 2025 fourth_quarter TEC Matters pertaining to the reforming and restructuring of the Universal Service Fund. SENATE     0 0 2026-01-14T08:21:19-05:00
3483426 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 83bb3bc2-401a-43ed-a6ef-05cfa1c90333 Q4 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 VERIZON SERVICES CORPORATION 2025 fourth_quarter TEC Issues related to tax, trade, broadband, mobile, and public safety communications issues. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-14T10:41:00-05:00
3483436 BALLARD PARTNERS a055f053-082a-4891-b90a-d93efbc0bace Q4 BALLARD PARTNERS 401104288 EQUINIX, INC. 2025 fourth_quarter TEC Tracking executive orders and action regarding, power, energy, and data center development. White House Office 120000   0 0 2026-01-14T10:42:28-05:00
3483494 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 04f03308-407d-40f6-88ab-153c4946635a Q4 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 APPLE, INC. 2025 fourth_quarter TEC Issues related to tax, trade, technology and broadband. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-14T10:59:45-05:00
3483582 THE FERGUSON GROUP c688b100-8569-45ce-ba99-9fbed89f1b38 Q4 THE FERGUSON GROUP 14451 MERCED IRRIGATION DISTRICT 2025 fourth_quarter TEC Broadband HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2026-01-14T11:15:21-05:00
3483602 MERIDIAN 535 STRATEGIES 13ac33b4-92e9-4c45-84b4-b557c1c0c992 Q4 MERIDIAN 535 STRATEGIES 401109425 DRONE DEPLOY 2025 fourth_quarter TEC Drone data security standards HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-01-14T11:20:22-05:00
3483681 KOUNTOUPES DENHAM CARR & REID, LLC cacc31c1-d952-4812-af29-e779875108dd Q4 KOUNTOUPES DENHAM CARR & REID, LLC 320918 ADT, LLC 2025 fourth_quarter TEC Issues related to spectrum, public safety and security. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-01-14T11:49:03-05:00
3483775 BROWNSTEIN HYATT FARBER SCHRECK, LLP 8feaa231-c523-4f06-9350-4ffb3b455be7 Q4 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 AFRICELL UK LIMITED 2025 fourth_quarter TEC Funding for broader mobile coverage in Africa Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,State, Dept of (DOS) 90000   0 0 2026-01-14T12:27:08-05:00
3483794 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 872eae9b-41c8-4a6b-a27d-9b789bb9ca08 Q4 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 STARZ ENTERTAINMENT, LLC 2025 fourth_quarter TEC Lobbying related to issues impacting cable programers. HOUSE OF REPRESENTATIVES,SENATE,White House Office 30000   0 0 2026-01-14T12:39:22-05:00
3483803 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 7ce1cbfe-5f8e-4500-b61d-e90d7bad5151 Q4 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 MSGN HOLDINGS L.P. 2025 fourth_quarter TEC Issues related to the programming industry HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-14T12:45:28-05:00
3483888 BROWNSTEIN HYATT FARBER SCHRECK, LLP 670d19f7-be7a-40c4-9a3b-f78be88b350a Q4 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 AMERICAN TOWER CORPORATION 2025 fourth_quarter TEC Telecommunications issues, both domestic and international Broadband/wireless access and deployment issues related to towers HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2026-01-14T13:16:39-05:00
3483901 THE INGRAM GROUP LLC 16e3fb0e-e142-48bc-b716-680a0a6e46e4 Q4 THE INGRAM GROUP LLC 400577737 ZAYO EDUCATION, INC. 2025 fourth_quarter TEC Issues related to the Universal Service Administrative Company (USAC) relative to E-Rate funds and Rural Healthcare Program funds. Issues related to non-deployment BEAD funds. HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE 20000   0 0 2026-01-14T13:19:01-05:00
3484081 BRIDGE PUBLIC AFFAIRS, LLC 14809daf-6226-423c-8200-e762c967494f Q4 BRIDGE PUBLIC AFFAIRS, LLC 401105130 ELECTRIC POWER BOARD 2025 fourth_quarter TEC Congressional and regulatory efforts related to energy, economic development, and telecommunications including broadband. Education related to quantum communication technology. Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,Tennessee Valley Authority (TVA) 50000   0 0 2026-01-14T14:06:25-05:00
3484102 I STREET ADVOCATES a56c40f9-09dc-43d0-8d87-0242b9442952 Q4 I STREET ADVOCATES 51753 DISH NETWORK LLC 2025 fourth_quarter TEC Issues relating to broadband and wireless industry competition, spectrum licensing, and infrastructure. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-01-14T14:09:30-05:00
3484164 JOHNSON CONTROLS, INC AND AFFILIATES 44c953ae-1bf1-45dd-955d-b3c3758a0944 Q4 JOHNSON CONTROLS, INC AND AFFILIATES 51150 JOHNSON CONTROLS INC 2025 fourth_quarter TEC Issues related to security technology and spectrum optimization Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE   120000 0 0 2026-01-14T14:18:24-05:00
3484895 VENABLE LLP c320cf19-a0a3-4576-9618-bf59eca438a0 Q4 VENABLE LLP 39941 META PLATFORMS, INC. AND VARIOUS SUBSIDIARIES 2025 fourth_quarter TEC Issues related to social networking HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-01-14T19:58:12-05:00
3485475 HOGAN LOVELLS US LLP dc8a7ec2-b782-4458-a97f-3b9f0e33b8c4 Q4 HOGAN LOVELLS US LLP 18422 BOOKING HOLDINGS INC. 2025 fourth_quarter TEC Hotel Fees Transparency Act (S. 314 and H.R. 1479); data privacy and tech legislation and policies.   80000   0 0 2026-01-15T10:45:53-05:00
3485516 HOGAN LOVELLS US LLP 35129fab-5cf7-49a0-8308-e54139c7adb6 Q4 HOGAN LOVELLS US LLP 18422 CORETSU INC. 2025 fourth_quarter TEC Technology applications for legal and regulatory analysis. HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 90000   0 0 2026-01-15T10:49:33-05:00

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE lobbying_activities (
            id INTEGER PRIMARY KEY,
            filing_uuid TEXT NOT NULL,
            filing_type TEXT NOT NULL,
            registrant_name TEXT NOT NULL,
            registrant_id INTEGER,
            client_name TEXT NOT NULL,
            filing_year INTEGER NOT NULL,
            filing_period TEXT NOT NULL,
            issue_code TEXT,
            specific_issues TEXT,
            government_entities TEXT,
            income_amount INTEGER,
            expense_amount INTEGER,
            is_no_activity INTEGER DEFAULT 0,
            is_termination INTEGER DEFAULT 0,
            received_date TEXT,
            CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
                REFERENCES lobbying_filings_raw(filing_uuid)
        );
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);
Powered by Datasette · Queries took 2359.252ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API