| 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 | - | None |
| ccs-approved-hospitals.csv | - | ccs_approved_hospitals |
| ccs-paneled-providers-non-provider-master-file-pmf.csv | - | ccs_non_providers |
| ccs-paneled-providers.csv | - | ccs_paneled_providers |
| ccs-special-care-centers.csv | - | ccs_special_care_centers |
|
|---|
| Updated | |
|---|