{"main_topic":"education","sub_topic":"gosa","topic":"act_scores","key":"education/gosa/act_scores","version":"1.0.0","year_min":2004,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/act_scores/year={year}/{detail}.parquet","grain":["year","district_code","school_code","test_component"],"title":"ACT College Readiness Test Scores","summary":"Average ACT college-admissions test scores and number of students tested, by Georgia school, district, and ACT section, 2004-2024.","description":"Average ACT scaled scores (1-36) and number of students tested for Georgia public schools, with official district and state rollups, by ACT test component. Covers graduating-class ACT results published by GOSA from 2004 through 2024.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/act_scores","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Reporting year. For 2011-2024 this is the spring (ending) calendar year of the school year in the source's LONG_SCHOOL_YEAR; for 2004-2010 the source carries no year column and the filename publication year is used.","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 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). 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":"test_component","type":"string","role":"categorical","nullable":false,"label":"Test Component","short_description":"Which ACT section the score covers: composite (overall), english, mathematics, reading, science, or writing.","description":"ACT section. composite, english, mathematics, reading, and science are reported in all years (2004-2010 label science as 'Science Reasoning'); writing_subscore appears from 2011 onward; combined_english_writing only in 2011-2015 (students who took both English and the optional Writing section).","valid_values":["combined_english_writing","composite","english","mathematics","reading","science","writing_subscore"],"example":"composite","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_tested","type":"integer","role":"metric","nullable":true,"label":"Number Tested","short_description":"","description":"Number of students tested. 2004-2010 sources publish one count per school/district/state entity, which is repeated on each of that entity's five test_component rows; 2011-2024 sources publish true per-component counts. In either case, summing num_tested across test_component double-counts students — filter to one component (typically composite) for headcounts.","valid_values":null,"example":24,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (too few students to report; TFS marker in 2011-2024 sources).","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"avg_score","type":"number","role":"metric","nullable":true,"label":"Average Score","short_description":"Average ACT scaled score on the 1-36 scale (writing subscore uses a 2-12 scale, except 2016); higher is better.","description":"Average ACT scaled score. The 1-36 ACT scale applies to every test_component except writing_subscore, which the source reports on the ACT writing domain 2-12 scale (typical statewide averages 6-7) in every year EXCEPT 2016: ACT's September 2015-June 2016 'enhanced writing' window reported writing on a 1-36 scale, so 2016 writing_subscore values run 11.8-23.1 (mean ~17.2) vs 4.2-8.5 in all other years — do not read 2016 as a writing-performance jump in time series. The [1, 36] range check below bounds all components and years. NULL when GOSA suppressed the value (too few test-takers). Known source defects NULLed by the transform per data-cleaning-standards §4b (rows and num_tested preserved): (a) the 2006 publication reported 10 impossible values of 36.9-41.5 (above the ACT scale maximum of 36) across the five sections for Campbell High School (district 633, school 1054) and Cedar Grove High School (district 644, school 0172) — any avg_score outside [1, 36] is NULLed; (b) the 2009 Atlanta City district rows (district 761) published scores of 34.2-35.5 while the district's own school rows bound every section at or below 17.7 — the five district avg_score values are NULLed (num_tested 949 is consistent with the school rows and preserved). This revises the preserve-bronze default for this column; the 1-36 range check below remains enforceable because of it.","valid_values":null,"example":18.1,"unit":"score","value_min":1,"value_max":36,"null_meaning":"Suppressed by GOSA (too few test-takers), or one of 15 impossible source values (10 in 2006, 5 in 2009) NULLed by the transform.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"avg_score","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":"Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code. 2010 caveat: the 2010 source's district-total rows are internally inconsistent with its own school rows (~30 districts' published means fall outside the feasible range implied by their school rows, in both directions; the 2010 state count is also an outlier vs adjacent years); the reporting basis is unknown and the published rows are preserved unchanged — use 2010 district aggregates with caution. 2016 writing_subscore is on a 1-36 scale (ACT's 'enhanced writing' window) vs the 2-12 writing domain scale in every other year.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"066aaae84c463e97cd65c1d94af2de8c7731ddbca060c1fd1c52acae38431bd1","tags":["education","gosa","act_scores"],"granularity_description":"One row per year, district_code, school_code, test_component (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM act_scores WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM act_scores WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by test_component = composite","query":"SELECT * FROM act_scores WHERE test_component = 'composite' 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":"test_component","kind":"categorical","column":"test_component","type":"string","multi_value":true,"enum_enforced":true,"values":["combined_english_writing","composite","english","mathematics","reading","science","writing_subscore"],"has_total":false,"total_value":null,"requires_single_value":true},{"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":[]}