home / lobbying / lobbying_filings_raw

lobbying_filings_raw: aa2d4b4e-b8fe-43df-8b28-88af15bbfa47

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
aa2d4b4e-b8fe-43df-8b28-88af15bbfa47 Q2 308070 THE WESSEL GROUP INCORPORATED 182654 MCWANE, INC. 2022 second_quarter 2022-07-12T16:26:03-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/aa2d4b4e-b8fe-43df-8b28-88af15bbfa47/", "filing_uuid": "aa2d4b4e-b8fe-43df-8b28-88af15bbfa47", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/aa2d4b4e-b8fe-43df-8b28-88af15bbfa47/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": "2022-07-12T16:26:03-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": "MAN", "general_issue_code_display": "Manufacturing", "description": "National and homeland security implications of declining manufacturing base; Issues surrounding the development of critical infrastructure manufacturing base; Implementation of Executive Order 14005 (Executive Order on Ensuring the Future Is Made in All of America by All of Americas Workers), Executive Order 14008 (Tackling the Climate Crisis at Home and Abroad), Executive Order 14017 (Americas Supply Chains), and Executive Order 14057, (Catalyzing Clean Energy Industries and Jobs Through Federal Sustainability; Buy America policies and implementation of such policies, and funding levels, for infrastructure programs, including the Clean Water State Revolving Fund, Drinking Water State Revolving Fund, Water Infrastructure Financing and Innovation Act program, Rural Utilities Service, and Community Development Block Grant Program in bills including potential energy and climate legislation including the CLEAN Future Act (HR 1512) and LIFT America Act (HR 1848), the Drinking Water and Wastewater Infrastructure Act of 2021 (S 914), the Water Quality Protection and Job Creation Act (HR 1915), the INVEST in America Act (HR 3684), FY2022 Interior, Environment, and Related Agencies Appropriations Act (HR 4372), FY2022 Agriculture, Rural Development, Food and Drug Administration, and Related Agencies Appropriations Act (HR 4356), FY2022 Transportation, Housing and Urban Development, and Related Agencies Appropriations Act (HR 4550), the Infrastructure Investment and Jobs Act (PL 117-44), and potential budget reconciliation legislation including the Build Back Better Act (HR 5376); Treatment of ductile iron utility poles in disaster and mitigation legislation; Legislative efforts to promote the rebuilding and expansion of infrastructure and promoting the use of domestically produced materials; Issues surrounding infrastructure investment programs, and support for domestic procurement policies, in potential economic stimulus legislation including the American Rescue Plan Act of 2021 (PL 117-2); Use of domestic content in FEMA non-emergency infrastructure programs in bills including the Resilient AMERICA Act (HR 5689); Implementation of Lead Service Line Replacement funding in the Infrastructure Investment and Jobs Act (PL 117-44); Implementation of the Build America, Buy America Act title of the Infrastructure Investment and Jobs Act (PL 117-44); Issues surrounding use of ductile iron and other materials in the Tribal Access to Clean Water Act of 2022 (HR 7632)", "foreign_entity_issues": "", "lobbyists": [{"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": 33, "name": "Energy, Dept of"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 35, "name": "Housing & Urban Development, Dept of (HUD)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Proposals to address circumvention of existing antidumping and countervailing duty orders", "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)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 38403 AL   US US Manufacturer of ductile iron pipe, valves and fittings and other products. 0 0 2235652   normalized_name 0.7

Links from other tables

  • 2 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 24.903ms