Saltar al contenido
← Todos los conjuntos de datos

Georgia Milestones End-of-Course (EOC) Results

Georgia Milestones high-school end-of-course test results by school, district, and subject, 2015-2025.

Cobertura de años
2015–2025
Actualización
triannual
Versión
1.1.0
Hash del esquema
1b2606493498

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Milestones End-of-Course (EOC) assessment results for high-school core content areas, published for each of up to three administrations per school year (Winter mid-year retest, Spring primary, Full-Year aggregate) at the state, district/system, and school level. Core metrics are the count of students tested, the mean scale score, and the share of students at each of the four achievement levels (Beginning, Developing, Proficient, Distinguished Learner) plus the two cumulative shares. Literature subjects add a Reading Status split against a per-course Lexile threshold (9th Grade Literature 1050L through 2020; American Literature 1185L). Student Growth Percentile (SGP) metrics appear in the source layout from Spring 2024 but carry data only from the 2024-2025 school year (Algebra: Concepts & Connections and American Literature). Full-Year 2020-2021 uniquely includes enrolled_tested_rate, reflecting COVID-era participation drops.

Granularidad de fila: Una fila por year, district_code, school_code, administration, subject.

Métrica clave

avg_scale_score — Average Scale Score (score, 140–820)

El valor principal que la mayoría de las consultas busca.

Variables

Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.

ColumnaTipoUnidadRango¿Nulo?Descripción
yearYearinteger——noEnding calendar year of the school year (e.g., 2024 = school year 2023-2024). Winter administrations are stored under the school year they fall inside: Winter 2014 EOC is the 2014-2015 mid-year retest, stored as year=2015.
Descripción completa
Ending calendar year of the school year (e.g., 2024 = school year 2023-2024). Winter administrations are stored under the school year they fall inside: Winter 2014 EOC is the 2014-2015 mid-year retest, stored as year=2015.
district_codeDistrict Codestring——yes3-digit GOSA district/system code (FK to districts dimension). School-level rows for State/Commission Charter campuses use the 7-digit campus code (system 782/783 + school code) — 2015-2017 bronze published those rows under the bare system code and they are promoted here. NULL for state-level rows.
Descripción completa
3-digit GOSA district/system code (FK to districts dimension). School-level rows for State/Commission Charter campuses use the 7-digit campus code (system 782/783 + school code) — 2015-2017 bronze published those rows under the bare system code and they are promoted here. NULL for state-level rows.

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool Codestring——yes4-digit GOSA school code (FK to schools dimension, composite with district_code). NULL for district- and state-level rows.
Descripción completa
4-digit GOSA school code (FK to schools dimension, composite with district_code). NULL for district- and state-level rows.

Se une a schools; agrega sus columnas de etiqueta.

administrationAdministrationstring——noWhich test window the row covers: winter retest, spring primary, or the full-year aggregate.
Descripción completa
Which of the three publications a row comes from: winter = mid-year retest, spring = primary end-of-year administration, full_year = fall+winter+spring aggregate. The three slices are distinct cohorts, not duplicates.
3 valores permitidos
  • winter
  • spring
  • full_year
subjectSubjectstring——noThe high-school course tested (e.g. biology, us_history, american_literature_and_composition).
Descripción completa
Snake-case EOC content area. The tested slate changed over time: 8-10 subjects through 2020 (incl. 9th Grade Literature, Physical Science, Economics, two algebra and two geometry courses); 5 standard subjects in 2021-2023 (gold year 2021 also carries the folded one-off Full-Year 2020-2021 8th-grade Physical Science administration as physical_science, so it shows 6 values); 3 in 2024 (american_literature_and_composition, biology, us_history — the 2024 Algebra: Concepts & Connections sheets are empty templates); and the 4-subject slate (adding algebra_concepts_and_connections) from 2025.
11 valores permitidos
  • 9th_grade_literature_and_composition
  • algebra_concepts_and_connections
  • algebra_i
  • american_literature_and_composition
  • analytic_geometry
  • biology
  • coordinate_algebra
  • economics_business_free_enterprise
  • geometry
  • physical_science
  • us_history
num_testedNumber Testedintegercount—yesNumber of students tested. Never suppressed by the source — non-null on every row.
Descripción completa
Number of students tested. Never suppressed by the source — non-null on every row.
avg_scale_scoreAverage Scale Scorenumberscore140–820yesAverage end-of-course scale score (about 400-650 in practice); higher means stronger performance.
Descripción completa
Mean scale score on the Georgia Milestones EOC scale. Reported scores span roughly 400-650; the contract enforces the full published EOC scale range of 140-820 (per-course bounds differ; Biology spans the full range per the GaDOE EOC Score Interpretation Guide). Preserved on its natural scale.
scale_score_std_devScale Score Std Devnumber——yesStandard deviation of the scale scores — a dispersion measure, NOT a bounded score. Units are scale-score points; the value is always >= 0. Exempt from unit/range checks (it has no fixed upper bound). Published only by Spring 2015 system-level files, Winter 2021 files, and every file from Spring 2022 onward; NULL elsewhere.
Descripción completa
Standard deviation of the scale scores — a dispersion measure, NOT a bounded score. Units are scale-score points; the value is always >= 0. Exempt from unit/range checks (it has no fixed upper bound). Published only by Spring 2015 system-level files, Winter 2021 files, and every file from Spring 2022 onward; NULL elsewhere.
pct_beginning_learnerPercent Beginning Learnernumberproportion—yesShare of tested students at the Beginning Learner level (0-1 scale; bronze 0-100 divided by 100).
Descripción completa
Share of tested students at the Beginning Learner level (0-1 scale; bronze 0-100 divided by 100).
pct_developing_learnerPercent Developing Learnernumberproportion—yesShare at Developing Learner (0-1 scale).
Descripción completa
Share at Developing Learner (0-1 scale).
pct_proficient_learnerPercent Proficient Learnernumberproportion—yesShare at Proficient Learner (0-1 scale).
Descripción completa
Share at Proficient Learner (0-1 scale).
pct_distinguished_learnerPercent Distinguished Learnernumberproportion—yesShare at Distinguished Learner (0-1 scale).
Descripción completa
Share at Distinguished Learner (0-1 scale).
pct_developing_learner_or_abovePercent Developing Learner or Abovenumberproportion—yesShare at Developing Learner or higher (= developing + proficient + distinguished). Published by the source and preserved verbatim rather than re-derived.
Descripción completa
Share at Developing Learner or higher (= developing + proficient + distinguished). Published by the source and preserved verbatim rather than re-derived.
pct_proficient_learner_or_abovePercent Proficient Learner or Abovenumberproportion—yesShare at Proficient Learner or higher (= proficient + distinguished). Published by the source and preserved verbatim.
Descripción completa
Share at Proficient Learner or higher (= proficient + distinguished). Published by the source and preserved verbatim.
pct_below_grade_level_lexilePercent Below Grade Level Lexilenumberproportion—yesReading Status: share of tested students reading below the course's Lexile threshold. Populated only for literature subjects. The threshold is per course, not per year: 9th Grade Literature uses 1050L (reported 2018-2020, discontinued after) and American Literature uses 1185L in every year it is reported (2018 onward — every American Literature sheet from Winter 2017 on is labelled 1185L in its sub-header; only the 9th Grade Literature sheets carry 1050L).
Descripción completa
Reading Status: share of tested students reading below the course's Lexile threshold. Populated only for literature subjects. The threshold is per course, not per year: 9th Grade Literature uses 1050L (reported 2018-2020, discontinued after) and American Literature uses 1185L in every year it is reported (2018 onward — every American Literature sheet from Winter 2017 on is labelled 1185L in its sub-header; only the 9th Grade Literature sheets carry 1050L).
pct_grade_level_or_above_lexilePercent Grade Level or Above Lexilenumberproportion—yesReading Status: share reading at or above the Lexile threshold; complement of pct_below_grade_level_lexile. Populated only for literature subjects.
Descripción completa
Reading Status: share reading at or above the Lexile threshold; complement of pct_below_grade_level_lexile. Populated only for literature subjects.
num_sgp_receivedNumber SGP Receivedintegercount—yesNumber of tested students who received a Student Growth Percentile. SGP columns exist in the source layout from Spring 2024, but the 2024 Algebra CC sheets are empty templates — populated data starts with the 2024-2025 school year (year=2025) for algebra_concepts_and_connections and american_literature_and_composition. NULL elsewhere.
Descripción completa
Number of tested students who received a Student Growth Percentile. SGP columns exist in the source layout from Spring 2024, but the 2024 Algebra CC sheets are empty templates — populated data starts with the 2024-2025 school year (year=2025) for algebra_concepts_and_connections and american_literature_and_composition. NULL elsewhere.
sgp_medianSGP Mediannumberpercentile1–99yesMedian Student Growth Percentile (1-99 percentile rank, preserved on its natural scale per data-cleaning-standards §4). Float64 because 2025 bronze publishes half-point medians (e.g. 61.5).
Descripción completa
Median Student Growth Percentile (1-99 percentile rank, preserved on its natural scale per data-cleaning-standards §4). Float64 because 2025 bronze publishes half-point medians (e.g. 61.5).
pct_sgp_low_growthPercent SGP Low Growthnumberproportion—yesShare of SGP-scored students in the Low Growth band (0-1 scale).
Descripción completa
Share of SGP-scored students in the Low Growth band (0-1 scale).
pct_sgp_typical_growthPercent SGP Typical Growthnumberproportion—yesShare in the Typical Growth band (0-1 scale).
Descripción completa
Share in the Typical Growth band (0-1 scale).
pct_sgp_high_growthPercent SGP High Growthnumberproportion—yesShare in the High Growth band (0-1 scale).
Descripción completa
Share in the High Growth band (0-1 scale).
enrolled_tested_rateEnrolled Tested Ratenumberproportion—yesShare of enrolled students who actually tested. Published ONLY by the Full-Year 2020-2021 files (COVID participation year); NULL for every other administration.
Descripción completa
Share of enrolled students who actually tested. Published ONLY by the Full-Year 2020-2021 files (COVID participation year); NULL for every other administration.

Filtros

Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.

ParámetroTipoValores permitidosNotas
yearyear_exactcualquier valor—
year_minyear_rangecualquier valor—
year_maxyear_rangecualquier valor—
detaildetaildistrictsschoolsstatesenum validado, predeterminado: schools
district_codeforeign_keycualquier valorvalores múltiples
school_codeforeign_keycualquier valorvalores múltiples
administrationcategoricalwinterspringfull_yearvalores múltiples, enum validado, elige uno
subjectcategorical
11 valores permitidos
  • 9th_grade_literature_and_composition
  • algebra_concepts_and_connections
  • algebra_i
  • american_literature_and_composition
  • analytic_geometry
  • biology
  • coordinate_algebra
  • economics_business_free_enterprise
  • geometry
  • physical_science
  • us_history
valores múltiples, enum validado, elige uno
district_typedimension_attribute
7 valores permitidos
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
valores múltiples, enum validado
school_leveldimension_attributeelementarymiddlehighk12othervalores múltiples, enum validado
localedimension_attributecitysuburbtownruralvalores múltiples, enum validado

Ejemplos de solicitudes

Ejecútalos contra la URL base: devuelven datos en vivo.

All rows (first page), schools level

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course"

schools data for 2025

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course?year=2025"

Filtered to administration = winter for 2025

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course?year=2025&administration=winter"

One district (code 601), 2025

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course?district_code=601&year=2025&detail=districts"

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course?year=2025&format=csv"

Notas y limitaciones

Manejo de NULL

  • Las celdas suprimidas (muy pocos estudiantes para reportar) son NULL, nunca cero.
  • El cero es un valor real y reportado.

Limitaciones

Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.