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

1 row where filing_uuid = "a1ca9b4c-6f5d-4ece-a3ae-ffc3ec4fa4eb" and issue_code = "BAN" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

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
2473368 U.S. PUBLIC INTEREST RESEARCH GROUP a1ca9b4c-6f5d-4ece-a3ae-ffc3ec4fa4eb Q2 U.S. PUBLIC INTEREST RESEARCH GROUP 38814 U.S. PUBLIC INTEREST RESEARCH GROUP 2020 second_quarter BAN Group letter to support H.R. 5332, the Protecting Your Credit Score Act of 2020, (Gottheimer (NJ) (Passed House.) Group letters to support debt collection provisions of Section 110402 and 110601 of the House-passed HEROES Act, H.R. 6800, restricting the collection of consumer and small business debt. That section gives consumers and small businesses that are facing mounting debts a path to recovery. Urge its inclusion in next COVID stimulus package. Submitted Comments to Request for Information from Taskforce on Federal Consumer Financial Law, Docket No. CFPB-2020-0013. Group letters to Urge Congressional leaders and OMB to mandate that Treasury Secretary and Federal Reserve Board fully comply with Coronavirus Aid, Relief, and Economic Security Act (CARES Act, Pub. L. 116-136) disclosure and transparency requirements and mechanisms, especially the provisions establishing the Pandemic Response Accountability Committee (PRAC, 15010 and 15011). Briefed House Financial Services Committee staff (at their request) on our latest findings on pandemic's impact on number and types of consumer complaints in the CFPB database, particularly its impact on homeowners and mortgages. Group letter to Urge Congressional leaders to include include S1581 (Merkley-OR)/HR 6470 (Porter-CA) the Medical Debt Relief Act of 2019 in the next COVID-19 relief package. The reforms in the Medical Debt Relief Act are urgently needed to allow American families to access the health care they need without further straining their finances during this public health crisis. Group letter to urge CFPB Director to suspend all regulatory actions unrelated to COVID19 and take more steps to better protect consumers during pandemic, instead of loosening enforcement on financial firms. Group letter to urge CFPB Director to suspend actions to weaken Payday Lending and Car Title Loan Regulation, based on leak of internal whistleblower report. Group letter to support S3913 (Cortez-Masto-NV) The End Double Taxation of Successful Consumer Claims Act to cor… Consumer Product Safety Commission (CPSC),Federal Deposit Insurance Corporation (FDIC),Federal Reserve System,Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),Office of the Comptroller of the Currency (OCC),SENATE,Transportation, Dept of (DOT),Treasury, Dept of   10000 0 0 2020-07-17T15:32:07.683000-04:00

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);