home / lobbying / lobbying_filings_raw

lobbying_filings_raw: d203fbf3-8d44-4ee4-8d3e-3687eec0af2b

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
d203fbf3-8d44-4ee4-8d3e-3687eec0af2b Q1 82215 KEARNEY, DONOVAN & MCGEE 171638 NATIONAL GRID 2021 first_quarter 2021-04-20T16:51:25.380000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/d203fbf3-8d44-4ee4-8d3e-3687eec0af2b/", "filing_uuid": "d203fbf3-8d44-4ee4-8d3e-3687eec0af2b", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2021, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/d203fbf3-8d44-4ee4-8d3e-3687eec0af2b/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Dennis J. Kearney", "dt_posted": "2021-04-20T16:51:25.380000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "40 Court Street", "registrant_address_2": "11th Floor", "registrant_different_address": false, "registrant_city": "Boston", "registrant_state": "MA", "registrant_zip": "02108", "registrant": {"id": 82215, "url": "https://lda.senate.gov/api/v1/registrants/82215/", "house_registrant_id": 36376, "name": "KEARNEY, DONOVAN & MCGEE", "description": "Government Relations & Lobbying, Public Policy & Strategic Planning.", "address_1": "40 Court Street", "address_2": null, "address_3": null, "address_4": null, "city": "Boston", "state": "MA", "state_display": "Massachusetts", "zip": "02108", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "BETH MARPLE", "contact_telephone": "", "dt_updated": "2026-01-30T15:53:14.159644-05:00"}, "client": {"id": 171638, "url": "https://lda.senate.gov/api/v1/clients/171638/", "client_id": 12, "name": "NATIONAL GRID", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-09"}, "lobbying_activities": [{"general_issue_code": "UTI", "general_issue_code_display": "Utilities", "description": "New England onshore and offshore energy projects, rate proceedings, regional economic development projects, pipeline safety, energy infrastructure resiliency initiatives, transportation electrification, climate change, smart grid and energy efficiency initiatives and coronavirus response; FERC, Department of Energy, and EPA policies affecting New England energy markets; Transportation electrification; Energy storage; Climate change; Implementation of Public Law 116-136 (the Coronavirus Aid, Relief, and Economic Security Act (CARES Act), regarding LIHEAP funding.", "foreign_entity_issues": "National Grid plc, 1-3 Strand, London WC2N5 EH GBR, the indirect parent of National Grid USA identified on LD-1, was interested in this issue due to its potential impact upon its investment in the United States.", "lobbyists": [{"lobbyist": {"id": 13165, "prefix": "mr", "prefix_display": "MR.", "first_name": "DENNIS", "nickname": null, "middle_name": "J", "last_name": "KEARNEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Carbon emission reduction proposals; Offshore wind tax incentives; Transportation electrification tax incentives; Energy storage tax incentives; Public Law 116-260 (Consolidated Appropriations Act, 2021), regarding implementation of LIHEAP funding and wind and solar energy tax provisions; H.R.848 (GREEN Act), regarding wind, solar, energy storage, electric vehicle and efficiency incentives; H.R.1684/S.627 (Energy Storage Tax Incentive and Deployment Act), all provisions.", "foreign_entity_issues": "National Grid plc, 1-3 Strand, London WC2N5 EH GBR, the indirect parent of National Grid USA identified on LD-1, was interested in this issue due to its potential impact upon its investment in the United States.", "lobbyists": [{"lobbyist": {"id": 13165, "prefix": "mr", "prefix_display": "MR.", "first_name": "DENNIS", "nickname": null, "middle_name": "J", "last_name": "KEARNEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "ENG", "general_issue_code_display": "Energy/Nuclear", "description": "EPA regulation of electricity and natural gas; H.R.1512 (CLEAN Future Act), provisions affecting electricity and natural gas; H.R.1319 (American Rescue Act of 2021), state and local assistance.", "foreign_entity_issues": "National Grid plc, 1-3 Strand, London WC2N5 EH GBR, the indirect parent of National Grid USA identified on LD-1, was interested in this issue due to its potential impact upon its investment in the United States.", "lobbyists": [{"lobbyist": {"id": 13165, "prefix": "mr", "prefix_display": "MR.", "first_name": "DENNIS", "nickname": null, "middle_name": "J", "last_name": "KEARNEY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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