lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
3 rows where filing_year = 2026 and issue_code = "VET" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: registrant_name, registrant_id, client_name, specific_issues, is_termination, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3528200 | THE AMERICAN LEGION 42c29484-06cc-427e-bcb8-6a7eb6f0c7b4 | Q1 | THE AMERICAN LEGION | 2775 | AMERICAN LEGION | 2026 | first_quarter | VET | benefits, healthcare, employment, education, and more for veterans and their families | HOUSE OF REPRESENTATIVES,SENATE | 190000 | 0 | 0 | 2026-02-09T12:02:10-05:00 | |
| 3528213 | FORBES-TATE 973383eb-d736-4a24-af74-d1008d2059d8 | 1T | FORBES-TATE | 400976792 | EZ ACCESS | 2026 | first_quarter | VET | Issues related to tariffs, Medicare reimbursement, and expanding handicap accessibility at VA facilities. | HOUSE OF REPRESENTATIVES,SENATE | 30000 | 0 | 1 | 2026-02-11T21:27:34-05:00 | |
| 3528216 | THE AMERICAN LEGION effd8e2e-2a18-4540-8c52-ede82d0d39f3 | 1A | THE AMERICAN LEGION | 2775 | AMERICAN LEGION | 2026 | first_quarter | VET | benefits, healthcare, employment, education, and more for veterans and their families | HOUSE OF REPRESENTATIVES,SENATE | 190000 | 0 | 0 | 2026-02-12T07:52:57-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,
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);