home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b5e0e2a9-e4e1-4eca-b1b0-26e595507a75

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
b5e0e2a9-e4e1-4eca-b1b0-26e595507a75 Q4 291435 SPECIAL OLYMPICS, INC. 177752 SPECIAL OLYMPICS, INC. 2019 fourth_quarter 2019-12-18T14:00:09.727000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b5e0e2a9-e4e1-4eca-b1b0-26e595507a75/", "filing_uuid": "b5e0e2a9-e4e1-4eca-b1b0-26e595507a75", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2019, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b5e0e2a9-e4e1-4eca-b1b0-26e595507a75/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "30000.00", "expenses_method": "b", "expenses_method_display": "Method B - Reporting amounts under section 6033(b)(8) of the Internal Revenue Code", "posted_by_name": "Meredith Ciaccia Pierce", "dt_posted": "2019-12-18T14:00:09.727000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1133 19TH STREET NW", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 291435, "url": "https://lda.senate.gov/api/v1/registrants/291435/", "house_registrant_id": 37227, "name": "SPECIAL OLYMPICS, INC.", "description": "Provide sport, health, inclusive education programs to people w/ intellectual disabilities", "address_1": "2600 Virginia Avenue NW", "address_2": null, "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20037", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MEREDITH CIACCIA PIERCE", "contact_telephone": "+1 202-824-0342", "dt_updated": "2026-01-20T17:50:45.828592-05:00"}, "client": {"id": 177752, "url": "https://lda.senate.gov/api/v1/clients/177752/", "client_id": 12, "name": "SPECIAL OLYMPICS, INC.", "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": "2017-01-01"}, "lobbying_activities": [{"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Special Olympics Unified Champion Schools, Special Olympics Young Athletes, Early Childhood Development, Motor Activities Training Program", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SCI", "general_issue_code_display": "Science/Technology", "description": "Inclusive camps for people with intellectual disabilities, data regulation, third party data for fundraising and supporter engagement, indirect marketing", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}, {"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LAW", "general_issue_code_display": "Law Enforcement/Crime/Criminal Justice", "description": "Law Enforcement Torch Run for Special Olympics", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "UNM", "general_issue_code_display": "Unemployment", "description": "Workplace inclusion for people with intellectual disabilities", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Workplace inclusion of people with intellectual disabilities", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Special Olympics Healthy Athletes and Healthy Communities Programs", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "Special Olympics/UNICEF Global Partnership", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}, {"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "SPO", "general_issue_code_display": "Sports/Athletics", "description": "Special Olympics 2019 World Summer Games, Special Olympics 2021 World Winter Games, Special Olympics 2022 USA Games, Special Olympics 2023 World Summer Games, Special Olympics 2025 World Winter Games, Special Olympics Unified Cup", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}, {"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Special Olympics Unified Champion Schools, Special Olympics Healthy Athletes and Healthy Communities Programs, Special Olympics 2019 World Summer Games, Special Olympics 2021 World Winter Games, Special Olympics 2022 USA Games, Special Olympics 2023 World Summer Games, Special Olympics 2025 World Winter Games", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 71255, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CIACCIA PIERCE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 133352, "prefix": "mr", "prefix_display": "MR.", "first_name": "SHAWN", "nickname": null, "middle_name": "M", "last_name": "FERGUSON", "suffix": null, "suffix_display": null}, "covered_position": "Senior Advisor to the Senator, Senator Kent Conrad Legislative Director, Representative Brian Baird Office Manager & Director of Scheduling, Representative Marcy Kaptur", "new": false}], "government_entities": [{"id": 134, "name": "Centers For Disease Control & Prevention (CDC)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 32, "name": "Education, Dept of"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 68, "name": "Natl Aeronautics & Space Administration (NASA)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 10, "name": "Vice President of the U.S."}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 37227 DC DC US US   0 0           30000.0

Links from other tables

  • 9 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.36ms · Privacy