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

8 rows where filing_uuid = "c302dd4e-c134-4f29-ae1a-d51c8a8b96d7" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 8

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
954932 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter TRA HR 1799, the Safe and Efficient Transportation Act of 2009 S 146, Railroad Antitrust Enforcement Act of 2009 HR 233, Railroad Antitrust Enforcement Act of 2009 S 2889, Surface Transportation Reauthorization Act Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954933 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter TAX S 870, expand the tax credit for renewable electricity production to include electricity produced from biomass for on-site use and to modify the credit period for certain facilities producing electricity from open-loop biomass. HR 622, expand the tax credit for renewable electricity production to include electricity produced from biomass for on-site use. HR 2528, extend the credit period for certain open-loop biomass facilities. HR 4213, Tax Extenders Act of 2009 Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954934 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter ENV HR 2336, the Green Resources for Energy Efficient Neighborhoods Act of 2009 or the GREEN Act of 2009 Green Building issues S 1660, Formaldehyde Standards for Composite Wood Products Act Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954935 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter CHM S. 2996, The Continuing Chemical Facilities Anti-Terrorism Standards Act of 2010 Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954936 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter ENG S. 1462, American Clean Energy Leadership Act of 2009 American Power Act -- Kerry/Lieberman climate change bill S 2877, The Carbon Limits and Energy for America's Renewal (CLEAR) Act S 1462, American Clean Energy Leadership Act of 2009 Climate Change issues Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954937 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter AGR Biomass Crop Assistance Program (BCAP) Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954938 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter CAW SJ Res 26, A joint resolution disapproving a rule submitted by the EPA relating to the endangerment finding and cause or contribute findings for greenhouse gases under section 202(a) of the Clean Air Act S 3072, A bill to suspend, during the 2 yr period beginning on the date of enactment of this Act, any EPA action under the Clean Air Act with respect to carbon dioxide or methane pursuant to certain proceedings, other than with respect to motor vehicle emissions, and for other purposes. S 3381, A bill to amend the Clean Air Act to modify certain definitions of the term "renewable biomass," and for other purposes. S 787, Clean Water Restoration Act HR 5088, America's Commitment to Clean Water Act Clean air issues Boiler MACT issues Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04:00
954939 AMERICAN FOREST & PAPER ASSOCIATION c302dd4e-c134-4f29-ae1a-d51c8a8b96d7 Q2 AMERICAN FOREST & PAPER ASSOCIATION 2376 AMERICAN FOREST & PAPER ASSOCIATION 2010 second_quarter NAT FY 2011, Interior Appropriations FY 2011, Agriculture Appropriations Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   770033 0 0 2010-07-15T14:54:07.503000-04: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);