lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where filing_uuid = "a5a862f2-419b-49e7-8db4-5d49d23a448a" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3142102 | AMERICAN SECURITIES ASSOCIATION a5a862f2-419b-49e7-8db4-5d49d23a448a | Q1 | AMERICAN SECURITIES ASSOCIATION | 401105885 | AMERICAN SECURITIES ASSOCIATION | 2024 | first_quarter | BAN | - S. 2230/H.R. 4551, Protecting Investors Personally Identifiable Information Act - Issues related to blockchain and cryptocurrency regulation - Issues related to the Financial Data Transparency Act (included as part of Public Law 117-263) | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 0 | 0 | 2024-04-11T16:19:44-04:00 |
| 3142103 | AMERICAN SECURITIES ASSOCIATION a5a862f2-419b-49e7-8db4-5d49d23a448a | Q1 | AMERICAN SECURITIES ASSOCIATION | 401105885 | AMERICAN SECURITIES ASSOCIATION | 2024 | first_quarter | LBR | - Issues related to Regulation Best Interest and fiduciary standards - Issues related to ESG investing in retirement plans (H.J. Res. 30; S.J. Res. 8) | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE | 0 | 0 | 2024-04-11T16:19:44-04:00 |
| 3142104 | AMERICAN SECURITIES ASSOCIATION a5a862f2-419b-49e7-8db4-5d49d23a448a | Q1 | AMERICAN SECURITIES ASSOCIATION | 401105885 | AMERICAN SECURITIES ASSOCIATION | 2024 | first_quarter | TAX | - Issues related to infrastructure investment - Issues related to public finance and municipal financing - H.R. 1837, Investing in Our Communities Act - H.R. 490, Federal Infrastructure Bank Act of 2023 | HOUSE OF REPRESENTATIVES,Labor, Dept of (DOL),Securities & Exchange Commission (SEC),SENATE | 0 | 0 | 2024-04-11T16:19:44-04:00 |
| 3142105 | AMERICAN SECURITIES ASSOCIATION a5a862f2-419b-49e7-8db4-5d49d23a448a | Q1 | AMERICAN SECURITIES ASSOCIATION | 401105885 | AMERICAN SECURITIES ASSOCIATION | 2024 | first_quarter | FIN | - Issues related to capital formation; Issues related to private client business lines, H.R. 2622/S. 2141 (legislation relating to MiFid II); Issues related to financial recordkeeping; Issues related to equity market structure and disclosures; Issues related to fixed income market structure, disclosure, and reporting times (MSRB Rule G-14; FINRA Rule 6730; MSRB Rule G-47); Issues related to Chinas impact on U.S. capital markets; SEC Rule 15c2-11; SEC Rule 15c2-12; Issues related to the Consolidated Audit Trail (CAT) and Consolidated Audit Information System (CAIS); Issues related to FINRAs remote inspections proposal; FINRAs remote supervisory location proposal; Issues related to conflicts of interest in securitizations; Issues related to shortening of settlement cycles; Issues related to proxy voting process; FINRA Rule 4210; Issues related to investor choice and ESG investing; Issues related to SEC rule proposal process and costs of proposals; Issues related to IPOs; H.R. 2812, Middle Market IPO Underwriting Cost Act; Issues related to the SECs predictive data analytics proposal; Issues related to Hart-Scott-Rodino pre-merger notifications; Issues related to SEC oversight; H.R. 7758, No China in Index Funds Act | HOUSE OF REPRESENTATIVES,Securities & Exchange Commission (SEC),SENATE,Treasury, Dept of | 0 | 0 | 2024-04-11T16:19:44-04:00 |
| 3142106 | AMERICAN SECURITIES ASSOCIATION a5a862f2-419b-49e7-8db4-5d49d23a448a | Q1 | AMERICAN SECURITIES ASSOCIATION | 401105885 | AMERICAN SECURITIES ASSOCIATION | 2024 | first_quarter | BUD | - S. 2309/H.R. 4664,Financial Services and General Government Appropriations Act and related House legislation, 2024 - H.R. 2882, Further Consolidated Appropriations Act, 2024 | HOUSE OF REPRESENTATIVES,SENATE | 0 | 0 | 2024-04-11T16:19:44-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,
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);