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-05-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_21

24.22 MB
1877329 rows
8 columns


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

Order And Referring : 2024-05-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_28

24 MB
1862293 rows
8 columns


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

Order And Referring : 2024-05-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_29

24.01 MB
1863529 rows
8 columns


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

Order And Referring : 2024-05-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_31

24.01 MB
1864825 rows
8 columns


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

Order And Referring : 2024-06-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_04

24.03 MB
1865512 rows
8 columns


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

Order And Referring : 2024-06-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_07

24.06 MB
1867286 rows
8 columns


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

Order And Referring : 2024-06-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_11

24.07 MB
1868454 rows
8 columns


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

Order And Referring : 2024-06-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_14

24.1 MB
1870420 rows
8 columns


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

Order And Referring : 2024-06-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_18

24.13 MB
1871820 rows
8 columns


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

Order And Referring : 2024-06-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_21

24.15 MB
1873581 rows
8 columns


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

Order And Referring : 2024-06-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_25

24.17 MB
1874938 rows
8 columns


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

Order And Referring : 2024-06-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_06_28

24.2 MB
1877183 rows
8 columns


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

Order And Referring : 2024-07-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_02

24.22 MB
1878535 rows
8 columns


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

Order And Referring : 2024-07-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_05

24.29 MB
1886793 rows
8 columns


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

Order And Referring : 2024-07-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_09

24.29 MB
1887299 rows
8 columns


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

Order And Referring : 2024-07-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_15

24.32 MB
1889474 rows
8 columns


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

Order And Referring : 2024-07-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_16

24.29 MB
1884678 rows
8 columns


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

Order And Referring : 2024-07-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_19

24.29 MB
1886223 rows
8 columns


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

Order And Referring : 2024-07-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_23

24.3 MB
1887637 rows
8 columns


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

Order And Referring : 2024-07-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_26

24.33 MB
1889733 rows
8 columns


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

Order And Referring : 2024-07-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_07_30

24.34 MB
1891012 rows
8 columns


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

Order And Referring : 2024-08-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_02

24.37 MB
1892672 rows
8 columns


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

Order And Referring : 2024-08-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_06

24.38 MB
1892882 rows
8 columns


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

Order And Referring : 2024-08-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_09

24.38 MB
1894612 rows
8 columns


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

Order And Referring : 2024-08-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_08_13

24.4 MB
1895739 rows
8 columns


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