home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9cd1a3d1-c736-41ec-b596-e0e2a9b2264f

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
9cd1a3d1-c736-41ec-b596-e0e2a9b2264f Q1 401105181 INNOVATIVE POLICY, PLLC 206523 ORACLE AMERICA, INC. 2021 first_quarter 2021-04-19T16:08:00.380000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9cd1a3d1-c736-41ec-b596-e0e2a9b2264f/", "filing_uuid": "9cd1a3d1-c736-41ec-b596-e0e2a9b2264f", "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/9cd1a3d1-c736-41ec-b596-e0e2a9b2264f/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Matt Sandgren", "dt_posted": "2021-04-19T16:08:00.380000-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.senate.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.senate.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": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, provide advice on key policy issues important to Oracle, including procurement 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": "CPI", "general_issue_code_display": "Computer Industry", "description": "Raise awareness in Congress and the Administration regarding Oracle products and technology, provide advice on key policy issues important to Oracle, including procurement 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, provide advice on key policy issues important to Oracle, including procurement 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, provide advice on key policy issues important to Oracle, including procurement 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": []}

Links from other tables

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