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-08-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_16

25.61 MB
1,897,699 rows
8 columns

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

Order And Referring : 2024-08-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_20

25.48 MB
1,888,539 rows
8 columns

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

Order And Referring : 2024-08-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_23

25.52 MB
1,890,414 rows
8 columns

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

Order And Referring : 2024-08-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_27

25.54 MB
1,891,568 rows
8 columns

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

Order And Referring : 2024-08-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_30

25.56 MB
1,893,505 rows
8 columns

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

Order And Referring : 2024-09-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_04

25.56 MB
1,894,445 rows
8 columns

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

Order And Referring : 2024-09-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_06

25.57 MB
1,895,666 rows
8 columns

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

Order And Referring : 2024-09-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_10

25.6 MB
1,897,000 rows
8 columns

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

Order And Referring : 2024-09-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_13

25.63 MB
1,898,976 rows
8 columns

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

Order And Referring : 2024-09-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_17

25.65 MB
1,900,137 rows
8 columns

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

Order And Referring : 2024-09-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_20

25.67 MB
1,901,975 rows
8 columns

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

Order And Referring : 2024-09-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_24

25.68 MB
1,903,041 rows
8 columns

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

Order And Referring : 2024-09-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_09_27

25.71 MB
1,904,793 rows
8 columns

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

Order And Referring : 2024-10-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_01

25.73 MB
1,905,758 rows
8 columns

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

Order And Referring : 2024-10-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_04

25.76 MB
1,907,148 rows
8 columns

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

Order And Referring : 2024-10-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_08

25.78 MB
1,908,128 rows
8 columns

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

Order And Referring : 2024-10-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_11

25.8 MB
1,909,813 rows
8 columns

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

Order And Referring : 2024-10-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_15

25.82 MB
1,911,245 rows
8 columns

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

Order And Referring : 2024-10-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_18

25.84 MB
1,912,438 rows
8 columns

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

Order And Referring : 2024-10-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_22

25.86 MB
1,913,397 rows
8 columns

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

Order And Referring : 2024-10-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_25

25.87 MB
1,915,248 rows
8 columns

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

Order And Referring : 2024-10-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_10_29

25.88 MB
1,916,119 rows
8 columns

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

Order And Referring : 2024-11-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_01

25.9 MB
1,917,363 rows
8 columns

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

Order And Referring : 2024-11-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_05

25.95 MB
1,920,894 rows
8 columns

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

Order And Referring : 2024-11-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_08

25.96 MB
1,922,203 rows
8 columns

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