Georgia Milestones End-of-Grade Assessment by Grade

Georgia Milestones End-of-Grade achievement levels by grade, subject, and demographic for schools, districts, and the state, 2015-2024.

Fuente: Governor's Office of Student Achievement (GOSA)
Cobertura de años: 2015–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: 692af1c294d3

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Milestones End-of-Grade (EOG) assessment results for Georgia public-school students in grades 3-8, disaggregated by individual grade level. Each row is one (entity x grade x demographic subgroup x subject) cell reporting the number of students tested plus the count and percentage of test-takers at each of four achievement levels (Beginning, Developing, Proficient, Distinguished), with derived cumulative developing-or-above and proficient-or-above shares. State, district, and school detail levels. School years 2014-15 through 2023-24; 2019-20 is absent (EOG administration cancelled, COVID-19).

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

Métrica clave

pct_proficient_learner_or_above — Percent Proficient Learner or Above (proportion)

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

Esquema JSON →Contrato de datos (YAML) →

Variables

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

Columna	Tipo	Unidad	Rango	¿Nulo?	Descripción
`year`Year	integer	—	—	no	Ending calendar year of the school year (e.g., 2024 = 2023-24), from the filename and cross-checked against the file's LONG_SCHOOL_YEAR. 2020 has no rows (EOG cancelled during COVID-19 closures). Descripción completa▾ Ending calendar year of the school year (e.g., 2024 = 2023-24), from the filename and cross-checked against the file's LONG_SCHOOL_YEAR. 2020 has no rows (EOG cancelled during COVID-19 closures).
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded standard codes or 7-digit state-charter / commission-charter / state-school codes. NULL on state-level rows. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded standard codes or 7-digit state-charter / commission-charter / state-school codes. NULL on state-level rows. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	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. Descripción completa▾ 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. Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Student subgroup the row covers (race, gender, economic, disability, English-learner, etc.); 'all' is all students. Descripción completa▾ Canonical demographic subgroup (FK to the global demographics dimension), normalized from bronze SUBGROUP_NAME. This topic uses the split race convention: asian and pacific_islander are separate, mutually exclusive rows (the source publishes both labels in every year). 18 core subgroups in 2015-2019; active_duty and homeless added in 2021; foster_care and military_connected (renaming active_duty) added in 2022. NON-ADDITIVE MILITARY KEYS: active_duty (2021) and military_connected (2022+) never co-occur in a year, but conceptually active-duty dependents are a subset of military-connected students — do not sum the two keys across years as if disjoint. 22 valores permitidos▾ `active_duty` `all` `asian` `black` `economically_disadvantaged` `english_learners` `female` `foster_care` `hispanic` `homeless` `male` `migrant` `military_connected` `multiracial` `native_american` `not_economically_disadvantaged` `not_english_learners` `not_migrant` `pacific_islander` `students_with_disabilities` `students_without_disabilities` `white` Se une a demographics; agrega sus columnas de etiqueta.
`grade_level`Grade Level	string	—	—	no	Grade tested, 03-08; this is the grade-by-grade breakout that distinguishes this topic from the all-grades rollup. Descripción completa▾ Grade of the test-takers in this row, as a canonical 2-char zero-padded string. Bronze ACDMC_LVL is unpadded (3-8) in 2015 and 2019 and zero-padded (03-08) in all other years; gold normalizes both to 03-08. This column is the grain difference vs the all-grades rollup sibling topic. 6 valores permitidos▾ `03` `04` `05` `06` `07` `08`
`subject`Subject	string	—	—	no	EOG content area tested (ELA, mathematics, science, social studies, physical science); coverage varies by grade and year. Descripción completa▾ EOG academic subject. english_language_arts and mathematics span grades 3-8 in every year; science and social_studies are restricted to grades 5 and 8 from 2017 (social_studies to grade 8 only from 2021); physical_science (2022+) is an 8th-grade accelerated option. The natural grade x subject sparsity is preserved — untested combinations have no rows; rare out-of-pattern audit/retest cells are retained. 5 valores permitidos▾ `english_language_arts` `mathematics` `physical_science` `science` `social_studies`
`num_tested`Number Tested	integer	count	—	yes	Number of students tested in this (entity x grade x subgroup x subject) cell. NULL when GOSA suppressed the cell (TFS); in 2024 GOSA extended suppression to this column (~30% of rows) while still publishing the rounded percentage distribution. Descripción completa▾ Number of students tested in this (entity x grade x subgroup x subject) cell. NULL when GOSA suppressed the cell (TFS); in 2024 GOSA extended suppression to this column (~30% of rows) while still publishing the rounded percentage distribution.
`num_beginning_learner`Number Beginning Learner	integer	count	—	yes	Count of students at the lowest achievement level (Beginning Learner). Bronze BEGIN_CNT; NULL when suppressed. Descripción completa▾ Count of students at the lowest achievement level (Beginning Learner). Bronze BEGIN_CNT; NULL when suppressed.
`num_developing_learner`Number Developing Learner	integer	count	—	yes	Count of students at the second achievement level (Developing Learner). Bronze DEVELOPING_CNT; NULL when suppressed. Descripción completa▾ Count of students at the second achievement level (Developing Learner). Bronze DEVELOPING_CNT; NULL when suppressed.
`num_proficient_learner`Number Proficient Learner	integer	count	—	yes	Count of students at the third achievement level (Proficient Learner). Bronze PROFICIENT_CNT; NULL when suppressed. Descripción completa▾ Count of students at the third achievement level (Proficient Learner). Bronze PROFICIENT_CNT; NULL when suppressed.
`num_distinguished_learner`Number Distinguished Learner	integer	count	—	yes	Count of students at the highest achievement level (Distinguished Learner). Bronze DISTINGUISHED_CNT; the most-suppressed metric (~70-76% of rows in recent years — few cells have enough distinguished scorers to clear the threshold). Descripción completa▾ Count of students at the highest achievement level (Distinguished Learner). Bronze DISTINGUISHED_CNT; the most-suppressed metric (~70-76% of rows in recent years — few cells have enough distinguished scorers to clear the threshold).
`pct_beginning_learner`Percent Beginning Learner	number	proportion	—	yes	Share of tested students at the Beginning level, 0-1 scale (bronze 0-100 divided by 100). Published shares are exact to one decimal on the 0-100 scale against num_tested. CAVEAT: on foster_care rows from 2022 onward the four level shares can sum below 1 (students tested but not assigned a level, plus all-zero placeholder rows on fully-suppressed cells) — published GOSA values are preserved exactly. Descripción completa▾ Share of tested students at the Beginning level, 0-1 scale (bronze 0-100 divided by 100). Published shares are exact to one decimal on the 0-100 scale against num_tested. CAVEAT: on foster_care rows from 2022 onward the four level shares can sum below 1 (students tested but not assigned a level, plus all-zero placeholder rows on fully-suppressed cells) — published GOSA values are preserved exactly.
`pct_developing_learner`Percent Developing Learner	number	proportion	—	yes	Share of tested students at the Developing level, 0-1 scale. See pct_beginning_learner for the foster_care caveat. Descripción completa▾ Share of tested students at the Developing level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.
`pct_proficient_learner`Percent Proficient Learner	number	proportion	—	yes	Share of tested students at the Proficient level, 0-1 scale. See pct_beginning_learner for the foster_care caveat. Descripción completa▾ Share of tested students at the Proficient level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.
`pct_distinguished_learner`Percent Distinguished Learner	number	proportion	—	yes	Share of tested students at the Distinguished level, 0-1 scale. See pct_beginning_learner for the foster_care caveat. Descripción completa▾ Share of tested students at the Distinguished level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.
`pct_developing_learner_or_above`Percent Developing Learner or Above	number	proportion	—	yes	Derived cumulative share at Developing or above (developing + proficient + distinguished), 0-1 scale. Computed at transform time from the published per-level shares; sums of publisher-rounded shares that land within 0.005 above 1.0 are snapped to 1.0 (a share cannot exceed 1). Descripción completa▾ Derived cumulative share at Developing or above (developing + proficient + distinguished), 0-1 scale. Computed at transform time from the published per-level shares; sums of publisher-rounded shares that land within 0.005 above 1.0 are snapped to 1.0 (a share cannot exceed 1).
`pct_proficient_learner_or_above`Percent Proficient Learner or Above	number	proportion	—	yes	Share of tested students scoring Proficient or Distinguished (proficient-or-above), on a 0-1 scale; the headline achievement measure. Descripción completa▾ Derived cumulative share at Proficient or above (proficient + distinguished), 0-1 scale. Computed at transform time from the published per-level shares; rounding overshoot above 1.0 within 0.005 is snapped to 1.0.

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ámetro	Tipo	Valores permitidos	Notas
`year`	year_exact	cualquier valor	—
`year_min`	year_range	cualquier valor	—
`year_max`	year_range	cualquier valor	—
`detail`	detail	`districtsschoolsstates`	enum validado, predeterminado: schools
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`demographic`	foreign_key	22 valores permitidos▾ `active_duty` `all` `asian` `black` `economically_disadvantaged` `english_learners` `female` `foster_care` `hispanic` `homeless` `male` `migrant` `military_connected` `multiracial` `native_american` `not_economically_disadvantaged` `not_english_learners` `not_migrant` `pacific_islander` `students_with_disabilities` `students_without_disabilities` `white`	valores múltiples, enum validado
`grade_level`	categorical	`030405060708`	valores múltiples, enum validado, elige uno
`subject`	categorical	`english_language_artsmathematicsphysical_sciencesciencesocial_studies`	valores múltiples, enum validado, elige uno
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado
`demographic_category`	dimension_attribute	12 valores permitidos▾ `aggregate` `disability` `economic_status` `esol` `foster_care` `gender` `grade` `homeless_status` `migrant_status` `military` `race` `sped`	valores 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_grade_by_grade_level"

schools data for 2024

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_grade_by_grade_level?year=2024"

Filtered to grade_level = 03 for 2024

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_grade_by_grade_level?year=2024&grade_level=03"

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_grade_by_grade_level?year=2024&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. 2020 has no rows (EOG cancelled during COVID-19). Grade x subject coverage is naturally sparse and changes over time (science/social_studies grades 5+8 only from 2017, social_studies grade 8 only from 2021, physical_science grade 8 only). Foster Care caveat (2022-2024): the foster_care rows are the only rows whose four per-level shares can fail to sum to 1 — 28 fully-unsuppressed state-level rows carry level counts summing below num_tested (students tested but not assigned a performance level at publication), and partially- or fully-suppressed foster_care cells publish shares covering only the unsuppressed levels, including an all-four-zeros placeholder pattern. The published GOSA values are preserved exactly rather than reconciled.