lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
7 rows where filing_uuid = "2b4e2314-e189-4f3e-9400-60d8f7dd45c4" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1696738 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | UTI | H.R. 2358, Electricity Reliability and Forest Protection Act, facilitate vegetation management on rights-of-way across federal land to the benefit of electric reliability and forest fire risk reduction; H. Res. 127, Recognizing linemen, the profession of linemen, the contributions of these brave men and women who protect public safety, and expressing support for the designation of March 31, 2015, as National Lineman Appreciation Day. | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696739 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | TAX | H.R. 2315, Mobile Workforce State Income Tax Simplification Act of 2015; H.R. 2510, to amend the Internal Revenue Code of 1986 to modify and make permanent bonus depreciation; Discussion draft of repatriation proposals; Discussion draft to amend the Internal Revenue Code of 1986 to extend the energy credit for certain property under construction; House tax extenders legislation; S. 386, Mobile Workforce State Income Tax Simplification Act of 2015; Senate Repatriation proposals; Senate tax extenders legislation. | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696740 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | BUD | H.R. 2028, FY 2016 Energy and Water Development and Related Agencies Appropriations Act, 2016, Waters of the U.S. policy rider, (potential appropriations issues related to DOE-industry coordination on cyber and physical security, DOE/industry partnership on storm response and restoration, and grid resilience); H.R. 2577, FY 2016 Transportation, Housing and Urban Development, and Related Agencies Appropriations, (potential appropriations issues related to unmanned aircraft systems, coal and rail interdependencies, HUD CDBG eligibility and transportation electrification); H.R. 2685, FY 2016 Defense Appropriations, (potential appropriations issues related to renewable energy efforts and Troops to Energy Jobs); H.R. 2822, FY 2016 Interior, Environment, and Related Agencies Appropriations, (potential appropriations issues related to Waters of the U.S., 316(b) Cooling Water Intake Structures rule, CCR regulation, clean air regulation, and GHG NSPS); H.R. 3020, FY 2016 Labor, Health and Human Services, and Education, and Related Agencies Appropriations, (potential appropriations issues related to Low Income Home Energy Assistance funding); House Subcommittee Draft, DHS Appropriations (potential appropriations issues related to Cybersecurity threat information sharing legislation and Safety Act Clarification); S. 1558, FY 2016 Defense Appropriations, (potential appropriations issues related to renewable energy efforts and Troops to Energy Jobs); S. 1619, DHS Appropriations (potential appropriations issues related to Cybersecurity threat information sharing legislation and Safety Act Clarification); S. 1645, Department of the Interior, Environment, and Related Agencies Appropriations Act, (Waters of the U.S. policy rider, regulations relating to air and climate); S. 1695, FY 2016 Labor- Labor, Health and Human Services, and Education, and Related Agencies Appropriations (LIHEAP); Senate Subcommittee Draft, FY 2016 Energy and Water Development and Related Agencies Appropriations Act, 2016 (Waters of the U.S. policy rider… | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696741 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | HOM | H.R. 1073, Critical Infrastructure Protection Act (Franks); H.R. 1560, Protecting Cyber Networks Act (Nunes); H.R. 1731, National Cybersecurity Protection Advancement Act (McCaul); H.R. 1735, the FY 2016 National Defense Authorization Act (provisions regarding electromagnetic pulse); H.R. 2402, to amend the Federal Power Act to prohibit the public disclosure of protected information (Lofgren); FY 2016 Homeland Security Appropriations (provisions related to SAFETY Act clarification); S. 456, Cyber Threat Sharing Act of 2015 (Carper); S. 754, Cybersecurity Information Sharing Act of 2015 (Burr). | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696742 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | CAW | H.R. 897, Reducing Regulatory Burdens Act of 2015 (addresses an NPDES permitting issue related to herbicides and pesticides); H.R. 1732, Regulatory Integrity Protection Act of 2015 (requires withdrawal of WOTUS rule and sets procedural steps for promulgation of a new rule); S. 1140, Federal Water Quality Protection Act (requires withdrawal of WOTUS rule and sets parameters for development of a new rule); S. 1500, Sensible Environmental Protection Act of 2015 (addresses NPDES permitting issue related to herbicides and pesticides). | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696743 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | ENG | H.R. 1558, Resolving Environmental and Grid Reliability Conflicts Act of 2015 (Olson); H.R. 1980, E-Access Act; S. 848, Resolving Environmental and Grid Reliability Conflicts Act of 2015 (McCaskill); S. 1044, E-Access Act; House Energy & Power Subcommittee, Discussion Draft Title II: 21st Century Workforce House Energy & Power Subcommittee, Discussion Draft Energy Efficiency House Energy & Power Subcommittee, Discussion Draft FERC Process Coordination House Energy & Power Subcommittee, Discussion Draft Energy Reliability and Security S. 454, A bill to amend the Department of Energy High-End Computing Revitalization Act of 2004 to improve the high-end computing research and development program of the Department of Energy, and for other purposes (Alexander); S. 485, A bill to prohibit the use of eminent domain in carrying out certain projects (Boozman); S. 523, A bill to coordinate the provision of energy retrofitting assistance to schools (Collins); S. 562, A bill to promote exploration for geothermal resources, and for other purposes (Heller); S. 600, A bill to require the Secretary of Energy to establish an energy efficiency retrofit pilot program (Klobuchar); S. 703, The Weatherization Enhancement and Local Energy Efficiency Investment and Accountability Act (Coons); S. 720, The Energy Savings and Industrial Competitiveness Act of 2015 (Portman); S. 723, The Utility Energy Service Contracts Improvement Act of 2015 (Schatz); S. 784, A bill to direct the Secretary of Energy to establish microlabs to improve regional engagement with national laboratories (Heinrich); S. 822, A bill to expand geothermal production, and for other purposes (Wyden); S. 858, The Energy Savings Through Public-Private Partnerships Act of 2015 (Gardner); S. 869, The All-of-the-Above Federal Building Energy Conservation Act of 2015 (Hoeven); S. 878, A bill to establish a State residential building energy efficiency upgrades loan pilot program (Sanders); S. 886, The Smart Energy and Water Efficiency Act of 2015 (Udall); S. 888, The PREPARE A… | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-04:00 | |
| 1696744 | PEPCO HOLDINGS, INC. 2b4e2314-e189-4f3e-9400-60d8f7dd45c4 | Q2 | PEPCO HOLDINGS, INC. | 79392 | PEPCO HOLDINGS INC | 2015 | second_quarter | TRA | S. 1608, Consumer Drone Safety Act; S. 1674, the DRIVE Act (Electric Vehicles). | HOUSE OF REPRESENTATIVES,SENATE | 300000 | 0 | 0 | 2015-07-15T14:20:08.473000-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);