lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
9 rows where filing_uuid = "7dfdca4f-3981-4894-9dfa-e23dfaf93408" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3069351 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | MMM | HR 1691, Ensuring Patient Access to Critical Breakthrough Products Act; transitional coverage for emerging technologies (TCET) proposal Site neutrality payment proposals under Medicare Medicare Physician Fee Schedule reform telehealth reimbursement | HOUSE OF REPRESENTATIVES,SENATE | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069352 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | HCR | 3rd Party Service regulation Cybersecurity Right to Repair of medical devices Artificial Intelligence and medical devices Mandatory device shortage reporting proposals Reauthorization of the Pandemic and All Hazards Preparedness Act (PAHPA) EPA ethylene oxide (EtO) regulations under FIFRA and NESHAP review - device sterilization Application of ENERGY STAR program to medical imaging devices Efforts to improve access to healthcare for underserved communities and activities to enhance maternal healthcare | Food & Drug Administration (FDA),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE,Vice President of the U.S. | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069353 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | BUD | FY 2024 Veterans Affairs Appropriations, in general with some focus on telehealth provisions FY 2024 Defense Department Appropriations 2024 National Defense Authorization Act including issues related to RATE and low helium MRIs | HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069354 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | VET | U.S. Department of Veteran Affairs' acquisition process Telehealth for veterans Tele-critical care for Dept of Defense Nationwide expansion of tele-critical care program Digital Pathology RATE (Rapid Analysis of Threat Exposure) Recall related to Continuous Positive Air Pressure (CPAP) devices | HOUSE OF REPRESENTATIVES,SENATE,Veterans Affairs, Dept of (VA) | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069355 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | TRD | Supply chain policy Semiconductor chip shortage and related 2021 Executive Orders on Federal procurement Data Transfer/Privacy (U.S.-EU Trade and Technology Council) and Localization China tariffs | Commerce, Dept of (DOC),HOUSE OF REPRESENTATIVES,SENATE,White House Office | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069356 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | DEF | Telehealth in DOD Issues related to COVID-19 pandemic response and other infectious diseases | Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069357 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | MAN | Issues related to circular economy Buy America Act Sustainability in connection with Circular Economy | Commerce, Dept of (DOC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069358 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | CHM | EPA ethylene oxide (EtO) regulations under FIFRA and NESHAP review - device sterilization | HOUSE OF REPRESENTATIVES | 570000 | 0 | 0 | 2023-10-20T09:53:25-04:00 | |
| 3069359 | PHILIPS HOLDING USA, INC. 7dfdca4f-3981-4894-9dfa-e23dfaf93408 | Q3 | PHILIPS HOLDING USA, INC. | 31417 | PHILIPS HOLDING USA INC. | 2023 | third_quarter | ENG | EPA proposal to extend Energy Star program to medical devices | HOUSE OF REPRESENTATIVES | 570000 | 0 | 0 | 2023-10-20T09:53:25-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);