home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 398dae9e-6021-4a17-bb52-dccd7c5f7be2

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
398dae9e-6021-4a17-bb52-dccd7c5f7be2 Q4 29403 CONSUMER HEALTHCARE PRODUCTS ASSOCIATION 134698 CONSUMER HEALTHCARE PRODUCTS ASSOCIATION 2025 fourth_quarter 2026-01-14T16:01:51-05:00 0 0 0 {"url": "https://lda.gov/api/v1/filings/398dae9e-6021-4a17-bb52-dccd7c5f7be2/", "filing_uuid": "398dae9e-6021-4a17-bb52-dccd7c5f7be2", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2025, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.gov/filings/public/filing/398dae9e-6021-4a17-bb52-dccd7c5f7be2/print/", "filing_document_content_type": "text/html", "income": "245484.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Marc Schloss", "dt_posted": "2026-01-14T16:01:51-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1625 Eye Street NW", "registrant_address_2": "Suite 600", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 29403, "url": "https://lda.gov/api/v1/registrants/29403/", "house_registrant_id": 31286, "name": "CONSUMER HEALTHCARE PRODUCTS ASSOCIATION", "description": null, "address_1": "1625 Eye Street NW", "address_2": "Suite 600", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "DAVID SPANGLER", "contact_telephone": "+1 202-429-9260", "dt_updated": "2026-01-15T16:02:44.446638-05:00"}, "client": {"id": 134698, "url": "https://lda.gov/api/v1/clients/134698/", "client_id": 12, "name": "CONSUMER HEALTHCARE PRODUCTS ASSOCIATION", "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-08"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "S.2292 - Over-the-Counter Monograph Drug User Fee Amendments H.R.4273 - Over-the-Counter Monograph Drug User Fee Amendments S.355 - FDA Modernization Act 3.0 H.R.2821 - FDA Modernization Act 3.0 H.R.3686 - SAFE Sunscreen Standards Act H.R.1 - One Big Beautiful Bill Act H.R.5371 - Continuing Appropriations and Extensions Act, 2026 S.2491 - SAFE Sunscreen Standards Act S.2529 - A bill to increase the clarity and predictability of the process for developing applications for Rx-to-nonprescription switches (SMART OTC Act) H.R.6868 - To amend the Federal Food, Drug, and Cosmetic Act to direct the Secretary of Health and Human Services to apply the least burdensome appropriate means for supporting certain administrative order requests with respect to over-the-counter monograph drugs, and for other purposes. S.3122 - Better FDA Act of 2025 - Activity related to Acetaminophen use - Nonprescription Drug Product with an Additional Condition for Nonprescription Use Rule - The Dietary Supplement Regulatory Uniformity Act - legislation that would restore a national standard for dietary supplements. - Dietary Supplement Drug Preclusion - legislation intended to clarify ingredients that can be used in dietary supplements.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65083, "prefix": null, "prefix_display": null, "first_name": "MARC", "nickname": null, "middle_name": null, "last_name": "SCHLOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67610, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "CHARLES", "last_name": "SPANGLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 148255, "prefix": null, "prefix_display": null, "first_name": "JOLIE", "nickname": null, "middle_name": null, "last_name": "BROCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "H.R.4958 - GRAS Act - The Wastewater Infrastructure Pollution Prevention and Environmental Safety (WIPPES) Act - Fluoride and fluoridated water - Additive Ingredients in Drug Products - Over-the-Counter Tests - Pediatric Labeling", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65083, "prefix": null, "prefix_display": null, "first_name": "MARC", "nickname": null, "middle_name": null, "last_name": "SCHLOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67610, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "CHARLES", "last_name": "SPANGLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 148255, "prefix": null, "prefix_display": null, "first_name": "JOLIE", "nickname": null, "middle_name": null, "last_name": "BROCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 155, "name": "Drug Enforcement Administration (DEA)"}, {"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "- The SHOP SAFE Act - Advocacy to protect funding for the Office of the Intellectual Property Enforcement Coordinator (IPEC) and to advocate for an IPEC appointment before the end of the year.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65083, "prefix": null, "prefix_display": null, "first_name": "MARC", "nickname": null, "middle_name": null, "last_name": "SCHLOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67610, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "CHARLES", "last_name": "SPANGLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 148255, "prefix": null, "prefix_display": null, "first_name": "JOLIE", "nickname": null, "middle_name": null, "last_name": "BROCHIN", "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": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "- H.R. 1219, Oral Health Products Inclusion Act - Pharmaceutical Tariffs - HSA/FSA Treatment for Dietary Supplements - Modernization of the Dietary Safety, Health and Education Act (DSHEA) - Regulation of Cannabidiol (CBD)", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65083, "prefix": null, "prefix_display": null, "first_name": "MARC", "nickname": null, "middle_name": null, "last_name": "SCHLOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67610, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "CHARLES", "last_name": "SPANGLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 148255, "prefix": null, "prefix_display": null, "first_name": "JOLIE", "nickname": null, "middle_name": null, "last_name": "BROCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "- Pharmaceutical Tariffs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 65083, "prefix": null, "prefix_display": null, "first_name": "MARC", "nickname": null, "middle_name": null, "last_name": "SCHLOSS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 67610, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "CHARLES", "last_name": "SPANGLER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 148255, "prefix": null, "prefix_display": null, "first_name": "JOLIE", "nickname": null, "middle_name": null, "last_name": "BROCHIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31286 DC DC US US   0 0         245484.0  

Links from other tables

  • 10 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.314ms · Privacy