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. Sortable columns (indexed): client_name, issue_code, filing_year, filing_uuid. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

5 rows where filing_uuid = "b47a1572-3933-4414-9907-70a922c6f8b9" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 5

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 is_no_activity is_termination received_date
2770105 THE PRESTON GROUP, LLC b47a1572-3933-4414-9907-70a922c6f8b9 Q1 THE PRESTON GROUP, LLC 401105373 OKLAHOMA DEPARTMENT OF WILDLIFE CONSERVATION 2022 first_quarter MAR Update Congressional staff on USACE implementation guidance for Section 204 of S.1811 from the 116th Congress. Provided an update to Senate staff on a fishery in Oklahoma. HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-06T10:09:24-04:00
2770106 THE PRESTON GROUP, LLC b47a1572-3933-4414-9907-70a922c6f8b9 Q1 THE PRESTON GROUP, LLC 401105373 OKLAHOMA DEPARTMENT OF WILDLIFE CONSERVATION 2022 first_quarter NAT Recovering America's Wildlife Act reintroduction and movement through House and Senate Committees, HR 2773 and S. 2372. Lesser Prairie Chicken status and response to the proposed listing from the U.S. Fish and Wildlife Service. Shared Alligator Snapping Turtle proposed listing comment letter with Oklahoma Delegation. Discussion of Endangered Species Act provisions with Senate staffers. Provided information to Senator's office for a Energy and Natural Resources hearing on hydropower. HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-06T10:09:24-04:00
2770107 THE PRESTON GROUP, LLC b47a1572-3933-4414-9907-70a922c6f8b9 Q1 THE PRESTON GROUP, LLC 401105373 OKLAHOMA DEPARTMENT OF WILDLIFE CONSERVATION 2022 first_quarter BUD FY 2023 appropriations requests submission to Oklahoma Delegation including: Interior & Environment appropriations: State and Tribal Wildlife Grants program Interior & Environment appropriations: Cooperative Endangered Species Conservation Funding Interior & Environment appropriations: Cooperative Fish and Wildlife Research Units Interior & Environment appropriations: Aquatic Invasive Species funding Interior & Environment appropriations: Migratory Bird Conservation Program funding Agriculture appropriations: Voluntary Public Access & Habitat Incentive Program funding HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-06T10:09:24-04:00
2770108 THE PRESTON GROUP, LLC b47a1572-3933-4414-9907-70a922c6f8b9 Q1 THE PRESTON GROUP, LLC 401105373 OKLAHOMA DEPARTMENT OF WILDLIFE CONSERVATION 2022 first_quarter ANI Recovering America's Wildlife Act reintroduction, HR 2773 and S. 2372. FY2023 Interior & Environment appropriations: State and Tribal Wildlife Grants program FY2023 Interior & Environment appropriations: Cooperative Endangered Species Conservation Funding FY2023 Interior & Environment appropriations: Cooperative Fish and Wildlife Research Units FY2023 Interior & Environment appropriations: Aquatic Invasive Species funding FY2023 Interior & Environment appropriations: Migratory Bird Conservation Program funding HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-06T10:09:24-04:00
2770109 THE PRESTON GROUP, LLC b47a1572-3933-4414-9907-70a922c6f8b9 Q1 THE PRESTON GROUP, LLC 401105373 OKLAHOMA DEPARTMENT OF WILDLIFE CONSERVATION 2022 first_quarter AGR Submitted Farm bill requests for the next reauthorization. FY2023 Agriculture appropriations: Voluntary Public Access & Habitat Incentive Program funding HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-06T10:09:24-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,
            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);