Home

Dataset:

Name	health-and-human-services-program-counts
Updated	2024-08-28
CA Dataset	link
Current	True
Tables	record_reconciliation_2015_2021_annual_data_file     fileyear - varchar(11) program - varchar(11) level - varchar(14) number - varchar(20) person - varchar(8) cases - varchar(7) medi_cal - varchar(8) aca - varchar(7) fpact - varchar(6) calfresh - varchar(8) calworks - varchar(8) ihss - varchar(6) child_welfare - varchar(13) foster_care - varchar(11) dds - varchar(6) wic - varchar(7) black - varchar(7) white - varchar(7) hispanic - varchar(8) asian_pi - varchar(8) native_american - varchar(15) other_missing - varchar(13) female - varchar(7) male - varchar(7) unknown_other_gender - varchar(20) age1_missing - varchar(12) 17_and_under - varchar(12) 18_and_over - varchar(11) 18_64 - varchar(7) 65_and_over - varchar(11) 18_to_59 - varchar(8) 60_and_over - varchar(11) 1_program - varchar(9) 2_programs - varchar(10) 3_programs - varchar(10) 4_programs - varchar(10) 5_plus_programs - varchar(11) 1_department - varchar(12) 2_departments - varchar(13) 3_departments - varchar(13) 4_departments - varchar(13) fc_age_missing - varchar(14) age_0 - varchar(5) 1_to_2 - varchar(6) 3_to_5 - varchar(6) 6_to_10 - varchar(7) 11_to_15 - varchar(8) 16_to_17 - varchar(8) 18_to_20 - varchar(8) wic_age_adult_missing - varchar(21) less_than_19 - varchar(12) 20_to_24 - varchar(8) 25_to_29 - varchar(8) 30_to_34 - varchar(8) 35_and_over - varchar(11) wic_age_child_missing - varchar(21) wic_age_0 - varchar(9) wic_age_1 - varchar(9) wic_age_2 - varchar(9) wic_age_3 - varchar(9) wic_age_4 - varchar(9) wic_age_5_to_19 - varchar(15) wic_age_20_and_over - varchar(19) record_reconciliation_2015_2021_annual_masking_key     fileyear - varchar(11) program - varchar(11) level - varchar(14) number - varchar(20) person - varchar(6) cases - varchar(5) medi_cal - varchar(8) aca - varchar(3) fpact - varchar(5) calfresh - varchar(8) calworks - varchar(8) ihss - varchar(4) child_welfare - varchar(13) foster_care - varchar(11) dds - varchar(3) wic - varchar(3) black - varchar(5) white - varchar(5) hispanic - varchar(8) asian_pi - varchar(8) native_american - varchar(15) other_missing - varchar(13) female - varchar(6) male - varchar(4) unknown_other_gender - varchar(20) age1_missing - varchar(12) 17_and_under - varchar(12) 18_and_over - varchar(11) 18_64 - varchar(5) 65_and_over - varchar(11) 18_to_59 - varchar(8) 60_and_over - varchar(11) 1_program - varchar(9) 2_programs - varchar(10) 3_programs - varchar(10) 4_programs - varchar(10) 5_plus_programs - varchar(11) 1_department - varchar(12) 2_departments - varchar(13) 3_departments - varchar(13) 4_departments - varchar(13) fc_age_missing - varchar(14) age_0 - varchar(5) 1_to_2 - varchar(6) 3_to_5 - varchar(6) 6_to_10 - varchar(7) 11_to_15 - varchar(8) 16_to_17 - varchar(8) 18_to_20 - varchar(8) wic_age_adult_missing - varchar(21) less_than_19 - varchar(12) 20_to_24 - varchar(8) 25_to_29 - varchar(8) 30_to_34 - varchar(8) 35_and_over - varchar(11) wic_age_child_missing - varchar(21) wic_age_0 - varchar(9) wic_age_1 - varchar(9) wic_age_2 - varchar(9) wic_age_3 - varchar(9) wic_age_4 - varchar(9) wic_age_5_to_19 - varchar(15) wic_age_20_and_over - varchar(19) record_reconciliation_2015_2021_july_data_file     fileyear - varchar(11) program - varchar(11) level - varchar(14) number - varchar(20) person - varchar(8) cases - varchar(7) medi_cal - varchar(8) aca - varchar(7) fpact - varchar(6) calfresh - varchar(8) calworks - varchar(8) ihss - varchar(6) child_welfare - varchar(13) foster_care - varchar(11) dds - varchar(6) wic - varchar(7) black - varchar(7) white - varchar(7) hispanic - varchar(8) asian_pi - varchar(8) native_american - varchar(15) other_missing - varchar(13) female - varchar(7) male - varchar(7) unknown_other_gender - varchar(20) age1_missing - varchar(12) 17_and_under - varchar(12) 18_and_over - varchar(11) 18_64 - varchar(7) 65_and_over - varchar(11) 18_to_59 - varchar(8) 60_and_over - varchar(11) 1_program - varchar(9) 2_programs - varchar(10) 3_programs - varchar(10) 4_programs - varchar(10) 5_plus_programs - varchar(11) 1_department - varchar(12) 2_departments - varchar(13) 3_departments - varchar(13) 4_departments - varchar(13) fc_age_missing - varchar(14) age_0 - varchar(5) 1_to_2 - varchar(6) 3_to_5 - varchar(6) 6_to_10 - varchar(7) 11_to_15 - varchar(8) 16_to_17 - varchar(8) 18_to_20 - varchar(8) wic_age_adult_missing - varchar(21) less_than_19 - varchar(12) 20_to_24 - varchar(8) 25_to_29 - varchar(8) 30_to_34 - varchar(8) 35_and_over - varchar(11) wic_age_child_missing - varchar(21) wic_age_0 - varchar(9) wic_age_1 - varchar(9) wic_age_2 - varchar(9) wic_age_3 - varchar(9) wic_age_4 - varchar(9) wic_age_5_to_19 - varchar(15) wic_age_20_and_over - varchar(19) record_reconciliation_2015_2021_july_masking_key     fileyear - varchar(11) program - varchar(11) level - varchar(14) number - varchar(20) person - varchar(6) cases - varchar(5) medi_cal - varchar(8) aca - varchar(3) fpact - varchar(5) calfresh - varchar(8) calworks - varchar(8) ihss - varchar(4) child_welfare - varchar(13) foster_care - varchar(11) dds - varchar(3) wic - varchar(3) black - varchar(5) white - varchar(5) hispanic - varchar(8) asian_pi - varchar(8) native_american - varchar(15) other_missing - varchar(13) female - varchar(6) male - varchar(4) unknown_other_gender - varchar(20) age1_missing - varchar(12) 17_and_under - varchar(12) 18_and_over - varchar(11) 18_64 - varchar(5) 65_and_over - varchar(11) 18_to_59 - varchar(8) 60_and_over - varchar(11) 1_program - varchar(9) 2_programs - varchar(10) 3_programs - varchar(10) 4_programs - varchar(10) 5_plus_programs - varchar(11) 1_department - varchar(12) 2_departments - varchar(13) 3_departments - varchar(13) 4_departments - varchar(13) fc_age_missing - varchar(14) age_0 - varchar(5) 1_to_2 - varchar(6) 3_to_5 - varchar(6) 6_to_10 - varchar(7) 11_to_15 - varchar(8) 16_to_17 - varchar(8) 18_to_20 - varchar(8) wic_age_adult_missing - varchar(21) less_than_19 - varchar(12) 20_to_24 - varchar(8) 25_to_29 - varchar(8) 30_to_34 - varchar(8) 35_and_over - varchar(11) wic_age_child_missing - varchar(21) wic_age_0 - varchar(9) wic_age_1 - varchar(9) wic_age_2 - varchar(9) wic_age_3 - varchar(9) wic_age_4 - varchar(9) wic_age_5_to_19 - varchar(15) wic_age_20_and_over - varchar(19)
Sources	calhhs-program-dashboard.chart  -    methodology.html  -    datapackage.json  -    record-reconciliation-2015-2021-annual-data-file.csv  -  Table: record_reconciliation_2015_2021_annual_data_file   Fails: 17 record-reconciliation-2015-2021-annual-masking-key.csv  -  Table: record_reconciliation_2015_2021_annual_masking_key   Fails: 17 record-reconciliation-2015-2021-july-data-file.csv  -  Table: record_reconciliation_2015_2021_july_data_file   Fails: 17 record-reconciliation-2015-2021-july-masking-key.csv  -  Table: record_reconciliation_2015_2021_july_masking_key   Fails: 17
Updated