home / lobbying / lobbying_filings_raw

lobbying_filings_raw: de370e09-e194-40db-a65e-9c979b3d5da0

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.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date amount_reported 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
de370e09-e194-40db-a65e-9c979b3d5da0 Q4 27888 NATIONAL FUNERAL DIRECTORS ASSN 134468 NATIONAL FUNERAL DIRECTORS ASSN 2017 fourth_quarter 2018-01-18T13:42:16.177000-05:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/de370e09-e194-40db-a65e-9c979b3d5da0/", "filing_uuid": "de370e09-e194-40db-a65e-9c979b3d5da0", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2017, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/de370e09-e194-40db-a65e-9c979b3d5da0/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": "Lesley Witter", "dt_posted": "2018-01-18T13:42:16.177000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "13625 Bishops Drive", "registrant_address_2": null, "registrant_different_address": true, "registrant_city": "WASHINGTON", "registrant_state": "WI", "registrant_zip": "53005", "registrant": {"id": 27888, "url": "https://lda.senate.gov/api/v1/registrants/27888/", "house_registrant_id": 32139, "name": "NATIONAL FUNERAL DIRECTORS ASSN", "description": null, "address_1": "13625 Bishops Drive", "address_2": null, "address_3": null, "address_4": null, "city": "Brookfield", "state": "WI", "state_display": "Wisconsin", "zip": "53005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "LELSEY WITTER", "contact_telephone": "+1 202-236-4926", "dt_updated": "2026-01-12T16:19:09.907300-05:00"}, "client": {"id": 134468, "url": "https://lda.senate.gov/api/v1/clients/134468/", "client_id": 12, "name": "NATIONAL FUNERAL DIRECTORS ASSN", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "WI", "state_display": "Wisconsin", "country": "US", "country_display": "United States of America", "ppb_state": "WI", "ppb_state_display": "Wisconsin", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-05-29"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R 1 - The Tax Cuts and Jobs Act - support for small business provisions including provision related to mortgage rate deduction", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19441, "prefix": null, "prefix_display": null, "first_name": "LESLEY", "nickname": null, "middle_name": null, "last_name": "WITTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"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": "H.R. 1212/S. 1596: The BRAVE Act of 2017 - legislation to improve existing benefits for veterans meeting eligibility requirements; ensure all non-service connected veteran deaths are treated equally, regardless of where a veteran dies; indexes all three current benefits for inflation.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19441, "prefix": null, "prefix_display": null, "first_name": "LESLEY", "nickname": null, "middle_name": null, "last_name": "WITTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "H.R. 2022: THE LATTS ACT of 2017: The Labeling and Transporting Tissues Safely Act \n- legislation to ensure certain safety measures are utilized in the interest of public health security with respect to labeling and transporting human tissue specimen or collection of specimens into interstate commerce.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19441, "prefix": null, "prefix_display": null, "first_name": "LESLEY", "nickname": null, "middle_name": null, "last_name": "WITTER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 42, "name": "Veterans Affairs, Dept of (VA)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} WI US 32139 WI WI US US   0 0        

Links from other tables

  • 3 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 24.176ms