{"main_topic":"education","sub_topic":"gosa","topic":"advanced_placement_scores","key":"education/gosa/advanced_placement_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/advanced_placement_scores/year={year}/{detail}.parquet","grain":["year","district_code","school_code","subject"],"title":"Advanced Placement (AP) Exam Scores","summary":"AP college-level exam participation and pass rates (share scoring 3 or higher) by Georgia school, district, and AP subject, 2004-2024.","description":"Advanced Placement (AP) exam participation and qualifying-score counts for Georgia public high schools, with official district and state rollups, published by GOSA for 2004-2024. Each row reports the number of distinct students taking AP exams, the total exams administered, the count of exams scoring 3 or higher (College Board's qualifying threshold), and a derived pass rate (tests_3_or_higher_rate). Years 2011-2024 break the counts down by AP subject in addition to a cross-subject all_subjects total; years 2004-2010 publish only the cross-subject total.","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/advanced_placement_scores","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2024 = the 2023-24 school year). 2011-2024 sources carry a LONG_SCHOOL_YEAR column whose ending year is cross-checked against the filename; 2004-2010 sources have no year column and the filename 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 charter codes. NULL on state-level rows. Bronze aggregate sentinels (ALL / DISTRICT_ALL) map to NULL.","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. Bronze aggregate sentinels (ALL / SCHOOL_ALL / DISTRICT_ALL) map to NULL.","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":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"Which AP exam subject the row covers; all_subjects is the cross-subject total (distinct students, not a sum of the per-subject rows).","description":"AP subject (snake_case recode of the source's TEST_CMPNT_TYP_NM). all_subjects is the cross-subject aggregate: the only value present for 2004-2010 (the legacy sources have no per-subject breakdown) and one row per entity alongside the per-subject rows for 2011-2024. all_subjects rows are NOT the sum of the subject rows — num_tested counts distinct students across subjects there. calculus_a is GOSA's literal label for AP Calculus AB (it pairs with calculus_bc), not a normalization error; physics_b and latin_vergil are discontinued legacy AP exams retained for the years they were administered.","valid_values":["african_american_studies","all_subjects","art_history","art_studio_2d_design","art_studio_3d_design","art_studio_drawing","biology","calculus_a","calculus_bc","capstone","capstone_research","chemistry","chinese_language_and_culture","computer_science_a","computer_science_principles","economics_macro","economics_micro","english_language_and_composition","english_literature_and_composition","environmental_science","european_history","french_language","german_language","government_and_politics_comparative","government_and_politics_us","human_geography","italian_language_and_culture","japanese_language_and_culture","latin_vergil","music_theory","physics_1","physics_2","physics_b","physics_c_electricity_and_magnetism","physics_c_mechanics","precalculus","psychology","spanish_language","spanish_literature","statistics","us_history","world_history"],"example":"calculus_a","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 distinct students who sat at least one AP exam (all_subjects rows) or who sat the specific subject's exam (per-subject rows). Summing per-subject num_tested double-counts students who took multiple subjects; summing school rows can likewise slightly exceed the published district/state rollups (median gap 2) because the rollup counts each student once even when school-level attribution counts a mid-year mover at more than one school. Three source rows publish num_tested greater than num_tests_taken — impossible if both counts were accurate, but the wrong-side column is unknowable, so the published values are preserved and documented: 2005 district 611 school 0204 (Rutland HS, 33 students / 23 tests) and 2008 district 652 (Elbert County, 10/9, appearing on both the school 0176 row and the single-school district row).","valid_values":null,"example":17,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS / Too Few Students marker, or a blank cell in 2004-2007 and 2011-2022 sources), or one of the 8 masked 2005 district rollup rows (misassigned at source — see notes).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_tests_taken","type":"integer","role":"metric","nullable":true,"label":"Number Tests Taken","short_description":"","description":"Total AP exams administered (a student can take exams in multiple subjects, and the College Board counts each exam). 47 of 414 bronze rows in 2004 leave this blank; 2011-2019 sources suppress via empty cells, 2020-2024 via TFS.","valid_values":null,"example":17,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS / Too Few Students marker, or a blank cell — the dominant suppression form in 2004-2007 and 2011-2019 sources), or one of the 8 masked 2005 district rollup rows (misassigned at source — see notes).","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_tests_3_or_higher","type":"integer","role":"metric","nullable":true,"label":"Number Tests 3 or Higher","short_description":"","description":"Number of AP exams that scored 3 or higher (College Board's qualifying threshold; scores run 1-5). Never exceeds num_tests_taken where both are reported (enforced by a quality check).","valid_values":null,"example":12,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS / Too Few Students marker, or a blank/empty cell), or one of the 8 masked 2005 district rollup rows (misassigned at source — see notes). Suppressed independently of the other two counts and roughly twice as often in 2023-2024.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"tests_3_or_higher_rate","type":"number","role":"metric","nullable":true,"label":"Tests 3 or Higher Rate","short_description":"Share of AP exams that scored 3 or higher (College Board's qualifying threshold), on a 0-1 scale; higher is better.","description":"Share of administered exams that scored 3 or higher, derived by the transform as num_tests_3_or_higher / num_tests_taken on the 0-1 scale (the pct_* share-of-denominator companion to num_tests_3_or_higher). 2004-2010 sources publish a 0-100 percentage column that is dropped and recomputed (recomputed values agree within 0.0005 — source rounding); 2011-2024 sources publish no rate column. NULL when either count is suppressed or the denominator is 0.","valid_values":null,"example":0.706,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Not derivable: num_tests_taken or num_tests_3_or_higher is suppressed (or masked on the 8 misassigned 2005 district rollup rows), or num_tests_taken is 0.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"tests_3_or_higher_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":"Suppressed cells are NULL (not zero). 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":[2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"99b14eb4841245881a8b45f0ee2c661900216655a6bb25f5c72e79a90e7563f3","tags":["education","governor's office of student achievement","advanced_placement_scores"],"granularity_description":"One row per year, district_code, school_code, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM advanced_placement_scores WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM advanced_placement_scores WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by subject = calculus_a","query":"SELECT * FROM advanced_placement_scores WHERE subject = 'calculus_a' 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":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["african_american_studies","all_subjects","art_history","art_studio_2d_design","art_studio_3d_design","art_studio_drawing","biology","calculus_a","calculus_bc","capstone","capstone_research","chemistry","chinese_language_and_culture","computer_science_a","computer_science_principles","economics_macro","economics_micro","english_language_and_composition","english_literature_and_composition","environmental_science","european_history","french_language","german_language","government_and_politics_comparative","government_and_politics_us","human_geography","italian_language_and_culture","japanese_language_and_culture","latin_vergil","music_theory","physics_1","physics_2","physics_b","physics_c_electricity_and_magnetism","physics_c_mechanics","precalculus","psychology","spanish_language","spanish_literature","statistics","us_history","world_history"],"has_total":true,"total_value":"all_subjects","requires_single_value":false},{"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":[]}