home / lobbying / lobbying_filings_raw

lobbying_filings_raw: c8a7d2a4-0a57-41f7-bf0b-4c5b8a558e08

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
c8a7d2a4-0a57-41f7-bf0b-4c5b8a558e08 MM 32464 PUBLIC SERVICE ENTERPRISE GROUP 140498 PUBLIC SERVICE ENTERPRISE GROUP 2007 mid_year 2007-07-30T11:18:17-04:00 840000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/c8a7d2a4-0a57-41f7-bf0b-4c5b8a558e08/", "filing_uuid": "c8a7d2a4-0a57-41f7-bf0b-4c5b8a558e08", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/c8a7d2a4-0a57-41f7-bf0b-4c5b8a558e08/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "840000.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-07-30T11:18:17-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": 32464, "url": "https://lda.senate.gov/api/v1/registrants/32464/", "house_registrant_id": 31593, "name": "PUBLIC SERVICE ENTERPRISE GROUP", "description": null, "address_1": "601 New Jersey Avenue NW", "address_2": "Suite 310", "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": "KRISTEN LUDECKE", "contact_telephone": "+1 202-408-0800", "dt_updated": "2026-01-28T09:38:31.214114-05:00"}, "client": {"id": 140498, "url": "https://lda.senate.gov/api/v1/clients/140498/", "client_id": 12, "name": "PUBLIC SERVICE ENTERPRISE GROUP", "general_description": null, "client_government_entity": null, "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-30"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nS. AMDT 1704 to H.R. 6, Energy Advancement & Investment Act, Provisions related to Solar, Smart Meters, Corporate Inversions, Plug In Electric Hybrids\r\nH.R. 1977, Solar Investment Tax Credit\nH.R. 2305, Smart Meters Act\nH.R. 2776, Renewable Energy and Energy Conservation Act, Provisions Related to the Solar Investment Tax Credit, Smart Meters,\nDOE Loan Guarantees", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 14292, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "GRAFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29871, "prefix": null, "prefix_display": null, "first_name": "ANNE", "nickname": null, "middle_name": null, "last_name": "HOSKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30792, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "LUDECKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 36723, "prefix": null, "prefix_display": null, "first_name": "DONISE", "nickname": null, "middle_name": null, "last_name": "CAMERON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "\r\nS. 1321, Energy Savings Act, Provisions related to Plug In Electric Hybrid Vehicle\nH.R. 2556, Energy Savings Act, Provisions related to Plug In Electric Hybrid Vehicles\nH.R. 6, Provsions Related to Combined Heat and Power, Plug In Elecric Hybrid Vehicles, DOE Loan Guarantees\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 14292, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "GRAFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29871, "prefix": null, "prefix_display": null, "first_name": "ANNE", "nickname": null, "middle_name": null, "last_name": "HOSKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30792, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "LUDECKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 36723, "prefix": null, "prefix_display": null, "first_name": "DONISE", "nickname": null, "middle_name": null, "last_name": "CAMERON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "\r\nS. 1710, Department of Labor, HHS Appropriations Act, provisons related to LIHEAP funding\nH.J. RES 20, Continuining Appropriations Resolution, provisons related to LIHEAP funding\nS. 1751 Energy and Water Development Appropriations Act, provisions related to Nuclear Waste\nH.R. 2641, Energy and Water Development Appropriations Act, provisons related to Nuclear Waste", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 14292, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "GRAFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29871, "prefix": null, "prefix_display": null, "first_name": "ANNE", "nickname": null, "middle_name": null, "last_name": "HOSKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30792, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "LUDECKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 36723, "prefix": null, "prefix_display": null, "first_name": "DONISE", "nickname": null, "middle_name": null, "last_name": "CAMERON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "\r\nH.R. 620, Climate Stewardship Act, Market to Reduce GHGs, Mandating Emissions, Tradeable Allowances, Compliance Costs \nS. 317, Electric Utility Cap and Trade Act\nS. 280, Climate Stewardship Act, Market to Reduce GHGs, Mandating Emissions, Tradeable Allowances, Compliance Costs\nS. 309, Global Warming Pollution Reduction Act", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 14292, "prefix": null, "prefix_display": null, "first_name": "PATRICIA", "nickname": null, "middle_name": null, "last_name": "GRAFF", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29871, "prefix": null, "prefix_display": null, "first_name": "ANNE", "nickname": null, "middle_name": null, "last_name": "HOSKINS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 30792, "prefix": null, "prefix_display": null, "first_name": "KRISTEN", "nickname": null, "middle_name": null, "last_name": "LUDECKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 36723, "prefix": null, "prefix_display": null, "first_name": "DONISE", "nickname": null, "middle_name": null, "last_name": "CAMERON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 4 rows from filing_uuid in lobbying_activities
  • 4 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 41.227ms