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

14 rows where filing_uuid = "65efd596-2863-4b2b-b4fc-cb13a0e7bcd2" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 14

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
2675721 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter FOO Food labeling - Bread Tax - Grain Foods Promotions Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675722 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter CAW Oven emission - green house gases, ethanol Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675723 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter RRR Rail car shortages Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675724 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter ACC Slotting fees Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675725 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter CDT wheat, soy and corn Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675726 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter ECN Business development Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675727 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter ENG Power rates, contract carriage Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675728 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter AGR Farm Bill, Sugar, commodities, Palm Oil imports, Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675729 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter UTI Power rates Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675730 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter URB Urban land use Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675731 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter HCR Health Care - various Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675732 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter TRU Hours of service Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675733 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter CSP Slotting Fees Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-04:00
2675734 ROBERT N. PYLE & ASSOCIATES, INC. 65efd596-2863-4b2b-b4fc-cb13a0e7bcd2 Q3 ROBERT N. PYLE & ASSOCIATES, INC. 32500 INDEPENDENT BAKERS ASSOCIATION 2021 third_quarter GOV Governance Agriculture, Dept of (USDA),Commodity Futures Trading Commission (CFTC),Energy, Dept of,Environmental Protection Agency (EPA),Federal Energy Regulatory Commission (FERC),Federal Motor Carrier Safety Administration,Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,Natl Highway Traffic Safety Administration (NHTSA),Occupational Safety & Health Administration (OSHA),Pension Benefit Guaranty Corporation (PBGC),SENATE,Transportation, Dept of (DOT),U.S. Trade Representative (USTR),White House Office     0 0 2021-10-01T13:07:18.737000-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);