colorado-gov/colorado-licensed-child-care-facilities-report-a9rr-k8mu
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

Colorado Licensed Child Care Facilities Report

This dataset includes all non-24 hour licensed child care facilities in the State of Colorado. It is updated monthly, and is intended for public use. It includes CDEC-issued child care license numbers, legal business names as they appear in the licensing application, the types of service the programs provide, the physical location addresses of the programs as they appear in the licensing application, the longitude-latitude coordinate values derived from geocoding services and spatial QA, the valid Colorado Shines quality rating levels (if applicable), total licensed capacities, and CCCAP utilization and fiscal agreement.

Note: As of Jan 1, 2021, the following fields are temporarily unavailable in this release: CCCAP CHILD COUNT_D1, CCCAP CASE COUNT_D1, and CCCAP_AMOUNT_PAID_D1. These columns will be included again in the near future. Please contact the dataset owner for more information as necessary.

Disclaimer: The State of Colorado, the Colorado Department of Human Services, and the Office of Early Childhood make no representations or warranties expressed or implied, with respect to the use of data provided herewith regardless of its format or the means of its transmission. There is no guarantee or representation to the user as to the accuracy, currency, suitability, or reliability of this data for any purpose. The user accepts the data “as is”. The State of Colorado assumes no responsibility for loss or damage incurred as a result of any user reliance on this data.

Users of this information should review or consult the primary data and information sources to ascertain the usability of the information. The State of Colorado does not necessarily endorse any interpretations or products derived from the data.

No longer in use columns as of 7/1/2022:

CCCAP CHILD COUNT_D1: the number of children utilizing CCCAP at least once during the month reflects most current data available; two months prior to the date of this report or D1

CCCAP CASE COUNT_D1: the number of cases (or families) with at lease one child utilizing CCCAP at least once during the month reflects most current data available; two months prior to the date of this report or D1

CCCAP FA EXP DATE_D1: CCCAP fiscal agreement expiration date across any associated county reflects data two months prior to the date of this report or D1

CCCAP TOTAL AUTH_D1: the total number of CCCAP authorizations for all fiscal agreements reflects data two months prior to the date of this report or D1

CCCAP FA EXP DATE_D2: the latest CCCAP fiscal agreement expiration date across any associated county reflects most current data available; through the previous two weeks prior from the date of this report or D2

CCCAP TOTAL AUTH_D2: the total number of CCCAP authorizations for all fiscal agreements reflects most current data available; through the previous two weeks prior from the date of this report or D2

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/colorado-licensed-child-care-facilities-report-a9rr-k8mu\".\"colorado_licensed_child_care_facilities_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • colorado_licensed_child_care_facilities_report
     
     
     
     
     
Upstream Metadata