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

12 rows where filing_uuid = "c471fb4f-e4df-4e59-b101-4ca524cf1552" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 12

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
838720 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter TRA H.R. 3288, Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2010, Truck Weights Issues: Highway Reauthorization Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838721 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter LBR S. 204, No Oil Producing and Exporting Cartels Act, amendments related to creation of Department of Justice Task Force Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838722 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter GOV S.752, Fair Elections Now Act, penalty provisions S. 488, Free Flow of Information Act, entire bill Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838723 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter FIN Legislative proposals regarding the creation of a systemic risk regulator for the financial services industry Legislative proposals regarding financial regulatory reform, provisions related to commodities derivatives General issues related to the collapse of the Auction-Rate Securities Market S. 664, Financial System Stabilization and Reform Act of 2009, entire bill H.R. 977, Derivatives Markets Transparency and Accountability Act of 2009, entire bill S. 3268, Stop Excessive Energy Speculation Act, entire bill S. 447, Prevent Excessive Speculation Act, entire bill Issues: Financial Reform, Capitalization. Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838724 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter TAX H.R. 1 & S. 336 American Recovery and Reinvestment Act of 2009, tax provisions General tax matters including the related party rules in section 45 and the manufacturers' deduction and the alternative fuel and alternative fuels mixture credit Issues: Renewable Energy-Refined Product Reserve Section 199 Manufacturing Deduction, all bill Issues: Energy Tax S. 3268, Stop Excessive Energy Speculation Act, entire bill Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838725 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter ENV H.R. 2454, American Clean Energy and Security Act, entire bill Advanced Notice of Proposed Rule Making to Regulate Carbon Emissions under the Clean Air Act H.R. 1787, to amend the Clean Air Act regarding transportation fuels and establishment of a low carbon fuel standard, entire bill S. 787, Clean Water Restoration Act, entire bill H.R. 1787, Low Carbon Fuels Standard Act of 2009, entire bill H.R. 2996, Department of the Interior, Environment, and Related Agencies Appropriations Act, 2010, entire bill S. 1095, America's Low-Carbon Fuel Standard Act of 2009, entire bill S. 1622, Clean Air Protection Act, entire bill S. 661, Restoring America's Manufacturing Leadership through Energy Efficiency Act of 2009, entire bill Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838726 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter CSP S. 566, Federal Financial Product Safety Commission Act, entire bill S. 386, Fraud Enforcement and Recovery Act of 2009, provisions related to expansion of SEC jurisdiction to cover commodities contracts regulated by the CFTC Legislative proposals related to price controls on energy products H.R. 2129, Federal Price Gouging Prevention Act, entire bill H.R. 3288, Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2010, Truck Weights Statement of Administration Policy (SAP): H.R. 3288, Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2010, Truck Weights S. 1660, Formaldehyde Standards for Composite Wood Products Act, Formaldehyde Issues: legislative proposals related to price controls on energy products Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838727 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter ENG Issues related to climate change Energy Markets; Federal Price-Gouging Prevention; Section 199 Provision; Energy and Tax Extenders; Formaldehyde; study of health effects, chemical plant security, LIFO, Student Loan Auction Rate Securities (SLARS) H.R. 2129, Federal Price Gouging Prevention Act of 2009, entire bill S. 757, Charlie Wolf Nuclear Workers Compensation Act, entire bill S. 807, SMART Energy Act, entire bill H.R. 2454, American Clean Energy and Security Act, entire bill H.R. 1787, To amend the Clean Air Act regarding transportation fuels and establishment of a low carbon fuel standard, entire bill H.R. 977, Derivatives Markets Transparency and Accountability Act of 2009, entire bill S. 1095, America's Low-Carbon Fuel Standard Act of 2009, entire bill S. 3268, Stop Excessive Energy Speculation Act, entire bill S. 661, Restoring America's Manufacturing Leadership through Energy Efficiency Act of 2009, entire bill S. 787, Clean Water Restoration Act, entire bill S. 447, Prevent Excessive Speculation Act, entire bill S. 272, Derivatives Trading Integrity Act, entire bill S. 221, To amend the Commodity Exchange Act to require energy commodities to be traded only on regulated markets, entire bill H.R. 2448, Prevent Unfair Manipulation of Prices Act, entire bill S. 1225, To require the CFTC to take certain actions to prevent manipulation of energy markets, entire bill General energy issues including refined product reserves and commodity trading Issues related to motor vehicle fuel, climate change, renewable fuels standards Alternative Fuel Mixing Credit. H.R. 2868, The Chemical Facility Anti-Terrorism Act of 2009, entire bill H.R. 2129, Federal Price Gouging Prevention Act, entire bill H.R. 2868, Chemical Facility Anti-Terrorism Act of 2009, entire bill S. 967 Strategic Petroleum Reserve Modernization Act, entire bill S. 539 Clean Renewable Energy and Economic Development, entire bill Issues: Federal Price-Gouging Prevention, Section 199 Provision LIFO, Energy Price Gouging Prevention Act of 2009 Issues: gas p… Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838728 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter HOM Issues related to chemical security legislation and discussion draft of H.R. 2868, The Chemical Facility Anti-Terrorism Act of 2009 Legislative proposals to reauthorize the Chemical Facilities Anti-Terrorism Standards, provisions related to Inherently Safer Technology H.R. 2868, Chemical Facility Anti-Terrorism Act of 2009, entire bill S. 569, Incorporation on Transparency and Law Enforcement Assistance Act, provisions related to disclosure of beneficial ownership information of business entities H.R. 2868, Chemical Facility Anti-Terrorism Act of 2009, entire bill H.R. 2892, Department of Homeland Security Appropriations Act, 2010, entire bill Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838729 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter TOR S. 458, False Claims Correction Act, provisions intended to reverse recent Supreme Court precedents regarding the scope of qui tam and whistleblower lawsuits S. 386, Fraud Enforcement and Recovery Act, provisions amending the False Claims Act S. 537, Sunshine in Litigation Act, entire bill Legislative proposals to provide for reform of the civil justice system Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838730 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter CAW Issues related to motor vehicle fuel, including climate change, renewable fuels standards H.R. 1787 To amend the Clean Air Act regarding transportation fuels and establishment of a low carbon fuel standard Chemical Security Re-Authorization, entire bill S. 787 Clean Water Restoration Act, entire bill H.R. 2454, The American Clean Energy and Security Act of 2009, entire bill Issues: Clean Water Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-04:00
838731 KOCH GOVERNMENT AFFAIRS, LLC c471fb4f-e4df-4e59-b101-4ca524cf1552 Q3 KOCH GOVERNMENT AFFAIRS, LLC 400390816 KOCH GOVERNMENT AFFAIRS, LLC 2009 third_quarter LAW S. 445, Attorney-Client Privilege Protection Act, entire bill Legislative proposals regarding unnecessary and excessive criminal provisions in Federal legislation S. 569 Incorporation Transparency and Law Enforcement Assistance Act, Beneficial Ownership Overcriminalization/Legal Reform H.R. 1947, Legislation to regulate certain deferred prosecution agreements and nonprosecution agreements in Federal criminal case, entire bill Legislative proposals regarding unnecessary and excessive criminal provisions in Federal legislation Energy, Dept of,Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,SENATE   2120000 0 0 2009-10-19T14:59:27-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);