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 = "c8eb482b-233f-48ad-9385-e2f9e05ee3bc" 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
1880114 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter DEF Pharmacy issues related to the annual defense reauthorization (HR 4909). Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-04:00
1880115 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter TAX Regulatory implementation of various tax provisions in the health reform law, including the health insurer tax (HR 928/ S 183). Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-04:00
1880116 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter HCR Regulatory policies related to the health reform law: structure, drug benefits, disclosure. Regulatory implementation of HITECH/accounting of disclosures. Issues regarding making prescription drugs more affordable. Restrictions on specialty tiering. Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-04:00
1880117 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter POS Postal reform proposals, including rate reform, and their impact on 6 day mail delivery. Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-04:00
1880118 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter MMM Health reform proposals that impact Medicare Part D such as formulary requirements, PBM disclosure provisions, closing of the Part D coverage gap. General Legislative and regulatory issues such as direct negotiation. Statutory implementation of changes to the definition of AMP in Medicaid. Exclusion of specialty distributors prompt pay discounts from the definition of average sales prices. Medicare audit and preferred network restrictions. HR 244; HR 793. Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-04:00
1880119 EXPRESS SCRIPTS, INC. c8eb482b-233f-48ad-9385-e2f9e05ee3bc Q3 EXPRESS SCRIPTS, INC. 294416 EXPRESS SCRIPTS, INC. 2016 third_quarter PHA Regulatory design and coverage of pharmacy benefits in health reform Exchanges and the commercial market, including: EHB, grandfathering, Rx quality, eRx, PBM disclosure, MLR, specialty pharmacy tiering restrictions. Regulatory implementation of a pathway for the approval of biosimilars. REMs. 340b program reform. policies placing restrictions on pharmacy benefit design. Issues regarding making prescription drugs more affordable, including: generic user fees, pedigree, biosimilars, REMs. General issues dealing with prescription drug abuse, including Medicare lock-in programs. General issues dealing with regulating pharmacy drug compounding. HR 1600; S 1190/ HR793. Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Executive Office of the President (EOP),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),Health Resources & Services Administration (HRSA),HOUSE OF REPRESENTATIVES,Internal Revenue Service (IRS),Labor, Dept of (DOL),Medicare Payment Advisory Commission (MedPAC),Office of Personnel Management (OPM),SENATE,White House Office   690000 0 0 2016-10-17T16:02:20.507000-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);