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

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_13

25.98 MB
1,923,692 rows
8 columns

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

Order And Referring : 2024-11-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_15

25.99 MB
1,924,826 rows
8 columns

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

Order And Referring : 2024-11-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_19

26.02 MB
1,925,875 rows
8 columns

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

Order And Referring : 2024-11-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_21

26.03 MB
1,927,586 rows
8 columns

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

Order And Referring : 2024-11-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_26

26.05 MB
1,928,691 rows
8 columns

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

Order And Referring : 2024-11-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_29

26.06 MB
1,930,232 rows
8 columns

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

Order And Referring : 2024-12-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_03

26.05 MB
1,929,368 rows
8 columns

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

Order And Referring : 2024-12-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_06

26.07 MB
1,930,816 rows
8 columns

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

Order And Referring : 2024-12-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_10

26.1 MB
1,931,772 rows
8 columns

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

Order And Referring : 2024-12-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_13

26 MB
1,926,353 rows
8 columns

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

Order And Referring : 2024-12-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_17

26.01 MB
1,927,140 rows
8 columns

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

Order And Referring : 2024-12-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_20

26.03 MB
1,928,427 rows
8 columns

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

Order And Referring : 2024-12-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_23

26.05 MB
1,929,174 rows
8 columns

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

Order And Referring : 2024-12-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_30

26.04 MB
1,929,629 rows
8 columns

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

Order And Referring : 2024-12-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_31

26.05 MB
1,930,174 rows
8 columns

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

Order And Referring : 2025-01-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_06

26.05 MB
1,930,721 rows
8 columns

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

Order And Referring : 2025-01-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_07

26.07 MB
1,931,250 rows
8 columns

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

Order And Referring : 2025-01-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_10

26.1 MB
1,932,440 rows
8 columns

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

Order And Referring : 2025-01-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_14

26.15 MB
1,933,192 rows
8 columns

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

Order And Referring : 2025-01-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_17

26.19 MB
1,934,761 rows
8 columns

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

Order And Referring : 2025-01-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_21

26.2 MB
1,935,049 rows
8 columns

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

Order And Referring : 2025-01-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_24

26.21 MB
1,935,646 rows
8 columns

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

Order And Referring : 2025-01-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_28

26.21 MB
1,936,075 rows
8 columns

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

Order And Referring : 2025-01-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_31

26.23 MB
1,937,028 rows
8 columns

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

Order And Referring : 2025-02-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_04

26.23 MB
1,936,702 rows
8 columns

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