"pa-gov/child-care-providers-including-early-learning-ajn5-kaxt:latest"."child_care_providers_including_early_learning"

SELECT
    ":id", -- Socrata column ID
    "capacity", -- The maximum number of children permitted to receive care in a child care facility at one time based on square footage of child care space and age of the children. School Age Provider identifies school-age programs located in a school building; physical site requirements do not apply for these providers. Note: this information is only available for certified providers.
    "mpi_id", -- Master Provider Index Numbers are used across the Department of Human Services to identify providers and service locations that participate in any of their programs. As such, they are used in PELICAN as a common identifier for all OCDEL programs, including Child Care Licensing, Early Intervention, PA Pre-K Counts, Head Start Supplemental and Keystone STARS.
    "subsidy_sa", -- Indicates if this facility has subsidy children enrolled with the following care levels: Young School-Age or Older School-Age.
    "subsidy_agreement", -- Indicates if this regulated child care facility has an agreement with the regional eligibility agency and receive payment for providing care to children who participate in the subsidized child care program.
    "subsidy_ps", -- Indicates if this facility has subsidy children enrolled with the following care level: Preschool.
    "pa_house_district", -- The Pennsylvania house district associated with the physical address of the facility where child care and other early learning services are provided.
    "family_support_program", -- Indicates if this facility provides a Family Support program at this location. OCDEL provides voluntary, evidence-based home visiting and community-based programs that help parents improve their parenting skills, resulting in healthier pregnancies and improved child health, learning, development, and well-being. These services are provided through a combination of state funds, the federal Title IV-B - Family Center funds and the federal Maternal, Infant, and Early Childhood Home Visiting grant program.
    "federal_early_head_start", -- Indicates if this facility provides a Federal Early Head Start (Federal EHS) program at this location. Federal EHS programs provide family-centered services for low-income families with very young children (infants and toddlers). These programs are designed to promote the development of the children and to enable their parents to fulfill their roles as parents and to move toward self-sufficiency.
    "school_district_vo_tech_pre_k", -- Indicates if this facility provides a School District or Vo Tec Pre-K program at this location. Programming is determined locally and can serve 3–4-year-old, at-risk children.
    ":@computed_region_nmsq_hqvv",
    "license_number", -- Reference Number for the current Certificate of Compliance on record for the regulated child care facilities. The Certificate of Compliance is a document issued by the Department of Human Services to a legal entity permitting the entity to operate a specific type of facility at a specific location for a specific time according to applicable Department regulations. Note: this information is only available for certified providers.
    "license_issue_date", -- The date the Certificate of Compliance was issued to the legal entity. Note: this information is only available for certified providers.
    "legal_entity_county", -- The county of the legal entity.
    "license_exp_date", -- The date the Certificate of Compliance expires. Note: this information is only available for certified providers.
    "legal_entity_zip_code", -- The zip code of the legal entity.
    "legal_entity_state_fips_code", -- These are the first 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html
    "legal_entity_state", -- The state of the legal entity.
    "legal_entity_city", -- The city of the legal entity.
    "facility_address", -- The street address for the physical location where child care and other early learning services are provided.
    "facility_address_continued", -- The street address for the physical location where child care and other early learning services are provided.
    "responsible_person_title", -- The Responsible Person's role within the facility. Note: this information is only available for certified providers.
    "legal_entity_county_fips", -- The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. This is the 3-digit part of the 5-digit county FIPS code specifically standing for the county associated with the legal entity.
    "legal_entity_address_continued", -- The physical address of the legal entity.
    "head_start_state_supplemental", -- Indicates if this facility provides a Head Start Supplemental Assistance Program (HSSAP) at this location. HSSAP is intended to reach low-income families with children ages 3 years to kindergarten who are at-risk for educational disadvantage.
    "pa_pre_k_counts", -- Indicates if this facility provides a PA Pre-K Counts (PA PKC) program at this location. PA PKC is a state-funded pre-kindergarten program intended to reach children ages three and four who are at risk of academic failure due to income, language, cultural, or special needs.
    "geocoded_column_1", -- Georeferenced column for use in creating mapping visualizations with both latitude and longitude based on the Legal Entity address.
    "facility_city", -- The city for the physical location where child care and other early learning services are provided.
    "subsidy_it", -- Indicates if this facility has subsidy children enrolled with the following care levels: Infant, Young Toddler, or Older Toddler.
    "master_provider_index", -- MPI ID and MPI Location ID combined to create the unique MPI for each location in the list.
    "negative_sanctions", -- Indicates if a negative sanction was issued at this location at any time during the location’s licensure. The negative sanction may be resolved and no longer active. A negative sanction means the Department has taken action to deny, refuse to renew, revoke, or downgrade a license to operate a child care program due to noncompliance with child care requirements. In the case of an unlicensed, illegal operation of a child care program, the Department orders the operator to cease and desist. Note: this information is only available for certified providers.
    "elrc", -- The Early Learning Resource Center under which the Facility County is assigned. Pennsylvania's Early Learning Resource Centers (ELRCs) provide a single point-of-contact for families, early learning service providers, and communities to gain information and access services that support high-quality child care and early learning programs.
    "facility_name", -- The name of the facility where child care and other early learning services are provided.
    "facility_state_fips_code", -- These are the first 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association of the Facility. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details: Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31, provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html
    "star_level_effective_date", -- The most recent effective begin date for the STAR Level.
    "responsible_person_last_name", -- The last name of the individual responsible for compliance with regulations. Note: this information is only available for certified providers.
    "responsible_person_first", -- The first name of the individual responsible for compliance with regulations. Note: this information is only available for certified providers.
    "facility_county", -- The county for the physical location where child care and other early learning services are provided.
    "facility_email", -- The email address for the physical location where child care and other early learning services are provided.
    "geocoded_column", -- Georeferenced column for use in creating mapping visualizations with both latitude and longitude based on the Facility address.
    "facility_fax", -- The fax number for the physical location where child care and other early learning services are provided.
    "facility_phone", -- The phone number for the physical location where child care and other early learning services are provided.
    "facility_county_fips_code", -- The FIPS county code is a five-digit Federal Information Processing Standard (FIPS) code (FIPS 6-4) which uniquely identifies counties and county equivalents in the United States, certain U.S. possessions, and certain freely associated states. This is the 3-digit part of the 5-digit county FIPS code specifically standing for the county associated with the facility.
    "facility_zip_code", -- The zip code for the physical location where child care and other early learning services are provided.
    "provider_type", -- Child Care Center: A child care facility in which 7 or more children who are not related to the operator receive child care, Group Child Care Home: A child care facility in which 7 to 12 children of various ages or in which 7 to 15 children from 4th grade through 15 years of age who are not related to the operator receive child care, Family Child Care Home: A child care facility located in a home in which 4 to 6 children who are not related to the caregiver receive child care, Other: Early learning programs that are not regulated child care locations; may include private academic schools, family support programs, federal Early Head Start programs, federal Head Start programs, and school district/vocational-technical programs.
    "mpi_location_id", -- Master Provider Index Numbers are used across the Department of Human Services to identify providers and service locations that participate in any of their programs. As such, they are used in PELICAN as a common identifier for all OCDEL programs, including Child Care Licensing, Early Intervention, PA Pre-K Counts, Head Start Supplemental and Keystone STARS.
    "private_academic_school_", -- Indicates if this facility provides a Licensed Private Academic School (PAS) program at this location. PAS are licensed and regulated by the State Board of Private Academic Schools, whose rules, regulations, and standards are concerned with quality education, teacher certification, attendance and courses of study, which closely parallel public-school requirements. These schools are primarily nonsectarian.
    "federal_head_start", -- Indicates if this facility provides a Federal Head Start (Federal HS) program at this location. Federal HS is a federal program that promotes the school readiness of children ages birth to five from low-income families by enhancing their cognitive, social, and emotional development.
    "school_age_provider", -- Indicates whether or not this facility is known to provide child care for School Age children. NOTE: This is not an inclusive indicator, such that the facility listed as "No" may provide child care for School Age children, but it is not known to OCDEL.
    "facility_state", -- The state for the physical location where child care services are provided.
    ":@computed_region_amqz_jbr4",
    "star_level", -- Performance Standards for the Keystone STARS initiative designed to improve, support, and recognize the continuous quality improvement efforts of early learning programs in Pennsylvania. The Performance Standards are grouped into four levels: STAR 1, STAR 2, STAR 3, and STAR 4. Each level builds on the previous level and utilizes research-based best practices to promote quality early learning environments and positive child outcomes. The standards address staff qualifications and professional development, the early learning program, partnerships with family and community, and leadership and management.
    "legal_entity_name", -- An individual, partnership, association, organization, or corporation responsible for the operation of a child care facility or location or other early learning program.
    "legal_entity_address", -- The physical address of the legal entity.
    "school_district", -- The school district associated with the physical address of the facility where child care and other early learning services are provided.
    "pa_senate_district" -- The Pennsylvania senate district associated with the physical address of the facility where child care and other early learning services are provided.
FROM
    "pa-gov/child-care-providers-including-early-learning-ajn5-kaxt:latest"."child_care_providers_including_early_learning"
LIMIT 100;

sgr clone pa-gov/child-care-providers-including-early-learning-ajn5-kaxt

sgr checkout pa-gov/child-care-providers-including-early-learning-ajn5-kaxt:latest

sgr checkout --layered pa-gov/child-care-providers-including-early-learning-ajn5-kaxt:latest