lobbying_filings_raw: c3aa6e11-a051-42d7-be3a-73699785b5c2

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. Sortable columns (indexed): filing_type, client_name, filing_year, client_state, registrant_state, registrant_house_id, registrant_id. Sorting on any other column returns HTTP 400 (2026-09-04, #697) — use ?sql= with your own ORDER BY if you need it.

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
c3aa6e11-a051-42d7-be3a-73699785b5c2	Q3	401105181	INNOVATIVE POLICY, PLLC	206523	ORACLE AMERICA, INC.	2025	third_quarter	2025-10-16T16:49:05-04:00	0	0	0	{"url": "https://lda.gov/api/v1/filings/c3aa6e11-a051-42d7-be3a-73699785b5c2/", "filing_uuid": "c3aa6e11-a051-42d7-be3a-73699785b5c2", "filing_type": "Q3", "filing_type_display": "3rd Quarter - Report", "filing_year": 2025, "filing_period": "third_quarter", "filing_period_display": "3rd Quarter (July 1 - Sep 30)", "filing_document_url": "https://lda.gov/filings/public/filing/c3aa6e11-a051-42d7-be3a-73699785b5c2/print/", "filing_document_content_type": "text/html", "income": "70000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Matt Sandgren", "dt_posted": "2025-10-16T16:49:05-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "PO Box 7247", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20044", "registrant": {"id": 401105181, "url": "https://lda.gov/api/v1/registrants/401105181/", "house_registrant_id": null, "name": "INNOVATIVE POLICY, PLLC", "description": "Professional services", "address_1": "PO Box 7247", "address_2": null, "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20044", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "MATT SANDGREN", "contact_telephone": "+1 703-599-1029", "dt_updated": "2026-01-28T11:44:35.502929-05:00"}, "client": {"id": 206523, "url": "https://lda.gov/api/v1/clients/206523/", "client_id": 48, "name": "ORACLE AMERICA, INC.", "general_description": "Technology company.", "client_government_entity": false, "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": "2020-07-22"}, "lobbying_activities": [{"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-2019); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-2019); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-2019); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-2019); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-19); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "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": "Raise awareness in Congress and the Administration regarding Oracle products and technology, and provide advice on key policy issues important to Oracle, including procurement policy, tax policy, technology policy, and intellectual property policy.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 70133, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": null, "last_name": "SANDGREN", "suffix": null, "suffix_display": null}, "covered_position": "Chief of Staff, Sen. Orrin G. Hatch (2016-2019); Sr. Counsel and Counsel, US Senate Committee on the Judiciary (2007-16); Legislative Assistant, Sen. Orrin G. Hatch (2005-07); and, Legislative Correspondent-Aide, Sen. Orrin G. Hatch (2003-05)", "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}	DC	US		CA	CA	US	US	Technology company.	0	0					70000.0

Links from other tables

12 rows from filing_uuid in lobbying_activities
2 rows from filing_uuid in lobbying_lobbyists
0 rows from filing_uuid in lobbying_affiliated_orgs