cms-pac-puf-snf/2024-01-01

Source: Centers for Medicare & Medicaid Services, Medicare Post-Acute Care Utilization, Skilled Nursing Facility; pinned object gs://gavel-mrf-dev-mrf/pubdata/cms-pac-puf-snf/vintage=2024-01-01/data.parquet#1789442345304538; Summary categories must be selected before aggregation; provider and geography rows overlap. Payments are published Medicare measures, not provider costs, patient-specific observed payments, or avoidable savings. Suppressed source strings remain strings; no coercion or invented zero.. Source vintage: Source vintage 2024-01-01; republished in website build over package vintage 2026-10-01. Grain: One published SNF provider or geography summary row in the source data year and summary category, containing stays, days and Medicare payment measures.. Snapshot: 7a53af6a9beb58928d4a64dc92db09c9db65433f9909f1a10d16e302adaf86ba.

Read the method for this source

Explore this source with typed OData queries · Filtering, grouping and evidence method

Schema and filter instructions · Count this selection · First records

Filters: eq.column, lt.column, le.column, gt.column, ge.column; isnull.column=true|false. Values are cast to the source type. Projection: columns=a,b. Order: order=a:asc,b:desc with stable physical row identity as final tie-breaker. OData uses the property names in the last column; RowId identifies the same physical source record.

ColumnTypeOData property
YEARVARCHARYEAR
YEAR_TYPEVARCHARYEAR_TYPE
SMRY_CTGRYVARCHARSMRY_CTGRY
SRVC_CTGRYVARCHARSRVC_CTGRY
PRVDR_IDVARCHARPRVDR_ID
PRVDR_NAMEVARCHARPRVDR_NAME
PRVDR_CITYVARCHARPRVDR_CITY
STATEVARCHARSTATE
PRVDR_ZIPVARCHARPRVDR_ZIP
BENE_DSTNCT_CNTVARCHARBENE_DSTNCT_CNT
TOT_EPSD_STAY_CNTVARCHARTOT_EPSD_STAY_CNT
TOT_SRVC_DAYSVARCHARTOT_SRVC_DAYS
TOT_CHRG_AMTVARCHARTOT_CHRG_AMT
TOT_ALOWD_AMTVARCHARTOT_ALOWD_AMT
TOT_MDCR_PYMT_AMTVARCHARTOT_MDCR_PYMT_AMT
TOT_MDCR_STDZD_PYMT_AMTVARCHARTOT_MDCR_STDZD_PYMT_AMT
BENE_DUAL_PCTVARCHARBENE_DUAL_PCT
BENE_RRL_PCTVARCHARBENE_RRL_PCT
BENE_AVG_AGEVARCHARBENE_AVG_AGE
BENE_MALE_PCTVARCHARBENE_MALE_PCT
BENE_FEML_PCTVARCHARBENE_FEML_PCT
BENE_RACE_WHT_PCTVARCHARBENE_RACE_WHT_PCT
BENE_RACE_BLACK_PCTVARCHARBENE_RACE_BLACK_PCT
BENE_RACE_API_PCTVARCHARBENE_RACE_API_PCT
BENE_RACE_HSPNC_PCTVARCHARBENE_RACE_HSPNC_PCT
BENE_RACE_NATIND_PCTVARCHARBENE_RACE_NATIND_PCT
BENE_RACE_UNK_PCTVARCHARBENE_RACE_UNK_PCT
BENE_RACE_OTHR_PCTVARCHARBENE_RACE_OTHR_PCT
BENE_AVG_RISK_SCREVARCHARBENE_AVG_RISK_SCRE
BENE_CC_BH_ADHD_OTHCD_V1_PCTVARCHARBENE_CC_BH_ADHD_OTHCD_V1_PCT
BENE_CC_BH_ALCOHOL_DRUG_V1_PCTVARCHARBENE_CC_BH_ALCOHOL_DRUG_V1_PCT
BENE_CC_BH_ALZ_NONALZDEM_V2_PCTVARCHARBENE_CC_BH_ALZ_NONALZDEM_V2_PCT
BENE_CC_BH_ANXIETY_V1_PCTVARCHARBENE_CC_BH_ANXIETY_V1_PCT
BENE_CC_BH_BIPOLAR_V1_PCTVARCHARBENE_CC_BH_BIPOLAR_V1_PCT
BENE_CC_BH_DEPRESS_V1_PCTVARCHARBENE_CC_BH_DEPRESS_V1_PCT
BENE_CC_BH_MOOD_V2_PCTVARCHARBENE_CC_BH_MOOD_V2_PCT
BENE_CC_BH_PD_V1_PCTVARCHARBENE_CC_BH_PD_V1_PCT
BENE_CC_BH_PTSD_V1_PCTVARCHARBENE_CC_BH_PTSD_V1_PCT
BENE_CC_BH_SCHIZO_OTHPSY_V1_PCTVARCHARBENE_CC_BH_SCHIZO_OTHPSY_V1_PCT
BENE_CC_BH_TOBACCO_V1_PCTVARCHARBENE_CC_BH_TOBACCO_V1_PCT
BENE_CC_PH_AFIB_V2_PCTVARCHARBENE_CC_PH_AFIB_V2_PCT
BENE_CC_PH_ARTHRITIS_V2_PCTVARCHARBENE_CC_PH_ARTHRITIS_V2_PCT
BENE_CC_PH_ASTHMA_V2_PCTVARCHARBENE_CC_PH_ASTHMA_V2_PCT
BENE_CC_PH_CANCER6_V2_PCTVARCHARBENE_CC_PH_CANCER6_V2_PCT
BENE_CC_PH_CKD_V2_PCTVARCHARBENE_CC_PH_CKD_V2_PCT
BENE_CC_PH_COPD_V2_PCTVARCHARBENE_CC_PH_COPD_V2_PCT
BENE_CC_PH_DIABETES_V2_PCTVARCHARBENE_CC_PH_DIABETES_V2_PCT
BENE_CC_PH_HF_NONIHD_V2_PCTVARCHARBENE_CC_PH_HF_NONIHD_V2_PCT
BENE_CC_PH_HYPERLIPIDEMIA_V2_PCTVARCHARBENE_CC_PH_HYPERLIPIDEMIA_V2_PCT
BENE_CC_PH_HYPERTENSION_V2_PCTVARCHARBENE_CC_PH_HYPERTENSION_V2_PCT
BENE_CC_PH_ISCHEMICHEART_V2_PCTVARCHARBENE_CC_PH_ISCHEMICHEART_V2_PCT
BENE_CC_PH_OSTEOPOROSIS_V2_PCTVARCHARBENE_CC_PH_OSTEOPOROSIS_V2_PCT
BENE_CC_PH_PARKINSON_V2_PCTVARCHARBENE_CC_PH_PARKINSON_V2_PCT
BENE_CC_PH_STROKE_TIA_V2_PCTVARCHARBENE_CC_PH_STROKE_TIA_V2_PCT
PRMRY_DX_INFCTN_PCTVARCHARPRMRY_DX_INFCTN_PCT
PRMRY_DX_NEOBLD_PCTVARCHARPRMRY_DX_NEOBLD_PCT
PRMRY_DX_ENDONUTRMET_PCTVARCHARPRMRY_DX_ENDONUTRMET_PCT
PRMRY_DX_MNTBEHNEUDIS_PCTVARCHARPRMRY_DX_MNTBEHNEUDIS_PCT
PRMRY_DX_NERVSYSTM_PCTVARCHARPRMRY_DX_NERVSYSTM_PCT
PRMRY_DX_ENTSYS_PCTVARCHARPRMRY_DX_ENTSYS_PCT
PRMRY_DX_CIRCSYSTM_PCTVARCHARPRMRY_DX_CIRCSYSTM_PCT
PRMRY_DX_RSPSYSTM_PCTVARCHARPRMRY_DX_RSPSYSTM_PCT
PRMRY_DX_DIGSYSTM_PCTVARCHARPRMRY_DX_DIGSYSTM_PCT
PRMRY_DX_SKNMUSSYSTM_PCTVARCHARPRMRY_DX_SKNMUSSYSTM_PCT
PRMRY_DX_GUSYSTM_PCTVARCHARPRMRY_DX_GUSYSTM_PCT
PRMRY_DX_PRGPERICONG_PCTVARCHARPRMRY_DX_PRGPERICONG_PCT
PRMRY_DX_SXILLDEF_PCTVARCHARPRMRY_DX_SXILLDEF_PCT
PRMRY_DX_INJPOIS_PCTVARCHARPRMRY_DX_INJPOIS_PCT
PRMRY_DX_HLTHSRV_PCTVARCHARPRMRY_DX_HLTHSRV_PCT
filenameVARCHARfilename
vintageDATEvintage