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 : 2024-05-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_21

25.39 MB
1,877,329 rows
8 columns

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

Order And Referring : 2024-05-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_28

25.17 MB
1,862,293 rows
8 columns

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

Order And Referring : 2024-05-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_29

25.18 MB
1,863,529 rows
8 columns

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

Order And Referring : 2024-05-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_31

25.18 MB
1,864,825 rows
8 columns

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

Order And Referring : 2024-06-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_04

25.2 MB
1,865,512 rows
8 columns

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

Order And Referring : 2024-06-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_07

25.23 MB
1,867,286 rows
8 columns

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

Order And Referring : 2024-06-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_11

25.24 MB
1,868,454 rows
8 columns

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

Order And Referring : 2024-06-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_14

25.27 MB
1,870,420 rows
8 columns

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

Order And Referring : 2024-06-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_18

25.3 MB
1,871,820 rows
8 columns

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

Order And Referring : 2024-06-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_21

25.32 MB
1,873,581 rows
8 columns

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

Order And Referring : 2024-06-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_25

25.35 MB
1,874,938 rows
8 columns

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

Order And Referring : 2024-06-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_28

25.38 MB
1,877,183 rows
8 columns

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

Order And Referring : 2024-07-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_02

25.39 MB
1,878,535 rows
8 columns

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

Order And Referring : 2024-07-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_05

25.47 MB
1,886,793 rows
8 columns

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

Order And Referring : 2024-07-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_09

25.47 MB
1,887,299 rows
8 columns

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

Order And Referring : 2024-07-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_15

25.5 MB
1,889,474 rows
8 columns

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

Order And Referring : 2024-07-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_16

25.47 MB
1,884,678 rows
8 columns

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

Order And Referring : 2024-07-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_19

25.47 MB
1,886,223 rows
8 columns

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

Order And Referring : 2024-07-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_23

25.48 MB
1,887,637 rows
8 columns

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

Order And Referring : 2024-07-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_26

25.51 MB
1,889,733 rows
8 columns

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

Order And Referring : 2024-07-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_30

25.52 MB
1,891,012 rows
8 columns

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

Order And Referring : 2024-08-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_02

25.56 MB
1,892,672 rows
8 columns

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

Order And Referring : 2024-08-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_06

25.56 MB
1,892,882 rows
8 columns

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

Order And Referring : 2024-08-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_09

25.57 MB
1,894,612 rows
8 columns

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

Order And Referring : 2024-08-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_13

25.59 MB
1,895,739 rows
8 columns

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