Georgia Civic DataGrade 7-12 Dropout Rates
Number and rate of grade 7-12 students who dropped out, by Georgia school, district, and demographic subgroup, 2011-2024.
- 2011–2024
- annual
- 1.0.0
- c579db0c0fb8
Overview
Number and rate of grade 7-12 dropouts for Georgia public schools, with official district and state rollups, by demographic subgroup (race/ethnicity, gender, economic status, English proficiency, migrant status, disability status). Published by GOSA for school years 2010-11 through 2023-24.
Row grain: One row per year, district_code, school_code, demographic.
dropout_rate — Dropout Rate (proportion)
The single headline value most answers want.
Variables
Every column in the fact table. The code is the exact field name the API returns.
| Column | Type | Unit | Range | Null? | Description |
|---|---|---|---|---|---|
year | integer | — | — | no | Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename.Full description▾Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename. |
district_code | string | — | — | yes | 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.Full description▾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. |
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.Full 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. |
demographic | string | — | — | no | Student subgroup the row describes (race, gender, economic status, English learner, migrant, or disability); 'all' is every student.Full description▾Demographic subgroup (FK to the global demographics dimension). Race buckets use the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes a single 'Asian/Pacific Islander' label and its six race buckets sum exactly to the 'all' total at the state level in every year, so Pacific Islanders are folded in, never published separately. english_learners rows are absent in 2020-2022 (the source dropped the Limited English Proficient subgroup in those files). 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic, special population). 15 allowed values▾
|
num_dropouts | integer | — | yes | Number of students in grades 7-12 who dropped out during the school year. Published values are always >= 10 because GOSA suppresses smaller cells; ~78-83% of school-level rows are suppressed (NULL) in every year. Always co-suppressed with dropout_rate.Full description▾Number of students in grades 7-12 who dropped out during the school year. Published values are always >= 10 because GOSA suppresses smaller cells; ~78-83% of school-level rows are suppressed (NULL) in every year. Always co-suppressed with dropout_rate. | |
dropout_rate | number | — | yes | Share of the subgroup's grade 7-12 students who dropped out during the school year, on a 0-1 scale; lower is better.Full description▾Grade 7-12 dropout rate as a proportion (0-1 scale): dropouts divided by the subgroup's grade 7-12 enrollment. The source publishes 0-100 percentages with one decimal place (observed 0.2-93.6 across all years); divided by 100. Always co-suppressed with num_dropouts. |
Filters
Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.
| Parameter | Kind | Allowed values | Notes |
|---|---|---|---|
year | year_exact | any value | — |
year_min | year_range | any value | — |
year_max | year_range | any value | — |
detail | detail | districtsschoolsstates | enum-enforced, default: schools |
district_code | foreign_key | any value | multi-value |
school_code | foreign_key | any value | multi-value |
demographic | foreign_key | 15 allowed values▾
| multi-value, enum-enforced |
district_type | dimension_attribute | 7 allowed values▾
| multi-value, enum-enforced |
demographic_category | dimension_attribute | 12 allowed values▾
| multi-value, enum-enforced |
Example requests
Run these against the base URL — they return live data.
All rows (first page), schools level
curl "https://georgiacivicdata.org/api/v1/education/dropout_rate_7_12"schools data for 2024
curl "https://georgiacivicdata.org/api/v1/education/dropout_rate_7_12?year=2024"One district (code 601), 2024
curl "https://georgiacivicdata.org/api/v1/education/dropout_rate_7_12?district_code=601&year=2024&detail=districts"Download 2024 as CSV
curl "https://georgiacivicdata.org/api/v1/education/dropout_rate_7_12?year=2024&format=csv"Notes & limitations
NULL handling
- Suppressed cells (too few students to report) are NULL, never zero.
- Zero is a real, reported value.
Limitations
Suppressed cells are NULL (not zero): GOSA suppresses any cell below the n=10 reporting threshold, which blanks ~78-83% of school-level rows in every year — school-level analyses should expect sparse coverage, and summing only published subgroup counts undercounts true totals at school grain (use district or state rows for official aggregates). State rows have NULL district_code and school_code; district rows have NULL school_code. The race axis uses the combined asian_pacific_islander bucket — not comparable row-for-row with split-convention topics without aggregating those topics' asian + pacific_islander rows at query time. english_learners rows are absent in 2020-2022.