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

28,925 rows where issue_code = "COM" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_termination, received_date (date)

filing_year 28

  • 2025 2,500
  • 2008 1,652
  • 2009 1,356
  • 2010 1,333
  • 2011 1,278
  • 2019 1,188
  • 2014 1,162
  • 2020 1,153
  • 2022 1,153
  • 2015 1,150
  • 2021 1,146
  • 2018 1,143
  • 2016 1,132
  • 2023 1,122
  • 2024 1,116
  • 2017 1,114
  • 2012 1,091
  • 2013 1,087
  • 2007 836
  • 2006 795
  • 2005 729
  • 2002 656
  • 2004 632
  • 2003 584
  • 2000 547
  • 1999 489
  • 2001 488
  • 2026 293

filing_period 6

  • first_quarter 6,259
  • second_quarter 5,819
  • third_quarter 5,590
  • fourth_quarter 5,493
  • mid_year 3,000
  • year_end 2,764

issue_code 1

  • COM · 28,925 ✖
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
3801597 HARO SOLUTIONS LLC ace9c3b4-02b8-4ed5-9210-b0a50fac1e02 Q1 HARO SOLUTIONS LLC 401108563 NATIONAL ASSOCIATION OF BROADCASTERS 2026 first_quarter COM H.R. 979, AM Radio for Every Vehicle Act of 2025 S. 315, AM Radio for Every Vehicle Act of 2025 H.Con.Res.12, Supporting the Local Radio Freedom Act S.Con.Res.8, A concurrent resolution supporting the Local Radio Freedom Act Issues around media ownership Issues around the next generation of broadcast television HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-01T11:49:48-04:00
3801640 BLOOM STRATEGIC COUNSEL cb6d79a6-ea38-4ca4-8ca2-b5f0f3b7cceb Q1 BLOOM STRATEGIC COUNSEL 401036920 DIGITAL CONTENT NEXT 2026 first_quarter COM Legislation, regulation, and policies impacting online publishers HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-01T12:56:46-04:00
3803132 HILLNORTH LLC cd815248-9997-4167-92a6-dc47924746d5 Q1 HILLNORTH LLC 401105493 CTIA - THE WIRELESS ASSOCIATION 2026 first_quarter COM Issues related to the wireless industry. HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2026-04-07T10:26:12-04:00
3803134 HILLNORTH LLC 087bf7aa-30c2-4aee-a3d7-e7bba980b435 Q1 HILLNORTH LLC 401105493 FOX CORPORATION 2026 first_quarter COM Copyright and content carriage issues; retransmission consent and program carriage issues; online privacy; spectrum-related issues; media ownership issues; First Amendment issues; streaming issues; advertising issues; Section 230 of the Communications Decency Act; antitrust enforcement and reform; unmanned aerial vehicle issues; corporate tax issues. HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2026-04-07T10:27:15-04:00
3803308 HILLNORTH LLC 8f2db2c9-fc8d-49b4-a15a-2ea3056bdf1c Q1 HILLNORTH LLC 401105493 NATIONAL ASSOCIATION OF BROADCASTERS (NAB) 2026 first_quarter COM Issues related to the broadcast industry. HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2026-04-07T13:57:30-04:00
3803604 RIVER PUBLIC AFFAIRS GROUP 2e469406-bc63-41d4-a16c-f6bd6bfd3369 1T RIVER PUBLIC AFFAIRS GROUP 401107443 SALEM MEDIA GROUP 2026 first_quarter COM S.315 - AM Radio for Every Vehicle Act of 2025. Passage of the bill through committees and Congress. HOUSE OF REPRESENTATIVES,SENATE,White House Office     0 1 2026-04-07T20:23:21-04:00
3804428 FORBES-TATE f25ea593-3c79-475f-a01d-c2dc69536804 1T FORBES-TATE 400976792 LUMEN TECHNOLOGIES SERVICE GROUP, LLC 2026 first_quarter COM Issues related to broadband development and general rural broadband related issues. HOUSE OF REPRESENTATIVES,SENATE 40000   0 1 2026-04-08T18:46:12-04:00
3804529 THE GIBSON GROUP, LLC 72a86b08-22a5-46fe-a761-7d215d24229f Q1 THE GIBSON GROUP, LLC 400703107 IHEARTMEDIA INC 2026 first_quarter COM Issues regarding the Local Radio Freedom Act (H. Con. Res. 12; S. Con. Res. 8) Issues regarding the American Music Fairness Act (HR 861; S 326) Issues regarding AM in car radios (HR 979; S 315) HOUSE OF REPRESENTATIVES 30000   0 0 2026-04-09T11:07:58-04:00
3804555 DISABILITY BELONGS df07a551-1028-4019-afd2-f6ff1bcb8b60 Q1 DISABILITY BELONGS 401108068 DISABILITY BELONGS 2026 first_quarter COM Advocating so that people with disabilities have access to communications technologies across the board and that those technologies are accessible to all. HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-04-09T11:34:55-04:00
3805619 SINCLAIR BROADCAST GROUP bfe2c501-89e4-4895-9731-8a228b412dad Q1 SINCLAIR BROADCAST GROUP 401103267 SINCLAIR BROADCAST GROUP 2026 first_quarter COM Issues related to media ownership and ownership caps, communications ecosystem including competition and future of media; issues relating to FCC oversight; deployment of ATSC 3.0 including in mobile devices; rules governing distribution ecosystem including virtual MVPDs. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2026-04-10T17:50:23-04:00
3805912 MATTOON & ASSOCIATES, LLC 209f754d-968d-43db-8273-723a9e83cbaa Q1 MATTOON & ASSOCIATES, LLC 314215 IHEARTMEDIA INC 2026 first_quarter COM H.R. 979, "AM Radio for Every Vehicle Act", all provisions. (2025) HOUSE OF REPRESENTATIVES 40000   0 0 2026-04-12T15:37:35-04:00
3805922 KELSAY STRATEGIES LLC e3cbc06e-0fcd-4515-a709-0184fa42e055 Q1 KELSAY STRATEGIES LLC 401104837 UNITED STATES TELECOM ASSOCIATION 2026 first_quarter COM General lobbying on telecommunications issues: broadband policy related to deployment, access, digital equity and affordability, access to devices, municipal broadband, supply chain, broadband infrastructure, mapping, broadband speeds, permitting, data privacy, robocalls, cyber security and artificial intelligence. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-12T17:31:28-04:00
3806000 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) b2aad1f4-0399-4830-9642-ec1a0e6e41d6 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 NATIONAL FOOTBALL LEAGUE 2026 first_quarter COM Legislative monitoring and outreach related to cable and communications issues as well as labor contract issues. HCR-Player health issues. HOUSE OF REPRESENTATIVES,SENATE,White House Office 90000   0 0 2026-04-13T09:02:26-04:00
3806004 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 96593558-3ea7-4fbb-b28c-f331b5b5d102 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 THE WALT DISNEY COMPANY 2026 first_quarter COM Issues related to cable and broadcast programming. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-13T09:04:47-04:00
3806023 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 7b11d39f-367e-452a-9e48-97ad0ce6f133 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 STARZ ENTERTAINMENT, LLC 2026 first_quarter COM Lobbying related to issues impacting cable programers. HOUSE OF REPRESENTATIVES,SENATE,White House Office 30000   0 0 2026-04-13T09:22:49-04:00
3806241 SALINAS STRATEGIES LLC de14e49d-e98a-449d-ba21-0f6a0db7c69b Q1 SALINAS STRATEGIES LLC 401106227 CHARTER COMMUNICATIONS OPERATING, LLC 2026 first_quarter COM communications and competition policy areas HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-13T11:47:22-04:00
3806384 DCI GROUP, L.L.C. 84e9c704-5639-4d31-b950-b95dcfa21b20 Q1 DCI GROUP, L.L.C. 61174 VERIZON 2026 first_quarter COM Internet Policy HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-13T13:22:30-04:00
3807087 EFB ADVOCACY, LLC 2760c8a7-2bf8-41dc-933a-a50d36d42030 Q1 EFB ADVOCACY, LLC 401104430 FOX CORPORATION 2026 first_quarter COM Copyright and content carriage issues; retransmission consent and program carriage issues; online privacy; spectrum-related issues; media ownership issues; First Amendment issues; streaming issues; advertising issues; Section 230 of the Communications Decency Act; antitrust enforcement and reform; unmanned aerial vehicle issues; corporate tax issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-14T09:23:31-04:00
3807178 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 5b4c1e00-3888-4b29-b40f-9437b3581023 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 LINCOLN MEDIA LLC 2026 first_quarter COM Issues related to regional sports networks HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-14T10:11:58-04:00
3807195 THE MCKEON GROUP, INC. 2d54c09a-c502-4c8e-967e-d9672e73dc36 Q1 THE MCKEON GROUP, INC. 401103598 GLOBAL HF, LLC 2026 first_quarter COM FY 2027 DOD appropriations HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2026-04-14T10:22:10-04:00
3807200 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7cd559a0-78c1-47aa-9219-d3cce53c809a Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 XLIGHT INC. 2026 first_quarter COM Inform and educate officials on the development and production of EUV lithography for advanced CHIPS manufacturing as well as the need for appropriations and federal funding support for advanced semiconductor technologies. Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Natl Institute of Standards & Technology (NIST),SENATE 50000   0 0 2026-04-14T10:23:52-04:00
3807290 CORNERSTONE GOVERNMENT AFFAIRS, INC. 6657d524-5988-4833-9a9f-c3614b5e7bdb Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 PLAYGROUND GLOBAL, LLC 2026 first_quarter COM Education and advocacy focused on advancing domestic capabilities; Incentives and funding opportunities for next gen technologies such as critical minerals extraction and processing, nuclear, defense technologies, semiconductor and energy. Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-04-14T11:07:56-04:00
3807456 CORNERSTONE GOVERNMENT AFFAIRS, INC. 98dc657c-2f41-4168-a7c7-732acd5cfde4 Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 IHEARTMEDIA, INC. 2026 first_quarter COM Issues related to broadcast and digital media. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-14T12:42:47-04:00
3807911 DAVID RUDD & ASSOCIATES LLC ee71bb87-27d5-45e6-ade5-85868cba0d69 Q1 DAVID RUDD & ASSOCIATES LLC 401104762 COX ENTERPRISES, INC. 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-14T15:03:27-04:00
3807914 DAVID RUDD & ASSOCIATES LLC ae1ed335-d65b-4995-8ed7-d9aec83b1305 Q1 DAVID RUDD & ASSOCIATES LLC 401104762 NATIONAL CABLE & TELECOMMUNICATIONS ASSOCIATION (NCTA) 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-04-14T15:04:24-04:00
3807917 DAVID RUDD & ASSOCIATES LLC 80655732-9897-4e53-b21c-4da892d2b4a9 1T DAVID RUDD & ASSOCIATES LLC 401104762 COMCAST CORPORATION 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2026-04-14T15:04:53-04:00
3808516 I STREET ADVOCATES 72588b01-57c2-4609-8e1f-051f8958e5e1 Q1 I STREET ADVOCATES 51753 DISH NETWORK LLC 2026 first_quarter COM Issues relating to video marketplace competition and media ownership. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-14T20:25:15-04:00
3808654 NATIONAL GROUP, LLP 1f26e2c1-1d4f-433f-b386-f9875e832e17 Q1 NATIONAL GROUP, LLP 66090 CONNECTICUT PUBLIC BROADCASTING 2026 first_quarter COM Public Broadcasting issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-15T08:08:11-04:00
3808827 HOGAN LOVELLS US LLP 67883611-1f48-411d-b910-efbcda634f85 Q1 HOGAN LOVELLS US LLP 18422 MAIN STREET SPORTS GROUP DBA FANDUEL SPORTS NETWORK 2026 first_quarter COM Issues related to carriage agreements of Main Street Sports Group, LLC Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-04-15T09:41:23-04:00
3808874 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) e847bd1c-e1df-45c1-99f0-34f63bddd894 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 ZOOM VIDEO COMMUNICATIONS, INC. 2026 first_quarter COM Advocacy before the Trump Administration on technology issues. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),White House Office 70000   0 0 2026-04-15T10:07:12-04:00
3809085 KELLER AND HECKMAN, LLP 0b281740-4d1d-4747-8717-d87323e07e74 Q1 KELLER AND HECKMAN, LLP 21313 AMERICAN PUBLIC POWER ASSOCIATION (APPA) 2026 first_quarter COM 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-04-15T11:44:14-04:00
3809417 KOUNTOUPES DENHAM CARR & REID, LLC 2c36d5d6-0ed6-4fe3-ac0a-3a342555c4fd Q1 KOUNTOUPES DENHAM CARR & REID, LLC 320918 CCIA (CONSUMER CREDIT INDUSTRY ASSOCIATION) 2026 first_quarter COM Issues related to the Federal Trade Commission.   40000   0 0 2026-04-15T13:28:43-04:00
3809613 HILLNORTH LLC f6d287b5-a69c-4a3f-adf2-3354264fde0b Q1 HILLNORTH LLC 401105493 VERIZON 2026 first_quarter COM Regulatory Issues, Broadband Issues, Issues related to oversight of the Federal Communications Commission, and Spectrum-related issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T14:16:13-04:00
3809635 THE RUSSELL GROUP, INC. 2546c219-cee8-4937-8dac-14189a536815 Q1 THE RUSSELL GROUP, INC. 22688 NATIONAL RURAL ELECTRIC COOPERATIVE ASSOCIATION 2026 first_quarter COM Issues pertaining to rural broadband and rural utilities; issues pertaining to financing for rural electric cooperatives; issues pertaining to the Farm Bill; implementation of the Inflation Reduction Act; issues related to FY27 appropriations; issues related to RUS electric loans; and issues related to the Rural Energy Savings Program. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T14:21:12-04:00
3809988 THE NICKLES GROUP, LLC 732852e4-59e7-4542-9df2-c0cf9930929f Q1 THE NICKLES GROUP, LLC 293335 COMCAST CORPORATION 2026 first_quarter COM General telecommunications issues related to telecommunications and cable interests, including cyber security, rural broadband deployment, broadband adoption and digital literacy. National Defense Authorization Act (NDAA) for Fiscal Year 2027, as it relates to spectrum issues. Issues related to federal permitting reform. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-15T15:31:56-04:00
3810023 STEPHEN WARD CONSULTING, LLC 9583435e-2622-4f10-8aea-a34fdc375dc5 Q1 STEPHEN WARD CONSULTING, LLC 401106286 HUBBARD BROADCASTING 2026 first_quarter COM Issues related to independent programming networks and carriage negotiations. SENATE 20000   0 0 2026-04-15T15:38:28-04:00
3810192 HOLLAND & KNIGHT LLP db37c481-e530-4464-b087-24194f39b8ea Q1 HOLLAND & KNIGHT LLP 18466 VIASAT, INC. 2026 first_quarter COM Issues connected to the Federal Communications Commissions proposed regulations in the matter of SB Docket No. 25-157; issues connected to global satellite communications policy and the U.S. role in the upcoming World Radio Conference. HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE 80000   0 0 2026-04-15T16:03:50-04:00
3810918 BL PARTNERS GROUP, LLC 5104d511-9226-4b57-aac6-6d898f60e587 Q1 BL PARTNERS GROUP, LLC 401105341 NEWS CORPORATION 2026 first_quarter COM Issues related to Sec. 230 of the Communications Decency Act.   30000   0 0 2026-04-15T19:53:27-04:00
3810922 BL PARTNERS GROUP, LLC 2f948f41-209e-4457-8dc8-46dc7d7f79b5 Q1 BL PARTNERS GROUP, LLC 401105341 CTIA - THE WIRELESS ASSOCIATION 2026 first_quarter COM Issues related to the cellular telephone industry - no specific legislation. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T19:58:25-04:00
3811072 THE O TEAM LLC 5f5f0a2a-ffd5-4b39-80ad-48f07063a25b Q1 THE O TEAM LLC 400783359 FOX CORPORATION 2026 first_quarter COM Retransmission consent. Online Privacy. Spectrum-related issues. Media ownership issues. First Amendment issues. Sports betting. Sports and event futures. Children's educational TV programming. Advertising issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-16T06:49:47-04:00
3811703 HARO SOLUTIONS LLC ace9c3b4-02b8-4ed5-9210-b0a50fac1e02 Q1 HARO SOLUTIONS LLC 401108563 NATIONAL ASSOCIATION OF BROADCASTERS 2026 first_quarter COM H.R. 979, AM Radio for Every Vehicle Act of 2025 S. 315, AM Radio for Every Vehicle Act of 2025 H.Con.Res.12, Supporting the Local Radio Freedom Act S.Con.Res.8, A concurrent resolution supporting the Local Radio Freedom Act Issues around media ownership Issues around the next generation of broadcast television HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-01T11:49:48-04:00
3811746 BLOOM STRATEGIC COUNSEL cb6d79a6-ea38-4ca4-8ca2-b5f0f3b7cceb Q1 BLOOM STRATEGIC COUNSEL 401036920 DIGITAL CONTENT NEXT 2026 first_quarter COM Legislation, regulation, and policies impacting online publishers HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-01T12:56:46-04:00
3813238 HILLNORTH LLC cd815248-9997-4167-92a6-dc47924746d5 Q1 HILLNORTH LLC 401105493 CTIA - THE WIRELESS ASSOCIATION 2026 first_quarter COM Issues related to the wireless industry. HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2026-04-07T10:26:12-04:00
3813240 HILLNORTH LLC 087bf7aa-30c2-4aee-a3d7-e7bba980b435 Q1 HILLNORTH LLC 401105493 FOX CORPORATION 2026 first_quarter COM Copyright and content carriage issues; retransmission consent and program carriage issues; online privacy; spectrum-related issues; media ownership issues; First Amendment issues; streaming issues; advertising issues; Section 230 of the Communications Decency Act; antitrust enforcement and reform; unmanned aerial vehicle issues; corporate tax issues. HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2026-04-07T10:27:15-04:00
3813414 HILLNORTH LLC 8f2db2c9-fc8d-49b4-a15a-2ea3056bdf1c Q1 HILLNORTH LLC 401105493 NATIONAL ASSOCIATION OF BROADCASTERS (NAB) 2026 first_quarter COM Issues related to the broadcast industry. HOUSE OF REPRESENTATIVES,SENATE 37500   0 0 2026-04-07T13:57:30-04:00
3813710 RIVER PUBLIC AFFAIRS GROUP 2e469406-bc63-41d4-a16c-f6bd6bfd3369 1T RIVER PUBLIC AFFAIRS GROUP 401107443 SALEM MEDIA GROUP 2026 first_quarter COM S.315 - AM Radio for Every Vehicle Act of 2025. Passage of the bill through committees and Congress. HOUSE OF REPRESENTATIVES,SENATE,White House Office     0 1 2026-04-07T20:23:21-04:00
3814534 FORBES-TATE f25ea593-3c79-475f-a01d-c2dc69536804 1T FORBES-TATE 400976792 LUMEN TECHNOLOGIES SERVICE GROUP, LLC 2026 first_quarter COM Issues related to broadband development and general rural broadband related issues. HOUSE OF REPRESENTATIVES,SENATE 40000   0 1 2026-04-08T18:46:12-04:00
3814635 THE GIBSON GROUP, LLC 72a86b08-22a5-46fe-a761-7d215d24229f Q1 THE GIBSON GROUP, LLC 400703107 IHEARTMEDIA INC 2026 first_quarter COM Issues regarding the Local Radio Freedom Act (H. Con. Res. 12; S. Con. Res. 8) Issues regarding the American Music Fairness Act (HR 861; S 326) Issues regarding AM in car radios (HR 979; S 315) HOUSE OF REPRESENTATIVES 30000   0 0 2026-04-09T11:07:58-04:00
3814661 DISABILITY BELONGS df07a551-1028-4019-afd2-f6ff1bcb8b60 Q1 DISABILITY BELONGS 401108068 DISABILITY BELONGS 2026 first_quarter COM Advocating so that people with disabilities have access to communications technologies across the board and that those technologies are accessible to all. HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-04-09T11:34:55-04:00
3815726 SINCLAIR BROADCAST GROUP bfe2c501-89e4-4895-9731-8a228b412dad Q1 SINCLAIR BROADCAST GROUP 401103267 SINCLAIR BROADCAST GROUP 2026 first_quarter COM Issues related to media ownership and ownership caps, communications ecosystem including competition and future of media; issues relating to FCC oversight; deployment of ATSC 3.0 including in mobile devices; rules governing distribution ecosystem including virtual MVPDs. HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2026-04-10T17:50:23-04:00
3816019 MATTOON & ASSOCIATES, LLC 209f754d-968d-43db-8273-723a9e83cbaa Q1 MATTOON & ASSOCIATES, LLC 314215 IHEARTMEDIA INC 2026 first_quarter COM H.R. 979, "AM Radio for Every Vehicle Act", all provisions. (2025) HOUSE OF REPRESENTATIVES 40000   0 0 2026-04-12T15:37:35-04:00
3816029 KELSAY STRATEGIES LLC e3cbc06e-0fcd-4515-a709-0184fa42e055 Q1 KELSAY STRATEGIES LLC 401104837 UNITED STATES TELECOM ASSOCIATION 2026 first_quarter COM General lobbying on telecommunications issues: broadband policy related to deployment, access, digital equity and affordability, access to devices, municipal broadband, supply chain, broadband infrastructure, mapping, broadband speeds, permitting, data privacy, robocalls, cyber security and artificial intelligence. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-12T17:31:28-04:00
3816107 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) b2aad1f4-0399-4830-9642-ec1a0e6e41d6 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 NATIONAL FOOTBALL LEAGUE 2026 first_quarter COM Legislative monitoring and outreach related to cable and communications issues as well as labor contract issues. HCR-Player health issues. HOUSE OF REPRESENTATIVES,SENATE,White House Office 90000   0 0 2026-04-13T09:02:26-04:00
3816111 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 96593558-3ea7-4fbb-b28c-f331b5b5d102 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 THE WALT DISNEY COMPANY 2026 first_quarter COM Issues related to cable and broadcast programming. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-13T09:04:47-04:00
3816130 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 7b11d39f-367e-452a-9e48-97ad0ce6f133 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 STARZ ENTERTAINMENT, LLC 2026 first_quarter COM Lobbying related to issues impacting cable programers. HOUSE OF REPRESENTATIVES,SENATE,White House Office 30000   0 0 2026-04-13T09:22:49-04:00
3816348 SALINAS STRATEGIES LLC de14e49d-e98a-449d-ba21-0f6a0db7c69b Q1 SALINAS STRATEGIES LLC 401106227 CHARTER COMMUNICATIONS OPERATING, LLC 2026 first_quarter COM communications and competition policy areas HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-13T11:47:22-04:00
3816491 DCI GROUP, L.L.C. 84e9c704-5639-4d31-b950-b95dcfa21b20 Q1 DCI GROUP, L.L.C. 61174 VERIZON 2026 first_quarter COM Internet Policy HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-13T13:22:30-04:00
3817194 EFB ADVOCACY, LLC 2760c8a7-2bf8-41dc-933a-a50d36d42030 Q1 EFB ADVOCACY, LLC 401104430 FOX CORPORATION 2026 first_quarter COM Copyright and content carriage issues; retransmission consent and program carriage issues; online privacy; spectrum-related issues; media ownership issues; First Amendment issues; streaming issues; advertising issues; Section 230 of the Communications Decency Act; antitrust enforcement and reform; unmanned aerial vehicle issues; corporate tax issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-14T09:23:31-04:00
3817285 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 5b4c1e00-3888-4b29-b40f-9437b3581023 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 LINCOLN MEDIA LLC 2026 first_quarter COM Issues related to regional sports networks HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-14T10:11:58-04:00
3817302 THE MCKEON GROUP, INC. 2d54c09a-c502-4c8e-967e-d9672e73dc36 Q1 THE MCKEON GROUP, INC. 401103598 GLOBAL HF, LLC 2026 first_quarter COM FY 2027 DOD appropriations HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2026-04-14T10:22:10-04:00
3817307 CORNERSTONE GOVERNMENT AFFAIRS, INC. 7cd559a0-78c1-47aa-9219-d3cce53c809a Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 XLIGHT INC. 2026 first_quarter COM Inform and educate officials on the development and production of EUV lithography for advanced CHIPS manufacturing as well as the need for appropriations and federal funding support for advanced semiconductor technologies. Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,Natl Institute of Standards & Technology (NIST),SENATE 50000   0 0 2026-04-14T10:23:52-04:00
3817397 CORNERSTONE GOVERNMENT AFFAIRS, INC. 6657d524-5988-4833-9a9f-c3614b5e7bdb Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 PLAYGROUND GLOBAL, LLC 2026 first_quarter COM Education and advocacy focused on advancing domestic capabilities; Incentives and funding opportunities for next gen technologies such as critical minerals extraction and processing, nuclear, defense technologies, semiconductor and energy. Commerce, Dept of (DOC),Defense, Dept of (DOD),Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-04-14T11:07:56-04:00
3817563 CORNERSTONE GOVERNMENT AFFAIRS, INC. 98dc657c-2f41-4168-a7c7-732acd5cfde4 Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 IHEARTMEDIA, INC. 2026 first_quarter COM Issues related to broadcast and digital media. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-14T12:42:47-04:00
3818018 DAVID RUDD & ASSOCIATES LLC ee71bb87-27d5-45e6-ade5-85868cba0d69 Q1 DAVID RUDD & ASSOCIATES LLC 401104762 COX ENTERPRISES, INC. 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-14T15:03:27-04:00
3818021 DAVID RUDD & ASSOCIATES LLC ae1ed335-d65b-4995-8ed7-d9aec83b1305 Q1 DAVID RUDD & ASSOCIATES LLC 401104762 NATIONAL CABLE & TELECOMMUNICATIONS ASSOCIATION (NCTA) 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-04-14T15:04:24-04:00
3818024 DAVID RUDD & ASSOCIATES LLC 80655732-9897-4e53-b21c-4da892d2b4a9 1T DAVID RUDD & ASSOCIATES LLC 401104762 COMCAST CORPORATION 2026 first_quarter COM privacy issues; rural broadband issues; spectrum issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2026-04-14T15:04:53-04:00
3818623 I STREET ADVOCATES 72588b01-57c2-4609-8e1f-051f8958e5e1 Q1 I STREET ADVOCATES 51753 DISH NETWORK LLC 2026 first_quarter COM Issues relating to video marketplace competition and media ownership. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-14T20:25:15-04:00
3818761 NATIONAL GROUP, LLP 1f26e2c1-1d4f-433f-b386-f9875e832e17 Q1 NATIONAL GROUP, LLP 66090 CONNECTICUT PUBLIC BROADCASTING 2026 first_quarter COM Public Broadcasting issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-15T08:08:11-04:00
3818934 HOGAN LOVELLS US LLP 67883611-1f48-411d-b910-efbcda634f85 Q1 HOGAN LOVELLS US LLP 18422 MAIN STREET SPORTS GROUP DBA FANDUEL SPORTS NETWORK 2026 first_quarter COM Issues related to carriage agreements of Main Street Sports Group, LLC Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE     0 0 2026-04-15T09:41:23-04:00
3818981 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) e847bd1c-e1df-45c1-99f0-34f63bddd894 Q1 FGS GLOBAL (US) LLC (FKA FGH HOLDINGS LLC) 86196 ZOOM VIDEO COMMUNICATIONS, INC. 2026 first_quarter COM Advocacy before the Trump Administration on technology issues. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Science & Technology Policy (OSTP),SENATE,State, Dept of (DOS),White House Office 70000   0 0 2026-04-15T10:07:12-04:00
3819215 KELLER AND HECKMAN, LLP 0b281740-4d1d-4747-8717-d87323e07e74 Q1 KELLER AND HECKMAN, LLP 21313 AMERICAN PUBLIC POWER ASSOCIATION (APPA) 2026 first_quarter COM 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-04-15T11:44:14-04:00
3819547 KOUNTOUPES DENHAM CARR & REID, LLC 2c36d5d6-0ed6-4fe3-ac0a-3a342555c4fd Q1 KOUNTOUPES DENHAM CARR & REID, LLC 320918 CCIA (CONSUMER CREDIT INDUSTRY ASSOCIATION) 2026 first_quarter COM Issues related to the Federal Trade Commission.   40000   0 0 2026-04-15T13:28:43-04:00
3819743 HILLNORTH LLC f6d287b5-a69c-4a3f-adf2-3354264fde0b Q1 HILLNORTH LLC 401105493 VERIZON 2026 first_quarter COM Regulatory Issues, Broadband Issues, Issues related to oversight of the Federal Communications Commission, and Spectrum-related issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T14:16:13-04:00
3819765 THE RUSSELL GROUP, INC. 2546c219-cee8-4937-8dac-14189a536815 Q1 THE RUSSELL GROUP, INC. 22688 NATIONAL RURAL ELECTRIC COOPERATIVE ASSOCIATION 2026 first_quarter COM Issues pertaining to rural broadband and rural utilities; issues pertaining to financing for rural electric cooperatives; issues pertaining to the Farm Bill; implementation of the Inflation Reduction Act; issues related to FY27 appropriations; issues related to RUS electric loans; and issues related to the Rural Energy Savings Program. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T14:21:12-04:00
3820118 THE NICKLES GROUP, LLC 732852e4-59e7-4542-9df2-c0cf9930929f Q1 THE NICKLES GROUP, LLC 293335 COMCAST CORPORATION 2026 first_quarter COM General telecommunications issues related to telecommunications and cable interests, including cyber security, rural broadband deployment, broadband adoption and digital literacy. National Defense Authorization Act (NDAA) for Fiscal Year 2027, as it relates to spectrum issues. Issues related to federal permitting reform. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-15T15:31:56-04:00
3820153 STEPHEN WARD CONSULTING, LLC 9583435e-2622-4f10-8aea-a34fdc375dc5 Q1 STEPHEN WARD CONSULTING, LLC 401106286 HUBBARD BROADCASTING 2026 first_quarter COM Issues related to independent programming networks and carriage negotiations. SENATE 20000   0 0 2026-04-15T15:38:28-04:00
3820322 HOLLAND & KNIGHT LLP db37c481-e530-4464-b087-24194f39b8ea Q1 HOLLAND & KNIGHT LLP 18466 VIASAT, INC. 2026 first_quarter COM Issues connected to the Federal Communications Commissions proposed regulations in the matter of SB Docket No. 25-157; issues connected to global satellite communications policy and the U.S. role in the upcoming World Radio Conference. HOUSE OF REPRESENTATIVES,Natl Telecommunications & Information Administration (NTIA),SENATE 80000   0 0 2026-04-15T16:03:50-04:00
3821057 BL PARTNERS GROUP, LLC 5104d511-9226-4b57-aac6-6d898f60e587 Q1 BL PARTNERS GROUP, LLC 401105341 NEWS CORPORATION 2026 first_quarter COM Issues related to Sec. 230 of the Communications Decency Act.   30000   0 0 2026-04-15T19:53:27-04:00
3821061 BL PARTNERS GROUP, LLC 2f948f41-209e-4457-8dc8-46dc7d7f79b5 Q1 BL PARTNERS GROUP, LLC 401105341 CTIA - THE WIRELESS ASSOCIATION 2026 first_quarter COM Issues related to the cellular telephone industry - no specific legislation. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-15T19:58:25-04:00
3821214 THE O TEAM LLC 5f5f0a2a-ffd5-4b39-80ad-48f07063a25b Q1 THE O TEAM LLC 400783359 FOX CORPORATION 2026 first_quarter COM Retransmission consent. Online Privacy. Spectrum-related issues. Media ownership issues. First Amendment issues. Sports betting. Sports and event futures. Children's educational TV programming. Advertising issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-16T06:49:47-04:00
3821310 THE PETRIZZO GROUP, INC. 238649e6-999b-4f23-a952-81c985113554 Q1 THE PETRIZZO GROUP, INC. 305932 DISH NETWORK CORPORATION 2026 first_quarter COM Issues relating to video marketplace competition, such as broadcast media ownership caps, consolidation, and retransmission consent reform. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2026-04-16T09:19:53-04:00
3821313 THE PETRIZZO GROUP, INC. a9004b84-e766-4247-85ea-47685f0f1778 Q1 THE PETRIZZO GROUP, INC. 305932 ROKU, INC. 2026 first_quarter COM Issues related to privacy legislation. Issues related to antitrust legislation. Issues related to potential copyright legislation. Issues related to video streaming regulation. Issues related to telecommunications policy. No specific legislation. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-16T09:21:07-04:00
3821760 CASSIDY & ASSOCIATES, INC. 47472066-1a1c-4f95-8e9e-b6bce273d998 Q1 CASSIDY & ASSOCIATES, INC. 8453 NCTA - THE INTERNET & TELEVISION ASSOCIATION 2026 first_quarter COM Spectrum, broadband, defense Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-16T11:50:36-04:00
3821792 SQUIRE PATTON BOGGS b49f81fd-e745-4fe4-b840-a7964a5d16f4 Q1 SQUIRE PATTON BOGGS 30906 NEWSMAX 2026 first_quarter COM Work with Senate and House Armed Service and Appropriations committees to secure language related to the Pentagons use of mis-information monitors and media filters related to political bias; work on FCC statutory 39 percent national broadcast television Ownership Cap. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2026-04-16T11:56:55-04:00
3822394 TELEMEDIA POLICY CORP. db0e172c-b187-4614-b7e5-5bc2e64ae74d Q1 TELEMEDIA POLICY CORP. 86210 NEWSMAX, INC. F/K/A NEWSMAX MEDIA, INC. 2026 first_quarter COM Legislative & regulatory matters relating to carriage of independent cable television programmers. Federal Communications Commission (FCC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-16T14:24:12-04:00
3822404 TELEMEDIA POLICY CORP. 1817c897-b8c2-40df-9f45-69c82cd964ba Q1 TELEMEDIA POLICY CORP. 86210 PARAMOUNT GLOBAL 2026 first_quarter COM Regulatory matters and proceedings involving developments in the media marketplace. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-16T14:25:54-04:00
3822643 BG ADVOCACY, LLC 8862b085-dc79-4857-abe2-5a22e4493215 Q1 BG ADVOCACY, LLC 401108759 DISCOVERY COMMUNICATIONS LLC 2026 first_quarter COM Issues related to competition in the media marketplace   10000   0 0 2026-04-16T14:58:11-04:00
3822728 BALLARD PARTNERS, LLC 9b438bc9-faf9-4ca5-a12e-6c7bd0d02890 Q1 BALLARD PARTNERS, LLC 401104288 NETFLIX, INC. 2026 first_quarter COM Legislative and regulatory issues related to the media industry. White House Office 150000   0 0 2026-04-16T15:09:11-04:00
3822810 INTERSECT PUBLIC AFFAIRS, LLC 85c06e73-712e-4f4c-9f8f-753374575f29 Q1 INTERSECT PUBLIC AFFAIRS, LLC 401108969 CHARTER COMMUNICATIONS, INC. 2026 first_quarter COM General broadband related policies. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-16T15:19:09-04:00
3822824 INTERSECT PUBLIC AFFAIRS, LLC 283bb192-72f1-41c9-b0aa-7c6417e30444 Q1 INTERSECT PUBLIC AFFAIRS, LLC 401108969 DISCOVERY COMMUNICATIONS, LLC 2026 first_quarter COM Issues related to competition in the media marketplace. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2026-04-16T15:20:12-04:00
3822853 INTERSECT PUBLIC AFFAIRS, LLC 35f932e2-53e8-44d7-b6bc-a7fc62a5d0b6 Q1 INTERSECT PUBLIC AFFAIRS, LLC 401108969 T-MOBILE USA, INC. 2026 first_quarter COM Wireless infrastructure, spectrum and tax issues. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-16T15:22:52-04:00
3823259 VENABLE LLP 1fa50b01-e544-47ee-84ee-011355005b4e Q1 VENABLE LLP 39941 NAVIGATORS GLOBAL ON BEHALF OF NATIONAL PUBLIC RADIO 2026 first_quarter COM Issues relating to public radio emergency alerting services. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-16T16:46:40-04:00
3823375 DENTONS US LLP 0ed1965b-b91a-4ef1-ad25-11b2f04fb6b1 Q1 DENTONS US LLP 36105 TIKTOK USDS JOINT VENTURE LLC 2026 first_quarter COM Issues related to internet technology and learning-enabled platforms, including data protection and privacy, algorithm security and integrity, content moderation, software assurance, online safety, interoperability of global platforms, and small businesses and the economic impact of TikTok. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-16T17:16:29-04:00
3823643 DUNKEL GOVERNMENT RELATIONS 1148e0e5-d683-4c0e-80cc-389ae18cd5b4 Q1 DUNKEL GOVERNMENT RELATIONS 304337 DISH NETWORK LLC 2026 first_quarter COM Video issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-16T19:44:21-04:00
3823897 SALT POINT STRATEGIES 89ccc248-47a0-4290-a726-8131ccb2ec15 Q1 SALT POINT STRATEGIES 401105514 META PLATFORMS INC. 2026 first_quarter COM Issues related to broadband permitting and the creation of an unlicensed allocation in the 6 GHz spectrum band. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2026-04-17T08:35:18-04:00
3823943 CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE 73128e1e-317a-4d23-b63b-23efd5eb0116 Q1 CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE 47985 CONCERNED WOMEN FOR AMERICA LEGISLATIVE ACTION COMMITTEE 2026 first_quarter COM S.1748 - Kids Online Safety Act S.1586 - App Sore Accountability Act H.R.1623 - Shielding Children's Retinas from Egregious Exposure on the Net (SCREEN) Act HOUSE OF REPRESENTATIVES,SENATE   30000 0 0 2026-04-17T08:48:01-04:00
3824796 FS VECTOR LLC f5d11b2f-1e74-4fec-b490-f332668132b8 Q1 FS VECTOR LLC 401105148 DTH SATELLITE SERVICES, LLC 2026 first_quarter COM Matters related to the application of sanctions to satellite broadcasts and anti-piracy. HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 20000   0 0 2026-04-17T10:16:39-04:00
3824990 VAN SCOYOC ASSOCIATES 41a07378-5d61-410e-af43-40bbfe29b30e Q1 VAN SCOYOC ASSOCIATES 39837 COMCAST CORPORATION 2026 first_quarter COM Cybersecurity, supply chain, IoT, information sharing, and artificial intelligence issues. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2026-04-17T10:31:48-04:00
3825116 THE HOBBS GROUP, LLC d3a646db-8e88-452c-9f3f-ece9086cb247 Q1 THE HOBBS GROUP, LLC 294495 NATIONAL CABLE AND TELECOMMUNICATIONS ASSOCIATION 2026 first_quarter COM Open internet rules. Proposals/Legislation to address broadband adoption, funding, and deployment. Privacy. Permitting Reform. Spectrum policy. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2026-04-17T10:41:48-04:00
3825178 THE HOBBS GROUP, LLC 31e7f392-3906-4934-b19a-bc9d950b4636 Q1 THE HOBBS GROUP, LLC 294495 COMCAST CORPORATION 2026 first_quarter COM Open internet rules. Proposals/Legislation to address broadband adoption, funding, and deployment. Privacy. Permitting Reform. Spectrum policy. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2026-04-17T10:48:41-04: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 1763.1ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API