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

9,181 rows where 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 19

  • 2025 1,673
  • 2019 717
  • 2018 692
  • 2020 668
  • 2010 615
  • 2021 552
  • 2022 522
  • 2012 515
  • 2013 486
  • 2023 424
  • 2024 413
  • 2014 378
  • 2017 367
  • 2011 312
  • 2016 286
  • 2009 282
  • 2015 277
  • 2008 1
  • 2026 1

filing_period 4

  • second_quarter 2,347
  • fourth_quarter 2,308
  • third_quarter 2,279
  • first_quarter 2,247

issue_code 1

  • TAR · 9,181 ✖
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
3528232 MOLNLYCKE HEALTH CARE US, LLC abc97552-ec28-45d0-92c4-7753e7db7415 Q1 MOLNLYCKE HEALTH CARE US, LLC 401104898 MOLNLYCKE HEALTH CARE US, LLC 2026 first_quarter TAR Lobbying around MedTech exemption from tariff implementation under IEEPA and 232 investigations. HOUSE OF REPRESENTATIVES,SENATE   30000 0 0 2026-02-17T14:09:25-05:00
3327733 MILLER & WENHOLD CAPITOL STRATEGIES 34935d86-73bb-4f95-9eec-fbb6eabe86ba Q1 MILLER & WENHOLD CAPITOL STRATEGIES 307034 CHAMBER OF MARINE COMMERCE 2025 first_quarter TAR Tariffs HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 15000   0 0 2025-03-25T15:58:36-04:00
3328723 SKLADANY CONSULTING LLC 9dedc78b-fec6-42ff-ab39-6d59fe6fe5b5 Q1 SKLADANY CONSULTING LLC 401104209 KASICH COMPANY ON BEHALF OF ATX NETWORKS 2025 first_quarter TAR Potential tariff proposals. Executive Office of the President (EOP),SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-04-04T07:05:13-04:00
3329014 RESOLUTION PUBLIC AFFAIRS, LLC 106fccbe-2127-4161-9043-de33336752a1 Q1 RESOLUTION PUBLIC AFFAIRS, LLC 401105068 MOLSON COORS BEVERAGE COMPANY USA 2025 first_quarter TAR Issues related to aluminum and the midwest premium HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-04-05T00:18:04-04:00
3329249 SKLADANY CONSULTING LLC cb679501-d706-4ff2-9115-fa0b0b1735d7 1A SKLADANY CONSULTING LLC 401104209 KASICH COMPANY ON BEHALF OF ATX NETWORKS 2025 first_quarter TAR Potential tariff proposals. Commerce, Dept of (DOC),Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-04-06T17:19:39-04:00
3329568 CORNERSTONE GOVERNMENT AFFAIRS, INC. 0a247c31-8b50-4389-a46a-dc90d00fec50 Q1 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 COVINGTON AIRCRAFT ENGINES INC. 2025 first_quarter TAR Issues related to Section 301 Tariff policy SENATE 30000   0 0 2025-04-07T16:10:12-04:00
3330365 TROUTMAN STATEGIES ab02352e-5ec9-4127-8699-1ad3684d3077 Q1 TROUTMAN STATEGIES 81511 KRONOS WORLDWIDE, INC. 2025 first_quarter TAR Issues related to tariffs on imports from Canada. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-04-09T12:18:43-04:00
3330534 KOREA INTERNATIONAL TRADE ASSOCIATION f716beea-2e94-4ab3-a213-34cfbe488e2b Q1 KOREA INTERNATIONAL TRADE ASSOCIATION 401107802 KOREA INTERNATIONAL TRADE ASSOCIATION 2025 first_quarter TAR - Expressing opinions on tariff measures - Requesting meetings with key government officials, etc. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   48199 0 0 2025-04-09T14:48:56-04:00
3330549 KOREA INTERNATIONAL TRADE ASSOCIATION c1c72f22-23f0-4a07-aa5c-441fd4cf56a2 1A KOREA INTERNATIONAL TRADE ASSOCIATION 401107802 KOREA INTERNATIONAL TRADE ASSOCIATION 2025 first_quarter TAR - Expressing opinions on tariff measures - Requesting meetings with key government officials, etc. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   64200 0 0 2025-04-09T14:57:38-04:00
3330592 AMERICAN CAPITOL GROUP 42cef26b-8900-41bb-b7f0-478b98e4dc26 Q1 AMERICAN CAPITOL GROUP 305852 CANNED MANUFACTURERS 2025 first_quarter TAR Tariffs on steel and Aluminum HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2025-04-09T15:32:43-04:00
3330885 CAN MANUFACTURERS INSTITUTE 78b6930a-851f-4a31-b9b4-f9fe000120f9 Q1 CAN MANUFACTURERS INSTITUTE 7975 CAN MANUFACTURERS INSTITUTE 2025 first_quarter TAR Section 232 on steel and aluminum products. Agriculture, Dept of (USDA),Bureau of Industry and Security (BIS),Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),SENATE,U.S. International Trade Commission (ITC)     0 0 2025-04-10T12:08:08-04:00
3330994 NORTH AMERICAN SUBARU, INC. 847d64d6-ec4e-4982-9776-a2c4c738572f Q1 NORTH AMERICAN SUBARU, INC. 401105415 NORTH AMERICAN SUBARU, INC. 2025 first_quarter TAR Issues related to auto tariffs HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   40000 0 0 2025-04-10T13:11:10-04:00
3331179 PUBLIC PRIVATE STRATEGIES 0f90f9d4-4338-4fae-99b3-5b7f5c9be592 Q1 PUBLIC PRIVATE STRATEGIES 401104830 ETSY 2025 first_quarter TAR de minimis Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 45000   0 0 2025-04-10T14:21:09-04:00
3331206 THE LANDE GROUP 756fdf98-5c87-4d96-8489-1b75875ed14d Q1 THE LANDE GROUP 400661993 POWER SOLUTIONS INTERNATIONAL (PSI) 2025 first_quarter TAR Sec 301 tariffs and the new tariffs announced in March and April 2025 Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of,U.S. Trade Representative (USTR),White House Office 30000   0 0 2025-04-10T14:31:06-04:00
3331504 MASON STREET CONSULTING, LLC 36d5a403-ed47-4634-ba70-e9f0f4ccd5c8 Q1 MASON STREET CONSULTING, LLC 401105150 DOMPE US INC. 2025 first_quarter TAR Tariffs on orphan drugs. Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),White House Office 30000   0 0 2025-04-10T18:19:09-04:00
3332061 THE MATTINGLEY GROUP 1b82936e-94b1-40c1-8368-a5cba0170d2a Q1 THE MATTINGLEY GROUP 400287370 THE PROCTER AND GAMBLE COMPANY 2025 first_quarter TAR Miscellaneous Tariff Bill (MTB) Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Intl Trade Administration (ITA),SENATE,U.S. Customs & Border Protection,U.S. International Trade Commission (ITC),U.S. Trade Representative (USTR)     0 0 2025-04-11T14:22:01-04:00
3332095 TARGA RESOURCES PARTNERS LP a2ddc9ba-2d1d-4c08-8469-61d94a2d23a5 Q1 TARGA RESOURCES PARTNERS LP 401105972 TARGA RESOURCES PARTNERS LP 2025 first_quarter TAR Legislative and administrative action related to Section 301. HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2025-04-11T14:53:02-04:00
3332099 SYENSQO USA LLC 9e2585c8-50b8-4c0d-95b7-ff638ab1b0e1 Q1 SYENSQO USA LLC 400408933 SYENSQO USA LLC 2025 first_quarter TAR Potential House and Senate legislation related to the renewal of Miscellaneous Tariff Bill and Generalized System of Preferences. HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2025-04-11T14:55:48-04:00
3332204 DENTONS US LLP 55918d9e-d7f9-4eee-8352-fac2b1e79d01 Q1 DENTONS US LLP 36105 TWO PEACHTREE PARTNERS, LLC 2025 first_quarter TAR Historic preservation tax credits, and TIFIA tax credit for redevelopment of property in downtown Atlanta HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-04-11T16:26:23-04:00
3332262 AEROFLOW HEALTHCARE INC 78a5db94-45ce-475e-94d7-89b43514540b Q1 AEROFLOW HEALTHCARE INC 401107289 AEROFLOW HEALTHCARE INC 2025 first_quarter TAR Tariffs affecting the Durable Medical Equipment industry HOUSE OF REPRESENTATIVES,SENATE   10000 0 0 2025-04-11T18:25:15-04:00
3332306 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) 7a014419-0c24-46dc-bab5-0c78e117e314 Q1 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) 401106405 VDMA AMERICA, INC. (FORMERLY KNOWN AS VDMA WASHINGTON, INC.) 2025 first_quarter TAR Education was done on the consequences of tariffs for American farmers and manufacturers. In Congress I raised that the Miscellaneous Tariff Bill would help manufacturers in America save costs. HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2025-04-12T11:03:35-04:00
3332826 BIFMA INTERNATIONAL 3a06aad8-7b5f-4032-a8d6-b21f1d99e2d4 Q1 BIFMA INTERNATIONAL 6198 BIFMA 2025 first_quarter TAR Expressing general concern of the various tariff activities that can negatively impact our member's businesses. HOUSE OF REPRESENTATIVES   32000 0 0 2025-04-14T08:20:26-04:00
3333581 SQUIRE PATTON BOGGS b842e01f-a9b6-4de9-8858-22af85004a7f Q1 SQUIRE PATTON BOGGS 30906 KIA CORPORATION (FORMERLY KNOWN AS KIA MOTORS CORPORATION) 2025 first_quarter TAR Impact of regulations regarding tax, trade and tariffs on the auto industry. HOUSE OF REPRESENTATIVES,SENATE,White House Office 40000   0 0 2025-04-14T14:18:31-04:00
3333986 AMERICAN ASSOCIATION FOR HOMECARE 8cf76f76-e666-45cf-92c4-c2b9da3e6005 Q1 AMERICAN ASSOCIATION FOR HOMECARE 55792 AMERICAN ASSOCIATION FOR HOMECARE 2025 first_quarter TAR Issues related to tariffs on medical devices. HOUSE OF REPRESENTATIVES,SENATE   250000 0 0 2025-04-14T19:54:00-04:00
3334062 BALLARD PARTNERS d2c15042-6d39-4c77-ba3c-69ebc3b96685 Q1 BALLARD PARTNERS 401104288 ATLAS AIR, INC. 2025 first_quarter TAR Advocacy related to trade and tariffs. Homeland Security, Dept of (DHS),U.S. Customs & Border Protection,White House Office 60000   0 0 2025-04-15T00:35:27-04:00
3334078 BALLARD PARTNERS 8e72fd58-bea8-417e-8f55-299efb690dd3 Q1 BALLARD PARTNERS 401104288 BMW OF NORTH AMERICA LLC 2025 first_quarter TAR Advocacy related to trade and tariffs. Commerce, Dept of (DOC),U.S. Trade Representative (USTR),White House Office 80000   0 0 2025-04-15T02:34:52-04:00
3334106 BALLARD PARTNERS c5d28e32-2083-4db2-90c9-51416bc7afc5 Q1 BALLARD PARTNERS 401104288 DAIMLER TRUCK NORTH AMERICA LLC 2025 first_quarter TAR Monitor vehicle emission regulations; Monitor tariff and trade discussions. HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 80000   0 0 2025-04-15T05:47:26-04:00
3334111 BALLARD PARTNERS cf5a228d-77a8-48a9-90ee-b00c0d382459 Q1 BALLARD PARTNERS 401104288 DOREL JUVENILE GROUP, INC. 2025 first_quarter TAR Advocacy related to import tariffs. White House Office 60000   0 0 2025-04-15T06:03:09-04:00
3334116 BALLARD PARTNERS e1f59d48-d6cf-44af-b67e-18e04ba0f6ae Q1 BALLARD PARTNERS 401104288 E3 IGNITIONS PRODUCTS, LLC 2025 first_quarter TAR Advocacy related to trade and tariffs. Commerce, Dept of (DOC),U.S. Trade Representative (USTR) 90000   0 0 2025-04-15T06:27:38-04:00
3334143 BALLARD PARTNERS 55549b0f-f787-4701-aa26-97658d742903 Q1 BALLARD PARTNERS 401104288 FRAGRANCE CREATORS ASSOCIATION 2025 first_quarter TAR Advocacy related to trade and tariffs, tax credits, and EPA chemical reviews. HOUSE OF REPRESENTATIVES,SENATE 90000   0 0 2025-04-15T07:31:25-04:00
3334317 TROUTMAN STATEGIES 060ef132-4b22-45a3-8e66-4f856a6c6ec8 Q1 TROUTMAN STATEGIES 81511 HALSTEAD NEW ENGLAND CORPORATION 2025 first_quarter TAR Section 301 Tariffs Legislative Proposals; generalized System of Preferences legislation. HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-04-15T09:32:36-04:00
3334562 NATIONAL TURKEY FEDERATION 31aa348f-b965-4d59-ad2e-9686021272ae Q1 NATIONAL TURKEY FEDERATION 28732 NATIONAL TURKEY FEDERATION 2025 first_quarter TAR Impact of tariffs and retaliatory action on the U.S. Turkey Industry. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE   50000 0 0 2025-04-15T10:48:08-04:00
3334628 ILLINOIS AGRICULTURAL ASSOCIATION 08404430-1204-49bf-aaab-5dd440607046 Q1 ILLINOIS AGRICULTURAL ASSOCIATION 400337565 ILLINOIS AGRICULTURAL ASSOCIATION 2025 first_quarter TAR IFB advocated for the administration to not impose tariffs on U.S. trading partners. IFB advocated to honor trade agreements. IFB advocated to not impose reciprocal tariffs on counties, whether the U.S. had a trade agreement or not. IFB advocated to honor the partnership between the United States, Canada and Mexico. Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE,White House Office   43000 0 0 2025-04-15T11:02:05-04:00
3334873 BAKERY, CONFECTIONERY, TOBACCO WORKERS AND GRAIN MILLERS INTERNATIONAL UNION 158530ed-4ab3-451f-834f-2a34e2726afa Q1 BAKERY, CONFECTIONERY, TOBACCO WORKERS AND GRAIN MILLERS INTERNATIONAL UNION 401105346 BAKERY, CONFECTIONERY, TOBACCO WORKERS AND GRAIN MILLERS INTERNATIONAL UNION 2025 first_quarter TAR Lifting Tariffs on Canada Executive Office of the President (EOP)     0 0 2025-04-15T12:37:47-04:00
3335055 ICE MILLER LLP 58dd8a71-523b-44bf-80ed-a357e0459fc1 Q1 ICE MILLER LLP 67854 GOLDEN BEAM METALS, LLC 2025 first_quarter TAR Metal manufacturing Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-04-15T13:49:39-04:00
3335218 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 59831b0d-94b2-43c1-9c8c-525bf6fea45b Q1 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 400520538 PROMOTIONAL PRODUCTS ASSOCIATION INTERNATIONAL 2025 first_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   80000 0 0 2025-04-15T14:59:19-04:00
3335443 BLACK & VEATCH e98ef23c-2aa8-4f0d-bcf7-1af12aa1b42b Q1 BLACK & VEATCH 6278 BLACK & VEATCH 2025 first_quarter TAR Executive actions on tariffs and impacts to critical infrastructure development. HOUSE OF REPRESENTATIVES,SENATE   80000 0 0 2025-04-15T16:05:00-04:00
3335477 SUMITOMO CORPORATION OF AMERICAS 6bbd7cff-97de-4f2f-9b00-6a4e9f31d669 Q1 SUMITOMO CORPORATION OF AMERICAS 401104955 SUMITOMO CORPORATION OF AMERICAS 2025 first_quarter TAR Issues related to the Miscellaneous Tariff Bill. HOUSE OF REPRESENTATIVES   70000 0 0 2025-04-15T16:16:08-04:00
3335704 OUTDOOR INDUSTRY ASSOCIATION ae3db8db-ebf4-48b4-944a-e4ed11d14e73 Q1 OUTDOOR INDUSTRY ASSOCIATION 30393 OUTDOOR INDUSTRY ASSOCIATION 2025 first_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-04-15T17:53:39-04:00
3335799 BROWNSTEIN HYATT FARBER SCHRECK, LLP 80435b85-7b2e-4b43-a348-1ca838ed3e68 Q1 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 BASIC MEDICAL DBA INTCO USA 2025 first_quarter TAR Tariff issues related to nitrile gloves HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 80000   0 0 2025-04-15T18:51:50-04:00
3335859 BALLARD PARTNERS c3ab3a57-90df-4b62-9a3a-0115a3739394 Q1 BALLARD PARTNERS 401104288 IRVING OIL LTD. 2025 first_quarter TAR Monitor and report on trade and tariff discussions. Commerce, Dept of (DOC),U.S. Trade Representative (USTR) 80000   0 0 2025-04-15T20:28:29-04:00
3336003 PENN AVENUE PARTNERS 9e981198-294d-44f2-aaea-53d8acd8ed53 Q1 PENN AVENUE PARTNERS 400918672 EXTREME NETWORKS 2025 first_quarter TAR Monitor tariffs and trade policy issues.   10000   0 0 2025-04-16T05:30:34-04:00
3336087 BALLARD PARTNERS e488e581-0289-45ef-bdb5-179da2191cf2 Q1 BALLARD PARTNERS 401104288 LUPIN PHARMACEUTICALS INC. 2025 first_quarter TAR Advocacy and guidance related to trade and tariffs. U.S. Trade Representative (USTR),White House Office 80000   0 0 2025-04-16T08:31:15-04:00
3336094 BALLARD PARTNERS dbb73038-bb40-4ef5-8486-ca90cd6c3726 Q1 BALLARD PARTNERS 401104288 MHP FOOD TRADING LLC 2025 first_quarter TAR Market access for agriculture and trade/tariff relief. HOUSE OF REPRESENTATIVES,SENATE,State, Dept of (DOS),White House Office 110000   0 0 2025-04-16T08:36:46-04:00
3336440 THE CSL GROUP, INC. 0e4475d5-abb8-4182-b1c1-b97f31325885 Q1 THE CSL GROUP, INC. 400978796 THE CSL GROUP INC. 2025 first_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   70000 0 0 2025-04-16T10:44:58-04:00
3336508 KOUNTOUPES DENHAM CARR & REID, LLC ffc52a7d-b5ee-4f1a-ad6b-dd5bbc68b832 Q1 KOUNTOUPES DENHAM CARR & REID, LLC 320918 APOTEX, CORP. 2025 first_quarter TAR Issues related to tariffs and generic pharmaceuticals. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-04-16T11:04:26-04:00
3336673 ICE MILLER LLP 4abf73f2-b1aa-47a5-9361-ba1d160323ae Q1 ICE MILLER LLP 67854 PROXIMO SPIRITS 2025 first_quarter TAR Issues regarding cross-border trade laws and tariffs related to distilled spirits. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-04-16T11:41:26-04:00
3336719 BROWNSTEIN HYATT FARBER SCHRECK, LLP eaee49c3-2629-40d2-aaa0-141a7069e2be Q1 BROWNSTEIN HYATT FARBER SCHRECK, LLP 7257 CHIC GROUP INCORPORATED 2025 first_quarter TAR Assist with non-tariff barriers and regulatory issues within the Dominican Republic. Agriculture, Dept of (USDA),Commerce, Dept of (DOC),State, Dept of (DOS) 30000   0 0 2025-04-16T11:52:34-04:00
3336889 HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION 758b374d-6b6a-4ac0-8c40-48cc912478af Q1 HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION 40011087 HEALTH INDUSTRY DISTRIBUTORS ASSOCIATION 2025 first_quarter TAR Linda Rouse O'Neill ceased lobbying for HIDA on 2/7/2025. Legislative and executive branch action with respect to tariffs and tariff exclusions on medical products: including IEEPA reciprocal tariffs, IEEPA border/fentanyl tariffs on China, Mexico and Canada, tariff investigations pursuant to Sec 301 and Sec 232 on medical products. Medical Supply Chain Resiliency Act (S. 998/HR 2213) Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)   30000 0 0 2025-04-16T12:42:10-04:00
3336908 JPC STRATEGIES, LLC c7f70a26-86dc-4dda-a10b-bc9bf707b6d6 Q1 JPC STRATEGIES 401107007 PUBLIC STRATEGIES WASHINGTON OBO SCHAEFFLER GROUP USA INC. 2025 first_quarter TAR Discussed recent tariffs put on by the Administration. HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-04-16T12:50:04-04:00
3337421 STRATEGIES 360 732ebb1c-559c-4f09-937c-70d567947620 Q1 STRATEGIES 360 79175 THE GAS COMPANY, LLC DBA HAWAII GAS 2025 first_quarter TAR Issues related to tariffs on shipments of Canadian propane HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-04-16T14:54:54-04:00
3337978 ADVANCED POLICY CONSULTING, LLC 9b173e9d-9933-41ec-a9ff-01df1107bf6d Q1 ADVANCED POLICY CONSULTING, LLC 401103524 POLARIS INDUSTRIES, INC. 2025 first_quarter TAR Issues related to tariffs that impact Polaris. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-04-16T16:37:31-04:00
3338036 MR. BRIAN KELLY f52ac711-dd2d-4338-aaf0-2964bc3821d5 1A MR. BRIAN KELLY 40024191 TAKEDA PHARMACEUTICAL COMPANY 2025 first_quarter TAR Government tariffs on drug imporatation. U.S. Trade Representative (USTR),White House Office 10000   0 0 2025-04-16T16:46:12-04:00
3338048 MS. MISSY BRANSON ce8345da-3f94-431e-a2b1-3857e08fd8c1 Q1 MS. MISSY BRANSON 400359656 GLEN RAVEN INC 1831 NORTH PARK AVENUE GLEN RAVEN NC 27217 2025 first_quarter TAR American Manufacturing Competitiveness Act (AMCA) PL 114-159: ITC report to Congress on recommendations for a miscellaneous tariff bill (MTB) and MTB legislation Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 30000   0 0 2025-04-16T16:47:38-04:00
3338062 INNOVATIVE FEDERAL STRATEGIES, LLC b4cc2bbc-603a-4d95-a799-b0383c09236f 1T INNOVATIVE FEDERAL STRATEGIES, LLC 10800 HALOCARBON LIFE SCIENCES, LLC 2025 first_quarter TAR Issues related to the domestic production of general anesthesia. HOUSE OF REPRESENTATIVES 10000   0 1 2025-04-16T16:48:30-04:00
3338218 MERCURY PUBLIC AFFAIRS, LLC c046055c-f2aa-4623-ba24-68394f858e46 Q1 MERCURY PUBLIC AFFAIRS, LLC 70175 DANAHER CORPORATION 2025 first_quarter TAR Issues related to science & biotechnology products HOUSE OF REPRESENTATIVES,SENATE,White House Office 50000   0 0 2025-04-16T17:22:46-04:00
3338697 BALLARD PARTNERS 46f41b8a-966c-4e88-a0fd-2788d97da4af Q1 BALLARD PARTNERS 401104288 MOORE CAPITAL MANAGEMENT, LLC 2025 first_quarter TAR Guidance related to trade and tariffs.   80000   0 0 2025-04-16T22:25:39-04:00
3338739 BALLARD PARTNERS 8d7afb48-70df-40bd-b299-9e18ac3c359d Q1 BALLARD PARTNERS 401104288 ORBIA FLUOR ENERGY MATERIALS (KOURA) 2025 first_quarter TAR Advocacy related to trade and tariffs.   40000   0 0 2025-04-17T00:43:32-04:00
3338765 BALLARD PARTNERS e8c52cd4-c02e-4529-b1a3-8c8b5e07c830 Q1 BALLARD PARTNERS 401104288 REYES HOLDINGS, LLC 2025 first_quarter TAR Issues regarding trade/tariffs. Commerce, Dept of (DOC),SENATE 120000   0 0 2025-04-17T05:22:53-04:00
3338836 BALLARD PARTNERS e7bb661e-ceef-41cb-a28a-ea4f0b1fb175 Q1 BALLARD PARTNERS 401104288 SHARKNINJA OPERATING LLC 2025 first_quarter TAR Exemptions and extension of 301 tariffs.   60000   0 0 2025-04-17T07:15:10-04:00
3339151 DATA CENTER COALITION 10129d84-6a65-458f-83ba-9743cca5f530 Q1 DATA CENTER COALITION 401109135 DATA CENTER COALITION 2025 first_quarter TAR Tariff Policy HOUSE OF REPRESENTATIVES,SENATE   123000 0 0 2025-04-17T09:45:41-04:00
3339249 ARNOLD & PORTER KAYE SCHOLER LLP 2ea51e5d-04b9-44a3-a898-6b4a6541414b Q1 ARNOLD & PORTER KAYE SCHOLER LLP 4301 SOCIETY OF NUCLEAR MEDICINE AND MOLECULAR IMAGING 2025 first_quarter TAR Issues related to tariffs on radiopharmaceuticals. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-04-17T10:00:53-04:00
3339324 THE NEW ENGLAND COUNCIL 6aac8246-1913-4a7b-9049-a7ccd8c0e2bd Q1 THE NEW ENGLAND COUNCIL 29106 NEW ENGLAND COUNCIL 2025 first_quarter TAR Tariffs on goods imported from Canada, China, and Mexico Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR)     0 0 2025-04-17T10:15:55-04:00
3339356 DOMTAR CORPORATION 02ee7d0c-123b-41d5-80ed-0df39cd16768 Q1 DOMTAR CORPORATION 401108705 DOMTAR CORPORATION 2025 first_quarter TAR Discussed the impact of tariffs HOUSE OF REPRESENTATIVES,SENATE,White House Office   190000 0 0 2025-04-17T10:19:40-04:00
3340010 VENABLE LLP 7033148a-9f66-4bef-8071-29fbe9107048 Q1 VENABLE LLP 39941 DYSTAR LP 2025 first_quarter TAR Legislation not yet introduced to extend the temporary suspension of duty on Disperse Red 60, Disperse Yellow 64, Vat Blue 66, Acid Black 172,Reactive Blue 224, Cuprate (4-), Reactive Yellow 27, Disperse Blue 77, Solvent Yellow 163, 1H-Xantheno, Reactive Red 123, Reactive Black 5,Disperse Blue 284, Reactive Red 198, Acid Blue 324, Acid Yellow 151, Acid Blue 221, Acid Yellow 137, Acid Yellow 230, Acid Red 414, DisperseRed 367, Reduced Vat Blue 1, Acid Red 278, Red 84, Acetic acid, Acid Yellow 7, Acid Blue 171, Reactive Blue 19, Disperse Yellow 184:1, Acid Red182, mixtures of (3-Pyridinecarbonitrile, 5-[2-cyano-4-nitrophenyl)diazenyl]-2-[[2-(2-hydroxyethoxy) ethyl]amino]-4-methyl-6- (phenylamino)-) and(3-Pyridinecarbonitrile, 5-[(2-cyano-4-nitrophenyl)diazenyl]-6-[[2-(2-hydroxyethoxy) ethyl]amino]-4-methyl-2-(phenylamino)-), Direct Green 91,Disperse Red 159, Reactive Red 122, Cobaltate (2-) and Cobaltate (3-), Disperse Red 311, Reactive Blue 187, Disperse Yellow 71, Acid Black 244,(Chromate(2-), (Cobaltate(1-), and Chromate(1-), Acid Blue 284, Basic Blue 94:1, Disperse Orange 288, Disperse Blue 284, Disperse Blue 56, AcidBlue 264, (9, 10-Anthracenedione, 1,5-diamino-4,8-dihydroxy(4-hydroxyphenyl)-) and 9,10-Anthracenedione, 1,5-diamino-4,8-dihydroxy(4-methoxyphenyl)-1), Acid Red 426, Reactive Blue 250, Reactive Black 5, Reactive Black 5, Benzenesulfonic acid, and 1-Naphthalenesulfonic acid, Disperse Red 367, Benzo, and Acetic acid, Disperse Blue 77, Reactive Red 198, Reactive Red 239, Reactive Blue 19. HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-04-17T11:36:31-04:00
3340387 PIKE ASSOCIATES LLC f83e088b-dbe3-4a33-b1f1-ec480f7e9901 Q1 PIKE ASSOCIATES LLC 400458236 BUMBLE BEE SEAFOODS, LLC 2025 first_quarter TAR proposed tariffs on imported seafood U.S. Trade Representative (USTR)     0 0 2025-04-17T12:16:46-04:00
3340565 MEHLMAN CONSULTING, INC. b4fae50e-5003-421b-b434-220b945978f9 Q1 MEHLMAN CONSULTING, INC. 284950 ONEOK, INC. 2025 first_quarter TAR Tariff bills and Executive Actions HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-04-17T12:37:27-04:00
3340578 S.C. JOHNSON & SON, INC. a445984a-68c0-47a9-bb2e-c981249715c3 Q1 S.C. JOHNSON & SON, INC. 20697 S.C. JOHNSON & SON, INC. 2025 first_quarter TAR U.S. tariff policy (not tied to specific legislation), in particular maintaining exemption for USMCA-qualified goods from U.S. tariffs imposed on Canada and Mexico. HOUSE OF REPRESENTATIVES,SENATE   79373 0 0 2025-04-17T12:39:34-04:00
3340636 SCHWAN'S COMPANY 8e24b393-480c-410f-a566-7499959bcf80 Q1 SCHWAN'S COMPANY 401103276 SCHWAN'S COMPANY 2025 first_quarter TAR Retaliatory tariffs on exports, tariffs on imported finished products, tariffs on imported ingredients HOUSE OF REPRESENTATIVES,SENATE   30000 0 0 2025-04-17T12:43:55-04:00
3341026 ORION ADVOCATES 04e0a8b5-a846-4194-8022-9a74446c1794 Q1 ORION ADVOCATES 400320506 DOMTAR CORPORATION FKA PAPER EXCELLENCE HOLDINGS CORPORATION FKA DOMTAR 2025 first_quarter TAR MTB HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-04-17T13:52:50-04:00
3341104 HITACHI ENERGY USA INC e3d5f974-3583-4f6c-bf20-5831774d2d86 Q1 HITACHI ENERGY USA INC 401105814 HITACHI ENERGY USA INC 2025 first_quarter TAR Federal policy relating to Sec. 301 tariffs and Sec. 232 tariffs. Executive Office of the President (EOP),HOUSE OF REPRESENTATIVES,SENATE   140000 0 0 2025-04-17T14:04:00-04:00
3341148 NEW YORK FARM BUREAU, INC. 892ee64e-3a3d-4b2c-be0a-e1068c3b30a0 Q1 NEW YORK FARM BUREAU, INC. 53777 NEW YORK FARM BUREAU INC 2025 first_quarter TAR Tariffs impacting agriculture input costs and international markets. HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2025-04-17T14:09:41-04:00
3341178 IPOLICY SOLUTIONS 61071c26-121e-4772-9157-faa079a9bf2e Q1 IPOLICY SOLUTIONS 401105127 TWIST BIOSCIENCE CORPORATION 2025 first_quarter TAR HR 694/S 206 Restoring Trade Fairness Act HOUSE OF REPRESENTATIVES,SENATE 75000   0 0 2025-04-17T14:11:53-04:00
3341751 HANCE SCARBOROUGH 1ce7fb83-4a81-4c6c-be06-db5f3a44f668 Q1 HANCE SCARBOROUGH 17443 NATIONAL INDEPENDENT AUTOMOBILE DEALERS ASSOCIATION 2025 first_quarter TAR REPAIR Act HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-04-17T15:14:03-04:00
3342080 EASTMAN CHEMICAL COMPANY 3cd91e2f-2e58-48e6-b046-12bfd5702c3f Q1 EASTMAN CHEMICAL COMPANY 13005 EASTMAN CHEMICAL COMPANY 2025 first_quarter TAR MTB 301 tariffs tariff policy HOUSE OF REPRESENTATIVES,SENATE   870000 0 0 2025-04-17T15:37:45-04:00
3342098 HANCE SCARBOROUGH 3e0aa3cb-a950-4159-bda2-7cadbab53b91 Q1 HANCE SCARBOROUGH 17443 AMERICAN BEEKEEPING FEDERATION 2025 first_quarter TAR Pesticides Issues, FY25 Appropriations, Farm Bill Agriculture, Dept of (USDA),HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-04-17T15:38:20-04:00
3342258 HANCE SCARBOROUGH 8ade7efc-b57d-425d-b4a3-ccb45862c937 Q1 HANCE SCARBOROUGH 17443 THE APP LAB 2025 first_quarter TAR Tariff/Business Issues HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-04-17T15:50:53-04:00
3342350 HANCE SCARBOROUGH 6fe7ed65-6952-4df5-bb18-8004a4001c95 Q1 HANCE SCARBOROUGH 17443 BUSINESS COUNCIL OF CANADA 2025 first_quarter TAR Tariff/Business Issues HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-04-17T15:59:28-04:00
3342587 HITACHI, LTD ae600853-3ec7-44fe-8d80-c18278f83d78 Q1 HITACHI, LTD 45937 HITACHI, LTD 2025 first_quarter TAR Issues pertaining to the impacts of tariffs on international supply chains HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2025-04-17T16:30:00-04:00
3342598 CARDINAL INFRASTRUCTURE LLC fb3d9ddd-8d94-4d43-a0e3-81908d55fddb Q1 CARDINAL INFRASTRUCTURE LLC 299913 NEW FLYER OF AMERICA INC. 2025 first_quarter TAR Administration Canadian Tariff Proposal Federal Transit Administration (FTA),HOUSE OF REPRESENTATIVES,SENATE 45000   0 0 2025-04-17T16:30:19-04:00
3342686 BASF CORPORATION b87c293c-60f8-4310-8067-749c4aa99e96 Q1 BASF CORPORATION 5506 BASF CORPORATION 2025 first_quarter TAR Tarrifs. (H.R.8398 Miscellaneous Tariff Bill Reform Act). BASF supports the temporary reduction or suspension of duties on imports of goods not domestically produced. Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   1050000 0 0 2025-04-17T16:43:11-04:00
3343243 BALL CORPORATION b33313f3-57dd-40d3-9356-8e93675745bd Q1 BALL CORPORATION 5211 BALL CORPORATION 2025 first_quarter TAR General discussions about impact of aluminum 232 tariffs on the beverage can manufacturing industry. S.J. Res. 37 - A resolution to terminate the Canadian trade war (and the IEEPA tariffs on Canada). HOUSE OF REPRESENTATIVES,SENATE   210000 0 0 2025-04-17T18:56:40-04:00
3343515 BALLARD PARTNERS 3021c798-c588-47bf-9d4b-2f8c66805e4b Q1 BALLARD PARTNERS 401104288 THE TOY ASSOCIATION 2025 first_quarter TAR Guidance and advocacy related to tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office 90000   0 0 2025-04-17T23:15:10-04:00
3344070 NATIONAL ROOFING CONTRACTORS ASSOCIATION cb52e06b-e652-4c9e-bdc9-867413229d54 Q1 NATIONAL ROOFING CONTRACTORS ASSOCIATION 28504 NATIONAL ROOFING CONTRACTORS ASSOCIATION 2025 first_quarter TAR Oppose tariffs that harm the roofing industry Support steady supply chain for solar industry Commerce, Dept of (DOC),Council of Economic Advisers (CEA),HOUSE OF REPRESENTATIVES,President of the U.S.,SENATE,U.S. Trade Representative (USTR)   200000 0 0 2025-04-18T09:33:13-04:00
3344323 WILLIAMS AND JENSEN, PLLC 7cc0bbbb-fd8c-4c6f-a143-c39bddac916c Q1 WILLIAMS AND JENSEN, PLLC 41454 CHRISTMAS TRADE GROUP 2025 first_quarter TAR US policy regarding proposed reciprocal and sectoral tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-04-18T10:13:43-04:00
3344350 ONEOK INC. 0ccfccf2-2906-44f3-8c9c-9abbebfa3394 Q1 ONEOK INC. 401105498 ONEOK INC. 2025 first_quarter TAR Tariff bills and Executive Actions HOUSE OF REPRESENTATIVES,SENATE   340000 0 0 2025-04-18T10:16:08-04:00
3344556 AIR-CONDITIONING, HEATING, AND REFRIGERATION INSTITUTE 046f733d-bad1-405d-9d57-23fd9593cee0 Q1 AIR-CONDITIONING, HEATING, AND REFRIGERATION INSTITUTE 556 AIR-CONDITIONING, HEATING, AND REFRIGERATION INSTITUTE 2025 first_quarter TAR Legislative proposals related to tariffs. Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,Natl Economic Council (NEC),President of the U.S.,SENATE,U.S. Trade Representative (USTR)   248068 0 0 2025-04-18T10:37:12-04:00
3344997 MEHLMAN CONSULTING, INC. 4794e4dc-aa57-494b-aae3-fa2602ac05a6 Q1 MEHLMAN CONSULTING, INC. 284950 GE AEROSPACE 2025 first_quarter TAR Monitoring US trade and tariff policy.   50000   0 0 2025-04-18T11:23:17-04:00
3345085 NATIONAL BUSINESS AVIATION ASSOCIATION, INC. aa9575db-842e-4077-9b4c-60834560b83f Q1 NATIONAL BUSINESS AVIATION ASSOCIATION, INC. 27332 NATIONAL BUSINESS AVIATION ASSOCIATION INC 2025 first_quarter TAR Tariff impact on aviation HOUSE OF REPRESENTATIVES,SENATE   350000 0 0 2025-04-18T11:38:10-04:00
3345150 REINECKE STRATEGIC SOLUTIONS, INC. d337ab4f-0059-471e-b005-8431f9e467af Q1 REINECKE STRATEGIC SOLUTIONS, INC. 298012 UNITED NATURAL PRODUCTS ALLIANCE 2025 first_quarter TAR Tariffs on critical nutrients and dietary supplements. Commerce, Dept of (DOC),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR) 10000   0 0 2025-04-18T11:53:43-04:00
3345241 REINECKE STRATEGIC SOLUTIONS, INC. 8da8516e-fcfc-4fb4-b33b-17a2b93feb9b Q1 REINECKE STRATEGIC SOLUTIONS, INC. 298012 PHARMAVITE LLC 2025 first_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-04-18T12:04:11-04:00
3345425 TEVA PHARMACEUTICALS USA, INC. 26d49555-c502-4aa6-ad8f-31bc25d7df85 Q1 TEVA PHARMACEUTICALS USA, INC. 76695 TEVA PHARMACEUTICALS USA INC 2025 first_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),U.S. Trade Representative (USTR)   310000 0 0 2025-04-18T12:34:16-04:00
3345910 GAVEL RESOURCES, LLC ad3744c7-802f-4130-a180-1fb9220ac233 Q1 GAVEL RESOURCES, LLC 401103521 PARADIGM PIPELINE LLC 2025 first_quarter TAR Permitting and construction of oil and gas pipelines in the Bakken Shale oil formation in ND HOUSE OF REPRESENTATIVES,SENATE     0 0 2025-04-18T13:28:26-04:00
3346039 CEDIA 53fe6f1e-8a5e-4afc-baaf-7466db888785 Q1 CEDIA 401103945 CEDIA 2025 first_quarter TAR Advocated for a tariff exclusion procedure, support for the "CHIPS and Science Act" and support for the "Freedom to Invest in Tomorrow's Workforce Act" (H.R.1151/S.756) as part of the CEDIA Smart Home Day on Capitol Hill. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2025-04-18T13:44:52-04:00
3346292 WOODSIDE ENERGY GROUP LTD 8947accc-c22c-42a0-b9ef-5de11c2dd865 Q1 WOODSIDE ENERGY GROUP LTD 401107067 WOODSIDE ENERGY GROUP LTD 2025 first_quarter TAR Issues related to tariffs impact on materials needed to build a domestic liquefied natural gas (LNG) project and on U.S. LNG exports to foreign nations (no bill). Defense, Dept of (DOD),Energy, Dept of,HOUSE OF REPRESENTATIVES,Interior, Dept of (DOI),Natl Economic Council (NEC),SENATE,State, Dept of (DOS),Treasury, Dept of,U.S. Trade Representative (USTR)   210000 0 0 2025-04-18T14:15:42-04:00
3346496 FORBES-TATE 8c5e94cc-7bbf-4ac7-bf34-d39e38771f09 Q1 FORBES-TATE 400976792 CRESTVIEW STRATEGIES OBO TEKNION 2025 first_quarter TAR Issues related to pending Canadian Tariffs. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-04-18T14:44:02-04:00
3346536 MAYER BROWN LLP 5dde4b51-bfcb-42f7-944a-80173582b36d Q1 MAYER BROWN LLP 24123 ELEMENT ELECTRONICS 2025 first_quarter TAR Issues related to the Miscellaneous Tariff Bill. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-04-18T14:49:45-04:00
3346579 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS da15cdf6-7164-4d2b-a945-200c66577ffc Q1 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS 19775 INTERNATIONAL ASSOCIATION OF MACHINISTS AND AEROSPACE WORKERS 2025 first_quarter TAR Oppose Tariffs on Canada (No Bill Number) Support Tariff Resolution (S.J. Res. 37) Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,U.S. Trade Representative (USTR),White House Office   1100000 0 0 2025-04-18T14:56:54-04:00
3346663 GREATER CLEVELAND PARTNERSHIP db862a28-9990-449e-b7ed-74f03ae4e64b Q1 GREATER CLEVELAND PARTNERSHIP 82330 GREATER CLEVELAND PARTNERSHIP 2025 first_quarter TAR Discussed trade and impact from tariffs HOUSE OF REPRESENTATIVES,SENATE   90000 0 0 2025-04-18T15:06:04-04:00
3346807 INDIANA UNIVERSITY 47de3b9c-19c9-479c-bf0c-84545e7365c7 Q1 INDIANA UNIVERSITY 296236 INDIANA UNIVERSITY 2025 first_quarter TAR The draft ExCEL Act. SENATE   120000 0 0 2025-04-18T15:22:25-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 705.853ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API