{"main_topic":"education","sub_topic":"gosa","topic":"direct_certification","key":"education/gosa/direct_certification","version":"1.0.0","year_min":2014,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/direct_certification/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"Direct Certification for Free School Meals","summary":"Share of K-12 students automatically eligible for free school meals via SNAP/TANF and other programs, by Georgia school, district, and state, 2014-2024.","description":"Share of K-12 students directly certified for free school meals across Georgia public schools and districts, published by GOSA for fiscal years 2014-2024 (FY2024 = the 2023-24 school year). Direct certification is the automatic, categorical-eligibility subset of free/reduced-price meal eligibility — a student is directly certified because their household participates in SNAP or TANF, the student is homeless, unaccompanied youth, foster, or migrant, or (from FY2024) the household's Medicaid income is at or below the free/reduced-price-lunch standard — with no household application required. One fact table at three detail levels: school (one row per school), district (one row per district / system, including charters, state agencies, and State Schools), and state (the statewide 'State of Georgia' aggregate, published 2022-2024 only). From FY2020 the underlying numerator and denominator counts are also published. Merges the formerly separate direct_certification_school and direct_certification_district topics.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/direct_certification","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Georgia fiscal year, equal to the ending (spring) calendar year of the school year (FY2024 = 2023-24). Read from the in-file FISCAL_YEAR column (SCHOOL_YEAR in the 2014 files) and cross-checked against the filename year in both download families.","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":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","description":"GOSA district/system code (FK to districts dimension), zero-padded to 3 digits; 7-digit charter and State-School codes and 3-digit state-agency codes are preserved unchanged. NULL on the statewide aggregate rows. Beyond the ~180 standard county/city districts the series includes 799 (combined State Schools, 2020+), 890 (Dept. of Corrections, 2019 only), 891 (Dept. of Juvenile Justice, 2017+), 7991893-7991895 (individual State Schools, 2014-2019; superseded by the combined 799 row from 2020), and 782xxxx/783xxxx state and commission charter schools.","valid_values":null,"example":"601","unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL only on the statewide aggregate (state) rows (2022-2024); populated on every school and district row.","key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","description":"GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). Populated on school rows only — district and state aggregate rows carry NULL. The 2014-2016 CSVs publish the padded form natively; the 2017-2024 .xls files publish unpadded 3/4-digit codes that are zero-filled to match.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":"Populated only on school-detail rows; NULL on every district-detail and state-detail row (those levels have no school code). The column is shared across the education key shape.","key_metric_grain_contributor":false,"metric_component":null},{"name":"direct_cert_rate","type":"number","role":"metric","nullable":true,"label":"Direct Cert Rate","short_description":"Share of K-12 students automatically eligible for free meals (via SNAP/TANF, foster, homeless, migrant, or Medicaid), on a 0-1 scale.","description":"Share of K-12 students directly certified for free school meals, on the 0-1 scale (0.69 = 69%). Bronze publishes 0-100 (integer percent in 2014-2016, one-decimal float thereafter); divided by 100 per data-cleaning-standards §4 and rounded to 3 decimals to strip .xls binary-float artifacts (82.400002 -> 0.824). Bounded — never exceeds 1.0 in any year. Never NULL (the source has no suppression). Where the FY2020+ counts exist, the rate reconciles with num_direct_cert_students / num_k12_students to within one-decimal-percent rounding (max observed deviation 0.0005). Two methodology breaks: FY2017 excludes foster students (FY2018+ re-includes them), and FY2024 adds the Medicaid (DC-M) category — comparisons crossing 2016->2017, 2017->2018, or 2023->2024 are not apples-to-apples.","valid_values":null,"example":0.69,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_direct_cert_students","type":"integer","role":"metric","nullable":true,"label":"Number Direct Cert Students","short_description":"","description":"Headcount of K-12 students directly certified — the numerator of direct_cert_rate (bronze K12_POVERTY_STUDENT_CT). Published FY2020 onward only; NULL for 2014-2019. Always at most num_k12_students (enforced by a quality check).","valid_values":null,"example":2233,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL for FY2014-FY2019: the source did not publish the underlying counts before FY2020. Populated for every row (all detail levels) from 2020 on. NOT suppression.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_k12_students","type":"integer","role":"metric","nullable":true,"label":"Number K12 Students","short_description":"","description":"Total K-12 enrollment used as the denominator of direct_cert_rate (the NSLP K-12 enrollment base — not the October/March FTE enrollment published by the enrollment topics; bronze K12_STUDENT_COUNT). Published FY2020 onward only; NULL for 2014-2019. Strictly positive where present (enforced by a quality check).","valid_values":null,"example":3238,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL for FY2014-FY2019: the source did not publish the underlying counts before FY2020. Populated for every row (all detail levels) from 2020 on. NOT suppression.","key_metric_grain_contributor":false,"metric_component":"denominator"}],"key_metric":"direct_cert_rate","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","limitations":"Three detail levels (school, district, state) in one fact table, split by parquet filename; school_code is NULL on district/state rows and district_code is NULL on state rows. The statewide aggregate exists only for 2022-2024; earlier years publish no state row and pre-2020 years lack the counts needed to reconstruct one. The underlying counts (num_direct_cert_students, num_k12_students) are published only from FY2020 and are NULL before that. School-level rows and district-level rows come from two independent GOSA downloads whose K-12 bases need not reconcile exactly, so school rows are NOT guaranteed to sum to their district row. Two methodology breaks limit year-over-year comparison: FY2017 rates EXCLUDE foster students (FY2018+ include them), and FY2024 adds the Medicaid DC-M category, roughly doubling certified counts — comparisons crossing 2016->2017, 2017->2018, or 2023->2024 are not apples-to-apples. The State Schools representation changes across eras: three individual 7-digit rows (7991893-7991895) through 2019, one combined 799 row from 2020. No suppression exists in this topic — NULL never means suppressed.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"335e0faaae4e3eedca087da3c4a83fcc6a87ca2038581d1be65f7d453782ce4b","tags":["education","gosa","direct_certification"],"granularity_description":"One row per year, district_code, school_code (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM direct_certification WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM direct_certification WHERE district_code = '601' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"}],"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":["districts","schools","states"],"default":"schools"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":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":[]}