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 : 2025-05-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_13

26.4 MB
1,948,847 rows
8 columns

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

Order And Referring : 2025-05-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_16

26.42 MB
1,950,203 rows
8 columns

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

Order And Referring : 2025-05-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_20

26.43 MB
1,951,057 rows
8 columns

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

Order And Referring : 2025-05-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_23

26.46 MB
1,953,031 rows
8 columns

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

Order And Referring : 2025-05-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_28

26.46 MB
1,953,339 rows
8 columns

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

Order And Referring : 2025-05-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_30

26.48 MB
1,954,313 rows
8 columns

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

Order And Referring : 2025-06-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_03

26.49 MB
1,954,962 rows
8 columns

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

Order And Referring : 2025-06-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_06

26.51 MB
1,956,623 rows
8 columns

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

Order And Referring : 2025-06-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_10

26.54 MB
1,957,714 rows
8 columns

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

Order And Referring : 2025-06-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_13

26.57 MB
1,959,285 rows
8 columns

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

Order And Referring : 2025-06-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_17

26.58 MB
1,960,453 rows
8 columns

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

Order And Referring : 2025-06-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_20

26.61 MB
1,962,764 rows
8 columns

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

Order And Referring : 2025-06-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_24

26.62 MB
1,963,319 rows
8 columns

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

Order And Referring : 2025-06-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_27

26.65 MB
1,965,355 rows
8 columns

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

Order And Referring : 2025-07-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_01

26.68 MB
1,966,829 rows
8 columns

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

Order And Referring : 2025-07-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_02

26.71 MB
1,968,050 rows
8 columns

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

Order And Referring : 2025-07-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_08

26.72 MB
1,969,355 rows
8 columns

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

Order And Referring : 2025-07-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_11

26.76 MB
1,971,395 rows
8 columns

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

Order And Referring : 2025-07-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_15

26.78 MB
1,972,670 rows
8 columns

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

Order And Referring : 2025-07-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_18

26.8 MB
1,974,409 rows
8 columns

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

Order And Referring : 2025-07-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_22

26.82 MB
1,975,663 rows
8 columns

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

Order And Referring : 2025-07-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_25

26.84 MB
1,977,445 rows
8 columns

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

Order And Referring : 2025-07-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_29

26.86 MB
1,978,573 rows
8 columns

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

Order And Referring : 2025-08-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_08_01

26.88 MB
1,980,296 rows
8 columns

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

Order And Referring : 2025-08-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_08_05

26.88 MB
1,980,043 rows
8 columns

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