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 : 2025-02-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_07

25.03 MB
1937809 rows
8 columns


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

Order And Referring : 2025-02-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_11

25.03 MB
1938486 rows
8 columns


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

Order And Referring : 2025-02-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_14

25.03 MB
1939577 rows
8 columns


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

Order And Referring : 2025-02-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_19

25.04 MB
1940599 rows
8 columns


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

Order And Referring : 2025-02-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_25

24.94 MB
1931703 rows
8 columns


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

Order And Referring : 2025-02-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_28

24.95 MB
1932858 rows
8 columns


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

Order And Referring : 2025-03-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_04

24.94 MB
1932534 rows
8 columns


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

Order And Referring : 2025-03-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_07

24.97 MB
1933799 rows
8 columns


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

Order And Referring : 2025-03-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_11

24.97 MB
1934531 rows
8 columns


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

Order And Referring : 2025-03-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_14

24.99 MB
1935785 rows
8 columns


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

Order And Referring : 2025-03-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_18

25 MB
1936503 rows
8 columns


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

Order And Referring : 2025-03-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_24

25.04 MB
1938384 rows
8 columns


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

Order And Referring : 2025-03-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_03_27

25.06 MB
1939691 rows
8 columns


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

Order And Referring : 2025-04-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_01

25.05 MB
1940532 rows
8 columns


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

Order And Referring : 2025-04-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_03

25.07 MB
1941214 rows
8 columns


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

Order And Referring : 2025-04-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_08

25.08 MB
1941870 rows
8 columns


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

Order And Referring : 2025-04-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_11

25.1 MB
1942928 rows
8 columns


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

Order And Referring : 2025-04-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_15

25.1 MB
1943462 rows
8 columns


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

Order And Referring : 2025-04-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_18

25.11 MB
1944433 rows
8 columns


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

Order And Referring : 2025-04-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_22

25.12 MB
1944929 rows
8 columns


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

Order And Referring : 2025-04-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_25

25.12 MB
1944844 rows
8 columns


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

Order And Referring : 2025-04-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_04_29

25.13 MB
1945216 rows
8 columns


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

Order And Referring : 2025-05-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_02

25.15 MB
1946455 rows
8 columns


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

Order And Referring : 2025-05-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_06

25.15 MB
1946730 rows
8 columns


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

Order And Referring : 2025-05-09

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_09

25.16 MB
1947991 rows
8 columns


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