About this Dataset

Community Care Licensing Facilities

Community Care Licensing Division

The Community Care Licensing Division’s (CCLD) mission is to promote the health, safety, and quality of life of each person in community care through the administration of an effective collaborative regulatory enforcement system. This is accomplished by:

Promoting strategies to increase voluntary compliance
Providing technical assistance to and consulting with care providers
Working collaboratively with clients, their families, advocates, care providers, placement agencies, related programs and regulatory agencies, and others involved in community care
Training staff in all aspects of the licensing process
Educating the public about CCLD and community care options
Promoting continuous improvement and efficiency throughout the community care licensing system
Organization: State of California
Last updated: 2025-07-23T20:32:34.560001
Tags: california-department-of-social-services, ccld, cdss, community-care, dss, licensing

Tables

Adult Residential Facilities

@usgov.ca_gov_community_care_licensing_facilities.adult_residential_facilities

889.9 kB
10,498 rows
17 columns

CREATE TABLE adult_residential_facilities (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" VARCHAR,
  "county_name" VARCHAR,
  "regional_office" BIGINT,
  "facility_capacity" VARCHAR,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

Child Care Centers

@usgov.ca_gov_community_care_licensing_facilities.child_care_centers

1.45 MB
19,426 rows
17 columns

CREATE TABLE child_care_centers (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" BIGINT,
  "county_name" VARCHAR,
  "regional_office" BIGINT,
  "facility_capacity" BIGINT,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

Family Child Care Homes

@usgov.ca_gov_community_care_licensing_facilities.family_child_care_homes

1.34 MB
19,758 rows
17 columns

CREATE TABLE family_child_care_homes (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" BIGINT,
  "county_name" VARCHAR,
  "regional_office" BIGINT,
  "facility_capacity" BIGINT,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

Foster Family Agencies

@usgov.ca_gov_community_care_licensing_facilities.foster_family_agencies

73.51 kB
709 rows
17 columns

CREATE TABLE foster_family_agencies (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" BIGINT,
  "county_name" VARCHAR,
  "regional_office" DOUBLE,
  "facility_capacity" DOUBLE,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

Home Care Organization

@usgov.ca_gov_community_care_licensing_facilities.home_care_organization

333.62 kB
3,654 rows
17 columns

CREATE TABLE home_care_organization (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" BIGINT,
  "county_name" VARCHAR,
  "regional_office" BIGINT,
  "facility_capacity" DOUBLE,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

24-Hour Residential Care For Children

@usgov.ca_gov_community_care_licensing_facilities.n_24_hour_residential_care_for_children

125.67 kB
1,960 rows
17 columns

CREATE TABLE n_24_hour_residential_care_for_children (
  "facility_type" VARCHAR,
  "facility_number" DOUBLE,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" VARCHAR,
  "county_name" VARCHAR,
  "regional_office" DOUBLE,
  "facility_capacity" BIGINT,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);

Residential Care Facilities For The Elderly

@usgov.ca_gov_community_care_licensing_facilities.residential_care_facilities_for_the_elderly

1.04 MB
12,522 rows
17 columns

CREATE TABLE residential_care_facilities_for_the_elderly (
  "facility_type" VARCHAR,
  "facility_number" BIGINT,
  "facility_name" VARCHAR,
  "licensee" VARCHAR,
  "facility_administrator" VARCHAR,
  "facility_telephone_number" VARCHAR,
  "facility_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state" VARCHAR,
  "facility_zip" BIGINT,
  "county_name" VARCHAR,
  "regional_office" BIGINT,
  "facility_capacity" BIGINT,
  "facility_status" VARCHAR,
  "license_first_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "file_date" BIGINT
);