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

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_08_31

22.75 MB
1786667 rows
7 columns


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

Order And Referring : 2023-09-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_06

22.75 MB
1787208 rows
7 columns


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

Order And Referring : 2023-09-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_07

22.79 MB
1788269 rows
7 columns


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

Order And Referring : 2023-09-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_11

22.8 MB
1789203 rows
7 columns


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

Order And Referring : 2023-09-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_14

22.81 MB
1790664 rows
7 columns


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

Order And Referring : 2023-09-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_18

22.83 MB
1791527 rows
7 columns


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

Order And Referring : 2023-09-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_22

22.86 MB
1793394 rows
7 columns


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

Order And Referring : 2023-09-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_26

22.87 MB
1793792 rows
7 columns


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

Order And Referring : 2023-09-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_09_28

22.89 MB
1795227 rows
7 columns


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

Order And Referring : 2023-10-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_03

22.75 MB
1785839 rows
7 columns


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

Order And Referring : 2023-10-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_05

22.91 MB
1797241 rows
7 columns


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

Order And Referring : 2023-10-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_11

22.93 MB
1798004 rows
7 columns


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

Order And Referring : 2023-10-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_13

22.94 MB
1798889 rows
7 columns


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

Order And Referring : 2023-10-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_17

22.95 MB
1799582 rows
7 columns


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

Order And Referring : 2023-10-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_19

22.98 MB
1800806 rows
7 columns


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

Order And Referring : 2023-10-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_24

22.98 MB
1801585 rows
7 columns


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

Order And Referring : 2023-10-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_27

23 MB
1802941 rows
7 columns


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

Order And Referring : 2023-10-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_10_31

22.94 MB
1799373 rows
7 columns


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

Order And Referring : 2023-11-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_03

22.98 MB
1800457 rows
7 columns


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

Order And Referring : 2023-11-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_07

22.98 MB
1801132 rows
7 columns


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

Order And Referring : 2023-11-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_09

22.99 MB
1802384 rows
7 columns


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

Order And Referring : 2023-11-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_14

23.02 MB
1803166 rows
7 columns


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

Order And Referring : 2023-11-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_16

23.04 MB
1804324 rows
7 columns


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

Order And Referring : 2023-11-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_21

23.05 MB
1805075 rows
7 columns


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

Order And Referring : 2023-11-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2023_11_24

23.05 MB
1805843 rows
7 columns


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