home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f26ce0f8-49f7-42fb-8da2-e4e3ed9d466b

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
f26ce0f8-49f7-42fb-8da2-e4e3ed9d466b Q2 304736 TARPLIN, DOWNS & YOUNG, LLC 181309 ABBVIE INC. 2017 second_quarter 2017-07-18T12:15:48.970000-04:00 60000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f26ce0f8-49f7-42fb-8da2-e4e3ed9d466b/", "filing_uuid": "f26ce0f8-49f7-42fb-8da2-e4e3ed9d466b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2017, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f26ce0f8-49f7-42fb-8da2-e4e3ed9d466b/print/", "filing_document_content_type": "text/html", "income": "60000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Jennifer B. Young", "dt_posted": "2017-07-18T12:15:48.970000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "1212 New York Avenue, NW", "registrant_address_2": "Suite 1050", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 304736, "url": "https://lda.senate.gov/api/v1/registrants/304736/", "house_registrant_id": 38067, "name": "TARPLIN, DOWNS & YOUNG, LLC", "description": "Health care policy and regulatory and legislative consulting", "address_1": "1212 New York Avenue, NW", "address_2": "Suite 750", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20005", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "JENNIFER B. YOUNG", "contact_telephone": "", "dt_updated": "2026-01-29T13:56:13.803090-05:00"}, "client": {"id": 181309, "url": "https://lda.senate.gov/api/v1/clients/181309/", "client_id": 1005142, "name": "ABBVIE INC.", "general_description": "Abbvie is a global biopharmaceutical company focused on developing leading-edge therapies.", "client_government_entity": false, "client_self_select": false, "state": "IL", "state_display": "Illinois", "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": "2013-07-15"}, "lobbying_activities": [{"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "patent issues", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7749, "prefix": null, "prefix_display": null, "first_name": "RAISSA", "nickname": null, "middle_name": "H", "last_name": "DOWNS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 26124, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43625, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": "P", "last_name": "EASTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61537, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": "T", "last_name": "MURRAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64513, "prefix": null, "prefix_display": null, "first_name": "CHARLOTTE", "nickname": null, "middle_name": "SPEARS", "last_name": "IVANCIC", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65078, "prefix": null, "prefix_display": null, "first_name": "PAMELA", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "PL114-255 - 21st Century Cures, implementation\nH.R. 1231/S. 456 - RACE for Children Act\nH.R 1628 - American Health Care Act of 2017\nS. 771 - Improving Access to Affordable Prescription Drugs Act\nS. 637 - Creating Transparency to Have Drug Rebates Unlocked Act of 2017\nStopping the Pharmaceutical Industry From Keeping Drugs Expensive Act of 2017\nS. 469 - Affordable and Safe Prescription Drug Importation act\nH.R. 749 - Lower Drug Costs Through Competition Act\nH.R. 2430 - FDA Reauthorization Act of 2017\nBetter Care Reconciliation Act of 2017\n\nno specific bill - FDA implementation issues, 340B, biosimilars, prescription drug user fee reauthorization, non-interference, patient assistance", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7749, "prefix": null, "prefix_display": null, "first_name": "RAISSA", "nickname": null, "middle_name": "H", "last_name": "DOWNS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 26124, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43625, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": "P", "last_name": "EASTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61537, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": "T", "last_name": "MURRAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64513, "prefix": null, "prefix_display": null, "first_name": "CHARLOTTE", "nickname": null, "middle_name": "SPEARS", "last_name": "IVANCIC", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65078, "prefix": null, "prefix_display": null, "first_name": "PAMELA", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "discount programs, hepatitis C, Sunshine, pipeline, biosimilars, Part B demonstration, Part D, Noninterference\n\nS. 251 - Protecting Medicare from Executive Action of 2017\nS. 260/H.R. 849 - Protecting Seniors' Access to Medicare Act of 2017\nH.J.Res. 51/S.J.Res. 16 - IPAB discontinuation\nS. 41 - Medicare Prescription Drug Price Negotiation Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 26124, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 43625, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": "P", "last_name": "EASTON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 61537, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": "T", "last_name": "MURRAY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 64513, "prefix": null, "prefix_display": null, "first_name": "CHARLOTTE", "nickname": null, "middle_name": "SPEARS", "last_name": "IVANCIC", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 65078, "prefix": null, "prefix_display": null, "first_name": "PAMELA", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "Budget resolution, reconciliation, deficit reduction, debt ceiling, appropriations\nS.Con.Res. 3 - Senate budget resolution\nH.R. 244 - Consolidated Appropriations Act of 2017", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 7749, "prefix": null, "prefix_display": null, "first_name": "RAISSA", "nickname": null, "middle_name": "H", "last_name": "DOWNS", "suffix": null, "suffix_display": null}, "covered_position": "Prin. Dep. Asst. Sec. for Leg. - HHS; Dep. Asst. Sec. for Leg. - HHS; Staff Dir., Sub. Cmte. on Employment, Sen. HELP Cmte.", "new": false}, {"lobbyist": {"id": 26124, "prefix": null, "prefix_display": null, "first_name": "JENNIFER", "nickname": null, "middle_name": "B", "last_name": "YOUNG", "suffix": null, "suffix_display": null}, "covered_position": "Asst. Sec. for Leg. - HHS; Dep. Asst. Sec. for Leg. - HHS; Cmte. Staff, House Cmte. on Ways and Means; Cmte. Staff, Sen. Cmte. on Finance", "new": false}, {"lobbyist": {"id": 43625, "prefix": null, "prefix_display": null, "first_name": "MICHELLE", "nickname": null, "middle_name": "P", "last_name": "EASTON", "suffix": null, "suffix_display": null}, "covered_position": "Chief Health Counsel, Sen. Cmte. on Finance; Staff Dir., Senate Aging Cmte.; Leg. Asst., Congressman Billy Tauzin", "new": false}, {"lobbyist": {"id": 61537, "prefix": null, "prefix_display": null, "first_name": "ELIZABETH", "nickname": null, "middle_name": "T", "last_name": "MURRAY", "suffix": null, "suffix_display": null}, "covered_position": "Senior Policy Advisor, Democratic Whip Steny Hoyer; Legislative Asst. for Rep. Mike Thompson, Rep. Bob Matsui, and Senator Bob Graham", "new": false}, {"lobbyist": {"id": 64513, "prefix": null, "prefix_display": null, "first_name": "CHARLOTTE", "nickname": null, "middle_name": "SPEARS", "last_name": "IVANCIC", "suffix": null, "suffix_display": null}, "covered_position": "Legislative Counsel, Senator Jim DeMint; Health Counsel, Majority Leader Bill Frist; Counsel and Budget Analyst, House Budget Committee; Asst. to the Speaker for Policy, Speaker John Boehner", "new": false}, {"lobbyist": {"id": 65078, "prefix": null, "prefix_display": null, "first_name": "PAMELA", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "Leg. Dir., Sen. Tom Harkin; Dep. Staff Dir., Senate HELP Cmte; Staff Dir., Senate HELP Cmte; Counselor to the Asst. AG, Civil Div., Dept of Justice; Spec Counsel, Ofc of Leg. Affairs, Dept of Justice; Counsel and LA, Senator Carol Moseley-Braun", "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"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
  • 6 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.293ms