home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 3db8d65b-3057-4daa-aebd-b2037fbbbf34

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 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
3db8d65b-3057-4daa-aebd-b2037fbbbf34 Q2 13610 ENS RESOURCES, INC. 119013 ORANGE COUNTY WATER DISTRICT 2024 second_quarter 2024-07-14T16:46:35-04:00 20000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/3db8d65b-3057-4daa-aebd-b2037fbbbf34/", "filing_uuid": "3db8d65b-3057-4daa-aebd-b2037fbbbf34", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2024, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/3db8d65b-3057-4daa-aebd-b2037fbbbf34/print/", "filing_document_content_type": "text/html", "income": "20000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Eric Sapirstein", "dt_posted": "2024-07-14T16:46:35-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1990 K Street, NW", "registrant_address_2": "Suite 605", "registrant_different_address": true, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20006", "registrant": {"id": 13610, "url": "https://lda.senate.gov/api/v1/registrants/13610/", "house_registrant_id": 30647, "name": "ENS RESOURCES, INC.", "description": "Consulting Intergovernmental Affairs", "address_1": "1367 Connecticut Ave., NW", "address_2": "Suite 310", "address_3": null, "address_4": null, "city": "WASHINGTON", "state": "DC", "state_display": "District of Columbia", "zip": "20036", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ERIC SAPIRSTEIN", "contact_telephone": "+1 202-466-3755", "dt_updated": "2026-01-25T14:02:03.727151-05:00"}, "client": {"id": 119013, "url": "https://lda.senate.gov/api/v1/clients/119013/", "client_id": 253, "name": "ORANGE COUNTY WATER DISTRICT", "general_description": null, "client_government_entity": true, "client_self_select": null, "state": "CA", "state_display": "California", "country": "US", "country_display": "United States of America", "ppb_state": "CA", "ppb_state_display": "California", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-13"}, "lobbying_activities": [{"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Support of Interior and Environment FY 25 Appropriations, H.R. 8998 and S. XXX, related to Community Project Assistance Request for PFAS groundwater contamination cleanup assistance Monitor and support of Energy and Water Development FY 25 Appropriations related to funding of Forecast Informed Reservoir Operations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19787, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SAPIRSTEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68582, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "SAPIRSTEIN", "suffix": null, "suffix_display": null}, "covered_position": "Intern, Office of Senator Patrick Leahy", "new": false}, {"lobbyist": {"id": 28160, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "R", "last_name": "FRENCH", "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": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "Monitor finalization of PFAS drinking water (MCL) rulemaking standard. Monitor and support development of PFAS legislation to address treatment technology development and CERCLA liability exemption for water agencies, S. 1430 and H.R. 7944. Support of Low Income Household Water Assistance Program Establishment Act, S. 3830 and H.R. 8032.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19787, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SAPIRSTEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 68582, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "SAPIRSTEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 28160, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": "R", "last_name": "FRENCH", "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": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Support of Superfund liability exemption for water agencies related to PFAS hazardous substance designation, H.R. 7944 and S. 1430.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 19787, "prefix": null, "prefix_display": null, "first_name": "ERIC", "nickname": null, "middle_name": null, "last_name": "SAPIRSTEIN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30647 CA CA US US   1 0   41841 government_unit_name_state 0.9

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 3.075ms