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_period = "first_quarter" and filing_uuid = "e57351e5-5624-4e14-9689-e4d971edc29f" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

issue_code 5

filing_year 1

filing_period 1

  • first_quarter · 5 ✖
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
2772299 THE NICKLES GROUP, LLC e57351e5-5624-4e14-9689-e4d971edc29f Q1 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2022 first_quarter HCR Monitored implementation of P.L. 117-2, the American Rescue Plan, as it relates to COVID relief. Issues regarding COVID relief. Issues related to mental health. Issues related to FDA user fee agreements. Issues related to clinical trial diversity. S.3799, The PREVENT Pandemic Act and issues regarding pandemic preparedness. Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-12T15:44:57-04:00
2772300 THE NICKLES GROUP, LLC e57351e5-5624-4e14-9689-e4d971edc29f Q1 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2022 first_quarter MMM H.R. 6007, Expansion of Coverage of Vaccines under Part B of the Medicare Program. Issues related to maternal health. Issues related to COVID relief. Monitored drug pricing issues related to H.R. 5376, The Build Back Better Act. Issues concerning mental health. Monitored S. 3700 / H.R. 6833, Affordable Insulin Now Act. HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-12T15:44:57-04:00
2772301 THE NICKLES GROUP, LLC e57351e5-5624-4e14-9689-e4d971edc29f Q1 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2022 first_quarter TAX H.R. 5376, the Build Back Better Act, as it relates to corporate taxes. HOUSE OF REPRESENTATIVES,SENATE 0 0 2022-04-12T15:44:57-04:00
2772302 THE NICKLES GROUP, LLC e57351e5-5624-4e14-9689-e4d971edc29f Q1 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2022 first_quarter GOV Monitored implementation of P.L. 117-2, the American Rescue Plan, as it relates to COVID relief. Issues regarding COVID relief. Issues related to mental health. Issues related to FDA user fee agreements. H.R. 6007, Expansion of Coverage of Vaccines under Part B of the Medicare Program. Issues related to maternal health. Monitored drug pricing issues related to H.R. 5376, The Build Back Better Act. Monitored H.R. 6833, Affordable Insulin Now Act. Issues related to diversity in clinical trials, including H.R. 5030, DIVERSE Trials Act. HOUSE OF REPRESENTATIVES 0 0 2022-04-12T15:44:57-04:00
2772303 THE NICKLES GROUP, LLC e57351e5-5624-4e14-9689-e4d971edc29f Q1 THE NICKLES GROUP, LLC 293335 JOHNSON & JOHNSON SERVICES, INC. 2022 first_quarter BNK H.R. 4777/S. 2497, the Nondebtor Release Prohibition Act and issues concerning bankruptcy reform. SENATE 0 0 2022-04-12T15:44:57-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);