{"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.","explorer":true,"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 6 among the 208 district-years where sums exceed the rollup) 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 with the TFS (Too Few Students) marker — 2011-2015 and 2019-2024 sources only; the count of test-takers is never suppressed in 2004-2010 or 2016-2018 — 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: blank cells in 2004 (47 rows) and 2011-2019 sources, the 'Too Few Students' marker in 2008-2010, TFS in 2020-2024; 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,"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"]},{"param":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"non_additive":[{"column":"subject","reason":"A student who took exams in several subjects counts under each subject, so per-subject num_tested adds up to more students than the all_subjects row.","metrics":["num_tested"]},{"column":"school_code","reason":"A student who moved schools mid-year can count at more than one school, while district and state rows count each student once, so school rows can add up to more than the published district or state row.","metrics":["num_tested"]}],"value_implications":[],"values_endpoint":"/api/v1/education/advanced_placement_scores/values"}