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-02-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_23

24.69 MB
1,845,109 rows
7 columns

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

Order And Referring : 2024-02-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_27

24.7 MB
1,846,336 rows
7 columns

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

Order And Referring : 2024-03-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_01

24.72 MB
1,848,347 rows
7 columns

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

Order And Referring : 2024-03-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_05

24.74 MB
1,849,058 rows
7 columns

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

Order And Referring : 2024-03-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_08

24.76 MB
1,850,878 rows
7 columns

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

Order And Referring : 2024-03-12

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_12

24.77 MB
1,852,004 rows
7 columns

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

Order And Referring : 2024-03-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_15

24.8 MB
1,853,875 rows
7 columns

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

Order And Referring : 2024-03-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_19

24.81 MB
1,854,933 rows
7 columns

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

Order And Referring : 2024-03-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_22

24.86 MB
1,856,717 rows
7 columns

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

Order And Referring : 2024-03-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_26

24.88 MB
1,857,672 rows
7 columns

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

Order And Referring : 2024-03-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_29

24.91 MB
1,859,382 rows
7 columns

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

Order And Referring : 2024-04-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_02

25.16 MB
1,860,219 rows
8 columns

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

Order And Referring : 2024-04-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_05

25.17 MB
1,861,421 rows
8 columns

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

Order And Referring : 2024-04-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_09

25.18 MB
1,862,493 rows
8 columns

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

Order And Referring : 2024-04-12

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_12

25.19 MB
1,863,963 rows
8 columns

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

Order And Referring : 2024-04-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_16

25.21 MB
1,865,051 rows
8 columns

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

Order And Referring : 2024-04-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_19

25.24 MB
1,866,610 rows
8 columns

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

Order And Referring : 2024-04-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_23

25.25 MB
1,867,580 rows
8 columns

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

Order And Referring : 2024-04-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_26

25.27 MB
1,868,999 rows
8 columns

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

Order And Referring : 2024-04-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_30

25.28 MB
1,870,036 rows
8 columns

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

Order And Referring : 2024-05-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_03

25.29 MB
1,870,870 rows
8 columns

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

Order And Referring : 2024-05-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_07

25.32 MB
1,871,783 rows
8 columns

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

Order And Referring : 2024-05-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_10

25.34 MB
1,873,518 rows
8 columns

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

Order And Referring : 2024-05-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_14

25.35 MB
1,874,468 rows
8 columns

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

Order And Referring : 2024-05-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_17

25.36 MB
1,876,188 rows
8 columns

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