lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where filing_uuid = "06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15" sorted by filing_year descending
This data as json, CSV (advanced)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3480093 | SQUIRE PATTON BOGGS 06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15 | Q4 | SQUIRE PATTON BOGGS | 30906 | AMERICA'S POISON CENTERS (APC) | 2025 | fourth_quarter | BUD | Issues relating to Poison Control Centers fiscal year 2026 appropriations; issues related to the implementation of the Poison Control Centers Reauthorization Act of 2024; issues related to the Pandemic and All Hazards Preparedness Act (PAHPA). | Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2026-01-09T10:57:50-05:00 |
| 3480094 | SQUIRE PATTON BOGGS 06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15 | Q4 | SQUIRE PATTON BOGGS | 30906 | AMERICA'S POISON CENTERS (APC) | 2025 | fourth_quarter | TEC | Issues related to the improper routing of calls to poison centers. | Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2026-01-09T10:57:50-05:00 |
| 3752160 | SQUIRE PATTON BOGGS 06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15 | Q4 | SQUIRE PATTON BOGGS | 30906 | AMERICA'S POISON CENTERS (APC) | 2025 | fourth_quarter | BUD | Issues relating to Poison Control Centers fiscal year 2026 appropriations; issues related to the implementation of the Poison Control Centers Reauthorization Act of 2024; issues related to the Pandemic and All Hazards Preparedness Act (PAHPA). | Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2026-01-09T10:57:50-05:00 |
| 3752161 | SQUIRE PATTON BOGGS 06c5621e-4dc8-4d4a-ba7b-1dd8aa0f1b15 | Q4 | SQUIRE PATTON BOGGS | 30906 | AMERICA'S POISON CENTERS (APC) | 2025 | fourth_quarter | TEC | Issues related to the improper routing of calls to poison centers. | Federal Communications Commission (FCC),Health & Human Services, Dept of (HHS),HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2026-01-09T10:57:50-05: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,
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);