home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 348abb9e-4285-47b6-b77e-ff930e6fbcf7

Raw lobbying disclosure filings from the Senate Office of Public Records (SOPR). Each row is a single filing — registrations, quarterly reports, amendments, and terminations. Includes registrant and client names, reported income/expenses, filing period, and the full raw JSON from the API. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date is_amendment is_no_activity is_termination raw_json registrant_state registrant_country registrant_house_id client_state client_ppb_state client_country client_ppb_country client_general_description client_government_entity affiliated_org_count client_entity_id client_government_unit_id client_match_method client_match_confidence income_amount expense_amount
348abb9e-4285-47b6-b77e-ff930e6fbcf7 Q1 32178 PRINCIPAL FINANCIAL GROUP 140450 PRINCIPAL FINANCIAL GROUP 2025 first_quarter 2025-04-15T13:02:53-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/348abb9e-4285-47b6-b77e-ff930e6fbcf7/", "filing_uuid": "348abb9e-4285-47b6-b77e-ff930e6fbcf7", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2025, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/348abb9e-4285-47b6-b77e-ff930e6fbcf7/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "953000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Christopher D. Payne", "dt_posted": "2025-04-15T13:02:53-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "801 Pennsylvania Avenue, NW, Suite 420", "registrant_address_2": null, "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 32178, "url": "https://lda.gov/api/v1/registrants/32178/", "house_registrant_id": 31588, "name": "PRINCIPAL FINANCIAL GROUP", "description": "Insurance", "address_1": "801 Pennsylvania Avenue, NW, Suite 420", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CHRISTOPHER D. PAYNE", "contact_telephone": "+1 202-682-1280", "dt_updated": "2026-01-22T11:19:24.676458-05:00"}, "client": {"id": 140450, "url": "https://lda.gov/api/v1/clients/140450/", "client_id": 12, "name": "PRINCIPAL FINANCIAL GROUP", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2017-07-05"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR2547, S1335 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. HR996, S400 Paid Family and Medical Leave Tax Credit Extension and Enhancement Act: This bill modifies the employer tax credit for paid family and medical leave. Specifically, the bill (1) makes such credit permanent, (2) allows the credit in states or localities that either mandate or do not mandate paid family and medical leave, (3) allows employers to claim the credit for a portion of their paid family leave insurance premiums, (4) reduces the minimum employment period eligibility requirement, and (5) requires the Small Business Administration and the Internal Revenue Service to conduct targeted outreach to employers and other relevant parties regarding the availability and requirements of the credit.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55868, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHIRSTOPHER", "nickname": null, "middle_name": null, "last_name": "PAYNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66880, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SHIMP", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66863, "prefix": null, "prefix_display": null, "first_name": "LANCE", "nickname": null, "middle_name": null, "last_name": "SCHOENING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61205, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": "A", "last_name": "STANLEY NGUYEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 147378, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANNE", "nickname": null, "middle_name": "DAVEY", "last_name": "GLEASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "HR2441 Improving Disclosure for Investors Act of 2025. 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. HR1013, S424 Retirement Fairness for Charities and Educational Institutions Act: Summary is in progress. To amend the Federal securities laws to enhance403(b) plans, and for other purposes. HR2441 Improving Disclosure for Investors Act 2025. To provide for the electronic delivery of certain regulatory document required under the securities laws.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55868, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHIRSTOPHER", "nickname": null, "middle_name": null, "last_name": "PAYNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66880, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SHIMP", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66863, "prefix": null, "prefix_display": null, "first_name": "LANCE", "nickname": null, "middle_name": null, "last_name": "SCHOENING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61205, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": "A", "last_name": "STANLEY NGUYEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 147378, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANNE", "nickname": null, "middle_name": "DAVEY", "last_name": "GLEASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "HR1397 Increasing Access to Dental Insurance Act: Summary is in progress. To allow additional individuals to enroll in standalone dental plans offered through Federal Exchanges. HR 643 Federal Insurance Office Elimination Act. To eliminate the Federal Insurance Office of the Department of the Treasury, and for other purposes. S1164 Expand Dental Coverage on Federal Exchanges. A bill to allow additional individuals to enroll in standalone dental plans offered through Federal Exchanges.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 55868, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHIRSTOPHER", "nickname": null, "middle_name": null, "last_name": "PAYNE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66880, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SHIMP", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66863, "prefix": null, "prefix_display": null, "first_name": "LANCE", "nickname": null, "middle_name": null, "last_name": "SCHOENING", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61205, "prefix": null, "prefix_display": null, "first_name": "RACHEL", "nickname": null, "middle_name": "A", "last_name": "STANLEY NGUYEN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 147378, "prefix": "ms", "prefix_display": "MS.", "first_name": "ANNE", "nickname": null, "middle_name": "DAVEY", "last_name": "GLEASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31588 DC DC US US   0 0           953000.0

Links from other tables

  • 9 rows from filing_uuid in lobbying_activities
  • 15 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.289ms · Privacy