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

789 rows where filing_period = "third_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 80
  • 2010 68
  • 2008 63
  • 2016 55
  • 2015 51
  • 2011 41
  • 2012 41
  • 2020 41
  • 2014 40
  • 2021 40
  • 2018 37
  • 2019 37
  • 2022 36
  • 2023 36
  • 2013 34
  • 2017 34
  • 2024 33
  • 2025 22

issue_code 1

  • BNK · 789 ✖

filing_period 1

  • third_quarter · 789 ✖
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
3428352 ALLON ADVOCACY, LLC c222878b-5953-40ca-b4b6-a96c6fdeccb6 Q3 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2025 third_quarter BNK Issues related to consumer debt relief, debt settlement and debt consolidation for unsecured consumer debt. Consumer Financial Protection Bureau (CFPB),Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-07T09:49:39-04:00
3428379 ALLON ADVOCACY, LLC 158c02aa-ed7b-47be-9ffd-442d521f0779 Q3 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2025 third_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-10-07T10:05:59-04:00
3432458 CAPITOL COUNSEL LLC 68d4ef07-4ee3-4d58-a42f-849e05fd34d0 Q3 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2025 third_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-14T15:34:49-04:00
3436529 MORAN GLOBAL STRATEGIES, INC. eb410185-5614-4d92-b9c9-bb3b04a3b3cb Q3 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2025 third_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-16T12:30:33-04:00
3436617 ALLIANCE FOR RETIRED AMERICANS 1527e745-a05c-4aa5-9ed7-1c5a9ec59311 Q3 ALLIANCE FOR RETIRED AMERICANS 67238 ALLIANCE FOR RETIRED AMERICANS 2025 third_quarter BNK 1. S. 1381, Protecting Employees and Retirees in Business Bankruptcies Act of 2025, entire bill SENATE   80000 0 0 2025-10-16T12:53:16-04:00
3442904 AXADVOCACY GOVERNMENT RELATIONS 059d9015-eb91-4fdc-8f97-51e745e17754 Q3 AXADVOCACY GOVERNMENT RELATIONS 401107432 D'ALESSIO LAW GROUP (ON BEHALF OF JAMES DONDERO) 2025 third_quarter BNK Issues related to bankruptcy proceedings in federal judiciary HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2025-10-17T15:32:22-04:00
3445114 WILMER CUTLER PICKERING HALE AND DORR LLP 316789b2-2ff1-4112-8698-4cd76da3319d Q3 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2025 third_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-10-18T16:08:45-04:00
3445799 CAPITOL HILL CONSULTING GROUP f01e8f1c-26f8-48ff-964e-93ff15d40ab3 Q3 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2025 third_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-19T09:18:21-04:00
3450789 BOSE PUBLIC AFFAIRS GROUP 41f8c2bf-8133-4cec-b60c-6ba5a444e362 Q3 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2025 third_quarter BNK Legislation affecting the inclusion of education loans in bankruptcy filings HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2025-10-20T10:30:53-04:00
3453708 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC b2345fd4-e726-48c2-ada0-2130cd82e62b Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2025 third_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code; HR 5371 HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2025-10-20T11:58:52-04:00
3453818 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC ce48c4a3-73a8-4286-a56d-e3a37523e93b Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2025 third_quarter BNK Monitor efforts to revive Subchapter V of the Bankruptcy Code HOUSE OF REPRESENTATIVES,SENATE 10000   0 0 2025-10-20T12:02:04-04:00
3454604 LODESTONE DC bb8f7163-0d40-4672-bff5-e0355261c3d6 Q3 LODESTONE DC 401107308 BETTER FUTURE FORWARD 2025 third_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 15000   0 0 2025-10-20T12:27:07-04:00
3454618 THE NICKLES GROUP, LLC cf91904b-76fd-4010-8252-312b1b60106d Q3 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2025 third_quarter BNK Issues related to litigation reform. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2025-10-20T12:27:14-04:00
3455649 COVINGTON & BURLING LLP e7cde64e-248a-490a-a2f8-d081875bbadf Q3 COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2025 third_quarter BNK Bankruptcy Law.   10000   0 0 2025-10-20T13:02:22-04:00
3456979 KOCH GOVERNMENT AFFAIRS, LLC 81546d30-f173-4222-98f6-f540cfaa0bd4 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2025 third_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   2310000 0 0 2025-10-20T13:47:46-04:00
3463191 K&L GATES, LLP 61e7149b-e1b2-4d5f-90f0-dfcef4966de6 Q3 K&L GATES, LLP 32098 PENNSYLVANIA HIGHER EDUCATION ASSISTANCE AGENCY (PHEAA) 2025 third_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,White House Office 20000   0 0 2025-10-20T16:41:33-04:00
3465143 KELLEY DRYE & WARREN LLP f7f71358-b4fc-43ab-aa17-3812d68be327 Q3 KELLEY DRYE & WARREN LLP 307114 ANCESTRY 2025 third_quarter BNK Dont Sell My DNA Act (S. 1916) SENATE 30000   0 0 2025-10-20T17:36:26-04:00
3465861 AMERICAN BANKERS ASSOCIATION 8013cd2f-ef53-47d1-840c-1c6f5583f13e Q3 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2025 third_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   2170000 0 0 2025-10-20T18:01:50-04:00
3469400 APPALACHIAN VOICES f3cdc619-9208-4cc8-97a9-737161791680 Q3 APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2025 third_quarter BNK Coal mining bankruptcies, lobbying for legislation to ensure money for reclamation after coal bankruptcies. No bill #s. HOUSE OF REPRESENTATIVES,SENATE   40000 0 0 2025-10-20T21:04:56-04:00
3469652 AQUIA GROUP, LLC 70f55fa8-a579-4605-82e5-f940274f652c Q3 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2025 third_quarter BNK Issues related to bankruptcy trustee fee schedule. Bankruptcy Administration Improvement Act (S. 1659, HR 3867)   20000   0 0 2025-10-20T21:21:11-04:00
3469666 AQUIA GROUP, LLC fb7cdbcd-45fb-4d1a-b433-cdebdfe8f2c4 Q3 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF FEDERAL EQUITY RECEIVERS (NAFER) 2025 third_quarter BNK Issues related to opportunities to improve the processes around tax refund and liability determinations in Federal Receivership cases.   20000   0 0 2025-10-20T21:22:24-04:00
3474810 PACE, LLP c452b2dd-475d-4056-9767-5de480c5e020 Q3 PACE, LLP 30495 NATIONAL ASSN OF CREDIT MANAGEMENT 2025 third_quarter BNK General Bankruptcy issues HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2025-11-06T16:39:06-05:00
3233679 ACG ADVOCACY a1410ac0-9a69-4113-8776-028c08465e7a Q3 ACG ADVOCACY 2057 COMMERCIAL BANKRUPTCY ALLIANCE 2024 third_quarter BNK Bankruptcy Issues. Monitor Venue Legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2024-10-08T14:47:09-04:00
3234885 THORSEN FRENCH ADVOCACY LLC d7d09303-031a-45cd-92bb-6891689ef6cb Q3 THORSEN FRENCH ADVOCACY LLC 400599826 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 third_quarter BNK Bankruptcy Policy. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2024-10-10T14:12:01-04:00
3235028 THE NICKLES GROUP, LLC 9c800deb-9973-448f-b429-e0aa4f411c63 Q3 THE NICKLES GROUP, LLC 293335 KOCH GOVERNMENT AFFAIRS, LLC 2024 third_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2024-10-10T15:38:53-04:00
3239287 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX 145c5a10-fa5c-4c91-84d4-8ee7174d7ff4 Q3 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX 401104915 LAKEVIEW CAPITAL HOLDINGS INC ON BEHALF OF MR JAY ALIX 2024 third_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-10-15T21:05:56-04:00
3239302 MR. PETER SNELL 8d9165c1-3dc8-4b50-8aea-80ee52e79896 Q3 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2024 third_quarter BNK governmental bankruptcy issues; Federal aid to states HOUSE OF REPRESENTATIVES,SENATE 55000   0 0 2024-10-15T21:47:32-04:00
3240005 ALLON ADVOCACY, LLC 55249906-95f7-4c8e-9dcd-07746d383e60 Q3 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2024 third_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-10-16T12:02:38-04:00
3240113 ALLON ADVOCACY, LLC eb347605-7e2e-4a55-bb8f-b1971c0c07c0 Q3 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2024 third_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-10-16T12:21:42-04:00
3241389 CAPITOL COUNSEL LLC 60e01b4e-e031-4dd6-9edb-418a0c90d6e2 Q3 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2024 third_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2024-10-16T16:47:39-04:00
3242639 K&L GATES, LLP 4e5f7e44-cb2b-409a-896d-767c1f6dc2d3 Q3 K&L GATES, LLP 32098 PENNSYLVANIA HIGHER EDUCATION ASSISTANCE AGENCY (PHEAA) 2024 third_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-10-17T11:09:25-04:00
3243449 APPALACHIAN VOICES 7ff55730-f35e-4511-9b83-7a5743037394 Q3 APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2024 third_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   20000 0 0 2024-10-17T13:15:44-04:00
3244327 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 6d505d17-d8c1-41b2-b33b-7f8c78eb3b49 Q3 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 19935 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 third_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-10-17T14:49:37-04:00
3249828 MEEKS, BUTERA & ISRAEL PLLC 47f1cca4-a2b8-40a4-875d-0f8333f1b5d4 Q3 MEEKS, BUTERA & ISRAEL PLLC 401105818 BROADBILL INVESTMENT PARTNERS, LLC 2024 third_quarter BNK Bankruptcy reform issues. HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 20000   0 0 2024-10-18T13:35:40-04:00
3253015 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 5e589428-3101-4286-a423-431ce18704db Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2024 third_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-10-19T08:24:14-04:00
3253028 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 0cd4c97c-90c6-4a49-a416-5bab35127273 Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2024 third_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-10-19T08:26:44-04:00
3253831 PURDUE PHARMA, LP 89a0f89c-1baf-4df7-8114-bdbe127d0689 Q3 PURDUE PHARMA, LP 81214 PURDUE PHARMA LP 2024 third_quarter BNK Monitored congressional activity related to bankruptcy reform.     100000 0 0 2024-10-19T14:41:53-04:00
3254275 CORNERSTONE GOVERNMENT AFFAIRS, INC. 4b024ddd-86e9-4527-9bd4-4e73e4ccfd7d Q3 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 MR. JAY ALIX 2024 third_quarter BNK Protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2024-10-19T23:13:35-04:00
3254832 CAPITOL HILL CONSULTING GROUP 94fbc2a1-6f3f-4bce-83c6-dc5fbe271e0c Q3 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2024 third_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2024-10-20T12:50:08-04:00
3259661 COGENT STRATEGIES LLC 58408227-9aaa-4e16-ba9a-a8644b032b56 Q3 COGENT STRATEGIES LLC 401104684 MR. JAY ALIX 2024 third_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-10-21T11:27:13-04:00
3260907 KOCH GOVERNMENT AFFAIRS, LLC df326ca6-931a-4b89-a9be-0e4b4a246d4f Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2024 third_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   2150000 0 0 2024-10-21T12:23:43-04:00
3260923 BOSE PUBLIC AFFAIRS GROUP 26dc096d-ebb4-4008-a4de-dca1b212519d Q3 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2024 third_quarter BNK Legislation affecting the inclusion of education loans in bankruptcy filings. HOUSE OF REPRESENTATIVES,SENATE 40000   0 0 2024-10-21T12:25:41-04:00
3261316 MORAN GLOBAL STRATEGIES, INC. 4389bae8-f2a5-4193-a7f8-b101f77fa6ae Q3 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2024 third_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2024-10-21T12:52:08-04:00
3263535 FEDERAL HALL POLICY ADVISORS, LLC 754eee46-1709-47fd-8e0f-ec43bc251870 Q3 FEDERAL HALL POLICY ADVISORS, LLC 401104646 LOAN SYNDICATIONS AND TRADING ASSOCIATION 2024 third_quarter BNK Issues related to the reform of the bankruptcy court system. HOUSE OF REPRESENTATIVES,SENATE 60000   0 0 2024-10-21T14:27:05-04:00
3263947 AQUIA GROUP, LLC 0167a693-d724-4f63-a2a4-73a23a01b7e3 Q3 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2024 third_quarter BNK Issues related to bankruptcy trustee fee schedule. S.4150 - Bankruptcy Threshold Adjustment Extension Act   20000   0 0 2024-10-21T14:42:36-04:00
3264007 AQUIA GROUP, LLC 29ef48ee-9e1e-4962-8b98-012d5a086e73 Q3 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF FEDERAL EQUITY RECEIVERS (NAFER) 2024 third_quarter BNK Issues related to opportunities to improve the processes around tax refund and liability determinations in Federal Receivership cases.   20000   0 0 2024-10-21T14:44:58-04:00
3265315 AMERICAN BANKERS ASSOCIATION 74fbd0a8-97ca-4d69-8695-45f67318ef0f Q3 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2024 third_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 Extension Act HOUSE OF REPRESENTATIVES,SENATE   1760000 0 0 2024-10-21T15:31:24-04:00
3265874 WILMER CUTLER PICKERING HALE AND DORR LLP 2f95a6d3-cf62-49ce-b9f2-5b09c3d15971 Q3 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2024 third_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2024-10-21T15:50:31-04:00
3266077 DISCOVER FINANCIAL SERVICES 1505326f-c291-4f74-9f49-1004e7e0c898 Q3 DISCOVER FINANCIAL SERVICES 318414 DISCOVER FINANCIAL SERVICES 2024 third_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   460000 0 0 2024-10-21T15:57:36-04:00
3266345 THE NICKLES GROUP, LLC d9b9fd18-e358-406c-9e61-9f92712d0cf0 Q3 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2024 third_quarter BNK Issues concerning bankruptcy reform. SENATE 40000   0 0 2024-10-21T16:08:09-04:00
3266559 JOHNSON & JOHNSON SERVICES, INC. e44953a3-777b-411f-a376-685f7336560a Q3 JOHNSON & JOHNSON SERVICES, INC. 20686 JOHNSON & JOHNSON SERVICES INC 2024 third_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   2340000 0 0 2024-10-21T16:14:28-04:00
3266789 COVINGTON & BURLING LLP 308cec56-37c7-4407-bd5a-039df669ca12 Q3 COVINGTON & BURLING LLP 11195 JOHNSON & JOHNSON SERVICES INC 2024 third_quarter BNK Bankruptcy Law SENATE 10000   0 0 2024-10-21T16:19:53-04:00
3269453 GRUBHUB HOLDINGS INC. cb8fb023-552d-4e50-b9c0-6603976fc16f Q3 GRUBHUB HOLDINGS INC. 401106201 GRUBHUB HOLDINGS INC. 2024 third_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   170000 0 0 2024-10-21T17:57:23-04:00
3272448 AIR LINE PILOTS ASSOCIATION 537bd363-44c9-48f8-9fe1-5488b286cfda Q3 AIR LINE PILOTS ASSOCIATION 580 AIR LINE PILOTS ASSOCIATION 2024 third_quarter BNK S 1838 Credit Card Competition Act of 2023. HOUSE OF REPRESENTATIVES,SENATE   190000 0 0 2024-10-22T11:26:57-04:00
3274063 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 57b50c61-e95c-4b7a-84b9-0d6c66a65d7b Q3 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2024 third_quarter BNK Fair Debt Collection Act. Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2024-10-29T17:17:27-04:00
3049045 THE NICKLES GROUP, LLC 834f7430-228a-40bf-889e-bef6ff46b36a Q3 THE NICKLES GROUP, LLC 293335 KOCH GOVERNMENT AFFAIRS, LLC 2023 third_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2023-10-13T12:23:44-04:00
3049749 CAPITOL COUNSEL LLC 4ef9a4c7-c629-4be5-8059-8c5af2ab3815 Q3 CAPITOL COUNSEL LLC 313715 TRANSUNION LLC 2023 third_quarter BNK Outreach and monitoring of credit and consumer reporting issues. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2023-10-14T11:21:49-04:00
3050743 ALLON ADVOCACY, LLC 4ed3710e-58a2-4045-ba7b-958c2cd03128 Q3 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2023 third_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-10-16T11:05:28-04:00
3050776 ALLON ADVOCACY, LLC 73ba4a8e-a269-45b2-a3cf-3120d1a7789b Q3 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2023 third_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 2023-10-16T11:09:17-04:00
3054162 DISCOVER FINANCIAL SERVICES 8a43a65a-101a-4e05-ae01-b1326737b48b Q3 DISCOVER FINANCIAL SERVICES 318414 DISCOVER FINANCIAL SERVICES 2023 third_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   340000 0 0 2023-10-17T17:09:47-04:00
3057282 ALPINE GROUP PARTNERS, LLC. 72ac5619-3f5f-4147-914c-254c3c1d5478 3T ALPINE GROUP PARTNERS, LLC. 1171 MANAGED FUNDS ASSOCIATION 2023 third_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 20000   0 1 2023-10-18T14:50:46-04:00
3058524 NELSON MULLINS RILEY & SCARBOROUGH f9e539d7-300c-4d8c-8764-1bbd4bbdf5ca Q3 NELSON MULLINS RILEY & SCARBOROUGH 285871 JOHNSON & JOHNSON SERVICES, INC. 2023 third_quarter BNK Corporate Bankruptcy Process SENATE 20000   0 0 2023-10-18T17:53:56-04:00
3058766 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 5ef8a811-644f-4fea-b293-c458bbab4e42 Q3 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2023 third_quarter BNK Fair Debt Collection Act. Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2023-10-18T19:43:00-04:00
3059654 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 9a0bdcf1-9610-4045-9d5e-9fe58df3c8f2 Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 INTERNATIONAL COUNCIL OF SHOPPING CENTERS 2023 third_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-10-19T09:25:42-04:00
3059672 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 547acb7c-fd9e-4cfb-86e1-74fbf4f5a4eb Q3 NORTH SOUTH GOVERNMENT STRATEGIES, FKA JDM PUBLIC STRATEGIES, LLC 400689052 AMERICAN BANKERS ASSOCIATION 2023 third_quarter BNK Monitor new bankruptcy legislation, Sub V extension and consumer issues in expiring provisions HOUSE OF REPRESENTATIVES,SENATE 35000   0 0 2023-10-19T09:27:52-04:00
3060714 MORAN GLOBAL STRATEGIES, INC. 7da472a5-1133-4f4b-82e5-7f6a6371ff41 Q3 MORAN GLOBAL STRATEGIES, INC. 401107502 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2023 third_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2023-10-19T11:31:39-04:00
3062026 BOSE PUBLIC AFFAIRS GROUP 6b4d97f2-77d8-4942-b743-a6bffbf8653f Q3 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2023 third_quarter BNK BNK: Legislation affecting the inclusion of education loans in bankruptcy filings. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2023-10-19T13:16:42-04:00
3063307 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX ea6bfe6c-a885-45d6-bb11-58f18b0aaf25 Q3 LAKEVIEW CAPITAL HOLDINGS, INC ON BEHALF OF MR. JAY ALIX 401104915 LAKEVIEW CAPITAL HOLDINGS INC ON BEHALF OF MR JAY ALIX 2023 third_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-10-19T15:00:49-04:00
3066677 APPALACHIAN VOICES a003b712-6f10-49a8-95a1-0088a63c245b Q3 APPALACHIAN VOICES 401107435 APPALACHIAN VOICES 2023 third_quarter BNK Coal mining company bankruptices (no bill number) HOUSE OF REPRESENTATIVES,SENATE   20000 0 0 2023-10-19T21:25:58-04:00
3069054 AQUIA GROUP, LLC 67ec8dd6-609c-4d47-88e0-a70654545733 Q3 AQUIA GROUP, LLC 401104982 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2023 third_quarter BNK Issues related to bankruptcy trustee fee schedule.   20000   0 0 2023-10-20T09:39:38-04:00
3069942 CHAMBER OF COMMERCE OF THE U.S.A. a4e40487-d3aa-4c86-be05-52372a1cb08f Q3 CHAMBER OF COMMERCE OF THE U.S.A. 38756 CHAMBER OF COMMERCE OF THE U.S.A. 2023 third_quarter BNK 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 the U.S. Trustees authority to oversee the administration of bankruptcy trust funds; Chapter 11 bankruptcies including third-party releases; bankruptcy and mass tort litigation HOUSE OF REPRESENTATIVES,SENATE   13590000 0 0 2023-10-20T10:17:02-04:00
3070222 BGR GOVERNMENT AFFAIRS f970bdbc-3e14-4e0e-ab30-75645044711a Q3 BGR GOVERNMENT AFFAIRS 5357 FRANKLIN RESOURCES, INC. 2023 third_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-10-20T10:24:06-04:00
3072283 CORNERSTONE GOVERNMENT AFFAIRS, INC. 585d1347-68f9-4ecf-84fa-da5811c03cf2 Q3 CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 MR. JAY ALIX 2023 third_quarter BNK Protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2023-10-20T11:27:43-04:00
3073609 THE NICKLES GROUP, LLC 768cceb7-1c78-494d-a345-2daf049e16bb Q3 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2023 third_quarter BNK H.R. 4777/S. 2497, the Nondebtor Release Prohibition Act and issues concerning bankruptcy reform. SENATE 40000   0 0 2023-10-20T12:17:52-04:00
3074148 COGENT STRATEGIES LLC 82a9901a-b5e0-476e-b6d2-98b93d535ec2 Q3 COGENT STRATEGIES LLC 401104684 MR. JAY ALIX 2023 third_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-10-20T12:42:42-04:00
3074908 KOCH GOVERNMENT AFFAIRS, LLC a3408b73-4455-4704-b2e6-aa65aaf99037 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2023 third_quarter BNK Issues related to bankruptcy reform. HOUSE OF REPRESENTATIVES,SENATE   1430000 0 0 2023-10-20T13:13:14-04:00
3074999 MEEKS, BUTERA & ISRAEL PLLC fa9cad16-8e0a-4151-848e-a9f529486647 Q3 MEEKS, BUTERA & ISRAEL PLLC 401105818 BROADBILL INVESTMENT PARTNERS, LLC 2023 third_quarter BNK Bankruptcy reform issues. HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of 25000   0 0 2023-10-20T13:17:35-04:00
3076394 MCCARTHY ADVANCED CONSULTING LLC ff9625c0-33e9-468e-9cee-5083f58860f3 Q3 MCCARTHY ADVANCED CONSULTING LLC 401104683 INTERNATIONAL BROTHERHOOD OF TEAMSTERS 2023 third_quarter BNK Lobbied in support of displaced workers at now-defunct Yellow Trucking by requesting support for permitting a delayed loan repayment that will allow workers to be retained and brought back to work. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2023-10-20T14:18:54-04:00
3076684 WILMER CUTLER PICKERING HALE AND DORR LLP 5051c119-6f02-4b4d-a3f2-ed93340233ba Q3 WILMER CUTLER PICKERING HALE AND DORR LLP 41534 NATIONAL ASSOCIATION OF CONSUMER BANKRUPTCY ATTORNEYS 2023 third_quarter BNK U.S. Trustee Program HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2023-10-20T14:27:18-04:00
3077520 AMERICAN BANKERS ASSOCIATION ea770e26-ffc1-4e76-973e-0cffd7606e52 Q3 AMERICAN BANKERS ASSOCIATION 1785 AMERICAN BANKERS ASSOCIATION 2023 third_quarter BNK Bankruptcy reform legislation, including bills dealing with small business, student loans and related legislation HOUSE OF REPRESENTATIVES,SENATE   2160000 0 0 2023-10-20T14:49:50-04:00
3077818 JOHNSON & JOHNSON SERVICES, INC. 4995d049-936a-4ada-b8b9-ee03c35f995f Q3 JOHNSON & JOHNSON SERVICES, INC. 20686 JOHNSON & JOHNSON SERVICES INC 2023 third_quarter BNK Issues related to: - Chapter 11 corporate bankruptcy process - Litigation reform HOUSE OF REPRESENTATIVES,SENATE   2350000 0 0 2023-10-20T14:59:05-04:00
3080059 ACG ADVOCACY ec2f6fa6-2d38-49d0-8e7f-bce92bf670c1 Q3 ACG ADVOCACY 2057 COMMERCIAL BANKRUPTCY ALLIANCE 2023 third_quarter BNK Bankruptcy Issues. Monitor Venue Legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2023-10-20T16:26:16-04:00
3080763 COGENT STRATEGIES LLC f55dca8a-2f5a-4352-adf2-13251fa159d0 3A COGENT STRATEGIES LLC 401104684 MR. JAY ALIX 2023 third_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-10-20T16:53:03-04:00
3080857 FEDERAL HALL POLICY ADVISORS, LLC 61ce1c7d-36ee-4172-9cb9-1a52fa64628c 3T FEDERAL HALL POLICY ADVISORS, LLC 401104646 INVICTUS GLOBAL MANAGEMENT 2023 third_quarter BNK Creditor rights HOUSE OF REPRESENTATIVES,SENATE 30000   0 1 2023-10-20T16:55:29-04:00
3082233 FIRST AMERICAN FINANCIAL CORPORATION c77671e1-7038-4657-aba0-830c064c48ef Q3 FIRST AMERICAN FINANCIAL CORPORATION 401046944 FIRST AMERICAN FINANCIAL CORPORATION 2023 third_quarter BNK S. 2860: SECURE AND FAIR ENFORCEMENT REGULATION (SAFER) BANKING ACT; PROVISIONS RELATED TO LEGAL CERTAINTY AROUND INSURING OF REAL ESTATE TRANSACTIONS WHERE FUNDS FROM CANNABIS RELATED BUSINESS ACTIVITIES MAY BE USED IN THE TRANSACTION SENATE   60000 0 0 2023-10-20T18:20:12-04:00
3082379 PURDUE PHARMA, LP 7a64f2d8-d1e2-4a76-bc7d-e937ebfe573b Q3 PURDUE PHARMA, LP 81214 PURDUE PHARMA LP 2023 third_quarter BNK Monitored congressional activity related to bankruptcy reform.     100000 0 0 2023-10-20T18:33:50-04:00
3083173 AIR LINE PILOTS ASSOCIATION 20952e9d-e853-4def-b43e-bfabf09703a9 Q3 AIR LINE PILOTS ASSOCIATION 580 AIR LINE PILOTS ASSOCIATION 2023 third_quarter BNK S 1838 Credit Card Competition Act of 2023. HOUSE OF REPRESENTATIVES,SENATE   270000 0 0 2023-10-20T20:45:55-04:00
3083291 AMERICAN BAR ASSOCIATION 6a32c538-1251-47eb-a25b-33d769785ba7 Q3 AMERICAN BAR ASSOCIATION 1808 AMERICAN BAR ASSOCIATION 2023 third_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   200000 0 0 2023-10-20T21:08:18-04:00
3083962 CAPITOL HILL CONSULTING GROUP 48f0b749-ba8d-4496-8305-c809bef57ea1 Q3 CAPITOL HILL CONSULTING GROUP 72053 PURDUE PHARMA LLP 2023 third_quarter BNK Monitored congressional efforts around the SACKLER Act. HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2023-10-23T10:19:06-04:00
3085026 CORNERSTONE GOVERNMENT AFFAIRS, INC. ec7e0202-4228-41e5-a6bd-47801f8e18a9 3A CORNERSTONE GOVERNMENT AFFAIRS, INC. 75557 MR. JAY ALIX 2023 third_quarter BNK Protecting the integrity of the bankruptcy system and promoting transparency in government. HOUSE OF REPRESENTATIVES,SENATE 110000   0 0 2023-10-25T23:00:44-04:00
3092509 MR. PETER SNELL fb755e2c-81ee-4c04-be5d-efe57707e64b Q3 MR. PETER SNELL 400458209 NATIONAL COUNCIL ON TEACHER RETIREMENT 9370 STUDIO COURT ELK GROVE CA 95758 2023 third_quarter BNK governmental bankruptcy issues; Federal aid to states HOUSE OF REPRESENTATIVES,SENATE 55000   0 0 2024-01-10T14:40:55-05:00
2864010 NELSON MULLINS RILEY & SCARBOROUGH ba2b41d9-d24e-4f95-979c-9aa2172d5fb7 Q3 NELSON MULLINS RILEY & SCARBOROUGH 285871 NATIONAL ASSOCIATION OF BANKRUPTCY TRUSTEES 2022 third_quarter BNK Issues related to the extension of bankruptcy legislation HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2022-10-13T11:52:11-04:00
2864715 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES af93fe3c-92e5-4124-8a56-314f84c45bb3 Q3 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 7725 CALIFORNIA AND NEVADA CREDIT UNION LEAGUES 2022 third_quarter BNK Fair Debt Collection Act. Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,SENATE   110000 0 0 2022-10-13T19:52:46-04:00
2865479 ALLON ADVOCACY, LLC 5566e2f5-86f8-4d6c-8824-91f03a11dd4f Q3 ALLON ADVOCACY, LLC 401104657 ASSOCIATION FOR CONSUMER DEBT RELIEF (FORMERLY AMERICAN ASS'N FOR DEBT RELIEF) 2022 third_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 2022-10-14T14:04:06-04:00
2867210 ALLON ADVOCACY, LLC 0618c5a5-6c48-4dd0-b3a0-d84ffc5610ba Q3 ALLON ADVOCACY, LLC 401104657 ACHIEVE 2022 third_quarter BNK Issues related to consumer debt relief, debt settlement, and debt consolidation for unsecured consumer debt; PL 116-136 and PL 116-123 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 2022-10-17T10:33:13-04:00
2869020 535 GROUP, LLC 538cfe34-9098-446f-b206-5d0376dc6591 Q3 535 GROUP, LLC 401105906 BOY SCOUTS OF AMERICA 2022 third_quarter BNK Monitor Non-debtor Release Prohibition Act of 2021 in the House and Senate HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2022-10-17T16:23:13-04:00
2869597 RICHARD F. HOHLT 2eabf000-1aa5-4d73-ac10-ab39d7ea77ff Q3 RICHARD F. HOHLT 18433 FIRST REPUBLIC BANK 2022 third_quarter BNK All legislation related to the above issue. HOUSE OF REPRESENTATIVES,SENATE 15000   0 0 2022-10-17T21:01:26-04:00
2869833 ACG ADVOCACY 5bd39f5d-9efa-4346-93b3-b448f4088c40 Q3 ACG ADVOCACY 2057 COMMERCIAL BANKRUPTCY ALLIANCE 2022 third_quarter BNK Bankruptcy Issues. Monitor Venue Legislation. HOUSE OF REPRESENTATIVES,SENATE 20000   0 0 2022-10-18T01:59:43-04:00
2869962 FEDERAL HALL POLICY ADVISORS, LLC b33de1b4-3d5e-4b88-b4c1-16c56be95e17 Q3 FEDERAL HALL POLICY ADVISORS, LLC 401104646 INVICTUS GLOBAL MANAGEMENT 2022 third_quarter BNK Creditor rights HOUSE OF REPRESENTATIVES,SENATE 30000   0 0 2022-10-18T09:05:33-04:00
2870147 BOSE PUBLIC AFFAIRS GROUP 620325bd-c4be-4f7d-93ff-bf619ac51fe7 Q3 BOSE PUBLIC AFFAIRS GROUP 297294 CONSUMER BANKERS ASSOCIATION 2022 third_quarter BNK Legislation affecting the inclusion of education loans in bankruptcy filings. HOUSE OF REPRESENTATIVES,SENATE 80000   0 0 2022-10-18T10:05:34-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 541.538ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API