About this Dataset

Order And Referring

The Order and Referring dataset provides information on all physicians and non-physician practitioners, by their National Provider Identifier (NPI), who are of a type/specialty that is legally eligible to order and refer in the Medicare program and who have current enrollment records in Medicare. This dataset identifies Medicare fee-for-service ordering and referring eligibility, supporting transparency and regulatory compliance efforts. The information can be used to verify ordering and referring capabilities as required by Medicare program standards.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-11-08T13:12:52.994422
Tags: medicare, original-medicare, provider-enrollment

Tables

Order And Referring : 2025-10-03

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_03

27.18 MB
2,002,085 rows
8 columns

CREATE TABLE order_and_referring_2025_10_03 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-07

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_07

27.19 MB
2,002,866 rows
8 columns

CREATE TABLE order_and_referring_2025_10_07 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-10

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_10

27.21 MB
2,004,174 rows
8 columns

CREATE TABLE order_and_referring_2025_10_10 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-14

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_14

27.23 MB
2,005,588 rows
8 columns

CREATE TABLE order_and_referring_2025_10_14 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-17

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_17

27.24 MB
2,006,579 rows
8 columns

CREATE TABLE order_and_referring_2025_10_17 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-21

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_21

27.25 MB
2,007,629 rows
8 columns

CREATE TABLE order_and_referring_2025_10_21 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-24

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_24

27.26 MB
2,008,946 rows
8 columns

CREATE TABLE order_and_referring_2025_10_24 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-28

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_28

27.28 MB
2,009,948 rows
8 columns

CREATE TABLE order_and_referring_2025_10_28 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-10-31

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_10_31

27.29 MB
2,011,222 rows
8 columns

CREATE TABLE order_and_referring_2025_10_31 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-11-04

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_11_04

27.29 MB
2,011,341 rows
8 columns

CREATE TABLE order_and_referring_2025_11_04 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);

Order And Referring : 2025-11-07

@usgov.hhs_gov_order_and_referring_a8541.order_and_referring_2025_11_07

27.2 MB
2,003,391 rows
8 columns

CREATE TABLE order_and_referring_2025_11_07 (
  "npi" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "partb" VARCHAR,
  "dme" VARCHAR,
  "hha" VARCHAR,
  "pmd" VARCHAR,
  "hospice" VARCHAR
);