Pioneer ACO Model

The Pioneer Accountable Care Organization (ACO) Model Public Use File (PUF) provides information on ACOs participating in the model.

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.PIONEER_ACO_MODEL on Snowflake and Databricks — five annual reporting periods (2012–2016) 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.PIONEER_ACO_MODEL
Databricks	cms_dwv.pioneer_aco_model
Coverage	Jan 2012 – Dec 2016 (5 of 5 annual reporting periods)
Rows	95 (total across all reporting periods)
Cadence	Annual
Update pattern	Time-partitioned — each file adds one reporting year
CMS published	2023-05-25
Loaded	2023-08-29
Columns	113 data + 6 lineage
Identifiers	ACO ID
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 2023-05-25 — awaiting the next release. New files load automatically when CMS publishes.

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

Sample queries

Snowflake

-- Each file version covers one reporting period (2012, 2013, 2014, 2015, 2016) — history is additive
SELECT *
FROM DWV.PIONEER_ACO_MODEL
LIMIT 100;

Databricks

About this feed

The Pioneer Accountable Care Organization (ACO) Model Public Use File (PUF) provides information on ACOs participating in the model. This dataset includes information on each ACO regarding beneficiaries, financial and quality results.

— Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Value-Based Care, Coordinated Care, Payment Models, Accountable Care Organizations Theme: Medicare

Coverage timeline

2012 🟩 · 2013 🟩 · 2014 🟩 · 2015 🟩 · 2016 🟩

5 of 5 annual reporting periods present — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2016-01-01 – 2016-12-31	2023-05-25	2023-08-29	✓
2015-01-01 – 2015-12-31	2023-05-25	2023-08-29
2014-01-01 – 2014-12-31	2023-05-25	2023-08-29
2013-01-01 – 2013-12-31	2023-05-25	2023-08-29
2012-01-01 – 2012-12-31	2023-05-25	2023-08-29

Data dictionary

📋 113 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Pioneer ACO Model data dictionary.

Data columns

Column	Type
ACO_ID	TEXT
ACO_NAME	TEXT
PERF_YR	NUMBER
PBP_ELECTION	TEXT
BENE_CT	NUMBER
MNTH_PY	NUMBER
BNMRK_EXPND	NUMBER
PERF_YR_EXPND	NUMBER
GROSS_SAVINGS	NUMBER
SHARED_SAVINGS	NUMBER
QUAL_SCRE	NUMBER
MNTH_AD_BY1	NUMBER
EXPND_AD_BY1	NUMBER
RISK_SCRE_AD_BY1	NUMBER
MNTH_AD_BY2	NUMBER
EXPND_AD_BY2	NUMBER
RISK_SCRE_AD_BY2	NUMBER
MNTH_AD_BY3	NUMBER
EXPND_AD_BY3	NUMBER
RISK_SCRE_AD_BY3	NUMBER
BNMRK_AD	NUMBER
RISK_SCRE_AD_PY	NUMBER
MNTH_AN_BY1	NUMBER
EXPND_AN_BY1	NUMBER
RISK_SCRE_AN_BY1	NUMBER
MNTH_AN_BY2	NUMBER
EXPND_AN_BY2	NUMBER
RISK_SCRE_AN_BY2	NUMBER
MNTH_AN_BY3	NUMBER
EXPND_AN_BY3	NUMBER
RISK_SCRE_AN_BY3	NUMBER
BNMRK_AN	NUMBER
RISK_SCRE_AN_PY	NUMBER
MNTH_DISA_BY1	NUMBER
EXPND_DISA_BY1	NUMBER
RISK_SCRE_DISA_BY1	NUMBER
MNTH_DISA_BY2	NUMBER
EXPND_DISA_BY2	NUMBER
RISK_SCRE_DISA_BY2	NUMBER
MNTH_DISA_BY3	NUMBER
EXPND_DISA_BY3	NUMBER
RISK_SCRE_DISA_BY3	NUMBER
BNMRK_DISA	NUMBER
RISK_SCRE_DISA_PY	NUMBER
MNTH_ESRD_BY1	NUMBER
EXPND_ESRD_BY1	NUMBER
RISK_SCRE_ESRD_BY1	NUMBER
MNTH_ESRD_BY2	NUMBER
EXPND_ESRD_BY2	NUMBER
RISK_SCRE_ESRD_BY2	NUMBER
MNTH_ESRD_BY3	NUMBER
EXPND_ESRD_BY3	NUMBER
RISK_SCRE_ESRD_BY3	NUMBER
BNMRK_ESRD	NUMBER
RISK_SCRE_ESRD_PY	NUMBER
EXPND_HHA	NUMBER
EXPND_SNF	NUMBER
EXPND_OUTP	NUMBER
EXPND_HOSP	NUMBER
EXPND_INP	NUMBER
EXPND_PROF	NUMBER
EXPND_DME	NUMBER
PRFM_YR	TEXT
CMMI_NAME	TEXT
PRVDR_CT	NUMBER
PRAC_CT	NUMBER
PROF_PRAC_CT	NUMBER
INST_PRAC_CT	NUMBER
PROF_PRVDR_CT	NUMBER
PAR_FAC_CT	NUMBER
PCP_PRVDR_CT	NUMBER
ALGN_COUNT	NUMBER
AGED_COUNT	NUMBER
DISABLED_COUNT	NUMBER
ESRD_COUNT	NUMBER
MALE_COUNT	NUMBER
FEMALE_COUNT	NUMBER
AGE_LT65_COUNT	NUMBER
AGE_6569_COUNT	NUMBER
AGE_7079_COUNT	NUMBER
AGE_GE80	NUMBER
EXP_TOT	NUMBER
EXP_NCH10	NUMBER
EXP_NCH20	NUMBER
EXP_NCH30	NUMBER
EXP_NCH40	NUMBER
EXP_NCH50	NUMBER
EXP_NCH60	NUMBER
EXP_NCH71	NUMBER
EXP_NCH72	NUMBER
EXP_NCH81	NUMBER
EXP_NCH82	NUMBER
STLMNT_DT	NUMBER
ALGND_BENE_CT	NUMBER
ALGND_BENE_MNTHS	NUMBER
ACO_BASELINE_PBPY	NUMBER
ADJ_REF_BASELINE_PBPY	NUMBER
ADJ_REF_PERFYEAR_PBPY	NUMBER
REF_PBPY_CHNG	NUMBER
REF_PBPY_TRND	NUMBER
ACO_PBPY_TRND_CMPNT	NUMBER
ACO_BLND_PBPY_INCR	NUMBER
ACO_BNMRK_PBPY	NUMBER
ACO_PERFYEAR_PBPY	NUMBER
GROSS_SAVINGS_PBPY	NUMBER
BNCHMRK_EXPEND	NUMBER
ACO_PERFYEAR_EXPND	NUMBER
PERFYEAR_QUAL_SCRE	NUMBER
QLTY_ADJ_SSL_RATE	NUMBER
BNCH_MTHD	NUMBER
AWI_GPCI_ADJ	NUMBER
RISK_ARNGMNT	TEXT
MSR	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.ACO_ID, d.ACO_NAME, d.PERF_YR,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.PIONEER_ACO_MODEL 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).

• Official CMS data dictionary

• Pioneer ACO Model Methodology

Frequently asked questions

How often is Pioneer ACO Model updated?

Annually. CMS last published this feed on 2023-05-25, and Dataplex loaded it to the warehouse on 2023-08-29. New releases are added automatically when CMS publishes them.

What years does Pioneer ACO Model cover?

2012 through 2016 — five annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side.

How many records are in Pioneer ACO Model?

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

How do I get Pioneer ACO Model 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.PIONEER_ACO_MODEL directly — no pipeline setup required.

Related feeds

Realizing Equity, Access, and Community Health ACOsPrepaid Shared Savings Spend PlanACO REACH ProvidersACO Realizing Equity, Access and Community Health Aligned BeneficiariesPerformance Year Financial and Quality Results

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 →