home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f4f35ad5-4bf7-44b7-89cf-ae781939abe9

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
f4f35ad5-4bf7-44b7-89cf-ae781939abe9 MM 9204 NOVARTIS 113305 NOVARTIS 2004 mid_year 2003-08-12T00:00:00-04:00 1479577.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f4f35ad5-4bf7-44b7-89cf-ae781939abe9/", "filing_uuid": "f4f35ad5-4bf7-44b7-89cf-ae781939abe9", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2004, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f4f35ad5-4bf7-44b7-89cf-ae781939abe9/print/", "filing_document_content_type": "application/pdf", "income": null, "expenses": "1479577.00", "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2003-08-12T00:00:00-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": "United States of America", "registrant_address_1": null, "registrant_address_2": null, "registrant_different_address": null, "registrant_city": null, "registrant_state": null, "registrant_zip": null, "registrant": {"id": 9204, "url": "https://lda.senate.gov/api/v1/registrants/9204/", "house_registrant_id": 33589, "name": "NOVARTIS", "description": "Federal Government Relations/Legislative Affairs", "address_1": "801 Pennsylvania Avenue, NW", "address_2": "Suite 700", "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": "COURTNEY PIRON", "contact_telephone": "+1 202-662-4364", "dt_updated": "2026-01-22T13:36:25.228154-05:00"}, "client": {"id": 113305, "url": "https://lda.senate.gov/api/v1/clients/113305/", "client_id": 12, "name": "NOVARTIS", "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": "2010-12-07"}, "lobbying_activities": [{"general_issue_code": "TRD", "general_issue_code_display": "Trade (domestic/foreign)", "description": "S970/HR1769, Job Protection Act of 2003\r\n\r\nEconomic Sanction\r\nSRM Ban/BSE\r\nChina/World Trade Organization\r\nFast Track Negotiating Authority\r\nCapital Market Sanctions\r\nChile and Singapore FTAs\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 10245, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "HALLER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15118, "prefix": null, "prefix_display": null, "first_name": "DEBORAH", "nickname": null, "middle_name": null, "last_name": "BUMBAUGH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17489, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "CASSERLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20150, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "ELKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29118, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "DRAKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "CPT", "general_issue_code_display": "Copyright/Patent/Trademark", "description": "S.1225, Greater Access to Affordable Pharmaceuticals Act", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 10245, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "HALLER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15118, "prefix": null, "prefix_display": null, "first_name": "DEBORAH", "nickname": null, "middle_name": null, "last_name": "BUMBAUGH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17489, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "CASSERLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20150, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "ELKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29118, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "DRAKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H.R.2218, Regulation of non corrective contact lens as medical devices\r\nS.1, Prescription Drug and Medicare Improvement Act of 2003\r\nH.R.1, Medicare Prescription Drug Modernization Act of 2003\r\nH.R.2427, Pharmaceutical Market Access Act of 2003\r\nHR1288/S1037, Access to Cancer Therapies Act of 2003\r\nS178, Comprehensive Immunosuppressive Drug Coverage for Transplant Patients Act of 2003\r\nS191/HR2223, Immunosuppressive Drug Coverage Act of 2003\r\nHR588, Medicare Fairness for Organ Transplant Recipients Act of 2003\r\nHR2356, Prescription Drug Comparative Effectiveness Act of 2003\r\nS.650/HR2857, Pediatric Research Equity Act of 2003\r\nHR2769, Save our Seniors Act of 2003\r\nHR2427 Pharmaceutical Market Access Act of 2003\r\nHR1170, Child Medication Safety Act of 2003\r\n\r\nMedicare Prescription Drugs\r\nBreaux/Thomas Medicare Reform Plan\r\nHealth Insurance Portability and Accessibility Act\r\nFDA Modernization Act\r\nMedical Records Privacy \u2013 Senators Jeffords, Bennett, Leahy, Kennedy Bills\r\nProspective Payment System\r\nGene Therapy\r\nDrug Reimportation\r\nMedicare Reform\r\nAgriculture appropriation 2001 \u2013 Drug Reimportation\r\nAgriculture appropriation 2001 (FDA funding)\r\nStem Cell Research\r\nPediatric Exclusivity\r\nDirect-to-Consumer Advertising\r\nThe Bipartisan Medicare Prescription Drug Act of 2001 (Sen. Kennedy-Draft Bill)\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 10245, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "HALLER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15118, "prefix": null, "prefix_display": null, "first_name": "DEBORAH", "nickname": null, "middle_name": null, "last_name": "BUMBAUGH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17489, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "CASSERLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20150, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "ELKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29118, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "DRAKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H.R.2218, Regulation of non corrective contact lens as medical devices\r\nS.1, Prescription Drug and Medicare Improvement Act of 2003\r\nH.R.1, Medicare Prescription Drug Modernization Act of 2003\r\nH.R.2427, Pharmaceutical Market Access Act of 2003\r\nHR1288/S1037, Access to Cancer Therapies Act of 2003\r\nS178, Comprehensive Immunosuppressive Drug Coverage for Transplant Patients Act of 2003\r\nS191/HR2223, Immunosuppressive Drug Coverage Act of 2003\r\nHR588, Medicare Fairness for Organ Transplant Recipients Act of 2003\r\nHR2356, Prescription Drug Comparative Effectiveness Act of 2003\r\nS.650, Pediatric Research Equity Act of 2003\r\nHR2769, Save our Seniors Act of 2003\r\nHR2427 Pharmaceutical Market Access Act of 2003\r\nHR2857, Pediatric Research Equity Act of 2003\r\nHR1170, Child Medication Safety Act of 2003\r\n\r\nMedicare Prescription Drugs & Modfernization Act\r\nThe Bipartisan Medicare Prescription Drug Act of 2001 (Sen. Kennedy-Draft Bill)\r\nProspective Payment System\r\nMedicare Reform\r\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 10245, "prefix": null, "prefix_display": null, "first_name": "SARAH", "nickname": null, "middle_name": null, "last_name": "HALLER", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 15118, "prefix": null, "prefix_display": null, "first_name": "DEBORAH", "nickname": null, "middle_name": null, "last_name": "BUMBAUGH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 17489, "prefix": null, "prefix_display": null, "first_name": "DANIEL", "nickname": null, "middle_name": null, "last_name": "CASSERLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 20150, "prefix": null, "prefix_display": null, "first_name": "JAMES", "nickname": null, "middle_name": null, "last_name": "ELKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 29118, "prefix": null, "prefix_display": null, "first_name": "DAVID", "nickname": null, "middle_name": null, "last_name": "DRAKE", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"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
  • 5 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 16.685ms