US Physician Referral Networks
Data license: Please contact the data provider for more information. · Data source: U.S. Census, Dartmouth Atlas of Health Care, NCQA, AIDOS Lab.
Tables
hedis_measures
hsa, year, obd_overall_diab_bloodlip, obd_nonblk_diab_bloodlip, obd_blk_diab_bloodlip, obd_blk_diab_eye, obd_overall_diab_eye, obd_nonblk_diab_eye, obd_overall_diab_hgb, obd_blk_diab_hgb, obd_nonblk_diab_hgb, obd_overall_mam_mam6769, obd_nonblk_mam_mam6769, obd_blk_mam_mam6769, obd_nonblk_ptbjune_amcare2, obd_blk_ptbjune_amcare2, obd_overall_ptbjune_amcare2, oe_overall_diab_bloodlip, oe_nonblk_diab_bloodlip, oe_blk_diab_bloodlip, oe_blk_diab_eye, oe_overall_diab_eye, oe_nonblk_diab_eye, oe_overall_diab_hgb, oe_blk_diab_hgb, oe_nonblk_diab_hgb, oe_overall_mam_mam6769, oe_nonblk_mam_mam6769, oe_blk_mam_mam6769, oe_nonblk_ptbjune_amcare2, oe_blk_ptbjune_amcare2, oe_overall_ptbjune_amcare2, cr_overall_diab_bloodlip, cr_nonblk_diab_bloodlip, cr_blk_diab_bloodlip, cr_blk_diab_eye, cr_overall_diab_eye, cr_nonblk_diab_eye, cr_overall_diab_hgb, cr_blk_diab_hgb, cr_nonblk_diab_hgb, cr_overall_mam_mam6769, cr_nonblk_mam_mam6769, cr_blk_mam_mam6769, cr_nonblk_ptbjune_amcare2, cr_blk_ptbjune_amcare2, cr_overall_ptbjune_amcare2, ar_overall_diab_bloodlip, ar_nonblk_diab_bloodlip, ar_blk_diab_bloodlip, ar_blk_diab_eye, ar_overall_diab_eye, ar_nonblk_diab_eye, ar_overall_diab_hgb, ar_blk_diab_hgb, ar_nonblk_diab_hgb, ar_overall_mam_mam6769, ar_nonblk_mam_mam6769, ar_blk_mam_mam6769, ar_nonblk_ptbjune_amcare2, ar_blk_ptbjune_amcare2, ar_overall_ptbjune_amcare2, ptl_overall_diab_bloodlip, ptl_nonblk_diab_bloodlip, ptl_blk_diab_bloodlip, ptl_blk_diab_eye, ptl_overall_diab_eye, ptl_nonblk_diab_eye, ptl_overall_diab_hgb, ptl_blk_diab_hgb, ptl_nonblk_diab_hgb, ptl_overall_mam_mam6769, ptl_nonblk_mam_mam6769, ptl_blk_mam_mam6769, ptl_nonblk_ptbjune_amcare2, ptl_blk_ptbjune_amcare2, ptl_overall_ptbjune_amcare2
41,244 rows
hospital_atlas_data
provider, new_prov, status14, shortname, pcity, pstate, pzip, hsa, hsaname, hrr, hrrname, fcounty, fcntyname, posbeds, sysname, ahabeds, category, teachstatus, hosptype, nci_center, excl_flag, icu_flag, year, status15, status16, pname, status17, latitude, longitude
20,479 rows
population_census
hsa, year, race_total_pop, race_black_pop, hispanic_total_pop, hispanic_pop, median_hh_income, employment_pop, employment_unemployed_pop, education_pop, education_nohs_pop
13,744 rows
post_discharge_records
hsa, year, obd_pt_asr_ami_anyac, obd_pt_asr_ami_aoervis, obd_pt_asr_ami_mdac, obd_pt_asr_ami_readmit, obd_pt_asr_chf_anyac, obd_pt_asr_chf_aoervis, obd_pt_asr_chf_mdac, obd_pt_asr_chf_readmit, obd_pt_asr_med_anyac, obd_pt_asr_med_aoervis, obd_pt_asr_med_mdac, obd_pt_asr_med_readmit, obd_pt_asr_pn_anyac, obd_pt_asr_pn_aoervis, obd_pt_asr_pn_mdac, obd_pt_asr_pn_readmit, obd_pt_asr_sur_aoervis, obd_pt_asr_sur_mdac, obd_pt_asr_sur_readmit, oecr_pt_asr_ami_anyac, oecr_pt_asr_ami_aoervis, oecr_pt_asr_ami_mdac, oecr_pt_asr_ami_readmit, oecr_pt_asr_chf_anyac, oecr_pt_asr_chf_aoervis, oecr_pt_asr_chf_mdac, oecr_pt_asr_chf_readmit, oecr_pt_asr_med_anyac, oecr_pt_asr_med_aoervis, oecr_pt_asr_med_mdac, oecr_pt_asr_med_readmit, oecr_pt_asr_pn_anyac, oecr_pt_asr_pn_aoervis, oecr_pt_asr_pn_mdac, oecr_pt_asr_pn_readmit, oecr_pt_asr_sur_aoervis, oecr_pt_asr_sur_mdac, oecr_pt_asr_sur_readmit, oear_pt_asr_ami_anyac, oear_pt_asr_ami_aoervis, oear_pt_asr_ami_mdac, oear_pt_asr_ami_readmit, oear_pt_asr_chf_anyac, oear_pt_asr_chf_aoervis, oear_pt_asr_chf_mdac, oear_pt_asr_chf_readmit, oear_pt_asr_med_anyac, oear_pt_asr_med_aoervis, oear_pt_asr_med_mdac, oear_pt_asr_med_readmit, oear_pt_asr_pn_anyac, oear_pt_asr_pn_aoervis, oear_pt_asr_pn_mdac, oear_pt_asr_pn_readmit, oear_pt_asr_sur_aoervis, oear_pt_asr_sur_mdac, oear_pt_asr_sur_readmit, exp_pt_asr_ami_anyac, exp_pt_asr_ami_aoervis, exp_pt_asr_ami_mdac, exp_pt_asr_ami_readmit, exp_pt_asr_chf_anyac, exp_pt_asr_chf_aoervis, exp_pt_asr_chf_mdac, exp_pt_asr_chf_readmit, exp_pt_asr_med_anyac, exp_pt_asr_med_aoervis, exp_pt_asr_med_mdac, exp_pt_asr_med_readmit, exp_pt_asr_pn_anyac, exp_pt_asr_pn_aoervis, exp_pt_asr_pn_mdac, exp_pt_asr_pn_readmit, exp_pt_asr_sur_aoervis, exp_pt_asr_sur_mdac, exp_pt_asr_sur_readmit, expa_pt_asr_ami_anyac, expa_pt_asr_ami_aoervis, expa_pt_asr_ami_mdac, expa_pt_asr_ami_readmit, expa_pt_asr_chf_anyac, expa_pt_asr_chf_aoervis, expa_pt_asr_chf_mdac, expa_pt_asr_chf_readmit, expa_pt_asr_med_anyac, expa_pt_asr_med_aoervis, expa_pt_asr_med_mdac, expa_pt_asr_med_readmit, expa_pt_asr_pn_anyac, expa_pt_asr_pn_aoervis, expa_pt_asr_pn_mdac, expa_pt_asr_pn_readmit, expa_pt_asr_sur_aoervis, expa_pt_asr_sur_mdac, expa_pt_asr_sur_readmit, cr_pt_asr_ami_anyac, cr_pt_asr_ami_aoervis, cr_pt_asr_ami_mdac, cr_pt_asr_ami_readmit, cr_pt_asr_chf_anyac, cr_pt_asr_chf_aoervis, cr_pt_asr_chf_mdac, cr_pt_asr_chf_readmit, cr_pt_asr_med_anyac, cr_pt_asr_med_aoervis, cr_pt_asr_med_mdac, cr_pt_asr_med_readmit, cr_pt_asr_pn_anyac, cr_pt_asr_pn_aoervis, cr_pt_asr_pn_mdac, cr_pt_asr_pn_readmit, cr_pt_asr_sur_aoervis, cr_pt_asr_sur_mdac, cr_pt_asr_sur_readmit, ar_pt_asr_ami_anyac, ar_pt_asr_ami_aoervis, ar_pt_asr_ami_mdac, ar_pt_asr_ami_readmit, ar_pt_asr_chf_anyac, ar_pt_asr_chf_aoervis, ar_pt_asr_chf_mdac, ar_pt_asr_chf_readmit, ar_pt_asr_med_anyac, ar_pt_asr_med_aoervis, ar_pt_asr_med_mdac, ar_pt_asr_med_readmit, ar_pt_asr_pn_anyac, ar_pt_asr_pn_aoervis, ar_pt_asr_pn_mdac, ar_pt_asr_pn_readmit, ar_pt_asr_sur_aoervis, ar_pt_asr_sur_mdac, ar_pt_asr_sur_readmit, ptl_pt_asr_ami_anyac, ptl_pt_asr_ami_aoervis, ptl_pt_asr_ami_mdac, ptl_pt_asr_ami_readmit, ptl_pt_asr_chf_anyac, ptl_pt_asr_chf_aoervis, ptl_pt_asr_chf_mdac, ptl_pt_asr_chf_readmit, ptl_pt_asr_med_anyac, ptl_pt_asr_med_aoervis, ptl_pt_asr_med_mdac, ptl_pt_asr_med_readmit, ptl_pt_asr_pn_anyac, ptl_pt_asr_pn_aoervis, ptl_pt_asr_pn_mdac, ptl_pt_asr_pn_readmit, ptl_pt_asr_sur_aoervis, ptl_pt_asr_sur_mdac, ptl_pt_asr_sur_readmit
37,807 rows
referral_network_features
hsa, year, assortativity, average_clustering, density, nnodes, nedges, forman_mean, forman_stdev, forman_median, forman_mode, forman_quantile_25, forman_quantile_50, forman_quantile_75, centrality_mean, centrality_stdev, centrality_median, centrality_mode, centrality_quantile_25, centrality_quantile_50, centrality_quantile_75
13,493 rows
standard_pricing
hsa, year, ar_pmt_dme, ar_pmt_hha, ar_pmt_hospice, ar_pmt_hospitalsnf, ar_pmt_outpt, ar_pmt_physician, ar_pmt_total, ar_stdprice_dme, ar_stdprice_hha, ar_stdprice_hospice, ar_stdprice_hospitalsnf, ar_stdprice_outpt, ar_stdprice_physician, ar_stdprice_total, oe_pmt_dme, oe_pmt_hha, oe_pmt_hospice, oe_pmt_hospitalsnf, oe_pmt_outpt, oe_pmt_physician, oe_pmt_total, oe_stdprice_dme, oe_stdprice_hha, oe_stdprice_hospice, oe_stdprice_hospitalsnf, oe_stdprice_outpt, oe_stdprice_physician, oe_stdprice_total, ptl_pmt_dme, ptl_pmt_hha, ptl_pmt_hospice, ptl_pmt_hospitalsnf, ptl_pmt_outpt, ptl_pmt_physician, ptl_pmt_total, ptl_stdprice_dme, ptl_stdprice_hha, ptl_stdprice_hospice, ptl_stdprice_hospitalsnf, ptl_stdprice_outpt, ptl_stdprice_physician, ptl_stdprice_total
30,933 rows
Download SQLite DB: us_physician_referral_networks.db 2.8 GB