Home

Dataset:

Name	california-children-s-services-ccs
Updated	2025-05-08
CA Dataset	link
Current	True
Tables	ccs_approved_hospitals     npi - varchar(10) legal_name - varchar(28) business_name - varchar(28) facility_type - varchar(53) start_date - varchar(10) end_date - varchar(10) county - varchar(15) address_line_1 - varchar(28) address_line_2 - varchar(14) city - varchar(15) state - varchar(5) zip_code - varchar(10) phone - varchar(18) ccs_non_providers     npi - varchar(10) last_name - varchar(25) first_name - varchar(20) middle_name - varchar(15) provider_type - varchar(44) specialty - varchar(67) effective_date - varchar(14) expiration_date - varchar(15) county - varchar(15) address_line_1 - varchar(48) address_line_2 - varchar(87) city - varchar(22) state - varchar(5) zip_code - varchar(8) phone - varchar(14) ccs_paneled_providers     npi - varchar(10) provider_name - varchar(29) provider_type - varchar(44) specialty_subspecialty - varchar(71) panel_date - varchar(10) expiration_date - varchar(15) county - varchar(15) address_line_1 - varchar(43) address_line_2 - varchar(28) city - varchar(22) state - varchar(5) zip_code - varchar(10) phone - varchar(19) ccs_special_care_centers     scc_num - varchar(8) center_name - varchar(77) scc_type - varchar(52) scc_effective_date - varchar(18) facility_status - varchar(15) county - varchar(15) npi - varchar(10) provider_name - varchar(28) business_name - varchar(28) address_line_1 - varchar(28) address_line_2 - varchar(20) city - varchar(16) state - varchar(5) zip_code - varchar(10) phone - varchar(19)
Sources	datapackage.json  -    ccs-approved-hospitals.csv  -  Table: ccs_approved_hospitals   Updated: 2025-10-11 ccs-paneled-providers-non-provider-master-file-pmf.csv  -  Table: ccs_non_providers   Updated: 2025-10-11 ccs-paneled-providers.csv  -  Table: ccs_paneled_providers   Fails: 3 ccs-special-care-centers.csv  -  Table: ccs_special_care_centers   Fails: 3
Updated