home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c5f8f7fb-2f8a-4d75-a3d2-5548bfca9c95

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
c5f8f7fb-2f8a-4d75-a3d2-5548bfca9c95 Q1 308070 THE WESSEL GROUP INCORPORATED 182654 MCWANE, INC. 2016 first_quarter 2016-04-20T10:33:30.433000-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c5f8f7fb-2f8a-4d75-a3d2-5548bfca9c95/", "filing_uuid": "c5f8f7fb-2f8a-4d75-a3d2-5548bfca9c95", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2016, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c5f8f7fb-2f8a-4d75-a3d2-5548bfca9c95/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Michael Wessel", "dt_posted": "2016-04-20T10:33:30.433000-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 Trans Pacific Partnership trade agreement negotiations;\nTreatment of iron ductile pipe in Environmental Goods Agreement;\nTrans Atlantic Trade and Investment Partnership - treatment of iron ductile pipe.", "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": 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 (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 Revolving Fund, Drinking Water State Revolving Fund, Water Infrastructure Financing and Innovation Act in bills including the Consolidated Appropriations Act, 2015 (P.L. 114-113), FY 2017 Interior, Environment, and Related Agencies Appropriations Bills, potential Water Resources Development Act in 2017, and the Assistance, Quality, and Affordability Act of 2016 (H.R. 4563);\nLegislative responses to water infrastructure needs in Flint, MI and elsewhere, including the Energy Modernization Act (S.2012) and the Safe Drinking Water Act Improved Compliance Awareness Act (H.R. 4470).", "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}], "government_entities": [{"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
  • 3 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 81.093ms