About this Dataset

Opioid Treatment Program Providers

The Opioid Treatment Program (OTP) Providers dataset provides information on Providers who have enrolled in Medicare under the Opioid Treatment Program. It contains provider's name, National Provider Identifier (NPI), address, phone number and the effective enrollment date.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-08-13T20:35:19.663106
Tags: drugs, medicare, original-medicare, provider-enrollment

Tables

Opioid Treatment Program Providers : 2025-05-13

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_05_13

111.03 KB
1547 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_05_13 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-05-20

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_05_20

111.33 KB
1551 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_05_20 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-05-28

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_05_28

111.55 KB
1553 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_05_28 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-06-03

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_06_03

111.43 KB
1550 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_06_03 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-06-10

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_06_10

111.39 KB
1548 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_06_10 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-06-17

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_06_17

111.43 KB
1549 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_06_17 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-06-24

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_06_24

111.4 KB
1548 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_06_24 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-07-01

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_07_01

111.43 KB
1549 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_07_01 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-07-08

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_07_08

111.44 KB
1550 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_07_08 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-07-15

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_07_15

111.68 KB
1552 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_07_15 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-07-22

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_07_22

111.76 KB
1552 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_07_22 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-07-29

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_07_29

112.15 KB
1558 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_07_29 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-08-05

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_08_05

112.54 KB
1563 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_08_05 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);

Opioid Treatment Program Providers : 2025-08-12

@usgov.hhs_gov_opioid_treatment_program_providers_9e369.opioid_treatment_program_providers_2025_08_12

112.67 KB
1566 rows
9 columns


CREATE TABLE opioid_treatment_program_providers_2025_08_12 (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "medicare_id_effective_date" TIMESTAMP,
  "phone" VARCHAR
);