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 = "0a00a669-c734-4cd8-ae0e-ecae7edbe8e0" 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
1446659 ALFRED W. CORS, JR 0a00a669-c734-4cd8-ae0e-ecae7edbe8e0 Q3 ALFRED W. CORS, JR 285277 RETIRESAFE 2013 third_quarter HCR Commented to the Secretary of Health and Human Services on the Proposed Rule "Medicaid, Children's Health Insurance Programs, and Exchanges: Essential Health Benefits in Alternative Benefit plans, Eligibility Notices Appeals and Other provisions Related to Eligibility and Enrollment for Exchanges, Medicaid and CHIP, and Medicaid Premiums and Cost Sharing." Support language that states must cover all drugs by companies that participate in the Medicaid drug rebate program. Oppose language that allows states toplace "limitations on amount, duration, and scope" and "adopt prior authorization other utilization control measures, as well as policies that promote the use of generic drugs," as open-ended limitations that can greatly impact access and violate the non-discrimination requirements included in the ACA. Urged at least 60 days for the public to review and comment on the respective state plans and subsequent plan changes. Support requiring all Alternative Benefit Plans to cover all preventive service that plans in the marketplace must cover, and oppose cost sharing for the Medicaid expansion population. Urge HHS to ensure that "medically frail" beneficiaries are not forced into a plan that provides fewer benefits than the ABP or the traditional Medicaid package. Urge the strongest possible non-discrimination rule across plans. Oppose copays for the very poor, or in the alternative, support monthly caps on copays. Oppose discriminatory copays and cost-sharing for non-preferred drugs. Oppose the use of "cost-effectiveness standards" which may compromise care. Support preferred cost-sharing on non-preferred drugs where the prescribing physician determines that the preferred drug would not be as effective or would have adverse effects for the patient. Urge clear and understandable notices and an easily understood, fully accessible, and speedy appeals process. Oppose sequestration budget cuts that negatively impact the Alzheimer's disease patient community including cuts to basic and translational Alzheimer's resear… Agency for Healthcare Research & Quality (AHRQ),Centers For Medicare and Medicaid Services (CMS),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Natl Institutes of Health (NIH),President of the U.S.,SENATE 5060   0 0 2013-10-17T12:51:35.630000-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);