Code for Pulling & Aggregating Public Population Data

This customizable code template helps pull and aggregate relevant, publicly available population-level data (e.g., American Community Survey data, birth records, licensed capacity, enrollment data) that can be cross-walked across different geographic areas of analysis (e.g., zip code, ZCTA, county)—to help identify and map childcare supply and demand in different contexts.

Note: This tool, a resource informed by an SDP Fellow at the California Department of Education, does not contain real data.                    

This tool is part of Preschool Supply & Demand, a collaboration between the Strategic Data Project and representatives from the California Department of Education, Denver Public Schools, Denver Preschool Program, South Carolina First Steps, Chicago Early Childhood Integrated Data System, National Head Start Association, Massachusetts Department of Early Education and Care, and Washington Education Research and Data Center. It is supported by the Gates Foundation.