lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
11 rows where filing_uuid = "b9f0e079-e9b2-49de-b99e-d1a4622b293e" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1712645 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | ACC | Pension-related accounting issues generally | 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 | |
| 1712646 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | FIN | None | 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 | |
| 1712647 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | UTI | H.R. 2358, Electricity Reliability and Forest Protection Act. H.R. 3301, the North American Energy Infrastructure Act. S. 1314, Commercial UAS Modernization Act. | 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 | |
| 1712648 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | CDT | H.R. 2289, reauthorization of the Commodity Exchange Act (derivative end-user protections. | 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 | |
| 1712649 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | TRA | Highway and water transportation issues generally | 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 | |
| 1712650 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | TAX | Tax reform in general and extension of expiring provisions (tax extenders) draft legislation in House and Senate. The Master Limited Partnership Parity Act of 2015 H.R. 2315 and S. 386 the Mobile Workforce State Income Tax Simplification Act of 2013 | 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 | |
| 1712651 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | BUD | HR. 2028, FY 2016 Energy and Water Development and Related Agencies Appropriations H.R. 3020 and S. 1695, FY 2016 Labor, Health and Human Services, and Education, and Related Agencies Appropriations H.R. 2822 and S. 1645, FY 2016 Interior, Environment and Related Agencies Appropriations | 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 | |
| 1712652 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | ENV | H.R. 1734, Improving Coal Combustion Residuals Regulation Act of 2015 S. 655, to prohibit Interior Secretary from using funds to make final determination on long-eared bat under Endangered Species Act. Endangered Species Act listing of long-eared bat as a threatened species. H.R. 2576 the TSCA Modernization Act of 2015 S.697, the Frank Lautenberg Chemical Safety for the 21st Century Act, to modernize the Toxic Substance Control Act | 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 | |
| 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 | |
| 1712654 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | HOM | H.R. 1646, Homeland Security Drone Assessment and Analysis Act. S. 754, Cybersecurity Information Sharing Act of 2015 (Burr) H.R. 1731, National Cyber Security Advancement Act of 2015 (McCaul) FY 2016 Homeland Security Appropriations. H.R. 3410, the Critical Infrastructure Protection Act (CIPA) to amend the Homeland Security Act to secure critical infrastructure against electromagnetic pulses. | 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 | |
| 1712655 | FIRSTENERGY CORP b9f0e079-e9b2-49de-b99e-d1a4622b293e | Q2 | FIRSTENERGY CORP | 43764 | FIRSTENERGY CORP | 2015 | second_quarter | CAW | "Clean Power Plan" proposed rule by the EPA to reduce greenhouse gas emissions from existing power plants. H.R. 2042 "Ratepayer Protection Act" regarding EPA's proposed greenhouse gas rule. S.1324 a bill to require EPA to fulfill certain requirements before regulating standards of performance for certain electric generation plants. (Capito) H.R. 1327, Ozone Regulatory Delay and Extension of Assessment Length Act H.R. 1388, Clean Air, Strong Economies Act regarding EPA ozone NAAQS S. 640, Ozone Regulatory Delay and Extension of Assessment Length Act "Waters of the U.S." proposed rule H.R. 1732 Regulatory Integrity Protection Act of 2015 (requires withdraw of the WOTUS rule and sets procedural steps for promulgation of a new rule) S. 1140 Federal Water Quality Protection Act H.R. 5078, the Waters of the U.S. Regulatory Overreach Protection Act. Discussion draft of carbon tax bill by Rep. John Delaney (D-MD) The State Choice Act of 2014. H.R. 2916, the Domestic Energy Production Protections Act of 2013 to require congressional review of certain EPA rules. | 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);