home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c10acca9-236d-41d7-bb46-e30e5c45d2d7

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
c10acca9-236d-41d7-bb46-e30e5c45d2d7 Q4 296715 SOCIETY FOR VASCULAR SURGERY 179480 SOCIETY FOR VASCULAR SURGERY 2018 fourth_quarter 2019-01-02T11:55:45.727000-05:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c10acca9-236d-41d7-bb46-e30e5c45d2d7/", "filing_uuid": "c10acca9-236d-41d7-bb46-e30e5c45d2d7", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2018, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c10acca9-236d-41d7-bb46-e30e5c45d2d7/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "50000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Mindi Walker", "dt_posted": "2019-01-02T11:55:45.727000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "20 F Street, NW, Suite 310B", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 296715, "url": "https://lda.senate.gov/api/v1/registrants/296715/", "house_registrant_id": 37527, "name": "SOCIETY FOR VASCULAR SURGERY", "description": "Trade Association", "address_1": "9400 W Higgins Rd", "address_2": null, "address_3": null, "address_4": null, "city": "Rosemont", "state": "IL", "state_display": "Illinois", "zip": "60018", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MEGAN K. MARCINKO, MPS", "contact_telephone": "+1 312-334-2356", "dt_updated": "2026-01-29T20:23:14.650238-05:00"}, "client": {"id": 179480, "url": "https://lda.senate.gov/api/v1/clients/179480/", "client_id": 12, "name": "SOCIETY FOR VASCULAR SURGERY", "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": "2018-03-26"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Evaluation and Management Services under the Medicare Physician Fee Schedule", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67977, "prefix": null, "prefix_display": null, "first_name": "MINDI", "nickname": null, "middle_name": null, "last_name": "WALKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "TOR", "general_issue_code_display": "Torts", "description": "Tort Reform; Good Samaritan Health Professionals Act S. 781/H.R. 1876", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67977, "prefix": null, "prefix_display": null, "first_name": "MINDI", "nickname": null, "middle_name": null, "last_name": "WALKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Supporting Independent Payment Advisory Board Repeal - H.R.849/S.260, Protecting Seniors' Access to Medicare Act and S.251, Protecting Medicare from Executive Action, enacted into law\nSupporting Medical Liability Reform - H.R.1215, Protecting Access to Care Act\nACA Repeal and Replace - not supporting\nSupporting H.R.4206, Medicare Care Coordination Improvement Act\nComments on FY 2018 Hospital Outpatient Prospective Payment System Final Rule submitted to CMS, the agency corrected placement of vascular ultrasound codes\nSupporting H.R.2267, Resident Physician Shortage Reduction Act\nSupporting H.R.1876/S.781 - Good Samaritan Health Professionals Act\nOpposing Medicare Payment Advisory Commission's proposal to rebalance the physician fee schedule towards primary care\nFollowing opioid legislation, Stark Act Reform to allow for physician self referral under alternative payment models", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67977, "prefix": null, "prefix_display": null, "first_name": "MINDI", "nickname": null, "middle_name": null, "last_name": "WALKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": true}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "Ensuring appropriate vascular care for veterans and seeking ways to allow medical students, residents, and fellows to login to the VA system remotely and securely", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67977, "prefix": null, "prefix_display": null, "first_name": "MINDI", "nickname": null, "middle_name": null, "last_name": "WALKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Student loan issues to allow for certain relief for medical professionals, Supporting H.R.2267, Resident Physician Shortage Reduction Act to address graduate Medical education shortages", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 67977, "prefix": null, "prefix_display": null, "first_name": "MINDI", "nickname": null, "middle_name": null, "last_name": "WALKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 132, "name": "Agency for Healthcare Research & Quality (AHRQ)"}, {"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} IL US 37527 DC DC US US   0 0           50000.0

Links from other tables

  • 5 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.371ms · Privacy