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.

Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-08-13T20:29:48.255283
Tags: medicare, original-medicare, provider-enrollment

Tables

Order And Referring : 2025-02-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_07

26.24 MB
1,937,809 rows
8 columns

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

Order And Referring : 2025-02-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_11

26.25 MB
1,938,486 rows
8 columns

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

Order And Referring : 2025-02-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_14

26.25 MB
1,939,577 rows
8 columns

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

Order And Referring : 2025-02-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_19

26.26 MB
1,940,599 rows
8 columns

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

Order And Referring : 2025-02-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_25

26.15 MB
1,931,703 rows
8 columns

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

Order And Referring : 2025-02-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_28

26.16 MB
1,932,858 rows
8 columns

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

Order And Referring : 2025-03-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_04

26.15 MB
1,932,534 rows
8 columns

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

Order And Referring : 2025-03-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_07

26.18 MB
1,933,799 rows
8 columns

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

Order And Referring : 2025-03-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_11

26.19 MB
1,934,531 rows
8 columns

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

Order And Referring : 2025-03-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_14

26.2 MB
1,935,785 rows
8 columns

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

Order And Referring : 2025-03-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_18

26.22 MB
1,936,503 rows
8 columns

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

Order And Referring : 2025-03-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_24

26.26 MB
1,938,384 rows
8 columns

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

Order And Referring : 2025-03-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_27

26.27 MB
1,939,691 rows
8 columns

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

Order And Referring : 2025-04-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_01

26.27 MB
1,940,532 rows
8 columns

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

Order And Referring : 2025-04-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_03

26.29 MB
1,941,214 rows
8 columns

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

Order And Referring : 2025-04-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_08

26.3 MB
1,941,870 rows
8 columns

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

Order And Referring : 2025-04-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_11

26.32 MB
1,942,928 rows
8 columns

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

Order And Referring : 2025-04-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_15

26.31 MB
1,943,462 rows
8 columns

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

Order And Referring : 2025-04-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_18

26.33 MB
1,944,433 rows
8 columns

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

Order And Referring : 2025-04-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_22

26.34 MB
1,944,929 rows
8 columns

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

Order And Referring : 2025-04-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_25

26.34 MB
1,944,844 rows
8 columns

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

Order And Referring : 2025-04-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_29

26.35 MB
1,945,216 rows
8 columns

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

Order And Referring : 2025-05-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_02

26.37 MB
1,946,455 rows
8 columns

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

Order And Referring : 2025-05-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_06

26.37 MB
1,946,730 rows
8 columns

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

Order And Referring : 2025-05-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_09

26.38 MB
1,947,991 rows
8 columns

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