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.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.OPIOID_TREATMENT_PROGRAM_PROVIDERS on Snowflake and Databricks — coverage from 2023 to 2026 in a single aligned schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake

DWV.OPIOID_TREATMENT_PROGRAM_PROVIDERS

Databricks

cms_dwv.opioid_treatment_program_providers

Coverage

May 2023 – Jul 2026

Rows

266,922 (total across all reporting periods)

Cadence

Weekly

Update pattern

Time-partitioned — each file adds one reporting period

CMS published

2026-07-07

Loaded

2026-07-07

Columns

9 data + 6 lineage

Identifiers

NPI · ZIP codes

File versions

178

License

CMS public data — U.S. Government work

Platforms

Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-07-07. Coverage runs through 2026-07-04. Next CMS release expected ~Jul 2026.

Time-partitioned feed — each file version covers one reporting period, so history is additive. Query the full table for all periods; filter on the reporting period columns for a single period. Do not filter to the latest file only — that would return just the 2026 reporting period.

Sample queries

-- Each file version covers one reporting period (2023, 2024, 2025, 2026) — history is additive
SELECT *
FROM DWV.OPIOID_TREATMENT_PROGRAM_PROVIDERS
LIMIT 100;

About this feed

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.
— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Drugs, Provider Enrollment Theme: Medicare

Coverage timeline

2023 🟩 · 2024 🟩 · 2025 🟩 · 2026 🟩

4 of 4 years covered — no gaps.

Release history

Reporting period

CMS published

Loaded

Latest file

2026-06-28 – 2026-07-04

2026-07-07

✓

2026-06-21 – 2026-06-27

2026-06-30

2026-06-14 – 2026-06-20

2026-06-23

2026-06-07 – 2026-06-13

2026-06-17

2026-05-31 – 2026-06-06

2026-06-09

2026-06-11

2026-05-24 – 2026-05-30

2026-06-02

2026-05-17 – 2026-05-23

2026-05-26

2026-05-10 – 2026-05-16

2026-05-19

2026-05-03 – 2026-05-09

2026-05-12

2026-04-26 – 2026-05-02

2026-05-05

Show 168 earlier file versions

Reporting period

CMS published

Loaded

Latest file

2026-04-19 – 2026-04-25

2026-04-28

2026-04-12 – 2026-04-18

2026-04-21

2026-04-05 – 2026-04-11

2026-04-14

2026-03-29 – 2026-04-04

2026-04-07

2026-04-08

2026-03-22 – 2026-03-28

2026-03-31

2026-03-15 – 2026-03-21

2026-03-24

2026-03-08 – 2026-03-14

2026-03-17

2026-03-01 – 2026-03-07

2026-03-10

2026-02-22 – 2026-02-28

2026-03-03

2026-02-15 – 2026-02-21

2026-02-24

2026-02-08 – 2026-02-14

2026-02-18

2026-02-01 – 2026-02-07

2026-02-10

2026-02-11

2026-01-25 – 2026-01-31

2026-02-03

2026-01-18 – 2026-01-24

2026-01-27

2026-01-11 – 2026-01-17

2026-01-21

2026-01-04 – 2026-01-10

2026-01-13

2025-12-28 – 2026-01-03

2026-01-06

2025-12-21 – 2025-12-27

2025-12-30

2025-12-14 – 2025-12-20

2025-12-23

2025-12-07 – 2025-12-13

2025-12-16

2025-11-30 – 2025-12-06

2025-12-09

2025-11-23 – 2025-11-29

2025-12-02

2025-11-16 – 2025-11-22

2025-11-25

2025-11-09 – 2025-11-15

2025-11-18

2025-11-02 – 2025-11-08

2025-11-11

2025-10-26 – 2025-11-01

2025-11-04

2025-10-19 – 2025-10-25

2025-10-28

2025-10-12 – 2025-10-18

2025-10-22

2025-10-05 – 2025-10-11

2025-10-22

2025-09-28 – 2025-10-04

2025-10-22

2025-09-21 – 2025-09-27

2025-09-30

2025-09-14 – 2025-09-20

2025-09-23

2025-09-07 – 2025-09-13

2025-09-16

2025-08-31 – 2025-09-06

2025-09-09

2025-08-24 – 2025-08-30

2025-09-02

2025-08-17 – 2025-08-23

2025-08-26

2025-08-10 – 2025-08-16

2025-08-19

2025-08-03 – 2025-08-09

2025-08-12

2025-08-13

2025-07-27 – 2025-08-02

2025-08-05

2025-07-20 – 2025-07-26

2025-07-29

2025-07-13 – 2025-07-19

2025-07-22

2025-07-06 – 2025-07-12

2025-07-15

2025-06-29 – 2025-07-05

2025-07-08

2025-06-22 – 2025-06-28

2025-07-01

2025-06-15 – 2025-06-21

2025-06-24

2025-06-08 – 2025-06-14

2025-06-17

2025-06-01 – 2025-06-07

2025-06-10

2025-05-25 – 2025-05-31

2025-06-03

2025-05-18 – 2025-05-24

2025-05-28

2025-05-11 – 2025-05-17

2025-05-20

2025-05-04 – 2025-05-10

2025-05-13

2025-04-27 – 2025-05-03

2025-05-06

2025-04-20 – 2025-04-26

2025-04-29

2025-04-13 – 2025-04-19

2025-04-28

2025-04-06 – 2025-04-12

2025-04-28

2025-03-30 – 2025-04-05

2025-04-28

2025-03-23 – 2025-03-29

2025-04-28

2025-03-16 – 2025-03-22

2025-04-28

2025-03-09 – 2025-03-15

2025-04-28

2025-03-02 – 2025-03-08

2025-04-28

2025-02-23 – 2025-03-01

2025-04-28

2025-02-16 – 2025-02-22

2025-04-28

2025-02-09 – 2025-02-15

2025-04-28

2025-02-02 – 2025-02-08

2025-04-28

2025-01-26 – 2025-02-01

2025-04-28

2025-01-19 – 2025-01-25

2025-04-28

2025-01-12 – 2025-01-18

2025-01-21

2025-01-05 – 2025-01-11

2025-01-14

2024-12-29 – 2025-01-04

2025-01-07

2024-12-22 – 2024-12-28

2024-12-31

2024-12-15 – 2024-12-21

2024-12-23

2024-12-08 – 2024-12-14

2024-12-17

2024-12-01 – 2024-12-07

2024-12-10

2024-11-24 – 2024-11-30

2024-12-03

2024-11-17 – 2024-11-23

2024-11-26

2024-11-10 – 2024-11-16

2024-11-19

2024-11-03 – 2024-11-09

2024-11-13

2024-10-27 – 2024-11-02

2024-11-05

2024-10-20 – 2024-10-26

2024-10-29

2024-10-13 – 2024-10-19

2024-10-22

2024-10-06 – 2024-10-12

2024-10-15

2024-09-29 – 2024-10-05

2024-10-08

2024-09-22 – 2024-09-28

2024-10-01

2024-09-15 – 2024-09-21

2024-09-24

2024-09-08 – 2024-09-14

2024-09-17

2024-09-01 – 2024-09-07

2024-09-10

2024-08-25 – 2024-08-31

2024-09-04

2024-08-18 – 2024-08-24

2024-08-27

2024-08-11 – 2024-08-17

2024-08-20

2024-08-04 – 2024-08-10

2024-08-13

2024-07-28 – 2024-08-03

2024-08-06

2024-07-21 – 2024-07-27

2024-07-30

2024-07-14 – 2024-07-20

2024-07-23

2024-07-07 – 2024-07-13

2024-07-16

2024-06-30 – 2024-07-06

2024-07-09

2024-06-23 – 2024-06-29

2024-07-02

2024-06-16 – 2024-06-22

2024-06-25

2024-06-09 – 2024-06-15

2024-06-18

2024-06-20

2024-06-02 – 2024-06-08

2024-06-11

2024-05-26 – 2024-06-01

2024-06-04

2024-06-07

2024-05-19 – 2024-05-25

2024-05-29

2024-05-12 – 2024-05-18

2024-05-21

2024-05-05 – 2024-05-11

2024-05-14

2024-04-28 – 2024-05-04

2024-05-07

2024-04-21 – 2024-04-27

2024-04-30

2024-04-14 – 2024-04-20

2024-04-23

2024-04-07 – 2024-04-13

2024-04-16

2024-04-18

2024-03-31 – 2024-04-06

2024-04-09

2024-04-13

2024-03-24 – 2024-03-30

2024-04-02

2024-03-17 – 2024-03-23

2024-03-26

2024-03-10 – 2024-03-16

2024-03-19

2024-03-03 – 2024-03-09

2024-03-12

2024-02-25 – 2024-03-02

2024-03-07

2024-02-18 – 2024-02-24

2024-03-07

2024-02-11 – 2024-02-17

2024-02-21

2024-02-04 – 2024-02-10

2024-02-13

2024-01-28 – 2024-02-03

2024-02-06

2024-01-21 – 2024-01-27

2024-01-30

2024-01-14 – 2024-01-20

2024-01-23

2024-01-07 – 2024-01-13

2024-01-16

2024-01-17

2023-12-31 – 2024-01-06

2024-01-09

2023-12-24 – 2023-12-30

2024-01-03

2023-12-17 – 2023-12-23

2023-12-27

2023-12-10 – 2023-12-16

2023-12-19

2023-12-03 – 2023-12-09

2023-12-11

2023-11-26 – 2023-12-02

2023-12-05

2023-11-19 – 2023-11-25

2023-11-28

2023-11-12 – 2023-11-18

2023-11-21

2023-11-05 – 2023-11-11

2023-11-14

2023-10-29 – 2023-11-04

2023-11-07

2023-10-22 – 2023-10-28

2023-10-31

2023-11-01

2023-10-15 – 2023-10-21

2023-10-24

2023-10-25

2023-10-08 – 2023-10-14

2023-10-17

2023-10-21

2023-10-01 – 2023-10-07

2023-10-11

2023-10-21

2023-09-24 – 2023-09-30

2023-10-03

2023-10-21

2023-09-17 – 2023-09-23

2023-09-27

2023-10-21

2023-09-03 – 2023-09-09

2023-09-11

2023-10-21

2023-08-27 – 2023-09-02

2023-09-06

2023-10-21

2023-08-20 – 2023-08-26

2023-08-29

2023-10-21

2023-08-13 – 2023-08-19

2023-08-22

2023-10-21

2023-08-06 – 2023-08-12

2023-08-15

2023-10-21

2023-07-30 – 2023-08-05

2023-08-08

2023-10-21

2023-07-23 – 2023-07-29

2023-08-01

2023-10-21

2023-07-16 – 2023-07-22

2023-07-25

2023-10-21

2023-07-09 – 2023-07-15

2023-07-19

2023-10-21

2023-07-02 – 2023-07-08

2023-07-11

2023-10-21

2023-06-25 – 2023-07-01

2023-07-05

2023-10-21

2023-06-18 – 2023-06-24

2023-06-27

2023-10-21

2023-05-28 – 2023-06-03

2023-06-05

2023-10-21

2023-05-21 – 2023-05-27

2023-05-30

2023-10-21

2023-10-11 – 2023-10-17

2023-10-17

2023-10-05 – 2023-10-11

2023-10-11

2023-09-27 – 2023-10-03

2023-10-03

2023-09-20 – 2023-09-26

2023-09-27

2023-09-30

2023-09-05 – 2023-09-11

2023-09-11

2023-08-31 – 2023-09-06

2023-09-06

2023-08-23 – 2023-08-29

2023-08-29

2023-08-30

2023-08-16 – 2023-08-22

2023-08-22

2023-08-29

2023-08-09 – 2023-08-15

2023-08-15

2023-08-29

2023-08-02 – 2023-08-08

2023-08-08

2023-08-29

2023-07-26 – 2023-08-01

2023-08-01

2023-08-29

2023-07-19 – 2023-07-25

2023-07-25

2023-08-29

2023-07-13 – 2023-07-19

2023-07-19

2023-08-29

2023-07-05 – 2023-07-11

2023-07-11

2023-08-29

2023-06-29 – 2023-07-05

2023-07-05

2023-08-29

2023-06-21 – 2023-06-27

2023-06-27

2023-08-29

2023-05-30 – 2023-06-05

2023-06-05

2023-08-29

2023-05-24 – 2023-05-30

2023-05-30

2023-08-29

Data dictionary

📋 9 data columns + 6 lineage columns

Data columns

Column

Type

Description

NPI

TEXT

National Provider Identifier (NPI) number of the Provider

PROVIDER_NAME

TEXT

ADDRESS_LINE_1

TEXT

ADDRESS_LINE_2

TEXT

CITY

TEXT

Provider's City

STATE

TEXT

Provider's State Abbreviation

ZIP

TEXT

Provider's Zip Code

MEDICARE_ID_EFFECTIVE_DATE

DATE

PHONE

TEXT

Provider's Phone number

Lineage columns (present on every feed table)

Column

Type

Description

ROW_ID

TEXT

Unique row ID for this table (PK)

FILE_ID

TEXT

Source file — joins to FEEDS_FILES.ID (FK)

FILE_FEED_ID

TEXT

Parent feed — joins to FEEDS.ID (FK)

FILE_NAME

TEXT

Source file name as published by CMS

ROWNUM

NUMBER

Row number within the source file

CREATED_AT

TIMESTAMP_NTZ

Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.NPI, d.PROVIDER_NAME, d.ADDRESS_LINE_1,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.OPIOID_TREATMENT_PROGRAM_PROVIDERS d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

Frequently asked questions

How often is Opioid Treatment Program Providers updated?

Weekly. CMS last published this feed on 2026-07-07, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them.

What years does Opioid Treatment Program Providers cover?

2023 through 2026.

How many records are in Opioid Treatment Program Providers?

266,922 rows across all 178 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed.

How do I get Opioid Treatment Program Providers data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.OPIOID_TREATMENT_PROGRAM_PROVIDERS directly — no pipeline setup required.

Opt Out Affidavits Skilled Nursing Facility Enrollments Medicare Quarterly Part B Spending by Drug Fiscal Intermediary Shared System Attending and Rendering Provider of Services File - Internet Quality Improvement and Evaluation System

Get this feed

Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share — the database and DWV schema appear in your account immediately
Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at notifications@dataplex-consulting.com.

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →

PreviousNursing Homes Including Rehab Services - Survey Summary NextOpt Out Affidavits

Last updated 6 days ago

Key facts

Sample queries

About this feed

Coverage timeline

Release history

Data dictionary

Row-level lineage

Source & provenance

Frequently asked questions

How often is Opioid Treatment Program Providers updated?

What years does Opioid Treatment Program Providers cover?

How many records are in Opioid Treatment Program Providers?

How do I get Opioid Treatment Program Providers data?

Related feeds

Get this feed