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-02-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_23

23.55 MB
1845109 rows
7 columns


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

Order And Referring : 2024-02-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_02_27

23.56 MB
1846336 rows
7 columns


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

Order And Referring : 2024-03-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_01

23.58 MB
1848347 rows
7 columns


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

Order And Referring : 2024-03-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_05

23.59 MB
1849058 rows
7 columns


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

Order And Referring : 2024-03-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_08

23.61 MB
1850878 rows
7 columns


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

Order And Referring : 2024-03-12

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_12

23.62 MB
1852004 rows
7 columns


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

Order And Referring : 2024-03-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_15

23.65 MB
1853875 rows
7 columns


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

Order And Referring : 2024-03-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_19

23.66 MB
1854933 rows
7 columns


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

Order And Referring : 2024-03-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_22

23.71 MB
1856717 rows
7 columns


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

Order And Referring : 2024-03-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_26

23.73 MB
1857672 rows
7 columns


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

Order And Referring : 2024-03-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_03_29

23.75 MB
1859382 rows
7 columns


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

Order And Referring : 2024-04-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_02

24 MB
1860219 rows
8 columns


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

Order And Referring : 2024-04-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_05

24.01 MB
1861421 rows
8 columns


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

Order And Referring : 2024-04-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_09

24.02 MB
1862493 rows
8 columns


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

Order And Referring : 2024-04-12

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_12

24.03 MB
1863963 rows
8 columns


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

Order And Referring : 2024-04-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_16

24.04 MB
1865051 rows
8 columns


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

Order And Referring : 2024-04-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_19

24.07 MB
1866610 rows
8 columns


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

Order And Referring : 2024-04-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_23

24.08 MB
1867580 rows
8 columns


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

Order And Referring : 2024-04-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_26

24.1 MB
1868999 rows
8 columns


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

Order And Referring : 2024-04-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_04_30

24.1 MB
1870036 rows
8 columns


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

Order And Referring : 2024-05-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_03

24.12 MB
1870870 rows
8 columns


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

Order And Referring : 2024-05-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_07

24.14 MB
1871783 rows
8 columns


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

Order And Referring : 2024-05-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_10

24.17 MB
1873518 rows
8 columns


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

Order And Referring : 2024-05-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_14

24.17 MB
1874468 rows
8 columns


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

Order And Referring : 2024-05-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_05_17

24.19 MB
1876188 rows
8 columns


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