Home

Dataset:

Name medi-cal-certified-eligibles-with-demographics-by-month
Updated 2024-11-04
Current True
Tables
Name:by_age_group_and_sex_certified_eligibles
File:by-age-group-and-sex-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:reference_medi_cal_aid_codes_and_aid_code_groups
File:reference-medi-cal-aid-codes-and-aid-code-groups.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_delivery_system_and_plan_certified_eligibles
File:by-delivery-system-and-plan-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_race_ethnicity_and_age_group_certified_eligibles
File:by-race-ethnicity-and-age-group-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_medicare_dual_status_certified_eligibles
File:by-medicare-dual-status-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_aid_category_certified_eligibles
File:by-aid-category-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_medicare_dual_status_and_age_group_certified_eligibles
File:by-medicare-dual-status-and-age-group-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:by_primary_language_certified_eligibles
File:by-primary-language-certified-eligibles.csv
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:None
File:dhcs-medi-cal-aid-category-grouping-schema.pdf
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Name:None
File:dhcs-medi-cal-aid-category-grouping-schema.pdf
Count:None
Columns:[['county', 'varchar(15)'], ['date_of_tier_assessment', 'varchar(23)'], ['ending_date_of_week_of_data_05_23_21_to_05_29_21', 'varchar(49)'], ['final_tier_assignment_for_06_08_21', 'varchar(34)'], ['previous_tier_assignment_05_31_21_assessment', 'varchar(45)'], ['first_date_in_current_tier', 'varchar(26)'], ['county_tier_assignment_based_on_meeting_accelerated_health_equi', 'varchar(74)'], ['number_of_weeks_in_current_tier', 'varchar(31)'], ['number_of_consecutive_weeks_meeting_criteria_for_less_restricti', 'varchar(70)'], ['number_of_consecutive_weeks_meeting_criteria_for_more_restricti', 'varchar(70)'], ['tier_for_week_05_23_21_to_05_29_21_06_07_21_assessment', 'varchar(55)'], ['small_countytier_for_week_05_23_21_to_05_29_21_06_07_21_assessm', 'varchar(100)'], ['test_positivity_excl_prisons_7_day_7_day_lag', 'varchar(47)'], ['case_rate_used_for_tier_adjusted_using_linear_adjustment_7_day_', 'varchar(79)'], ['unadjusted_case_rate_per_100_000_excl_prisons_7_day_avg_7_day_l', 'varchar(68)'], ['linear_adjustment_factor_applied_to_case_rate', 'varchar(45)'], ['tests_per_100_000_excl_prisons_with_replaced_approved_county_da', 'varchar(124)'], ['population', 'varchar(11)'], ['total_new_cases_7_day_7_day_lag', 'varchar(33)'], ['health_equity_quartile_test_positivity_excl_prison_cases_7_day_', 'varchar(75)'], ['he_quartile_test_positivitypct_within_threshold_for_less_restri', 'varchar(91)'], ['number_of_consecutive_weeks_of_health_equity_metric_towards_mov', 'varchar(111)'], ['eligible_for_accelerated_health_equity_criteria_to_move_to_less', 'varchar(129)'], ['number_of_consecutive_weeks_towards_movement_to_less_restrictiv', 'varchar(110)'], ['notes_about_countys_tier_status_for_06_07_21_assessment', 'varchar(59)']]

Sources by-age-group-and-sex-certified-eligibles.csv
reference-medi-cal-aid-codes-and-aid-code-groups.csv
by-delivery-system-and-plan-certified-eligibles.csv
by-race-ethnicity-and-age-group-certified-eligibles.csv
by-medicare-dual-status-certified-eligibles.csv
by-aid-category-certified-eligibles.csv
by-medicare-dual-status-and-age-group-certified-eligibles.csv
by-primary-language-certified-eligibles.csv
datapackage.json
dhcs-medi-cal-aid-category-grouping-schema.pdf
Updates
2024-12-27 18:55:10      0
2024-12-12 14:44:53      None
2024-12-04 16:44:23      None