home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 38f9d66d-b039-4b5b-80b6-8d12a44b97d0

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
38f9d66d-b039-4b5b-80b6-8d12a44b97d0 Q2 49511 RELX INC. 156227 RELX INC 2022 second_quarter 2022-07-14T11:49:59-04:00 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/38f9d66d-b039-4b5b-80b6-8d12a44b97d0/", "filing_uuid": "38f9d66d-b039-4b5b-80b6-8d12a44b97d0", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2022, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/38f9d66d-b039-4b5b-80b6-8d12a44b97d0/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "630000.00", "expenses_method": "A", "expenses_method_display": "A", "posted_by_name": "Becky Garcia", "dt_posted": "2022-07-14T11:49:59-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1150 18TH STREET, NW, #600", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20036", "registrant": {"id": 49511, "url": "https://lda.senate.gov/api/v1/registrants/49511/", "house_registrant_id": 34613, "name": "RELX INC.", "description": null, "address_1": "1150 18TH STREET, NW, #600", "address_2": null, "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": "JON BURTON", "contact_telephone": "+1 202-857-8235", "dt_updated": "2026-01-29T12:29:12.630273-05:00"}, "client": {"id": 156227, "url": "https://lda.senate.gov/api/v1/clients/156227/", "client_id": 12, "name": "RELX 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-09"}, "lobbying_activities": [{"general_issue_code": "CSP", "general_issue_code_display": "Consumer Issues/Safety/Products", "description": "Issues related to data security and consumer privacy protections. S 113, BROWSER Act of 2021, all provisions. HR 4258, Improving Digital Identity Act, all provisions. HR 6027, Online Privacy Act, all provisions. S 1628, Children & Teens Online Privacy Protection Act, all provisions. S 2499, SAFE DATA Act, all provisions. S 3195, Consumer Online Privacy Rights Act, all provisions. HR 8152, American Data Privacy and Protection Act, all provisions. HR 4259, Strengthening Digital Identity Act, all provisions. HR 4258, Improving Digital Identity Act, all provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "GOV", "general_issue_code_display": "Government Issues", "description": "HR 5844 / S 2614, Open Courts Act, all provisions. HR 6769, Pro Codes Act, all provisions. Issues relating to use of facial recognition technology for government services.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "Issues related to copyright, including support for strong US intellectual property laws, and a reduction in piracy of copyrighted materials. S 1260, US Innovation & Competition Act, provision regarding copyright. HR 4521, America COMPETES Act, provisions regarding copyright.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 66169, "prefix": null, "prefix_display": null, "first_name": "KAREN", "nickname": null, "middle_name": null, "last_name": "MARANGI", "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": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Issues related to cross-border data transfers. Issues related to digital trade and intellectual property issues in the trade agreements. Copyright provisions in the proposed TRIPS waiver at WTO. S 1260, US Innovation & Competition Act, provisions regarding copyright. EU-US Joint Technology Competition Policy Dialogue. HR 4521, America COMPETES Act, provisions regarding copyright. Monitoring issues related to HR 7185, Federal Contracting for Peace and Security Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 66169, "prefix": null, "prefix_display": null, "first_name": "KAREN", "nickname": null, "middle_name": null, "last_name": "MARANGI", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "FIN", "general_issue_code_display": "Financial Institutions/Investments/Securities", "description": "Issues related to consumer reporting for the unbanked and underbanked. Issues related to algorithmic bias and algorithmic discrimination. Issues related to the used of Artificial Intelligence in financial services.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "LBR", "general_issue_code_display": "Labor Issues/Antitrust/Workplace", "description": "Unemployment insurance, issues related to program integrity.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "S 1265, Fourth Amendment is Not For Sale Act, all provisions. Issues related to the provision of data to DHS.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "MED", "general_issue_code_display": "Medical/Disease Research/Clinical Labs", "description": "Issues related to US-UK Cancer Summit and Cancer Moonshot initiative.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138107, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "EVANS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 21, "name": "Office of Science & Technology Policy (OSTP)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "S 3917, Protecting Medicaid Beneficiaries Act of 2022, all provisions. Sec. 1940 of the Social Security Act, all provisions. Sec. 1902(e) of the Social Security Act, all provisions related to income determined using modified adjusted gross income. Sec. 1128(g) of the Social Security Act, provisions related to patient education in the Centers for Medicare and Medicaid Services Open Payments Program.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138107, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "EVANS", "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": "HCR", "general_issue_code_display": "Health Issues", "description": "Issues related to opioids. Issues related to the healthcare workforce. HR 8295, FY 23 Labor, HHS Appropriations bill: Sec. 510, provisions related to unique identifier ban and development of patient matching standards. Issues relating to consumer directed health information exchange, interoperability, and patient access to health information.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138107, "prefix": "ms", "prefix_display": "MS.", "first_name": "CHRISTINE", "nickname": null, "middle_name": null, "last_name": "EVANS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 19, "name": "Office of Natl Drug Control Policy (NDCP)"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to the need for post-pandemic economic relief for small businesses in the exhibitions and conferences business sector. Issues related to the need for an extension of the Employee Retention Tax Credit Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "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": "TOU", "general_issue_code_display": "Travel/Tourism", "description": "Issues relating to the need for legislation to support the issuance of event cancellation insurance due to communicable diseases. Issues relating to the need to address delays in visa issuance at US embassies and consulates. Issues relating to the need to cancel pre-flight Covid testing for international flights arriving in the US.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 33527, "prefix": null, "prefix_display": null, "first_name": "STEVEN", "nickname": null, "middle_name": null, "last_name": "EMMERT", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 34613 DC DC US US   0 0           630000.0

Links from other tables

  • 12 rows from filing_uuid in lobbying_activities
  • 3 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 0.531ms · Privacy