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-06-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_01

23.62 MB
1,768,677 rows
7 columns

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

Order And Referring : 2023-06-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_08

23.64 MB
1,770,271 rows
7 columns

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

Order And Referring : 2023-06-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_13

23.64 MB
1,771,089 rows
7 columns

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

Order And Referring : 2023-06-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_15

23.65 MB
1,772,568 rows
7 columns

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

Order And Referring : 2023-06-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_20

23.67 MB
1,773,577 rows
7 columns

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

Order And Referring : 2023-06-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_23

23.68 MB
1,774,783 rows
7 columns

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

Order And Referring : 2023-06-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_06_27

23.7 MB
1,775,881 rows
7 columns

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

Order And Referring : 2023-07-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_03

23.72 MB
1,777,696 rows
7 columns

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

Order And Referring : 2023-07-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_05

23.55 MB
1,765,000 rows
7 columns

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

Order And Referring : 2023-07-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_07

23.58 MB
1,766,744 rows
7 columns

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

Order And Referring : 2023-07-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_11

23.59 MB
1,767,570 rows
7 columns

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

Order And Referring : 2023-07-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_14

23.62 MB
1,769,672 rows
7 columns

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

Order And Referring : 2023-07-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_19

23.66 MB
1,771,615 rows
7 columns

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

Order And Referring : 2023-07-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_21

23.66 MB
1,772,844 rows
7 columns

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

Order And Referring : 2023-07-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_25

23.68 MB
1,773,882 rows
7 columns

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

Order And Referring : 2023-07-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_07_27

23.7 MB
1,775,445 rows
7 columns

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

Order And Referring : 2023-08-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_01

23.72 MB
1,776,356 rows
7 columns

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

Order And Referring : 2023-08-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_03

23.73 MB
1,777,181 rows
7 columns

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

Order And Referring : 2023-08-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_08

23.74 MB
1,778,266 rows
7 columns

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

Order And Referring : 2023-08-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_10

23.77 MB
1,779,829 rows
7 columns

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

Order And Referring : 2023-08-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_15

23.78 MB
1,780,743 rows
7 columns

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

Order And Referring : 2023-08-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_17

23.8 MB
1,782,200 rows
7 columns

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

Order And Referring : 2023-08-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_22

23.81 MB
1,782,950 rows
7 columns

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

Order And Referring : 2023-08-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_24

23.82 MB
1,784,401 rows
7 columns

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

Order And Referring : 2023-08-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_29

23.84 MB
1,785,282 rows
7 columns

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