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

2,279 rows where filing_period = "third_quarter" and issue_code = "TAR" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filing_type, is_termination, received_date (date)

filing_year 18

  • 2025 346
  • 2018 195
  • 2019 190
  • 2020 166
  • 2010 152
  • 2012 141
  • 2021 136
  • 2022 128
  • 2013 121
  • 2023 105
  • 2009 102
  • 2024 101
  • 2017 95
  • 2014 90
  • 2015 72
  • 2011 71
  • 2016 67
  • 2008 1

issue_code 1

  • TAR · 2,279 ✖

filing_period 1

  • third_quarter · 2,279 ✖
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
3425073 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL daaa58c3-cb9e-408b-9933-1593adad8fd0 Q3 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2025 third_quarter TAR We ask you to consider the impact tariffs will have on American businesses and your constituents, to share these concerns with the White House, and to do what you can to help prevent the loss of American jobs. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-08-26T15:17:58-04:00
3425963 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL d02f99bd-a3af-4597-99f8-86dbd4606277 3A PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2025 third_quarter TAR We ask you to consider the impact tariffs will have on American businesses and your constituents, to share these concerns with the White House, and to do what you can to help prevent the loss of American jobs. HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   50000 0 0 2025-09-22T14:19:06-04:00
3426220 LOBBYIT.COM 2c029e20-2f4a-4545-9d3a-da8c37a0eb0c Q3 LOBBYIT.COM 400487397 STEEL TUBE INSTITUTE 2025 third_quarter TAR N/A HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-09-25T18:17:55-04:00
3426494 SPORTS & FITNESS INDUSTRY ASSOCIATION b365b98c-b7b5-4dd8-8b73-a5e7c637721c Q3 SPORTS & FITNESS INDUSTRY ASSOCIATION 36366 SPORTS & FITNESS INDUSTRY ASSOCIATION 2025 third_quarter TAR PHIT Act Youth Sports Facility Act Tarriffs Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)     0 0 2025-10-01T09:26:18-04:00
3426505 PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 705042af-4b1e-427a-83d1-ad7057c2900a Q3 PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 401103605 PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 2025 third_quarter TAR Discussed response to Section 232 National Security Investigation of Imports of Pharmaceuticals and Pharmaceutical Ingredients Bureau of Industry and Security (BIS),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES   50000 0 0 2025-10-01T09:31:32-04:00
3426541 PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 7d6eb167-0413-418d-82f1-b2ba84bc9dd9 3A PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 401103605 PHARMA & BIOPHARMA OUTSOURCING ASSOCIATION 2025 third_quarter TAR Discussed response to Section 232 National Security Investigation of Imports of Pharmaceuticals and Pharmaceutical Ingredients Bureau of Industry and Security (BIS),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,State, Dept of (DOS)   50000 0 0 2025-10-01T10:54:16-04:00
3426551 ROCKIES ARIA LLC d9382593-87d7-4add-94f8-2872a5c68efa Q3 ROCKIES ARIA LLC 401106954 VINTAGE HOTELS 2025 third_quarter TAR Status of U.S. trade negotiations. Changes in U.S. foreign policy. HOUSE OF REPRESENTATIVES,Natl Security Council (NSC),SENATE,State, Dept of (DOS),White House Office 40000   0 0 2025-10-01T11:20:52-04:00
3427527 PENN AVENUE PARTNERS 924f5e57-c2c2-4ffd-8e2d-491f4fc418e5 Q3 PENN AVENUE PARTNERS 400918672 EXTREME NETWORKS 2025 third_quarter TAR Monitor tariffs and trade policy issues.   20000   0 0 2025-10-03T18:50:06-04:00
3427924 MASON STREET CONSULTING, LLC a1b777f8-1ccf-48f5-acce-1382e505d12b Q3 MASON STREET CONSULTING, LLC 401105150 DOMPE US INC. 2025 third_quarter TAR Tariffs on orphan drugs. Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),White House Office     0 0 2025-10-06T12:53:17-04:00
3427985 FOCUS DC LLC 21d52a64-4d93-428e-885a-f0b5ce06176c Q3 FOCUS DC LLC 401104454 REVOLUTION CORPORATE SERVICES, INC. 2025 third_quarter TAR Tariffs. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-06T13:39:42-04:00
3428790 SYENSQO USA LLC 6de00983-7765-4443-b28b-371e3ec0bfb3 Q3 SYENSQO USA LLC 400408933 SYENSQO USA LLC 2025 third_quarter TAR Potential House and Senate legislation related to the renewal of Miscellaneous Tariff Bill and Generalized System of Preferences. HOUSE OF REPRESENTATIVES,SENATE   170000 0 0 2025-10-07T17:33:25-04:00
3428901 B. BRAUN MEDICAL 65aa62b0-899d-4224-9de9-8ad9eaa581f9 Q3 B. BRAUN MEDICAL 401107078 B. BRAUN MEDICAL 2025 third_quarter TAR drug and device shortage issues HOUSE OF REPRESENTATIVES,SENATE   118000 0 0 2025-10-08T10:20:37-04:00
3429045 CANADIAN AUTOMOBILE DEALERS ASSOCIATION 7cc36d23-f4b0-45fe-b96b-3791b19da384 Q3 CANADIAN AUTOMOBILE DEALERS ASSOCIATION 401109741 CANADIAN AUTOMOBILE DEALERS ASSOCIATION 2025 third_quarter TAR Tariffs and automotive free trade between the United States and Canada. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE   10000 0 0 2025-10-08T12:20:22-04:00
3429129 CORNERSTONE GOVERNMENT AFFAIRS, INC. 5678a17a-0211-4bc4-ade3-7120433d292f Q3 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 COVINGTON AIRCRAFT ENGINES INC. 2025 third_quarter TAR Issues related to Section 301 Tariff policy Commerce, Dept of (DOC),SENATE 30000   0 0 2025-10-08T14:04:52-04:00
3429398 ADVANCED POLICY CONSULTING, LLC a05f3173-1bf2-4e53-8809-12fbc4f16d02 Q3 ADVANCED POLICY CONSULTING, LLC 401103524 POLARIS INDUSTRIES, INC. 2025 third_quarter TAR Issues related to tariffs that impact Polaris. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-08T16:44:01-04:00
3429416 TERRAPIN STRATEGY, INC 2b134053-1707-43e2-9217-0452c0194e11 3T TERRAPIN STRATEGY, INC 401107434 AGRODITY, INC. 2025 third_quarter TAR Outreach on U.S. tariff policy impacting agricultural supply chains. HOUSE OF REPRESENTATIVES,SENATE 7250   0 1 2025-10-08T17:08:14-04:00
3429538 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) aead0697-8f1b-4da2-b242-44b9df15f908 Q3 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) 401106405 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) 2025 third_quarter TAR Lobbied against tariffs on the EU (reciprocal and Section 232), lobbied to find a solution to lower non-tariff barriers between EU and US. Lobbied in favor of H.R.2665 - Trade Review Act of 2025 and S.1272 - Trade Review Act of 2025. This bill aims to strengthen congressional oversight over tariffs. Lobbied for exclusions for machinery and equipment that is not readily or abundantly available domestically. Educated on the impacts of tariffs on American producers, farmers, manufacturers, and the U.S. economy as a whole and U.S. manufacturing goals. Lobbied to find solutions on simplifying documentation requirements on steel and aluminum derivative tariffs. Lobbied to exclude EU from new 232 investigation on robotics and industrial machinery. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   20000 0 0 2025-10-09T10:22:07-04:00
3429758 KOUNTOUPES DENHAM CARR & REID, LLC 7fc44fe9-53ab-41b5-bb56-394bcf133647 Q3 KOUNTOUPES DENHAM CARR & REID, LLC 320918 APOTEX, CORP. 2025 third_quarter TAR Issues related to tariffs and generic pharmaceuticals.   50000   0 0 2025-10-09T14:30:26-04:00
3430217 NORTH AMERICAN SUBARU, INC. 115d7320-93b9-44b3-9c56-144b4cc10b9b Q3 NORTH AMERICAN SUBARU, INC. 401105415 NORTH AMERICAN SUBARU, INC. 2025 third_quarter TAR Issues related to auto tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),Natl Economic Council (NEC),SENATE,Treasury, Dept of   40000 0 0 2025-10-10T15:57:30-04:00
3430265 FBB FEDERAL RELATIONS 1c53b0c9-0a23-4611-b53b-8000e57ace73 Q3 FBB FEDERAL RELATIONS 22883 DECKERS OUTDOOR CORPORATION 2025 third_quarter TAR Lobby for passage of international trade, intellectual property rights, and customs legislation, and other legislative issues impacting the company HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-10-10T18:08:42-04:00
3430314 VIVID STRATEGIES LLC 44710ccc-b219-47f3-890f-d5af246722ca Q3 VIVID STRATEGIES LLC 401109416 DIGITALEUROPE 2025 third_quarter TAR H.R. 7738 - International Emergency Economic Powers Act (IEEPA) H.R. 11970 - Section 232 of the Trade Expansion Act of 1962 HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 20000   0 0 2025-10-10T22:02:41-04:00
3430807 OUTDOOR INDUSTRY ASSOCIATION 65e96b76-ce22-48d3-99d8-4c604016698f Q3 OUTDOOR INDUSTRY ASSOCIATION 30393 OUTDOOR INDUSTRY ASSOCIATION 2025 third_quarter TAR Reviving MTBs, which provide outdoor companies with duty savings for imported products vetted by USITC as not being domestically produced. HOUSE OF REPRESENTATIVES,SENATE   55000 0 0 2025-10-13T09:48:04-04:00
3430813 TERRAPOWER, LLC aec381b1-455c-48aa-a47c-7692e2a63c05 Q3 TERRAPOWER, LLC 401109474 TERRAPOWER, LLC 2025 third_quarter TAR Implementation of H.R. 3684, Infrastructure Investment and Jobs Act (IIJA); Implementation of H.R 5376 - Inflation Reduction Act of 2022; Implementation of S. 870 - Fire Grants and Safety Act of 2023; Implementation of H.R.1042 - Prohibiting Russian Uranium Imports Act; Implementation of H.R. 1 - One Big Beautiful Act; FY26 Appropriations. Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE   160000 0 0 2025-10-13T09:51:08-04:00
3430823 PIKE ASSOCIATES LLC 92d4fb4f-0374-4f97-9868-79b21a4a8ad6 Q3 PIKE ASSOCIATES LLC 400458236 BUMBLE BEE SEAFOODS, LLC 2025 third_quarter TAR proposed tariffs on imported seafood U.S. Trade Representative (USTR)     0 0 2025-10-13T09:56:35-04:00
3431068 MERCURY PUBLIC AFFAIRS, LLC 0c118d2d-b6f0-45fc-a302-fea5892c4b29 3T MERCURY PUBLIC AFFAIRS, LLC 70175 DANAHER CORPORATION 2025 third_quarter TAR Issues related to science & biotechnology products HOUSE OF REPRESENTATIVES,SENATE,White House Office 70000   0 1 2025-10-13T13:06:47-04:00
3431115 REINECKE STRATEGIC SOLUTIONS, INC. 67a2a908-9ccd-4815-9771-9717e845b7fd Q3 REINECKE STRATEGIC SOLUTIONS, INC. 298012 UNITED NATURAL PRODUCTS ALLIANCE 2025 third_quarter TAR Tariffs on critical nutrients and dietary supplements. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-10-13T13:51:00-04:00
3431158 REINECKE STRATEGIC SOLUTIONS, INC. c0dc4459-389a-4bcb-b6d8-ad7de84588fc Q3 REINECKE STRATEGIC SOLUTIONS, INC. 298012 PHARMAVITE LLC 2025 third_quarter TAR Tariffs on critical nutrients and dietary supplements. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 40000   0 0 2025-10-13T14:07:01-04:00
3431185 CARDINAL INFRASTRUCTURE LLC 0fdf6f4c-e24b-441c-aeac-3c71b15089cb Q3 CARDINAL INFRASTRUCTURE LLC 299913 NEW FLYER OF AMERICA INC. 2025 third_quarter TAR Administration Canadian Tariff Proposal Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 25000   0 0 2025-10-13T14:27:18-04:00
3431959 THE CSL GROUP, INC. 106d34e2-d1a2-4550-b073-85001ed8e297 Q3 THE CSL GROUP, INC. 400978796 THE CSL GROUP INC. 2025 third_quarter TAR Lobbying for an optimal operational and trade context for shipping between Canada and the U.S., as well as other neighboring jurisdictions, in relation to tariffs and port fees imposed on the vessels owned and operated by the CSL Group Inc. HOUSE OF REPRESENTATIVES,SENATE,St. Lawrence Seaway Development Corporation,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office   60000 0 0 2025-10-14T12:43:41-04:00
3432211 SQUIRE PATTON BOGGS 73ff2af5-dd84-40cb-8b8c-e9d61b576270 Q3 SQUIRE PATTON BOGGS 30906 KIA CORPORATION (FORMERLY KNOWN AS KIA MOTORS CORPORATION) 2025 third_quarter TAR Impact of regulations regarding tax, trade and tariffs on the auto industry. SENATE 140000   0 0 2025-10-14T14:33:51-04:00
3432925 BALLARD PARTNERS d720d737-ef1e-4283-8e16-aa0e064a375c Q3 BALLARD PARTNERS 401104288 ATLAS AIR, INC. 2025 third_quarter TAR Advocacy related to trade and tariffs. Homeland Security, Dept of (DHS),U.S. Customs & Border Protection,White House Office 90000   0 0 2025-10-14T21:28:36-04:00
3432985 THE LANDE GROUP 611721d5-62d6-4e86-871e-ac9dafaa8f8c Q3 THE LANDE GROUP 400661993 POWER SOLUTIONS INTERNATIONAL (PSI) 2025 third_quarter TAR Sec 301 tariffs and the possible new tariffs Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office     0 0 2025-10-14T23:40:58-04:00
3433114 BALLARD PARTNERS 1eec728f-ea2d-4d4e-b41e-6ffdb57629f2 Q3 BALLARD PARTNERS 401104288 ATLAS COPCO NORTH AMERICA INC. 2025 third_quarter TAR Advocacy related to trade and tariffs.   20000   0 0 2025-10-15T08:59:57-04:00
3433130 AMERICAN ASSOCIATION FOR HOMECARE 812e5b11-47b3-4d3d-ba1e-bab37144655c Q3 AMERICAN ASSOCIATION FOR HOMECARE 55792 AMERICAN ASSOCIATION FOR HOMECARE 2025 third_quarter TAR Issues related to tariffs on medical devices. HOUSE OF REPRESENTATIVES,SENATE   300000 0 0 2025-10-15T09:08:12-04:00
3433232 GENERAL MILLS SERVICES INC. (FKA GENERAL MILLS) bb69b22b-6eba-4664-a6b4-cd44e2210514 Q3 GENERAL MILLS SERVICES INC. (FKA GENERAL MILLS) 16010 GENERAL MILLS SERVICES INC. (FKA GENERAL MILLS) 2025 third_quarter TAR Issues related to duties and tariffs on food ingredients and packaging. No bill number. Agriculture, Dept of (USDA),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office   331000 0 0 2025-10-15T09:34:35-04:00
3433484 TSG ADVOCATES DC, LLC b83cb2c9-bd49-452f-a26e-859dbff4a25a Q3 TSG ADVOCATES DC, LLC 401109292 AMERICAN AIRLINES, INC. 2025 third_quarter TAR Commercial airline industry policy, aviation security & infrastructure Enhance flight safety Aviation safety and security Airport infrastructure and funding Air traffic control modernization Airline competition and antitrust issues Taxation and economic regulation Labor relations Environmental regulations International aviation agreements HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2025-10-15T10:37:11-04:00
3433530 BALLARD PARTNERS 13f8cf84-97ee-4981-b7b6-b54a835b2a2d Q3 BALLARD PARTNERS 401104288 BMW OF NORTH AMERICA LLC 2025 third_quarter TAR Advocacy related to trade and tariffs. Export controls. Commerce, Dept of (DOC),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 80000   0 0 2025-10-15T10:50:30-04:00
3433558 BALLARD PARTNERS 086ea8f2-efa1-4e71-81e4-754f0fa47717 Q3 BALLARD PARTNERS 401104288 BREITLING SA 2025 third_quarter TAR Guidance and advocacy related to trade and tariffs. Commerce, Dept of (DOC),Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-10-15T10:56:40-04:00
3433609 BUCHANAN INGERSOLL & ROONEY PC 3cbcc160-e9c5-4ecf-b12b-8f4c2ae5afe3 Q3 BUCHANAN INGERSOLL & ROONEY PC 55291 HERAEUS INCORPORATED 2025 third_quarter TAR Develop and execute a government relations strategy on issues relating to tariffs and critical minerals policy. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-10-15T11:09:42-04:00
3433780 SQUIRE PATTON BOGGS 9e46e3ca-43cb-4676-954e-775e6a7f412b Q3 SQUIRE PATTON BOGGS 30906 THE BOEING COMPANY 2025 third_quarter TAR Outreach to Congress on International Emergency Economic Powers Act (IEEPA) and tariff policy updates. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-10-15T11:55:22-04:00
3433958 BALLARD PARTNERS 31f505cf-fb73-4a88-9228-707c039b5453 Q3 BALLARD PARTNERS 401104288 COMPOSITE TECHNOLOGY INTERNATIONAL, INC. 2025 third_quarter TAR Advocacy and guidance regarding lumber 232 and reciprocal tariffs. Commerce, Dept of (DOC),Homeland Security, Dept of (DHS),White House Office 90000   0 0 2025-10-15T12:35:26-04:00
3434323 BALLARD PARTNERS 48ab3798-3356-43e0-a69a-701a9b3f3252 Q3 BALLARD PARTNERS 401104288 CONSOLIDATED MILL SUPPLY, INC. 2025 third_quarter TAR Advocacy related to trade and tariffs.   10000   0 0 2025-10-15T13:56:17-04:00
3434413 JPC STRATEGIES 957a5532-93ac-4ca4-bb2f-0003650b979a Q3 JPC STRATEGIES 401107007 PUBLIC STRATEGIES WASHINGTON OBO SCHAEFFLER GROUP USA INC. 2025 third_quarter TAR Discussed recent tariffs put on by the Administration. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-10-15T14:21:07-04:00
3434554 BALLARD PARTNERS c0d76713-b21e-4b81-93fe-650d1655c880 Q3 BALLARD PARTNERS 401104288 DAIMLER TRUCK NORTH AMERICA LLC 2025 third_quarter TAR Monitor vehicle emission regulations; Monitor tariff and trade discussions. HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 120000   0 0 2025-10-15T15:10:09-04:00
3434565 BALLARD PARTNERS b62be308-d3ba-4111-bcf3-bda8fe12a560 Q3 BALLARD PARTNERS 401104288 E3 IGNITIONS PRODUCTS, LLC 2025 third_quarter TAR Advocacy related to trade and tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-10-15T15:13:12-04:00
3434613 BALLARD PARTNERS 6776999c-dc49-485e-8885-34e0c0565f39 Q3 BALLARD PARTNERS 401104288 DOREL JUVENILE GROUP, INC. 2025 third_quarter TAR U.S. trade and tariffs policy related to domestic manufacturing. HOUSE OF REPRESENTATIVES,SENATE,White House Office 110000   0 0 2025-10-15T15:24:21-04:00
3434859 DENTONS US LLP fce32e05-83a4-4609-8e69-7d7a4275b157 Q3 DENTONS US LLP 36105 TWO PEACHTREE PARTNERS, LLC 2025 third_quarter TAR Historic preservation tax credits, and TIFIA tax credit for redevelopment of property in downtown Atlanta; HOUSE OF REPRESENTATIVES,SENATE,Transportation, Dept of (DOT) 10000   0 0 2025-10-15T16:24:14-04:00
3434929 BALLARD PARTNERS 31b4f721-79fa-4973-95b7-98c8a44cea59 Q3 BALLARD PARTNERS 401104288 FRAGRANCE CREATORS ASSOCIATION 2025 third_quarter TAR Advocacy related to trade and tariffs, tax credits, and EPA chemical reviews. HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-10-15T16:44:36-04:00
3435015 BALLARD PARTNERS 13b6d99f-7b1a-486f-b4b2-57e95e319555 Q3 BALLARD PARTNERS 401104288 GIMME SEAWEED 2025 third_quarter TAR Advocacy regarding Tariff Exemption for Korean seaweed. Commerce, Dept of (DOC),White House Office 70000   0 0 2025-10-15T17:13:29-04:00
3435259 BALLARD PARTNERS 4d946ac9-44e6-4092-9ad5-2decf2f57400 Q3 BALLARD PARTNERS 401104288 HYPERICE, INC. 2025 third_quarter TAR Advocacy and guidance on issues pertaining to tariffs, trade policy, and medical devices. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-10-15T19:32:56-04:00
3435282 BALLARD PARTNERS 71a8ecf1-8983-4139-916b-79110135734e Q3 BALLARD PARTNERS 401104288 IRVING OIL LTD. 2025 third_quarter TAR Monitor and report on trade and tariff discussions. Commerce, Dept of (DOC),U.S. Trade Representative (USTR) 120000   0 0 2025-10-15T20:29:06-04:00
3435573 MR. BRIAN KELLY 9b96e251-dc45-4745-968c-400960af9dec Q3 MR. BRIAN KELLY 40024191 TAKEDA PHARMACEUTICAL COMPANY 2025 third_quarter TAR Government tariffs on drug imporatation. U.S. Trade Representative (USTR),White House Office 10000   0 0 2025-10-16T09:23:06-04:00
3435589 BROWNSTEIN HYATT FARBER SCHRECK, LLP 57a6bc40-0c58-47ce-a5fc-003301288d78 Q3 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 ABBVIE 2025 third_quarter TAR Reciprocal tariffs   80000   0 0 2025-10-16T09:26:08-04:00
3435689 CAPITOLINE CONSULTING, LLC 6c4049a6-16de-4565-8b85-f1c960a73774 Q3 CAPITOLINE CONSULTING, LLC 400426039 INTERNATIONAL SLEEP PRODUCTS ASSOCIATION 2025 third_quarter TAR Tracked the Administrations tariff actions and related Congressional oversight SENATE 20000   0 0 2025-10-16T09:56:58-04:00
3436033 CAPITOLINE CONSULTING, LLC f4678c5d-d69e-402b-89a1-13282be4feae Q3 CAPITOLINE CONSULTING, LLC 400426039 AMERICAN COATINGS ASSOCIATION 2025 third_quarter TAR Tracked the Administrations tariff actions and related Congressional oversight HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-16T10:52:35-04:00
3436227 COREWELL HEALTH 15b37df3-82ac-47d6-9e9a-f2daf02f5200 Q3 COREWELL HEALTH 298455 COREWELL HEALTH 2025 third_quarter TAR Impacts of tariffs on health care providers. Executive Office of the President (EOP)   190000 0 0 2025-10-16T11:24:37-04:00
3436418 NEW YORK FARM BUREAU, INC. b75b08df-b840-4543-9f64-53841bc97706 Q3 NEW YORK FARM BUREAU, INC. 53777 NEW YORK FARM BUREAU INC 2025 third_quarter TAR Tariffs impacting agricultural products (no bill no.). Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2025-10-16T11:55:05-04:00
3436444 CAPITOLINE CONSULTING, LLC 47bf8ddf-7054-4ef9-b811-d870f56587e6 Q3 CAPITOLINE CONSULTING, LLC 400426039 EVONIK CORPORATION 2025 third_quarter TAR Issues related to the Administrations tariff actions and related Congressional oversight HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-16T11:59:51-04:00
3436684 CAPITOLINE CONSULTING, LLC 30f44ff7-e1f0-4aac-a11a-1e2fdd0d7dc5 Q3 CAPITOLINE CONSULTING, LLC 400426039 ENVELOPE MANUFACTURERS ASSOCIATION 2025 third_quarter TAR Tracked the Administrations tariff actions and related Congressional oversight HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-16T13:08:36-04:00
3436772 BALLARD PARTNERS 7f0449c3-d9b7-4f83-b288-4565aa8e97ec Q3 BALLARD PARTNERS 401104288 LEGO SYSTEMS, INC. 2025 third_quarter TAR Advocacy related to trade and tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-10-16T13:23:29-04:00
3436778 BALLARD PARTNERS ff05cfff-e9ac-460b-ba67-d6bd53018325 Q3 BALLARD PARTNERS 401104288 LUPIN PHARMACEUTICALS INC. 2025 third_quarter TAR Advocacy and guidance related to trade and tariffs. 232 Investigation. Commerce, Dept of (DOC),U.S. Trade Representative (USTR),White House Office 80000   0 0 2025-10-16T13:24:42-04:00
3436798 CAPITOLINE CONSULTING, LLC 0ba37462-a498-4c94-9a5e-b1f4b202bbdf Q3 CAPITOLINE CONSULTING, LLC 400426039 FLEXIBLE PACKAGING ASSOCIATION 2025 third_quarter TAR Tracked the Administrations tariff actions and related Congressional oversight HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-16T13:27:46-04:00
3436803 BALLARD PARTNERS a1cb8935-709e-4e79-8e9c-1e82abc52fe3 Q3 BALLARD PARTNERS 401104288 MERCK SHARP & DOHME LLC 2025 third_quarter TAR Guidance and advocacy related to drug pricing and tariffs.   50000   0 0 2025-10-16T13:29:15-04:00
3436810 OTSUKA AMERICA PHARMACEUTICAL, INC. e966f484-de76-4935-8d1a-7c435a3d5ad7 Q3 OTSUKA AMERICA PHARMACEUTICAL, INC. 401093052 OTSUKA AMERICA PHARMACEUTICAL, INC. 2025 third_quarter TAR Issues related to tariffs on pharmaceuticals and pharmaceutical supply chain. HOUSE OF REPRESENTATIVES,SENATE   340000 0 0 2025-10-16T13:29:44-04:00
3436854 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS 5434fba2-7e65-4cc4-93ad-1e2226cc26c6 Q3 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS 19775 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS 2025 third_quarter TAR Oppose Tariffs on Canada (No Bill Number) Oppose Reciprocal Tariffs (No Bill Number) Oppose Aerospace Tariffs (No Bill Number) HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   740000 0 0 2025-10-16T13:36:21-04:00
3437138 ARNOLD & PORTER KAYE SCHOLER LLP 72bd7677-4aa5-435f-86e5-2ccc44503dea Q3 ARNOLD & PORTER KAYE SCHOLER LLP 4301 SOCIETY OF NUCLEAR MEDICINE AND MOLECULAR IMAGING 2025 third_quarter TAR Issues related to tariffs on radiopharmaceuticals. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-10-16T14:22:02-04:00
3437164 BECKER & POLIAKOFF, P.A. 874f721c-117f-4bce-96ba-6cff99dff469 Q3 BECKER & POLIAKOFF, P.A. 283696 ASSOCIAZIONE INDUSTRIALI DELLE CARNI E DEI SALUMI 2025 third_quarter TAR Tariffs on cured meats. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-16T14:27:22-04:00
3437202 MAYER BROWN LLP e18bf14b-f35d-4c88-b440-ea40d59104d0 Q3 MAYER BROWN LLP 24123 ELEMENT ELECTRONICS 2025 third_quarter TAR Issues related to the Miscellaneous Tariff Bill. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-16T14:32:22-04:00
3437445 BALLARD PARTNERS 3fad85ec-b0be-43ab-8d16-00323bc72faf 3T BALLARD PARTNERS 401104288 FLUENCE ENERGY, LLC 2025 third_quarter TAR Issues regarding trade/tariffs; 232 investigations; anti-dumping investigations. Commerce, Dept of (DOC),Energy, Dept of,HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,U.S. Trade Representative (USTR),White House Office 60000   0 1 2025-10-16T14:57:35-04:00
3437554 BALLARD PARTNERS fa2fbf5f-5ef8-4f6d-a7c4-d62f3f400d7f 3T BALLARD PARTNERS 401104288 MOORE CAPITAL MANAGEMENT, LLC 2025 third_quarter TAR Guidance related to trade and tariffs.       0 1 2025-10-16T15:11:48-04:00
3437607 KOREA INTERNATIONAL TRADE ASSOCIATION ea072cd9-408b-4db5-969f-ac70228040a4 Q3 KOREA INTERNATIONAL TRADE ASSOCIATION 401107802 KOREA INTERNATIONAL TRADE ASSOCIATION 2025 third_quarter TAR - Expressing opinions on tariff measures - Requesting meetings with key government officials, etc. Commerce, Dept of (DOC),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   83832 0 0 2025-10-16T15:18:33-04:00
3437715 BALLARD PARTNERS b7baf6b7-07e7-4bef-b9b3-d131b57eb0e2 Q3 BALLARD PARTNERS 401104288 MHP FOOD TRADING LLC 2025 third_quarter TAR Market access for agriculture and trade/tariff relief. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS) 150000   0 0 2025-10-16T15:35:48-04:00
3437999 HANCE SCARBOROUGH 9d5b3907-40c5-4922-a397-23e208cdb36f Q3 HANCE SCARBOROUGH 17443 AMERICAN BEEKEEPING FEDERATION 2025 third_quarter TAR Reconciliation Bill, Farm Bill Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-10-16T16:21:47-04:00
3438048 CAPITOL COUNSEL LLC 6266ab81-6b53-4a8b-960b-47d944633a74 Q3 CAPITOL COUNSEL LLC 313715 SALUBER STRATEGIES, LLC ON BEHALF OF MAD GLOBAL STRATEGY 2025 third_quarter TAR Issues regarding tariffs on gum acacia imports. SENATE 10000   0 0 2025-10-16T16:29:53-04:00
3438177 TROUTMAN STATEGIES e57bd730-0760-4e3d-8dbf-6611e2e086d3 Q3 TROUTMAN STATEGIES 81511 KRONOS WORLDWIDE, INC. 2025 third_quarter TAR Issues related to tariffs on imports from Canada. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-16T16:56:30-04:00
3438254 BALLARD PARTNERS d1338540-63a7-428d-82d1-8f40744ea77c Q3 BALLARD PARTNERS 401104288 NIAGARA BOTTLING, LLC 2025 third_quarter TAR Advocacy and guidance related to trade and tariffs. Commerce, Dept of (DOC),U.S. Trade Representative (USTR),White House Office 30000   0 0 2025-10-16T17:12:14-04:00
3438262 STRATEGIES 360 2e1c15a9-ce01-4016-bf9a-e741907d3ad6 Q3 STRATEGIES 360 79175 THE GAS COMPANY, LLC DBA HAWAII GAS 2025 third_quarter TAR Issues related to tariffs on shipments of Canadian propane HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-16T17:12:54-04:00
3438604 BROWNSTEIN HYATT FARBER SCHRECK, LLP 26927523-fb45-4ceb-9852-8091ef8d51e2 3T BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 PRINCESS HOUSE INC 2025 third_quarter TAR Trade and tariff issues affecting the home goods market Commerce, Dept of (DOC) 20000   0 1 2025-10-16T19:32:22-04:00
3439070 CAPITOLINE CONSULTING, LLC b03810ac-2999-4c61-baeb-8a67f6441e1e Q3 CAPITOLINE CONSULTING, LLC 400426039 PPG INDUSTRIES 2025 third_quarter TAR Tracked the Administrations tariff actions and related Congressional oversight HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-10-17T08:48:21-04:00
3439397 APOTEX CORP. a4aa4c2c-6718-4396-b0a6-1ca35164cfe9 Q3 APOTEX CORP. 310973 APOTEX CORP. 2025 third_quarter TAR Executive Order 14231 and 14325, Amendment to Duties To Address the Flow of Illicit Drugs Across our Northern Border, provisions relating to the imposition of tariffs on products from Canada and the exemption of pharmaceuticals compliant with the United States-Mexico-Canada trade agreements from such tariffs; Executive Order 14257, Regulating Imports With A Reciprocal Tariff To Rectify Practices That Contribute To Large And Persistent Annual United States Goods Trade Deficits, provisions relating to the exemption of pharmaceuticals from reciprocal tariffs; Executive Order 14326, Further Modifying the Reciprocal Tarriff Rate, provisions relating to a zero percent tariff rate for non-patented articles for use in pharmaceutical applications; Federal policy relating to the United States-European Union Framework on an Agreement on Reciprocal, Fair, and Balanced Trade and the exemption of generic pharmaceuticals and their ingredients and precursor materials from tariffs; and Federal policy relating to the Department of Commerce's Section 232 National Security Investigation of Imports of Pharmaceuticals and Pharmaceutical Ingredients [Docket No. 250414-006] and the exemption of pharmaceuticals compliant with the United States-Mexico-Canada trade agreement from any tariffs implemented following the completion of the Section 232 investigation. HOUSE OF REPRESENTATIVES,SENATE   310000 0 0 2025-10-17T09:56:54-04:00
3439666 WILLIAMS AND JENSEN, PLLC 4cfd82be-3a85-4838-ab1c-23a6bdc09e6d Q3 WILLIAMS AND JENSEN, PLLC 41454 CHRISTMAS TRADE GROUP 2025 third_quarter TAR US policy regarding proposed reciprocal and sectoral tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 40000   0 0 2025-10-17T10:35:51-04:00
3439935 HANCE SCARBOROUGH f0f47ae5-8127-4e45-9f3f-06e3ae79ccb4 Q3 HANCE SCARBOROUGH 17443 MOLNLYCKE HEALTH CARE US, LLC 2025 third_quarter TAR Reconciliation Bill, Trade Issues, Tariff Issues HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-17T10:58:48-04:00
3439946 COALITION FOR A PROSPEROUS AMERICA 46448174-99e4-4e57-bede-32755c1e6da0 Q3 COALITION FOR A PROSPEROUS AMERICA 401105589 COALITION FOR A PROSPEROUS AMERICA 2025 third_quarter TAR MTB/GSP: update and modernize MTB so that it works for America and does not hinder American manufacturing; De minimis: reforming the threshold that hurts domestic manufacturing and overburdens our nation's customs and border protection work 201 solar tariffs - maintenance and strengthening; 301 tariffs - maintenance and strengthening; 232 tariffs - maintenance and strengthening of existing tariffs on steel and aluminum; new 232 tariffs on pharmaceuticals and other critical industries Securing Accountability in Foreign Entities Act Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office   300000 0 0 2025-10-17T10:59:05-04:00
3440077 HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC a64d4200-7125-4622-8506-b77ea4dd83b5 Q3 HECHT LATHAM SPENCER & ASSOCIATES, INC., FORMERLY KNOWN AS HECHT SPENCER & ASSOC 17966 AMERICAN GEM TRADE ASSOCIATION 2025 third_quarter TAR Tariff policy on imports of loose colored gemstones. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR) 50000   0 0 2025-10-17T11:08:38-04:00
3440098 TEVA PHARMACEUTICALS USA, INC. 4330f46a-5884-49f2-986b-e6fad520dcde Q3 TEVA PHARMACEUTICALS USA, INC. 76695 TEVA PHARMACEUTICALS USA INC 2025 third_quarter TAR A joint resolution terminating the national emergency declared to impose duties on articles imported from Canada (S.J.Res.37). Commerce, Dept of (DOC),Executive Office of the President (EOP),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   460000 0 0 2025-10-17T11:10:30-04:00
3440384 HANCE SCARBOROUGH b70d603d-5f69-46f4-bd74-bd5d7a3a17eb Q3 HANCE SCARBOROUGH 17443 BUSINESS COUNCIL OF CANADA 2025 third_quarter TAR Tariff/Business Issues HOUSE OF REPRESENTATIVES,Office of Administration,SENATE 40000   0 0 2025-10-17T11:34:45-04:00
3440392 BALLARD PARTNERS 88c94d90-3184-4913-8d49-e5cb0f63ee32 3A BALLARD PARTNERS 401104288 MERCK SHARP & DOHME LLC 2025 third_quarter TAR Guidance and advocacy related to drug pricing and tariffs.   80000   0 0 2025-10-17T11:35:17-04:00
3440520 HB STRATEGIES 002d33da-f458-4647-bd7d-33b077754e05 Q3 HB STRATEGIES 401104718 CAN MANUFACTURERS INSTITUTE 2025 third_quarter TAR Issues related to 232 tariffs on steel and aluminum. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2025-10-17T11:46:30-04:00
3440538 HANCE SCARBOROUGH 069a0e64-c6c3-48f8-a31e-faaa513b49d0 Q3 HANCE SCARBOROUGH 17443 NATIONAL INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION 2025 third_quarter TAR HR 1566 Reconciliation Bill Trade Issues Tariff Issues HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-17T11:48:26-04:00
3440545 THE SMITH-FREE GROUP, LLC c87453cc-d1f4-4d16-bc81-5ceee4c6a65f Q3 THE SMITH-FREE GROUP, LLC 35800 COMSTOCK & HOLT, INC. 2025 third_quarter TAR Discussions regarding duty drawback. Discussions regarding S. 956, the Customs Facilitation Act of 2025. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-17T11:49:11-04:00
3440730 HANCE SCARBOROUGH 29194fdc-a906-499c-ae14-245aecb26e44 Q3 HANCE SCARBOROUGH 17443 NATIONAL TURKEY FEDERATION 2025 third_quarter TAR Issues related to poultry tariffs HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-17T12:03:20-04:00
3440748 HANCE SCARBOROUGH fb527113-e255-4963-88ce-532b7f8f1ece Q3 HANCE SCARBOROUGH 17443 PACKSIZE INTERNATIONAL, LLC 2025 third_quarter TAR Tariffs on packaging goods HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-17T12:06:43-04:00
3440781 DOMTAR CORPORATION 409bf746-914f-4e34-ae7a-ae2c9a8df934 Q3 DOMTAR CORPORATION 401108705 DOMTAR CORPORATION 2025 third_quarter TAR Discussed the impact of tariffs, including the softwood lumber trade dispute, and the need for fair trade practices to protect domestic industries; discussed the evasion of duties on thermal paper tariffs and enforcement of trade regulations; discussed section 232 investigation. HOUSE OF REPRESENTATIVES,SENATE   230000 0 0 2025-10-17T12:09:50-04:00
3440849 HANCE SCARBOROUGH 2132d9cc-7623-403a-9953-62b04137c004 Q3 HANCE SCARBOROUGH 17443 NORTHEAST COUNCIL OF STATE GOVERNMENTS 2025 third_quarter TAR Farm Bill, Tariffs HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-10-17T12:16:34-04:00
3440864 HANCE SCARBOROUGH 4e93252c-89f8-4eba-a288-a6bde049c94b Q3 HANCE SCARBOROUGH 17443 PORT OF CORPUS CHRISTI 2025 third_quarter TAR Funding for U.S. Army Corp of Engineers Army, Dept of (Corps of Engineers),HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-17T12:17:29-04:00
3441290 BROWNSTEIN HYATT FARBER SCHRECK, LLP 6fc738f1-4b8a-4cfd-aff6-c5a3dca4a25c Q3 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 JOHNSON & JOHNSON SERVICES, INC. 2025 third_quarter TAR Trade and tariffs affecting the pharmaceutical industry   80000   0 0 2025-10-17T13:11:58-04:00
3441300 EAST END GROUP, LLC a22846bf-7b05-4a84-8ec6-c184e538a9ca Q3 EAST END GROUP, LLC 400646949 ALVOGEN 2025 third_quarter TAR Section 232 investigation into pharmaceuticals and unfair trade practices. Commerce, Dept of (DOC),U.S. Trade Representative (USTR),White House Office 45000   0 0 2025-10-17T13:12:22-04:00
3441614 GENERAL AVIATION MANUFACTURERS ASSOCIATION c1ead592-dc93-45d5-bc10-1371941a481b Q3 GENERAL AVIATION MANUFACTURERS ASSOCIATION 15942 GENERAL AVIATION MANUFACTURERS ASSOCIATION 2025 third_quarter TAR Aviation and Aerospace Trade and Tariffs, 1979 Agreement on Trade in Civil Aircraft, Aerospace Exports and Imports, Aviation Supply Chain, Manufacturing, Maintenance, Aviation Safety and standards, U.S. Leadership, Trade Agreements Commerce, Dept of (DOC),Federal Aviation Administration (FAA),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),SENATE,Transportation, Dept of (DOT),Treasury, Dept of,U.S. Trade Representative (USTR)   260000 0 0 2025-10-17T13:58:17-04:00
3441689 WOODSIDE ENERGY GROUP LTD fb29b404-ba95-4fff-aa5d-9e4356919062 Q3 WOODSIDE ENERGY GROUP LTD 401107067 WOODSIDE ENERGY GROUP LTD 2025 third_quarter TAR Discussed tariffs impact on materials needed to build a domestic LNG project and on US LNG exports to foreign nations. Energy, Dept of,HOUSE OF REPRESENTATIVES,SENATE,White House Office   260000 0 0 2025-10-17T14:02:38-04:00
3441719 HB STRATEGIES b5fda981-dca3-4d5c-a855-c256f6c1583e Q3 HB STRATEGIES 401104718 H-J ENTERPRISES 2025 third_quarter TAR Report of the application of tariffs to supply chain materials. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-17T14:04:19-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 585.028ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API