Baselight
Sign In

Provider Of Services File - Clinical Laboratories

U.S. Department of Health & Human Services

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f

Loading...
Loading...

About this Dataset

Provider Of Services File - Clinical Laboratories

The Provider of Services (POS) Clinical Laboratories (CLIA) data provides information on CLIA demographics and types of testing services the facility provides. In this file you will find provider number, name, address and characteristics of the participating institution providers.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-04-17T00:07:33.148551
Tags: all-other-provider-care-types, health-care-use-payments, medicare, medicare-advantage, original-medicare

Tables

Provider Of Services File - Clinical Laboratories : 2025-01-01

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2025_01_01
  • 52.78 MB
  • 657403 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2025_01_01 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2024-12-01

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2024_12_01
  • 52.46 MB
  • 653223 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2024_12_01 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2024-09-01

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2024_09_01
  • 52.07 MB
  • 648771 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2024_09_01 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2024-04-01

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2024_04_01
  • 51.59 MB
  • 644378 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2024_04_01 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2024-03-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2024_03_31
  • 51.2 MB
  • 639047 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2024_03_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2023-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2023_12_31
  • 50.77 MB
  • 633947 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2023_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2023-09-01

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2023_09_01
  • 50.27 MB
  • 628095 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2023_09_01 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2022-06-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2022_06_30
  • 48.11 MB
  • 601880 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2022_06_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2022-03-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2022_03_31
  • 47.43 MB
  • 594489 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2022_03_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2021-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_12_31
  • 46.79 MB
  • 586234 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2021_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2021-09-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_09_30
  • 46.21 MB
  • 577154 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2021_09_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2021-06-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_06_30
  • 45.62 MB
  • 569334 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2021_06_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2021-03-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_03_31
  • 44.94 MB
  • 558748 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2021_03_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2020-12-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_12_30
  • 44.13 MB
  • 547510 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2020_12_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2020-09-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_09_30
  • 43.22 MB
  • 536749 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2020_09_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2020-06-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_06_30
  • 42.44 MB
  • 530561 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2020_06_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" BOOLEAN,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" VARCHAR,
  "cross_ref_provider_number" VARCHAR,
  "crtfctn_dt" BIGINT,
  "elgblty_sw" BOOLEAN,
  "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" BOOLEAN,
  "state_cd" VARCHAR,
  "ssa_state_cd" BIGINT,
  "state_rgn_cd" VARCHAR,
  "st_adr" VARCHAR,
  "phne_num" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" BOOLEAN,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" BOOLEAN,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" BOOLEAN,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" BOOLEAN,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" BOOLEAN,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" BOOLEAN,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" BOOLEAN,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" BOOLEAN,
  "hosp_lab_excptn_sw" BOOLEAN,
  "non_prft_excptn_sw" BOOLEAN,
  "lab_temp_tstg_site_sw" BOOLEAN,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" BOOLEAN,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2020-03-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_03_31
  • 42.4 MB
  • 525311 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2020_03_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2019-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_12_31
  • 42.12 MB
  • 521494 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2019_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2019-09-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_09_30
  • 41.75 MB
  • 517027 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2019_09_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2019-06-30

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_06_30
  • 41.37 MB
  • 512897 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2019_06_30 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2019-03-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_03_31
  • 41.05 MB
  • 508730 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2019_03_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2018-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2018_12_31
  • 40.7 MB
  • 504763 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2018_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2017-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2017_12_31
  • 39.23 MB
  • 487626 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2017_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2016-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2016_12_31
  • 37.88 MB
  • 469651 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2016_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" BIGINT,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" BIGINT,
  "current_clia_lab_clsfctn_cd" BIGINT,
  "clia_lab_classification_cd_1" BIGINT,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" BIGINT,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2015-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2015_12_31
  • 38.11 MB
  • 472395 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2015_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" VARCHAR,
  "pgm_trmntn_cd" BIGINT,
  "trmntn_exprtn_dt" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" DOUBLE,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" DOUBLE,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" DOUBLE,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" DOUBLE,
  "current_clia_lab_clsfctn_cd" DOUBLE,
  "clia_lab_classification_cd_1" DOUBLE,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" DOUBLE,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2014-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2014_12_31
  • 36.09 MB
  • 454990 rows
  • 103 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2014_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "cbsa_cd" DOUBLE,
  "addtnl_st_adr" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "a2la_acrdtd_cd" VARCHAR,
  "a2la_acrdtd_y_match_dt" VARCHAR,
  "a2la_acrdtd_y_match_sw" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" DOUBLE,
  "gnrl_fac_type_cd" BIGINT,
  "crtfct_efctv_dt" DOUBLE,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" DOUBLE,
  "current_clia_lab_clsfctn_cd" DOUBLE,
  "clia_lab_classification_cd_1" DOUBLE,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" DOUBLE,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "hosp_lab_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_temp_tstg_site_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "addtnl_fac_name" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR
);

Provider Of Services File - Clinical Laboratories : 2013-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2013_12_31
  • 32.9 MB
  • 436513 rows
  • 97 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2013_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" 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" BIGINT,
  "crtfctn_actn_type_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "aplctn_rcvd_dt" BIGINT,
  "aplctn_type_cd" DOUBLE,
  "ashi_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "crtfct_efctv_dt" DOUBLE,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" DOUBLE,
  "current_clia_lab_clsfctn_cd" DOUBLE,
  "clia_lab_classification_cd_1" DOUBLE,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" DOUBLE,
  "acrdtn_schdl_cd" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "cola_acrdtd_cd" VARCHAR,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "drctly_afltd_lab_cnt" BIGINT,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "jcaho_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "gnrl_fac_type_cd" BIGINT,
  "mlt_site_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "ppmp_test_vol_cnt" BIGINT,
  "clia_67_lcnsd_sw" VARCHAR,
  "related_provider_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR,
  "form_1557_cmplnc_schdl_cd" VARCHAR,
  "form_1557_test_vol_cnt" BIGINT,
  "vldtn_srvy_dt" DOUBLE,
  "wvd_test_vol_cnt" BIGINT
);

Provider Of Services File - Clinical Laboratories : 2012-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2012_12_31
  • 31.23 MB
  • 417354 rows
  • 97 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2012_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "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" DOUBLE,
  "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" BIGINT,
  "srvy_prpse_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "acrdtn_schdl_cd" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "aplctn_rcvd_dt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "aplctn_type_cd" DOUBLE,
  "crtfct_efctv_dt" DOUBLE,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" DOUBLE,
  "current_clia_lab_clsfctn_cd" DOUBLE,
  "clia_lab_classification_cd_1" DOUBLE,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" DOUBLE,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "clia_67_lcnsd_sw" VARCHAR,
  "related_provider_number" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR,
  "form_1557_cmplnc_schdl_cd" VARCHAR,
  "form_1557_test_vol_cnt" BIGINT,
  "wvd_test_vol_cnt" BIGINT,
  "gnrl_fac_type_cd" BIGINT
);

Provider Of Services File - Clinical Laboratories : 2011-12-31

@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2011_12_31
  • 28.89 MB
  • 401319 rows
  • 98 columns
Loading... 

CREATE TABLE provider_of_services_file_clinical_laboratories_2011_12_31 (
  "prvdr_ctgry_sbtyp_cd" BIGINT,
  "prvdr_ctgry_cd" BIGINT,
  "chow_cnt" BIGINT,
  "chow_dt" DOUBLE,
  "city_name" VARCHAR,
  "acptbl_poc_sw" VARCHAR,
  "cmplnc_stus_cd" VARCHAR,
  "ssa_cnty_cd" DOUBLE,
  "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" DOUBLE,
  "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" BIGINT,
  "srvy_prpse_cd" DOUBLE,
  "gnrl_cntl_type_cd" BIGINT,
  "zip_cd" DOUBLE,
  "fips_state_cd" DOUBLE,
  "fips_cnty_cd" DOUBLE,
  "cbsa_urbn_rrl_ind" VARCHAR,
  "affiliated_provider_number_1" VARCHAR,
  "affiliated_provider_number_2" VARCHAR,
  "affiliated_provider_number_3" VARCHAR,
  "affiliated_provider_number_4" VARCHAR,
  "affiliated_provider_number_5" VARCHAR,
  "affiliated_provider_number_6" VARCHAR,
  "affiliated_provider_number_7" VARCHAR,
  "affiliated_provider_number_8" VARCHAR,
  "acrdtn_schdl_cd" VARCHAR,
  "aabb_acrdtd_cd" VARCHAR,
  "aoa_acrdtd_cd" VARCHAR,
  "ashi_acrdtd_cd" VARCHAR,
  "cap_acrdtd_cd" VARCHAR,
  "cola_acrdtd_cd" VARCHAR,
  "jcaho_acrdtd_cd" VARCHAR,
  "aabb_acrdtd_y_match_dt" DOUBLE,
  "aoa_acrdtd_y_match_dt" DOUBLE,
  "ashi_acrdtd_y_match_dt" DOUBLE,
  "cap_acrdtd_y_match_dt" DOUBLE,
  "cola_acrdtd_y_match_dt" DOUBLE,
  "jcaho_acrdtd_y_match_dt" DOUBLE,
  "aabb_acrdtd_y_match_sw" VARCHAR,
  "cola_acrdtd_y_match_sw" VARCHAR,
  "jcaho_acrdtd_y_match_sw" VARCHAR,
  "aoa_acrdtd_y_match_sw" VARCHAR,
  "ashi_acrdtd_y_match_sw" VARCHAR,
  "cap_acrdtd_y_match_sw" VARCHAR,
  "form_116_acrdtd_test_vol_cnt" BIGINT,
  "aplctn_rcvd_dt" BIGINT,
  "form_116_test_vol_cnt" BIGINT,
  "aplctn_type_cd" DOUBLE,
  "crtfct_efctv_dt" DOUBLE,
  "crtfct_mail_dt" DOUBLE,
  "crtfct_type_cd" DOUBLE,
  "current_clia_lab_clsfctn_cd" DOUBLE,
  "clia_lab_classification_cd_1" DOUBLE,
  "clia_lab_classification_cd_10" DOUBLE,
  "clia_lab_classification_cd_2" DOUBLE,
  "clia_lab_classification_cd_3" DOUBLE,
  "clia_lab_classification_cd_4" DOUBLE,
  "clia_lab_classification_cd_5" DOUBLE,
  "clia_lab_classification_cd_6" DOUBLE,
  "clia_lab_classification_cd_7" DOUBLE,
  "clia_lab_classification_cd_8" DOUBLE,
  "clia_lab_classification_cd_9" DOUBLE,
  "clia_mdcr_num" VARCHAR,
  "clia_trmntn_cd" DOUBLE,
  "vldtn_srvy_dt" DOUBLE,
  "fax_phne_num" DOUBLE,
  "fy_end_mo_day_cd" DOUBLE,
  "mlt_site_excptn_sw" VARCHAR,
  "non_prft_excptn_sw" VARCHAR,
  "lab_site_cnt" BIGINT,
  "drctly_afltd_lab_cnt" BIGINT,
  "ppmp_test_vol_cnt" BIGINT,
  "clia_67_lcnsd_sw" VARCHAR,
  "related_provider_number" VARCHAR,
  "shared_lab_xref_number" VARCHAR,
  "shr_lab_sw" VARCHAR,
  "form_1557_crtfct_schdl_cd" VARCHAR,
  "form_1557_cmplnc_schdl_cd" VARCHAR,
  "form_1557_test_vol_cnt" BIGINT,
  "wvd_test_vol_cnt" VARCHAR,
  "gnrl_fac_type_cd" VARCHAR
);

Share link

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