home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f7e48ba2-84a7-4488-b73b-05bf287cff7f

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
f7e48ba2-84a7-4488-b73b-05bf287cff7f MM 39815 VAN NESS FELDMAN, LLP 147369 MCKESSON CORPORATION 2007 mid_year 2007-08-10T15:05:36-04:00 100000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f7e48ba2-84a7-4488-b73b-05bf287cff7f/", "filing_uuid": "f7e48ba2-84a7-4488-b73b-05bf287cff7f", "filing_type": "MM", "filing_type_display": "Mid-Year Report", "filing_year": 2007, "filing_period": "mid_year", "filing_period_display": "Mid-Year (Jan 1 - Jun 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f7e48ba2-84a7-4488-b73b-05bf287cff7f/print/", "filing_document_content_type": "application/pdf", "income": "100000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": null, "dt_posted": "2007-08-10T15:05:36-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": 39815, "url": "https://lda.senate.gov/api/v1/registrants/39815/", "house_registrant_id": 30171, "name": "VAN NESS FELDMAN, LLP", "description": "Law and Public Policy Firm", "address_1": "2000 Pennsylvania Ave.", "address_2": "Suite 6000", "address_3": null, "address_4": null, "city": "Washington", "state": "DC", "state_display": "District of Columbia", "zip": "20006", "country": "US", "country_display": "United States of America", "ppb_country": "US", "ppb_country_display": "United States of America", "contact_name": "CARLOS FLORES", "contact_telephone": "+1 202-298-1800", "dt_updated": "2026-01-27T11:35:35.887938-05:00"}, "client": {"id": 147369, "url": "https://lda.senate.gov/api/v1/clients/147369/", "client_id": 315, "name": "MCKESSON CORPORATION", "general_description": null, "client_government_entity": false, "client_self_select": null, "state": "CA", "state_display": "California", "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-10"}, "lobbying_activities": [{"general_issue_code": "TAX", "general_issue_code_display": "Taxation/Internal Revenue Code", "description": "\r\nLegislation regarding potential LIFO repeal", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "\r\nS.1082, Food and Drug Administration Revitalization Act \nS. 1695, Biologics Price Competition and Innovation Act of 2007\nS. 1693, Wired for Health Care Quality Act\nH.R. 1368, Personalized Health Information Act of 2007\nS. 1783, Ten Steps to Transform Health Care in America Act\nS. 321, Fostering Independence Through Technology Act of 2007\nH.R. 2791, Unique Device Identification System for Medical Devices Act of 2007\n\r\nH.R. 2991, Independent Health Record Trust Act of 2007\nS. 1456, Federal Employees Electronic Personal Health Records Act of 2007\nS. 63, Remote Monitoring Access Act of 2007\nH.R. 2900, Food and Drug Administration Amendments Act of 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "\r\nS. 3, Medicare Prescription Drug Price Negotiation Act of 2007 \nH.R. 4, Medicare Prescription Drug Price Negotiation Act of 2007\nH.R. 1474, Fair and Speedy Treatment (FAST) of Medicare Prescription Drug Claims Act of 2007\nS. 1544, Medicare Quality Enhancement Act of 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "BUD", "general_issue_code_display": "Budget/Appropriations", "description": "\r\nS. 1710, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008\nH.R. 2206, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007\nS. 2107, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007\nH.R. 1591, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007\nS. 965, U.S. Troop Readiness, Veterans' Care, Katrina Recovery, and Iraq Accountability Appropriations Act, 2007\nH.J. Res. 20, Revised Continuing Appropriations Resolution, 2007\r\nH.R. 2642, Military Construction and Veterans Affairs Appropriations Act, 2008\nS. 1645, Military Construction and Veterans Affairs Appropriations Act, 2008\nH.R. 3043, Departments of Labor, Health and Human Services, and Education, and Related Agencies Appropriations Act, 2008\n", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "PHA", "general_issue_code_display": "Pharmacy", "description": "\r\nS. 980, Online Pharmacy Consumer Protection Act of 2007\nH.R. 971, Community Pharmacy Fairness Act of 2007\nS. 885, Community Pharmacy Fairness Act of 2007\n\r\nS. 242, Pharmaceutical Market Access and Drug Safety Act of 2007\nH.R. 380, Pharmaceutical Market Access and Drug Safety Act of 2007\nS. 251, Pharmaceutical Market Access Act of 2007\nS. 596, Safe Internet Pharmacy Act of 2007", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "VET", "general_issue_code_display": "Veterans", "description": "\r\nEducation regarding the Department of Veterans Affairs Pharmaceutical Prime Vendor contract", "foreign_entity_issues": null, "lobbyists": [{"lobbyist": {"id": 3896, "prefix": null, "prefix_display": null, "first_name": "JOHN", "nickname": null, "middle_name": null, "last_name": "IANI", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5704, "prefix": null, "prefix_display": null, "first_name": "MEREDITH", "nickname": null, "middle_name": null, "last_name": "CHAMBERS", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 5711, "prefix": null, "prefix_display": null, "first_name": "CHRISTOPHER", "nickname": null, "middle_name": null, "last_name": "BOHANON", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 6238, "prefix": null, "prefix_display": null, "first_name": "JORDAN", "nickname": null, "middle_name": null, "last_name": "SMITH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 22909, "prefix": "mr", "prefix_display": "MR.", "first_name": "RICHARD", "nickname": null, "middle_name": "A", "last_name": "AGNEW", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 33231, "prefix": "mr", "prefix_display": "MR.", "first_name": "HOWARD", "nickname": null, "middle_name": "J", "last_name": "FELDMAN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43688, "prefix": null, "prefix_display": null, "first_name": "J", "nickname": null, "middle_name": "CURTIS", "last_name": "RICH", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 43744, "prefix": "mr", "prefix_display": "MR.", "first_name": "BEN", "nickname": null, "middle_name": "LEE", "last_name": "MCMAKIN", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}, {"lobbyist": {"id": 143887, "prefix": "mrs", "prefix_display": "MRS.", "first_name": "NANCY", "nickname": null, "middle_name": "MACAN", "last_name": "MCNALLY", "suffix": null, "suffix_display": null}, "covered_position": "N/A", "new": null}], "government_entities": [{"id": 34, "name": "Health & Human Services, Dept of (HHS)"}, {"id": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []} DC US 30171 CA   US US   0 0 1498   normalized_name 0.7

Links from other tables

  • 6 rows from filing_uuid in lobbying_activities
  • 9 rows from filing_uuid in lobbying_lobbyists
  • 0 rows from filing_uuid in lobbying_affiliated_orgs
Powered by Datasette · Queries took 182.859ms