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

11 rows where filing_uuid = "d1c6fbb9-910d-4e5f-bd8a-9201d343abe3" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 11

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
1764028 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter TRD Trade Promotion Authority (support), Trans-Pacific Partnership FTA (monitor/evaluate), Transatlantic Trade and Investment Partnership, status of common food names/geographic indicators (monitor) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764029 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter AGR Farm Bill Implementation: monitor; Farmer Cooperative Caucus (support); Ag technology (support), H.R. 1599 The Safe and Accurate Food Labeling Act of 2015 (support), Food for Progress (support), Local and Regional Procurement (support): Waters of the US rule (oppose) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764030 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter TAX Sec. 179 tax deduction and bonus depreciation (support restoring 2014 rate) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764031 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter FOR Food for Peace, Food for Progress, McGovern-Dole, Local and Regional Purchase Program, Farmer to Farmer Programs, and development assistance (support); cargo preference (oppose increase), Feed the Future permanent authorization/Global Food Security Act (support) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764032 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter BUD Agriculture Appropriations, Foreign Operations Appropriations, International Affairs budget (monitor), omnibus appropriations act (monitor) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764033 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter IMM Immigration reform (monitor) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764034 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter FOO Food Safety Modernization Act implementation (monitor); Child Nutrition Act re authorization (support) Healthy Hunger Free Kids Act implementation (monitor), Dietary Guidelines proposals (monitor), food nutrition labeling (monitor, oppose added sugar) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764035 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter CAW Reducing Regulatory Burdens Act (HR 897, support); Waters of the US rule (oppose); S. 1140 support, Worker Protection Standards (monitor) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764036 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter NAT California and western states drought relief (support), H.R. 2898 The Western Water and American Food Security Act (support), California Emergency Drought Relief Act (monitor/support some provisions) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764037 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter RET Provisions in the Multiemployer Pension Reform Act of 2014 included in H.R. 83, the Consolidated and Further Continuing Appropriations Act, 2015 (Pub. Law 113-235); Pension Accountability Act (oppose) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-05:00
1764038 LAND O'LAKES, INC. d1c6fbb9-910d-4e5f-bd8a-9201d343abe3 Q4 LAND O'LAKES, INC. 22110 LAND O'LAKES INC 2015 fourth_quarter TRU Rail cargo preference (monitor), Safe Trucking Act (support), Positive Train Control compliance extension (support), Surface Transportation Reauthorization and Reform Act (support) Agriculture, Dept of (USDA),Environmental Protection Agency (EPA),Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Pension Benefit Guaranty Corporation (PBGC),SENATE,Treasury, Dept of,U.S. Trade Representative (USTR)   330000 0 0 2016-01-11T10:01:27.577000-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);