lobbying_activities
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
4 rows where filing_uuid = "43b5c73f-e78c-4e3f-8220-64a4853d4e6e" sorted by filing_year descending
This data as json, CSV (advanced)
Suggested facets: government_entities, received_date (date)
| id | filing_uuid | filing_type | registrant_name | registrant_id | client_name | filing_year ▲ | filing_period | issue_code | specific_issues | government_entities | income_amount | expense_amount | is_no_activity | is_termination | received_date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2959805 | O'CONNELL & DEMPSEY, LLC 43b5c73f-e78c-4e3f-8220-64a4853d4e6e | Q1 | O'CONNELL & DEMPSEY, LLC | 401103767 | METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO | 2023 | first_quarter | BUD | 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 | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 40000 | 0 | 0 | 2023-04-14T16:48:33-04:00 | |
| 2959806 | O'CONNELL & DEMPSEY, LLC 43b5c73f-e78c-4e3f-8220-64a4853d4e6e | Q1 | O'CONNELL & DEMPSEY, LLC | 401103767 | METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO | 2023 | first_quarter | CAW | 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 | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 40000 | 0 | 0 | 2023-04-14T16:48:33-04:00 | |
| 2959807 | O'CONNELL & DEMPSEY, LLC 43b5c73f-e78c-4e3f-8220-64a4853d4e6e | Q1 | O'CONNELL & DEMPSEY, LLC | 401103767 | METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO | 2023 | first_quarter | URB | 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 | Army, Dept of (Corps of Engineers),Environmental Protection Agency (EPA),Federal Emergency Management Agency (FEMA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 40000 | 0 | 0 | 2023-04-14T16:48:33-04:00 | |
| 2959808 | O'CONNELL & DEMPSEY, LLC 43b5c73f-e78c-4e3f-8220-64a4853d4e6e | Q1 | O'CONNELL & DEMPSEY, LLC | 401103767 | METROPOLITAN WATER RECLAMATION DISTRICT OF GREATER CHICAGO | 2023 | first_quarter | NAT | 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 | Army, Dept of (Corps of Engineers),Council on Environmental Quality (CEQ),Environmental Protection Agency (EPA),HOUSE OF REPRESENTATIVES,Office of Management & Budget (OMB),SENATE | 40000 | 0 | 0 | 2023-04-14T16:48:33-04:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE lobbying_activities (
id INTEGER PRIMARY KEY,
filing_uuid TEXT NOT NULL,
filing_type TEXT NOT NULL,
registrant_name TEXT NOT NULL,
registrant_id INTEGER,
client_name TEXT NOT NULL,
filing_year INTEGER NOT NULL,
filing_period TEXT NOT NULL,
issue_code TEXT,
specific_issues TEXT,
government_entities TEXT,
income_amount INTEGER,
expense_amount INTEGER,
is_no_activity INTEGER DEFAULT 0,
is_termination INTEGER DEFAULT 0,
received_date TEXT,
CONSTRAINT fk_activity_filing FOREIGN KEY (filing_uuid)
REFERENCES lobbying_filings_raw(filing_uuid)
);
CREATE INDEX idx_act_client_name ON lobbying_activities(client_name COLLATE NOCASE);
CREATE INDEX idx_act_issue_code ON lobbying_activities(issue_code);
CREATE INDEX idx_act_filing_year ON lobbying_activities(filing_year);
CREATE INDEX idx_act_filing_uuid ON lobbying_activities(filing_uuid);