About this Dataset

DCYF Licensed Childcare Center And School Age Program Providers

The DCYF Licensed Childcare Provider data set is comprised of license and facility information for active childcare provider licenses at the point in time the data is extracted.
Organization: State of Washington
Last updated: 2024-01-12T14:14:21.274245
Tags: child-care, childcare, early-learning, licensed-child-care, licensed-child-care-provider, providers

Tables

Table 1

@usgov.state_of_washington_dcyf_licensed_childcare_center_and_0e37d055.table_1

406.07 kB
2,452 rows
34 columns

CREATE TABLE table_1 (
  "wacompassid" VARCHAR,
  "famlinkid" BIGINT,
  "sspsprovidernumber" DOUBLE,
  "providername" VARCHAR,
  "doingbusinessas" VARCHAR,
  "facilitytypegeneric" VARCHAR,
  "facilitytypeauthoritydesc" VARCHAR,
  "latestoperatingstatus" VARCHAR,
  "licensecertificatetypedesc" VARCHAR,
  "initiallicensedate" TIMESTAMP,
  "latestlicensestartdate" TIMESTAMP,
  "licenseexpirationdate" TIMESTAMP,
  "licensecapacity" BIGINT,
  "startingage" VARCHAR,
  "endingage" VARCHAR,
  "primarycontactpersonname" VARCHAR,
  "primarycontactphonenumber" VARCHAR,
  "primarycontactemail" VARCHAR,
  "physciallatitude" DOUBLE,
  "physicallongitude" DOUBLE,
  "geocodedphysicaladdress" VARCHAR,
  "physicalstreetaddress" VARCHAR,
  "physicalcity" VARCHAR,
  "physicalstate" VARCHAR,
  "physicalzip" BIGINT,
  "physicalcounty" VARCHAR,
  "primarylicensor" VARCHAR,
  "providershippingaddress" VARCHAR,
  "providershippingcity" VARCHAR,
  "shippingzip" DOUBLE,
  "providershippingstate" VARCHAR,
  "region" VARCHAR,
  "eaparticipation" VARCHAR,
  "earating" VARCHAR
);