home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d6c80bf3-9d92-44f1-8e74-e3fea2e9196c

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
d6c80bf3-9d92-44f1-8e74-e3fea2e9196c MM 9578 CMS ENERGY CORP 113699 CMS ENERGY CORP 2005 mid_year 2005-08-10T00:00:00-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d6c80bf3-9d92-44f1-8e74-e3fea2e9196c/", "filing_uuid": "d6c80bf3-9d92-44f1-8e74-e3fea2e9196c", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2005, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d6c80bf3-9d92-44f1-8e74-e3fea2e9196c/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "235000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2005-08-10T00: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": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "HR2744 - Agriculture FY'06 Approps, Animal and Plant Health Inspection Service (APHIS) provisions. HR2862 Science/State/Justice/Commerce and related agencies FY'06 Appropriations. HR2419 Energy & Water FY'06 Appropriations. HR3057 Foreign Operations FY'06 Appropriations, development assistance related provisions. HR3010 Labor/HHS/Education FY'06 Appropriations, LIHEAP related provisions. HconRes95 to establish the congressional budget for FY'06, revising appropriate budgetary levels for FY'05, and setting forth appropriate budgetary levels for FY'07-'10. SConRes18 - set forth the congressional budget for FY'06 and including the appropriate budgetary levels for FY'05 and '07 thru '10.\r\nHR2601- Foreign Relations Authorization Act, Fiscal Years 2006 and 2007, provisions to authorize appropriations for the Department of State for fiscal years 2006 and 2007. S600 - Foreign Affairs Authorization Act, Fiscal Years 2006 and 2007, provisions to authorize appropriations for the Department of State and for fiscal years 2006 and 2007 and for foreign assistance programs for fiscal years 2006 and 2007. HR3057 - Foreign Operations, Export Financing, and Related Programs Appropriations Act, 2006, provisions making appropriations for the Department of State, foreign operations, and related programs for the fiscal year ending September 30, 2006. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "BAN", "general_issue_code_display": "Banking", "description": "HR809 a bill to make permanent the individual income tax rates for capital gains and dividends. HR526 - 21st Century Science for Nuclear Waste Disposal Act, redirects the nuclear waste fund be used for research, etc... S858 - Nuclear Fees Reauthorization Act of 2005. S467 Terrorism Risk Insurance Extension Act of 2005. HR1153 - a bill to extend the terrorism insurance program of the Department of the Treasury. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "UTI", "general_issue_code_display": "Utilities", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy. S1194 - Spent Nuclear Fuel Tracking and Accountability Act. HR3017 - Nuclear Power Licensing Reform Act of 2005. HR526 - 21st Century Science for Nuclear Waste Disposal Act. S858 - Nuclear Fees Reauthorization Act of 2005. S864-Nuclear Safety and Security Act of 2005.\r\nHR3/S732 - Safe, Accountable, Flexible and Efficient Transportation Equity Act of 2005, hours of service related provisions. HR2958 - a bill to require notification of appropriate emergency response authorities when damage to underground pipeline facilities occurs or is discovered. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TRA", "general_issue_code_display": "Transportation", "description": "HR3058 - Transportation/Treasury/Judiciary/HUD FY'06 Appropriations. HR3 - Safe, Accountable, Flexible, and Efficient Transportation Equity Act of 2005, hours of service related provisions. HR2958 - a bill to require notification of appropriate emergency response authorities when damage to underground pipeline facilities occurs or is discovered. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "HR809 a bill to make permanent the individual income tax rates for capital gains and dividends. HR2830- Pension Protection Act of 2005, provisions to amend the Internal Revenue Code of 1986 to reform the pension funding rules. HR2106- Employee Pension Preservation and Taxpayer Protection Act of 2005, provisions to amend the Internal Revenue Code of 1986 to provide transition funding rules for certain plans electing to cease future benefit accruals. S861 - Employee Pension Preservation Act of 2005, provisions to amend the Internal Revenue Code of 1986 to provide transition funding rules for certain plans electing to cease future benefit accruals. HR6/S10 - Energy Policy Act of 2005.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "RET", "general_issue_code_display": "Retirement", "description": "S219 - National Employee Savings and Trust Equity Guarantee Act of 2005. HR2830 - Pension Protection Act of 2005. HR2106 - Employee Pension Preservation and Taxpayer Protection Act of 2005. S861 -Employee Pension Preservation Act of 2005.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "FOR", "general_issue_code_display": "Foreign Relations", "description": "HR2862 Science/State/Justice/Commerce and related agencies FY'06 Appropriations. HR3057 Foreign Operations FY'06 Appropriations, development assistance related provisions. HR2601- Foreign Relations Authorization Act, Fiscal Years 2006 and 2007, provisions to authorize appropriations for the Department of State for fiscal years 2006 and 2007. S600 - Foreign Affairs Authorization Act, Fiscal Years 2006 and 2007, provisions to authorize appropriations for the Department of State and for fiscal years 2006 and 2007 and for foreign assistance programs for fiscal years 2006 and 2007. HR3057 - Foreign Operations, Export Financing, and Related Programs Appropriations Act, 2006, provisions making appropriations for the Department of State, foreign operations, and related programs for the fiscal year ending September 30, 2006. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy. S1194 - Spent Nuclear Fuel Tracking and Accountability Act. HR526 - 21st Century Science for Nuclear Waste Disposal Act.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "INS", "general_issue_code_display": "Insurance", "description": "S467 - Terrorism Risk Insurance Extension Act of 2005. HR1153 a bill to extend the terrorism insurance program of the Department of the Treasury. HR6/S10 - Energy Policy Act of 2005, Price Anderson provisions.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy. S1194 - Spent Nuclear Fuel Tracking and Accountability Act. HR3017 - Nuclear Power Licensing Reform Act of 2005. HR526 - 21st Century Science for Nuclear Waste Disposal Act. S858 - Nuclear Fees Reauthorization Act of 2005. S864-Nuclear Safety and Security Act of 2005.\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "FUE", "general_issue_code_display": "Fuel/Gas/Oil", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy. HR3/S732 - Safe, Accountable, Flexible and Efficient Transportation Equity Act of 2005.\r\nHR2958 - a bill to require notification of appropriate emergency response authorities when damage to underground pipeline facilities occurs or is discovered. \r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "HR6/S10 - Energy Policy Act of 2005. S.131 - Clear Skies Act of 2005. S150 Clean Power Act of 2005. S342 Climate Stewardship Act of 2005. S1151 Climate Stewardship and Innovation Act of 2005. S730 - Mercury Emission Act of 2005. S386, S387, S388 and S887 - Climate Change Technology Deployment and Infrastrucutre Credit Acts of 2005 as introduced by Sen. Hagel. SJRes20 - resolution disapproving the EPA's mercury rule as introduced by Sen. Leahy.", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 138341, "prefix": "ms", "prefix_display": "MS.", "first_name": "KIRAN", "nickname": null, "middle_name": "CROUT", "last_name": "MALONE", "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": 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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 39, "name": "State, Dept of (DOS)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} MI US 31130 DC DC US US   0 0           235000.0

Links from other tables

  • 13 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.347ms · Privacy