Ambulatory Surgical Center Quality Measures - State

This file contains state-level data for all measures reported through the Ambulatory Surgical Center Quality Reporting (ASCQR) Program.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE on Snowflake and Databricks: five snapshot releases spanning 2024–2025, aligned to a single 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.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE
Databricks	cms_dwv.ambulatory_surgical_center_quality_measures__state
Cadence	Quarterly
Update pattern	Full-refresh; each file replaces the prior snapshot
CMS published	2025-12-16
Loaded	2026-02-28
Columns	52 data + 6 lineage
File versions	5
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.

Last CMS publication 2025-12-16: awaiting the next release. New files load automatically when CMS publishes.

Full-refresh feed: each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM cms_dwv.ambulatory_surgical_center_quality_measures__state
WHERE file_id IN (
  SELECT id FROM cms_dwv.feeds_files WHERE is_latest = 1
)
LIMIT 100;

About this feed

This file contains state-level data for all measures reported through the Ambulatory Surgical Center Quality Reporting (ASCQR) Program.

Source: CMS feed metadata

Keywords: Medicare, Ambulatory Surgical Center Quality Measures - State Theme: Medicare

Coverage timeline

2024 🟩 · 2025 🟩

2 of 2 years with snapshot releases, no gaps.

Release history

Reporting period	Data as of	Loaded	Latest file
Snapshot as of 2025-12-16	2025-12-16	2026-02-28	✓
Snapshot as of 2025-10-01	2025-10-01	2025-11-28
Snapshot as of 2025-06-27	2025-06-27	2025-08-06
Snapshot as of 2025-01-15	2025-01-15	2025-02-27
Snapshot as of 2024-10-10	2024-10-10	2024-12-14

Data dictionary

📋 52 data columns + 6 lineage columns

Data columns

Column	Type	Description
STATE	TEXT
YEAR	TEXT
AVG_ASC_1_STATE_RATE_	TEXT	AVG ASC-1 STATE RATE*
MEDIAN_ASC_1_STATE_RATE_	TEXT	MEDIAN ASC-1 STATE RATE*
AVG_ASC_2_STATE_RATE_	TEXT	AVG ASC-2 STATE RATE*
MEDIAN_ASC_2_STATE_RATE_	TEXT	MEDIAN ASC-2 STATE RATE*
AVG_ASC_3_STATE_RATE_	TEXT	AVG ASC-3 STATE RATE*
MEDIAN_ASC_3_STATE_RATE_	TEXT	MEDIAN ASC-3 STATE RATE*
AVG_ASC_4_STATE_RATE_	TEXT	AVG ASC-4 STATE RATE*
MEDIAN_ASC_4_STATE_RATE_	TEXT	MEDIAN ASC-4 STATE RATE*
AVG_ASC_9_STATE_RATE_	TEXT	AVG ASC-9 STATE RATE*
MEDIAN_ASC_9_STATE_RATE_	TEXT	MEDIAN ASC-9 STATE RATE*
AVG_ASC_11_STATE_RATE_	TEXT	AVG ASC-11 STATE RATE*
MEDIAN_ASC_11_STATE_RATE_	TEXT	MEDIAN ASC-11 STATE RATE*
ASC_12_BETTER	TEXT	ASC-12 BETTER
ASC_12_NO_DIFFERENT	TEXT	ASC-12 NO DIFFERENT
ASC_12_WORSE	TEXT	ASC-12 WORSE
ASC_12_TOO_SMALL	TEXT	ASC-12 TOO SMALL
AVG_ASC_13_STATE_RATE_	TEXT	AVG ASC-13 STATE RATE*
MEDIAN_ASC_13_STATE_RATE_	TEXT	MEDIAN ASC-13 STATE RATE*
AVG_ASC_14_STATE_RATE_	TEXT	AVG ASC-14 STATE RATE*
MEDIAN_ASC_14_STATE_RATE_	TEXT	MEDIAN ASC-14 STATE RATE*
ASC_17_BETTER	TEXT	ASC-17 BETTER
ASC_17_NO_DIFFERENT	TEXT	ASC-17 NO DIFFERENT
ASC_17_WORSE	TEXT	ASC-17 WORSE
ASC_17_TOO_SMALL	TEXT	ASC-17 TOO SMALL
ASC_18_BETTER	TEXT	ASC-18 BETTER
ASC_18_NO_DIFFERENT	TEXT	ASC-18 NO DIFFERENT
ASC_18_WORSE	TEXT	ASC-18 WORSE
ASC_18_TOO_SMALL	TEXT	ASC-18 TOO SMALL
ASC_19_BETTER	TEXT	ASC-19 BETTER
ASC_19_NO_DIFFERENT	TEXT	ASC-19 NO DIFFERENT
ASC_19_WORSE	TEXT	ASC-19 WORSE
ASC_19_TOO_SMALL	TEXT	ASC-19 TOO SMALL
AVG_ASC_1_STATE_RATE	TEXT	AVG ASC-1 STATE RATE
MEDIAN_ASC_1_STATE_RATE	TEXT	MEDIAN ASC-1 STATE RATE
AVG_ASC_2_STATE_RATE	TEXT	AVG ASC-2 STATE RATE
MEDIAN_ASC_2_STATE_RATE	TEXT	MEDIAN ASC-2 STATE RATE
AVG_ASC_3_STATE_RATE	TEXT	AVG ASC-3 STATE RATE
MEDIAN_ASC_3_STATE_RATE	TEXT	MEDIAN ASC-3 STATE RATE
AVG_ASC_4_STATE_RATE	TEXT	AVG ASC-4 STATE RATE
MEDIAN_ASC_4_STATE_RATE	TEXT	MEDIAN ASC-4 STATE RATE
AVG_ASC_9_STATE_RATE	TEXT	AVG ASC-9 STATE RATE
MEDIAN_ASC_9_STATE_RATE	TEXT	MEDIAN ASC-9 STATE RATE
AVG_ASC_11_STATE_RATE	TEXT	AVG ASC-11 STATE RATE
MEDIAN_ASC_11_STATE_RATE	TEXT	MEDIAN ASC-11 STATE RATE
AVG_ASC_13_STATE_RATE	TEXT	AVG ASC-13 STATE RATE
MEDIAN_ASC_13_STATE_RATE	TEXT	MEDIAN ASC-13 STATE RATE
AVG_ASC_14_STATE_RATE	TEXT	AVG ASC-14 STATE RATE
MEDIAN_ASC_14_STATE_RATE	TEXT	MEDIAN ASC-14 STATE RATE
AVG_ASC_20_STATE_RATE	TEXT	AVG ASC-20 STATE RATE
AVG_ASC_20_STATE_RATE_	TEXT	AVG ASC-20 STATE RATE*

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:

Snowflake

SELECT d.STATE, d.YEAR, d.AVG_ASC_1_STATE_RATE_,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Databricks

SELECT d.state, d.year, d.avg_asc_1_state_rate_,
       ff.temporal_start, ff.temporal_end, ff.cms_feed_modified
FROM cms_dwv.ambulatory_surgical_center_quality_measures__state d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation

Frequently asked questions

How often is Ambulatory Surgical Center Quality Measures - State updated?

Quarterly. CMS last published this feed on 2025-12-16, and Dataplex loaded it to the warehouse on 2026-02-28. New releases are added automatically when CMS publishes them.

What years does Ambulatory Surgical Center Quality Measures - State cover?

2024 through 2025.

How many records are in Ambulatory Surgical Center Quality Measures - State?

Count the current snapshot yourself once the share is mounted:

Snowflake

SELECT COUNT(*)
FROM DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

Databricks

SELECT COUNT(*)
FROM cms_dwv.ambulatory_surgical_center_quality_measures__state d
JOIN cms_dwv.feeds_files ff ON d.file_id = ff.id
WHERE ff.is_latest = 1;

How do I get Ambulatory Surgical Center Quality Measures - State 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.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__STATE directly; no pipeline setup required.

Related feeds

Quarterly Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information - pricingHospital Change of OwnershipMonthly Prescription Drug Plan Formulary and Pharmacy Network Information - insulin_beneficiary_costInnovation Center Webinars and ForumsSkilled Nursing Facility Change of Ownership - Owner Information

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share; the database and DWV schema appear in your account immediately

3. Run the sample query above; no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

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