lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "9f9f0b67-e810-43e7-acfb-9f32ebdaf4e7", filing_year = 2024 and issue_code = "ENG" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3257690 | GREENBERG TRAURIG, LLP 9f9f0b67-e810-43e7-acfb-9f32ebdaf4e7 | Q3 | GREENBERG TRAURIG, LLP | 16896 | COVESTRO LLC | 2024 | third_quarter | ENG | Outreach and monitoring related to legislative and administrative action on energy efficiency and clean energy tax credits. Monitor legislative and administrative action regarding federal carbon incentives. Monitor legislative and administrative action regarding building energy efficiency standards. Monitor legislative and administrative action regarding supply chain resiliency. Monitor legislation to reauthorize the Agriculture Improvement Act of 2018 H.R. 1, Lower Energy Costs Act H.R. 165, New Source Review Permitting Improvement Act H.R. 209, Permitting for Mining Needs Act of 2023 H.R. 1131, To require the Administrator of the Environmental Protection Agency to authorize the use of flexible air permitting with respect to certain critical energy resource facilities, and for other purposes. H.R. 1335, Transparency, Accountability, Permitting, and Production of American Resources Act H.R. 1603, Homeowner Energy Freedom Act S. 611, Energy Efficiency for Affordable Housing Act S. 877, Federal Permitting Modernization Act of 2023 S. 947, A bill to lower energy costs by increasing American energy production, exports, infrastructure, and critical minerals processing, by promoting transparency, accountability, permitting, and production of American resources, and by improving water quality certification and energy projects, and for other purposes. S. 2714, CREATE AI Act H.R. 5077, CREATE AI Act Monitor legislative and administrative action regarding the Biobased Markets Program H.R. 8467, Farm, Food, and National Security Act of 2024 S. 2452, Biomanufacturing and Jobs Act H.R. 5134, Biomanufacturing and Jobs Act | SENATE | 30000 | 0 | 0 | 2024-10-21T10:06:50-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);