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

6 rows where filing_uuid = "c81961bd-e1c5-4eca-bcc9-8a2ec7e23270" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 6

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
257051 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end HCR Access to Dental Services-S.971, S.988, S.1626; Health Center Week - H.Res. 240, S.Res. 140; Legislation to temporarily increase the federal medical assistance percentage for the Medicaid program-S.2570; Patient Navigator, Outreach, and Chronic Disease Prevention - S.453, H.R.918; Women's Autoimmune Disease Research and Prevention-H.R.370; Domestic Violence Screening, Treatment and Prevention Act of 2002-H.R.1267; Access to Affordable Health Care Act-S.100; Medikids Health Insurance Act - H.R.1205, S.588; Health Care Access Res. - HCR99, SCR41; Building Better Health Centers - H.R.1386, S.673; Hispanic Health Improvement Act-S.1159, H.R.2258; Children's Dental Health Improvement Act - S.1142; Sickle Cell Treatment Act - S.874, H.R.1736; Securing Access, Value and Equity Act - H.R.1236; Hospital Mortgage Insurance Act of 2003-H.R.659; Diabetes, Prevention Access and Care Act-H.R.1916; Health Care Equality and Accountability Act of 2003(S.1833/H.R.3459). Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257052 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end IMM Eligibility of legal immigrant children for Medicaid and CHIP-S.845, H.R.1689; Legislation to reauthorize the Conrad-30 J-1 Visa program - S.2674, H.R.4858, H.R. 2215; The Federal Responsibility for Immigrant Health Act, S.2449; Improving Women's Health Act - S.1238. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257053 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end TAX Tax Relief for National Health Service Corps Scholarship and Loan Repayment Recipients-H.R.1522, S.529; Medicare provision in Jobs and Growth package - H.R.2. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257054 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end MMM Medicare Reform and Medicare Prescription Drug Coverage - H.R.1, S.1; Federal Health Coverage Expansions - S.582, S.827, S.1016, S.1244, H.R.2630, H.R.1143, H.R.1733; Medicare Safety Net Access Act of 2003-H.R.1377, S.654; Health Center Issues in Medicaid/SCHIP; Implementation of the Medicare Prospective Payment System for FQHCs; Children's Dental Health-S.1142; Medicare provisions in Jobs and Growth bill - H.R.2; Start Healthy, Stay Healthy Act-S.1033, H.R.2268. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257055 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end BUD Appropriations for health centers and related programs; Appropriations for access to health care for uninsured workers (CAP Program); REACH Initiative to double size of health center program S.Res.96, H.Res.142; LHHS Appropriations - H.R.246, H.R.2660, S.1356; Consolidated Appropriations Bill H.R.2673; Appropriations for the National Health Service Corps; Appropriations for HIV/AIDS programs; Congressional Budget Resolution (HCR 95, SCR 23); FY'03 Omnibus Appropriations (HJ Res 2); Continuing Resolutions 1-7 HJ Res 69, 73, 75, 76, 78, 79, 82. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05:00
257056 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS c81961bd-e1c5-4eca-bcc9-8a2ec7e23270 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2003 year_end PHA Drug Discount Program (Section 340B of the Public Health Service Act); Medicare Reform and Prescription Drug Coverage - H.R.1, S.1. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE   260000 0 0 2004-02-10T00:00:00-05: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);