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...
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-07-17T16:47:08.594814
Tags: all-other-provider-care-types, health-care-use-payments, medicare, medicare-advantage, original-medicare
Tables
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
- 30.3 MB
- 401,319 rows
- 98 columns
Loading...
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
);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
- 32.74 MB
- 417,354 rows
- 97 columns
Loading...
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 : 2013-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2013_12_31
- 34.5 MB
- 436,513 rows
- 97 columns
Loading...
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 : 2014-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2014_12_31
- 37.85 MB
- 454,990 rows
- 103 columns
Loading...
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 : 2015-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2015_12_31
- 39.96 MB
- 472,395 rows
- 103 columns
Loading...
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 : 2016-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2016_12_31
- 39.72 MB
- 469,651 rows
- 103 columns
Loading...
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 : 2017-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2017_12_31
- 41.14 MB
- 487,626 rows
- 103 columns
Loading...
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 : 2018-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2018_12_31
- 42.68 MB
- 504,763 rows
- 103 columns
Loading...
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 : 2019-03-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_03_31
- 43.05 MB
- 508,730 rows
- 103 columns
Loading...
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 : 2019-06-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_06_30
- 43.38 MB
- 512,897 rows
- 103 columns
Loading...
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-09-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_09_30
- 43.78 MB
- 517,027 rows
- 103 columns
Loading...
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-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2019_12_31
- 44.17 MB
- 521,494 rows
- 103 columns
Loading...
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 : 2020-03-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_03_31
- 44.46 MB
- 525,311 rows
- 103 columns
Loading...
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 : 2020-06-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_06_30
- 44.5 MB
- 530,561 rows
- 103 columns
Loading...
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-09-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_09_30
- 45.32 MB
- 536,749 rows
- 103 columns
Loading...
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-12-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2020_12_30
- 46.27 MB
- 547,510 rows
- 103 columns
Loading...
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 : 2021-03-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_03_31
- 47.12 MB
- 558,748 rows
- 103 columns
Loading...
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 : 2021-06-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_06_30
- 47.84 MB
- 569,334 rows
- 103 columns
Loading...
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-09-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_09_30
- 48.45 MB
- 577,154 rows
- 103 columns
Loading...
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-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2021_12_31
- 49.06 MB
- 586,234 rows
- 103 columns
Loading...
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 : 2022-03-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2022_03_31
- 49.74 MB
- 594,489 rows
- 103 columns
Loading...
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 : 2022-06-30
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2022_06_30
- 50.44 MB
- 601,880 rows
- 103 columns
Loading...
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 : 2023-09-01
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2023_09_01
- 52.71 MB
- 628,095 rows
- 103 columns
Loading...
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 : 2023-12-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2023_12_31
- 53.24 MB
- 633,947 rows
- 103 columns
Loading...
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 : 2024-03-31
@usgov.hhs_gov_provider_of_services_file_clinical_laboratories_1675f.provider_of_services_file_clinical_laboratories_2024_03_31
- 53.69 MB
- 639,047 rows
- 103 columns
Loading...
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
);