lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "fc7db854-ebf2-4b58-bcf7-2870410cf476" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2636727 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | CPT | Issues related to intellectual property and product counterfeiting; S. 936 INFORM Consumer Act | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636728 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | LBR | Issues related to U.S. manufacturing presence and workforce development, Issues related to COVID-19 Vaccinations | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636729 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | MAN | General manufacturing issues; Issues related to COVID-19, issues related to supply chain disruptions | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636730 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | TAX | General tax issues, Issues related to corporate and international tax provisions | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636731 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | ENV | Issues related to the ENERGY STAR home appliance program; issues related to refrigerants for household refrigerators and freezers; H.R. 1512 - CLEAN Future Act | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636732 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | TRD | General U.S. trade policy; Section 301 tariffs; Section 201 tariffs on large residential washers; United States-Mexico Canada Agreement; Miscellaneous tariffs; S. 1260 Endless Frontier Act | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-04:00 |
| 2636733 | WHIRLPOOL CORPORATION fc7db854-ebf2-4b58-bcf7-2870410cf476 | Q2 | WHIRLPOOL CORPORATION | 41168 | WHIRLPOOL CORPORATION | 2021 | second_quarter | ENG | Issues related to the ENERGY STAR home appliance program; issues related to appliance energy standards; H.R. 1512 - CLEAN Future Act | Commerce, Dept of (DOC),Energy, Dept of,Environmental Protection Agency (EPA),Executive Office of the President (EOP),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),SENATE,U.S. Trade Representative (USTR) | 0 | 0 | 2021-07-14T11:29:46.010000-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,
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);