About this Dataset

California Children’s Services (CCS) All Provider Lists

Providers approved by the CCS program to render services to CCS enrollees.
Organization: State of California
Last updated: 2025-07-23T15:33:30.198071
Tags: california-childrens-health-services, california-department-of-health-care-services, ccs, ccs-approved-hospitals, ccs-paneled-providers-non-pmf, ccs-special-care-center, dhcs

Tables

CCS Approved Hospitals

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.ccs_approved_hospitals

27.91 KB
184 rows
15 columns


CREATE TABLE ccs_approved_hospitals (
  "npi" BIGINT,
  "legal_name" VARCHAR,
  "business_name" VARCHAR,
  "facility_type" VARCHAR,
  "facility_status" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "most_recent_review_date" TIMESTAMP,
  "county" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "phone" VARCHAR
);

CCS Paneled Providers

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.ccs_paneled_providers

2.93 MB
88787 rows
13 columns


CREATE TABLE ccs_paneled_providers (
  "npi" VARCHAR,
  "provider_name" VARCHAR,
  "provider_type" VARCHAR,
  "specialty_subspecialty" VARCHAR,
  "panel_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "county" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "phone" VARCHAR
);

CCS Paneled Providers Non Provider Master File (PMF)

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.ccs_paneled_providers_non_provider_master_file_pmf

421.68 KB
11709 rows
15 columns


CREATE TABLE ccs_paneled_providers_non_provider_master_file_pmf (
  "npi" DOUBLE,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "provider_type" VARCHAR,
  "specialty" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "county" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "phone" VARCHAR
);

CCS Special Care Centers

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.ccs_special_care_centers

56.53 KB
794 rows
16 columns


CREATE TABLE ccs_special_care_centers (
  "scc" VARCHAR,
  "center_name" VARCHAR,
  "scc_type" VARCHAR,
  "scc_effective_date" TIMESTAMP,
  "facility_status" VARCHAR,
  "most_recent_review_date" TIMESTAMP,
  "county" VARCHAR,
  "npi" DOUBLE,
  "provider_name" VARCHAR,
  "business_name" VARCHAR,
  "address_line_1" VARCHAR,
  "address_line_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "phone" VARCHAR
);

Data Dictionary - CCS Approved Hospitals

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.data_dictionary_ccs_approved_hospitals

3.89 KB
15 rows
4 columns


CREATE TABLE data_dictionary_ccs_approved_hospitals (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

Data Dictionary - CCS Paneled Providers

@usgov.ca_gov_california_childrens_services_ccs_all_provider__f0ca9d44.data_dictionary_ccs_paneled_providers

3.92 KB
13 rows
4 columns


CREATE TABLE data_dictionary_ccs_paneled_providers (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);