home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9e68113d-935b-48fd-856a-67755c0da8e3

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

This data as json

filing_uuid filing_type registrant_id registrant_name client_id client_name filing_year filing_period received_date 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 income_amount expense_amount
9e68113d-935b-48fd-856a-67755c0da8e3 MM 9578 CMS ENERGY CORP 113699 CMS ENERGY CORP 2002 mid_year 2002-08-12T00:00:00-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9e68113d-935b-48fd-856a-67755c0da8e3/", "filing_uuid": "9e68113d-935b-48fd-856a-67755c0da8e3", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2002, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9e68113d-935b-48fd-856a-67755c0da8e3/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "1000000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2002-08-12T00:00:00-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 9578, "url": "https://lda.senate.gov/api/v1/registrants/9578/", "house_registrant_id": 31130, "name": "CMS ENERGY CORP", "description": null, "address_1": "One Energy Plaza", "address_2": null, "address_3": null, "address_4": null, "city": "Jackson", "state": "MI", "state_display": "Michigan", "zip": "49201", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BRANDON J. HOFMEISTER", "contact_telephone": "+1 517-745-2508", "dt_updated": "2026-01-20T13:55:40.726894-05:00"}, "client": {"id": 113699, "url": "https://lda.senate.gov/api/v1/clients/113699/", "client_id": 12, "name": "CMS ENERGY CORP", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-07-26"}, "lobbying_activities": [{"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "HR. 333, Bankruptcy Overhaul\r\nH.R. 3763, Accounting Reform\r\nH.R. 3764, SEC Reauthorization\r\nS. 420, Bankruptcy Overhaul\r\nS. 2673, Accounting Reform", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "H.R. 3529, Economic Stimulus\r\nH.R. 4775, Fiscal 2002 Supplemental Appropriations\r\nCommerce, Justice, State and the Judiciary Appropriations for FY 2003\r\nEnergy and Water Appropriations for FY 2003\r\nInterior Appropriations for FY 2003\r\nForeign Operations Appropriations for FY 2003\r\nLabor, HHS and Education Appropriations for FY 2003\r\nTransportation Appropriations for FY 2003", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "H.R. 4, Energy Policy\r\nH.R. 1256, Clean Smokestacks Act\r\nH.R. 1335, Clean Power Plant Act\r\nH.R. 1647, Electricity Energy Relief Act\r\nH.R. 2249\r\nH.R. 2436, Energy Security Act\r\nH.R. 2869, Brownfields Revitalization and Environmental Restoration\r\nS. 60, NEET Act\r\nS. 388, National Energy Security Act\r\nS. 517, Energy Policy\r\nS. 556, Clean Power Act\r\nS. 1131, Clean Power Plant Act\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "UTI", "general_issue_code_display": "Utilities", "description": "H.J. Res. 87, Yucca Mountain Site Resolution\r\nH.R. 4, SAFE Act\r\nH.R. 1045\r\nH.R. 1101, Repeal PUHCA Act\r\nH.R. 1647, The Electricity Emergency Act\r\nH.R. 3406, Electric Supply and Transmission Act\r\nS. 60, NEET Act\r\nS. 1746, Nuclear Security Act\r\nS. 1766, Energy Policy Act\r\nS.J. Res. 34, Yucca Mountain Site Resolution", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "H.R. 4, SAFE Act\r\nH.R. 144, Pipeline Safety Act\r\nH.R. 276\r\nH.R. 360, Transportation Security\r\nH.R. 459\r\nH.R. 1008, Hours of Service Legislation\r\nH.R. 2436, Energy Security Act\r\nH.R. 2481, Omnibus Maritime Improvements Act\r\nH.R. 3429, Transportation Security\r\nH.R. 3609, Pipeline Safety Improvement Act\r\nH.R. 3983, Port Security\r\nS. 141\r\nS. 235, Pipeline Safety Improvement Act\r\nS. 299\r\nS. 388, National Energy Security Act\r\nS. 614, Hours of Service Legislation", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 4, Energy Policy\r\nH.R. 10\r\nH.R. 794\r\nH.R. 1657\r\nH.R. 1836\r\nH.R. 2436, Energy Security Act\r\nH.R. 2511, Energy Tax Policy Act\r\nH.R. 3762, Pension Plan Reform\r\nSenate Energy Tax Legislation, a Part of the Comprehensive Energy Policy\r\nS. 388, National Energy Security Act\r\nS. 389\r\nS. 517, Energy Policy\r\nS. 1992, Pension Plan Reform", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "H.R. 1646, State Department Authorization\r\nH.R. 2602, Reauthorize Export Administration Act\r\nH.R. 3005, Trade Promotion Authority\r\nS. 1401, State Department Authorization", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "H.R. 4, Energy Policy and SAFE Act\r\nH.R. 264\r\nH.R. 381\r\nH.R. 1045\r\nH.R. 1101, Repeal the Public Utility Holding Company Act\r\nH.R. 1647\r\nH.R. 1941\r\nH.R. 2311, Energy and Water Appropriations for FY 2002\r\nH.R. 2436, Energy Security Act\r\nH.R. 2975, PATRIOT Bill\r\nH.R. 3016, Antiterrorism Legislation\r\nH.R. 3210, Terrorism Insurance\r\nH.R. 3609, Pipeline Safety\r\nH.R. 4660, Homeland Security Department Creation\r\nS. 206\r\nS. 235, Pipeline Safety\r\nS. 388, National Energy Security Act\r\nS. 472, Nuclear Energy Electricity Supply Assurance Act\r\nS. 517, Energy Policy\r\nS. 1746, Nuclear Security Act\r\nS. 1776, Energy Policy Act\r\nS. 2452, Homeland Security Department Creation\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "H.R. 3762, Pension Plan Reform\r\nS. 1992, Pension Plan Reform\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "H.R. 4, Energy Policy\r\nH.R. 245\r\nH.R. 1117, Relief From Unfair Interest and Penalties on Refunds Retroactively Ordered by FERC\r\nH.R. 1317\r\nH.R. 1647, The Electricity Emergency Act\r\nH.R. 1705\r\nH.R. 2323, National Electricity and Environmental Technology Act\r\nH.R. 2952, Powder River Basin Resource Development Act\r\nH.R. 3406, Electric Supply and Transmission Act\r\nH.R. 3449\r\nH.R. 3798\r\nH.R. 4011\r\nS. 295\r\nS. 517, Energy Policy\r\nS. 1037\r\nS. 2546\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "H.R. 4, Energy Policy and SAFE Act\r\nH.R. 1256, Clean Smokestacks Act\r\nH.R. 1335, Clean Power Plant Act\r\nH.R. 1647, Electricity Energy Relief Act\r\nH.R. 2249\r\nH.R. 2436, Energy Security Act\r\nS. 60, NEET Act\r\nS. 388, National Energy Security Act\r\nS. 517, Energy Policy\r\nS. 556, Clean Power Act\r\nS. 1131, Clean Power Plant Act\r\nS. 1766, Energy Policy Act\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Department of Interior Appropriations Act of 2002\r\nH.R. 4, SAFE Act\r\nH.R. 2436, Energy Security Act\r\nS. 388, National Energy Security Act\r\nS. 517, Energy Policy", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3841, "prefix": null, "prefix_display": null, "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "EDELSON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4422, "prefix": null, "prefix_display": null, "first_name": "ANNA", "nickname": null, "middle_name": "V", "last_name": "COCHRANE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 4847, "prefix": null, "prefix_display": null, "first_name": "MARY", "nickname": null, "middle_name": "JO", "last_name": "KRIPOWICZ", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 7802, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "A", "last_name": "PICKART", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 25472, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "MENGEBIER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 34138, "prefix": null, "prefix_display": null, "first_name": "KATHRYN", "nickname": null, "middle_name": "M", "last_name": "WOODRUFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 38351, "prefix": null, "prefix_display": null, "first_name": "NORMAN", "nickname": null, "middle_name": "J", "last_name": "SAARI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 33, "name": "Energy, Dept of"}, {"id": 49, "name": "Environmental Protection Agency (EPA)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 36, "name": "Interior, Dept of (DOI)"}, {"id": 188, "name": "Internal Revenue Service (IRS)"}, {"id": 78, "name": "Nuclear Regulatory Commission (NRC)"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 88, "name": "Securities & Exchange Commission (SEC)"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}, {"id": 40, "name": "Transportation, Dept of (DOT)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} MI US 31130 DC DC US US   0 0           1000000.0

Links from other tables

  • 12 rows from filing_uuid in lobbying_activities
  • 7 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.28ms · Privacy