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

1 row where filing_uuid = "91dec2df-809c-4a05-9dba-fa263b2cb4aa" and issue_code = "HCR" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 1

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
3147029 AMERICAN PSYCHOLOGICAL ASSOCIATION SERVICES INC.(FKA AMERICAN PSYCHOLOGICAL ASSN 91dec2df-809c-4a05-9dba-fa263b2cb4aa Q1 AMERICAN PSYCHOLOGICAL ASSOCIATION SERVICES INC.(FKA AMERICAN PSYCHOLOGICAL ASSN 60138 AMERICAN PSYCHOLOGICAL ASSOCIATION SERVICES INC.(FKA AMERICAN PSYCHOLOGICAL ASSN 2024 first_quarter HCR Womens Health Protection Act Mental Health Workforce Shortages Coding and reimbursement for digital therapeutics devices (DTx) and services furnished via DTx Meeting with various administrative agencies on expanding access to mental health care in rural areas Forthcoming House bill on capital investments in rural mental health Federal policies affecting access to contingency management services for substance use disorders H. R. 498 / S.1493, 9-8-8 Lifeline Cybersecurity Responsibility Act H.R. 501 Block, Report, And Suspend Suspicious Shipments Act H.R. 773/S. 3165, Homelessness and Behavioral Health Care Coordination Act of 2023 H.R. 824, Telehealth Benefit Expansion for Workers Act H.R. 1359/S. 644 Modernizing Opioid Treatment Access Act H.R. 1423 911 Community Crisis Responders Act of 2023 H.R. 1502 Comprehensive Opioid Recovery Centers Reauthorization Act of 2023 H.R. 2400 The Reentry Act H.R. 2474 - The Strengthening Medicare for Patients and Providers Act H.R.2577/S.1137,DHS Suicide Prevention and Resiliency for Law Enforcement Act H.R. 3074/S. 971 The Due Process Continuity of Care Act HR 3305 Black Maternal Health Momnibus Act H.R. 3375 STOP Fentanyl Overdoses Act H.R. 3432/S. 3651 Telemental Health Care Access Act H.R. 3548 Pursuing Equity in Mental Health Act H.R. 3752 Parity Enforcement Act of 2023 H.R. 3759 Barriers to Suicide Act of 2023 H.R. 3850/S.3949 Pride in Mental Health Act H.R.4310/S.2233, Youth Poisoning Protection Act H.R. 4531 / S. 2433, SUPPORT for Patients and Communities Reauthorization Act of 2023 H.R. 4851, 9-8-8 Implementation Act of 2023 H.R. 4892, Medicaid Bump Act H.R. 4884 /S. 2476 Mental Health for Latinos Act of 2023 H.R.4974, Local 988 Response Act H.R. 5866, Substance Use Disorder and Family Engagement (SAFE) in Recovery Act H.R. 6284/S. 3260 Improving Measurements for Loneliness and Isolation Act of 2023 H.R. 6475 Health Disparity Zones Act of 2023 H.R.6928 CONNECT Act of 2024 S.669 Increasing Mental Health Options Act of 2023 S. 923 Better Mental Health Care for Americans A… Agriculture, Dept of (USDA),Centers For Disease Control & Prevention (CDC),Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Faith-Based & Community Initiatives,Office of Management & Budget (OMB),SENATE,Substance Abuse & Mental Health Services Administration (SAMHSA),Treasury, Dept of   400000 0 0 2024-04-16T15:37:16-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);