home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 1fadef41-c7c9-4c40-9cff-5e56e533f887

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.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

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
1fadef41-c7c9-4c40-9cff-5e56e533f887 Q1 41454 WILLIAMS AND JENSEN, PLLC 151166 OGE ENERGY CORP 2022 first_quarter 2022-04-19T10:48:44-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/1fadef41-c7c9-4c40-9cff-5e56e533f887/", "filing_uuid": "1fadef41-c7c9-4c40-9cff-5e56e533f887", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2022, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/1fadef41-c7c9-4c40-9cff-5e56e533f887/print/", "filing_document_content_type": "text/html", "income": "80000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "TJ Hartten", "dt_posted": "2022-04-19T10:48:44-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1201 Pennsylvania Avenue, NW", "registrant_address_2": "Suite 800", "registrant_different_address": true, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 41454, "url": "https://lda.senate.gov/api/v1/registrants/41454/", "house_registrant_id": 30771, "name": "WILLIAMS AND JENSEN, PLLC", "description": "Lobbying Law Firm", "address_1": "1201 Pennsylvania Avenue, NW", "address_2": "Suite 800", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20004", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "ISABELLA QUINN", "contact_telephone": "+1 202-659-8201", "dt_updated": "2026-01-30T10:10:58.206597-05:00"}, "client": {"id": 151166, "url": "https://lda.senate.gov/api/v1/clients/151166/", "client_id": 595, "name": "OGE ENERGY CORP", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "OK", "state_display": "Oklahoma", "country": "US", "country_display": "United States of America", "ppb_state": "OK", "ppb_state_display": "Oklahoma", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2008-07-10"}, "lobbying_activities": [{"general_issue_code": "ENV", "general_issue_code_display": "Environment/Superfund", "description": "Listing of Lesser Prairie Chicken and American Burying Beetle by FWS under Endangered Species Act, EPA 111(d) proposal re: Greenhouse gas emissions from existing utility plants and 111 (b) proposal re: new utility plants; review of EPA regulations impacting utilities. Clean Future Act H.R. 1512. The Lift Act H.R. 1848. Clean Electricity Performance Program proposed in reconciliation bills and EV infrastructure proposed in infrastructure bills.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29747, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "D", "last_name": "BAKER", "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": "Taxation of MLPs. EV tax credit. Extension of expiring Indian Lands Accelerated Depreciation provision. Amendments to Production Tax Credit and Investment Tax Credit provisions of Internal Revenue Code to address normalization rules for utility investments in renewables, storage and transmission. PTC/ITC normalization relief for utility investments in solar, storage and transmission.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 43332, "prefix": "mr", "prefix_display": "MR.", "first_name": "CHRISTOPHER", "nickname": null, "middle_name": "W", "last_name": "HATCHER", "suffix": null, "suffix_display": null}, "covered_position": "Sch. C, Treasury; Associate Staff, House Rules Committee; LD, Rep. Scott McInnis", "new": false}, {"lobbyist": {"id": 29747, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "D", "last_name": "BAKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 35111, "prefix": "mr", "prefix_display": "MR.", "first_name": "DAVID", "nickname": null, "middle_name": "E", "last_name": "FRANASIAK", "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": "HOM", "general_issue_code_display": "Homeland Security", "description": "Cybersecurity and issues pertaining to utility resilience and energy service for military installations.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29747, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "D", "last_name": "BAKER", "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": "UTI", "general_issue_code_display": "Utilities", "description": "LIHEAP appropriations; Clean Future Act (HR 1512); LIFT Act (1848); utility provisions of American Rescue Plan Act (HR 1319); Clean energy provisions proposed in reconciliation bills (BBB) and electricity provisions recently enacted in the infrastructure bill (BIL).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29747, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "D", "last_name": "BAKER", "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": "IND", "general_issue_code_display": "Indian/Native American Affairs", "description": "Consideration of possible congressional response to concerns related to Supreme Courts decision in the McGirt case.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 29747, "prefix": "mr", "prefix_display": "MR.", "first_name": "GEORGE", "nickname": null, "middle_name": "D", "last_name": "BAKER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 2190, "prefix": null, "prefix_display": null, "first_name": "FRANK", "nickname": null, "middle_name": null, "last_name": "VLOSSAK", "suffix": null, "suffix_display": null}, "covered_position": "LA, Rep. Merrill Cook", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30771 OK OK US US   0 0         80000.0  

Links from other tables

  • 5 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.249ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API