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 = "f7e48ba2-84a7-4488-b73b-05bf287cff7f" 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
520291 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year TAX Legislation regarding potential LIFO repeal Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-04:00
520292 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year HCR S.1082, Food and Drug Administration Revitalization Act S. 1695, Biologics Price Competition and Innovation Act of 2007 S. 1693, Wired for Health Care Quality Act H.R. 1368, Personalized Health Information Act of 2007 S. 1783, Ten Steps to Transform Health Care in America Act S. 321, Fostering Independence Through Technology Act of 2007 H.R. 2791, Unique Device Identification System for Medical Devices Act of 2007 H.R. 2991, Independent Health Record Trust Act of 2007 S. 1456, Federal Employees Electronic Personal Health Records Act of 2007 S. 63, Remote Monitoring Access Act of 2007 H.R. 2900, Food and Drug Administration Amendments Act of 2007 Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-04:00
520293 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year MMM S. 3, Medicare Prescription Drug Price Negotiation Act of 2007 H.R. 4, Medicare Prescription Drug Price Negotiation Act of 2007 H.R. 1474, Fair and Speedy Treatment (FAST) of Medicare Prescription Drug Claims Act of 2007 S. 1544, Medicare Quality Enhancement Act of 2007 Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-04:00
520294 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year BUD S. 1710, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008 H.R. 2206, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007 S. 2107, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007 H.R. 1591, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007 S. 965, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007 H.J. Res. 20, Revised Continuing Appropriations Resolution, 2007 H.R. 2642, Military Construction and Veterans Affairs Appropriations Act, 2008 S. 1645, Military Construction and Veterans Affairs Appropriations Act, 2008 H.R. 3043, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008 Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-04:00
520295 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year PHA S. 980, Online Pharmacy Consumer Protection Act of 2007 H.R. 971, Community Pharmacy Fairness Act of 2007 S. 885, Community Pharmacy Fairness Act of 2007 S. 242, Pharmaceutical Market Access and Drug Safety Act of 2007 H.R. 380, Pharmaceutical Market Access and Drug Safety Act of 2007 S. 251, Pharmaceutical Market Access Act of 2007 S. 596, Safe Internet Pharmacy Act of 2007 Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-04:00
520296 VAN NESS FELDMAN, LLP f7e48ba2-84a7-4488-b73b-05bf287cff7f MM VAN NESS FELDMAN, LLP 39815 MCKESSON CORPORATION 2007 mid_year VET Education regarding the Department of Veterans Affairs Pharmaceutical Prime Vendor contract Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 100000   0 0 2007-08-10T15:05:36-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);