home / lobbying / lobbying_filings_raw

lobbying_filings_raw: 7dfc0763-1dfa-4b85-b2ec-1c2fdf2f7a0b

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
7dfc0763-1dfa-4b85-b2ec-1c2fdf2f7a0b Q2 400693064 RED+BLUE STRATEGIES 194277 DAVITA INC. 2020 second_quarter 2020-07-03T15:12:07.547000-04:00 70000.0 0 0 0 {"url": "https://lda.senate.gov/api/v1/filings/7dfc0763-1dfa-4b85-b2ec-1c2fdf2f7a0b/", "filing_uuid": "7dfc0763-1dfa-4b85-b2ec-1c2fdf2f7a0b", "filing_type": "Q2", "filing_type_display": "2nd Quarter - Report", "filing_year": 2020, "filing_period": "second_quarter", "filing_period_display": "2nd Quarter (Apr 1 - June 30)", "filing_document_url": "https://lda.senate.gov/filings/public/filing/7dfc0763-1dfa-4b85-b2ec-1c2fdf2f7a0b/print/", "filing_document_content_type": "text/html", "income": "70000.00", "expenses": null, "expenses_method": null, "expenses_method_display": null, "posted_by_name": "Melanie Nathanson", "dt_posted": "2020-07-03T15:12:07.547000-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": "Suite 290 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": 194277, "url": "https://lda.senate.gov/api/v1/clients/194277/", "client_id": 90, "name": "DAVITA INC.", "general_description": "A leading provider of dialysis services in the United States.", "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": null, "ppb_state_display": null, "ppb_country": "US", "ppb_country_display": "United States of America", "effective_date": "2011-05-02"}, "lobbying_activities": [{"general_issue_code": "MMM", "general_issue_code_display": "Medicare/Medicaid", "description": "H. R. 6800 - The HEROES Act - Issues related to enhancing coverage for people with ESRD and kidney disease who are particularly vulnerable to COVID-19. \n\nH.R. 748 - CARES Act - Issues related to supporting the national work fighting COVID-19 with a focus on dialysis clinics and providers supporting people living with ESRD.\n\nH.R. 6201 - Families First Coronavirus Response Act - Issues related to ensuring that the federal government is best supporting the public good with a focus on ensuring that states, localities and health care providers have the support they need to support people with ESRD's health, transportation and other critical services.\n\nH.R. 6074 - Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 - Issues related to supporting health care programs and related institutions during the current pandemic. \n\nAdministrative actions and demonstrations related coverning care for people with chronic kidney disease and End Stage Renal Disease (ESRD).\n\nLegislative policies related to ensuring that people living with End Stage Renal Disease (ESRD) who are covered through Medicare Fee for Service (FFS) have the supports and services they need.", "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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}, {"general_issue_code": "HCR", "general_issue_code_display": "Health Issues", "description": "H. R. 6800 - The HEROES Act - Issues related to enhancing coverage for people with ESRD and kidney disease who are particularly vulnerable to COVID-19. \n\nH.R. 748 - CARES Act - Implementation - Issues related to supporting the national work fighting COVID-19 with a focus on dialysis clinics and providers supporting people living with ESRD.\n\nH.R. 6201 - Families First Coronavirus Response Act - Implementation- Issues related to ensuring that the federal government is best supporting the public good with a focus on ensuring that states, localities and health care providers have the support they need to support people with ESRD's health, transportation and other critical services.\n\nH.R. 6074 - Coronavirus Preparedness and Response Supplemental Appropriations Act of 2020 -Implementation- Issues related to supporting health care programs and related institutions during the current pandemic. \n\nAdministrative actions and demonstrations related coverning care for people with chronic kidney disease and End Stage Renal Disease (ESRD).\n\nLegislative policies related to ensuring that people living with End Stage Renal Disease (ESRD) who are covered through Medicare Fee for Service (FFS) have the supports and services they need.", "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": 2, "name": "HOUSE OF REPRESENTATIVES"}, {"id": 1, "name": "SENATE"}]}], "conviction_disclosures": [], "foreign_entities": [], "affiliated_organizations": []}

Links from other tables

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