Baselight
Sign In

Hospice Enrollments

U.S. Department of Health & Human Services

@usgov.hhs_gov_hospice_enrollments_ed907

Loading...
Loading...

About this Dataset

Hospice Enrollments

The Hospice Enrollments dataset provides enrollment information of all hospices currently enrolled in Medicare. This data includes information on the hospice's legal business name, doing business as name, organization type and address. 
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-23T09:59:06.036904
Tags: hospice, hospitals-facilities, medicare, medicare-advantage, original-medicare, provider-enrollment

Tables

Hospice Enrollments : 2023-04-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2023_04_01
  • 577 kB
  • 6,576 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2023_04_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2023-07-17

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2023_07_17
  • 585.97 kB
  • 6,706 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2023_07_17 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2023-10-02

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2023_10_02
  • 591.79 kB
  • 6,791 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2023_10_02 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2024-01-05

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2024_01_05
  • 598.65 kB
  • 6,886 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2024_01_05 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2024-04-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2024_04_01
  • 591.6 kB
  • 6,773 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2024_04_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2024-07-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2024_07_01
  • 589.97 kB
  • 6,708 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2024_07_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE
);

Hospice Enrollments : 2024-10-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2024_10_01
  • 581.2 kB
  • 6,585 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2024_10_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE
);

Hospice Enrollments : 2025-01-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2025_01_01
  • 581.4 kB
  • 6,603 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2025_01_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2025-04-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2025_04_01
  • 578.91 kB
  • 6,563 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2025_04_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2025-07-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2025_07_01
  • 574.84 kB
  • 6,501 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2025_07_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Hospice Enrollments : 2025-10-01

@usgov.hhs_gov_hospice_enrollments_ed907.hospice_enrollments_2025_10_01
  • 563.14 kB
  • 6,326 rows
  • 20 columns
Loading... 
CREATE TABLE hospice_enrollments_2025_10_01 (
  "enrollment_id" VARCHAR,
  "enrollment_state" VARCHAR,
  "provider_type_code" VARCHAR,
  "provider_type_text" VARCHAR,
  "npi" BIGINT,
  "multiple_npi_flag" VARCHAR,
  "ccn" VARCHAR,
  "associate_id" BIGINT,
  "organization_name" VARCHAR,
  "doing_business_as_name" VARCHAR,
  "incorporation_date" TIMESTAMP,
  "incorporation_state" VARCHAR,
  "organization_type_structure" VARCHAR,
  "organization_other_type_text" VARCHAR,
  "proprietary_nonprofit" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT
);

Share link

Anyone who has the link will be able to view this.