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 : 2023-08-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_31

23.86 MB
1,786,667 rows
7 columns

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

Order And Referring : 2023-09-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_06

23.86 MB
1,787,208 rows
7 columns

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

Order And Referring : 2023-09-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_07

23.89 MB
1,788,269 rows
7 columns

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

Order And Referring : 2023-09-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_11

23.91 MB
1,789,203 rows
7 columns

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

Order And Referring : 2023-09-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_14

23.92 MB
1,790,664 rows
7 columns

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

Order And Referring : 2023-09-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_18

23.94 MB
1,791,527 rows
7 columns

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

Order And Referring : 2023-09-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_22

23.97 MB
1,793,394 rows
7 columns

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

Order And Referring : 2023-09-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_26

23.98 MB
1,793,792 rows
7 columns

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

Order And Referring : 2023-09-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_28

24 MB
1,795,227 rows
7 columns

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

Order And Referring : 2023-10-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_03

23.86 MB
1,785,839 rows
7 columns

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

Order And Referring : 2023-10-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_05

24.02 MB
1,797,241 rows
7 columns

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

Order And Referring : 2023-10-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_11

24.04 MB
1,798,004 rows
7 columns

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

Order And Referring : 2023-10-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_13

24.06 MB
1,798,889 rows
7 columns

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

Order And Referring : 2023-10-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_17

24.07 MB
1,799,582 rows
7 columns

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

Order And Referring : 2023-10-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_19

24.1 MB
1,800,806 rows
7 columns

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

Order And Referring : 2023-10-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_24

24.1 MB
1,801,585 rows
7 columns

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

Order And Referring : 2023-10-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_27

24.12 MB
1,802,941 rows
7 columns

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

Order And Referring : 2023-10-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_31

24.06 MB
1,799,373 rows
7 columns

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

Order And Referring : 2023-11-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_03

24.09 MB
1,800,457 rows
7 columns

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

Order And Referring : 2023-11-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_07

24.1 MB
1,801,132 rows
7 columns

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

Order And Referring : 2023-11-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_09

24.11 MB
1,802,384 rows
7 columns

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

Order And Referring : 2023-11-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_14

24.14 MB
1,803,166 rows
7 columns

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

Order And Referring : 2023-11-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_16

24.16 MB
1,804,324 rows
7 columns

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

Order And Referring : 2023-11-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_21

24.17 MB
1,805,075 rows
7 columns

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

Order And Referring : 2023-11-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_24

24.17 MB
1,805,843 rows
7 columns

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