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-11-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_28

24.17 MB
1,806,111 rows
7 columns

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

Order And Referring : 2023-12-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_01

24.19 MB
1,807,551 rows
7 columns

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

Order And Referring : 2023-12-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_05

24.19 MB
1,807,412 rows
7 columns

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

Order And Referring : 2023-12-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_08

24.21 MB
1,808,505 rows
7 columns

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

Order And Referring : 2023-12-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_11

24.22 MB
1,809,240 rows
7 columns

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

Order And Referring : 2023-12-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_15

24.22 MB
1,810,356 rows
7 columns

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

Order And Referring : 2023-12-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_19

24.22 MB
1,810,887 rows
7 columns

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

Order And Referring : 2023-12-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_22

24.24 MB
1,811,966 rows
7 columns

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

Order And Referring : 2023-12-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_27

24.25 MB
1,812,521 rows
7 columns

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

Order And Referring : 2023-12-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_12_29

24.25 MB
1,812,877 rows
7 columns

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

Order And Referring : 2024-01-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_03

24.33 MB
1,818,973 rows
7 columns

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

Order And Referring : 2024-01-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_05

24.36 MB
1,820,531 rows
7 columns

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

Order And Referring : 2024-01-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_09

24.38 MB
1,822,433 rows
7 columns

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

Order And Referring : 2024-01-12

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_12

24.41 MB
1,824,935 rows
7 columns

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

Order And Referring : 2024-01-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_16

24.41 MB
1,826,734 rows
7 columns

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

Order And Referring : 2024-01-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_19

24.46 MB
1,829,721 rows
7 columns

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

Order And Referring : 2024-01-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_23

24.49 MB
1,830,478 rows
7 columns

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

Order And Referring : 2024-01-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_26

24.54 MB
1,833,708 rows
7 columns

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

Order And Referring : 2024-01-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_01_30

24.55 MB
1,834,575 rows
7 columns

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

Order And Referring : 2024-02-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_02

24.57 MB
1,835,986 rows
7 columns

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

Order And Referring : 2024-02-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_06

24.57 MB
1,836,161 rows
7 columns

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

Order And Referring : 2024-02-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_09

24.6 MB
1,838,315 rows
7 columns

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

Order And Referring : 2024-02-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_13

24.61 MB
1,839,685 rows
7 columns

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

Order And Referring : 2024-02-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_16

24.64 MB
1,841,753 rows
7 columns

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

Order And Referring : 2024-02-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_21

24.66 MB
1,843,753 rows
7 columns

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