home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1ace8877-2fc9-42a8-8d5a-abd7a5d6352e

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
1ace8877-2fc9-42a8-8d5a-abd7a5d6352e Q1 32362 PUBLIC CITIZEN 140490 PUBLIC CITIZEN 2026 first_quarter 2026-04-09T15:06:58-04:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/1ace8877-2fc9-42a8-8d5a-abd7a5d6352e/", "filing_uuid": "1ace8877-2fc9-42a8-8d5a-abd7a5d6352e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2026, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.gov/filings/public/filing/1ace8877-2fc9-42a8-8d5a-abd7a5d6352e/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "100382.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Noyan Eyigor", "dt_posted": "2026-04-09T15:06:58-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1600 20TH STREET, NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20009", "registrant": {"id": 32362, "url": "https://lda.gov/api/v1/registrants/32362/", "house_registrant_id": 32102, "name": "PUBLIC CITIZEN", "description": null, "address_1": "1600 20TH STREET, NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20009", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "NOYAN EYIGOR", "contact_telephone": "+1 202-588-1000", "dt_updated": "2026-07-09T13:18:42.426797-04:00"}, "client": {"id": 140490, "url": "https://lda.gov/api/v1/clients/140490/", "client_id": 12, "name": "PUBLIC CITIZEN", "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-03"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "crypto legislation, credit card bills, small bank regulation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 143538, "prefix": "mr", "prefix_display": "MR.", "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "HOLMAN", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "Sen. Blumenthal re. Forced Arb/ Amtrak , Sen. Gillibrand re. Protecting Older Americans Act , Email Re. Fosters office re. Investor Choice Act , Forced Arbitration - Mass Arbitration , Roblox Article.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138383, "prefix": null, "prefix_display": null, "first_name": "MARTHA", "nickname": null, "middle_name": null, "last_name": "PEREZ-PEDEMONTI", "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": "CPI", "general_issue_code_display": "Computer Industry", "description": "AI Preemption Issue", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 151739, "prefix": null, "prefix_display": null, "first_name": "JOSHUA", "nickname": null, "middle_name": null, "last_name": "BRANCH", "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": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "SBA Office of Advocacy Deregulatory Initiative (Small Business Committee Minority Staff); Blast Oppo Email on HR 6622 to all House Judiciary Committee Member Staff; H.R. 6622 (Rep. Jayapal staff). H.R. 6544, Review Act of 2025; Regulatory reform meeting, H.J. Res. 140, Research on Office of Advocacy and Tariffs Shared with Senate and House Small Business Committee Staff (re DUMP Red Tape Act HR 4305),Standing Meeting with HSGAC Minority Staff (1.0); Draft Letter to Senate on H.J. Res. 140, Senator Klobuchar re. Product Safety , Meeting with HSGAC Minority Staff , EXPERTS Act , Rep. Lee Staff (EXPERTS Act, H.R. 6145; Dump Red Tape Act H.R. 4305, Midnight Rules Relief Act H.R. 77, Small Business Regulatory Reduction Act, H.R. 2965), Rep. Gottheimer (EXPERTS H.R. 6145), Rep. Min (EXPERTS H.R. 6145), Call with Jacob Press, Small Bus Minority, Supporting New Businesses Act (S. 1608), EXPERTS Act (HR 6145) Dump Red Tape Act (HR 4305), REINS Act (HR 142), Midnight Rules Relief Act )(HR 77) (Rep. Mcdonald Rivet), Standing Meeting with Senate HSGAC Staff (discussed independent agency reforms).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138628, "prefix": "ms", "prefix_display": "MS.", "first_name": "ELIZABETH", "nickname": null, "middle_name": null, "last_name": "SKERRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 151740, "prefix": null, "prefix_display": null, "first_name": "KATHERINE", "nickname": null, "middle_name": null, "last_name": "TRACY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 138383, "prefix": null, "prefix_display": null, "first_name": "MARTHA", "nickname": null, "middle_name": null, "last_name": "PEREZ-PEDEMONTI", "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": "Sen. Bennet Crypto Bill/Preemption , Communications opposing Public Company Advisory Committee Act (H.R. 6967). Communications supporting bill to oppose removal of elected DC Attorney General (H.R. 5179).,", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138383, "prefix": null, "prefix_display": null, "first_name": "MARTHA", "nickname": null, "middle_name": null, "last_name": "PEREZ-PEDEMONTI", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144141, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "GOLINGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "H.R.6622, Sunshine for Regulatory Decrees and Settlements Act\", Congressional stock trading ban (HR5106), Democratic leadership bill on stock trading by Congress and the executive branch (No number yet), Cap credit card late fees (No number yet), Honest Act (S1879), Restore Trust in Congress Act (HR 5106), Restore Trust in Government Act (HR6731), Supreme Court ethics and term limits (S1814), Congressional stock trading ban (HR5106, HR6731, HR7008), DISCLOSE Act of 2026 (No number yet), Expand personal financial disclosure requirements (No number yet), Johnson amendment on political activities by nonprofit organizations (No bill yet), DISCLOSE Act (No numbers yet), H.R. 6967, the Public Company Advisory Committee Act, Legislation to prevent government officials from enriching themselves through lawsuit settlements, Potential anti-corruption reforms, Prohibit congressional stock trading (HR5106, HR6731, HR7008), Prediction Markets insider trading by government officials (no number yet), SAVE Act (HR22) and SAVE 2.0 (No number yet), Supreme Court ethics and disclosure (HR3513, S1814), FOIA Clarification Act, congressional stock trading (HR 5106, 6731 and 7008); and on the Democratic House ethics package (No number yet), Ban political betting on prediction market platforms (No number yet),Congressional stock trading (HR5106, HR6731, HR7008), DISCLOSE Act (S3391,HR7802), End Congressional Stock Trading (HR 5106, HR6731, HR7008), End Prediction Markets Corruption Act (S4017),SAVE America Act (S3752, HR7296).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 143538, "prefix": "mr", "prefix_display": "MR.", "first_name": "CRAIG", "nickname": null, "middle_name": null, "last_name": "HOLMAN", "suffix": "phd", "suffix_display": "PHD"}, "covered_position": null, "new": false}, {"lobbyist": {"id": 144141, "prefix": null, "prefix_display": null, "first_name": "JONATHAN", "nickname": null, "middle_name": null, "last_name": "GOLINGER", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R.3069 & S.1506 - Medicare for All", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66133, "prefix": null, "prefix_display": null, "first_name": "EAGAN", "nickname": null, "middle_name": null, "last_name": "KEMP", "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": "PHA", "general_issue_code_display": "Pharmacy", "description": "Medicare drug price negotiation improvement and expansion; EPIC Act (H.R. 1492 / S. 832), MINI Act (H.R.1672); Medicare drug price negotiation delay periods and exemptions; drug prices; NDAA & public drug and API manufacturing,S.2276, H.R.3269 (ETHIC Act).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66542, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "KNIEVEL", "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": "POS", "general_issue_code_display": "Postal", "description": "opposing privatization of the USPS", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Direct File Act of 2026, Disclosure of Tax Havens and Offshoring Act, Tax Excessive CEO Pay Act (S.2818/H.R. 5298), Curtailing Executive Overcompensation (CEO) Act (S. 3176/H.R. 6191), Billionaires Income Tax Act (S.2845/H.R.5427), Wall Street Tax Act (S.2127/H.R.4035), Equal Tax Act (H.R. 5336), AI tax issues, Ultra-Millionaire Tax Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 60196, "prefix": "ms", "prefix_display": "MS.", "first_name": "SUSAN", "nickname": null, "middle_name": "ELAINE", "last_name": "HARLEY", "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 32102 DC DC US US   0 0           100382.0

Links from other tables

  • 60 rows from filing_uuid in lobbying_activities
  • 54 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.468ms · Privacy