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-09-23T12:48:29.907730
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

28.49 kB
183 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

3.08 MB
89,192 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

436.66 kB
11,841 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

58.09 kB
799 rows
16 columns

CREATE TABLE ccs_special_care_centers (
  "scc" VARCHAR  -- SCC #,
  "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
);