lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
10 rows where filing_uuid = "a71b8a36-e494-4af2-bfea-537e64212bef" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, received_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3206677 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | BUD | S. 2226, National Defense Authorization Act for Fiscal Year 2024, provisions relating to extension of sequester H.R.7463, Extension of Continuing Appropriations and Other Matters Act, 2024, provisions relating to Medicare payments, and Conrad 30 program H.R. 4366, Consolidated Appropriations Act, 2024, provisions relating to mitigating physician payment cuts, and APM bonus extension H.R. 7688, Accelerating Access to Dementia and Alzheimers Provider Training (AADAPT) Act, all provisions FY 2025 Labor, Health and Human Services, Education and Related Agencies Appropriations, provisions related to CDC funding for Surveillance for Emerging Threats to Mothers and Babies Network (SET-NET); Title V Maternal and Child Health Block Grant funding H. Res. 1102, Further Consolidated Appropriations Act, 2024, provisions related to Conrad 30 program Childrens Hospitals Graduate Medical Education (CHGME) program/FY 2025 funding FY 2025 Appropriations budget, provisions relating to funding increase for American Indian and Alaska Natives' health care improvements | HOUSE OF REPRESENTATIVES,SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206678 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | EDU | H.R. 3046, Medical Student Education Authorization Act of 2023, all provisions S. 1403, Medical Student Education Authorization Act of 2023, all provisions H.R. 1202, Resident Education Deferred Interest (REDI) Act, all provisions S. 704, Resident Education Deferred Interest (REDI) Act, all provisions H.R. 2761, Specialty Physicians Advancing Rural Care (SPARC) Act, all provisions S. 705, Specialty Physicians Advancing Rural Care (SPARC) Act, all provisions H.R. 7258, Community Training, Education, and Access for Medical Students (Community TEAMS) Act of 2024, all provisions S. 3968, Community Training, Education, and Access for Medical Students (Community TEAMS) Act of 2024, all provisions S. 3022, IHS Workforce Parity Act of 2023, all provisions H.R. 2389, Resident Physician Shortage Reduction Act of 2023, all provisions S. 1302, Resident Physician Shortage Reduction Act of 2023, all provisions H.R. 751, Fair Access In Residency (FAIR) Act, all provisions H.R. 7050, Substance Use Disorder Workforce Act, all provisions H.R. 4829, Physical Therapist Workforce and Patient Access Act of 2023, provisions relating to National Health Service Corps Loan Repayment program H.R. 7725, To amend the Higher Education Act of 1965 to prohibit graduate medical schools from receiving Federal financial assistance if such schools adopt certain policies and requirements relating to diversity, equity, and inclusion, all provisions S. 4115, Embracing anti-Discrimination, Unbiased Curricula, and Advancing Truth in Education (EDUCATE) Act, all provisions H.R. 8318, Tribal Tax and Investment Reform Act of 2024, provisions relating to student loans H.R. 8235, Rural Physician Workforce Preservation Act, provisions relating to GME H.R. 7855, Rural Residency Planning and Development Act of 2024, all provisions Opioid Workforce Act/draft IHS Health Professions Tax Fairness Act/draft Childrens Hospitals Graduate Medical Education (CHGME) program/FY 2025 funding Pathways to Practice GME cap flexibility Rural health care | HOUSE OF REPRESENTATIVES,SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206679 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | HCR | H.R. 618, Improving Access to Workers Compensation for Injured Federal Workers Act, all provisions S. 131, Improving Access to Workers Compensation for Injured Federal Workers Act of 2023, all provisions H.R. 2923, Living Donor Protection Act of 2023, all provisions S. 1384, Living Donor Protection Act of 2023, all provisions H.R. 1359, Modernizing Opioid Treatment Access Act, all provisions S. 644, Modernizing Opioid Treatment Access Act, all provisions H.R. 6487, No Fees for EFTs Act, all provisions S. 3805, No Fees for EFTs Act, all provisions H.R. 766, Dr. Michael C. Burgess Preventive Health Savings Act, all provisions S. 114, Dr. Michael C. Burgess Preventive Health Savings Act, all provisions H.R. 2630, Safe Step Act, all provisions S. 652, Safe Step Act, all provisions S. 2840, Bipartisan Primary Care and Health Workforce Act, all provisions S. 113, Prescription Pricing for the People Act of 2023, all provisions H.R. 7153, Dr. Lorna Breen Health Care Provider Protection Reauthorization Act, al provisions S. 3679, Dr. Lorna Breen Health Care Provider Protection Reauthorization Act, all provisions H.R. 830, Help Ensure Lower Patient (HELP) Copays Act, all provisions S. 1375, Help Ensure Lower Patient (HELP) Copays Act, all provisions S. 127, Pharmacy Benefit Manager Transparency Act of 2023, all provisions H.R. 8325, Physician and Patient Safety Act, all provisions S. 4278, Physician and Patient Safety Act, all provisions H.R. 6475, Health Disparity Zones Act of 2023, all provisions H.R. 3417, Facilitating Accountability In Reimbursements (FAIR) Act, all provisions H.R. 7931, Preserving Emergency Access in Key Sites (PEAKS) Act, all provisions H.R. 8245, Rural Hospital Stabilization Act, all provisions H.R. 8246, Second Chances for Rural Hospitals Act, all provisions H.R. 6230, Doctor Knows Best Act of 2023, all provisions S. 4349, A bill to require private health plans to provide for secure electronic transmission of prior authorization requests for prescription drugs, all provisions H.R. 6881, AI Foundati… | Drug Enforcement Administration (DEA),Federal Trade Commission (FTC),Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Office of Natl Drug Control Policy (NDCP),SENATE,Substance Abuse & Mental Health Services Administration (SAMHSA) | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206680 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | IMM | H.R. 4942, Conrad State 30 and Physician Access Reauthorization Act, all provisions S. 665, Conrad State 30 and Physician Access Reauthorization Act, all provisions H.R. 6205, Healthcare Workforce Resilience Act, all provisions S. 3211, Healthcare Workforce Resilience Act, all provisions H.R. 4875, Doctors in our Borders Act, all provisions H.R. 6980, Directing Our Countrys Transfer Of Residency Slots (DOCTORS) Act, all provisions S. 2719, Directing Our Countrys Transfer Of Residency Slots (DOCTORS) Act, all provisions H.R. 6363, Further Continuing Appropriations and Other Extensions Act, 2024, provisions related to resident dual intent H.R. 7463, Extension of Continuing Appropriations and Other Matters Act, 2024, provisions relating to Conrad 30 program H. Res. 1102, Further Consolidated Appropriations Act, 2024, provisions related to Conrad 30 program | HOUSE OF REPRESENTATIVES,SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206681 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | LBR | Insurance market competition Health care consolidation/anticompetition | Federal Trade Commission (FTC),HOUSE OF REPRESENTATIVES | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206682 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | MMM | H.R. 6445, Medicare Audiology Access Improvement Act of 2023, all provisions S. 2377, Medicare Audiology Access Improvement Act of 2023, all provisions H.R. 1610, Chiropractic Medicare Coverage Modernization Act of 2023, all provisions S. 799, Chiropractic Medicare Coverage Modernization Act of 2023, all provisions H.R. 4189, Creating Opportunities Now for Necessary and Effective Care Technologies (CONNECT) for Health Act of 2023, all provisions S. 2016, Creating Opportunities Now for Necessary and Effective Care Technologies (CONNECT) for Health Act of 2023, all provisions S. 712, Connected MOM Act, all provisions H.R. 5066, Tech to Save Moms Act, all provisions H.R. 1770, Equitable Community Access to Pharmacist Services Act, all provisions S. 2477, Equitable Community Access to Pharmacist Services Act, all provisions H.R. 751, Fair Access In Residency (FAIR) Act, all provisions H.R. 4968, Getting Over Lengthy Delays in Care As Required by Doctors (GOLD CARD) Act of 2023 H.R. 2713, Improving Care and Access to Nurses (ICAN) Act, all provisions S. 2418, Improving Care and Access to Nurses (ICAN) Act, all provisions H.R. 2583, Increasing Access to Quality Cardiac Rehabilitation Care Act of 2023, all provisions H.R. 977, Patient Access to Higher Quality Health Care Act of 2023, all provisions S. 470, Patient Access to Higher Quality Health Care Act of 2023, all provisions H.R. 2389, Resident Physician Shortage Reduction Act of 2023, all provisions S. 1302, Resident Physician Shortage Reduction Act of 2023, all provisions H.R. 7050, Substance Use Disorder Workforce Act, all provisions H.R. 7623, Telehealth Modernization Act of 2024, all provisions S. 3967, Telehealth Modernization Act, all provisions H.R. 2474, Strengthening Medicare for Patients and Providers Act, all provisions H.R. 6371, Provider Reimbursement Stability Act of 2023, all provisions H.R. 6545, Physician Fee Schedule Update and Improvements Act, all provisions H.R. 5378, Lower Costs, More Transparency Act, all provisions H.R. 6683, Preserving Senio… | Centers For Medicare and Medicaid Services (CMS),Government Accountability Office (GAO),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,Medicare Payment Advisory Commission (MedPAC),SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206683 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | TOB | Unauthorized e-cigarettes/enforcement of laws | Food & Drug Administration (FDA),Justice, Dept of (DOJ),U.S. Customs & Border Protection | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206684 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | TAX | H.R. 8318, Tribal Tax and Investment Reform Act of 2024, provisions relating to student loans IHS Health Professions Tax Fairness Act/drafts | HOUSE OF REPRESENTATIVES,SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206685 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | TOR | Medical malpractice | HOUSE OF REPRESENTATIVES | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 | |
| 3206686 | AMERICAN MEDICAL ASSOCIATION a71b8a36-e494-4af2-bfea-537e64212bef | Q2 | AMERICAN MEDICAL ASSOCIATION | 2877 | AMERICAN MEDICAL ASSOCIATION | 2024 | second_quarter | VET | S. 10, VA Clinician Appreciation, Recruitment, Education, Expansion, and Retention Support (CAREERS) Act of 2023, all provisions H.R. 3347, Protect Lifesaving Anesthesia Care for Veterans Act of 2023, all provisions S. 2070, Protect Lifesaving Anesthesia Care for Veterans Act of 2023, all provisions VA Supremacy Project | HOUSE OF REPRESENTATIVES,SENATE | 5120000 | 0 | 0 | 2024-07-19T15:40:45-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);