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

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_13

25.18 MB
1948847 rows
8 columns


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

Order And Referring : 2025-05-16

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_16

25.2 MB
1950203 rows
8 columns


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

Order And Referring : 2025-05-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_20

25.21 MB
1951057 rows
8 columns


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

Order And Referring : 2025-05-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_23

25.23 MB
1953031 rows
8 columns


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

Order And Referring : 2025-05-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_28

25.24 MB
1953339 rows
8 columns


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

Order And Referring : 2025-05-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_05_30

25.25 MB
1954313 rows
8 columns


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

Order And Referring : 2025-06-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_03

25.26 MB
1954962 rows
8 columns


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

Order And Referring : 2025-06-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_06

25.28 MB
1956623 rows
8 columns


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

Order And Referring : 2025-06-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_10

25.31 MB
1957714 rows
8 columns


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

Order And Referring : 2025-06-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_13

25.34 MB
1959285 rows
8 columns


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

Order And Referring : 2025-06-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_17

25.35 MB
1960453 rows
8 columns


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

Order And Referring : 2025-06-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_20

25.37 MB
1962764 rows
8 columns


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

Order And Referring : 2025-06-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_24

25.38 MB
1963319 rows
8 columns


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

Order And Referring : 2025-06-27

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_06_27

25.41 MB
1965355 rows
8 columns


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

Order And Referring : 2025-07-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_01

25.44 MB
1966829 rows
8 columns


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

Order And Referring : 2025-07-02

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_02

25.47 MB
1968050 rows
8 columns


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

Order And Referring : 2025-07-08

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_08

25.48 MB
1969355 rows
8 columns


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

Order And Referring : 2025-07-11

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_11

25.52 MB
1971395 rows
8 columns


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

Order And Referring : 2025-07-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_15

25.54 MB
1972670 rows
8 columns


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

Order And Referring : 2025-07-18

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_18

25.56 MB
1974409 rows
8 columns


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

Order And Referring : 2025-07-22

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_22

25.58 MB
1975663 rows
8 columns


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

Order And Referring : 2025-07-25

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_25

25.6 MB
1977445 rows
8 columns


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

Order And Referring : 2025-07-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_07_29

25.61 MB
1978573 rows
8 columns


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

Order And Referring : 2025-08-01

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_08_01

25.64 MB
1980296 rows
8 columns


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

Order And Referring : 2025-08-05

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_08_05

25.63 MB
1980043 rows
8 columns


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