Saltar al contenido
← Todos los conjuntos de datos

Enrollment by Grade Level

Student enrollment counts by grade (K-12) for each Georgia school, district, and the state, per Fall/Spring snapshot, 2011-2024.

Cobertura de años
20112024
Actualización
annual
Versión
1.0.0
Hash del esquema
0a3f9211501c

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Student enrollment counts by grade level for every Georgia public school, school district, and the state, published by GOSA for school years 2010-11 through 2023-24. Each row is the total number of students enrolled in one grade (K through 12) at one entity in one enrollment-snapshot period — GaDOE counts enrollment twice per school year (Fall and Spring collection cycles), and both snapshots are preserved as distinct rows. There is no demographic breakdown: every row is a total count for its (year, geography, period, grade) cell.

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

Métrica clave

num_studentsNumber Students (count)

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 (2024 = 2023-24). Parsed from the bronze LONG_SCHOOL_YEAR and cross-checked against the filename year.
Descripción completa
Ending calendar year of the school year (2024 = 2023-24). Parsed from the bronze LONG_SCHOOL_YEAR and cross-checked against the filename year.
district_codeDistrict CodestringyesGOSA district code (FK to districts dimension): 3-character zero-padded code for standard county/city districts, or 7-character code for state-charter (782 prefix), commission-charter (783 prefix), and state school (799 prefix) entities — 7-character codes appear in every year 2011-2024. NULL on state-level aggregate rows (bronze sentinel 'ALL').
Descripción completa
GOSA district code (FK to districts dimension): 3-character zero-padded code for standard county/city districts, or 7-character code for state-charter (782 prefix), commission-charter (783 prefix), and state school (799 prefix) entities — 7-character codes appear in every year 2011-2024. NULL on state-level aggregate rows (bronze sentinel 'ALL').

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool Codestringyes4-character zero-padded GOSA school code (composite FK to schools dimension with district_code; school codes are not globally unique on their own). NULL on district- and state-level aggregate rows (bronze sentinel 'ALL').
Descripción completa
4-character zero-padded GOSA school code (composite FK to schools dimension with district_code; school codes are not globally unique on their own). NULL on district- and state-level aggregate rows (bronze sentinel 'ALL').

Se une a schools; agrega sus columnas de etiqueta.

enrollment_periodEnrollment PeriodstringnoEnrollment snapshot within the school year: fall (October) or spring (March); never sum across them.
Descripción completa
Enrollment-count snapshot within the school year: 'fall' (October collection) or 'spring' (March collection). Both snapshots exist for nearly every entity — queries wanting one headline count per year must filter to a single period, never sum across them.
2 valores permitidos
  • fall
  • spring
grade_levelGrade LevelstringnoGrade of the students counted: 'k' for kindergarten, '01'-'12' for grades 1-12; no pre-K or all-grades row.
Descripción completa
Grade level of the students counted: 'k' for kindergarten, '01' through '12' for grades 1-12 (canonical zero-padded codes per the shared grade vocabulary). This source publishes no pre-K row and no cross-grade aggregate row, so 'pk' and 'all' never appear. Bronze spellings were K and 1st..12th.
13 valores permitidos
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • k
num_studentsNumber StudentsintegercountyesNumber of students enrolled in this grade and period at this entity.
Descripción completa
Number of students enrolled in this grade and period at this entity. Three source regimes govern 0 vs NULL: (1) 2011-2020 — no suppression; an explicit 0 is a true zero (grade not served) and is preserved; (2) 2021-2022 — the source replaces both true zeros and counts 1-9 with 'TFS' (Too Few Students), stored as NULL here; (3) 2023-2024 — TFS suppression continues AND rows for non-applicable grade x entity combinations are no longer emitted, roughly halving the row count per year.

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
enrollment_periodcategoricalfallspringvalores múltiples, enum validado, elige uno
grade_levelcategorical
13 valores permitidos
  • 01
  • 02
  • 03
  • 04
  • 05
  • 06
  • 07
  • 08
  • 09
  • 10
  • 11
  • 12
  • k
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

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/enrollment_by_grade_level"

schools data for 2024

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

Filtered to enrollment_period = fall for 2024

curl "https://georgiacivicdata.org/api/v1/education/enrollment_by_grade_level?year=2024&enrollment_period=fall"

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/enrollment_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. State and district rows are independently published GOSA aggregates and may differ from the sum of their component rows by up to ~0.02% (e.g., students enrolled in more than one district during a collection period); do not treat component sums as exact reconciliations.