enrollments

Data source: Big Local News · About: Big Local

18,300 rows where state = "SC" and year = 2021 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 18,200 ✖
Link rowid state county county_state_id admin_level district_nces_id ▼ district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
379988 379988 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379989 379989 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379990 379990 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379991 379991 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379992 379992 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379993 379993 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379994 379994 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379995 379995 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379996 379996 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
379997 379997 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
381207 381207 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2021   grade_9                                                   2.0                                             2
381208 381208 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   grade_9                                                   39.0                                             39
381209 381209 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   grade_9                                                   12.0                                             12
381210 381210 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   grade_9                                                   6.0                                             6
381211 381211 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   grade_9                                                   6.0                                             6
381212 381212 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   grade_9                                                   13.0                                             13
381213 381213 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   grade_9                                                   6.0                                             6
381214 381214 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   grade_9                                                   14.0                                             14
381215 381215 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   grade_9                                                   10.0                                             10
381216 381216 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   grade_9                                                   8.0                                             8
381217 381217 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   grade_9                                                   111.0                                             111
382427 382427 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2021   grade_10                                                   1.0                                             1
382428 382428 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   grade_10                                                   13.0                                             13
382429 382429 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   grade_10                                                   3.0                                             3
382430 382430 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   grade_10                                                   1.0                                             1
382431 382431 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   grade_10                                                   1.0                                             1
382432 382432 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   grade_10                                                   4.0                                             4
382433 382433 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   grade_10                                                   0.0                                             0
382434 382434 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   grade_10                                                   2.0                                             2
382435 382435 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   grade_10                                                   3.0                                             3
382436 382436 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   grade_10                                                   3.0                                             3
382437 382437 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   grade_10                                                   18.0                                             18
383647 383647 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2021   grade_11                                                   0.0                                             0
383648 383648 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   grade_11                                                   6.0                                             6
383649 383649 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   grade_11                                                   0.0                                             0
383650 383650 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   grade_11                                                   3.0                                             3
383651 383651 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   grade_11                                                   1.0                                             1
383652 383652 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   grade_11                                                   0.0                                             0
383653 383653 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   grade_11                                                   1.0                                             1
383654 383654 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   grade_11                                                   1.0                                             1
383655 383655 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   grade_11                                                   1.0                                             1
383656 383656 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   grade_11                                                   0.0                                             0
383657 383657 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   grade_11                                                   2.0                                             2
384867 384867 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2021   grade_12                                                   1.0                                             1
384868 384868 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   grade_12                                                   5.0                                             5
384869 384869 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   grade_12                                                   1.0                                             1
384870 384870 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   grade_12                                                   1.0                                             1
384871 384871 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   grade_12                                                   0.0                                             0
384872 384872 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   grade_12                                                   0.0                                             0
384873 384873 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   grade_12                                                   0.0                                             0
384874 384874 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   grade_12                                                   2.0                                             2
384875 384875 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   grade_12                                                   0.0                                             0
384876 384876 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   grade_12                                                   0.0                                             0
384877 384877 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   grade_12                                                   9.0                                             9
386087 386087 SC     school 4500001 5209   Department of Corrections 450000100255 5209003 Tyger River High   Alternative School No High 09 12 2021   pk_12_total 2.0 1.0 1.0 0.0   0.0     0.0   0.0 0.0 4.0 0.0   0.0         3.0         4.0 2 1 1 0   0     0   0 0 4 0   0     3       4
386088 386088 SC     school 4500001 5209   Department of Corrections 450000101731 5209005 Kirkland High   Alternative School No High 09 12 2021   pk_12_total 14.0 46.0 0.0 0.0   0.0     3.0   0.0 0.0 63.0 0.0   0.0         40.0         63.0 14 46 0 0   0     3   0 0 63 0   0     40       63
386089 386089 SC     school 4500001 5209   Department of Corrections 450000101376 5209006 MacDougall High   Alternative School No High 09 12 2021   pk_12_total 5.0 10.0 1.0 0.0   0.0     0.0   0.0 0.0 16.0 0.0   0.0         11.0         16.0 5 10 1 0   0     0   0 0 16 0   0     11       16
386090 386090 SC     school 4500001 5209   Department of Corrections 450000101423 5209009 Wateree River High   Alternative School No High 09 12 2021   pk_12_total 1.0 9.0 0.0 0.0   0.0     0.0   1.0 0.0 11.0 0.0   0.0         8.0         11.0 1 9 0 0   0     0   1 0 11 0   0     8       11
386091 386091 SC     school 4500001 5209   Department of Corrections 450000101378 5209011 Sara Babb High   Alternative School No High 09 12 2021   pk_12_total 4.0 4.0 0.0 0.0   0.0     0.0   0.0 0.0 0.0 8.0   0.0         5.0         8.0 4 4 0 0   0     0   0 0 0 8   0     5       8
386092 386092 SC     school 4500001 5209   Department of Corrections 450000101730 5209017 Allendale   Alternative School No High 09 12 2021   pk_12_total 4.0 12.0 0.0 0.0   0.0     1.0   0.0 0.0 17.0 0.0   0.0         14.0         17.0 4 12 0 0   0     1   0 0 17 0   0     14       17
386093 386093 SC     school 4500001 5209   Department of Corrections 450000101721 5209018 Broad River   Alternative School No High 09 12 2021   pk_12_total 1.0 5.0 0.0 0.0   1.0     0.0   0.0 0.0 7.0 0.0   0.0         4.0         7.0 1 5 0 0   1     0   0 0 7 0   0     4       7
386094 386094 SC     school 4500001 5209   Department of Corrections 450000100063 5209021 Lee High   Alternative School No High 09 12 2021   pk_12_total 1.0 18.0 0.0 0.0   0.0     0.0   0.0 0.0 19.0 0.0   0.0         16.0         19.0 1 18 0 0   0     0   0 0 19 0   0     16       19
386095 386095 SC     school 4500001 5209   Department of Corrections 450000100148 5209022 Trenton High   Alternative School No High 09 12 2021   pk_12_total 1.0 13.0 0.0 0.0   0.0     0.0   0.0 0.0 14.0 0.0   0.0         13.0         14.0 1 13 0 0   0     0   0 0 14 0   0     13       14
386096 386096 SC     school 4500001 5209   Department of Corrections 450000100266 5209023 Ridgeland High   Alternative School No High 09 12 2021   pk_12_total 2.0 9.0 0.0 0.0   0.0     0.0   0.0 0.0 11.0 0.0   0.0         9.0         11.0 2 9 0 0   0     0   0 0 11 0   0     9       11
386097 386097 SC     school 4500001 5209   Department of Corrections 450000100238 5209024 Turbeville High   Alternative School No High 09 12 2021   pk_12_total 26.0 109.0 3.0 0.0   0.0     1.0   1.0 0.0 140.0 0.0   0.0         122.0         140.0 26 109 3 0   0     1   1 0 140 0   0     122       140
368196 368196 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   16.0                                             16
368197 368197 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   pre_kindergarten                                                   0.0                                             0
368198 368198 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   43.0                                             43
368199 368199 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   pre_kindergarten                                                   0.0                                             0
368200 368200 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   pre_kindergarten                                                   14.0                                             14
368201 368201 SC     school 4500002 1804   Dorchester 04 450000201597 1804022 Harleyville-Ridgeville Middle   Regular School No Middle 06 08 2021   pre_kindergarten                                                   0.0                                             0
369416 369416 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   kindergarten                                                   32.0                                             32
369417 369417 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   kindergarten                                                   0.0                                             0
369418 369418 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   kindergarten                                                   78.0                                             78
369419 369419 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   kindergarten                                                   0.0                                             0
369420 369420 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   kindergarten                                                   22.0                                             22
369421 369421 SC     school 4500002 1804   Dorchester 04 450000201597 1804022 Harleyville-Ridgeville Middle   Regular School No Middle 06 08 2021   kindergarten                                                   0.0                                             0
370636 370636 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   grade_1                                                   44.0                                             44
370637 370637 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   grade_1                                                   0.0                                             0
370638 370638 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   grade_1                                                   93.0                                             93
370639 370639 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
370640 370640 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   grade_1                                                   26.0                                             26
370641 370641 SC     school 4500002 1804   Dorchester 04 450000201597 1804022 Harleyville-Ridgeville Middle   Regular School No Middle 06 08 2021   grade_1                                                   0.0                                             0
371856 371856 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   grade_2                                                   29.0                                             29
371857 371857 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   grade_2                                                   0.0                                             0
371858 371858 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   grade_2                                                   79.0                                             79
371859 371859 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
371860 371860 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   grade_2                                                   19.0                                             19
371861 371861 SC     school 4500002 1804   Dorchester 04 450000201597 1804022 Harleyville-Ridgeville Middle   Regular School No Middle 06 08 2021   grade_2                                                   0.0                                             0
373076 373076 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   grade_3                                                   40.0                                             40
373077 373077 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   grade_3                                                   0.0                                             0
373078 373078 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   grade_3                                                   91.0                                             91
373079 373079 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
373080 373080 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   grade_3                                                   21.0                                             21
373081 373081 SC     school 4500002 1804   Dorchester 04 450000201597 1804022 Harleyville-Ridgeville Middle   Regular School No Middle 06 08 2021   grade_3                                                   0.0                                             0
374296 374296 SC     school 4500002 1804   Dorchester 04 450000200435 1804016 Harleyville Elem   Regular School No Elementary PK 05 2021   grade_4                                                   33.0                                             33
374297 374297 SC     school 4500002 1804   Dorchester 04 450000200439 1804017 St. George Middle   Regular School No Middle 06 08 2021   grade_4                                                   0.0                                             0
374298 374298 SC     school 4500002 1804   Dorchester 04 450000200444 1804018 Williams Memorial Elem   Regular School No Elementary PK 05 2021   grade_4                                                   95.0                                             95
374299 374299 SC     school 4500002 1804   Dorchester 04 450000200445 1804019 Woodland High   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
374300 374300 SC     school 4500002 1804   Dorchester 04 450000201600 1804021 Clay Hill Elem   Regular School No Elementary PK 05 2021   grade_4                                                   27.0                                             27

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);