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 = "9418c6cb-e784-4516-b21e-2abbdaee2bef" 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
471812 MICHAEL POLLARD 9418c6cb-e784-4516-b21e-2abbdaee2bef YY MICHAEL POLLARD 87836 MEDCO HEALTH SOLUTIONS INC 2006 year_end HCR HR 22 Postal Accountability and Enhancement Act HR 184 Controlled Substances Export Reform Act of 2005 HR 218 Health Care Tax Deduction Act of 2005 HR 328 Pharmaceutical Market Access Act of 2005 HR 700 Pharmaceutical Market Access and Drug Safety Act of 2005 HR 753 Safe Importation of Medical Products and Other Rx Therapies Act of 2005 HR 747 National Health Information Incentive Act of 2005 HR 1132 National All Schedules Prescription Electronic Reporting Act of 2005 HR 1223 Information Technology for Health Care Quality Act HR 4832 Electronic Health Information Technology Act of 2006 HR 4157 Health Information Technology Promotion Act of 2005 HR 5166 Independent Pharmacy Protection Act of 2006 HR 5182 Fair and Speedy Treatment (FAST) of Medicare Prescription Drug Claims Act of 2006 HR 1626 Medicare Prescription Drug Improvement Act HR 1669 Pharmacy Benefit Manager Transparency Act of 2005 HR 1671 Community Pharmacy Fairness Act of 2005 HR 1710 Internet Police Protection Act of 2005' HR 1808 Safe Online Drug Act of 2005 HR 2234 21st Century Health Information Act of 2005 HR 2664 Biennial Budgeting and Appropriations Act of 2005 HR 2774 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act of 2006 HR 5384 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act of 2007 S 4 Healthy America Act of 2005 S 16 Affordable Health Care Act S 109 Pharmaceutical Market Access Act of 2005 S 184 Safe Importation of Medical Products and Other Rx Therapies Act of 2005 S 334 Pharmaceutical Market Access and Drug Safety Act of 2005 S 518 National All Schedules Prescription Electronic Reporting Act of 2005 S 662 Postal Accountability and Enhancement Act S 975 Project BiosSheild II Act of 2005 S 1223 Information Technology for Health Care Quality Act S 1227 Health Information Technology Act of 2005 S 1262 Health Technology to Enhance Quality Act of 2005 S 1418 Wired for Health Care Quality Act S 2072 Medicare Early Access Ac… Centers For Medicare and Medicaid Services (CMS),Congressional Budget Office (CBO),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE 160000   0 0 2007-02-08T14:04:26-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);