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

13,406 rows where filing_period = "second_quarter" and issue_code = "HOM" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

filing_year 18

  • 2025 976
  • 2008 864
  • 2018 785
  • 2009 776
  • 2020 752
  • 2015 748
  • 2017 747
  • 2014 742
  • 2019 727
  • 2022 724
  • 2012 721
  • 2013 717
  • 2010 716
  • 2016 713
  • 2021 700
  • 2011 676
  • 2024 663
  • 2023 659

issue_code 1

  • HOM · 13,406 ✖

filing_period 1

  • second_quarter · 13,406 ✖
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
3374709 WILLIAM A. COHAN, P.C. f171526c-1f0c-4c04-9808-af6e1ce941e5 2T WILLIAM A. COHAN, P.C. 401108280 TEKLIUM, INC. 2025 second_quarter HOM Communications regarding client's legal rights Justice, Dept of (DOJ)     0 1 2025-06-02T14:11:14-04:00
3374753 THE AMERICAN LEGION c4af2058-a1e8-4ce3-8ae5-5ae0ac1eb256 Q2 THE AMERICAN LEGION 2775 AMERICAN LEGION 2025 second_quarter HOM homeland security issues related to veterans HOUSE OF REPRESENTATIVES,SENATE   190000 0 0 2025-06-03T12:36:51-04:00
3375009 BECKER & POLIAKOFF, P.A. 2b4c554d-ced9-44c3-b8d1-3e3b16c65a43 Q2 BECKER & POLIAKOFF, P.A. 283696 CITY OF VIRGINIA BEACH, VA 2025 second_quarter HOM Homeland Security & FEMA, including support for emergency operation centers and regional fire and law enforcement facilities and training. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-06-11T13:42:46-04:00
3375017 BECKER & POLIAKOFF, P.A. 27ceeb28-8a93-428b-941e-471aec5c4a49 Q2 BECKER & POLIAKOFF, P.A. 283696 VIRGINIA PORT AUTHORITY 2025 second_quarter HOM Custom & Border Patrol issues. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-06-11T13:51:33-04:00
3375086 HOLLINGER GROUP CONSULTING aeaa659c-cf27-4958-8099-211865e5d1bf Q2 HOLLINGER GROUP CONSULTING 401108124 THERMOPACT 2025 second_quarter HOM mouthpiece with core temp Air Force, Dept of,Army, Dept of (Other),HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-06-16T10:58:37-04:00
3375162 PARRY LABS, LLC 1947ceb3-5003-48bc-9fb8-9861fd799d6d Q2 PARRY LABS, LLC 401107646 PARRY LABS, LLC 2025 second_quarter HOM FY26 Department of Homeland Security Appropriations Bill related to counter-IED technology. HOUSE OF REPRESENTATIVES,SENATE   160000 0 0 2025-06-20T11:27:44-04:00
3375349 THE NICKLES GROUP, LLC 90357446-d308-45d6-9d39-2ea37a9483c3 Q2 THE NICKLES GROUP, LLC 293335 LA 2028 -LOS ANGELES ORGANIZING COMMITTEE FOR OLYMPIC AND PARALYMPIC GAMES 2028 2025 second_quarter HOM Issues related to the security of the LA28 Olympics. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-06-26T17:08:01-04:00
3375402 ALTANA TECHNOLOGIES 5b93adcb-5d44-4de0-b7a0-888dd4249210 Q2 ALTANA TECHNOLOGIES 401109119 ALTANA TECHNOLOGIES 2025 second_quarter HOM General supply chain issues; General Artificial Intelligence issues including tax, supply chain, trade facilitation, fentanyl detection. HOUSE OF REPRESENTATIVES,SENATE   15000 0 0 2025-06-28T18:18:18-04:00
3375491 EDENS ADVISORY, LLC bd44529c-ddcf-4305-871a-76a4b2e12939 Q2 EDENS ADVISORY, LLC 83490 ADVANCED MEASUREMENT TECHNOLOGY 2025 second_quarter HOM Radiation detection devices in the FY25 House Department of Homeland Security bill Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES     0 0 2025-06-30T17:12:33-04:00
3375603 MCKINNON GROUP, LLC d628b0a9-2de8-4a31-926c-0dea3ac91fe4 Q2 MCKINNON GROUP, LLC 401109343 GRAY ANALYTICS, INC. 2025 second_quarter HOM Advocated for report language and funding in support of DHS/HSI via FY26 Homeland Security Appropriations. HOUSE OF REPRESENTATIVES 30000   0 0 2025-07-01T10:28:56-04:00
3375619 MCKINNON GROUP, LLC 09a81ea5-7826-41c1-9f89-ea1572f81f33 Q2 MCKINNON GROUP, LLC 401109343 ALLEN CONTROL SYSTEMS 2025 second_quarter HOM FY26 Homeland Security Appropriations HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-01T10:33:50-04:00
3375627 MCKINNON GROUP, LLC 5663dbca-5eb6-4d95-be14-fdf6685211d9 Q2 MCKINNON GROUP, LLC 401109343 SYZYGY INTEGRATION 2025 second_quarter HOM FY26 Homeland Security Appropriations HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-01T10:39:23-04:00
3375675 MCKINNON GROUP, LLC 7d7d3bac-82e0-4319-85a0-2cf8fea9637a Q2 MCKINNON GROUP, LLC 401109343 DYNAMIS, INC. 2025 second_quarter HOM FY26 Homeland Security Appropriations HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-01T11:10:00-04:00
3375693 LAW OFFICES OF GEORGE HARRIS, LLC 628af532-700d-40e1-a32f-daced5ee3ce3 2T LAW OFFICES OF GEORGE HARRIS, LLC 400871553 IRWIN COUNTY COMMISSION 2025 second_quarter HOM Advocate for congressionally directed spending and community project funding for critically needed local public safety needs with a federal nexus in FY2025 and FY2026 appropriation bills and continuing resolutions, including full body scanners for local detention facility utilized for federal immigration inmates and mobile telecommunication equipment and tower; advocate for pre-disaster mitigation funding for use in local detention facilities Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE 5000   0 1 2025-07-01T11:44:44-04:00
3375762 VENABLE LLP fb0b9348-abd1-4355-a443-5688553d4b45 Q2 VENABLE LLP 39941 BERKSHIRE HATHAWAY ENERGY 2025 second_quarter HOM Counter-UAS authorities HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-01T13:24:05-04:00
3375798 MR. BALTAZAR SERNA, JR. c5022a38-95a1-4ff2-be00-11f7443e7147 Q2 MR. BALTAZAR SERNA, JR. 40009064 CITY OF SAN ANTONIO 2025 second_quarter HOM FY2025-2026 Homeland Security Appropriations Act, USAI funding Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 11250   0 0 2025-07-01T13:55:14-04:00
3375821 DA VINCI GROUP 311e6d1e-ddfd-45f7-beaa-4ec91a08b20b Q2 DA VINCI GROUP 11548 EASTERN AIRLINE HOLDINGS 2025 second_quarter HOM Border Security Issues Homeland Security, Dept of (DHS) 30000   0 0 2025-07-01T14:47:50-04:00
3375907 23 CONSULTING, LLC 05775588-3787-477e-a113-ad826c3a51e8 Q2 23 CONSULTING, LLC 401106371 TECNOLOGIAS RELACIONADAS CON ENERGIA Y SERVICIOS ESPECIALIZADOS SA DE CV (TRESE 2025 second_quarter HOM There were no bill numbers. My lobbying activities were to raise awareness to injustice that TRESE experienced in Mexico and how that injustice directly impacted the U.S. and its interests. HOUSE OF REPRESENTATIVES     0 0 2025-07-01T18:32:49-04:00
3376164 REPUBLIC CONSULTING, LLC f511089f-02a8-402e-b630-c620372db724 Q2 REPUBLIC CONSULTING, LLC 401016871 G3 TECHNOLOGIES, INC. 2025 second_quarter HOM Monitor budget and policy on sensor technology. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-02T14:06:17-04:00
3376191 HILLSBOROUGH COUNTY AVIATION AUTHORITY e7fedf83-da19-4a50-bedc-3570c9e52a9a Q2 HILLSBOROUGH COUNTY AVIATION AUTHORITY 305431 HILLSBOROUGH COUNTY AVIATION AUTHORITY 2025 second_quarter HOM CBP technology, EDS funding, Exit lane funding, aviation worker screening, CBP staffing Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE   36000 0 0 2025-07-02T14:50:47-04:00
3376303 THE MAJORITY GROUP, LLC 391f673c-c2ae-46b1-86bd-5b88a89138c8 Q2 THE MAJORITY GROUP, LLC 400713141 SHORELIGHT EDUCATION 2025 second_quarter HOM Legislative and regulatory issues impacting international education in the US. HOUSE OF REPRESENTATIVES,SENATE 54000   0 0 2025-07-03T10:20:36-04:00
3376337 BUTLER SNOW LLP 9073ecc2-e3d1-4e94-b1b2-c03b589b9a50 Q2 BUTLER SNOW LLP 400421012 BASIS PATH 2025 second_quarter HOM Department of Homeland Security and issues related thereto. HOUSE OF REPRESENTATIVES,SENATE 19500   0 0 2025-07-03T11:15:40-04:00
3376662 HOLLAND & KNIGHT LLP 83b4f25a-eb6e-4696-841e-c5919e18a8a3 Q2 HOLLAND & KNIGHT LLP 18466 CITY OF SAN JOSE, CA 2025 second_quarter HOM Issues related to FIFA and Homeland Security Preparedness Grants. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-04T13:41:23-04:00
3376800 NATIONAL GROUP, LLP 6f3bde51-fe76-4ba8-8a44-7d5f8fe8ebeb Q2 NATIONAL GROUP, LLP 66090 908 DEVICES, INC. 2025 second_quarter HOM Border Technology Funding HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-06T09:49:22-04:00
3376986 CHRISTIANS UNITED FOR ISRAEL ACTION FUND 1decf081-df72-4c03-9cf9-806f5e335056 Q2 CHRISTIANS UNITED FOR ISRAEL ACTION FUND 401104012 CHRISTIANS UNITED FOR ISRAEL ACTION FUND 2025 second_quarter HOM FY 2026 Homeland Security Appropriations (Nonprofit Security Grant Program) HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2025-07-07T09:59:45-04:00
3377016 ADAMS AND REESE, LLP 396dbe0a-2c32-4712-8d6d-515ea72092a7 Q2 ADAMS AND REESE, LLP 157 GNO, INC. 2025 second_quarter HOM Federal government relations services regarding legislative issues including, but not limited to flood insurance, energy, and economic development Energy, Dept of,Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 20000   0 0 2025-07-07T10:32:06-04:00
3377023 NAVY LEAGUE OF THE UNITED STATES 55a7f2bf-de64-46eb-ad3b-22b0cb1554ab Q2 NAVY LEAGUE OF THE UNITED STATES 28903 NAVY LEAGUE OF THE UNITED STATES 2025 second_quarter HOM $7 billion for Coast Guard Shoreside Infrastructure, Support the SHIPS for America Act, $20 billion annual Coast Guard Budget, Increase Coast Guard aviation maintenance funding from ~$1.2 billion to $3 billion     27500 0 0 2025-07-07T10:34:03-04:00
3377207 WESTMORELAND160, LLC 43c5c831-f735-4642-bf05-24574ba6d609 Q2 WESTMORELAND160, LLC 401104802 SECURE COMMUNICATION SYSTEMS DBA BENCHMARK SECURE TECHNOLOGY 2025 second_quarter HOM Mobile Video Surveillance Systems (MVSS-R) for Customs and Border Protection Radar and Counter Unmanned Aerial Systems enhancements to MVSS program House Fiscal Year 2026 Department of Homeland Security Appropriations Act (H.R. TBD) Senate Fiscal year 2026 Department of Homeland Security Appropriations Act (S. TBD) H.R. 1 - The One Big, Beautiful Bill Act (Provisions related to border technology) HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-07T14:28:10-04:00
3377211 WESTMORELAND160, LLC 1adc5e26-97d3-468f-8aa6-b412d0454c30 Q2 WESTMORELAND160, LLC 401104802 SRC INC. 2025 second_quarter HOM Radar and Counter Unmanned Aerial Systems enhancements to the mobile Video Surveillance System (MVSS) House Fiscal Year 2026 Department of Homeland Security Appropriations Act (H.R. TBD) Senate Fiscal year 2026 Department of Homeland Security Appropriations Act (S. TBD) H.R. 1 - The One Big, Beautiful Bill Act (Provisions related to border technology) HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-07T14:35:46-04:00
3377246 WESTMORELAND160, LLC 2c85c60e-81f7-4b16-b678-5bf0fa5a61c8 Q2 WESTMORELAND160, LLC 401104802 SKYSHIP SERVICES INC. 2025 second_quarter HOM Aerostat Programs Intelligence, Surveillance and Reconnaissance (ISR) House Fiscal Year 2026 Department of Homeland Security Appropriations Act (H.R.TBD) Senate Fiscal Year 2026 Department of Homeland Security Appropriations Act (S.TBD) H.R. 1 - The One Big, Beautiful Bill Act (provisions related to border technology) HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-07T15:20:04-04:00
3377327 PORTER GROUP, LLC 65d92c4f-1d3d-490c-ae3a-acd822bd9e27 Q2 PORTER GROUP, LLC 400745228 CERTUS CORE 2025 second_quarter HOM Request Homeland Security appropriations go towards vendor threat mitigation data analysis. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-07T18:36:45-04:00
3377335 PORTER GROUP, LLC a0ed6f2b-05de-4834-9a5a-d0902ca57192 Q2 PORTER GROUP, LLC 400745228 COLERIDGE INITIATIVE 2025 second_quarter HOM Discussing data analytics and AI in government reporting requirements. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-07T18:59:31-04:00
3377397 SQUIRE PATTON BOGGS f7ed1b1d-814c-48f3-83c8-57483b40171b Q2 SQUIRE PATTON BOGGS 30906 HELLEN SYSTEMS, LLC 2025 second_quarter HOM Development of a US Government public-private partnership to provide a back-up system for GPS; issues related to the provision in the Coast Guard Authorization Act; monitor Trump nominations and appointments, 119th Congress leadership; FY 26 appropriations. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 60000   0 0 2025-07-08T08:57:36-04:00
3377414 SQUIRE PATTON BOGGS ce7e95e1-165e-481e-bfc2-8972a03fd107 Q2 SQUIRE PATTON BOGGS 30906 XCELERATE SOLUTIONS 2025 second_quarter HOM Outreach to Homeland Security and Congress on Transportation on TSA privatization. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-08T09:18:05-04:00
3377443 SYENSQO USA LLC 4fa7d1e8-065b-408a-8203-e3dfe529ce20 Q2 SYENSQO USA LLC 400408933 SYENSQO USA LLC 2025 second_quarter HOM Pub. L. 71-361, Tariff Act of 1930, including provisions related to the enforcement of forced labor regulations by Customs and Border Protection. H.R. 4470 and S. 2178, legislation to extend the Chemical Facility Anti-Terrorism Standards Program of the Department of Homeland Security, and for other purposes.     220000 0 0 2025-07-08T09:40:55-04:00
3377496 THE NORMANDY GROUP, LLC 0f422f75-8d71-4108-b378-9f9a7c69ca9e Q2 THE NORMANDY GROUP, LLC 306636 CITY OF EAGLE PASS, TEXAS 2025 second_quarter HOM Pursued AFG; Presidential Permit Application Support HOUSE OF REPRESENTATIVES,SENATE,White House Office 30000   0 0 2025-07-08T10:44:55-04:00
3377565 THE NORMANDY GROUP, LLC c464d968-1814-496b-8704-a25b15baa25a Q2 THE NORMANDY GROUP, LLC 306636 AMERICAN SYSTEMS CORPORATION 2025 second_quarter HOM Supported federal funding for CBP IV&V Program, informational HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-08T11:44:40-04:00
3377674 AMERICAN ASSOCIATION OF PORT AUTHORITIES d1b38bf9-4f2b-4ec4-b0bc-68e580e9d14a Q2 AMERICAN ASSOCIATION OF PORT AUTHORITIES 1683 AMERICAN ASSOCIATION OF PORT AUTHORITIES 2025 second_quarter HOM Issues related to Port Security and U.S. Customs and Border Protection. Issues related to Unmanned Aerial Systems. Secure Our Ports Act Port Crane Security and Inspection Act Implementation of the National Defense Authorization Act for FY 2026 Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT),U.S. Coast Guard (USCG),U.S. Customs & Border Protection   73084 0 0 2025-07-08T13:38:16-04:00
3377827 HORIZONS GLOBAL SOLUTIONS LLC 97772cb7-65b9-427a-beaf-fa536a645f5f Q2 HORIZONS GLOBAL SOLUTIONS LLC 401106159 YULISTA INTEGRATED SOLUTIONS LLC 2025 second_quarter HOM FY2026 policy and Appropriations HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-08T15:55:13-04:00
3377852 HORIZONS GLOBAL SOLUTIONS LLC 1de022be-619a-4090-91ac-c361401641a1 Q2 HORIZONS GLOBAL SOLUTIONS LLC 401106159 INVARIANT CORPORATION 2025 second_quarter HOM FY2026 policy and Appropriations HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2025-07-08T16:36:56-04:00
3377869 D&P CREATIVE STRATEGIES, LLC c49c5c2b-0cf8-4252-a2fc-f9d4b626b0e6 Q2 D&P CREATIVE STRATEGIES, LLC 304554 MICROSOFT CORPORATION 2025 second_quarter HOM Cyber Security, Bulk Data collection, Surveillance, ECPA, Lawful Access HOUSE OF REPRESENTATIVES 50000   0 0 2025-07-08T16:55:37-04:00
3378287 CORNERSTONE GOVERNMENT AFFAIRS, INC. 17ab1c26-7d5a-4b9a-baf4-4b589c0d02bc Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 HUNT DEVELOPMENT GROUP LLC 2025 second_quarter HOM Coast Guard Reauthorization. HOUSE OF REPRESENTATIVES,SENATE 140000   0 0 2025-07-09T13:03:26-04:00
3378306 ASSOCIATION OF METROPOLITAN WATER AGENCIES 0432a5e9-6bad-4b36-9e26-936a1361da91 Q2 ASSOCIATION OF METROPOLITAN WATER AGENCIES 4631 ASSOCIATION OF METROPOLITAN WATER AGENCIES 2025 second_quarter HOM H.R. 2344/S. 1118, the Water Information, Security, and Cyber Threat Protection Act H.R. 2594, the Water Risk and Resilience Organization Establishment Act HOUSE OF REPRESENTATIVES,SENATE   90000 0 0 2025-07-09T13:11:00-04:00
3378310 CORNERSTONE GOVERNMENT AFFAIRS, INC. d1013289-1e43-438b-886f-14e042a3d2e9 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 COVENANT AVIATION SECURITY 2025 second_quarter HOM Issues related to the Transportation Security Agency (TSA) Screening Partnership Program. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-09T13:12:08-04:00
3378313 CORNERSTONE GOVERNMENT AFFAIRS, INC. ac573c7a-5dd2-48ea-b6ce-d9fd5edf2f57 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 S2 GLOBAL, INC. 2025 second_quarter HOM Issues related to funding for Homeland Security. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-09T13:14:01-04:00
3378432 GRANT CONSULTING GROUP 937f7b2c-8e50-4095-834d-c08167a43d2c Q2 GRANT CONSULTING GROUP 89155 BIOKO SCIENCE AND TECHNOLOGY 2025 second_quarter HOM bio defense HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-09T14:38:42-04:00
3378461 FEDERAL SOLUTIONS, LLC 648bab8b-8c41-4287-914a-4ecbc5392fc9 Q2 FEDERAL SOLUTIONS, LLC 311371 MISSISSIPPI STATE UNIVERSITY 2025 second_quarter HOM Homeland Security Appropriations: Provisions relating to research and development HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-09T15:06:08-04:00
3378593 ARK STRATEGY 0c34b51c-354a-47e5-ae67-fc33d4886970 Q2 ARK STRATEGY 401108659 OVERWATCH IMAGING, INC. 2025 second_quarter HOM Provisions in the USCG Reauthorization act related to maritime domain awareness, counter-narcotics, and search and rescue. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-09T16:50:59-04:00
3378778 CORNERSTONE GOVERNMENT AFFAIRS, INC. 1c0289cf-8c21-4a3d-bc93-0017b923868c Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 BDR SOLUTIONS, LLC 2025 second_quarter HOM Support for IT programs at the Departments of Veterans Affairs & Homeland Security. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-10T09:10:56-04:00
3378795 A1.9 STRATEGIES LLC d09afa49-00ae-4969-9e66-a6795e786590 Q2 A1.9 STRATEGIES LLC 401104281 TELEDYNE FLIR (FORMERLY FLIR SYSTEMS INC AND SUBSIDIARIES) 2025 second_quarter HOM DHS/CBP acquisition and program development of next generation surveillance vehicles and detection capabilities for border security and WMD deterrence/detection. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-10T09:37:10-04:00
3378797 A1.9 STRATEGIES LLC bd1c1938-4615-4144-b98a-21aea5ee91da Q2 A1.9 STRATEGIES LLC 401104281 ANALOGIC CORPORATION 2025 second_quarter HOM Support for adoption/funding of next generation TSA cabin baggage screening technologies. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-10T09:38:59-04:00
3378806 A1.9 STRATEGIES LLC d1ac5e9b-834a-497e-810c-46e1e005d2ad Q2 A1.9 STRATEGIES LLC 401104281 VIKEN DETECTION 2025 second_quarter HOM Support for CBP rapid adoption, investment, and deployment of next generation vehicle screening technologies at ports of entry, including under vehicle and backscatter X-ray technologies. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-10T09:53:10-04:00
3378825 CORNERSTONE GOVERNMENT AFFAIRS, INC. 9b9192e9-4ca3-4edd-81d7-87ff8d30b8e2 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 UNITED NEGRO COLLEGE FUND, INC. 2025 second_quarter HOM Identify and grow congressional champions to support UNCF mission and priorities, to include legislation and funding opportunities pertaining to higher education and historically black colleges and universities. HOUSE OF REPRESENTATIVES 20000   0 0 2025-07-10T10:02:27-04:00
3378828 A1.9 STRATEGIES LLC e9d41cc7-e9fd-4699-95a3-566205ddb1db Q2 A1.9 STRATEGIES LLC 401104281 BATTELLE MEMORIAL INSTITUTE 2025 second_quarter HOM Support for National Biodefense Analysis and Countermeasures Center; adoption of clandestine armored vehicles. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-10T10:04:20-04:00
3378832 CORNERSTONE GOVERNMENT AFFAIRS, INC. 5c78d79b-28ff-460b-ab4c-ae1e95afdb84 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 BOSSIER PARISH POLICE JURY 2025 second_quarter HOM Increasing Bossier Parish's visibility as a national security policy, research, and innovation hub among key federal policymakers within the legislative and executive branches (including departments and agencies); support business development goals and objectives, and diversify funding opportunities; and help with their strategic growth, partnerships and national security presence in the shape of roundtables, fora, symposiums, and HBCU and higher ed engagement. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-07-10T10:05:02-04:00
3378846 A1.9 STRATEGIES LLC 00632f8a-928b-449a-a8d3-d6e9ad046afe Q2 A1.9 STRATEGIES LLC 401104281 THRUVISION AMERICA 2025 second_quarter HOM TSA/CBP adoption of person stand-off screening detection technologies. HOUSE OF REPRESENTATIVES 15000   0 0 2025-07-10T10:12:40-04:00
3378854 A1.9 STRATEGIES LLC ede3fd46-1f69-449e-81a5-f4cfe60eee54 Q2 A1.9 STRATEGIES LLC 401104281 CACI INTERNATIONAL, INC 2025 second_quarter HOM DHS tactical communications systems. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-10T10:32:26-04:00
3378874 A1.9 STRATEGIES LLC 2627ba0b-c0b1-44be-918c-e3e343e255b6 Q2 A1.9 STRATEGIES LLC 401104281 GENERAL ATOMICS 2025 second_quarter HOM U.S. Coast Guard and CBP adoption of Medium-Altitude Long-Endurance Unmanned Aircraft Systems. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-10T10:52:02-04:00
3378900 CORNERSTONE GOVERNMENT AFFAIRS, INC. e8aa11d6-f17d-4940-ba00-2912921c9428 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 FAMILY ENDEAVORS, INC. 2025 second_quarter HOM Introducing client to government stakeholders; issues regarding veterans affairs, mental health, disaster recovery, migrant services and case management. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-10T11:15:47-04:00
3378913 CORNERSTONE GOVERNMENT AFFAIRS, INC. 2a266960-5b3b-4b26-8100-9ec907bb0f3a Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 PRESCIENT EDGE 2025 second_quarter HOM Fiscal year 2024 funding for Homeland Security programs. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-10T11:25:16-04:00
3378917 CORNERSTONE GOVERNMENT AFFAIRS, INC. db72fae1-327a-4ad0-80f2-43f7ed960473 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 TARGET HOSPITALITY CORP. 2025 second_quarter HOM Advocating for housing and hospitality solutions. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-10T11:26:26-04:00
3378995 STRATEGIC MARKETING INNOVATIONS 8e4b3286-10de-4a68-93e0-e2e563c9f6f2 Q2 STRATEGIC MARKETING INNOVATIONS 60550 STEALTH SOFTWARE TECHNOLOGIES 2025 second_quarter HOM Research and development funding for federal government cybersecurity topics, including encrypted computing, communications, and data analytics applications Defense, Dept of (DOD),Energy, Dept of,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) 10000   0 0 2025-07-10T12:29:59-04:00
3379056 KASOWITZ LLP 5fb8f527-b037-4dd4-950e-0675d71a207a Q2 KASOWITZ LLP 401103221 SPECTROHM, INC. 2025 second_quarter HOM Security issues. HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-07-10T13:15:37-04:00
3379096 CORNERSTONE GOVERNMENT AFFAIRS, INC. 9a529104-8606-4acc-8603-e3c2d80140f6 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 GLOBAL BUSINESS TRAVEL ASSOCIATION 2025 second_quarter HOM Transportation Security Agency funding and reauthorization, Visa Waiver Program, Sustainable Skies Act, Real ID, reopening the U.S.to international travelers; FAA Reauthorization. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-10T13:48:28-04:00
3379157 NATIONAL ROOFING CONTRACTORS ASSOCIATION 4d89fd59-5151-4192-ad2d-c9b4007ad676 Q2 NATIONAL ROOFING CONTRACTORS ASSOCIATION 28504 NATIONAL ROOFING CONTRACTORS ASSOCIATION 2025 second_quarter HOM Support increase in H2-B visas by the Department of Homeland Security Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE   200000 0 0 2025-07-10T14:14:15-04:00
3379267 CASSIDY & ASSOCIATES, INC. 0a414a47-44f8-4343-a5ae-6e679ded3fa6 Q2 CASSIDY & ASSOCIATES, INC. 8453 PERATON 2025 second_quarter HOM FY2026 National Defense Authorization Act, FY2026 Appropriations HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-10T14:58:11-04:00
3379279 SQUIRE PATTON BOGGS 4bde6654-bbba-4d86-afae-8e5a0710aaff Q2 SQUIRE PATTON BOGGS 30906 BEYONDTRUST CORPORATION 2025 second_quarter HOM Digital safety and cybersecurity initiatives. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2025-07-10T15:01:59-04:00
3379297 WHO DAT STRATEGIES LLC 84d57ec2-e973-4b2b-9c3f-44672ba7e4b8 Q2 WHO DAT STRATEGIES LLC 401106439 CJ LAKE LLC ON BEHALF OF BART 2025 second_quarter HOM Education and outreach related to Transit Security Grant Program funding. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-10T15:10:03-04:00
3379330 NOKIA OF AMERICA CORPORATION 1ee4dc11-f886-4446-8567-5d9c8ee4ea38 Q2 NOKIA OF AMERICA CORPORATION 29380 NOKIA OF AMERICA CORPORATION 2025 second_quarter HOM Industry supply chain security processes; component sourcing; semiconductor supply. HOUSE OF REPRESENTATIVES,SENATE   160000 0 0 2025-07-10T15:16:47-04:00
3379453 HOLLAND & KNIGHT LLP 0a021d4a-54c6-445d-b07a-3673110cc87f Q2 HOLLAND & KNIGHT LLP 18466 CITY OF CLEVELAND 2025 second_quarter HOM Assistance to Firefighters Grants program extension. Homeland Security, Dept of (DHS) 50000   0 0 2025-07-10T16:01:04-04:00
3379457 HOWE STREET GROUP LLC 1725a482-1783-4036-a5cc-15edd2931cf1 Q2 HOWE STREET GROUP LLC 401109111 KC2026 2025 second_quarter HOM Discussions about security surrounding 2026 FIFA World Cup matches in Kansas City. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-10T16:04:51-04:00
3379485 KASOWITZ LLP 310752e7-0700-4f6c-bde2-a63d1bc8b42d 2A KASOWITZ LLP 401103221 SPECTROHM, INC. 2025 second_quarter HOM Security issues. HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-07-10T16:11:25-04:00
3379523 NORTH BRIDGE STRATEGIC (FORMERLY KNOWN AS SCISSORTAIL STRATEGIC CONSULTING PARTN e4de7b2e-c75a-45ba-8602-14c7bee3b010 Q2 NORTH BRIDGE STRATEGIC (FORMERLY KNOWN AS SCISSORTAIL STRATEGIC CONSULTING PARTN 401109091 BEAVERFIT NORTH AMERICA, LLC 2025 second_quarter HOM H.R. 4213 - Making appropriations for the Department of Homeland Security for the fiscal year ending September 30, 2026, and for other purposes. Lobbying activities related to funding for visit, board, search, and seizure training apparatuses for the U.S. Coast Guard. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-10T16:25:43-04:00
3379529 NORTH BRIDGE STRATEGIC (FORMERLY KNOWN AS SCISSORTAIL STRATEGIC CONSULTING PARTN d4e00a5a-e88d-4840-b9fa-c5f908073bfb Q2 NORTH BRIDGE STRATEGIC (FORMERLY KNOWN AS SCISSORTAIL STRATEGIC CONSULTING PARTN 401109091 CAPCVENTURES LLC ON BEHALF OF TCOM LP 2025 second_quarter HOM H.R. 4213 - Making appropriations for the Department of Homeland Security for the fiscal year ending September 30, 2026, and for other purposes. Lobbying activities related to aerostats by U.S. Customs and Border Protection. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-10T16:30:07-04:00
3379745 THE PRENDA GROUP LLC 6338ff61-2e4f-4193-9172-c4d592a15f06 Q2 THE PRENDA GROUP LLC 401104543 LEONARDO US CYBER AND SECURITY SOLUTIONS LLC. (FORMERLY SELEX ES INC.) 2025 second_quarter HOM Monitoring legislation concerning the use of new technologies for law enforcement in particular Leading edge License Plate Readers (LPR) Monitoring House and Senate Committees on Appropriations, Homeland Security, Law enforcement program funding. Monitoring Federal Law Enforcement Agency appropriations Homeland Security. Homeland Security and Customs and Border Patrol programs. HR 1 monitoring. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-11T10:16:32-04:00
3379748 HORIZONS GLOBAL SOLUTIONS LLC 0aa3d899-9aad-401c-bd5e-52692bdb4c9d 2A HORIZONS GLOBAL SOLUTIONS LLC 401106159 YULISTA INTEGRATED SOLUTIONS LLC 2025 second_quarter HOM FY2026 Appropriations Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-11T10:16:42-04:00
3379798 NATIONAL CHICKEN COUNCIL c466c411-3776-42e6-b8c2-ff5d9e19c192 Q2 NATIONAL CHICKEN COUNCIL 27310 NATIONAL CHICKEN COUNCIL 2025 second_quarter HOM Immigration Reform Temporary Protected Status (TPS) program CHNV Parole Program HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,White House Office   100000 0 0 2025-07-11T10:43:30-04:00
3379888 NATIONAL CHICKEN COUNCIL c9087541-4034-4146-9136-02a60f39ff29 2A NATIONAL CHICKEN COUNCIL 27310 NATIONAL CHICKEN COUNCIL 2025 second_quarter HOM Immigration Reform Temporary Protected Status (TPS) program CHNV Parole Program HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,White House Office   100000 0 0 2025-07-11T11:25:42-04:00
3379922 CASSIDY & ASSOCIATES, INC. 13c571e7-48b0-421d-bd02-46e73e5d3e87 Q2 CASSIDY & ASSOCIATES, INC. 8453 SWITCH 2025 second_quarter HOM Implementation of the Federal Data Center Enhancement Act HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-11T11:47:33-04:00
3379985 SKYLINE CAPITOL LLC 8e54e044-36f2-4582-957a-d9727174f792 Q2 SKYLINE CAPITOL LLC 401108050 KENAI DEFENSE COMPANY LLC 2025 second_quarter HOM Issues regarding military defense innovation, technology commercialization, testing and evaluation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-11T12:52:22-04:00
3380000 STRATEGIC MARKETING INNOVATIONS 25ab328f-8aea-465d-8a1e-3026d07b8afd 2A STRATEGIC MARKETING INNOVATIONS 60550 FINCANTIERI MARINE GROUP LLC 2025 second_quarter HOM Navy shipbuilding programs Defense, Dept of (DOD),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE 110000   0 0 2025-07-11T12:57:33-04:00
3380046 STRATEGIC MARKETING INNOVATIONS a5a103e6-3c49-422e-9f99-1543d09bc52a Q2 STRATEGIC MARKETING INNOVATIONS 60550 MICHIGAN WHEEL 2025 second_quarter HOM FY26 appropriations; U.S. Navy and Coast Guard procurement; U.S. maritime industrial base policy Defense, Dept of (DOD),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE,U.S. Coast Guard (USCG) 50000   0 0 2025-07-11T13:35:39-04:00
3380051 ROBOTIC RESEARCH OPCO, LLC (DBA FORTERRA) 6d94fdc7-77f9-4c86-8872-1b6084e70acd Q2 ROBOTIC RESEARCH OPCO, LLC (DBA FORTERRA) 401106886 ROBOTIC RESEARCH OPCO, LLC (DBA FORTERRA) 2025 second_quarter HOM Issues relating to autonomous ground vehicles for homeland security. HOUSE OF REPRESENTATIVES,SENATE   90000 0 0 2025-07-11T13:37:02-04:00
3380062 STRATEGIC MARKETING INNOVATIONS 919829fb-6116-4ac7-880b-7dc840469cbb Q2 STRATEGIC MARKETING INNOVATIONS 60550 SHINE TECHNOLOGIES (FKA PHOENIX, LLC) 2025 second_quarter HOM Research and development programs related to neutron radiography and inspection technology Fusion energy applications Army, Dept of (Other),Defense, Dept of (DOD),Energy, Dept of,Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Navy, Dept of,SENATE 30000   0 0 2025-07-11T13:45:19-04:00
3380153 THE PICARD GROUP, LLC f83200ba-497e-4327-9754-5a23983aae22 Q2 THE PICARD GROUP, LLC 400711132 LAKE CHARLES REGIONAL AIRPORT 2025 second_quarter HOM Support airport security needs HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-11T15:31:42-04:00
3380263 KASOWITZ LLP 7e9f8d8b-35b5-428d-9de8-e8e5a336e75e Q2 KASOWITZ LLP 401103221 INSTITUTE FOR THE STUDY OF GLOBAL ANTISEMITISM AND POLICY 2025 second_quarter HOM Issues related to contemporary antisemitism and the timely and accurate reporting of foreign donations to the Department of Education, and FARA registrations. HOUSE OF REPRESENTATIVES,SENATE 54000   0 0 2025-07-11T17:20:40-04:00
3380527 HOLLAND & KNIGHT LLP eb1fe14a-c0a0-4465-99c6-5215b8f42571 Q2 HOLLAND & KNIGHT LLP 18466 ORANGE COUNTY FIRE AUTHORITY 2025 second_quarter HOM H.R. 4213 - FY 2026 Homeland Security Appropriations; Urban Search & Rescue funding; first responder drones. Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-13T11:32:14-04:00
3380531 HOLLAND & KNIGHT LLP 4d104e44-582f-45d9-bff3-5de135949d73 Q2 HOLLAND & KNIGHT LLP 18466 SACRAMENTO METROPOLITAN FIRE DISTRICT 2025 second_quarter HOM H.R. 4213 - FY 2026 Homeland Security Appropriations Urban Search & Rescue. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-13T11:40:17-04:00
3380790 VECTIS DC f2befb04-198f-448c-ba8a-2a7f40da3222 Q2 VECTIS DC 401105021 ROSE BOWL OPERATING COMPANY 2025 second_quarter HOM Anti-drone legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-14T09:23:33-04:00
3380996 SQUIRE PATTON BOGGS 28d6d7a1-67ed-4511-ab67-34054bcb19d2 Q2 SQUIRE PATTON BOGGS 30906 SOUTHWEST AIRLINES 2025 second_quarter HOM Issues surrounding aviation and airport security   80000   0 0 2025-07-14T10:52:32-04:00
3381229 LUKE HOLDING, INC. be0c2102-b462-4f2e-99f6-0438ea3d315a Q2 LUKE HOLDING, INC. 401108052 LUKE HOLDING, INC. 2025 second_quarter HOM Homeland on immigration activities and migrant services and for Defense on military medicine and behavioral health. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2025-07-14T12:30:39-04:00
3381315 CORNERSTONE GOVERNMENT AFFAIRS, INC. e1046de3-5a19-4f32-a957-feea2343d03f Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 SMX (FKA SMARTRONIX) 2025 second_quarter HOM Defense, National Defense Authorization Act Appropriations. Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-14T13:10:43-04:00
3381353 D INITIATIVES LLC 6a340277-b953-4ca0-80f7-8ea1415198c1 Q2 D INITIATIVES LLC 12141 FAMA/FEMSA GOVERNMENTAL AFFAIRS COMMITTEE 2025 second_quarter HOM FY 2025 Appropriations for the Department of Homeland Security, specially the AFG, SAFER, and U.S.A.R., programs. The AFG program provides grants to volunteer, combined and career fire departments for critical fire and rescue equipment; SAFER provides funds to fire departments to hire additional first responders; the U.S. Fire Administration provides technical assistance to fire and rescue departments; and the U.S.A.R. program trains and funds a set of local first responder teams that can be deployed by the federal government to respond to all-hazard events. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-07-14T13:28:34-04:00
3381403 A1.9 STRATEGIES LLC e22d9d99-8899-4887-b6a8-6d468cfff13b Q2 A1.9 STRATEGIES LLC 401104281 CHANTIER DAVIE CANADA INC. 2025 second_quarter HOM Civilian and Defense shipbuilding and maritime matters, including ICE Pact implementation. HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),Office of Management & Budget (OMB),Office of the Vice President of the United States,SENATE,State, Dept of (DOS) 50000   0 0 2025-07-14T13:40:22-04:00
3381433 A1.9 STRATEGIES LLC 81207d57-9a87-4440-aa40-aa9f8c2777a4 Q2 A1.9 STRATEGIES LLC 401104281 SAILDRONE INC. 2025 second_quarter HOM Educate Members of Congress on autonomous maritime vehicles and advocate for the use of innovative, advanced technology for maritime domain awareness in the FY26 Department of Homeland Security appropriations bill. Discussed regulatory policy for Autonomous Uncrewed Surface Vehicles. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-14T13:46:06-04:00
3381448 STRATEGIC MARKETING INNOVATIONS faa1e927-52bf-4d94-8c2d-ccd6518a35fb Q2 STRATEGIC MARKETING INNOVATIONS 60550 MONTANA STATE UNIVERSITY 2025 second_quarter HOM Cybersecurity, TechTransfer HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T13:51:56-04:00
3381463 STRATEGIC MARKETING INNOVATIONS bb8ad161-7899-41f6-8ac6-cc84b9daddba Q2 STRATEGIC MARKETING INNOVATIONS 60550 UNIVERSITY OF ARKANSAS AT LITTLE ROCK 2025 second_quarter HOM Modeling and machine learning HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T13:55:09-04:00
3381490 CAPITOL STRATEGIES, LLC c0c10b80-4226-407e-a572-9df4a258149f Q2 CAPITOL STRATEGIES, LLC 400625900 RACY & ASSOCIATES (ON BEHALF OF PIMA COUNTY) 2025 second_quarter HOM FEMA funding for the Lee Moore Wash HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-07-14T14:05:27-04:00
3381831 DIROMA ECK & CO. LLP 0bfeba33-7321-4e91-b7d4-acc1e2f0fb6d Q2 DIROMA ECK & CO. LLP 401105820 ARETE 2025 second_quarter HOM Policies and potential legislation involving cybersecurity and ransomware HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-14T15:30:19-04:00
3381915 MERCURY PUBLIC AFFAIRS, LLC 42165860-cec4-47e9-93fc-11fb3b970717 Q2 MERCURY PUBLIC AFFAIRS, LLC 70175 FLOCK GROUP INC D/B/A FLOCK SAFETY 2025 second_quarter HOM issues related to safety and security HOUSE OF REPRESENTATIVES,Office of Administration,SENATE 120000   0 0 2025-07-14T15:57:33-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 3273.306ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API