MCNA - T/D Standards By County
State of California
@usgov.ca_gov_mcna_t_d_standards_by_county_079e4
State of California
@usgov.ca_gov_mcna_t_d_standards_by_county_079e4
The Network Adequacy Standards data is divided out by Provider Type, Adult and Pediatric separately, so that the Time or Distance analysis can be performed with greater detail. These standards differ by County due to the County "type" which is based on the population density of the county. There are 5 county categories within California; Rural (<50 people/sq mile), Small (51-200 people/sq mile), Medium (201-599 people/sq mile), and Dense (>600 people/sq mile).
CREATE TABLE table_1 (
"objectid" BIGINT,
"state_fips" BIGINT,
"county_fips" BIGINT,
"county_cd" BIGINT,
"county_name" VARCHAR,
"county_size_type" VARCHAR,
"people_per_sq_mile" VARCHAR,
"time_threshold_hospitals" BIGINT,
"distance_threshold_hospitals" BIGINT,
"time_threshold_adult_pcp" BIGINT,
"distance_threshold_adult_pcp" BIGINT,
"time_threshold_pediatric_pcp" BIGINT,
"distance_threshold_pediatric_pc" BIGINT,
"time_threshold_ob_gyn_primary" BIGINT,
"distance_threshold_ob_gyn_prima" BIGINT,
"time_threshold_ob_gyn_specialty" BIGINT,
"distance_threshold_ob_gyn_speci" BIGINT,
"time_threshold_adult_cardiology" BIGINT,
"distance_threshold_adult_cardio" BIGINT,
"time_threshold_adult_dermatolog" BIGINT,
"distance_threshold_adult_dermat" BIGINT,
"time_threshold_adult_endocrinol" BIGINT,
"distance_threshold_adult_endocr" BIGINT,
"time_threshold_adult_ent_otolar" BIGINT,
"distance_threshold_adult_ent_ot" BIGINT,
"time_threshold_adult_gastroente" BIGINT,
"distance_threshold_adult_gastro" BIGINT,
"time_threshold_adult_general_su" BIGINT,
"distance_threshold_adult_genera" BIGINT,
"time_threshold_adult_hematology" BIGINT,
"distance_threshold_adult_hemato" BIGINT,
"time_threshold_adult_hiv_aids_i" BIGINT,
"distance_threshold_adult_hiv_ai" BIGINT,
"time_threshold_adult_mental_hea" BIGINT,
"distance_threshold_adult_mental" BIGINT,
"time_threshold_adult_nephrology" BIGINT,
"distance_threshold_adult_nephro" BIGINT,
"time_threshold_adult_neurology" BIGINT,
"distance_threshold_adult_neurol" BIGINT,
"time_threshold_adult_oncology" BIGINT,
"distance_threshold_adult_oncolo" BIGINT,
"time_threshold_adult_ophthalmol" BIGINT,
"distance_threshold_adult_ophtha" BIGINT,
"time_threshold_adult_orthopedic" BIGINT,
"distance_threshold_adult_orthop" BIGINT,
"time_threshold_adult_physical_m" BIGINT,
"distance_threshold_adult_physic" BIGINT,
"time_threshold_adult_psychiatry" BIGINT,
"distance_threshold_adult_psychi" BIGINT,
"time_threshold_adult_pulmonolog" BIGINT,
"distance_threshold_adult_pulmon" BIGINT,
"time_threshold_pediatric_cardio" BIGINT,
"distance_threshold_pediatric_ca" BIGINT,
"time_threshold_pediatric_dermat" BIGINT,
"distance_threshold_pediatric_de" BIGINT,
"time_threshold_pediatric_endocr" BIGINT,
"distance_threshold_pediatric_en" BIGINT,
"time_threshold_pediatric_ent_ot" BIGINT,
"distance_threshold_pediatric_1" BIGINT -- DISTANCE THRESHOLD PEDIATRIC, 1,
"time_threshold_pediatric_gastro" BIGINT,
"distance_threshold_pediatric_ga" BIGINT,
"time_threshold_pediatric_genera" BIGINT,
"distance_threshold_pediatric_ge" BIGINT,
"time_threshold_pediatric_hemato" BIGINT,
"distance_threshold_pediatric_he" BIGINT,
"time_threshold_pediatric_hiv_ai" BIGINT,
"distance_threshold_pediatric_hi" BIGINT,
"time_threshold_pediatric_mental" BIGINT,
"distance_threshold_pediatric_me" BIGINT,
"time_threshold_pediatric_nephro" BIGINT,
"distance_threshold_pediatric_ne" BIGINT,
"time_threshold_pediatric_neurol" BIGINT,
"distance_threshold_pediatric_2" BIGINT -- DISTANCE THRESHOLD PEDIATRIC, 2,
"time_threshold_pediatric_ophtha" BIGINT,
"distance_threshold_pediatric_op" BIGINT,
"time_threshold_pediatric_orthop" BIGINT,
"distance_threshold_pediatric_or" BIGINT,
"time_threshold_pediatric_physic" BIGINT,
"distance_threshold_pediatric_ph" BIGINT,
"time_threshold_pediatric_psychi" BIGINT,
"distance_threshold_pediatric_ps" BIGINT,
"time_threshold_pediatric_pulmon" BIGINT,
"distance_threshold_pediatric_pu" BIGINT
);Anyone who has the link will be able to view this.