home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported is_amendment is_no_activity is_termination raw_json
ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2 Q3 11674 DAVIS & HARMAN LLP 116197 TRANSAMERICA LIFE INSURANCE COMPANY 2022 third_quarter 2022-10-18T12:28:13-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2/", "filing_uuid": "ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2022, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ecf78ead-e9fd-4aa6-b795-cc5cae79c7e2/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Kent A. Mason", "dt_posted": "2022-10-18T12:28:13-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1455 Pennsylvania Avenue, N. W.", "registrant_address_2": "Suite 1200", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 11674, "url": "https://lda.senate.gov/api/v1/registrants/11674/", "house_registrant_id": 31318, "name": "DAVIS & HARMAN LLP", "description": "Law Firm.", "address_1": "1455 Pennsylvania Avenue, N. W.", "address_2": "Suite 1200", "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": "TAYLOR HOWARD", "contact_telephone": "+1 202-662-2282", "dt_updated": "2026-01-30T12:13:03.011579-05:00"}, "client": {"id": 116197, "url": "https://lda.senate.gov/api/v1/clients/116197/", "client_id": 618, "name": "TRANSAMERICA LIFE INSURANCE COMPANY", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "IA", "state_display": "Iowa", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "Proposals related to retirement plans for small business. Proposals to reform the multiple employer plan rules. Proposals related to ABLE accounts. Issues related to defined benefit plan funding. Guidance related to nondiscrimination rules for defined contribution plan annuity investment products. Issues related to tax incentives for retirement savings. Issues related to income investment options. Proposals related to electronic disclosure. Plan consolidation. Issues related to PEP trustees. Issues related to audits of groups of plans. Proposals to reform 403(b) plan investments. Proposals to amend the Internal Revenue Code and ERISA to avoid duplicative annual reporting, including H.R. 982 and S. 354. S. 1770, Retirement Security and Savings Act. S. 1011, to modify the requirements for multiple employer plans, and for other purposes (116th Congress). S. 321, Retirement Security Act. H.R. 4523, the Automatic Retirement Plan Act (115th Congress). H.R. 4637, the SAVE Act (115th Congress). H.R. 4610/S. 3759, RETIRE Act (115th Congress). Issues related to e-notarization. H.R. 2741, Public Service Retirement Fairness Act. S. 1625, Securing and Enabling Commerce Using Remote and Electronic Notarization Act. S. 1703, Improving Access to Retirement Savings. H.R. 2954, Securing a Strong Retirement Act. H.R. 8606, To defer the tax of certain sales of employer stock and reduce certain retirement-related excise taxes, and for other purposes (116th Congress). H.R. 423/H.R. 409, Emergency Pension Plan Relief Act. H.R. 1319, the American Rescue Plan Act. H.R. 5376, Build Back Better Act. H.R. 5891, Retirement Improvement and Savings Enhancement Act. H.R. 6912, Pooled Employer Plan Fix Act. H.R. 2741, Public Service Retirement Fairness Act of 2021. H.R. 7146/S. 1870, Enhancing Emergency and Retirement Savings Act. H.R. 7310, Protecting Americas Retirement Security Act. H.R. 6782/S. 3712, Auto Reenrollment Act. S. 4154, Simplifying Small Business Retirement Savings Act. S. 4153, Incentivizing Small Business Retirement Savings Act. S. 4808, Enhancing American Retirement Now (EARN) Act. S. 4353, RISE & SHINE Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41060, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": "A", "last_name": "MASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46347, "prefix": "ms", "prefix_display": "MS.", "first_name": "BARBARA", "nickname": null, "middle_name": "A.", "last_name": "PATE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62920, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": "L", "last_name": "GASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Representative Rush Holt", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Proposals related to retirement plans for small business. Proposals to reform the multiple employer plan rules. Proposals related to ABLE accounts. Issues related to defined benefit plan funding. Guidance related to nondiscrimination rules for defined contribution plan annuity investment products. Issues related to tax incentives for retirement savings. Issues related to income investment options. Proposals related to electronic disclosure. Plan consolidation. Issues related to PEP trustees. Issues related to audits of groups of plans. Proposals to reform 403(b) plan investments. Proposals to amend the Internal Revenue Code and ERISA to avoid duplicative annual reporting, including H.R. 982 and S. 354. S. 1770, Retirement Security and Savings Act. S. 1011, to modify the requirements for multiple employer plans, and for other purposes (116th Congress). S. 321, Retirement Security Act. H.R. 4523, the Automatic Retirement Plan Act (115th Congress). H.R. 4637, the SAVE Act (115th Congress). H.R. 4610/S. 3759, RETIRE Act (115th Congress). Issues related to e-notarization. H.R. 2741, Public Service Retirement Fairness Act. S. 1625, Securing and Enabling Commerce Using Remote and Electronic Notarization Act. S. 1703, Improving Access to Retirement Savings. H.R. 2954, Securing a Strong Retirement Act. H.R. 8606, To defer the tax of certain sales of employer stock and reduce certain retirement-related excise taxes, and for other purposes (116th Congress). H.R. 423/H.R. 409, Emergency Pension Plan Relief Act. H.R. 1319, the American Rescue Plan Act. H.R. 5376, Build Back Better Act. H.R. 5891, Retirement Improvement and Savings Enhancement Act. H.R. 6912, Pooled Employer Plan Fix Act. H.R. 2741, Public Service Retirement Fairness Act of 2021. H.R. 7146/S. 1870, Enhancing Emergency and Retirement Savings Act. H.R. 7310, Protecting Americas Retirement Security Act. H.R. 6782/S. 3712, Auto Reenrollment Act. S. 4154, Simplifying Small Business Retirement Savings Act. S. 4153, Incentivizing Small Business Retirement Savings Act. S. 4808, Enhancing American Retirement Now (EARN) Act. S. 4353, RISE & SHINE Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41060, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": "A", "last_name": "MASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46347, "prefix": "ms", "prefix_display": "MS.", "first_name": "BARBARA", "nickname": null, "middle_name": "A.", "last_name": "PATE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62920, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": "L", "last_name": "GASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Representative Rush Holt", "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": "H.R. 2954, Securing a Strong Retirement Act. S. 4808, Enhancing American Retirement Now (EARN) Act. Proposals to reform 403(b) plan investments.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 41060, "prefix": null, "prefix_display": null, "first_name": "KENT", "nickname": null, "middle_name": "A", "last_name": "MASON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 46347, "prefix": "ms", "prefix_display": "MS.", "first_name": "BARBARA", "nickname": null, "middle_name": "A.", "last_name": "PATE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 62920, "prefix": null, "prefix_display": null, "first_name": "CHRIS", "nickname": null, "middle_name": "L", "last_name": "GASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Rep. Rush Holt", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.108ms