CUSP DATA MODEL

Child Universal Success Platform (CUSP) ingests, consolidates, integrates, and processes data on children, providers, and funding programs from disparate data sources to produce a single holistic view of the entire early childhood landscape in the state.  

Child Population

A geo-referenced child-level dataset of all children in a state, including child age, household income, household employment status, and address.

Eligible Children

A geo-referenced child-level dataset of all children eligible for key funding programs available in the state (e.g., state subsidy, Head Start/Early Head Start, public PreK, etc.). 

Served Children

A geo-referenced child-level dataset of all children who are served by early childhood providers and child care funding programs. 

Provider Base

A geo-referenced provider-level table of all early childhood providers and programs in the state, deduplicated by location and funding program, and organized by key characteristics such as provider type, capacity, quality rating (if available), etc. 

Geographic Location

All children and providers are geo-coded to addresses within the state. This allows for children and providers to be mapped in various ways, e.g., by census tract, ZCTA, town, county, legislative district, school district, etc. 

GET DATA 

Need data directly from CUSP?  Here is a list of frequently requested data queries. Copy the query to your clipboard using ‘Copy’ button and paste it in your query editor. Run the query and get results in the form of output tables. 

Need the query modified?  Modify it directly in the query editor and run it.

Don’t see what you need on the list?  Go directly to the database and write your own query or, ask 3Si and we will get you the data you need.

POPULATION

What is the population of children aged 0 to 13 in every county in the state? 

Get Snippet

Providers

List all active child care learning centers in the state, by county. 

Get Snippet

List all active family child care homes in the state, by county. 

Get Snippet

List all active licensed providers in the state, by county. 

Get Snippet

Service

How many children in each county are served by state subsidy (CCDF)?

Get Snippet

How many children in each county are served by public Pre-K?

Get Snippet

GAPS

List the top 10 counties with the highest service gaps in the state (population of children who potentially need child care services minus the number of children who utilize child care services)

Get Snippet

extreme access deserts

List all the ZCTAs in the state that have consistently remained extreme subsidized access deserts in the last 12 months, with the quality restriction applied.

Get Snippet

List all the ZCTAs in the state that have consistently remained extreme subsidized access deserts in the last 12 months, without the quality restriction applied.

Get Snippet

List all the ZCTAs in the state that are currently extreme subsidized access deserts.

Get Snippet

List all the ZCTAs in the state that have consistently remained extreme subsidized access deserts in the last 12 months.

Get Snippet
Click here to see the documentation on the CUSP Data Model
Scroll to Top

To use the snippet; select the code below and copy and paste into your desired area.

				
					select
township
, count (c.child_uid) as child_ct
, count(distinct case when INCOME_BRACKET IN('under_100_perc_fpl','100_perc_fpl_50_perc_smi','50_85_perc_smi')
and UNEMPLOYMENT_CODE=0 then child_uid else null end) as eligible_subsidy
, eligible_subsidy / child_ct as percent_eligble
  from "EEC_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "EEC_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "EEC_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township