Baselight
Sign In

Provider Of Services File - Hospital & Non-Hospital Facilities

U.S. Department of Health & Human Services

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df

Loading...
Loading...

About this Dataset

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 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-08-11T19:06:21.848985
Tags: hospitals-facilities, inpatient, medicare, medicare-advantage, original-medicare, outpatient-facilities, provider-enrollment

Tables

Provider Of Services File - Hospital & Non-Hospital Facilities : 2021-03-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__16678c75
  • 15.3 MB
  • 152746 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__16678c75 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2015-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__1e724da4
  • 15.74 MB
  • 138803 rows
  • 470 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__1e724da4 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2014-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__1f53bd52
  • 15.36 MB
  • 136502 rows
  • 470 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__1f53bd52 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2017-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__26007f27
  • 16.27 MB
  • 144110 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__26007f27 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" VARCHAR,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2012-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__26f83f07
  • 17.4 MB
  • 141342 rows
  • 499 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__26f83f07 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" DOUBLE,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rec_stus_cd" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "srvy_prpse_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "actvty_profnl_cntrct_cnt" DOUBLE,
  "actvty_profnl_fltm_cnt" DOUBLE,
  "actvty_profnl_prtm_cnt" DOUBLE,
  "actvty_stf_othr_cntrct_cnt" DOUBLE,
  "actvty_stf_othr_fltm_cnt" DOUBLE,
  "actvty_stf_othr_prtm_cnt" DOUBLE,
  "acute_resp_care_cd" VARCHAR,
  "profnl_admin_cntrct_cnt" DOUBLE,
  "profnl_admin_fltm_cnt" DOUBLE,
  "profnl_admin_prtm_cnt" DOUBLE,
  "admsn_suspnsn_dt" DOUBLE,
  "admsn_suspnsn_prior_dt" DOUBLE,
  "hha_trng_pgm_cd" DOUBLE,
  "mr_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcd_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "crtfd_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "brnch_cnt" DOUBLE,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "nrs_aide_cntrct_cnt" DOUBLE,
  "nrs_aide_fltm_cnt" DOUBLE,
  "nrs_aide_prtm_cnt" DOUBLE,
  "crna_cnt" DOUBLE,
  "chow_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "scope_of_srvc_wvr_sw" VARCHAR,
  "tchncl_prsnel_wvr_sw" VARCHAR,
  "cnslr_emplee_cnt" DOUBLE,
  "cnslr_vlntr_cnt" DOUBLE,
  "srvy_ever_acrdtd_sw" VARCHAR,
  "srvy_ever_nacrdtd_sw" VARCHAR,
  "srvy_ever_sb_sw" VARCHAR,
  "asc_bgn_srvc_dt" DOUBLE,
  "vldtn_srvy_dt" DOUBLE,
  "dntst_cntrct_cnt" DOUBLE,
  "dntst_fltm_cnt" DOUBLE,
  "dntst_prtm_cnt" DOUBLE,
  "dietn_cnt" DOUBLE,
  "dietn_cntrct_cnt" DOUBLE,
  "dietn_fltm_cnt" DOUBLE,
  "dietn_prtm_cnt" DOUBLE,
  "drct_care_prsnel_cnt" DOUBLE,
  "drctr_qualn_cd" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fqhc_approved_rhc_provider_num" DOUBLE,
  "fax_phne_num" DOUBLE,
  "fed_pgm_sprt_sw" VARCHAR,
  "fed_fundd_fqhc_sw" VARCHAR,
  "fy_end_mo_day_cd" DOUBLE,
  "food_srvc_cntrct_cnt" DOUBLE,
  "food_srvc_fltm_cnt" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2019-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__2e3433d2
  • 15.12 MB
  • 149206 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__2e3433d2 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2022-03-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__347a6f32
  • 15.61 MB
  • 155859 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__347a6f32 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2020-12-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__38b962f4
  • 15.29 MB
  • 152080 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__38b962f4 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2016-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__44d72520
  • 15.97 MB
  • 141557 rows
  • 470 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__44d72520 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2023-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__4d7db3a0
  • 11.7 MB
  • 114047 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__4d7db3a0 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" DOUBLE,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" VARCHAR,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" VARCHAR,
  "asc_bgn_srvc_dt" VARCHAR,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" VARCHAR,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2021-09-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__5b903482
  • 15.48 MB
  • 154348 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__5b903482 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2022-06-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__6e9dd1b9
  • 15.61 MB
  • 156369 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__6e9dd1b9 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2024-03-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__79e633b0
  • 11.94 MB
  • 114525 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__79e633b0 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" DOUBLE,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" VARCHAR,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" VARCHAR,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" VARCHAR,
  "asc_bgn_srvc_dt" VARCHAR,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" VARCHAR,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" VARCHAR,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2023-06-01

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__7e04412d
  • 15.41 MB
  • 158778 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__7e04412d (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" DOUBLE,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" DOUBLE,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" DOUBLE,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" VARCHAR,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2021-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__82ee336a
  • 15.54 MB
  • 155262 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__82ee336a (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2022-09-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__983a5017
  • 15.61 MB
  • 156712 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__983a5017 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2020-03-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__a1cc0f29
  • 14.3 MB
  • 140200 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__a1cc0f29 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" DOUBLE,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2022-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__a4212014
  • 15.26 MB
  • 157649 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__a4212014 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" DOUBLE,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" DOUBLE,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" DOUBLE,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2024-04-01

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__b87f09c5
  • 11.75 MB
  • 114882 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__b87f09c5 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" DOUBLE,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" VARCHAR,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" VARCHAR,
  "asc_bgn_srvc_dt" VARCHAR,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" VARCHAR,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2020-06-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__c13de33c
  • 15.19 MB
  • 150686 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__c13de33c (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2013-12-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__c3eac61f
  • 15.75 MB
  • 133879 rows
  • 485 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__c3eac61f (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "gnrl_fac_type_cd" DOUBLE,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "phrmcy_srvc_desc" VARCHAR,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "scope_of_srvc_wvr_sw" VARCHAR,
  "tchncl_prsnel_wvr_sw" VARCHAR,
  "srvy_ever_sb_sw" VARCHAR,
  "drctr_qualn_cd" DOUBLE,
  "drctr_qualn_desc" VARCHAR,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE,
  "fed_fundd_fqhc_sw" VARCHAR,
  "hha_qlfyd_opt_spch_sw" VARCHAR,
  "hh_aide_trng_pgm_cd" DOUBLE,
  "mdcr_hospc_sw" VARCHAR,
  "hosp_bsd_sw" VARCHAR,
  "ltc_cross_ref_provider_number" VARCHAR,
  "mdcl_schl_afltn_cd" DOUBLE,
  "medicare_hospice_provider_num" DOUBLE,
  "mdcd_mdcr_prtcptg_prvdr_sw" VARCHAR,
  "medicare_medicaid_prvdr_number" VARCHAR,
  "mlt_fac_org_name" VARCHAR,
  "mlt_ownd_fac_org_sw" VARCHAR,
  "meet_1861_sw" VARCHAR,
  "npp_type_cd" VARCHAR
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2025-04-02

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__c48dbb9c
  • 11.86 MB
  • 116331 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__c48dbb9c (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" DOUBLE,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" VARCHAR,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" VARCHAR,
  "asc_bgn_srvc_dt" VARCHAR,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" VARCHAR,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2023-09-01

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__ca903ff7
  • 15.44 MB
  • 159295 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__ca903ff7 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" DOUBLE,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" DOUBLE,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" DOUBLE,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2023-03-31

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__e569d00a
  • 15.38 MB
  • 158185 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__e569d00a (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" DOUBLE,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" DOUBLE,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" DOUBLE,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Provider Of Services File - Hospital & Non-Hospital Facilities : 2021-06-30

@usgov.hhs_gov_provider_of_services_hospital_non_hospital_fac_438c01df.provider_of_services_hospital_non_hospital_facilities__e9651f86
  • 15.42 MB
  • 153592 rows
  • 473 columns
Loading... 

CREATE TABLE provider_of_services_hospital_non_hospital_facilities__e9651f86 (
  "prvdr_ctgry_sbtyp_cd" DOUBLE,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" DOUBLE,
  "elgblty_sw" VARCHAR,
  "fac_name" VARCHAR,
  "intrmdry_carr_cd" DOUBLE,
  "mdcd_vndr_num" VARCHAR,
  "orgnl_prtcptn_dt" BIGINT,
  "chow_prior_dt" DOUBLE,
  "intrmdry_carr_prior_cd" VARCHAR,
  "prvdr_num" VARCHAR,
  "rgn_cd" BIGINT,
  "skltn_rec_sw" VARCHAR,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" DOUBLE,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" DOUBLE,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" VARCHAR,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "acrdtn_efctv_dt" DOUBLE,
  "acrdtn_exprtn_dt" DOUBLE,
  "acrdtn_type_cd" DOUBLE,
  "tot_afltd_amblnc_srvc_cnt" DOUBLE,
  "tot_afltd_asc_cnt" DOUBLE,
  "tot_colctd_hosp_cnt" DOUBLE,
  "tot_afltd_esrd_cnt" DOUBLE,
  "tot_afltd_fqhc_cnt" DOUBLE,
  "tot_afltd_hha_cnt" DOUBLE,
  "tot_afltd_hospc_cnt" DOUBLE,
  "tot_afltd_opo_cnt" DOUBLE,
  "tot_afltd_prtf_cnt" DOUBLE,
  "tot_afltd_rhc_cnt" DOUBLE,
  "tot_afltd_snf_cnt" DOUBLE,
  "afltd_prvdr_cnt" DOUBLE,
  "rsdnt_pgm_alpthc_sw" VARCHAR,
  "rsdnt_pgm_dntl_sw" VARCHAR,
  "rsdnt_pgm_ostpthc_sw" VARCHAR,
  "rsdnt_pgm_othr_sw" VARCHAR,
  "rsdnt_pgm_pdtrc_sw" VARCHAR,
  "lab_srvc_cd" DOUBLE,
  "phrmcy_srvc_cd" DOUBLE,
  "rdlgy_srvc_cd" DOUBLE,
  "asc_bgn_srvc_dt" DOUBLE,
  "freestndng_asc_sw" VARCHAR,
  "ovrrd_bed_cnt_sw" VARCHAR,
  "crtfd_bed_cnt" DOUBLE,
  "icfiid_bed_cnt" DOUBLE,
  "mdcd_nf_bed_cnt" DOUBLE,
  "mdcr_snf_bed_cnt" DOUBLE,
  "mdcr_mdcd_snf_bed_cnt" DOUBLE,
  "aids_bed_cnt" DOUBLE,
  "alzhmr_bed_cnt" DOUBLE,
  "dlys_bed_cnt" DOUBLE,
  "dsbl_chldrn_bed_cnt" DOUBLE,
  "head_trma_bed_cnt" DOUBLE,
  "hospc_bed_cnt" DOUBLE,
  "hntgtn_dease_bed_cnt" DOUBLE,
  "rehab_bed_cnt" DOUBLE,
  "vntltr_bed_cnt" DOUBLE,
  "bed_cnt" DOUBLE,
  "brnch_cnt" DOUBLE,
  "brnch_oprtn_sw" VARCHAR,
  "cah_psych_dpu_sw" VARCHAR,
  "cah_rehab_dpu_sw" VARCHAR,
  "cah_sb_sw" VARCHAR,
  "crdc_cthrtztn_prcdr_rooms_cnt" DOUBLE,
  "gnrl_fac_type_cd" DOUBLE,
  "chow_sw" VARCHAR,
  "clia_id_number_1" VARCHAR,
  "clia_id_number_2" VARCHAR,
  "clia_id_number_3" VARCHAR,
  "clia_id_number_4" VARCHAR,
  "clia_id_number_5" VARCHAR,
  "colctn_stus_sw" VARCHAR,
  "rn_24_hr_wvr_sw" VARCHAR,
  "rn_7_day_wvr_sw" VARCHAR,
  "bed_per_room_wvr_sw" VARCHAR,
  "lsc_wvr_sw" VARCHAR,
  "room_size_wvr_sw" VARCHAR,
  "endscpy_prcdr_rooms_cnt" DOUBLE,
  "esrd_ntwrk_num" DOUBLE,
  "exprmt_rsrch_cndctd_sw" VARCHAR,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "fqhc_approved_rhc_provider_num" DOUBLE
);

Share link

Anyone who has the link will be able to view this.