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

3 rows where filing_uuid = "0ccddf24-ed91-4c9f-afec-8f795b50bb59" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 3

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
2772865 AMERICAN ASSOCIATION OF LAW LIBRARIES 0ccddf24-ed91-4c9f-afec-8f795b50bb59 Q1 AMERICAN ASSOCIATION OF LAW LIBRARIES 1615 AMERICAN ASSOCIATION OF LAW LIBRARIES 2022 first_quarter BUD H.R. 2471, Consolidated Appropriations Act, 2022 (U.S. Government Publishing Office, Library of Congress, and National Archives and Records Administration) HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-13T12:35:40-04:00
2772866 AMERICAN ASSOCIATION OF LAW LIBRARIES 0ccddf24-ed91-4c9f-afec-8f795b50bb59 Q1 AMERICAN ASSOCIATION OF LAW LIBRARIES 1615 AMERICAN ASSOCIATION OF LAW LIBRARIES 2022 first_quarter CPT H.R. 6769, Protecting and Enhancing Public Access to Codes Act (Pro Codes Act) S. 3880, Strengthening Measures to Advance Rights Technologies (SMART) Copyright Act of 2022 HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-13T12:35:40-04:00
2772867 AMERICAN ASSOCIATION OF LAW LIBRARIES 0ccddf24-ed91-4c9f-afec-8f795b50bb59 Q1 AMERICAN ASSOCIATION OF LAW LIBRARIES 1615 AMERICAN ASSOCIATION OF LAW LIBRARIES 2022 first_quarter GOV H.R. 3241, To make improvements in the enactment of title 54, United States Code, into a positive law title and to improve the Code H.R. 3239, To make improvements in the enactment of title 41, United States Code, into a positive law title and to improve the Code H.R. 5961, To make revisions in title 5, United States Code, as necessary to keep the title current, and to make technical amendments to improve the United States Code H.R. 5982, To make revisions in title 51, United States Code, as necessary to keep the title current, and to make technical amendments to improve the United States Code H.R. 5677, To make technical amendments to update statutory references to certain provisions classified to title 2, United States Code, title 50, United States Code, and title 52, United States Code H.R. 5679, To make technical amendments to update statutory references to certain provisions classified to title 7, title 20, and title 43, United States Code H.R. 5695, To make technical amendments to update statutory references to certain provisions which were formerly classified to chapters 14 and 19 of title 25, United States Code H.R. 5705, To make technical amendments to update statutory references to provisions reclassified to title 34, United States Code H.R. 5844 and S. 2614, Open Courts Act of 2021 HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-13T12:35:40-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);