| Name |
california-children-s-services-ccs |
|---|
| Updated |
2025-05-08 |
|---|
| 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 |
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
|
|---|
| Updates |
| 2025-06-11 10:58:03 |
|
0 |
| 2025-06-11 10:55:18 |
|
0 |
| 2025-06-11 10:53:28 |
|
0 |
| 2025-06-11 10:49:52 |
|
1 |
| 2025-06-10 10:56:49 |
|
0 |
| 2025-06-10 10:52:54 |
|
1 |
| 2025-06-06 11:24:16 |
|
1 |
| 2025-02-10 10:41:32 |
|
0 |
| 2025-02-02 17:22:49 |
|
0 |
| 2025-01-31 15:11:05 |
|
0 |
| 2025-01-14 18:06:06 |
|
0 |
| 2025-01-14 18:05:34 |
|
1 |
| 2025-01-14 17:59:07 |
|
0 |
| 2025-01-14 17:57:43 |
|
0 |
| 2025-01-14 17:55:45 |
|
0 |
| 2025-01-14 17:50:05 |
|
0 |
| 2025-01-14 17:49:36 |
|
1 |
| 2025-01-14 17:47:43 |
|
0 |
| 2025-01-14 17:46:52 |
|
0 |
| 2024-12-27 18:06:18 |
|
0 |
| 2024-12-12 11:03:26 |
|
None |
| 2024-12-06 07:43:44 |
|
None |
| 2024-12-04 16:16:17 |
|
None |
| 2024-09-18 10:55:11 |
|
None |
| 2024-09-18 08:56:09 |
|
None |
| 2024-09-17 20:07:36 |
|
None |
|
|---|