{"main_topic":"census","sub_topic":"acs","topic":"school_enrollment","key":"census/acs/school_enrollment","version":"1.0.0","year_min":2020,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","districts","states","tracts"],"default_detail":"counties","path_template":"census/school_enrollment/year={year}/{detail}.parquet","grain":["year","county_fips","district_code","tract_geoid","school_type"],"title":"School Enrollment of Children (ACS)","summary":"Where each Georgia community's school-age children (3-17) go to school - public, private, or not enrolled - American Community Survey 5-year shares down to the census-tract level.","description":"School enrollment of school-age children (ages 3-17) from the American Community Survey 5-year estimates (detailed table B14003), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024: the share of children enrolled in public school, private school, or not enrolled, with the underlying counts and margins of error.","source":"U.S. Census Bureau, American Community Survey 5-Year Estimates","source_url":"https://data.census.gov/table/ACSDT5Y2024.B14003?g=040XX00US13","endpoint":"/api/v1/census/school_enrollment","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code (state 13 + county). Populated only on county-level rows.","valid_values":null,"example":"13121","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","description":"GCD school district code (FK to the education districts dimension). Populated only on district-level rows - Census unified-school-district estimates mapped onto the ~180 standard districts.","valid_values":null,"example":"660","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows.","valid_values":null,"example":"13121011100","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_type","type":"string","role":"categorical","nullable":false,"label":"School Type","short_description":"","description":"Enrollment status of school-age children (3-17): enrolled in public school, enrolled in private school, or not enrolled. The Census type split covers nursery school through college, not K-12 specifically. The three types partition the school-age population.","valid_values":["not_enrolled","private","public"],"example":"public","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"pct_of_school_age_population","type":"number","role":"metric","nullable":true,"label":"Percent of School Age Population","short_description":"Share of school-age children in this enrollment type.","description":"Children aged 3-17 in this school_type as a share of the school-age population (0-1), derived as num_in_school_type / num_school_age_population. NULL when the geography has no school-age children.","valid_values":null,"example":0.773,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_of_school_age_population_moe","type":"number","role":"metric","nullable":true,"label":"Percent of School Age Population Moe","short_description":"","description":"90 percent margin of error for pct_of_school_age_population, derived from the two aggregated count margins (each built under the Census zero-estimate rule) with the Census proportion-MOE formula, falling back to the ratio-form (addition) formula whenever the radicand is not positive; a margin above 1.0 is NULLed. When a geography's entire school-age population sits in one school_type (share exactly 1.0; 418 tract rows in 2020-2024), the numerator and denominator margins coincide, the proportion formula degenerates, and the served margin is the ratio-form fallback sqrt(2) * MOE / N (246 rows, median 0.61) or NULL where that exceeds 1.0 (172 rows). The same geography's sibling rows (0 of N children) serve the complement's margin - the largest zero-cell margin over N, typically 14 / N (median 0.054) - which bounds the same quantity more tightly because MOE(p) = MOE(1 - p); prefer the sibling rows' margins for those geographies. Never the headline metric.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"No margin derivable: a component margin was masked, the school-age population is zero, or the derived margin exceeded 1.0 - a 90 percent half-width wider than the whole 0-1 scale, which occurs in very small cells whose aggregated count margins (already under the Census zero-estimate rule) dwarf the counts. Most such NULLs (172 of the 220 masked rows in 2020-2024) are tract rows whose share is exactly 1.0, where the ratio-form fallback sqrt(2) * MOE / N exceeds 1.0 for 6-730 children; the geography's sibling rows (0 of N children) still serve the complement's margin, which bounds the same quantity - use it for the 1.0 row.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_in_school_type","type":"integer","role":"metric","nullable":true,"label":"Number in School Type","short_description":"","description":"Children aged 3-17 in this school_type (sum of the pinned B14003 sex x age cells) - the share's numerator.","valid_values":null,"example":1678235,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_in_school_type_moe","type":"number","role":"metric","nullable":true,"label":"Number in School Type Moe","short_description":"","description":"90 percent margin of error for num_in_school_type: sqrt-sum-of-squares over the member cells' published margins under the Census zero-estimate rule (of the member cells whose estimate is zero, only the largest margin enters the sum).","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"A member-cell margin was masked (annotation sentinel), so no aggregate margin is derivable.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_school_age_population","type":"integer","role":"metric","nullable":true,"label":"Number School Age Population","short_description":"","description":"Children aged 3-17 (sum of all 24 pinned B14003 cells; the table publishes no 3-17 total) - the share's denominator, repeated on each school_type row.","valid_values":null,"example":2170967,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_school_age_population_moe","type":"number","role":"metric","nullable":true,"label":"Number School Age Population Moe","short_description":"","description":"90 percent margin of error for num_school_age_population: sqrt-sum-of-squares approximation over all 24 member cells under the Census zero-estimate rule (of the member cells whose estimate is zero, only the largest margin enters the sum).","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"A member-cell margin was masked (annotation sentinel), so no aggregate margin is derivable.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"pct_of_school_age_population","usage":"Star-schema fact table. Join the districts dimension on district_code; the counties dimension on county_fips; the tracts dimension on tract_geoid. Read directly with DuckDB over Parquet.","limitations":"Universe: SCHOOL-AGE children (ages 3-17) by deliberate scoping - the source table covers population 3+, where adult non-enrollment would dominate the not_enrolled share. The public/private split is the Census school-type split (nursery through college), not K-12 enrollment specifically: a 16-year-old enrolled in college counts in public or private per their institution. not_enrolled is concentrated among 3-4-year-olds (pre-K non-attendance). The school-age denominator and its margin are derived by aggregating the 24 source cells (the table publishes no 3-17 total), so the count margins are sqrt-sum-of-squares approximations applying the Census zero-estimate rule (of the member cells whose estimate is zero, only the largest margin enters the sum); share margins use the Census proportion-MOE formula (ratio-form fallback when the radicand is not positive), and a margin above 1.0 is NULLed. ACS 5-year period estimates: the year column is the vintage END year and each estimate pools five years of survey responses (2024 = 2020-2024). Consecutive vintages share about 80% of their sample, so the series is heavily smoothed - never difference overlapping vintages as if they were annual change. Estimates are survey-based and carry 90% margins of error (the *_moe columns); tract-level margins can be large relative to the estimate. All levels serve vintages 2020-2024 only, on 2020-vintage tract boundaries. State rows have NULL county_fips, district_code, and tract_geoid; county rows carry only county_fips, district rows only district_code, tract rows only tract_geoid. District rows cover the ~180 standard (city/county) districts only: the Census publishes school-district estimates at unified school district geography, which has no codes for charter schools, RESAs, or state agencies, and its few Census-only districts (e.g. the Fort Stewart military district) have no GCD district code and are dropped.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2020,2021,2022,2023,2024],"schema_hash":"f3fe93a3fe9738ca2caba7c6838087a0123ddc9854873373b71b3b03a16586ef","tags":["census","u.s. census bureau, american community survey 5-year estimates","school_enrollment"],"granularity_description":"One row per year, county_fips, district_code, tract_geoid, school_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM school_enrollment WHERE year = 2024 LIMIT 100"},{"description":"District 660 in 2024","query":"SELECT * FROM school_enrollment WHERE district_code = '660' AND year = 2024 LIMIT 100"},{"description":"Filter by school_type = public","query":"SELECT * FROM school_enrollment WHERE school_type = 'public' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","districts","states","tracts"],"default":"counties"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_type","kind":"categorical","column":"school_type","type":"string","multi_value":true,"enum_enforced":true,"values":["not_enrolled","private","public"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[],"values_endpoint":"/api/v1/census/school_enrollment/values"}