enrollments

Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2967606 2967606 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_1 57.0 2.0 5.0               2.0   36.0 30.0                       66.0 57 2 5               2   36 30                 66
2967609 2967609 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_10 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967612 2967612 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_11 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967615 2967615 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_12 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967618 2967618 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_2 60.0 1.0 6.0               2.0   42.0 27.0                       69.0 60 1 6               2   42 27                 69
2967621 2967621 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_3 52.0 0.0 2.0               2.0   29.0 27.0                       56.0 52 0 2               2   29 27                 56
2967624 2967624 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_4 57.0 0.0 4.0               0.0   34.0 27.0                       61.0 57 0 4               0   34 27                 61
2967627 2967627 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_5 49.0 0.0 3.0               1.0   28.0 25.0                       53.0 49 0 3               1   28 25                 53
2967630 2967630 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_6 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967633 2967633 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_7 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967636 2967636 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_8 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967639 2967639 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   grade_9 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
2967642 2967642 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   k_12_total 339.0 4.0 25.0               8.0   213.0 163.0                       376.0 339 4 25               8   213 163                 376
2967645 2967645 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   kindergarten 64.0 1.0 5.0               1.0   44.0 27.0                       71.0 64 1 5               1   44 27                 71
2967648 2967648 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   pk_12_total 339.0 4.0 25.0               8.0   213.0 163.0                       376.0 339 4 25               8   213 163                 376
2967651 2967651 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2015   pre_kindergarten 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350206 3350206 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_1 55.0 2.0 2.0               1.0   36.0 24.0                       60.0 55 2 2               1   36 24                 60
3350209 3350209 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_10 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350212 3350212 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_11 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350215 3350215 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_12 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350218 3350218 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_2 57.0 2.0 6.0               2.0   37.0 30.0                       67.0 57 2 6               2   37 30                 67
3350221 3350221 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_3 63.0 1.0 5.0               1.0   44.0 26.0                       70.0 63 1 5               1   44 26                 70
3350224 3350224 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_4 49.0 0.0 5.0               1.0   25.0 30.0                       55.0 49 0 5               1   25 30                 55
3350227 3350227 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_5 57.0 0.0 5.0               0.0   35.0 27.0                       62.0 57 0 5               0   35 27                 62
3350230 3350230 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_6 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350233 3350233 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_7 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350236 3350236 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_8 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350239 3350239 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   grade_9 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3350242 3350242 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   k_12_total 334.0 6.0 27.0               7.0   209.0 165.0       3.4               374.0 334 6 27               7   209 165                 374
3350245 3350245 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   kindergarten 53.0 1.0 4.0               2.0   32.0 28.0                       60.0 53 1 4               2   32 28                 60
3350248 3350248 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   pk_12_total 334.0 6.0 27.0               7.0   209.0 165.0                       374.0 334 6 27               7   209 165                 374
3350251 3350251 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No 1 KG 05 2016   pre_kindergarten 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012342 3012342 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_1 40.0 1.0 4.0               3.0   27.0 21.0                       48.0 40 1 4               3   27 21                 48
3012345 3012345 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_10 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012348 3012348 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_11 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012351 3012351 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_12 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012354 3012354 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_2 56.0 2.0 3.0               2.0   35.0 28.0                       63.0 56 2 3               2   35 28                 63
3012357 3012357 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_3 56.0 2.0 6.0               2.0   38.0 28.0                       66.0 56 2 6               2   38 28                 66
3012360 3012360 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_4 64.0 1.0 3.0               1.0   44.0 25.0                       69.0 64 1 3               1   44 25                 69
3012363 3012363 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_5 52.0 0.0 6.0               2.0   28.0 32.0                       60.0 52 0 6               2   28 32                 60
3012366 3012366 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_6 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012369 3012369 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_7 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012372 3012372 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_8 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012375 3012375 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   grade_9 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
3012378 3012378 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   k_12_total 335.0 6.0 25.0               12.0   205.0 173.0       3.4               378.0 335 6 25               12   205 173                 378
3012381 3012381 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   kindergarten 67.0 0.0 3.0               2.0   33.0 39.0                       72.0 67 0 3               2   33 39                 72
3012384 3012384 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   pk_12_total 335.0 6.0 25.0               12.0   205.0 173.0                       378.0 335 6 25               12   205 173                 378
3012387 3012387 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2017   pre_kindergarten 0.0 0.0 0.0               0.0   0.0 0.0                       0.0 0 0 0               0   0 0                 0
255917 255917 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_1 57.0 0.0 4.0 0.0             2.0   28.0 35.0                       63.0 57 0 4 0             2   28 35                 63
255920 255920 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_10 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255923 255923 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_11 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255926 255926 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_12 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255929 255929 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_2 44.0 1.0 6.0 0.0             2.0   31.0 22.0                       53.0 44 1 6 0             2   31 22                 53
255932 255932 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_3 61.0 2.0 4.0 0.0             4.0   42.0 29.0                       71.0 61 2 4 0             4   42 29                 71
255935 255935 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_4 61.0 2.0 8.0 0.0             3.0   44.0 30.0                       74.0 61 2 8 0             3   44 30                 74
255938 255938 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_5 63.0 0.0 4.0 1.0             1.0   43.0 26.0                       69.0 63 0 4 1             1   43 26                 69
255941 255941 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_6 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255944 255944 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_7 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255947 255947 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_8 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255950 255950 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   grade_9 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
255953 255953 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   k_12_total 353.0 6.0 36.0 1.0             12.0   224.0 184.0       6.1               408.0 353 6 36 1             12   224 184                 408
255956 255956 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   kindergarten 67.0 1.0 10.0 0.0             0.0   36.0 42.0                       78.0 67 1 10 0             0   36 42                 78
255959 255959 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   pk_12_total 353.0 6.0 36.0 1.0             12.0   224.0 184.0                       408.0 353 6 36 1             12   224 184                 408
255962 255962 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary KG 05 2018   pre_kindergarten 0.0 0.0 0.0 0.0             0.0   0.0 0.0                       0.0 0 0 0 0             0   0 0                 0
363160 363160 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_1 56.0 1.0 11.0 0.0   0.0         1.0   30.0 39.0                       69.0 56 1 11 0   0         1   30 39                 69
363163 363163 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_10 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363166 363166 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_11 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363169 363169 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_12 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363172 363172 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_2 57.0 0.0 6.0 0.0   0.0         3.0   32.0 34.0                       66.0 57 0 6 0   0         3   32 34                 66
363175 363175 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_3 45.0 1.0 6.0 1.0   0.0         1.0   30.0 24.0                       54.0 45 1 6 1   0         1   30 24                 54
363178 363178 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_4 61.0 2.0 7.0 1.0   0.0         5.0   46.0 30.0                       76.0 61 2 7 1   0         5   46 30                 76
363181 363181 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_5 66.0 2.0 11.0 1.0   0.0         2.0   45.0 37.0                       82.0 66 2 11 1   0         2   45 37                 82
363184 363184 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_6 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363187 363187 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363190 363190 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_8 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363193 363193 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   grade_9 0.0 0.0 0.0 0.0   0.0         0.0   0.0 0.0                       0.0 0 0 0 0   0         0   0 0                 0
363196 363196 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   k_12_total 355.0 6.0 47.0 5.0   1.0         15.0   226.0 203.0       5.8               429.0 355 6 47 5   1         15   226 203                 429
363199 363199 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   kindergarten 70.0 0.0 6.0 2.0   1.0         3.0   43.0 39.0                       82.0 70 0 6 2   1         3   43 39                 82
363202 363202 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   pk_12_total 368.0 6.0 51.0 6.0   1.0         15.0   237.0 210.0                       447.0 368 6 51 6   1         15   237 210                 447
363205 363205 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 13.0 0.0 4.0 1.0   0.0         0.0   11.0 7.0                       18.0 13 0 4 1   0         0   11 7                 18
493430 493430 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_1 51.0 0.0 5.0 1.0   1.0       0.0 2.0   26.0 34.0                       60.0 51 0 5 1   1       0 2   26 34                 60
493434 493434 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493438 493438 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493442 493442 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493446 493446 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_2 54.0 1.0 14.0 0.0   0.0       0.0 2.0   29.0 42.0                       71.0 54 1 14 0   0       0 2   29 42                 71
493450 493450 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_3 55.0 0.0 6.0 0.0   0.0       0.0 4.0   33.0 32.0                       65.0 55 0 6 0   0       0 4   33 32                 65
493454 493454 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_4 42.0 1.0 8.0 1.0   0.0       0.0 2.0   32.0 22.0                       54.0 42 1 8 1   0       0 2   32 22                 54
493458 493458 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_5 61.0 2.0 7.0 1.0   0.0       0.0 6.0   46.0 31.0                       77.0 61 2 7 1   0       0 6   46 31                 77
493462 493462 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_6 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493466 493466 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_7 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493470 493470 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_8 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493474 493474 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   grade_9 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
493478 493478 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 337.0 4.0 54.0 3.0   1.0       0.0 18.0   221.0 196.0       8.9               417.0 337 4 54 3   1       0 18   221 196                 417
493482 493482 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   kindergarten 74.0 0.0 14.0 0.0   0.0       0.0 2.0   55.0 35.0                       90.0 74 0 14 0   0       0 2   55 35                 90
493486 493486 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   pk_12_total 348.0 5.0 57.0 5.0   1.0       1.0 19.0   230.0 206.0                       436.0 348 5 57 5   1       1 19   230 206                 436
493490 493490 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Koch Elementary   Regular School Not applicable Elementary PK 05 2020   pre_kindergarten 11.0 1.0 3.0 2.0   0.0       1.0 1.0   9.0 10.0                       19.0 11 1 3 2   0       1 1   9 10                 19
455007 455007 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   grade_1 56.0 0.0 13.0 0.0   0.0       0.0 1.0   42.0 28.0                       70.0 56 0 13 0   0       0 1   42 28                 70
455011 455011 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   grade_10 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
455015 455015 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   grade_11 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0
455019 455019 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   grade_12 0.0 0.0 0.0 0.0   0.0       0.0 0.0   0.0 0.0                       0.0 0 0 0 0   0       0 0   0 0                 0

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]);