lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "a1ca9b4c-6f5d-4ece-a3ae-ffc3ec4fa4eb" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2473367 | 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 | WAS | Support Break Free From Plastic Pollution Act (H.R.5845 and S.3263). Oppose RECOVER Act (H.R.5115). | 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 | |
| 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 | |
| 2473369 | 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 | HCR | Supported the Medical Supply Transparency and Delivery Act, which would establish central, transparent coordination of the medical supply chain. | 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 | |
| 2473370 | 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 | GOV | Support pro-public health, pro-democracy, pro-consumer, and pro-environment provisions in House COVID-19 stimulus package (H.R.6800) and Senate COVID-19 stimulus package. | 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 | |
| 2473371 | 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 | CSP | Opposed anti- Right to Repair provisions in the National Defense Authorization Act in the Senate. Urged leadership of Senate Commerce Committee not to schedule a confirmation vote on and more generally to oppose the nomination of former chemical industry lobbyist Nancy Beck to chair the U.S. Consumer Product Safety Commission. Conducted general outreach activities to Congress on this matter. Joined coalition letter to FTC urging it to withhold final consent to the merger of prescription drug companies Abbvie and Allergan (AbbVie and Allergan; File No. 191 0169). Submitted group comment to US DOT on Defining Unfair or Deceptive Practices in Airlines and Ticketing Agents, Docket No. DOT-OST-2019-0182. Sent civil society letter to House Judiciary Committee leaders opposing efforts by U.S. Chamber of Commerce to demand sweeping business immunity from COVID19-related claims by consumers or workers. Sent consumer group letter to Congressional leaders opposing efforts by U.S. Chamber of Commerce to demand sweeping business immunity from COVID19-related claims by consumers or workers. Sent civil society letter to Congressional leaders opposing efforts by U.S. Chamber of Commerce to demand sweeping business immunity from COVID19-related claims by consumers or workers. | 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 | |
| 2473372 | 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 | FOO | Supported dedicated funding in the appropriations bill to meet the current date set for duration limits for antibiotic use in farm animals. | 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 | |
| 2473373 | 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 | ROD | Support pro-environment provisions in House FY2021 surface transportation bill (H.R.2). | 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 | |
| 2473374 | 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 | BUD | Support provisions to fund FDAs priority action to improve antibiotic stewardship in veterinary settings in House FY2021 Agriculture/FDA appropriations bill and Senate FY2021 Agriculture/FDA appropriations bill. | 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 | |
| 2473375 | 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 | TRA | Support increasing public transportation, bike and walk lanes, and public transportation in the Invest Act. Support funding for the USPS. | 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
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);