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

823 rows where filing_period = "second_quarter" and issue_code = "BNK" 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

  • 2009 94
  • 2008 73
  • 2016 72
  • 2010 71
  • 2015 47
  • 2012 46
  • 2017 42
  • 2020 40
  • 2013 36
  • 2022 36
  • 2025 36
  • 2018 35
  • 2011 34
  • 2019 34
  • 2023 34
  • 2024 34
  • 2014 31
  • 2021 28

issue_code 1

  • BNK · 823 ✖

filing_period 1

  • second_quarter · 823 ✖
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
3380064 ALLON ADVOCACY, LLC 465516de-cb15-4d11-bc72-54de72c737f3 Q2 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2025 second_quarter BNK Issues related to student debt relief and unsecured consumer debt relief. Consumer Financial Protection Bureau (CFPB),Federal Deposit Insurance Corporation (FDIC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of the Comptroller of the Currency (OCC),SENATE 50000   0 0 2025-07-11T13:46:46-04:00
3380071 ALLON ADVOCACY, LLC 512940fc-2af9-4e94-9e65-2592c2a12ad5 Q2 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2025 second_quarter BNK Issues related to consumer debt relief and debt settlement for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-07-11T13:53:55-04:00
3380509 PACE, LLP 806c6439-ae0a-4419-9905-728b85da0221 Q2 PACE, LLP 30495 NATIONAL ASSN OF CREDIT MANAGEMENT 2025 second_quarter BNK General Bankruptcy issues HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-13T11:03:27-04:00
3385409 ALLIANCE FOR RETIRED AMERICANS 16120632-c9b4-443d-8846-b606455def86 Q2 ALLIANCE FOR RETIRED AMERICANS 67238 ALLIANCE FOR RETIRED AMERICANS 2025 second_quarter BNK 1. S. 1381, Protecting Employees and Retirees in Business Bankruptcies Act of 2025, entire bill SENATE   80000 0 0 2025-07-16T14:20:21-04:00
3386732 WILMER CUTLER PICKERING HALE AND DORR LLP d999021b-d245-4456-843e-e7b530d84e38 Q2 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2025 second_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-16T18:02:01-04:00
3387276 CAPITOL COUNSEL LLC a947b099-4f29-4057-bc06-abce633bd671 Q2 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2025 second_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-17T06:25:53-04:00
3389378 FEDERAL HALL POLICY ADVISORS, LLC a37e70fb-f3bf-4860-8e90-dbe7c2bccd96 Q2 FEDERAL HALL POLICY ADVISORS, LLC 401104646 LOAN SYNDICATIONS AND TRADING ASSOCIATION 2025 second_quarter BNK Issues related to private corporate credit HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-17T15:11:55-04:00
3390421 THE NICKLES GROUP, LLC 0d1b298e-7d58-4338-9605-e873871261cb Q2 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2025 second_quarter BNK Issues related to litigation reform. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-17T17:59:41-04:00
3396038 COVINGTON & BURLING LLP e073f72e-ccf7-4b98-83f0-d09137adda96 Q2 COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2025 second_quarter BNK Bankruptcy Law.       0 0 2025-07-18T15:24:49-04:00
3398175 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC ede570b0-7299-442f-8696-bf95eed27fa3 Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2025 second_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-19T07:49:25-04:00
3398180 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 7506da20-8157-4346-94d3-1bed88393d98 Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2025 second_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2025-07-19T07:51:18-04:00
3398994 K&L GATES, LLP a9d6b244-7f24-4767-af4a-52358621487c Q2 K&L GATES, LLP 32098 PENNSYLVANIA HIGHER EDUCATION ASSISTANCE AGENCY (PHEAA) 2025 second_quarter BNK Issues related to Consumer Financial Protection Bureau guidance and civil investigation demands and following the Consumer Financial Protection Act and CFPB Transparency and Accountability Reform Act. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-19T16:19:57-04:00
3401450 APPALACHIAN VOICES 929fd0c7-c71d-4a72-94ee-f2fa0ba47bf3 Q2 APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2025 second_quarter BNK Coal mining bankruptcies, lobbying for legislation to ensure money for reclamation after coal bankruptcies. No bill #s. HOUSE OF REPRESENTATIVES,SENATE   30000 0 0 2025-07-20T20:13:58-04:00
3402550 KELLEY DRYE & WARREN LLP c59a4d20-b104-4c42-971b-bccc7c857d3d Q2 KELLEY DRYE & WARREN LLP 307114 ANCESTRY 2025 second_quarter BNK Dont Sell My DNA Act (S. 1916) SENATE 30000   0 0 2025-07-21T08:54:05-04:00
3404200 KOCH GOVERNMENT AFFAIRS, LLC 02cf667c-e964-4bfc-93ba-6c33b8eb853c Q2 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2025 second_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   2300000 0 0 2025-07-21T10:24:30-04:00
3404351 COVINGTON & BURLING LLP 31831446-2a44-48ac-b31d-67bdd38bcc8b 2A COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2025 second_quarter BNK Bankruptcy Law.   20000   0 0 2025-07-21T10:31:32-04:00
3404423 CAPITOL HILL CONSULTING GROUP 51cd3424-c355-4ece-b65a-2263232f6c4e Q2 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2025 second_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-21T10:33:49-04:00
3405350 CAPITOL HILL CONSULTING GROUP 1a9a04d4-3c77-46a8-b40c-84f4afc4c7ce 2A CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2025 second_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-21T11:10:35-04:00
3405852 AMERICAN BANKERS ASSOCIATION db808f52-562a-4265-9ed3-2e0396717ed2 Q2 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2025 second_quarter BNK Bankruptcy reform legislation, including bills related to small business, student loans and related legislation Small business bankruptcy thresholds under Chapter 11, Subsection V HOUSE OF REPRESENTATIVES,SENATE   1960000 0 0 2025-07-21T11:35:40-04:00
3408606 MORAN GLOBAL STRATEGIES, INC. e960fd15-ccb1-4020-8ef3-cc3a4e9e607e Q2 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2025 second_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-21T13:29:50-04:00
3409836 AQUIA GROUP, LLC fb5fd14a-51fb-4d14-ac27-02d66fc3b8da Q2 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2025 second_quarter BNK Issues related to bankruptcy trustee fee schedule. Bankruptcy Administration Improvement Act (S. 1659, HR 3867)   20000   0 0 2025-07-21T14:14:06-04:00
3410003 AQUIA GROUP, LLC 9fd6ddc1-c8f4-43bd-b63b-dd2fbcddc194 Q2 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF FEDERAL EQUITY RECEIVERS (NAFER) 2025 second_quarter BNK Issues related to opportunities to improve the processes around tax refund and liability determinations in Federal Receivership cases.   20000   0 0 2025-07-21T14:21:45-04:00
3411764 BOSE PUBLIC AFFAIRS GROUP 71fee018-bcf5-4a5c-88f9-38d9bd400c8f Q2 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2025 second_quarter BNK Legislation affecting the inclusion of education loans in bankruptcy filings HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-07-21T15:31:42-04:00
3413342 CHAMBER OF COMMERCE OF THE U.S.A. 9540c35a-5726-45ad-aa09-89283b86b0c0 Q2 CHAMBER OF COMMERCE OF THE U.S.A. 38756 CHAMBER OF COMMERCE OF THE U.S.A. 2025 second_quarter BNK Various issues relating to U.S. Trustees authority to oversee the administration of bankruptcy trust funds; mass tort litigation HOUSE OF REPRESENTATIVES,SENATE   19340000 0 0 2025-07-21T16:26:04-04:00
3416938 LODESTONE DC 13e58a37-92e9-4b19-9a03-eca145a3f0da Q2 LODESTONE DC 401107308 BETTER FUTURE FORWARD 2025 second_quarter BNK Outcomes based financing options for students, including the forthcoming Outcomes Based Financing for Students Act and bankruptcy of private loans Outcomes based financing options for students in the One Big Beautiful Bill Act Education, Dept of,HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-21T18:30:47-04:00
3580926 ALLON ADVOCACY, LLC 465516de-cb15-4d11-bc72-54de72c737f3 Q2 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2025 second_quarter BNK Issues related to student debt relief and unsecured consumer debt relief. Consumer Financial Protection Bureau (CFPB),Federal Deposit Insurance Corporation (FDIC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of the Comptroller of the Currency (OCC),SENATE 50000   0 0 2025-07-11T13:46:46-04:00
3580933 ALLON ADVOCACY, LLC 512940fc-2af9-4e94-9e65-2592c2a12ad5 Q2 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2025 second_quarter BNK Issues related to consumer debt relief and debt settlement for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2025-07-11T13:53:55-04:00
3581371 PACE, LLP 806c6439-ae0a-4419-9905-728b85da0221 Q2 PACE, LLP 30495 NATIONAL ASSN OF CREDIT MANAGEMENT 2025 second_quarter BNK General Bankruptcy issues HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-13T11:03:27-04:00
3586271 ALLIANCE FOR RETIRED AMERICANS 16120632-c9b4-443d-8846-b606455def86 Q2 ALLIANCE FOR RETIRED AMERICANS 67238 ALLIANCE FOR RETIRED AMERICANS 2025 second_quarter BNK 1. S. 1381, Protecting Employees and Retirees in Business Bankruptcies Act of 2025, entire bill SENATE   80000 0 0 2025-07-16T14:20:21-04:00
3587594 WILMER CUTLER PICKERING HALE AND DORR LLP d999021b-d245-4456-843e-e7b530d84e38 Q2 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2025 second_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-07-16T18:02:01-04:00
3588138 CAPITOL COUNSEL LLC a947b099-4f29-4057-bc06-abce633bd671 Q2 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2025 second_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-17T06:25:53-04:00
3590240 FEDERAL HALL POLICY ADVISORS, LLC a37e70fb-f3bf-4860-8e90-dbe7c2bccd96 Q2 FEDERAL HALL POLICY ADVISORS, LLC 401104646 LOAN SYNDICATIONS AND TRADING ASSOCIATION 2025 second_quarter BNK Issues related to private corporate credit HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2025-07-17T15:11:55-04:00
3591283 THE NICKLES GROUP, LLC 0d1b298e-7d58-4338-9605-e873871261cb Q2 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2025 second_quarter BNK Issues related to litigation reform. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-07-17T17:59:41-04:00
3596900 COVINGTON & BURLING LLP e073f72e-ccf7-4b98-83f0-d09137adda96 Q2 COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2025 second_quarter BNK Bankruptcy Law.       0 0 2025-07-18T15:24:49-04:00
3599037 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC ede570b0-7299-442f-8696-bf95eed27fa3 Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2025 second_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-07-19T07:49:25-04:00
3599042 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 7506da20-8157-4346-94d3-1bed88393d98 Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2025 second_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2025-07-19T07:51:18-04:00
3189926 MEEKS, BUTERA & ISRAEL PLLC 059e1ad2-9c79-4398-8286-97fed836a563 Q2 MEEKS, BUTERA & ISRAEL PLLC 401105818 BROADBILL INVESTMENT PARTNERS, LLC 2024 second_quarter BNK Bankruptcy reform issues. HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 20000   0 0 2024-07-12T16:48:41-04:00
3190283 THORSEN FRENCH ADVOCACY LLC 886590f8-26d8-4b3f-90f8-9688d4b33cbe Q2 THORSEN FRENCH ADVOCACY LLC 400599826 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 second_quarter BNK Bankruptcy Policy. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2024-07-13T14:34:42-04:00
3190669 K&L GATES, LLP 92867d21-f51c-45b4-aead-bdf6d6d5b29a Q2 K&L GATES, LLP 32098 PENNSYLVANIA HIGHER EDUCATION ASSISTANCE AGENCY (PHEAA) 2024 second_quarter BNK Issues related to Consumer Financial Protection Bureau guidance and civil investigation demands and following the Consumer Financial Protection Act and CFPB Transparency and Accountability Reform Act. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2024-07-14T12:16:31-04:00
3191145 PURDUE PHARMA, LP fe7775e7-91b8-4443-ba2c-685a2305ca4b Q2 PURDUE PHARMA, LP 81214 PURDUE PHARMA LP 2024 second_quarter BNK Monitored congressional activity related to bankruptcy reform.     100000 0 0 2024-07-14T18:46:26-04:00
3195190 CORNERSTONE GOVERNMENT AFFAIRS, INC. b58c9804-50ad-49f9-bbb8-53b81f469285 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 MR. JAY ALIX 2024 second_quarter BNK Protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2024-07-16T23:12:55-04:00
3195447 ALLON ADVOCACY, LLC 00c74389-20a9-4244-a47d-63b9be718159 Q2 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2024 second_quarter BNK Issues related to consumer debt relief, debt settlement and debt consolidation for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Deposit Insurance Corporation (FDIC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of the Comptroller of the Currency (OCC),SENATE 50000   0 0 2024-07-17T10:39:07-04:00
3195483 ALLON ADVOCACY, LLC aa2468af-0737-4d90-8b8c-68558d26c3d5 Q2 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2024 second_quarter BNK Issues related to consumer debt relief and debt settlement for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE 70000   0 0 2024-07-17T10:48:54-04:00
3195633 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 02ae96b4-db5f-41a0-90b0-4b8624810472 Q2 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 19935 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 second_quarter BNK S. 4150 "Bankruptcy Threshold Adjustment Extension Act" to extend Small Business Reorganization Act (SBRA), Subchapter V dealing with bankruptcy for two year period no House companion bill to date HOUSE OF REPRESENTATIVES,SENATE   330000 0 0 2024-07-17T11:34:30-04:00
3197555 THE NICKLES GROUP, LLC 456ba0a0-4393-4102-b7ef-1ddc29f4995c Q2 THE NICKLES GROUP, LLC 293335 KOCH GOVERNMENT AFFAIRS, LLC 2024 second_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2024-07-18T07:53:32-04:00
3199499 CAPITOL COUNSEL LLC 9dfa73ab-d300-4e6d-831a-07743fe8e10a Q2 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2024 second_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2024-07-18T14:10:02-04:00
3206479 KOCH GOVERNMENT AFFAIRS, LLC ebada118-f912-404a-9e3b-e7ef24d16adc Q2 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2024 second_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   2110000 0 0 2024-07-19T15:21:48-04:00
3207847 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC c52506ed-ce5c-4f00-a380-c8bf7f83a9ac Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 second_quarter BNK Monitor efforts to amend or extend Subchapter V of Chapter 11, Title 11, US Code; S 4150, Bankruptcy Threshold Amendments HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2024-07-19T17:59:41-04:00
3207864 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC cc321f06-198b-4fa6-ad26-157417ac8cdb Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2024 second_quarter BNK Monitor new bankruptcy legislation, Sub V extension and consumer issues in expiring provisions; S 4150 Bankruptcy Threshold Amendments HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2024-07-19T18:02:28-04:00
3209165 AIR LINE PILOTS ASSOCIATION f30a8465-8250-42c2-bac2-3301d1eb4125 Q2 AIR LINE PILOTS ASSOCIATION 580 AIR LINE PILOTS ASSOCIATION 2024 second_quarter BNK S 1838 Credit Card Competition Act of 2023. HOUSE OF REPRESENTATIVES,SENATE   198000 0 0 2024-07-20T13:30:05-04:00
3209727 AQUIA GROUP, LLC 75ab9f24-302e-4178-8b53-59164892a016 Q2 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2024 second_quarter BNK Issues related to bankruptcy trustee fee schedule. S.4150 - Bankruptcy Threshold Adjustment Extension Act   20000   0 0 2024-07-20T21:42:45-04:00
3209732 AQUIA GROUP, LLC e2f3ac17-3485-4dfd-b4df-a5e0c47daffc Q2 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF FEDERAL EQUITY RECEIVERS (NAFER) 2024 second_quarter BNK Issues related to opportunities to improve the processes around tax refund and liability determinations in Federal Receivership cases.   20000   0 0 2024-07-20T21:50:47-04:00
3211098 APPALACHIAN VOICES 6489707a-2f14-4bc2-8269-ebe00475f776 Q2 APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2024 second_quarter BNK Generally advocating for policies that prevent coal companies from using bankruptcy to avoid responsibility for liabilities such as black lung payments and coal reclamation. HOUSE OF REPRESENTATIVES,Office of Surface Mining Reclamation & Enforcement,SENATE   40000 0 0 2024-07-21T22:35:51-04:00
3213088 DISCOVER FINANCIAL SERVICES dcbe4cdc-27d5-4de3-918c-241e34ee4380 Q2 DISCOVER FINANCIAL SERVICES 318414 DISCOVER FINANCIAL SERVICES 2024 second_quarter BNK HR. 138 Private Student Loan Bankruptcy Fairness Act of 2023. Issues related to the discharge of private student loan debt. HOUSE OF REPRESENTATIVES,SENATE   430000 0 0 2024-07-22T10:20:13-04:00
3213177 MORAN GLOBAL STRATEGIES, INC. b581568c-2958-47b8-a93a-1e4cb6e72cf5 Q2 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2024 second_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2024-07-22T10:23:39-04:00
3213546 AMERICAN BANKERS ASSOCIATION b7a75c77-6fee-4a42-9b42-96f364e30b42 Q2 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2024 second_quarter BNK Bankruptcy reform legislation, including bills related to small business, student loans and related legislation Small business bankruptcy thresholds under Chapter 11, Subsection V S.4150, Bankruptcy Threshold Adjustment Act. HOUSE OF REPRESENTATIVES,SENATE   1490000 0 0 2024-07-22T10:42:51-04:00
3214570 JOHNSON & JOHNSON SERVICES, INC. 892c5512-a57d-482f-aedb-86ee9c7d45f6 Q2 JOHNSON & JOHNSON SERVICES, INC. 20686 JOHNSON & JOHNSON SERVICES INC 2024 second_quarter BNK HR 5488, S 2805, "Protecting Our Courts from Foreign Manipulation Act of 2023", regarding provisions relating to transparency from foreign investors in US litigation. Issues related to: - Chapter 11 corporate bankruptcy process - Litigation reform HOUSE OF REPRESENTATIVES,SENATE   1120000 0 0 2024-07-22T11:36:37-04:00
3214623 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX c60e3eae-d733-4f4b-a06f-affe7f3804ea Q2 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX 401104915 LAKEVIEW CAPITAL HOLDINGS INC ON BEHALF OF MR JAY ALIX 2024 second_quarter BNK -Issues related to protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2024-07-22T11:39:39-04:00
3216974 COVINGTON & BURLING LLP 30cfb2ad-3242-4707-96fc-f3a48cf256b7 Q2 COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2024 second_quarter BNK Bankruptcy Law SENATE 10000   0 0 2024-07-22T13:58:22-04:00
3217622 CHAMBER OF COMMERCE OF THE U.S.A. ec3fd4e5-4d9f-412f-a67f-9400c8fa8f22 Q2 CHAMBER OF COMMERCE OF THE U.S.A. 38756 CHAMBER OF COMMERCE OF THE U.S.A. 2024 second_quarter BNK S. 4095, Stop Helping Outcome Preferences (SHOP) Act Potential legislation similar to S. 2817, Bankruptcy Venue Reform Act of 2021 Potential legislation similar to H.R. 4777/S. 2497, Nondebtor Release Prohibition Act of 2021 Potential legislation similar to S. 574, Providing Responsible Oversight of Trusts to Ensure Compensation and Transparency (PROTECT) Asbestos Victims Act of 2021 Various issues relating to bankruptcy; mass tort litigation; Chapter 11 bankruptcies including third-party releases; U.S. Trustees authority to oversee the administration of bankruptcy trust funds HOUSE OF REPRESENTATIVES,SENATE   13930000 0 0 2024-07-22T14:27:27-04:00
3218595 THE NICKLES GROUP, LLC eab971e6-3228-45a0-99b0-1cca90670e88 Q2 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2024 second_quarter BNK Issues concerning bankruptcy reform. SENATE 40000   0 0 2024-07-22T15:08:26-04:00
3219243 COGENT STRATEGIES LLC fb4ef476-6dea-4554-9fd6-d0b2c34692d4 Q2 COGENT STRATEGIES LLC 401104684 MR. JAY ALIX 2024 second_quarter BNK - Issues related to protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2024-07-22T15:36:55-04:00
3219795 FEDERAL HALL POLICY ADVISORS, LLC 9538e902-2b3b-4f6a-9e1e-fc6bb087a7f4 Q2 FEDERAL HALL POLICY ADVISORS, LLC 401104646 LOAN SYNDICATIONS AND TRADING ASSOCIATION 2024 second_quarter BNK Issues related to the reform of the bankruptcy court system. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2024-07-22T15:54:27-04:00
3219937 BOSE PUBLIC AFFAIRS GROUP 76f20476-06be-4dd7-9b2a-b6117fa4342c Q2 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2024 second_quarter BNK BNK: Legislation affecting the inclusion of education loans in bankruptcy filings. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2024-07-22T15:59:29-04:00
3220568 WILMER CUTLER PICKERING HALE AND DORR LLP fe305818-0119-4d46-832b-62bed05dadd1 Q2 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2024 second_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2024-07-22T16:25:45-04:00
3220754 ACG ADVOCACY 99436413-bdb0-4d18-be94-933c920926d6 Q2 ACG ADVOCACY 2057 COMMERCIAL BANKRUPTCY ALLIANCE 2024 second_quarter BNK Bankruptcy Issues. Monitor Venue Legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2024-07-22T16:32:56-04:00
3223812 GRUBHUB HOLDINGS INC. 63484f79-0e1f-42e0-becc-0c9690af8bcd Q2 GRUBHUB HOLDINGS INC. 401106201 GRUBHUB HOLDINGS INC. 2024 second_quarter BNK HR 3881: CREDIT CARD COMPETITION ACT OF 2023; ALL PROVISIONS OF THE BILL S 1838: CREDIT CARD COMPETITION ACT OF 2023; ALL PROVISIONS OF THE BILL HOUSE OF REPRESENTATIVES,SENATE   180000 0 0 2024-07-22T18:48:36-04:00
3224739 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 8e70be78-1cde-4d77-8ff0-8c5877da0ed4 Q2 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2024 second_quarter BNK Fair Debt Collection Act. Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2024-07-22T20:36:49-04:00
3231232 CAPITOL HILL CONSULTING GROUP 81619aab-6d76-4883-8a05-440a3fc36562 Q2 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2024 second_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2024-09-17T16:05:53-04:00
3239295 MR. PETER SNELL 802bbbc6-79fd-44c9-a6c8-3dbe487072a6 Q2 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2024 second_quarter BNK governmental bankruptcy issues; Federal aid to states HOUSE OF REPRESENTATIVES,SENATE 55000   0 0 2024-10-15T21:43:42-04:00
3002368 ALLON ADVOCACY, LLC a82452da-479a-4d29-b303-69036cd2e97d Q2 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2023 second_quarter BNK Issues related to consumer debt relief, debt settlement and debt consolidation for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Deposit Insurance Corporation (FDIC),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of the Comptroller of the Currency (OCC),SENATE 50000   0 0 2023-07-13T11:16:18-04:00
3002386 ALLON ADVOCACY, LLC 65b43325-f291-4e60-b9d3-7236f726173c Q2 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2023 second_quarter BNK Issues related to consumer debt relief and debt settlement for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2023-07-13T11:24:56-04:00
3002734 THE NICKLES GROUP, LLC 4c6c30a7-527f-434e-a79a-5bca34cb387b Q2 THE NICKLES GROUP, LLC 293335 KOCH GOVERNMENT AFFAIRS, LLC 2023 second_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2023-07-13T13:50:50-04:00
3003417 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX f8bf04e4-119a-467c-bc06-a3471b329392 Q2 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX 401104915 LAKEVIEW CAPITAL HOLDINGS INC ON BEHALF OF MR JAY ALIX 2023 second_quarter BNK -Issues related to protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE   220000 0 0 2023-07-13T20:58:15-04:00
3006061 RICHARD F. HOHLT 6fdcc989-3aab-4da4-bf47-300e814b9040 Q2 RICHARD F. HOHLT 18433 FIRST REPUBLIC BANK 2023 second_quarter BNK All legislation related to the above issue. HOUSE OF REPRESENTATIVES,SENATE     0 0 2023-07-16T20:36:55-04:00
3006069 RICHARD F. HOHLT 90727296-394f-4997-9a6a-0ba88c73e541 2T RICHARD F. HOHLT 18433 FIRST REPUBLIC BANK 2023 second_quarter BNK All legislation related to the above issue. HOUSE OF REPRESENTATIVES,SENATE     0 1 2023-07-16T20:39:16-04:00
3007067 PURDUE PHARMA, LP 22b74fdf-66fc-4889-90b8-0a82ba7df741 Q2 PURDUE PHARMA, LP 81214 PURDUE PHARMA LP 2023 second_quarter BNK Monitored congressional activity related to bankruptcy reform.     100000 0 0 2023-07-17T13:30:18-04:00
3010451 INTERNATIONAL COUNCIL OF SHOPPING CENTERS bfb6855a-ba9c-40a2-9e60-28981e54bbc6 Q2 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 19935 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2023 second_quarter BNK Potential technical corrections to Subchapter V of Small Business Reorganization Act of 2019 - - no bill HOUSE OF REPRESENTATIVES   380000 0 0 2023-07-18T13:55:45-04:00
3010643 CAPITOL COUNSEL LLC e4c96527-7c68-472c-a61e-e758b5ba3200 Q2 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2023 second_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2023-07-18T14:21:32-04:00
3012734 ALPINE GROUP PARTNERS, LLC. 6090ac41-d4b0-435e-b0e5-1ca92779e7c5 Q2 ALPINE GROUP PARTNERS, LLC. 1171 MANAGED FUNDS ASSOCIATION 2023 second_quarter BNK Legislation impacting capital financial markets, and commodity and swap markets Policies related to capital markets engagement and transparency Short sale transparency HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2023-07-18T23:37:05-04:00
3015130 MORAN GLOBAL STRATEGIES, INC. e34078be-f5e3-45d3-b75e-62efe646b482 Q2 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2023 second_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2023-07-19T12:23:36-04:00
3015579 DISCOVER FINANCIAL SERVICES 2b638b9c-def9-4d5a-bd18-b42979c575b6 Q2 DISCOVER FINANCIAL SERVICES 318414 DISCOVER FINANCIAL SERVICES 2023 second_quarter BNK HR 138 Private Student Loan Bankruptcy Fairness Act of 2023 Issues related to the discharge of private student loan debt HOUSE OF REPRESENTATIVES,SENATE   510000 0 0 2023-07-19T13:11:50-04:00
3016436 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 3193b374-3747-4eef-87e4-3f2310945d65 Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2023 second_quarter BNK Monitor efforts to amend or extend Subchapter V of Chapter 11, Title 11, US Code HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2023-07-19T14:33:00-04:00
3016484 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 11d7ddc9-a9c6-491d-8d4d-478dc10df64f Q2 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2023 second_quarter BNK Monitor new bankruptcy legislation, Sub V extension and consumer issues HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2023-07-19T14:35:29-04:00
3016996 APPALACHIAN VOICES 1a7ea2f7-015d-45ef-a7a5-8a5f9fba8f89 2A APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2023 second_quarter BNK Coal bankruptices (no bill number) HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2023-07-19T15:05:15-04:00
3018021 FEDERAL HALL POLICY ADVISORS, LLC 68561553-0e89-4ea5-bdc5-ce8bcbcb78d6 Q2 FEDERAL HALL POLICY ADVISORS, LLC 401104646 INVICTUS GLOBAL MANAGEMENT 2023 second_quarter BNK Creditor rights HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2023-07-19T16:09:48-04:00
3020474 COGENT STRATEGIES LLC 03966177-8c9e-43da-af0f-18033b64029d Q2 COGENT STRATEGIES LLC 401104684 MR. JAY ALIX 2023 second_quarter BNK - Issues related to protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2023-07-19T22:20:47-04:00
3023392 CAPITOL HILL CONSULTING GROUP 950d5f62-28ba-4d40-8b5f-866d611a5851 Q2 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2023 second_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2023-07-20T10:15:24-04:00
3023967 BGR GOVERNMENT AFFAIRS 35576cae-bb83-444c-a819-262601f512ac Q2 BGR GOVERNMENT AFFAIRS 5357 FRANKLIN RESOURCES, INC. 2023 second_quarter BNK Provide strategic advice and counsel on legislative and regulatory actions that are impacting or may potentially impact Franklin Resources and/or the financial services industry. Federal Reserve System,HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,Treasury, Dept of,White House Office 50000   0 0 2023-07-20T10:34:59-04:00
3024832 JOHNSON & JOHNSON SERVICES, INC. a029fafd-e098-4eca-b733-ef767080b4a5 Q2 JOHNSON & JOHNSON SERVICES, INC. 20686 JOHNSON & JOHNSON SERVICES INC 2023 second_quarter BNK - Issues related to the Chapter 11 corporate bankruptcy process HOUSE OF REPRESENTATIVES,SENATE   850000 0 0 2023-07-20T11:16:28-04:00
3025896 KOCH GOVERNMENT AFFAIRS, LLC 41d625cd-d784-4e78-a94a-c05021934ce6 Q2 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2023 second_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   2020000 0 0 2023-07-20T11:54:36-04:00
3027375 CHAMBER OF COMMERCE OF THE U.S.A. 5805c3cb-e8e7-4cb9-81ad-b25c9f13dfb2 Q2 CHAMBER OF COMMERCE OF THE U.S.A. 38756 CHAMBER OF COMMERCE OF THE U.S.A. 2023 second_quarter BNK Potential legislation similar to H.R. 4777, Nondebtor Release Prohibition Act of 2021 Potential legislation similar to S. 2497, Nondebtor Release Prohibition Act of 2021 Potential legislation similar to S. 574, Providing Responsible Oversight of Trusts to Ensure Compensation and Transparency (PROTECT) Asbestos Victims Act of 2021 Various issues relating to the U.S. Trustees authority to oversee the administration of bankruptcy trust funds; Chapter 11 bankruptcies, including third-party release HOUSE OF REPRESENTATIVES,SENATE   16390000 0 0 2023-07-20T12:51:32-04:00
3027856 MEEKS, BUTERA & ISRAEL PLLC 01c8bcc9-67f5-41ed-958d-5aaa3b67291b Q2 MEEKS, BUTERA & ISRAEL PLLC 401105818 BROADBILL INVESTMENT PARTNERS, LLC 2023 second_quarter BNK Bankruptcy reform issues. HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 30000   0 0 2023-07-20T13:07:19-04:00
3028901 CORNERSTONE GOVERNMENT AFFAIRS, INC. ccbf8c41-ec6c-4b01-b4a6-55e5a6476607 Q2 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 MR. JAY ALIX 2023 second_quarter BNK Protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2023-07-20T13:51:04-04:00
3028996 WILMER CUTLER PICKERING HALE AND DORR LLP 2ffc0e92-aa36-440d-9f2b-682e5fc515d8 Q2 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2023 second_quarter BNK U.S. Trustee Program   20000   0 0 2023-07-20T13:55:43-04:00
3030850 AMERICAN BANKERS ASSOCIATION 46514846-4d98-4215-9de7-7d3c617ee9ed Q2 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2023 second_quarter BNK Bankruptcy reform legislation, including bills dealing with small business, student loans and related legislation HOUSE OF REPRESENTATIVES,SENATE   2440000 0 0 2023-07-20T15:05:50-04:00
3031620 BOSE PUBLIC AFFAIRS GROUP f0ec5686-5deb-48d1-bbc7-e14bc3f7c133 Q2 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2023 second_quarter BNK BNK: Legislation affecting the inclusion of education loans in bankruptcy filings. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2023-07-20T15:33:43-04:00
3033041 THE NICKLES GROUP, LLC 4569dbd1-55c4-49e7-88a0-0b834f2cbe60 Q2 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2023 second_quarter BNK H.R. 4777/S. 2497, the Nondebtor Release Prohibition Act and issues concerning bankruptcy reform. SENATE 40000   0 0 2023-07-20T16:24:12-04:00
3036440 AMERICAN BAR ASSOCIATION b8c60b0b-5bcd-477f-86b1-c05fe3d9705c Q2 AMERICAN BAR ASSOCIATION 1808 AMERICAN BAR ASSOCIATION 2023 second_quarter BNK Draft legislation that would make the temporary Subchapter 5 and Chapter 13 threshold adjustments in the Bankruptcy Threshold Adjustment and Technical Corrections Act of 2022 (P.L. 117-151, S. 3823) permanent. HOUSE OF REPRESENTATIVES,SENATE   230000 0 0 2023-07-20T19:08:16-04:00
3036627 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 146b2f6a-6947-4a9f-8820-fb9c72a48a74 Q2 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2023 second_quarter BNK Fair Debt Collection Act. Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2023-07-20T19:26: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 1375.126ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API