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

5 rows where filing_uuid = "4ce76927-204f-448c-a300-059d2b1ba02d" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: government_entities, received_date (date)

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 income_amount expense_amount is_no_activity is_termination received_date
3239447 THE LIAISON GROUP, LLC 4ce76927-204f-448c-a300-059d2b1ba02d Q3 THE LIAISON GROUP, LLC 401104378 NATIONAL CANNABIS ROUNDTABLE 2024 third_quarter BAN Ensuring cannabis businesses have access to financial services (Congresses the SAFE Banking Ac HR 2891, S. 1323). discussion of broad access to financial institutions and capital, The SAFER Banking Act S. 2860 HOUSE OF REPRESENTATIVES,SENATE 65500   0 0 2024-10-16T09:35:23-04:00
3239448 THE LIAISON GROUP, LLC 4ce76927-204f-448c-a300-059d2b1ba02d Q3 THE LIAISON GROUP, LLC 401104378 NATIONAL CANNABIS ROUNDTABLE 2024 third_quarter GOV Allowing District of Columbia to have autonomy on issues of creating a regulated cannabis marketplace HOUSE OF REPRESENTATIVES,SENATE 65500   0 0 2024-10-16T09:35:23-04:00
3239449 THE LIAISON GROUP, LLC 4ce76927-204f-448c-a300-059d2b1ba02d Q3 THE LIAISON GROUP, LLC 401104378 NATIONAL CANNABIS ROUNDTABLE 2024 third_quarter BUD Working on appropriations provisions that prevent the Department of Justice from interfering in state legal cannabis programs (both medical and adult use), allowing JAG Bryne funding to be used for expungements, banking language, various language proposals allowing veterans to access cannabis, fairness in federal drug testing, language protecting tribal sovereignty on cannabis decisions, and language promoting further research into cannabis. HOUSE OF REPRESENTATIVES,SENATE 65500   0 0 2024-10-16T09:35:23-04:00
3239450 THE LIAISON GROUP, LLC 4ce76927-204f-448c-a300-059d2b1ba02d Q3 THE LIAISON GROUP, LLC 401104378 NATIONAL CANNABIS ROUNDTABLE 2024 third_quarter LAW Bills to reduce criminal penalties of cannabis possession and distribution, including but not limited to for bills that remove cannabis from the Schedules in the Controlled Substances Act. Also active on provisions that would facilitate expungements of cannabis offenses including what the Misdemeanor Expungement Act (H.R. 8917) last congress and the HOPE Act (S. 4161, HR 2677) Legislation which gives states autonomy to regulate cannabis and deschedules cannabis based on state law. HOUSE OF REPRESENTATIVES,SENATE,White House Office 65500   0 0 2024-10-16T09:35:23-04:00
3239451 THE LIAISON GROUP, LLC 4ce76927-204f-448c-a300-059d2b1ba02d Q3 THE LIAISON GROUP, LLC 401104378 NATIONAL CANNABIS ROUNDTABLE 2024 third_quarter CSP Engaging with Congress on issues surrounding packaging, labeling, and tracing of regulated cannabis products. Educating on difference between cannabis, synthetic substances, and synthetic intoxicants that mimic cannabinoids Food & Drug Administration (FDA),HOUSE OF REPRESENTATIVES,SENATE,White House Office 65500   0 0 2024-10-16T09:35:23-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);