home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 718772aa-eecf-4d8c-88bf-cd2fa3f455aa

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
718772aa-eecf-4d8c-88bf-cd2fa3f455aa Q1 41454 WILLIAMS AND JENSEN, PLLC 151341 MERCK & CO INC 2020 first_quarter 2020-04-17T16:20:51.220000-04:00 80000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/718772aa-eecf-4d8c-88bf-cd2fa3f455aa/", "filing_uuid": "718772aa-eecf-4d8c-88bf-cd2fa3f455aa", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2020, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/718772aa-eecf-4d8c-88bf-cd2fa3f455aa/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": "2020-04-17T16:20:51.220000-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": 151341, "url": "https://lda.senate.gov/api/v1/clients/151341/", "client_id": 3654, "name": "MERCK & CO INC", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2007-08-14"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "Issues related to corporate tax including international tax proposals: Implementation of the Tax Cuts and Jobs Act (P.L. 115-97).", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"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": null, "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14682, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "HIRSCHMANN", "suffix": null, "suffix_display": null}, "covered_position": "COS, Rep Van Hilleary and Majority Whip", "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "ANI", "general_issue_code_display": "Animals", "description": "Monitor issues as they relate to animal health . Issues concerning the Animal Drug User Fee Act.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": "Staff, Senate Special Committee on Aging; Staff, Senate Committee on Government Affairs; Senate Committees on Aging and Gov Affairs.", "new": false}, {"lobbyist": {"id": 65545, "prefix": null, "prefix_display": null, "first_name": "SCOTT", "nickname": null, "middle_name": null, "last_name": "GRAVES", "suffix": null, "suffix_display": null}, "covered_position": "Deputy Chief of Staff, Rep Conaway; COS, Rep Farenthold, COS, Rep Conaway; Staff Director, House Ag Committee", "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": "Shrd employee, Ofc of the Speaker & Ofc of VA 7; Sr Plicy Adv, Maj Leader, Rep Cantor; Sr. Policy Adv, Rep Whip, Rep Cantor; Sr. Policy Adv, Maj Whip, Rep Blunt; Prof Staff House Committee on E&C; Sr LA to Rep Cox", "new": false}, {"lobbyist": {"id": 68922, "prefix": null, "prefix_display": null, "first_name": "MATTHEW", "nickname": null, "middle_name": "S", "last_name": "VALESKO", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "International trade issues and agreements; Monitor pending trade issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"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": null, "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": "Shared employee, Ofc of the Speaker & Ofc of VA 07; Sr Policy Adv, Maj Leader, Rep. Cantor; Sr Policy Adv, Republican Whip, Rep. Cantor; Sr Policy Adv, Majority Whip, Rep. Blunt; Prof Staff House Committee on E & C; Sr LA to Rep. Cox", "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Policies impacting Medicare Part D. Drug Development and Public Health Preparedness. Policies impacting U.S. address to the Covid-19 pandemic, including H.R. 604 Coronavirus Preparedness and Response Supplemental Appropriations Act, Public Law No: 116-123.; H. R . 6201 Families First Coronavirus Response Act, Public Law No: 116-127; and H. R. 748 CARES Act, Public Law No: 116-136.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": "Staff, Senate Special Committee on Aging; Staff, Senate Committee on Government Affairs; Senate Committees on Aging and Government Affairs", "new": false}, {"lobbyist": {"id": 14682, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "HIRSCHMANN", "suffix": null, "suffix_display": null}, "covered_position": "COS, Rep Van Hilleary and Majority Whip", "new": false}, {"lobbyist": {"id": 48784, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "HOEKSTRA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": "Shrd employee, Ofc of the Speaker & Ofc of VA 7;Sr policy adv, Maj Leader, Rep Cantor; Sr. Policy Adv, Rep Whip, Rep Cantor; Sr. Policy Adv, Maj Whip, Rep Blunt; Prof Staff House Committee on E&C; Sr. LA to Rep Cox", "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Drug safety; Congressional oversight issues; Issues related to vaccines and drug pricing; Drug pricing under 340B program; General education about FDA approval policies. S. 2543, Prescription Drug Pricing Reduction Act (PDPRA) of 2019 and H.R. 3, Lower Drug Costs Now Act of 2019. Policies impacting U.S. address to the Covid-19 pandemic, including H.R. 604 Coronavirus Preparedness and Response Supplemental Appropriations Act, Public Law No: 116-123.; H. R . 6201 Families First Coronavirus Response Act, Public Law No: 116-127; and H. R. 748 CARES Act, Public Law No: 116-136.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14682, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "HIRSCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "Payment policies for Part B prescription drugs; Rebates and co-pays for Medicare Part D drug benefits; Possible revisions in structure and operation of Medicare and Medicaid drug policies. S. 2543, Prescription Drug Pricing Reduction Act (PDPRA) of 2019 and H.R. 3, Lower Drug Costs Now Act of 2019. Policies impacting U.S. address to the Covid-19 pandemic, including H.R. 604 Coronavirus Preparedness and Response Supplemental Appropriations Act, Public Law No: 116-123.; H. R . 6201 Families First Coronavirus Response Act, Public Law No: 116-127; and H. R. 748 CARES Act, Public Law No: 116-136.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 37173, "prefix": null, "prefix_display": null, "first_name": "KARINA", "nickname": null, "middle_name": null, "last_name": "LYNCH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 14682, "prefix": null, "prefix_display": null, "first_name": "SUSAN", "nickname": null, "middle_name": null, "last_name": "HIRSCHMANN", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 48784, "prefix": "mr", "prefix_display": "MR.", "first_name": "MATTHEW", "nickname": null, "middle_name": "B", "last_name": "HOEKSTRA", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61426, "prefix": null, "prefix_display": null, "first_name": "CHERYL", "nickname": null, "middle_name": "LYNN", "last_name": "JAEGER", "suffix": null, "suffix_display": null}, "covered_position": "Shared employee, Ofc of the Speaker and Ofc of VA 7th; Sr Policy Advisor, Majority Leader, Rep. Eric Cantor; Sr. Advisor, Majority Whip, Rep Roy Blunt; Prof Staff House Committee on E&C; Sr LA to Rep. Christopher Cox", "new": false}], "government_entities": [{"id": 135, "name": "Food & Drug Administration (FDA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 12, "name": "White House Office"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 7 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 32.009ms