For the complete documentation index, see llms.txt. This page is also available as Markdown.

Provider of Services File - Quality Improvement and Evaluation System

The Provider of Services File (POS) - Quality Improvement and Evaluation System (QIES) data provides provider demographic and associated certification…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM on Snowflake and Databricks — coverage from 2011 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.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM

Databricks

cms_dwv.provider_of_services_file__quality_improvement_and_evaluation_system

Coverage

Oct 2011 – Mar 2026

Rows

3,496,832 (total across all reporting periods)

Cadence

Quarterly

Update pattern

Time-partitioned — each file adds one reporting period

CMS published

2026-04-15

Loaded

2026-04-15

Columns

595 data + 6 lineage

Identifiers

FIPS codes · ZIP codes

File versions

37

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.

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

About this feed

The Provider of Services File (POS) - Quality Improvement and Evaluation System (QIES) data provides provider demographic and associated certification information for hospital & non-hospital facilities along with the provider number (CMS Certification Number), name, address, and other characteristics of the participating providers.

Source: CMS feed metadata

Keywords: Medicare, Original Medicare, Medicare Advantage, Hospitals & Facilities, Inpatient, Outpatient Facilities, Provider Enrollment Theme: Medicare

Coverage timeline

2011–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

16 of 16 years covered — no gaps.

Release history

Reporting period
CMS published
Loaded
Latest file

2026-01-01 – 2026-03-31

2026-04-15

2026-04-15

2025-10-01 – 2025-12-31

2026-01-12

2026-01-12

2025-07-01 – 2025-09-30

2025-12-10

2025-12-11

2025-04-01 – 2025-06-30

2025-08-07

2025-12-11

2025-01-01 – 2025-03-31

2025-04-25

2025-12-11

2024-10-01 – 2024-12-31

2025-01-31

2025-12-11

2024-07-01 – 2024-09-30

2024-10-15

2025-12-11

2024-04-01 – 2024-06-30

2024-07-18

2025-12-11

2024-01-01 – 2024-03-31

2024-04-11

2025-12-11

2023-10-01 – 2023-12-31

2024-02-27

2025-12-11

Show 27 earlier file versions
Reporting period
CMS published
Loaded
Latest file

2023-07-01 – 2023-09-30

2023-10-17

2025-12-11

2023-04-01 – 2023-06-30

2023-07-26

2025-12-11

2023-01-01 – 2023-03-31

2023-05-11

2025-12-11

2022-10-01 – 2022-12-31

2023-03-07

2025-12-11

2022-07-01 – 2022-09-30

2022-10-25

2025-12-11

2022-04-01 – 2022-06-30

2022-09-19

2025-12-11

2022-01-01 – 2022-03-31

2022-04-14

2025-12-11

2021-10-01 – 2021-12-31

2022-01-10

2025-12-11

2021-07-01 – 2021-09-30

2021-10-29

2025-12-11

2021-04-01 – 2021-06-30

2021-07-23

2025-12-11

2021-01-01 – 2021-03-31

2021-07-20

2025-12-11

2020-10-01 – 2020-12-31

2021-05-20

2025-12-11

2020-07-01 – 2020-09-30

2021-05-20

2025-12-11

2020-04-01 – 2020-06-30

2020-12-21

2025-12-11

2020-01-01 – 2020-03-31

2020-12-21

2025-12-11

2019-10-01 – 2019-12-31

2021-01-11

2025-12-11

2019-07-01 – 2019-09-30

2022-01-04

2025-12-11

2019-04-01 – 2019-06-30

2021-01-11

2025-12-11

2019-01-01 – 2019-03-31

2021-01-11

2025-12-11

2018-10-01 – 2018-12-31

2021-01-11

2025-12-11

2017-10-01 – 2017-12-31

2021-01-11

2025-12-11

2016-10-01 – 2016-12-31

2021-05-20

2025-12-11

2015-10-01 – 2015-12-31

2021-05-20

2025-12-11

2014-10-01 – 2014-12-31

2021-05-20

2025-12-11

2013-10-01 – 2013-12-31

2021-05-20

2025-12-11

2012-10-01 – 2012-12-31

2021-05-20

2025-12-11

2011-10-01 – 2011-12-31

2021-05-20

2025-12-11

Data dictionary

📋 595 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Provider of Services File - Quality Improvement and Evaluation System data dictionary.

Data columns

Column
Type

PRVDR_CTGRY_SBTYP_CD

NUMBER

PRVDR_CTGRY_CD

NUMBER

CHOW_CNT

NUMBER

CHOW_DT

NUMBER

CITY_NAME

TEXT

ACPTBL_POC_SW

BOOLEAN

CMPLNC_STUS_CD

TEXT

SSA_CNTY_CD

NUMBER

CROSS_REF_PROVIDER_NUMBER

TEXT

CRTFCTN_DT

NUMBER

ELGBLTY_SW

BOOLEAN

FAC_NAME

TEXT

INTRMDRY_CARR_CD

NUMBER

MDCD_VNDR_NUM

TEXT

ORGNL_PRTCPTN_DT

NUMBER

CHOW_PRIOR_DT

NUMBER

INTRMDRY_CARR_PRIOR_CD

NUMBER

PRVDR_NUM

TEXT

RGN_CD

NUMBER

SKLTN_REC_SW

BOOLEAN

STATE_CD

TEXT

SSA_STATE_CD

NUMBER

STATE_RGN_CD

TEXT

ST_ADR

TEXT

PHNE_NUM

NUMBER

PGM_TRMNTN_CD

NUMBER

TRMNTN_EXPRTN_DT

NUMBER

CRTFCTN_ACTN_TYPE_CD

NUMBER

GNRL_CNTL_TYPE_CD

TEXT

ZIP_CD

TEXT

FIPS_STATE_CD

NUMBER

FIPS_CNTY_CD

NUMBER

CBSA_URBN_RRL_IND

TEXT

CBSA_CD

NUMBER

ACRDTN_EFCTV_DT

NUMBER

ACRDTN_EXPRTN_DT

NUMBER

ACRDTN_TYPE_CD

NUMBER

TOT_AFLTD_AMBLNC_SRVC_CNT

NUMBER

TOT_AFLTD_ASC_CNT

NUMBER

TOT_COLCTD_HOSP_CNT

NUMBER

TOT_AFLTD_ESRD_CNT

NUMBER

TOT_AFLTD_FQHC_CNT

NUMBER

TOT_AFLTD_HHA_CNT

NUMBER

TOT_AFLTD_HOSPC_CNT

NUMBER

TOT_AFLTD_OPO_CNT

NUMBER

TOT_AFLTD_PRTF_CNT

NUMBER

TOT_AFLTD_RHC_CNT

NUMBER

TOT_AFLTD_SNF_CNT

NUMBER

AFLTD_PRVDR_CNT

NUMBER

RSDNT_PGM_ALPTHC_SW

BOOLEAN

RSDNT_PGM_DNTL_SW

BOOLEAN

RSDNT_PGM_OSTPTHC_SW

BOOLEAN

RSDNT_PGM_OTHR_SW

BOOLEAN

RSDNT_PGM_PDTRC_SW

BOOLEAN

LAB_SRVC_CD

TEXT

PHRMCY_SRVC_CD

NUMBER

RDLGY_SRVC_CD

TEXT

ASC_BGN_SRVC_DT

TEXT

FREESTNDNG_ASC_SW

TEXT

OVRRD_BED_CNT_SW

BOOLEAN

CRTFD_BED_CNT

NUMBER

ICFIID_BED_CNT

TEXT

MDCD_NF_BED_CNT

TEXT

MDCR_SNF_BED_CNT

TEXT

MDCR_MDCD_SNF_BED_CNT

TEXT

AIDS_BED_CNT

TEXT

ALZHMR_BED_CNT

TEXT

DLYS_BED_CNT

TEXT

DSBL_CHLDRN_BED_CNT

TEXT

HEAD_TRMA_BED_CNT

TEXT

HOSPC_BED_CNT

TEXT

HNTGTN_DEASE_BED_CNT

TEXT

REHAB_BED_CNT

TEXT

VNTLTR_BED_CNT

TEXT

BED_CNT

NUMBER

BRNCH_CNT

TEXT

BRNCH_OPRTN_SW

BOOLEAN

CAH_PSYCH_DPU_SW

BOOLEAN

CAH_REHAB_DPU_SW

BOOLEAN

CAH_SB_SW

BOOLEAN

CRDC_CTHRTZTN_PRCDR_ROOMS_CNT

NUMBER

GNRL_FAC_TYPE_CD

NUMBER

CHOW_SW

BOOLEAN

CLIA_ID_NUMBER_1

TEXT

CLIA_ID_NUMBER_2

TEXT

CLIA_ID_NUMBER_3

TEXT

CLIA_ID_NUMBER_4

TEXT

CLIA_ID_NUMBER_5

TEXT

COLCTN_STUS_SW

BOOLEAN

RN_24_HR_WVR_SW

BOOLEAN

RN_7_DAY_WVR_SW

BOOLEAN

BED_PER_ROOM_WVR_SW

BOOLEAN

LSC_WVR_SW

BOOLEAN

ROOM_SIZE_WVR_SW

BOOLEAN

ENDSCPY_PRCDR_ROOMS_CNT

NUMBER

ESRD_NTWRK_NUM

TEXT

EXPRMT_RSRCH_CNDCTD_SW

BOOLEAN

FAX_PHNE_NUM

NUMBER

FY_END_MO_DAY_CD

NUMBER

FQHC_APPROVED_RHC_PROVIDER_NUM

NUMBER

FED_FUNDD_FQHC_SW

BOOLEAN

HHA_QLFYD_OPT_SPCH_SW

BOOLEAN

HH_AIDE_TRNG_PGM_CD

TEXT

HOME_TRNG_SPRT_ONLY_SRVC_SW

BOOLEAN

MDCR_HOSPC_SW

BOOLEAN

HOSP_BSD_SW

BOOLEAN

INCNTR_NCTRNL_SRVC_SW

BOOLEAN

LTC_CROSS_REF_PROVIDER_NUMBER

TEXT

MDCL_SCHL_AFLTN_CD

NUMBER

MEDICARE_HOSPICE_PROVIDER_NUM

TEXT

MDCD_MDCR_PRTCPTG_PRVDR_SW

BOOLEAN

MEDICARE_MEDICAID_PRVDR_NUMBER

TEXT

MLT_FAC_ORG_NAME

TEXT

MLT_OWND_FAC_ORG_SW

BOOLEAN

NCRY_PRVDR_DSGNTD_DT

TEXT

NCRY_PRVDR_DSGNTD_AS_SW

BOOLEAN

NCRY_PRVDR_LOST_DT

TEXT

MEET_1861_SW

BOOLEAN

NPP_TYPE_CD

TEXT

TOT_OFSITE_CNCR_HOSP_CNT

NUMBER

TOT_OFSITE_CHLDRN_HOSP_CNT

NUMBER

TOT_OFSITE_EMER_DEPT_CNT

NUMBER

TOT_OFSITE_INPTNT_LCTN_CNT

NUMBER

TOT_OFSITE_LTC_HOSP_CNT

NUMBER

TOT_OFSITE_OPTHLMC_SRGRY_CNT

NUMBER

TOT_OFSITE_OTHR_LCTN_CNT

NUMBER

TOT_OFSITE_PSYCH_HOSP_CNT

NUMBER

TOT_OFSITE_PSYCH_UNIT_CNT

NUMBER

TOT_OFSITE_REHAB_HOSP_CNT

NUMBER

TOT_OFSITE_REHAB_UNIT_CNT

NUMBER

TOT_OFSITE_URGNT_CARE_CNTR_CNT

NUMBER

OFSITE_LCTN_CNT

NUMBER

OPRTG_ROOM_CNT

TEXT

ORGNZ_FMLY_MBR_GRP_SW

BOOLEAN

ORGNZ_RSDNT_GRP_SW

BOOLEAN

PARENT_PROVIDER_NUMBER

NUMBER

FQHC_APRVD_RHC_SW

BOOLEAN

MDCR_PRTCPTN_OP_PT_SPCH_SW

BOOLEAN

PGM_PRTCPTN_CD

TEXT

PRVDR_BSD_FAC_SW

BOOLEAN

PRVNC_CD

TEXT

PSYCH_UNIT_BED_CNT

NUMBER

PSYCH_UNIT_EFCTV_DT

NUMBER

PSYCH_UNIT_SW

BOOLEAN

PSYCH_UNIT_TRMNTN_CD

NUMBER

PSYCH_UNIT_TRMNTN_DT

NUMBER

REHAB_UNIT_BED_CNT

NUMBER

REHAB_UNIT_EFCTV_DT

NUMBER

REHAB_UNIT_SW

BOOLEAN

REHAB_UNIT_TRMNTN_CD

NUMBER

REHAB_UNIT_TRMNTN_DT

NUMBER

RELATED_PROVIDER_NUMBER

NUMBER

ACUTE_RNL_DLYS_SRVC_CD

NUMBER

PSYCH_SRVC_CD

NUMBER

HH_AIDE_SRVC_CD

TEXT

ALCHL_DRUG_SRVC_CD

NUMBER

ANSTHSA_SRVC_CD

NUMBER

APLNC_EQUIP_SRVC_CD

TEXT

AUDLGY_SRVC_CD

NUMBER

BLOOD_SRVC_OFSITE_RSDNT_SW

BOOLEAN

BLOOD_SRVC_ONST_NRSDNT_SW

BOOLEAN

BLOOD_SRVC_ONST_RSDNT_SW

BOOLEAN

BURN_CARE_UNIT_SRVC_CD

NUMBER

CRDC_CTHRTZTN_LAB_SRVC_CD

NUMBER

OPEN_HRT_SRGRY_SRVC_CD

NUMBER

CARF_IP_REHAB_SRVC_CD

NUMBER

CHMTHRPY_SRVC_CD

NUMBER

CHRPRCTIC_SRVC_CD

NUMBER

CL_SRVC_OFSITE_RSDNT_SW

BOOLEAN

CL_SRVC_ONST_NRSDNT_SW

BOOLEAN

CL_SRVC_ONST_RSDNT_SW

BOOLEAN

CL_SRVC_CD

NUMBER

CRNRY_CARE_UNIT_SRVC_CD

NUMBER

CNSLNG_SRVC_CD

TEXT

CT_SCAN_SRVC_CD

NUMBER

DNTL_SRVC_CD

NUMBER

DNTL_SRVC_OFSITE_RSDNT_SW

BOOLEAN

DNTL_SRVC_ONST_NRSDNT_SW

BOOLEAN

DNTL_SRVC_ONST_RSDNT_SW

BOOLEAN

SHCK_TRMA_SRVC_CD

NUMBER

DGNSTC_RDLGY_SRVC_CD

NUMBER

DTRY_SRVC_CD

NUMBER

DTRY_OFSITE_RSDNT_SW

BOOLEAN

DTRY_ONST_NRSDNT_SW

BOOLEAN

DTRY_ONST_RSDNT_SW

BOOLEAN

DCTD_ER_SRVC_CD

NUMBER

EMER_PSYCH_SRVC_CD

NUMBER

XTRCRPRL_SHCK_LTHTRPTR_SRVC_CD

NUMBER

FRNSC_PSYCH_SRVC_CD

NUMBER

GRTRC_PSYCH_SRVC_CD

NUMBER

GRNTLGCL_SPCLTY_SRVC_CD

NUMBER

SP_HOME_TRNG_SPRT_HD_SW

BOOLEAN

HMDLYS_SRVC_SW

BOOLEAN

HMMKR_SRVC_CD

TEXT

HSEKPNG_SRVC_OFSITE_RSDNT_SW

BOOLEAN

HSEKPNG_SRVC_ONST_NRSDNT_SW

BOOLEAN

HSEKPNG_SRVC_ONST_RSDNT_SW

BOOLEAN

IP_SRGCL_SRVC_CD

NUMBER

INTRN_RSDNT_SRVC_CD

TEXT

MDCL_SCL_SRVC_CD

TEXT

MDCL_SUPLY_SRVC_CD

TEXT

ICU_SRVC_CD

NUMBER

MDCR_TRNSPLNT_CNTR_SRVC_CD

NUMBER

MENTL_HLTH_OFSITE_RSDNT_SW

BOOLEAN

MENTL_HLTH_ONST_NRSDNT_SW

BOOLEAN

MENTL_HLTH_ONST_RSDNT_SW

BOOLEAN

MGNTC_RSNC_IMG_SRVC_CD

NUMBER

NEONTL_ICU_SRVC_CD

NUMBER

NEONTL_NRSRY_SRVC_CD

NUMBER

NRSRGCL_SRVC_CD

NUMBER

ORGN_TRNSPLNT_SRVC_CD

NUMBER

NUCLR_MDCN_SRVC_CD

NUMBER

NRSNG_SRVC_EMPLEE_SW

BOOLEAN

NRSNG_SRVC_CNTRCTR_SW

BOOLEAN

NRSNG_SRVC_ARNGMT_SW

BOOLEAN

NRSNG_SRVC_CD

TEXT

NRSNG_SRVC_OFSITE_RSDNT_SW

BOOLEAN

NRSNG_SRVC_ONST_NRSDNT_SW

BOOLEAN

NRSNG_SRVC_ONST_RSDNT_SW

BOOLEAN

NTRTNL_GDNC_SRVC_CD

TEXT

OB_SRVC_CD

NUMBER

OPTHLMC_SRGY_SRVC_CD

NUMBER

OPTMTRC_SRVC_CD

NUMBER

OPRTG_ROOM_SRVC_CD

NUMBER

ORTHPDC_SRGY_SRVC_CD

NUMBER

ORTHTC_PRSTHTC_EMPLEE_SW

BOOLEAN

ORTHTC_PRSTHTC_CNTRCTR_SW

BOOLEAN

ORTHTC_PRSTHTC_ARNGMT_SW

BOOLEAN

OT_EMPLEE_SW

BOOLEAN

OT_CNTRCTR_SW

BOOLEAN

OT_ARNGMT_SW

BOOLEAN

OT_SRVC_CD

NUMBER

OT_SRVC_OFSITE_RSDNT_SW

BOOLEAN

OT_SRVC_ONST_NRSDNT_SW

BOOLEAN

OT_SRVC_ONST_RSDNT_SW

BOOLEAN

OTHR_SRVC_CD

TEXT

OP_SRVC_CD

NUMBER

OP_PSYCH_SRVC_CD

NUMBER

OP_REHAB_SRVC_CD

NUMBER

OP_SRGRY_UNIT_SRVC_CD

NUMBER

PED_SRVC_CD

NUMBER

PED_ICU_SRVC_CD

NUMBER

SP_HOME_TRNG_SPRT_PD_SW

BOOLEAN

PRTNL_DLYS_SRVC_SW

BOOLEAN

PET_SCAN_SRVC_CD

NUMBER

PHRMCY_SRVC_OFSITE_RSDNT_SW

BOOLEAN

PHRMCY_SRVC_ONST_NRSDNT_SW

BOOLEAN

PHRMCY_SRVC_ONST_RSDNT_SW

BOOLEAN

PHYSN_EMPLEE_SW

BOOLEAN

PHYSN_CNTRCTR_SW

BOOLEAN

PHYSN_ARNGMT_SW

BOOLEAN

PHYSN_SRVC_CD

TEXT

PHYSN_EXT_SRVC_OFSITE_RSDNT_SW

BOOLEAN

PHYSN_EXT_SRVC_ONST_NRSDNT_SW

BOOLEAN

PHYSN_EXT_SRVC_ONST_RSDNT_SW

BOOLEAN

PHYSN_SRVC_OFSITE_RSDNT_SW

BOOLEAN

PHYSN_SRVC_ONST_NRSDNT_SW

BOOLEAN

PHYSN_SRVC_ONST_RSDNT_SW

BOOLEAN

PDTRY_SRVC_OFSITE_RSDNT_SW

BOOLEAN

PDTRY_SRVC_ONST_NRSDNT_SW

BOOLEAN

PDTRY_SRVC_ONST_RSDNT_SW

BOOLEAN

PSTOPRTV_RCVRY_SRVC_CD

NUMBER

CHLD_ADLSCNT_PSYCH_SRVC_CD

NUMBER

PSYCHLGCL_EMPLEE_SW

BOOLEAN

PSYCHLGCL_CNTRCTR_SW

BOOLEAN

PSYCHLGCL_ARNGMT_SW

BOOLEAN

PT_EMPLEE_SW

BOOLEAN

PT_CNTRCTR_SW

BOOLEAN

PT_ARNGMT_SW

BOOLEAN

PT_SRVC_CD

NUMBER

PT_OFSITE_RSDNT_SW

BOOLEAN

PT_ONST_NRSDNT_SW

BOOLEAN

PT_ONST_RSDNT_SW

BOOLEAN

RCNSTRCTN_SRGY_SRVC_CD

NUMBER

RSPRTRY_CARE_EMPLEE_SW

BOOLEAN

RSPRTRY_CARE_CNTRCTR_SW

BOOLEAN

RSPRTRY_CARE_ARNGMT_SW

BOOLEAN

RSPRTRY_CARE_SRVC_CD

NUMBER

SHRT_TERM_IP_SRVC_CD

TEXT

SCL_EMPLEE_SW

BOOLEAN

SCL_CNTRCTR_SW

BOOLEAN

SCL_ARNGMT_SW

BOOLEAN

SCL_SRVC_CD

NUMBER

SCL_WORK_SRVC_OFSITE_RSDNT_SW

BOOLEAN

SCL_WORK_SRVC_ONST_NRSDNT_SW

BOOLEAN

SCL_WORK_SRVC_ONST_RSDNT_SW

BOOLEAN

SPCH_PTHLGY_EMPLEE_SW

BOOLEAN

SPCH_PTHLGY_CNTRCTR_SW

BOOLEAN

SPCH_PTHLGY_ARNGMT_SW

BOOLEAN

SPCH_PTHLGY_SRVC_CD

NUMBER

SPCH_PTHLGY_OFSITE_RSDNT_SW

BOOLEAN

SPCH_PTHLGY_ONST_NRSDNT_SW

BOOLEAN

SPCH_PTHLGY_ONST_RSDNT_SW

BOOLEAN

SPCH_THRPY_SRVC_CD

TEXT

SRGCL_ICU_SRVC_CD

NUMBER

ACTVTY_OTHR_OFSITE_RSDNT_SW

BOOLEAN

ACTVTY_OTHR_ONST_NRSDNT_SW

BOOLEAN

ACTVTY_OTHR_ONST_RSDNT_SW

BOOLEAN

SCL_SRVC_OTHR_OFSITE_RSDNT_SW

BOOLEAN

SCL_SRVC_OTHR_ONST_NRSDNT_SW

BOOLEAN

SCL_SRVC_OTHR_ONST_RSDNT_SW

BOOLEAN

ACTVTY_OFSITE_RSDNT_SW

BOOLEAN

ACTVTY_ONST_NRSDNT_SW

BOOLEAN

ACTVTY_ONST_RSDNT_SW

BOOLEAN

THRPTC_RDLGY_SRVC_CD

NUMBER

THRPTC_RCRTNL_OFSITE_RSDNT_SW

BOOLEAN

THRPTC_RCRTNL_ONST_NRSDNT_SW

BOOLEAN

THRPTC_RCRTNL_ONST_RSDNT_SW

BOOLEAN

URGNT_CARE_SRVC_CD

NUMBER

VCTNL_GDNC_SRVC_CD

TEXT

VCTNL_SRVC_OFSITE_RSDNT_SW

BOOLEAN

VCTNL_SRVC_ONST_NRSDNT_SW

BOOLEAN

VCTNL_SRVC_ONST_RSDNT_SW

BOOLEAN

DGNSTC_XRAY_OFSITE_RSDNT_SW

BOOLEAN

DGNSTC_XRAY_ONST_NRSDNT_SW

BOOLEAN

DGNSTC_XRAY_ONST_RSDNT_SW

BOOLEAN

ACUTE_RESP_CARE_CD

TEXT

OVRRD_STFG_SW

BOOLEAN

PROFNL_ADMIN_CNTRCT_CNT

TEXT

PROFNL_ADMIN_FLTM_CNT

TEXT

PROFNL_ADMIN_PRTM_CNT

TEXT

HH_AIDE_EMPLEE_CNT

TEXT

HH_AIDE_VLNTR_CNT

TEXT

PRSNEL_OTHR_CNT

NUMBER

NRS_AIDE_CNTRCT_CNT

TEXT

NRS_AIDE_FLTM_CNT

TEXT

NRS_AIDE_PRTM_CNT

TEXT

CNSLR_EMPLEE_CNT

TEXT

CNSLR_VLNTR_CNT

TEXT

CRNA_CNT

NUMBER

DNTST_CNTRCT_CNT

TEXT

DNTST_FLTM_CNT

TEXT

DNTST_PRTM_CNT

TEXT

DIETN_CNT

NUMBER

DIETN_CNTRCT_CNT

TEXT

DIETN_FLTM_CNT

TEXT

DIETN_PRTM_CNT

TEXT

DRCT_CARE_PRSNEL_CNT

TEXT

FOOD_SRVC_CNTRCT_CNT

TEXT

FOOD_SRVC_FLTM_CNT

TEXT

FOOD_SRVC_PRTM_CNT

TEXT

HH_AIDE_CNT

TEXT

HMMKR_EMPLEE_CNT

TEXT

HMMKR_VLNTR_CNT

TEXT

HSEKPNG_CNTRCT_CNT

TEXT

HSEKPNG_FLTM_CNT

TEXT

HSEKPNG_PRTM_CNT

TEXT

LAB_TCHNCN_CNT

NUMBER

LPN_CNT

TEXT

LPN_LVN_CNT

NUMBER

LPN_LVN_CNTRCT_CNT

TEXT

LPN_LVN_FLTM_CNT

TEXT

LPN_LVN_PRTM_CNT

TEXT

LPN_LVN_VLNTR_CNT

TEXT

MDCL_DRCTR_CNTRCT_CNT

TEXT

MDCL_DRCTR_FLTM_CNT

TEXT

MDCL_DRCTR_PRTM_CNT

TEXT

MDCL_SCL_WORKR_CNT

NUMBER

MDCL_SCL_WORKR_VLNTR_CNT

TEXT

MDCL_TCHNLGST_CNT

NUMBER

MDCTN_AIDE_CNTRCT_CNT

TEXT

MDCTN_AIDE_FLTM_CNT

TEXT

MDCTN_AIDE_PRTM_CNT

TEXT

MENTL_HLTH_SRVC_CNTRCT_CNT

TEXT

MENTL_HLTH_SRVC_FLTM_CNT

TEXT

MENTL_HLTH_SRVC_PRTM_CNT

TEXT

NUCLR_MDCN_TCHNCN_CNT

NUMBER

NAT_CNTRCT_CNT

TEXT

NAT_FLTM_CNT

TEXT

NAT_PRTM_CNT

TEXT

NRS_PRCTNR_CNT

NUMBER

NRS_ADMINV_CNTRCT_CNT

TEXT

NRS_ADMINV_FLTM_CNT

TEXT

NRS_ADMINV_PRTM_CNT

TEXT

OCPTNL_THRPST_CNT

NUMBER

OCPTNL_THRPST_CNTRCT_CNT

TEXT

OCPTNL_THRPST_FLTM_CNT

TEXT

OCPTNL_THRPST_PRTM_CNT

TEXT

OT_AIDE_CNTRCT_CNT

TEXT

OT_AIDE_FLTM_CNT

TEXT

OT_AIDE_PRTM_CNT

TEXT

OT_ASTNT_CNTRCT_CNT

TEXT

OT_ASTNT_FLTM_CNT

TEXT

OT_ASTNT_PRTM_CNT

TEXT

VLNTR_OTHR_CNT

TEXT

ACTVTY_STF_OTHR_CNTRCT_CNT

TEXT

ACTVTY_STF_OTHR_FLTM_CNT

TEXT

ACTVTY_STF_OTHR_PRTM_CNT

TEXT

PHYSN_OTHR_CNTRCT_CNT

TEXT

PHYSN_OTHR_FLTM_CNT

TEXT

PHYSN_OTHR_PRTM_CNT

TEXT

SCL_SRVC_OTHR_STF_CNTRCT_CNT

TEXT

SCL_SRVC_OTHR_STF_FLTM_CNT

TEXT

SCL_SRVC_OTHR_STF_PRTM_CNT

TEXT

STF_OTHR_CNTRCT_CNT

TEXT

STF_OTHR_FLTM_CNT

TEXT

STF_OTHR_PRTM_CNT

TEXT

PHRMCST_CNTRCT_CNT

TEXT

PHRMCST_FLTM_CNT

TEXT

PHRMCST_PRTM_CNT

TEXT

PHYS_THRPST_CNTRCT_CNT

TEXT

PHYS_THRPST_FLTM_CNT

TEXT

PHYS_THRPST_PRTM_CNT

TEXT

PHYSN_CNT

NUMBER

PHYSN_VLNTR_CNT

TEXT

PHYSN_ASTNT_CNT

NUMBER

PHYSN_EXT_CNTRCT_CNT

TEXT

PHYSN_EXT_FLTM_CNT

TEXT

PHYSN_EXT_PRTM_CNT

TEXT

RSDNT_PHYSN_CNT

NUMBER

PDTRST_CNTRCT_CNT

TEXT

PDTRST_FLTM_CNT

TEXT

PDTRST_PRTM_CNT

TEXT

PSYCHLGST_CNT

NUMBER

PHYS_THRPST_STF_CNT

TEXT

PHYS_THRPST_CNT

NUMBER

PHYS_THRPST_ARNGMT_CNT

TEXT

PT_AIDE_CNTRCT_CNT

TEXT

PT_AIDE_FLTM_CNT

TEXT

PT_AIDE_PRTM_CNT

TEXT

PT_ASTNT_CNTRCT_CNT

TEXT

PT_ASTNT_FLTM_CNT

TEXT

PT_ASTNT_PRTM_CNT

TEXT

ACTVTY_PROFNL_CNTRCT_CNT

TEXT

ACTVTY_PROFNL_FLTM_CNT

TEXT

ACTVTY_PROFNL_PRTM_CNT

TEXT

RDLGY_TCHNCN_CNT

NUMBER

REG_PHRMCST_CNT

NUMBER

INHLTN_THRPST_CNT

NUMBER

RN_CNT

NUMBER

RN_CNTRCT_CNT

TEXT

RN_FLTM_CNT

TEXT

RN_PRTM_CNT

TEXT

RN_VLNTR_CNT

TEXT

RN_DRCTR_CNTRCT_CNT

TEXT

RN_DRCTR_FLTM_CNT

TEXT

RN_DRCTR_PRTM_CNT

TEXT

SCL_WORKR_CNT

TEXT

SCL_WORKR_CNTRCT_CNT

TEXT

SCL_WORKR_FLTM_CNT

TEXT

SCL_WORKR_PRTM_CNT

TEXT

SPCH_PTHLGST_ARNGMT_CNT

TEXT

SPCH_PTHLGST_CNTRCT_CNT

TEXT

SPCH_PTHLGST_FLTM_CNT

TEXT

SPCH_PTHLGST_PRTM_CNT

TEXT

SPCH_PTHLGST_CNT

TEXT

SPCH_PTHLGST_AUDLGST_CNT

NUMBER

TCHNCL_STF_NUM

TEXT

TCHNCN_CNT

TEXT

THRPTC_RCRTNL_CNTRCT_CNT

TEXT

THRPTC_RCRTNL_FLTM_CNT

TEXT

THRPTC_RCRTNL_PRTM_CNT

TEXT

EMPLEE_CNT

TEXT

VLNTR_CNT

TEXT

SBUNIT_CNT

TEXT

SBUNIT_SW

BOOLEAN

SBUNIT_OPRTN_SW

BOOLEAN

DNTL_SRGRY_SW

TEXT

OTLRYNGLGY_SRGRY_SW

BOOLEAN

ENDSCPY_SRGRY_SW

TEXT

OB_GYN_SRGRY_SW

BOOLEAN

OPTHMLGY_SRGRY_SW

BOOLEAN

ORTHPDC_SRGRY_SW

BOOLEAN

OTHR_SRGRY_SW

TEXT

PAIN_SRGRY_SW

TEXT

PLSTC_SRGRY_SW

BOOLEAN

FT_SRGRY_SW

BOOLEAN

SB_SW

BOOLEAN

SB_SIZE_CD

NUMBER

TCHNLGST_2_YR_RDLGC_CNT

TEXT

TCHNLGST_ASCT_DGR_CNT

TEXT

TCHNLGST_BS_BA_DGR_CNT

TEXT

DLYS_STN_CNT

TEXT

REC_STUS_CD

TEXT

SRVY_PRPSE_CD

NUMBER

PHRMCY_SRVC_DESC

TEXT

ADMSN_SUSPNSN_DT

TEXT

ADMSN_SUSPNSN_PRIOR_DT

TEXT

HHA_TRNG_PGM_CD

TEXT

MR_BED_CNT

TEXT

MDCD_SNF_BED_CNT

TEXT

SCOPE_OF_SRVC_WVR_SW

BOOLEAN

TCHNCL_PRSNEL_WVR_SW

BOOLEAN

SRVY_EVER_ACRDTD_SW

BOOLEAN

SRVY_EVER_NACRDTD_SW

BOOLEAN

SRVY_EVER_SB_SW

BOOLEAN

DRCTR_QUALN_CD

TEXT

DRCTR_QUALN_DESC

TEXT

VLDTN_SRVY_DT

NUMBER

FED_PGM_SPRT_SW

BOOLEAN

OVRRD_NRS_BED_SW

BOOLEAN

AGRMT_BGN_DT

TEXT

AGRMT_END_DT

TEXT

AGRMT_EXTNSN_DT

TEXT

ACUTE_RNL_DLYS_SRVC_DESC

TEXT

PSYCH_SRVC_DESC

TEXT

ALCHL_DRUG_SRVC_DESC

TEXT

ANSTHSA_SRVC_DESC

TEXT

AUDLGY_SRVC_DESC

TEXT

BURN_CARE_UNIT_SRVC_DESC

TEXT

…and 95 more columns. Run DESCRIBE VIEW DWV.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM once the share is mounted for the complete column list.

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:

Source & provenance

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

Frequently asked questions

How often is Provider of Services File - Quality Improvement and Evaluation System updated?

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

What years does Provider of Services File - Quality Improvement and Evaluation System cover?

2011 through 2026.

How many records are in Provider of Services File - Quality Improvement and Evaluation System?

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

How do I get Provider of Services File - Quality Improvement and Evaluation System 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.PROVIDER_OF_SERVICES_FILE__QUALITY_IMPROVEMENT_AND_EVALUATION_SYSTEM directly — no pipeline setup required.

Provider of Services File - Hospital & Non-Hospital FacilitiesAmbulatory Surgical Centers and Independent Free Standing Emergency Departments Enrolled in Medicare As Hospital ProvidersHome Infusion Therapy ProvidersHospital Change of Ownership - Owner InformationProvider of Services File - Clinical Laboratories

Get this feed

  1. Mount the share — the database and DWV schema appear in your account immediately

  2. 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 →

Last updated