lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
1 row where filing_uuid = "cfb4fb1f-4e8c-4c7a-9ca7-8ea13b9a7128" and issue_code = "MMM" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3140827 | AMERICAN COLLEGE OF SURGEONS cfb4fb1f-4e8c-4c7a-9ca7-8ea13b9a7128 | Q1 | AMERICAN COLLEGE OF SURGEONS | 45312 | AMERICAN COLLEGE OF SURGEONS | 2024 | first_quarter | MMM | S. 2333 - Pandemic and All-Hazards Preparedness and Response Act H.R. 4420 - The Preparedness and Response Reauthorization Act H.R. 4421 - The Preparing for All Hazards and Pathogens Reauthorization Act H.R. 715/S. 494 - The Bipartisan Background Checks Act/Background Check Expansion Act S. 1140/H.R. 1781 - Ensuring Access to General Surgery Act H.R. 2416 - MISSION Zero Reauthorization S. 220/H.R. 731 - Workforce Mobility Act (Non-compete Legislation) S. 705/H.R. 2761 - The Specialty Physicians Advancing Rural Care (SPARC) Act S. 704/H.R. 1202 - The Resident Education Deferred Interest (REDI) Act S. 1653 - Prevent BLEEDing Act H.R. 2427 - Strengthening Medicare for Patients and Providers Act S. 2644 - Law Enforcement Sustaining Aid and Vital Emergency Resources (SAVER) Act H.R. 2474 - Strengthening Medicare for Patients and Providers Act H.R. 5213 - Reducing Medically Unnecessary Delays in Care H.R. 6487/S. 3805 - No Fees for EFTS H.R. 6960/S. 3765 - Emergency Medical Services for Children Act Reauthorization S. 3679/H.R.7153 - Dr. Lorna Breen Health Care Provider Protection Reauthorization Act S. RES. 567 - Resolution for Health Workforce Well-Being Day of Awareness H.R. 4366 - Consolidated Appropriations Act, 2024 MACRA reforms through MIPS e-prescribing Medicare Physician Fee Schedule CMS Quality Payment Program (QPP) Proposed Rule Safe opioid disposal policy Bilateral Exchange Visa Issues/Visas for physician educational and cultural exchange (Conrad-30 Waiver Program) Medicare Price Transparency S. 1447 - The Bipartisan Solution to Cyclical Violence Act H.R. 2819 - Good Samaritan Health Professionals Act Labor HHS Appropriations Medicare Physician Payment Cuts AI Taskforce Neglected Surgical Conditions Pharmacy benefit management reform Age Friendly Hospital Measure in IQR program Stop the Bleed program Cancer Advocacy Agenda Trauma Advocacy Agenda Workforce Advocacy Agenda National Trauma and Emergency Preparedness System (NTEPs) Administrative Burden/Prior Authorization Legislation Physician Burnout and Wel… | Centers For Medicare and Medicaid Services (CMS),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 210000 | 0 | 0 | 2024-04-09T09:03:00-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);