Provider of Services File - Hospital & Non-Hospital Facilities

Please be advised that as of Q4 2023 there is a new Provider of Service file (POS) that contains the provider and certification details for Home Health…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.PROVIDER_OF_SERVICES_FILE__HOSPITAL__NONHOSPITAL_FACILITIES on Snowflake and Databricks — coverage from 2010 to 2025 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__HOSPITAL__NONHOSPITAL_FACILITIES
Databricks	cms_dwv.provider_of_services_file__hospital__nonhospital_facilities
Coverage	Oct 2010 – Jun 2025
Rows	3,525,048 (total across all reporting periods)
Cadence	Quarterly
Update pattern	Time-partitioned — each file adds one reporting period
CMS published	2025-08-07
Loaded	2025-10-18
Columns	1,125 data + 6 lineage
Identifiers	FIPS codes · ZIP codes
File versions	36
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-08-07 — awaiting the next release. New files load automatically when CMS publishes.

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 2025 reporting period.

Sample queries

Snowflake

-- Each file version covers one reporting period — history is additive
SELECT *
FROM DWV.PROVIDER_OF_SERVICES_FILE__HOSPITAL__NONHOSPITAL_FACILITIES
LIMIT 100;

Databricks

About this feed

Please be advised that as of Q4 2023 there is a new Provider of Service file (POS) that contains the provider and certification details for Home Health Agencies (HHAs), Hospices, and Ambulatory Surgical Centers (ASCs). Data contained in this file are extracted from the Internet Quality Improvement and Evaluation System (iQIES) environment and will be updated quarterly along with the other two POS files.

The Provider of Services File - Hospital & Non-Hospital Facilities data provide critical resources for other federal regulator requirements as well as supports the ongoing quality & research efforts sponsored by CMS. In this file you will find provider certification, termination, accreditation, ownership, name, location and other characteristics organized by CMS Certification Number.

— Source: CMS feed metadata

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

Coverage timeline

2010–2025 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

16 of 16 years covered — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
2025-04-01 – 2025-06-30	2025-08-07	2025-10-18	✓
2025-04-01 – 2025-06-30	2025-07-16	2025-07-16
2025-01-01 – 2025-03-31	2025-04-15	2025-04-15
2024-10-01 – 2024-12-31	2025-01-16	2025-01-16
2024-07-01 – 2024-09-30	2024-10-15	2024-10-15
2024-04-01 – 2024-06-30	2024-07-18	2024-07-18
2024-01-01 – 2024-03-31	2024-04-10	2024-04-13
2023-10-01 – 2023-12-31	2024-01-17	2024-01-17
2023-07-01 – 2023-09-30	2023-10-17	2023-10-17
2023-04-01 – 2023-06-30	2023-07-26	2023-08-29

Show 26 earlier file versions

Reporting period	CMS published	Loaded	Latest file
2023-01-01 – 2023-03-31	2023-05-11	2023-08-29
2022-10-01 – 2022-12-31	2023-03-07	2023-08-29
2022-07-01 – 2022-09-30	2022-10-25	2023-08-29
2022-04-01 – 2022-06-30	2022-09-19	2023-08-29
2022-01-01 – 2022-03-31	2022-04-14	2023-08-29
2021-10-01 – 2021-12-31	2022-01-10	2023-08-29
2021-07-01 – 2021-09-30	2021-10-29	2023-08-29
2021-04-01 – 2021-06-30	2021-07-23	2023-08-29
2021-01-01 – 2021-03-31	2021-07-20	2023-08-29
2020-10-01 – 2020-12-31	2021-05-20	2023-08-29
2020-07-01 – 2020-09-30	2021-05-20	2023-08-29
2020-04-01 – 2020-06-30	2020-12-21	2023-08-29
2020-01-01 – 2020-03-31	2020-12-21	2023-08-29
2019-10-01 – 2019-12-31	2021-01-11	2023-08-29
2019-07-01 – 2019-09-30	2022-01-04	2023-08-29
2019-04-01 – 2019-06-30	2021-01-11	2023-08-29
2019-01-01 – 2019-03-31	2021-01-11	2023-08-29
2018-10-01 – 2018-12-31	2021-01-11	2023-08-29
2017-10-01 – 2017-12-31	2021-01-11	2023-08-29
2016-10-01 – 2016-12-31	2021-05-20	2023-08-29
2015-10-01 – 2015-12-31	2021-05-20	2023-08-29
2014-10-01 – 2014-12-31	2021-05-20	2023-08-29
2013-10-01 – 2013-12-31	2021-05-20	2023-08-29
2012-10-01 – 2012-12-31	2021-05-20	2023-08-29
2011-10-01 – 2011-12-31	2021-05-20	2023-08-29
2010-10-01 – 2010-12-31	2021-05-20	2023-08-29

Data dictionary

📋 1,125 data columns + 6 lineage columns

Column-level definitions are maintained by CMS in the official Provider of Services File - Hospital & Non-Hospital Facilities 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	NUMBER
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	NUMBER
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	NUMBER
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	NUMBER
TCHNCN_CNT	NUMBER
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	NUMBER
PROV0085	NUMBER
PROV0075	NUMBER
PROV0095	NUMBER
PROV0100	TEXT
PROV3225	TEXT
PROV0220	NUMBER
PROV2715	TEXT
PROV2695	NUMBER
PROV0300	TEXT
PROV0500	NUMBER
PROV2740	NUMBER
PROV0455	NUMBER
PROV0475	TEXT
PROV0605	NUMBER
PROV0655	TEXT
PROV1565	NUMBER
PROV1615	NUMBER
PROV1620	NUMBER
PROV1680	TEXT
REC_STUS_CD	TEXT
PROV1720	TEXT
PROV1725	NUMBER
PROV2045	BOOLEAN
PROV3230	TEXT
PROV2700	NUMBER
PROV2710	NUMBER
PROV2720	TEXT

…and 625 more columns. Run DESCRIBE VIEW DWV.PROVIDER_OF_SERVICES_FILE__HOSPITAL__NONHOSPITAL_FACILITIES 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:

SELECT d.PRVDR_CTGRY_SBTYP_CD, d.PRVDR_CTGRY_CD, d.CHOW_CNT,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.PROVIDER_OF_SERVICES_FILE__HOSPITAL__NONHOSPITAL_FACILITIES 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 documentation

• Provider of Services File Methodology

Frequently asked questions

How often is Provider of Services File - Hospital & Non-Hospital Facilities updated?

Quarterly. CMS last published this feed on 2025-08-07, and Dataplex loaded it to the warehouse on 2025-10-18. New releases are added automatically when CMS publishes them.

What years does Provider of Services File - Hospital & Non-Hospital Facilities cover?

2010 through 2025.

How many records are in Provider of Services File - Hospital & Non-Hospital Facilities?

3,525,048 rows across all 36 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 - Hospital & Non-Hospital Facilities 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__HOSPITAL__NONHOSPITAL_FACILITIES directly — no pipeline setup required.

Related feeds

Provider of Services File - Quality Improvement and Evaluation SystemHome Infusion Therapy ProvidersAmbulatory Surgical Centers and Independent Free Standing Emergency Departments Enrolled in Medicare As Hospital ProvidersSkilled Nursing Facility Change of Ownership - Owner InformationSkilled Nursing Facility Enrollments

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 →