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?

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

providers

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

SERVICE

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

How many children in each county are served by public PreK?

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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)

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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.

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

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

				
					select 
township 
, count (c.child_uid) as child_ct
  from "DEMO_ANALYTICS_PROD"."OUTPUT"."BOUNDARIES" b
  left join "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN" c
    on c.child_address_uid = b.address_uid
where c.load_dt = (SELECT MAX(load_dt) FROM "DEMO_ANALYTICS_PROD"."OUTPUT"."CHILDREN")
and b.BOUNDARY_YR = 2021
and age_group != 'School Age'
group by township
order by township

CUSP DATA MODEL

POPULATION​