Data source: Big Local News · About: Big Local

4,696 rows where grade = "k_12_total" and state = "SD" sorted by district_nces_id

View and edit SQL

year

grade

  • k_12_total · 4,696
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
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
255954 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   k_12_total 309.0 1.0 18.0 4.0           1.0 3.0   174.0 162.0       0.9               336.0 309 1 18 4           1 3   174 162                 336
255955 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   k_12_total 192.0   16.0 2.0             3.0   111.0 102.0       1.9               213.0 192   16 2             3   111 102                 213
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
363197 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2019   k_12_total 296.0 2.0 18.0 3.0             4.0   171.0 152.0       0.9               323.0 296 2 18 3             4   171 152                 323
363198 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2019   k_12_total 207.0   26.0 2.0             4.0   126.0 113.0       2.5               239.0 207   26 2             4   126 113                 239
455054 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2021   k_12_total 7.0                       1.0 6.0       85.7               7.0 7                       1 6                 7
455055 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   k_12_total 325.0 2.0 52.0 1.0   1.0       1.0 16.0   208.0 190.0       10.1               398.0 325 2 52 1   1       1 16   208 190                 398
455056 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School Not applicable High 09 12 2021   k_12_total 291.0 1.0 27.0 3.0             5.0   164.0 163.0       2.8               327.0 291 1 27 3             5   164 163                 327
455057 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 214.0 4.0 25.0 1.0             11.0   152.0 103.0       4.3               255.0 214 4 25 1             11   152 103                 255
493477 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 6.0                       1.0 5.0       100.0               6.0 6                       1 5                 6
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
493479 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School Not applicable High 09 12 2020   k_12_total 286.0 1.0 30.0 3.0             2.0   170.0 152.0       2.8               322.0 286 1 30 3             2   170 152                 322
493480 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 209.0 2.0 33.0 2.0             6.0   134.0 118.0       6.0               252.0 209 2 33 2             6   134 118                 252
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
2967643 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No 3 09 12 2015   k_12_total 307.0 1.0 13.0 2.0   1.0       1.0 3.0   162.0 166.0                       328.0 307 1 13 2   1       1 3   162 166                 328
2967644 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2015   k_12_total 190.0   11.0 4.0   1.0         3.0   108.0 101.0                       209.0 190   11 4   1         3   108 101                 209
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
3012379 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2017   k_12_total 308.0   19.0 4.0           1.0 3.0   169.0 166.0       1.2               335.0 308   19 4           1 3   169 166                 335
3012380 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2017   k_12_total 202.0   13.0               3.0   114.0 104.0       1.4               218.0 202   13               3   114 104                 218
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
3350243 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No 3 09 12 2016   k_12_total 290.0 1.0 13.0 3.0   4.0       1.0 3.0   150.0 165.0       1.2               315.0 290 1 13 3   4       1 3   150 165                 315
3350244 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2016   k_12_total 203.0   13.0 2.0   1.0         2.0   114.0 107.0       1.4               221.0 203   13 2   1         2   114 107                 221
260305 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   k_12_total 78.0 2.0 3.0 34.0             1.0   61.0 57.0       0.0               118.0 78 2 3 34             1   61 57                 118
260306 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 17.0             3.0   33.0 39.0       0.0               72.0 49   3 17             3   33 39                 72
260307 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   k_12_total 22.0     8.0                 16.0 14.0       0.0               30.0 22     8                 16 14                 30
367564 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2019   k_12_total 80.0 3.0 4.0 33.0             1.0   64.0 57.0       0.8               121.0 80 3 4 33             1   64 57                 121
367565 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2019   k_12_total 47.0   4.0 15.0             2.0   32.0 36.0       0.0               68.0 47   4 15             2   32 36                 68
367566 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2019   k_12_total 19.0   2.0 12.0                 18.0 15.0       0.0               33.0 19   2 12                 18 15                 33
459474 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School Not applicable Elementary PK 05 2021   k_12_total 73.0 2.0 3.0 21.0             2.0   49.0 52.0       0.0               101.0 73 2 3 21             2   49 52                 101
459475 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 42.0   2.0 18.0             2.0   35.0 29.0       0.0               64.0 42   2 18             2   35 29                 64
459476 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Middle School   Regular School Not applicable Middle 06 08 2021   k_12_total 39.0 2.0 1.0 9.0             1.0   32.0 20.0       0.0               52.0 39 2 1 9             1   32 20                 52
497865 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School Not applicable Elementary PK 06 2020   k_12_total 84.0 2.0 3.0 34.0             1.0   62.0 62.0       0.0               124.0 84 2 3 34             1   62 62                 124
497866 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 45.0   2.0 16.0             2.0   27.0 38.0       0.0               65.0 45   2 16             2   27 38                 65
497867 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School Not applicable Middle 07 08 2020   k_12_total 23.0 1.0 2.0 10.0             1.0   23.0 14.0       0.0               37.0 23 1 2 10             1   23 14                 37
2972090 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No 1 PK 05 2015   k_12_total 68.0 1.0 2.0 17.0           1.0 2.0   53.0 38.0                       91.0 68 1 2 17           1 2   53 38                 91
2972091 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2015   k_12_total 53.0 1.0 2.0 15.0             2.0   37.0 36.0                       73.0 53 1 2 15             2   37 36                 73
2972092 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot MS   Regular School No 2 06 08 2015   k_12_total 36.0   2.0 7.0                 26.0 19.0                       45.0 36   2 7                 26 19                 45
3016698 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   k_12_total 66.0 2.0 2.0 25.0             1.0   50.0 46.0       0.0               96.0 66 2 2 25             1   50 46                 96
3016699 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2017   k_12_total 51.0   4.0 18.0             2.0   34.0 41.0       2.7               75.0 51   4 18             2   34 41                 75
3016700 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2017   k_12_total 24.0   1.0 3.0                 16.0 12.0       0.0               28.0 24   1 3                 16 12                 28
3354594 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No 1 PK 05 2016   k_12_total 55.0 1.0 1.0 21.0           1.0 1.0   43.0 37.0       0.0               80.0 55 1 1 21           1 1   43 37                 80
3354595 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2016   k_12_total 54.0   4.0 15.0             2.0   40.0 35.0       2.7               75.0 54   4 15             2   40 35                 75
3354596 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot MS   Regular School No 2 06 08 2016   k_12_total 28.0   2.0 10.0                 22.0 18.0       0.0               40.0 28   2 10                 22 18                 40
254381 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2018   k_12_total 163.0 1.0 6.0 1.0                 95.0 76.0       0.6               171.0 163 1 6 1                 95 76                 171
254382 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2018   k_12_total 99.0 1.0 6.0                   57.0 49.0       0.0               106.0 99 1 6                   57 49                 106
254383 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2018   k_12_total 52.0 3.0 1.0               2.0   33.0 25.0       0.0               58.0 52 3 1               2   33 25                 58
254384 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2018   k_12_total 28.0                       13.0 15.0       71.4               28.0 28                       13 15                 28
361608 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2019   k_12_total 163.0 1.0 8.0 1.0                 97.0 76.0       0.6               173.0 163 1 8 1                 97 76                 173
361609 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2019   k_12_total 89.0 1.0 3.0     1.0         2.0   57.0 39.0       0.0               96.0 89 1 3     1         2   57 39                 96
361610 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2019   k_12_total 57.0 3.0 2.0 1.0                 34.0 29.0       0.0               63.0 57 3 2 1                 34 29                 63
361611 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2019   k_12_total 29.0                       12.0 17.0       41.4               29.0 29                       12 17                 29
453454 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School Not applicable Elementary KG 06 2021   k_12_total 143.0 2.0 4.0 2.0             1.0   81.0 71.0       1.3               152.0 143 2 4 2             1   81 71                 152
453455 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School Not applicable High 09 12 2021   k_12_total 99.0 3.0 2.0               2.0   58.0 48.0       0.0               106.0 99 3 2               2   58 48                 106
453456 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School Not applicable Middle 07 08 2021   k_12_total 48.0   2.0                   28.0 22.0       0.0               50.0 48   2                   28 22                 50
453457 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School Not applicable Elementary KG 08 2021   k_12_total 31.0                       15.0 16.0       35.5               31.0 31                       15 16                 31
491877 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School Not applicable Elementary KG 06 2020   k_12_total 153.0 1.0 7.0 2.0                 85.0 78.0       0.6               163.0 153 1 7 2                 85 78                 163
491878 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School Not applicable High 09 12 2020   k_12_total 106.0 3.0 3.0               2.0   65.0 49.0       0.0               114.0 106 3 3               2   65 49                 114
491879 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School Not applicable Middle 07 08 2020   k_12_total 50.0   1.0 1.0                 27.0 25.0       0.0               52.0 50   1 1                 27 25                 52
491880 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 29.0                       13.0 16.0       41.4               29.0 29                       13 16                 29
2966150 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2015   k_12_total 178.0 3.0 5.0               2.0   105.0 83.0                       188.0 178 3 5               2   105 83                 188
2966151 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No 3 09 12 2015   k_12_total 97.0   4.0                   49.0 52.0                       101.0 97   4                   49 52                 101
2966152 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No 2 07 08 2015   k_12_total 50.0 1.0 1.0                   29.0 23.0                       52.0 50 1 1                   29 23                 52
2966153 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No 1 KG 08 2015   k_12_total 22.0                       8.0 14.0                       22.0 22                       8 14                 22
3010838 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2017   k_12_total 180.0 4.0 3.0                   106.0 81.0       0.0               187.0 180 4 3                   106 81                 187
3010839 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2017   k_12_total 100.0 1.0 4.0                   49.0 56.0       0.0               105.0 100 1 4                   49 56                 105
3010840 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2017   k_12_total 39.0   1.0               2.0   25.0 17.0       0.0               42.0 39   1               2   25 17                 42
3010841 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2017   k_12_total 29.0                       12.0 17.0       62.1               29.0 29                       12 17                 29
3348734 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2016   k_12_total 175.0 4.0 2.0 1.0             2.0   109.0 75.0       0.0               184.0 175 4 2 1             2   109 75                 184
3348735 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No 3 09 12 2016   k_12_total 91.0 1.0 5.0                   46.0 51.0       0.0               97.0 91 1 5                   46 51                 97
3348736 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No 2 07 08 2016   k_12_total 50.0   1.0                   25.0 26.0       0.0               51.0 50   1                   25 26                 51
3348737 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No 1 KG 08 2016   k_12_total 25.0                       9.0 16.0       62.1               25.0 25                       9 16                 25
250065 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   k_12_total 158.0   10.0     1.0       1.0 5.0   89.0 86.0       1.1               175.0 158   10     1       1 5   89 86                 175
250066 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2018   k_12_total 89.0   7.0                   45.0 51.0       2.1               96.0 89   7                   45 51                 96
250067 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2018   k_12_total 34.0   1.0               3.0   18.0 20.0       0.0               38.0 34   1               3   18 20                 38
357308 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2019   k_12_total 177.0   8.0 0.0   1.0         7.0   96.0 97.0       0.5               193.0 177   8 0   1         7   96 97                 193
357309 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2019   k_12_total 78.0   7.0               2.0   42.0 45.0       0.0               87.0 78   7               2   42 45                 87
357310 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2019   k_12_total 51.0   3.0               2.0   28.0 28.0       0.0               56.0 51   3               2   28 28                 56
449170 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2021   k_12_total 183.0   7.0 2.0   1.0         5.0   99.0 99.0       0.5               198.0 183   7 2   1         5   99 99                 198
449171 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School Not applicable High 09 12 2021   k_12_total 89.0   4.0               3.0   44.0 52.0       0.0               96.0 89   4               3   44 52                 96
449172 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School Not applicable Middle 07 08 2021   k_12_total 45.0   3.0               2.0   25.0 25.0       2.0               50.0 45   3               2   25 25                 50
487593 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 181.0   9.0 2.0   1.0         8.0   106.0 95.0       0.5               201.0 181   9 2   1         8   106 95                 201
487594 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School Not applicable High 09 12 2020   k_12_total 73.0   6.0               3.0   39.0 43.0       1.2               82.0 73   6               3   39 43                 82
487595 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School Not applicable Middle 07 08 2020   k_12_total 55.0   4.0               1.0   29.0 31.0       1.7               60.0 55   4               1   29 31                 60
2961866 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2015   k_12_total 146.0 1.0 7.0 2.0           2.0 4.0   77.0 85.0                       162.0 146 1 7 2           2 4   77 85                 162
2961867 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No 3 09 12 2015   k_12_total 83.0   4.0               1.0   45.0 43.0                       88.0 83   4               1   45 43                 88
2961868 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No 2 07 08 2015   k_12_total 33.0   1.0                   18.0 16.0                       34.0 33   1                   18 16                 34
3006490 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2017   k_12_total 152.0   6.0 1.0   1.0         8.0   86.0 82.0       0.6               168.0 152   6 1   1         8   86 82                 168
3006491 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2017   k_12_total 74.0 1.0 3.0     1.0             40.0 39.0       0.0               79.0 74 1 3     1             40 39                 79
3006492 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2017   k_12_total 45.0   3.0               2.0   24.0 26.0       0.0               50.0 45   3               2   24 26                 50
3344418 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2016   k_12_total 140.0 1.0 5.0 2.0             5.0   75.0 78.0       0.6               153.0 140 1 5 2             5   75 78                 153
3344419 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No 3 09 12 2016   k_12_total 84.0 1.0 1.0                   44.0 42.0       0.0               86.0 84 1 1                   44 42                 86
3344420 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No 2 07 08 2016   k_12_total 37.0   2.0 1.0                 22.0 18.0       0.0               40.0 37   2 1                 22 18                 40
252161 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   k_12_total 220.0 2.0 16.0 5.0           1.0     134.0 110.0       1.2               244.0 220 2 16 5           1     134 110                 244
252162 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2018   k_12_total 105.0 1.0 3.0                   53.0 56.0       0.0               109.0 105 1 3                   53 56                 109
252163 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2018   k_12_total 130.0   3.0             1.0     71.0 63.0       0.8               134.0 130   3             1     71 63                 134
359420 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2019   k_12_total 226.0 2.0 14.0 10.0           1.0     144.0 109.0       1.2               253.0 226 2 14 10           1     144 109                 253
359421 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2019   k_12_total 117.0 1.0 4.0 1.0                 62.0 61.0       0.0               123.0 117 1 4 1                 62 61                 123
359422 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2019   k_12_total 131.0   3.0 1.0                 70.0 65.0       0.7               135.0 131   3 1                 70 65                 135
451266 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 212.0 2.0 13.0 2.0             4.0   144.0 89.0       0.4               233.0 212 2 13 2             4   144 89                 233

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