lobbying_activities

Individual lobbying activities reported in quarterly filings. Each row is one issue area for one client — includes the specific issues lobbied on, government entities contacted, and income/expense amounts.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1 row where filing_uuid = "e1c9c7f6-00a2-46bf-829e-4df25ad1e06f" and issue_code = "CAW" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

filing_year 1

filing_period 1

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
1474782 MARCUS G. FAUST, PC e1c9c7f6-00a2-46bf-829e-4df25ad1e06f Q4 MARCUS G. FAUST, PC 14223 NV ENERGY 2013 fourth_quarter CAW H.R. 621, the Ensuring Affordable Energy Act to prohibit funding for EPA to be used to implement or enforce a cap-and-trade program for greenhouse gases; H.R. 959, to prohibit EPA from awarding any grants or other financial assistance under Sec. 103 of the Clean Air Act for any program, project, or activity to occur outside the United States; H.R. 2081, the No More Excuses Energy Act of 2013 provisions to prohibit regulation of emissions of greenhouse gases under the Clean Air Act; H.R. 2127, to prohibit EPA from finalizing NSPS for CO2 emissions from fossil-fueled EGUs until CCS is found to be technologically and economically feasible; H.R. 2886, the Social Cost of Carbon Transparency Enhancement Act of 2013; H.R. 2916, the Domestic Energy Production Protection Act of 2013 to require congressional review of certain EPA rules; H.R. 2948, the Transparency in Regulatory Analysis of Impacts on the Nation (TRAIN) Act of 2013 to require analyses of cumulative and incremental impacts of certain EPA rules and actions; H.R. 3042, the Taking Hold of Regulations to Increase Vital Employment in Energy Act to prohibit the use of the social cost of carbon in any regulatory impact analysis until authorized by federal law; H.R. 3080, the Water Resources Reform and Development Act (expansion of Corps authority to enter into cost recovery agreements); H.R. 3138, the Satisfying Energy Needs and Saving the Environment (SENSE) Act of 2013 to exempt certain coal refuse-fueled EGUs from certain emissions limits; H.R. 3140, the Ensure Reliable and Affordable American Energy Act of 2013 to prohibit carbon dioxide regulations under the Clean Air Act until EPA certifies a sufficient number of other countries have put into effect similar regulations; H. Con. Res. 57, expressing congressional opposition to EPAs proposed new source performance standards to limit greenhouse gas emissions from new power plants; H.J. Res. 64, disapproving an EPA rule relating to Standards of Performance for GHG Emissions from New Stationary Sources: Electric … HOUSE OF REPRESENTATIVES,SENATE 50000   0 0 2014-01-13T10:19:57.023000-05:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);