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

23.05 MB
1806111 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

23.07 MB
1807551 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

23.07 MB
1807412 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

23.09 MB
1808505 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

23.1 MB
1809240 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

23.1 MB
1810356 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

23.1 MB
1810887 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

23.12 MB
1811966 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

23.13 MB
1812521 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

23.13 MB
1812877 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

23.21 MB
1818973 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

23.23 MB
1820531 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

23.25 MB
1822433 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

23.28 MB
1824935 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

23.28 MB
1826734 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

23.32 MB
1829721 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

23.35 MB
1830478 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

23.4 MB
1833708 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

23.41 MB
1834575 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

23.43 MB
1835986 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

23.43 MB
1836161 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

23.46 MB
1838315 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

23.47 MB
1839685 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

23.49 MB
1841753 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

23.52 MB
1843753 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
);