home / lobbying / lobbying_filings_raw

lobbying_filings_raw: cb8e54f1-276f-43bb-8e95-d9475058a213

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
cb8e54f1-276f-43bb-8e95-d9475058a213 Q1 20128 INVESTMENT COMPANY INSTITUTE 126471 INVESTMENT COMPANY INSTITUTE 2011 first_quarter 2011-04-20T09:39:11.653000-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/cb8e54f1-276f-43bb-8e95-d9475058a213/", "filing_uuid": "cb8e54f1-276f-43bb-8e95-d9475058a213", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2011, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/cb8e54f1-276f-43bb-8e95-d9475058a213/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "1247644.00", "expenses_method": "c", "expenses_method_display": "Method C - Reporting amounts under section 162(e) of the Internal Revenue Code", "posted_by_name": "Dean R Sackett III", "dt_posted": "2011-04-20T09:39:11.653000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1401 H STREET, NW", "registrant_address_2": "SUITE 1200", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 20128, "url": "https://lda.senate.gov/api/v1/registrants/20128/", "house_registrant_id": 31117, "name": "INVESTMENT COMPANY INSTITUTE", "description": null, "address_1": "1401 H STREET, NW", "address_2": "SUITE 1200", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "TOM QUAADMAN", "contact_telephone": "+1 202-326-5800", "dt_updated": "2026-02-26T10:42:07.633817-05:00"}, "client": {"id": 126471, "url": "https://lda.senate.gov/api/v1/clients/126471/", "client_id": 12, "name": "INVESTMENT COMPANY INSTITUTE", "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": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "S. 347 Public Employee Pension Transparency Act\nS. 557 Public Good IRA Rollover Act of 2011 (tax-free charitable distributions) H.R. 567 Public Employee Pension Transparency Act\nH.R. 1140 Senior Citizens Income Security Act of 2011 (eliminate mandatory IRA withdrawals)\nTax Deferral Limits for Retirement Plans", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5995, "prefix": null, "prefix_display": null, "first_name": "DEAN", "nickname": null, "middle_name": "R", "last_name": "SACKETT", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14072, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": "J", "last_name": "GUNAS", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53091, "prefix": null, "prefix_display": null, "first_name": "ALLEN", "nickname": null, "middle_name": null, "last_name": "HUFFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8143, "prefix": null, "prefix_display": null, "first_name": "DONALD", "nickname": null, "middle_name": "C", "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "S. 267 Lifetime Income Disclosure Act\nH.R. 677 Lifetime Income Disclosure Act DOL Fiduciary Definition\nTarget Date Funds\n401(k) Fee Disclosure\nSecurities Lending in Retirement Plans", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5995, "prefix": null, "prefix_display": null, "first_name": "DEAN", "nickname": null, "middle_name": "R", "last_name": "SACKETT", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14072, "prefix": null, "prefix_display": null, "first_name": "PETER", "nickname": null, "middle_name": "J", "last_name": "GUNAS", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53091, "prefix": null, "prefix_display": null, "first_name": "ALLEN", "nickname": null, "middle_name": null, "last_name": "HUFFMAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 44127, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": "L", "last_name": "HADLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8143, "prefix": null, "prefix_display": null, "first_name": "DONALD", "nickname": null, "middle_name": "C", "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "FY2012 Financial Services and General Government Appropriations (SEC funding)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5995, "prefix": null, "prefix_display": null, "first_name": "DEAN", "nickname": null, "middle_name": "R", "last_name": "SACKETT", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 8143, "prefix": null, "prefix_display": null, "first_name": "DONALD", "nickname": null, "middle_name": "C", "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "S. 366 Iran Transparency and Accountability Act of 2011\nH.R. 31 Fannie Mae and Freddie Mac Accountability and Transparency for Taxpayers Act H.R. 344 Fiscal Responsibility Effective Enforcement Act of 2011 (municipal bonds)\nH.R. 653 Financial Information Privacy Act of 2011\nH.R. 654 Do Not Track Me Online Act of 2011\nH.R. 740 Iran Transparency and Accountability Act of 2011\nH.R. 940 United States Covered Bond Act of 2011\nH.R. 1182 GSE Bailout Elimination and Taxpayer Protection Act\nH.R. 1221 Equity in Government Compensation Act (GSEs)\nH.R. 1222 GSE Subsidy Elimination Act\nH.R. 1223 GSE Credit Risk Equitable Treatment Act\nH.R. 1224 Portfolio Risk Reduction Act (GSEs)\nH.R. 1225 GSE Debt Issuance Approval Act\nH.R. 1226 GSE Mission Improvement Act\nH.R. 1227 GSE Risk and Activities Limitation Act\nMoney Market Mutual Funds", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 5995, "prefix": null, "prefix_display": null, "first_name": "DEAN", "nickname": null, "middle_name": "R", "last_name": "SACKETT", "suffix": "iii", "suffix_display": "III"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53809, "prefix": null, "prefix_display": null, "first_name": "NETONIS", "nickname": null, "middle_name": null, "last_name": "WYBENSINGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}, {"lobbyist": {"id": 8143, "prefix": null, "prefix_display": null, "first_name": "DONALD", "nickname": null, "middle_name": "C", "last_name": "AUERBACH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 38, "name": "Labor, Dept of (DOL)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31117 DC DC US US   0 0           1247644.0

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 6 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.625ms · Privacy