Early Childhood School Enrollment for Youth Ages 3-4 by ZIP Code

This dataset includes annual estimates of school enrollment for the population ages 3-4. Through its American Community Survey, the U.S. Census Bureau produces 5-year estimates for most geographies. The school enrollment estimates reports a percentage of the 3-4 age group who are enrolled in school (public or private) for the survey period. According to the Census Bureau, school for this age group is identified as nursery or preschool. Public schools are any school controlled and supported primarily by a local, county, state, or federal government. Private schools are defined as schools supported and controlled primarily by religious organizations or other private groups.

This dataset is for the Census bureau defined ZIP Code Tabulation Areas (ZCTA). Though roughly formed with the U.S. Postal Service’s ZIP Code areas as a guide, across the nation the ZCTAs do not always conform to the exact boundaries of ZIP Code areas. However, in St. Louis County the boundaries rarely differ.

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 \"impact-stlouisco/early-childhood-school-enrollment-for-youth-ages-stxz-74v4\".\"early_childhood_school_enrollment_for_youth_ages\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.