home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3d77222f-f1e7-4b41-811b-90070fd8c447

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
3d77222f-f1e7-4b41-811b-90070fd8c447 Q1 32362 PUBLIC CITIZEN 140490 PUBLIC CITIZEN 2024 first_quarter 2024-04-02T10:46:25-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3d77222f-f1e7-4b41-811b-90070fd8c447/", "filing_uuid": "3d77222f-f1e7-4b41-811b-90070fd8c447", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2024, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3d77222f-f1e7-4b41-811b-90070fd8c447/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "88000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Noyan Eyigor", "dt_posted": "2024-04-02T10:46:25-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.senate.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-01-15T12:37:43.672096-05:00"}, "client": {"id": 140490, "url": "https://lda.senate.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": "PHA", "general_issue_code_display": "Pharmacy", "description": "march-in and other Bayh-Dole rights, Prescription Drug Affordability and Access Act, TRACK Act, Medicare drug price negotiation delay periods and exemptions; patent thicket reform, PREVAIL Act, Affordable and Safe Prescription Drug Importation Act, HR5539/S3131 ORPHAN Cures Act; HR5547/S476 Maintaining Investments in New Innovation Act; HR7174, PASTEUR Act, patent thicket reform, biosimilar interchangeability; Medicare drug price negotiation delay periods, expansion to commercial market, march-in and other licensing rights; Pandemic Accord access provisions, Prescription Drug Affordability and Access Act, Pandemic Accord access provisions; public pharmaceutical manufacturing.", "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": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 139, "name": "Natl Institutes of Health (NIH)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "crypto legislation, opposing Grayscale petition, Security markets bills, banker pay reform, Dodd-Frank Sec. 956, FSOC-related issues including banker pay reform and artificial intelligence, HR 2799, securities deregulation, cryptocurrency regulation, artificial intelligence guardrails, House financial services bills re securities markets, securities markets.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 56333, "prefix": "mr", "prefix_display": "MR.", "first_name": "BARTLETT", "nickname": null, "middle_name": null, "last_name": "NAYLOR", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 62, "name": "Federal Reserve System"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Bright Lines Project - clarifying the rules for nonprofit organizations, SHINE Act, last-minute disclosures by outside electioneering groups., financial transaction tax, Direct File, IRS funding, End Tax Breaks for Dark Money.", "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}, {"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"}, {"id": 41, "name": "Treasury, Dept of"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Deepfakes in electioneering communications (HR 5586, S 2770), ETHICS Act (HR 2678, S 1171), Restoring Integrity in America's Elections Act (reforming the FEC) and EMPOWER Act (public financing of presidential elections), Financial Regulators Revolving Door Enforcement Act, Judicial Conflict of Interest Act, Revolving Door in Financial Services Act, Protecting Democracy from Deceptive AI Act (S. 2770), Deepfakes Accountability Act (HR5586), Bright Lines Project, Nonprofit Transparency Act, Transparency in Government Act, FOIA reform, open government initiatives/ National Action Plan, OGP National Action Plan.", "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}, {"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": 65, "name": "General Services Administration (GSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R.3421 & S.1655 - Medicare for All, Health Care AI, Medicare Advantage.", "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": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "H.R. 357, SMART Act, ALERT Act, Information QualityAssurance Act of 2023 (against all four bills. Regulatory reform. Stop Corporate Capture Act (H.R. 1507), Information Quality Assurance Act of 2024 (H.R. 7219), Comment Integrity and Management Act of 2024 (H.R. 7528), Modernizing Retrospective Regulatory Review Act (H.R. 7533). H.R. 7532, the Federal AI Governance and Transparency Act. Prove It Act of 2024 (H.R. 7198), Children sleep products and generally products, Product safety, Forced arbitration in nursing home contracts, AI labeling bill.", "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": 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": 145661, "prefix": null, "prefix_display": null, "first_name": "RICHARD", "nickname": null, "middle_name": null, "last_name": "ANTHONY MARQUEZ", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Anti-ESG House Bills with House Staff, Corporate Lobbying Disclosure, lobbying disclosures for publicly traded companies, strengthening corporate disclosure, corporate lobby disclosure.", "foreign_entity_issues": "", "lobbyists": [{"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": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "heat stress bill, whistleblower contractor bill, heat stress (AG outreach).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 74667, "prefix": null, "prefix_display": null, "first_name": "JULEY", "nickname": null, "middle_name": null, "last_name": "FULCHER", "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": "CIV", "general_issue_code_display": "Civil Rights/Civil Liberties", "description": "arbitration in Healthcare.", "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"}]}, {"general_issue_code": "COM", "general_issue_code_display": "Communications/Broadcasting/Radio/TV", "description": "online safety for children.", "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": 1, "name": "SENATE"}]}, {"general_issue_code": "POS", "general_issue_code_display": "Postal", "description": "USPS Board of Governor nominations", "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": 99, "name": "U.S. Postal Service (USPS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 32102 DC DC US US   0 0           88000.0

Links from other tables

  • 11 rows from filing_uuid in lobbying_activities
  • 10 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.546ms · Privacy