home / lobbying / lobbying_filings_raw

lobbying_filings_raw: e5f2d6eb-4ee4-4c2d-b58e-d47fd48cbafe

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
e5f2d6eb-4ee4-4c2d-b58e-d47fd48cbafe Q4 288635 ADOBE INC 177222 ADOBE INC 2018 fourth_quarter 2019-01-16T14:47:58.317000-05:00 220000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/e5f2d6eb-4ee4-4c2d-b58e-d47fd48cbafe/", "filing_uuid": "e5f2d6eb-4ee4-4c2d-b58e-d47fd48cbafe", "filing_type": "Q4", "filing_type_display": "4th Quarter - Report", "filing_year": 2018, "filing_period": "fourth_quarter", "filing_period_display": "4th Quarter (Oct 1 - Dec 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/e5f2d6eb-4ee4-4c2d-b58e-d47fd48cbafe/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "220000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Russell H. Miller", "dt_posted": "2019-01-16T14:47:58.317000-05:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": "300 NEW JERSEY AVENUE, NW", "registrant_address_2": "Suite 900", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20001", "registrant": {"id": 288635, "url": "https://lda.senate.gov/api/v1/registrants/288635/", "house_registrant_id": 37080, "name": "ADOBE INC", "description": null, "address_1": "300 NEW JERSEY AVENUE, NW", "address_2": "Suite 900", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20001", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "RUSSELL H. MILLER", "contact_telephone": "+1 650-401-8735", "dt_updated": "2026-01-22T19:26:27.398114-05:00"}, "client": {"id": 177222, "url": "https://lda.senate.gov/api/v1/clients/177222/", "client_id": 12, "name": "ADOBE INC", "general_description": null, "client_government_entity": false, "client_self_select": true, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "DC", "ppb_state_display": "District of Columbia", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-20"}, "lobbying_activities": [{"general_issue_code": "HOM", "general_issue_code_display": "Homeland Security", "description": "Digital government and information security policy issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61443, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Accessibility law compliance, tools and regulations; privacy and cyber security issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "EDU", "general_issue_code_display": "Education", "description": "Support federal funding of technical and arts education -- STEM and STEAM initiatives.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CPI", "general_issue_code_display": "Computer Industry", "description": "Digital and electronic Federal government IT acquisition, information security issues, including electronic signatures, electronic workflows, consumer privacy, cyber security, improving citizen's online experience and privacy shield. In favor of HR 5759 and S 3050.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61443, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Digital trade issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "DEF", "general_issue_code_display": "Defense", "description": "Digital government, information security and recruiting issues inside FY2018 and FY 2019 National Defense Authorization Act (NDAA).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61443, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "In favor of FY 2019 House and Senate Defense, FSGG and Homeland Security Appropriations Bills; Information Technology acquisition, digital government and cyber security issues. Taxpayer savings associated with electronic signatures, electronic workflows and improving citizen's online experience.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61443, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Support for copyright enforcement and patent reform.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "GOV", "general_issue_code_display": "Government Issues", "description": "Digital government modernization and citizen facing digital service delivery; In favor of HR 2227 -- MGT Act and HR 2331 -- Connected Government Act. In favor of HR 5759 and S 3050.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 61443, "prefix": null, "prefix_display": null, "first_name": "MATT", "nickname": null, "middle_name": "SCOTT", "last_name": "SCHRADER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 53050, "prefix": null, "prefix_display": null, "first_name": "JACE", "nickname": null, "middle_name": null, "last_name": "JOHNSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 25, "name": "Defense, Dept of (DOD)"}, {"id": 65, "name": "General Services Administration (GSA)"}, {"id": 201, "name": "Homeland Security, Dept of (DHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 18, "name": "Office of Management & Budget (OMB)"}, {"id": 113, "name": "Patent & Trademark Office (PTO)"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 37080 DC DC US US   0 0 843   normalized_name_dc_fallback 0.8

Links from other tables

  • 9 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 10.994ms