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

5 rows where filing_uuid = "fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea" sorted by filing_year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

issue_code 5

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
2463363 AMERICAN PHARMACISTS ASSOCIATION fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea Q2 AMERICAN PHARMACISTS ASSOCIATION 3071 AMERICAN PHARMACISTS ASSOCIATION 2020 second_quarter MAN HR 6080 - Preventing Drug Shortages Act. To amend the Federal Food, Drug, and Cosmetic Act to reduce drug shortages, and for other purposes. HOUSE OF REPRESENTATIVES,SENATE   34000 0 0 2020-07-10T12:21:58.880000-04:00
2463364 AMERICAN PHARMACISTS ASSOCIATION fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea Q2 AMERICAN PHARMACISTS ASSOCIATION 3071 AMERICAN PHARMACISTS ASSOCIATION 2020 second_quarter HCR H.R. 2482/S. 2074 Mainstreaming Addiction Treatment Act of 2019- To amend section 303(g) of the Controlled Substances Act (21 U.S.C. 823(g)) to eliminate the separate registration requirement for dispensing narcotic drugs in schedule III, IV, or V (such as buprenorphine) for maintenance or detoxification treatment, and for other purposes. H.R. 6800 - This bill responds to the COVID-19 (i.e., coronavirus disease 2019) outbreak and its impact on the economy, public health, state and local governments, individuals, and businesses. HOUSE OF REPRESENTATIVES,SENATE   34000 0 0 2020-07-10T12:21:58.880000-04:00
2463365 AMERICAN PHARMACISTS ASSOCIATION fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea Q2 AMERICAN PHARMACISTS ASSOCIATION 3071 AMERICAN PHARMACISTS ASSOCIATION 2020 second_quarter CSP HR 5663 - "Safeguarding Therapeutics Act". To amend the Federal Food, Drug, and Cosmetic Act to give authority to the Secretary of Health and Human Services, acting through the Commissioner of Food and Drugs, to destroy counterfeit devices. HOUSE OF REPRESENTATIVES,SENATE   34000 0 0 2020-07-10T12:21:58.880000-04:00
2463366 AMERICAN PHARMACISTS ASSOCIATION fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea Q2 AMERICAN PHARMACISTS ASSOCIATION 3071 AMERICAN PHARMACISTS ASSOCIATION 2020 second_quarter EDU HR 6699 - To establish a commission to determine essential employment during the COVID-19 crisis period and provide loan repayment and education credit to workers employed in such essential employment during such crisis, and for other purposes. HR 6433 - To provide an exclusion from gross income for certain qualified first responders. HOUSE OF REPRESENTATIVES,SENATE   34000 0 0 2020-07-10T12:21:58.880000-04:00
2463367 AMERICAN PHARMACISTS ASSOCIATION fa6dfd70-58b1-4fda-9ae3-31f9a7ea52ea Q2 AMERICAN PHARMACISTS ASSOCIATION 3071 AMERICAN PHARMACISTS ASSOCIATION 2020 second_quarter PHA H.R. 789 - To amend title XVIII of the Social Security Act to prohibit prescription drug plan sponsors and MA-PD organizations under the Medicare program from retroactively reducing payment on clean claims submitted by pharmacies. H.R. 803 - This bill prohibits Medicare prescription drug plan sponsors from retroactively reducing payment on clean claims submitted by pharmacies. (A "clean claim" is a Medicare claim that is free of defects such as incomplete documentation.) H.R. 1034 - Phair Pricing Act of 2019; To amend title XVIII of the Social Security Act to require pharmacy-negotiated price concessions to be included in negotiated prices at the point-of-sale under part D of the Medicare program S. 640 - To amend title XVIII of the Social Security Act to require pharmacy-negotiated price concessions to be included in negotiated prices at the point-of-sale under part D of the Medicare program, and for other purposes. S. 476 - Creating Transparency to Have Drug Rebates Unlocked (C-Thru) Act of 2019 - To amend titles XI and XVIII of the Social Security Act to provide greater transparency of discounts provided by drug manufacturers. S. 476 - Creating Transparency to Have Drug Rebates Unlocked (C-Thru) Act of 2019 - To amend titles XI and XVIII of the Social Security Act to provide greater transparency of discounts provided by drug manufacturers. H.R. 3 Lower Drug Costs Now Act of 2019-To establish a fair price negotiation program, protect the Medicare program from excessive price increases, and establish an out-of-pocket maximum for Medicare part D enrollees, and for other purposes. S.2543 Prescription Drug Pricing Reduction Act of 2019 -To amend titles XI, XVIII, and XIX of the Social Security Act to lower prescription drug prices in the Medicare and Medicaid programs, to improve transparency related to pharmaceutical prices and transactions, to lower patients' out-of-pocket costs, and to ensure accountability to taxpayers, and for other purposes. HR 5304 PBM Transparency in Prescription Drug Cost Act - To amend t… HOUSE OF REPRESENTATIVES,SENATE   34000 0 0 2020-07-10T12:21:58.880000-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);