home / lobbying / lobbying_filings_raw

lobbying_filings_raw: f1addf39-bef3-4e58-9e66-ae4e58f2fbf0

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
f1addf39-bef3-4e58-9e66-ae4e58f2fbf0 Q1 400693064 RED+BLUE STRATEGIES 194270 EXPRESS SCRIPTS INC. 2012 first_quarter 2012-04-11T16:29:49.920000-04:00 30000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/f1addf39-bef3-4e58-9e66-ae4e58f2fbf0/", "filing_uuid": "f1addf39-bef3-4e58-9e66-ae4e58f2fbf0", "filing_type": "Q1", "filing_type_display": "1st Quarter - Report", "filing_year": 2012, "filing_period": "first_quarter", "filing_period_display": "1st Quarter (Jan 1 - Mar 31)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/f1addf39-bef3-4e58-9e66-ae4e58f2fbf0/print/", "filing_document_content_type": "text/html", "income": "30000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Melanie Nathanson, Partner", "dt_posted": "2012-04-11T16:29:49.920000-04:00", "termination_date": null, "registrant_country": "United States of America", "registrant_ppb_country": null, "registrant_address_1": "601 13th Street NW", "registrant_address_2": "11th Floor North", "registrant_different_address": false, "registrant_city": "Washington", "registrant_state": "DC", "registrant_zip": "20005", "registrant": {"id": 400693064, "url": "https://lda.senate.gov/api/v1/registrants/400693064/", "house_registrant_id": null, "name": "RED+BLUE STRATEGIES", "description": "Health Care Consulting", "address_1": "975 F St NW", "address_2": "Suite 550", "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": "MELANIE NATHANSON", "contact_telephone": "+1 202-258-9381", "dt_updated": "2026-02-25T17:01:10.141217-05:00"}, "client": {"id": 194270, "url": "https://lda.senate.gov/api/v1/clients/194270/", "client_id": 12, "name": "EXPRESS SCRIPTS INC.", "general_description": "Pharmacy Benefit Manager", "client_government_entity": false, "client_self_select": false, "state": "DC", "state_display": "District of Columbia", "country": "US", "country_display": "United States of America", "ppb_state": "MO", "ppb_state_display": "Missouri", "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-01-14"}, "lobbying_activities": [{"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "Implementation of the Health Reform Law with a focus on regulations related to the medical loss ratio (MLR), Accountable Care Organizations, Transparency, E-prescribing, Health Information Technology, and Essential Health Benefits.\n\nReauthorization of the Prescription Drug User Fee Act, specifically issues related to track and trace policies and exclusivity. Issues related to pathways for biogenerics in both domestic and international arenas.\n\nProposed OPM-focused policies in the Administration's 2013 Budget related to the utilization of Pharmacy Benefit Managers.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54544, "prefix": "ms", "prefix_display": "MS.", "first_name": "MELANIE", "nickname": null, "middle_name": "JAN", "last_name": "NATHANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145382, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "HAUCK", "last_name": "MARSHALL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"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": "H.R. 3630 (S. Amdt 1465) Temporary Payroll Tax Cut Continuation Act of 2011-12 - Tracking Medicare offsets\nMonitoring ongoing Medicare and Medicaid regulations and guidance related to prescription medications, PBMs and related entities.\nMonitoring potential health-related offsets being considered as part of the deficit reduction package related to Medicare Part D and Medicaid pharmacy benefits.", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54544, "prefix": "ms", "prefix_display": "MS.", "first_name": "MELANIE", "nickname": null, "middle_name": "JAN", "last_name": "NATHANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145382, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "HAUCK", "last_name": "MARSHALL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"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": "H.R. 1946 - Preserving Our Hometown Independent Pharmacies Act of 2011, which creates and antitrust exemption for certain pharmacies.\n\nRules, regulations and guidance specific to prescription drug pricing, generic utilization and specialty pharmacy. Issues impacting PBMs included in the Prescription Drug User Fee Act reauthorization and the Generic Drug User Fee Reauthorization", "foreign_entity_issues": "", "lobbyists": [{"lobbyist": {"id": 54544, "prefix": "ms", "prefix_display": "MS.", "first_name": "MELANIE", "nickname": null, "middle_name": "JAN", "last_name": "NATHANSON", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}, {"lobbyist": {"id": 145382, "prefix": "ms", "prefix_display": "MS.", "first_name": "MEGAN", "nickname": null, "middle_name": "HAUCK", "last_name": "MARSHALL", "suffix": null, "suffix_display": null}, "covered_position": null, "new": false}], "government_entities": [{"id": 136, "name": "Centers For Medicare and Medicaid Services (CMS)"}, {"id": 11, "name": "Executive Office of the President (EOP)"}, {"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": []}

Links from other tables

  • 3 rows from filing_uuid in lobbying_activities
  • 2 rows from filing_uuid in lobbying_lobbyists
Powered by Datasette · Queries took 1.058ms