Saltar al contenido
← Todos los conjuntos de datos

Georgia Milestones EOC Lexile Reading Scores

Lexile reading-measure distributions from Georgia's two ELA End-of-Course exams by school, district, and state, 2015-2024.

Cobertura de años
20152024
Actualización
annual
Versión
1.0.0
Hash del esquema
91988a21c744

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Governor's Office of Student Achievement (GOSA) Georgia Milestones End-of-Course (EOC) Lexile assessment dataset. Reports Lexile reading-measure distributions derived from Georgia's two English Language Arts EOC courses (9th Grade Literature and Composition, American Literature and Composition). Each row is one (entity x subject) combination with five measures: total students tested, students with a Lexile measure, students without a Lexile score, students with Lexile at or above the grade-level midpoint (the 'on-track reader' threshold), and the average Lexile measure. Coverage is school years 2014-15 through 2023-24 (2019-20 absent — EOC testing suspended due to COVID-19) at state, district, and school detail levels. No demographic breakdown — every row is implicitly 'All Students'.

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

Métrica clave

avg_lexile_scoreAverage Lexile Score (score, 0–2000)

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
yearYearintegernoEnding calendar year of the school year (e.g., 2024 = 2023-24). Derived from the filename and cross-checked against the bronze SCHOOL_YEAR column. 2020 is absent (EOC testing suspended during COVID-19 closures).
Descripción completa
Ending calendar year of the school year (e.g., 2024 = 2023-24). Derived from the filename and cross-checked against the bronze SCHOOL_YEAR column. 2020 is absent (EOC testing suspended during COVID-19 closures).
district_codeDistrict CodestringyesGOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows.
Descripción completa
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.

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool CodestringyesGOSA 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.

subjectSubjectstringnoWhich ELA End-of-Course exam the row covers: 9th Grade Literature (through 2021) or American Literature.
Descripción completa
ELA EOC course this row measures, snake_case canonical. 9th_grade_literature_and_composition is present 2015-2021 (only 84 rows in 2021) and retired after 2021 — a real curriculum change (GOSA moved 9th-grade ELA off the EOC program), not a relabeling. american_literature_and_composition is present every year and is the sole subject from 2022.
2 valores permitidos
  • 9th_grade_literature_and_composition
  • american_literature_and_composition
num_testedNumber TestedintegercountyesCount of students who took the subject's EOC. Bronze TOTAL_STUDENTS_TESTED. NULL when the source cell is blank (2015-2019 — those files contain no TFS) or TFS-suppressed (2021-2024); 4-18% of rows depending on year.
Descripción completa
Count of students who took the subject's EOC. Bronze TOTAL_STUDENTS_TESTED. NULL when the source cell is blank (2015-2019 — those files contain no TFS) or TFS-suppressed (2021-2024); 4-18% of rows depending on year.
num_with_lexileNumber with LexileintegercountyesCount of tested students whose EOC produced a usable Lexile measure — equal to or slightly below num_tested, never above it (enforced). Reported exactly when avg_lexile_score is reported (enforced biconditional). Bronze STUDENTS_WITH_LEXILE; NULL when blank (2015-2019) or TFS-suppressed (2021-2024). In all years only 2 rows have num_tested reported with this column missing (2015 Polk County school 0207; 2016 Bleckley County school 0115 — blank cells, not TFS).
Descripción completa
Count of tested students whose EOC produced a usable Lexile measure — equal to or slightly below num_tested, never above it (enforced). Reported exactly when avg_lexile_score is reported (enforced biconditional). Bronze STUDENTS_WITH_LEXILE; NULL when blank (2015-2019) or TFS-suppressed (2021-2024). In all years only 2 rows have num_tested reported with this column missing (2015 Polk County school 0207; 2016 Bleckley County school 0115 — blank cells, not TFS).
num_without_lexileNumber Without LexileintegercountyesCount of tested students who did NOT receive a usable Lexile measure, as published by GOSA (bronze NO_LEXILE_SCORE). This is an independently reported source count, NOT the arithmetic complement num_tested - num_with_lexile: of the 140 rows (all years) where all three counts are numeric, 45 disagree with that derivation (by up to 99 students), so the published column is retained rather than derived and no with+without=tested check is enforced. Heavily suppressed (~94-99% NULL).
Descripción completa
Count of tested students who did NOT receive a usable Lexile measure, as published by GOSA (bronze NO_LEXILE_SCORE). This is an independently reported source count, NOT the arithmetic complement num_tested - num_with_lexile: of the 140 rows (all years) where all three counts are numeric, 45 disagree with that derivation (by up to 99 students), so the published column is retained rather than derived and no with+without=tested check is enforced. Heavily suppressed (~94-99% NULL).
num_at_or_above_lexile_midpointNumber at or Above Lexile MidpointintegercountyesCount of students whose Lexile measure was at or above the midpoint of the course's Lexile range (GOSA's 'on-track reader' / grade-level threshold: 1050L for 9th Grade Literature, 1185L for American Literature). A raw COUNT, not a percentage (2024 state row: 69,660 of 132,835 students with a Lexile = 52.4%) — derive a share by dividing by num_with_lexile (the population with a valid Lexile), not num_tested. Never exceeds num_with_lexile (enforced). Bronze LEXILE_ON_OR_ABOVE_MIDPOINT; NULL when suppressed.
Descripción completa
Count of students whose Lexile measure was at or above the midpoint of the course's Lexile range (GOSA's 'on-track reader' / grade-level threshold: 1050L for 9th Grade Literature, 1185L for American Literature). A raw COUNT, not a percentage (2024 state row: 69,660 of 132,835 students with a Lexile = 52.4%) — derive a share by dividing by num_with_lexile (the population with a valid Lexile), not num_tested. Never exceeds num_with_lexile (enforced). Bronze LEXILE_ON_OR_ABOVE_MIDPOINT; NULL when suppressed.
avg_lexile_scoreAverage Lexile Scorenumberscore0–2000yesAverage Lexile reading measure (on the natural Lexile scale, not a percentage) among students who received one.
Descripción completa
Average Lexile reading measure among students who received one, reported to one decimal place. The Lexile reader scale runs from below 0L (BR / Beginning Reader) to above 2000L; the contract enforces 0-2000 for these entity-level averages (observed range 707.0-1679.3 across all years and detail levels — a below-0 BR average is unreachable for an EOC cohort). NOT a percentage — no 0-1 rescaling; the natural Lexile scale is preserved. Reported exactly when num_with_lexile is reported (enforced biconditional). Bronze AVG_LEXILE_SCORE; NULL when suppressed.

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
subjectcategorical9th_grade_literature_and_compositionamerican_literature_and_compositionvalores 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

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_lexile"

schools data for 2024

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

Filtered to subject = 9th_grade_literature_and_composition for 2024

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course_lexile?year=2024&subject=9th_grade_literature_and_composition"

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/georgia_milestones_end_of_course_lexile?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.