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

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_13

24.77 MB
1923692 rows
8 columns


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

Order And Referring : 2024-11-15

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_15

24.79 MB
1924826 rows
8 columns


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

Order And Referring : 2024-11-19

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_19

24.81 MB
1925875 rows
8 columns


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

Order And Referring : 2024-11-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_21

24.83 MB
1927586 rows
8 columns


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

Order And Referring : 2024-11-26

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_26

24.84 MB
1928691 rows
8 columns


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

Order And Referring : 2024-11-29

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_11_29

24.85 MB
1930232 rows
8 columns


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

Order And Referring : 2024-12-03

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_03

24.85 MB
1929368 rows
8 columns


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

Order And Referring : 2024-12-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_06

24.86 MB
1930816 rows
8 columns


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

Order And Referring : 2024-12-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_10

24.89 MB
1931772 rows
8 columns


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

Order And Referring : 2024-12-13

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_13

24.8 MB
1926353 rows
8 columns


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

Order And Referring : 2024-12-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_17

24.81 MB
1927140 rows
8 columns


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

Order And Referring : 2024-12-20

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_20

24.82 MB
1928427 rows
8 columns


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

Order And Referring : 2024-12-23

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_23

24.84 MB
1929174 rows
8 columns


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

Order And Referring : 2024-12-30

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_30

24.84 MB
1929629 rows
8 columns


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

Order And Referring : 2024-12-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2024_12_31

24.84 MB
1930174 rows
8 columns


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

Order And Referring : 2025-01-06

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_06

24.85 MB
1930721 rows
8 columns


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

Order And Referring : 2025-01-07

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_07

24.86 MB
1931250 rows
8 columns


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

Order And Referring : 2025-01-10

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_10

24.89 MB
1932440 rows
8 columns


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

Order And Referring : 2025-01-14

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_14

24.94 MB
1933192 rows
8 columns


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

Order And Referring : 2025-01-17

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_17

24.98 MB
1934761 rows
8 columns


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

Order And Referring : 2025-01-21

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_21

24.98 MB
1935049 rows
8 columns


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

Order And Referring : 2025-01-24

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_24

24.99 MB
1935646 rows
8 columns


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

Order And Referring : 2025-01-28

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_28

24.99 MB
1936075 rows
8 columns


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

Order And Referring : 2025-01-31

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_01_31

25.02 MB
1937028 rows
8 columns


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

Order And Referring : 2025-02-04

@usgov.hhs_gov_order_and_referring_dffa2.order_and_referring_2025_02_04

25.01 MB
1936702 rows
8 columns


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