lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5 rows where filing_uuid = "d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3062409 | PRINCIPAL FINANCIAL GROUP d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5 | Q3 | PRINCIPAL FINANCIAL GROUP | 32178 | PRINCIPAL FINANCIAL GROUP | 2023 | third_quarter | TAX | No Bill Number: Issues pertaining to Paid Family and Medical Leave Treaty Document 112-8: bilateral tax treaty with Chile HR 5707 Secure Family Futures Act Summary is in progress. To amend the Internal Revenue Code of 1986 to exclude debt held by certain insurance companies from capital assets. | HOUSE OF REPRESENTATIVES,SENATE | 438000 | 0 | 0 | 2023-10-19T13:51:20-04:00 | |
| 3062410 | PRINCIPAL FINANCIAL GROUP d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5 | Q3 | PRINCIPAL FINANCIAL GROUP | 32178 | PRINCIPAL FINANCIAL GROUP | 2023 | third_quarter | FIN | H.R. 1165 Data Privacy Act of 2023: Summary in progress H.R. 3603: account parity relating to the ability for 403(b) plans to invest in collective investment trusts H.R. 2799 Expanding Access to Capital Act: Summary in progress H.R. 1807 Improving Disclosure for Investors Act of 2023. This bill requires the Securities and Exchange Commission (SEC) to propose and finalize rules to allow entities to deliver regulatory documents to investors electronically. The SEC must establish a mechanism for investors to opt out of electronic delivery and receive paper documents instead. If the SEC does not finalize rules within one year after enactment, the bill allows for electronic delivery of these documents. | HOUSE OF REPRESENTATIVES,SENATE | 438000 | 0 | 0 | 2023-10-19T13:51:20-04:00 | |
| 3062411 | PRINCIPAL FINANCIAL GROUP d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5 | Q3 | PRINCIPAL FINANCIAL GROUP | 32178 | PRINCIPAL FINANCIAL GROUP | 2023 | third_quarter | RET | HR 5339 RETIRE Act: Summary is in progress. To amend the Employee Retirement Income Security Act of 1974 to specify requirements concerning the consideration of pecuniary and non-pecuniary factors, and for other purposes. HR 5337 Retirement Proxy Protection Act: Summary is in progress. To amend the Employee Retirement Income Security Act of 1974 to clarify the application of prudence and exclusive purpose duties to the exercise of shareholder rights. HR 5338 No Discrimination In My Benefits Act: Summary is in progress. To amend the Employee Retirement Income Security Act of 1974 to establish that fiduciaries must act with prudence and loyalty when selecting service providers for pension plans. HR 5340 Providing Complete Information to Retirement Investors Act: Summary is in progress. To amend the Employee Retirement Income Security Act of 1974 to ensure that pension plans provide notice to participants and beneficiaries on risks associated with certain investments, and for other purposes. HR 3063 Retirement Fairness for Charities and Educational Institutions Act: Summary is in progress. To amend the Federal securities laws to enhance 403(b) plans, and for other purposes. | HOUSE OF REPRESENTATIVES,SENATE | 438000 | 0 | 0 | 2023-10-19T13:51:20-04:00 | |
| 3062412 | PRINCIPAL FINANCIAL GROUP d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5 | Q3 | PRINCIPAL FINANCIAL GROUP | 32178 | PRINCIPAL FINANCIAL GROUP | 2023 | third_quarter | INS | S 2771 Increasing Access to Dental Insurance Act: Summary is in progress. To allow additional individuals to enroll in standalone dental plans offered through Federal Exchanges. | HOUSE OF REPRESENTATIVES,SENATE | 438000 | 0 | 0 | 2023-10-19T13:51:20-04:00 | |
| 3062413 | PRINCIPAL FINANCIAL GROUP d5b0dcab-579c-4fcb-9347-e2ca9ca4cab5 | Q3 | PRINCIPAL FINANCIAL GROUP | 32178 | PRINCIPAL FINANCIAL GROUP | 2023 | third_quarter | GOV | S 1212 Securing and Enabling Commerce Using Remote and Electronic Notarization Act: Summary in progress. To authorize notaries public to perform, and to establish minimum standards for, electronic notarizations and remote notarizations that occur in or affect interstate commerce, to require any Federal court to recognize notarizations performed by a notarial officer of any State, to require any State to recognize notarizations performed by a notarial officer of any other State when the notarization was performed under or relates to a public Act, record, or judicial proceeding of the notarial officers State or when the notarization occurs in or affects interstate commerce, and for other purposes. | HOUSE OF REPRESENTATIVES,SENATE | 438000 | 0 | 0 | 2023-10-19T13:51:20-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);