lobbying: lobbying_activities: 12 rows where filing_uuid = "adfa368f-c0e2-4ed0-8da6-e34dfe9b677d" sorted by filing

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 = "adfa368f-c0e2-4ed0-8da6-e34dfe9b677d" sorted by filing_year descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id	filing_uuid	filing_type	registrant_name	registrant_id	client_name	filing_year ▲	filing_period	issue_code	specific_issues	government_entities	expense_amount	received_date
934086	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	CHM	H.R. 2868, The Chemical Facility Anti-Terrorism Act of 2009, entire bill H.R. 2892, Department of Homeland Security Appropriations Act, 2010, entire bill S.1660, Formaldehyde Standards for Composite Wood Products Act, entire bill S. 787, Clean Water Restoration Act, entire bill S. 2996, Continuing Chemical Facilities Antiterrorism Security Act of 2010	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934087	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_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 H.R. 2477, Chemical Facility Security Authorization Act of 2009, entire bill Low Carbon Fuel Standard/Inslee Bill /Climate S. 787 Clean Water Restoration Act, entire bill H.R. 2454, The American Clean Energy and Security Act of 2009, entire bill H.R. 2868, Chemical Facility Antiterrorism Act of 2009 S.J. Res. 26, A joint resolution disapproving a rule submitted by the Environmental Protection Agency relating to the endangerment finding and the cause or contribute findings for greenhouse gases under section 202(a) of the Clean Air Act S. 3072, Stationary Source Regulations Delay Act, entire bill H.J. RES. 77, Disapproving a rule submitted by the Enviornmental Agency relating to the endangerment finding and the cause or contribute findings for greenhouse gases under section 202(a) of the Clean Air Act, entire bill H.R. 4572, To amend the Clean Air Act relating to greenhouse gases, and for other purposes, entire bill H.R. 391, To amend the Clean Air Act to provide that greenhouse gases are not subject to the Act, and for other purposes, entire bill H.R. 4396, To amend the Clean Air Act to provide that greenhouse gases are not subject to the Act, and for other purposes, entire bill. Issues related to motor vehicle fuel including climate change, renewable fuels standards Issues related to climate change, renewables, low carbon fuel standards, small refiners	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934088	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	GOV	S. 1745, the Non-Federal Employee Whistleblower Protection Act of 2009, entire bill	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934089	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	DEF	FY11, Defense appropriations and authorizations, entire bill.	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934090	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_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 H.R. 977, Derivatives Markets Transparency and Accountability Act of 2009, entire bill H.R. 1754, Financial System Stabilization and Reform Act of 2009, entire bill H.R. 4173, the Wall Street Reform and Consumer Protection Act, Titles I and III, provisions related to systemic risk Regulator and commodity derivatives, entire bill H.R. 3996, Financial Stability Improvement Act of 2009, provisions related to Systemic Risk Regulator, Credit Risk Retention Act of 2009, Payment, Clearing, and Settlement Supervision Act of 2009, Resolution Authority for Large, Interconnected Financial Companies Act of 2009, entire bill H.R. 3818, Private Fund Investment Advisers Registration Act, entire bill H.R. 3795, the Over-the-Counter Derivatives Markets Act of 2009, entire bill S. 3268, Stop Excessive Energy Speculation Act, entire bill S. 447, Prevent Excessive Speculation Act, entire bill S. 664, Financial System Stabilization and Reform Act of 2009, entire bill Draft Legislation, American Financial Stability Act, provisions related to the creation of a systemic risk regulator for the financial services industry and commodities derivatives	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934091	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	TRA	H.R. 3617 Surface Transportation Extension Act of 2009, entire bill H.R. 1799, Safe and Efficient Transportation Act of 2009, entire bill H.R. 3288, Transportation, Housing and Urban Development, and Related Agencies Appropriations Act, 2010	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934092	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	TAX	H.R. 3617, Surface Transportation Extension Act of 2009, entire bill General tax matters including the manufacturers' deduction and the alternative fuel and alternative fuels mixture credit H.R. 4213, American Workers, State and Business Relief Act of 2010, entire bill S. 3268, Stop Excessive Energy Speculation Act, entire bill Issues related to section 199 Manufacturing Deduction H.R. 4213, Tax Extenders Act, entire bill S. 870, H.R. 622, A bill to amend the Internal Revenue Code of 1986 to expand the 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, entire bill	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934093	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	ENV	H.R. 2454, American Clean Energy and Security Act, entire bill H.R. 1787, Low Carbon Fuels Standard Act of 2009, entire bill S. 1733, Clean Energy Jobs & American Power Act, entire bill S. 787, Clean Water Restoration Act, entire bill S. 1095, America's Low-Carbon Fuel Standard Act of 2009, entire bill S. 1622, Clean Air Protection Act, 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 Legislative proposals regarding climate change, provisions realted to inclusion of new low carbon fuels standards EPA Endangerment Finding Kerry-Graham Draft (issues related to climate change)	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934094	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	CSP	H.R. 2129, Federal Price Gouging Prevention Act, entire bill 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),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934095	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_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 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 H.R. 2448, Prevent Unfair Manipulation of Prices Act, entire bill 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. 2998, National Climate Service Act of 2009, entire bill S. 807, SMART Energy Act, 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 S. 967 Strategic Petroleum Reserve Modernization Act, entire bill S. 539 Clean Renewable Energy and Economic Development, entire bill S. 1225, To require the CFTC to take certain actions to prevent manipulation of energy markets, entire bill S. 888, Oil Industry Tax Break Act of 2009, entire bill S. 337, Prevent Excessive Speculation Act, entire bill S. 1733, Clean Energy Jobs & American Power Act, entire bill S. 1462, American Clean Energy Leadership Act of 2009, entire bill S. 949, 21st Century Energy Technology Deployment Act, entire bill S. 2996, Continuing Chemical Facilities Antiterrorism Security Act of 2010, entire bil…	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934096	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	HOM	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, entire bill S. 2996, the Continuing Chemical Facilities Antiterrorism Security Act, entire bill	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-04:00
934097	KOCH GOVERNMENT AFFAIRS, LLC adfa368f-c0e2-4ed0-8da6-e34dfe9b677d	Q1	KOCH GOVERNMENT AFFAIRS, LLC	400390816	KOCH GOVERNMENT AFFAIRS, LLC	2010	first_quarter	LAW	S. 569 Incorporation Transparency and Law Enforcement Assistance Act, Beneficial Ownership Issues related to overcriminalization/legal reform H.R. 4326, Attorney-Client Privilege Protection Act of 2009, entire bill Issues: Legislative proposals regarding unnecessary and excessive criminal provisions in Federal legislation S. 1504, "Notice Pleading Restoration Act," entire bill H.R. 4115, "Open Access to Courts Act," entire bill Proposed amendments to the U.S. Sentencing Guidelines related to commodities fraud and unauthorized disclosures of personal health insurance information Draft legislation, FY 2011 Labor-Health and Human Services-Education Appropriation Act, provisions related to funding for OSHA Voluntary Protection Program	Energy, Dept of,Environmental Protection Agency (EPA),Homeland Security, Dept of (DHS),HOUSE OF REPRESENTATIVES,SENATE,Treasury, Dept of	1950000	2010-04-20T14:38:59.143000-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);