home / lobbying / lobbying_filings_raw

lobbying_filings_raw: ddc5d2b6-e1d0-4afd-84ba-e91b3ff70ebd

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
ddc5d2b6-e1d0-4afd-84ba-e91b3ff70ebd Q2 308070 THE WESSEL GROUP INCORPORATED 182654 MCWANE, INC. 2019 second_quarter 2019-07-18T21:30:08.550000-04:00 50000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/ddc5d2b6-e1d0-4afd-84ba-e91b3ff70ebd/", "filing_uuid": "ddc5d2b6-e1d0-4afd-84ba-e91b3ff70ebd", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2019, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/ddc5d2b6-e1d0-4afd-84ba-e91b3ff70ebd/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": "2019-07-18T21:30:08.550000-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}], "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"}]}, {"general_issue_code": "MAN", "general_issue_code_display": "Manufacturing", "description": "National and homeland security implications of declining manufacturing base;\n\nIssues surrounding the development of critical infrastructure manufacturing base;\n\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, 2018 (PL 115-141), Consolidated Appropriations Act, 2019 (PL 116-6), Americas Water Infrastructure Act of 2018 (PL 115-270), and FY 2020 Interior, Environment, and Related Agencies Appropriations bills, including HR 3052, and Omnibus Appropriations bills, including HR 3055; \n\nImplementation of Executive Order 13788 (Buy American and Hire American), and other potential presidential actions related to procurement;\n\nTreatment of ductile iron utility poles in disaster and mitigation legislation, including the Disaster Recovery Reform Act (PL 115-254), and the Additional Supplemental Appropriations for Disaster Relief Act, 2019 (PL 116-20);\n\nIssues and potential legislation relating to the use of innovative materials in infrastructure projects; \n\nLegislative efforts to promote the rebuilding and expansion of infrastructure and promoting the use of domestically-produced products", "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"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 36.365ms