{"main_topic":"education","sub_topic":"gosa","topic":"postsecondary_c12","key":"education/gosa/postsecondary_c12","version":"1.0.0","year_min":2008,"year_max":2020,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/postsecondary_c12/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic"],"title":"Postsecondary Outcomes of HS Graduates (C12, Georgia)","summary":"How many Georgia public high school graduates enrolled in a Georgia college and earned a year of credit, by school, district, and demographic subgroup, 2008-2020 cohorts.","description":"GOSA Postsecondary C12 Report: three raw student counts per demographic subgroup along the high-school-graduate-to-postsecondary pipeline, for every Georgia public high school with official district and state rollups — high school graduates in the cohort year (num_graduates), graduates who enrolled in a Georgia postsecondary institution (num_enrolled_in_college), and graduates who earned at least 24 postsecondary credit hours (roughly one year of college) within two years of initial enrollment (num_earned_24_credits). IMPORTANT: unlike the sibling C11 report, which counts enrollment in institutions anywhere in the nation, C12 counts Georgia institutions only (verified: for the same 2016 cohort C11 reports 71,095 enrolled statewide vs C12's 57,468, while graduate counts agree), so C11 and C12 enrollment figures are NOT directly comparable. Covers HS graduating cohorts 2008-2020; no rates are published — derive college-going rate as num_enrolled_in_college / num_graduates and credit-earning rate as num_earned_24_credits / num_graduates at query time.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/postsecondary_c12","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"HS graduating cohort year (ending calendar year of the school year; 2020 means the class of 2019-20), parsed from the source's School Year column and cross-checked against the filename (publication year = cohort year + 4). Never the publication year.","valid_values":null,"example":2020,"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 code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows.","valid_values":null,"example":"601","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"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). The 2015-2019 source files strip leading zeros; the transform restores them. NULL on district- and state-level rows.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"Student subgroup the row covers (race, gender, economic, or special-population); 'all' is the cohort total. Race uses the split asian / pacific_islander convention.","description":"Demographic subgroup (FK to the global demographics dimension). Race uses the SPLIT convention: asian and pacific_islander are separate buckets (the source publishes a distinct Pacific Islander group from cohort 2009 onward, and at the state level the seven race buckets sum exactly to the all-students total in most years), never the combined asian_pacific_islander rollup. pacific_islander rows are absent (not NULL) in year=2008 — the 2012 source file does not carry the group. 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic status, special population).","valid_values":["all","asian","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","pacific_islander","students_with_disabilities","white"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_graduates","type":"integer","role":"metric","nullable":true,"label":"Number Graduates","short_description":"","description":"Number of students in the demographic subgroup who graduated from high school in the cohort year. Published values are always >= 10 (GOSA suppresses smaller cells as TFS). The denominator for both derived rates.","valid_values":null,"example":140,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA: counts below 10 are published as the literal TFS (Too Few Students).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_enrolled_in_college","type":"integer","role":"metric","nullable":true,"label":"Number Enrolled in College","short_description":"Count of the cohort's graduates who enrolled in a Georgia college; divide by num_graduates for the in-state college-going rate (Georgia institutions only).","description":"Number of those graduates who enrolled in a postsecondary institution located in Georgia (public or private, 2-year or 4-year). Georgia institutions ONLY — the sibling C11 report counts enrollment anywhere in the nation, so C11 and C12 enrollment figures are not comparable. Never exceeds num_graduates where both are published (enforced by a quality check).","valid_values":null,"example":96,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA: counts below 10 are published as the literal TFS (Too Few Students).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_earned_24_credits","type":"integer","role":"metric","nullable":true,"label":"Number Earned 24 Credits","short_description":"","description":"Number of those graduates who accumulated at least 24 credit hours of postsecondary coursework — roughly one year of college instruction — within two years of initial enrollment; a persistence / college-readiness signal. Never exceeds num_enrolled_in_college or num_graduates where both are published (enforced by quality checks).","valid_values":null,"example":58,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA: counts below 10 are published as the literal TFS (Too Few Students).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_enrolled_in_college","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code; the demographics dimension on demographic. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero): GOSA publishes counts below 10 as TFS, so sparse subgroups (pacific_islander, native_american, migrant) are almost universally suppressed at school level, and summing only published school rows undercounts true totals — use district or state rows for official aggregates (a district total is NOT the sum of its published school rows). num_enrolled_in_college counts enrollment in GEORGIA institutions only; it is not comparable to the C11 report's nationwide enrollment count. pacific_islander rows are absent in year=2008. State rows have NULL district_code and school_code; district rows have NULL school_code.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020],"schema_hash":"afe2abc74f9ed5efae21d79e7d6fe5443c7cde363ede99c1633b95483a81971b","tags":["education","gosa","postsecondary_c12"],"granularity_description":"One row per year, district_code, school_code, demographic (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2020), schools detail","query":"SELECT * FROM postsecondary_c12 WHERE year = 2020 LIMIT 100"},{"description":"District 601 in 2020","query":"SELECT * FROM postsecondary_c12 WHERE district_code = '601' AND year = 2020 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"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"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":["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":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","asian","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","pacific_islander","students_with_disabilities","white"]},{"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"]},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[]}