home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 9d65d710-4644-4d36-8eef-57ce6ac00a1c

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
9d65d710-4644-4d36-8eef-57ce6ac00a1c Q1 7053 BRISTOL-MYERS SQUIBB COMPANY 109642 BRISTOL-MYERS SQUIBB COMPANY 2018 first_quarter 2018-04-18T18:34:41.057000-04:00 800000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/9d65d710-4644-4d36-8eef-57ce6ac00a1c/", "filing_uuid": "9d65d710-4644-4d36-8eef-57ce6ac00a1c", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2018, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/9d65d710-4644-4d36-8eef-57ce6ac00a1c/print/", "filing_document_content_type": "text/html", "income": null, "expenses": "800000.00", "expenses_method": "a", "expenses_method_display": "Method A - Reporting amounts using LDA definitions only", "posted_by_name": "Chris Pernie", "dt_posted": "2018-04-18T18:34:41.057000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "801 Pennsylvania Ave, NW, Suite 325", "registrant_address_2": null, "registrant_different_address": false, "registrant_city": "WASHINGTON", "registrant_state": "DC", "registrant_zip": "20004", "registrant": {"id": 7053, "url": "https://lda.senate.gov/api/v1/registrants/7053/", "house_registrant_id": 31580, "name": "BRISTOL-MYERS SQUIBB COMPANY", "description": "Lobbying on biopharmaceutical issues.", "address_1": "801 Pennsylvania Ave, NW, Suite 745", "address_2": null, "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": "LAURA DAVIS EIDSON", "contact_telephone": "+1 727-519-5721", "dt_updated": "2026-01-30T12:07:02.522051-05:00"}, "client": {"id": 109642, "url": "https://lda.senate.gov/api/v1/clients/109642/", "client_id": 12, "name": "BRISTOL-MYERS SQUIBB COMPANY", "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": "2013-05-21"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "Lobbied regarding intellectual property rights in trade agreements and international negotiations.\nSaudi Arabia, Saudi Food and Drug Authority, lobbied Congress regarding pharmaceutical patent infringement issues.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "H.R. 1, Tax Cuts and Jobs Act, regarding all pharmaceutical related provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "No bill, lobbied on patent troll issues regarding biopharmaceutical patents.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "No bill, lobbied to raise awareness about Atrial Fibrillation and stroke prevention.\nNo bill, lobbied regarding biosimilars issues including naming, labeling and interchangeability.\nH.R. 1245 and S. 469, Affordable and Safe Prescription Drug Importation Act, lobbied regarding all biopharmaceutical provisions.\nH.R. 1703, Medical Product Communications Act of 2017, regarding all biopharmaceutical related provisions\nH.R. 2851, Stop the Importation and Trafficking of Synthetic Analogues Act of 2017, regarding all biopharmaceutical related provisions\nNo bill, lobbied for changes to the 340B Drug Discount Program.\nH.R. 4710, 340B PAUSE Act, lobbied regarding all biopharmaceutical provisions.\nH.R. 4392, a bill to repeal the HOPPS final regulation related to changes in the payment amount for certain drugs under the 340B program, lobbied regarding all biopharmaceutical provisions.\nH.R. 2026, the Pharmaceutical Information Exchange (PIE) Act of 2017, lobbied regarding all biopharmaceutical provisions.\nS. 2312, Helping Ensure Low-Income Patients have Access to Care and Treatment (HELP) Act, regarding all pharmaceutical related provisions.\nS.2453, Ensuring the Value of the 340B Program Act of 2018, regarding all pharmaceutical related provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H.R. 849, S. 260, S. 251 Protecting Seniors Access to Medicare Act, lobbied regarding all biopharmaceutical related provisions.\nS.771, Improving Access To Affordable Prescription Drugs Act, lobbied regarding all biopharmaceutical related provisions. \nS.348, Prescription Drug and Health Improvement Act of 2017, lobbied regarding all biopharmaceutical related provisions.\nS.637, Creating Transparency to Have Drug Rebates Unlocked (C-THRU) Act of 2017, lobbied regarding all biopharmaceutical related provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "American Health Care Act, regarding all biopharmaceutical related provisions.\nContinuing Budget Resolution, lobbied regarding all biopharmaceutical provisions.\nBetter Care Reconciliation Act, regarding all biopharmaceutical related provisions.\nS. 1771, Department of Labor, HHS and Education Appropriations Act, regarding all pharmaceutical related provisions.\nH.R. 1625, Consolidates Appropriations Act, regarding all pharmaceutical related provisions.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 138136, "prefix": "mr", "prefix_display": "MR.", "first_name": "PAUL", "nickname": null, "middle_name": "ANTHONY", "last_name": "WILLIAMS", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 39456, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "PERNIE", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 36053, "prefix": null, "prefix_display": null, "first_name": "LANE", "nickname": null, "middle_name": null, "last_name": "PENRY", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 24, "name": "Commerce, Dept of (DOC)"}, {"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 137, "name": "Health Resources & Services Administration (HRSA)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}, {"id": 22, "name": "U.S. Trade Representative (USTR)"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 31580 DC DC US US   0 0 63   normalized_name_dc_fallback 0.8

Links from other tables

  • 6 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 1.384ms