Ambulatory Surgical Center Quality Measures - Facility

A list of ambulatory surgical centers participating in the Ambulatory Surgical Center Quality Reporting (ASCQR) Program and their performance rates.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__FACILITY 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__FACILITY
Databricks	cms_dwv.ambulatory_surgical_center_quality_measures__facility
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2025-12-16
Loaded	2026-02-28
Columns	59 data + 6 lineage
Identifiers	NPI · ZIP codes
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__FACILITY
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

A list of ambulatory surgical centers participating in the Ambulatory Surgical Center Quality Reporting (ASCQR) Program and their performance rates.

— Source: CMS feed metadata

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

Coverage timeline

2024 🟩 · 2025 🟩

2 of 2 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	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-07

Data dictionary

📋 59 data columns + 6 lineage columns

Data columns

Column	Type	Description
FACILITY_NAME	TEXT
FACILITY_ID	TEXT
NPI	NUMBER
CITY_TOWN	TEXT	CITY/TOWN
STATE	TEXT
ZIP_CODE	TEXT
YEAR	TEXT
ASC_1_RATE_	TEXT	ASC-1 RATE*
ASC_1_FOOTNOTE	NUMBER	ASC-1 FOOTNOTE
ASC_2_RATE_	TEXT	ASC-2 RATE*
ASC_2_FOOTNOTE	NUMBER	ASC-2 FOOTNOTE
ASC_3_RATE_	TEXT	ASC-3 RATE*
ASC_3_FOOTNOTE	NUMBER	ASC-3 FOOTNOTE
ASC_4_RATE_	TEXT	ASC-4 RATE*
ASC_4_FOOTNOTE	NUMBER	ASC-4 FOOTNOTE
ASC_9_RATE_	TEXT	ASC-9 RATE*
ASC_9_FOOTNOTE	NUMBER	ASC-9 FOOTNOTE
ASC_11_RATE_	TEXT	ASC-11 RATE*
ASC_11_FOOTNOTE	NUMBER	ASC-11 FOOTNOTE
ASC_12_TOTAL_CASES	TEXT	ASC-12 TOTAL CASES
ASC_12_PERFORMANCE_CATEGORY	TEXT	ASC-12 PERFORMANCE CATEGORY
ASC_12_RSHV_RATE	TEXT	ASC-12 RSHV RATE
ASC_12_INTERVAL_LOWER_LIMIT	TEXT	ASC-12 INTERVAL LOWER LIMIT
ASC_12_INTERVAL_UPPER_LIMIT	TEXT	ASC-12 INTERVAL UPPER LIMIT
ASC_12_FOOTNOTE	NUMBER	ASC-12 FOOTNOTE
ASC_13_RATE_	TEXT	ASC-13 RATE*
ASC_13_FOOTNOTE	NUMBER	ASC-13 FOOTNOTE
ASC_14_RATE_	TEXT	ASC-14 RATE*
ASC_14_FOOTNOTE	NUMBER	ASC-14 FOOTNOTE
ASC_17_TOTAL_CASES	TEXT	ASC-17 TOTAL CASES
ASC_17_PERFORMANCE_CATEGORY	TEXT	ASC-17 PERFORMANCE CATEGORY
ASC_17_RSHV_RATE	TEXT	ASC-17 RSHV RATE
ASC_17_INTERVAL_LOWER_LIMIT	TEXT	ASC-17 INTERVAL LOWER LIMIT
ASC_17_INTERVAL_UPPER_LIMIT	TEXT	ASC-17 INTERVAL UPPER LIMIT
ASC_17_FOOTNOTE	NUMBER	ASC-17 FOOTNOTE
ASC_18_TOTAL_CASES	TEXT	ASC-18 TOTAL CASES
ASC_18_PERFORMANCE_CATEGORY	TEXT	ASC-18 PERFORMANCE CATEGORY
ASC_18_RSHV_RATE	TEXT	ASC-18 RSHV RATE
ASC_18_INTERVAL_LOWER_LIMIT	TEXT	ASC-18 INTERVAL LOWER LIMIT
ASC_18_INTERVAL_UPPER_LIMIT	TEXT	ASC-18 INTERVAL UPPER LIMIT
ASC_18_FOOTNOTE	NUMBER	ASC-18 FOOTNOTE
ASC_19_TOTAL_CASES	TEXT	ASC-19 TOTAL CASES
ASC_19_PERFORMANCE_CATEGORY	TEXT	ASC-19 PERFORMANCE CATEGORY
ASC_19_RSHV_RATE	TEXT	ASC-19 RSHV RATE
ASC_19_INTERVAL_LOWER_LIMIT	TEXT	ASC-19 INTERVAL LOWER LIMIT
ASC_19_INTERVAL_UPPER_LIMIT	TEXT	ASC-19 INTERVAL UPPER LIMIT
ASC_19_FOOTNOTE	NUMBER	ASC-19 FOOTNOTE
ASC_1_RATE	TEXT	ASC-1 RATE
ASC_2_RATE	TEXT	ASC-2 RATE
ASC_3_RATE	TEXT	ASC-3 RATE
ASC_4_RATE	TEXT	ASC-4 RATE
ASC_9_RATE	TEXT	ASC-9 RATE
ASC_11_RATE	TEXT	ASC-11 RATE
ASC_13_RATE	TEXT	ASC-13 RATE
ASC_14_RATE	TEXT	ASC-14 RATE
ASC_20_SAMPLE	NUMBER	ASC-20 SAMPLE
ASC_20_RATE	TEXT	ASC-20 RATE
ASC_20_RATE_	TEXT	ASC-20 RATE*
ASC_20_FOOTNOTE	NUMBER	ASC-20 FOOTNOTE

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.FACILITY_NAME, d.FACILITY_ID, d.NPI,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.AMBULATORY_SURGICAL_CENTER_QUALITY_MEASURES__FACILITY d
JOIN 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 - Facility updated?

CMS last published this feed on 2025-12-16. New releases are added automatically when CMS publishes them.

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

2024 through 2025.

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

Count the current snapshot yourself once the share is mounted:

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

How do I get Ambulatory Surgical Center Quality Measures - Facility 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__FACILITY directly — no pipeline setup required.

Related feeds

Next Generation Accountable Care Organization Model DataMonthly Prescription Drug Plan Formulary and Pharmacy Network Information - pharmacy_networkMedicare Fee-For-Service Public Provider EnrollmentQuarterly Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information - beneficiary_costHistorical Hospital Patient Safety Indicators (PSI) Dataset

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 →