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 = "3ecbdb05-e76a-4cff-a6bb-df44d5d668c5" 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
83948 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end PHA Drug Discount Program (Section 340 B of the Public Health Service Act). Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00:00:00-05:00
83949 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end TAX Tax Relief for National Health Care Scholarship Recipients -- H.R. 1414; S. 288; H.R. 2488; S. 1429; H.R. 324. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00:00:00-05:00
83950 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end IMM Eligibility of legal immigrant children for Medicaid and CHIP -- S. 1227; H.R. 4707 Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00:00:00-05:00
83951 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end HCR Managed Care Reform -- H.R. 2990; Health Centers Programs under Section 330 of the Public Health Service Act; National Health Service Corps Reauthorization; RECA Amendments -- S. 1515; Rural Health Care - H.R. 1344; S. 980; Health Care Fairness (racial and ethnic disparities) -- H.R. 3250; S. 1880; Ryan White Comprehensive AIDS Resources Emergency Awareness Act of 2000 -- H.R. 4807; S. 2311; Children's Health Act of 2000 -- H.R. 4365; S. 2868; Adoption Awareness Act of 1999 -- H.R. 2511; S. 1382; Access to Dental Services -- H.R. 1920; S. 1035; S. 901; Authorization of program to provide access to health care for uninsured workers (CAP program) -- S. 2923; H.R. 4927; H.R. 4970; PL 106-105, the Public Health Improvement Act. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00:00:00-05:00
83952 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end MMM Reimbursement of Federally Qualified Health Centers -- H.R. 2341; S. 1277; S. 1678; S. 1582; H.R. 3194; S. 980; H.R. 3075; H.R. 3146; H.R. 5001; H.R. 5291; S. 3077; H.R. 5661. Extension of Medicaid and SCHIP Coverage -- H.R. 4927; H.R. 4970; S. 2923. Medicare Prescription Drug Benefit. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00:00:00-05:00
83953 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 3ecbdb05-e76a-4cff-a6bb-df44d5d668c5 YY NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 26706 NATIONAL ASSOCIATION OF COMMUNITY HEALTH CENTERS 2000 year_end BUD Appropriations for health centers and related programs -- H.R. 4577; S. 2553; Appropriations for Children's Health Insurance Program -- H.R. 4577; S. 2553; Appropriations for access to health care for uninsured workers (CAP program) -- H.R. 4577; S. 2553. REACH Initiative to double size of health center program -- S. Res. 260; S. Con Res. 101; H. Con Res. 290. Executive Office of the President (EOP),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE   220000 0 0 2001-02-13T00: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);