home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f433ecb6-e488-40ac-96c2-baa209bf31ec

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
f433ecb6-e488-40ac-96c2-baa209bf31ec Q2 13610 ENS RESOURCES, INC. 119036 CITY OF SAN BUENAVENTURA 2017 second_quarter 2017-07-11T13:06:43.660000-04:00 10000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f433ecb6-e488-40ac-96c2-baa209bf31ec/", "filing_uuid": "f433ecb6-e488-40ac-96c2-baa209bf31ec", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f433ecb6-e488-40ac-96c2-baa209bf31ec/print/", "filing_document_content_type": "text/html", "income": "10000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Eric Sapirstein", "dt_posted": "2017-07-11T13:06:43.660000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1101 14th Street, NW", "registrant_address_2": "Suite 350", "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20005", "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": 119036, "url": "https://lda.senate.gov/api/v1/clients/119036/", "client_id": 1003391, "name": "CITY OF SAN BUENAVENTURA", "general_description": "Public services", "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": "2016-02-01"}, "lobbying_activities": [{"general_issue_code": "CAW", "general_issue_code_display": "Clean Air and Water (quality)", "description": "H.R. 645/S. 692 Water Quality Improvement Act/Water Infrastructure Flexibility Act\nIntegrated Permit Plans\nImplementation of WIIN water recycling project assistance programs\nH.R. 2510, Water Protection and Job Creation Act, renewal of clean water SRF program and water recycling assistance", "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": 149, "name": "Bureau of Reclamation"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Fiscal Year 2018 Energy and Water Development Appropriations, Title XVI, competitive grants and WaterSMART, and basin studies funding,", "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": 149, "name": "Bureau of Reclamation"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "NAT", "general_issue_code_display": "Natural Resources", "description": "Basin studies and ecosystem protection policy and program assistance", "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": 149, "name": "Bureau of Reclamation"}, {"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 10.105ms