home / lobbying / lobbying_filings_raw

lobbying_filings_raw: b8d3aaa9-ed32-4e0a-b479-b861f5aa4e4b

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
b8d3aaa9-ed32-4e0a-b479-b861f5aa4e4b Q2 308070 THE WESSEL GROUP INCORPORATED 182654 MCWANE, INC. 2017 second_quarter 2017-07-19T16:07:56.457000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/b8d3aaa9-ed32-4e0a-b479-b861f5aa4e4b/", "filing_uuid": "b8d3aaa9-ed32-4e0a-b479-b861f5aa4e4b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/b8d3aaa9-ed32-4e0a-b479-b861f5aa4e4b/print/", "filing_document_content_type": "text/html", "income": "50000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Michael Wessel", "dt_posted": "2017-07-19T16:07:56.457000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 17th Street NW", "registrant_address_2": "Suite 1004", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 308070, "url": "https://lda.senate.gov/api/v1/registrants/308070/", "house_registrant_id": 38403, "name": "THE WESSEL GROUP INCORPORATED", "description": "Consulting services on public policy and political affairs", "address_1": "1101 17th Street NW", "address_2": "Suite 400", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MICHAEL WESSEL", "contact_telephone": "+1 202-293-8899", "dt_updated": "2026-01-23T15:20:26.306155-05:00"}, "client": {"id": 182654, "url": "https://lda.senate.gov/api/v1/clients/182654/", "client_id": 1002374, "name": "MCWANE, INC.", "general_description": "Manufacturer of ductile iron pipe, valves and fittings and other products.", "client_government_entity": false, "client_self_select": false, "state": "AL", "state_display": "Alabama", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-05-01"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Treatment of ductile iron pipe in potential trade agreements and actions under consideration by the Trump Administration", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20113, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "WESSEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 24153, "prefix": null, "prefix_display": null, "first_name": "STEPHEN", "nickname": null, "middle_name": null, "last_name": "KOPLAN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "Funding mechanisms for water and wastewater infrastructure projects, including the Water Resources Reform and Development Act\n(PL 113-121);\nNational and homeland security implications of declining manufacturing base;\nIssues surrounding the development of critical infrastructure manufacturing base;\nIssues surrounding Buy America applications and the drought in California;\nSupport for Department of Energy programs for the assistance and promotion of energy-intensive, trade-exposed industries;\nBuy America policies and implementation of such policies, and funding levels, for water infrastructure programs including the Clean Water State Revolving Fund, Drinking Water State Revolving Fund, Water Infrastructure Financing and Innovation Act in bills including the Consolidated Appropriations Act, 2016 (PL 114-113), Water Infrastructure Improvements for the Nation Act (PL 114-322), and FY 2018 Interior, Environment, and Related Agencies appropriations bill;\nConsolidated Appropriations Act, 2017 (PL 155-31)\nImplementation of Executive Order 13788 (Buy American and Hire American), and other potential presidential actions related to procurement.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 20113, "prefix": null, "prefix_display": null, "first_name": "MICHAEL", "nickname": null, "middle_name": null, "last_name": "WESSEL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36239, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "TRACI", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64483, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": "REED", "last_name": "ECKHOLD", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 18.883ms