home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 43b5c73f-e78c-4e3f-8220-64a4853d4e6e

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
43b5c73f-e78c-4e3f-8220-64a4853d4e6e Q1 401103767 O'CONNELL & DEMPSEY, LLC 200094 METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO 2023 first_quarter 2023-04-14T16:48:33-04:00 40000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/43b5c73f-e78c-4e3f-8220-64a4853d4e6e/", "filing_uuid": "43b5c73f-e78c-4e3f-8220-64a4853d4e6e", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2023, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/43b5c73f-e78c-4e3f-8220-64a4853d4e6e/print/", "filing_document_content_type": "text/html", "income": "40000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Mia O'Connell", "dt_posted": "2023-04-14T16:48:33-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "20 F Street, NW, Ste. 700", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 401103767, "url": "https://lda.senate.gov/api/v1/registrants/401103767/", "house_registrant_id": 43017, "name": "O'CONNELL & DEMPSEY, LLC", "description": "Lobbying/Government Relations", "address_1": "20 F Street, NW, Ste. 700", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MIA O'CONNELL", "contact_telephone": "+1 202-740-5401", "dt_updated": "2026-01-30T22:05:33.369422-05:00"}, "client": {"id": 200094, "url": "https://lda.senate.gov/api/v1/clients/200094/", "client_id": 113, "name": "METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO", "general_description": "Protect and improve water quality and protect against flood damage in the Chicago area.", "client_government_entity": true, "client_self_select": null, "state": "IL", "state_display": "Illinois", "country": "US", "country_display": "United States of America", "ppb_state": "IL", "ppb_state_display": "Illinois", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2016-02-01"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Provisions related to Environmental Protection Agency Funding for environmental protection, water quality projects, wastewater projects, workforce development and combined sewer overflows projects and programs in FY 2022 Interior, and Environmental and related agencies Appropriations bills, (H.R.4502, S.3034); specific project funding for Forging Resilient Communities in Chicagoland in the Omnibus Appropriations Act of 2022, P.L. 117-103 Funding for Forging Resilient Communities in Chicagoland in the Senate FY 2023 Interior and Environment and Related Agencies Appropriations bill, and the Consolidated Appropriations Act, 2023, H.R. 2617 Federal funding related to water quality, wastewater and green infrastructure in Infrastructure Investment and Jobs Act, P.L.117-58 Federal funding sought for reimbursement of local flood contract construction costs in the Senate Energy and Water Development Appropriation Bill for FY 2023, and the Consolidated Appropriations Act, 2023, H.R. 2617 and for FY 2023 Corps' Work Plan Federal funding related to Inflation Reduction Act, P.L.117-169", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62586, "prefix": null, "prefix_display": null, "first_name": "MIA", "nickname": null, "middle_name": null, "last_name": "O'CONNELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Flood protection, water quality, wastewater treatment and environmental restoration, project implementation, and project approvals for Corps of Engineers and U.S. Environmental Protection Agency projects Federal funding related to wastewater treatment in the FY2023 Senate Interior Environment and Related Agencies Appropriations Bill, and the Consolidated Appropriations Act, 2023, H.R. 2617", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62586, "prefix": null, "prefix_display": null, "first_name": "MIA", "nickname": null, "middle_name": null, "last_name": "O'CONNELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "URB", "general_issue_code_display": "Urban Development/Municipalities", "description": "Flood protection, water quality, wastewater treatment, and environmental restoration, project implementation and project approvals for Corps of Engineers and U.S. Environmental Protection Agency projects Federal funding around Corps of Engineers' flood control funding and reimbursements and FEMA's BRIC programs in Infrastructure Investment and Jobs Act, P.L.117-58, and Consolidated Appropriations Act, 2023, H.R. 2617, and the FY 2023 Work Plan of the Corps of Engineers Federal funding related to wastewater projects in American Rescue Plan of 2021, P.L.117-2 Federal funding related to wastewater treatment facilities in Inflation Reduction Act, P.L. 117-169", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62586, "prefix": null, "prefix_display": null, "first_name": "MIA", "nickname": null, "middle_name": null, "last_name": "O'CONNELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 56, "name": "Federal Emergency Management Agency (FEMA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Flood protection, water quality, wastewater treatment, and environmental restoration, project implementation and project approvals for Corps of Engineers and U.S. Environmental Protection Agency projects Provisions of the America's Water Infrastructure Act of 2020, S.3591; the Water Resources Development Act of 2020, H.R. 7575 regarding the Chicago River Restoration Study, green infrastructure and workforce development in wastewater utility arena; and the Omnibus Appropriations Act of 2022, P.L. 117-103, and the Consolidated Appropriations Act, 2023, H.R. 2617 Federal funding related to natural resources in Inflation Reduction Act, P.L. 117-169", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 62586, "prefix": null, "prefix_display": null, "first_name": "MIA", "nickname": null, "middle_name": null, "last_name": "O'CONNELL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 200, "name": "Army, Dept of (Corps of Engineers)"}, {"id": 15, "name": "Council on Environmental Quality (CEQ)"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 1 row from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 13.259ms