lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "b9f0e079-e9b2-49de-b99e-d1a4622b293e" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1712653 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | ENG | House Energy & Power Subcommittee Discussion Drafts on Energy Efficiency, FERC Process Coordination and Energy Reliability and Security. H.R. 1558 Resolving Environmental and Grid Reliability Conflicts Act of 2015 S. 854, a bill to establish a new organization to manage nuclear waste, provide a process for siting nuclear waste facilities, ensure adequate funding for managing nuclear waste and other purposes. (Alexander) S. 545 Energy Efficiency Improvement Act of 2015 S. 720, The Energy Savings & Industrial Competitiveness Act of 2015 (Portman) S. 848 Resolving Environmental and Grid Reliability Conflicts Act of 2015 S. 1017, a bill to amend the Federal Power Act to improve siting of interstate electric transmission facilities and for other purposes (Heinrich) S. 1037, a bill to expand the provisions for termination of mandatory purchase requirements under the PURPA Act of 1978 (Risch) S.1272, A bill to direct the Comptroller General of the United States to conduct a study on the effects of forward capacity auctions and other capacity mechanisms. (Markey) S.1201, Clean Distributed Energy Grid Integration Act (Shaheen) S.1202, HEAT Act (Shaheen) S. 1219, a bill to amend the PURPA act of 1978 regarding distributed resources and net metering (Murkowski) S.1221, Bulk-Power System Reliability Impact Statement Act (Murkowski) S.1213, Free Market Energy Act of 2015 (King) S.1256, Advancing Grid Storage Act of 2015 (Franken) S.1258, Local Energy Supply and Resiliency Act of 2015 (Franken) S.1063, American Energy Efficiency Act (Franken) S.1232, Smart Grid Act of 2015 S.1243, Grid Modernization Act of 2015 (Wyden) S.1217, Electric Transmission Infrastructure Permitting Improvement Act (Murkowski) S.1222, Continuity of Electric Capacity Resources Act. (Murkowski) S.1017, A bill to amend the Federal Power Act to improve the siting of interstate electric transmission facilities, and for other purpose (Heinrich) S.1228, North American Energy Infrastructure Act (Hoeven) S.1275, Job Creation through Energy Efficient Manufac… | Council on Environmental Quality (CEQ),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE | 457178 | 0 | 0 | 2015-07-20T14:14:35.623000-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);