Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • pk_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
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
255960 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2018   pk_12_total 309.0 1.0 18.0 4.0           1.0 3.0   174.0 162.0                       336.0 309 1 18 4           1 3   174 162                 336
255961 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2018   pk_12_total 192.0   16.0 2.0             3.0   111.0 102.0                       213.0 192   16 2             3   111 102                 213
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
363203 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2019   pk_12_total 296.0 2.0 18.0 3.0             4.0   171.0 152.0                       323.0 296 2 18 3             4   171 152                 323
363204 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2019   pk_12_total 207.0   26.0 2.0             4.0   126.0 113.0                       239.0 207   26 2             4   126 113                 239
455062 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2021   pk_12_total 7.0                       1.0 6.0                       7.0 7                       1 6                 7
455063 SD     school 4600002 25004   Milbank 25-4 460000200423 3 Milbank Elementary School   Regular School Not applicable Elementary PK 05 2021   pk_12_total 341.0 2.0 54.0 1.0   1.0       1.0 16.0   218.0 198.0                       416.0 341 2 54 1   1       1 16   218 198                 416
455064 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School Not applicable High 09 12 2021   pk_12_total 291.0 1.0 27.0 3.0             5.0   164.0 163.0                       327.0 291 1 27 3             5   164 163                 327
455065 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 214.0 4.0 25.0 1.0             11.0   152.0 103.0                       255.0 214 4 25 1             11   152 103                 255
493485 SD     school 4600002 25004   Milbank 25-4 460000201390 4 Blue Sky Colony   Regular School Not applicable Elementary KG 08 2020   pk_12_total 6.0                       1.0 5.0                       6.0 6                       1 5                 6
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
493487 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School Not applicable High 09 12 2020   pk_12_total 286.0 1.0 30.0 3.0             2.0   170.0 152.0                       322.0 286 1 30 3             2   170 152                 322
493488 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School Not applicable Middle 06 08 2020   pk_12_total 209.0 2.0 33.0 2.0             6.0   134.0 118.0                       252.0 209 2 33 2             6   134 118                 252
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
2967649 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No 3 09 12 2015   pk_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
2967650 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2015   pk_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
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
3012385 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No High 09 12 2017   pk_12_total 308.0   19.0 4.0           1.0 3.0   169.0 166.0                       335.0 308   19 4           1 3   169 166                 335
3012386 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No Middle 06 08 2017   pk_12_total 202.0   13.0               3.0   114.0 104.0                       218.0 202   13               3   114 104                 218
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
3350249 SD     school 4600002 25004   Milbank 25-4 460000200424 1 Milbank High School   Regular School No 3 09 12 2016   pk_12_total 290.0 1.0 13.0 3.0   4.0       1.0 3.0   150.0 165.0                       315.0 290 1 13 3   4       1 3   150 165                 315
3350250 SD     school 4600002 25004   Milbank 25-4 460000200425 2 Milbank Middle School   Regular School No 2 06 08 2016   pk_12_total 203.0   13.0 2.0   1.0         2.0   114.0 107.0                       221.0 203   13 2   1         2   114 107                 221
260311 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2018   pk_12_total 91.0 4.0 3.0 35.0             1.0   70.0 64.0                       134.0 91 4 3 35             1   70 64                 134
260312 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2018   pk_12_total 49.0   3.0 17.0             3.0   33.0 39.0                       72.0 49   3 17             3   33 39                 72
260313 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2018   pk_12_total 22.0     8.0                 16.0 14.0                       30.0 22     8                 16 14                 30
367570 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2019   pk_12_total 92.0 3.0 4.0 34.0             1.0   70.0 64.0                       134.0 92 3 4 34             1   70 64                 134
367571 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2019   pk_12_total 47.0   4.0 15.0             2.0   32.0 36.0                       68.0 47   4 15             2   32 36                 68
367572 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2019   pk_12_total 19.0   2.0 12.0                 18.0 15.0                       33.0 19   2 12                 18 15                 33
459480 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School Not applicable Elementary PK 05 2021   pk_12_total 87.0 2.0 3.0 22.0             2.0   56.0 60.0                       116.0 87 2 3 22             2   56 60                 116
459481 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 42.0   2.0 18.0             2.0   35.0 29.0                       64.0 42   2 18             2   35 29                 64
459482 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Middle School   Regular School Not applicable Middle 06 08 2021   pk_12_total 39.0 2.0 1.0 9.0             1.0   32.0 20.0                       52.0 39 2 1 9             1   32 20                 52
497871 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School Not applicable Elementary PK 06 2020   pk_12_total 95.0 2.0 3.0 36.0             1.0   69.0 68.0                       137.0 95 2 3 36             1   69 68                 137
497872 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 45.0   2.0 16.0             2.0   27.0 38.0                       65.0 45   2 16             2   27 38                 65
497873 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School Not applicable Middle 07 08 2020   pk_12_total 23.0 1.0 2.0 10.0             1.0   23.0 14.0                       37.0 23 1 2 10             1   23 14                 37
2972096 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No 1 PK 05 2015   pk_12_total 74.0 1.0 2.0 20.0           1.0 2.0   55.0 45.0                       100.0 74 1 2 20           1 2   55 45                 100
2972097 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2015   pk_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
2972098 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot MS   Regular School No 2 06 08 2015   pk_12_total 36.0   2.0 7.0                 26.0 19.0                       45.0 36   2 7                 26 19                 45
3016704 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No Elementary PK 06 2017   pk_12_total 84.0 2.0 3.0 25.0             1.0   57.0 58.0                       115.0 84 2 3 25             1   57 58                 115
3016705 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No High 09 12 2017   pk_12_total 51.0   4.0 18.0             2.0   34.0 41.0                       75.0 51   4 18             2   34 41                 75
3016706 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot Jr. High   Regular School No Middle 07 08 2017   pk_12_total 24.0   1.0 3.0                 16.0 12.0                       28.0 24   1 3                 16 12                 28
3354600 SD     school 4600003 54007   Wilmot 54-7 460000300757 2 Wilmot Elem   Regular School No 1 PK 05 2016   pk_12_total 64.0 1.0 1.0 23.0           1.0 1.0   46.0 45.0                       91.0 64 1 1 23           1 1   46 45                 91
3354601 SD     school 4600003 54007   Wilmot 54-7 460000300758 1 Wilmot Hi Sch   Regular School No 3 09 12 2016   pk_12_total 54.0   4.0 15.0             2.0   40.0 35.0                       75.0 54   4 15             2   40 35                 75
3354602 SD     school 4600003 54007   Wilmot 54-7 460000300872 3 Wilmot MS   Regular School No 2 06 08 2016   pk_12_total 28.0   2.0 10.0                 22.0 18.0                       40.0 28   2 10                 22 18                 40
254389 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2018   pk_12_total 163.0 1.0 6.0 1.0                 95.0 76.0                       171.0 163 1 6 1                 95 76                 171
254390 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2018   pk_12_total 99.0 1.0 6.0                   57.0 49.0                       106.0 99 1 6                   57 49                 106
254391 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2018   pk_12_total 52.0 3.0 1.0               2.0   33.0 25.0                       58.0 52 3 1               2   33 25                 58
254392 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2018   pk_12_total 28.0                       13.0 15.0                       28.0 28                       13 15                 28
361616 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2019   pk_12_total 163.0 1.0 8.0 1.0                 97.0 76.0                       173.0 163 1 8 1                 97 76                 173
361617 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2019   pk_12_total 89.0 1.0 3.0     1.0         2.0   57.0 39.0                       96.0 89 1 3     1         2   57 39                 96
361618 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2019   pk_12_total 57.0 3.0 2.0 1.0                 34.0 29.0                       63.0 57 3 2 1                 34 29                 63
361619 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2019   pk_12_total 29.0                       12.0 17.0                       29.0 29                       12 17                 29
453462 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School Not applicable Elementary KG 06 2021   pk_12_total 143.0 2.0 4.0 2.0             1.0   81.0 71.0                       152.0 143 2 4 2             1   81 71                 152
453463 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School Not applicable High 09 12 2021   pk_12_total 99.0 3.0 2.0               2.0   58.0 48.0                       106.0 99 3 2               2   58 48                 106
453464 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School Not applicable Middle 07 08 2021   pk_12_total 48.0   2.0                   28.0 22.0                       50.0 48   2                   28 22                 50
453465 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School Not applicable Elementary KG 08 2021   pk_12_total 31.0                       15.0 16.0                       31.0 31                       15 16                 31
491885 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School Not applicable Elementary KG 06 2020   pk_12_total 153.0 1.0 7.0 2.0                 85.0 78.0                       163.0 153 1 7 2                 85 78                 163
491886 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School Not applicable High 09 12 2020   pk_12_total 106.0 3.0 3.0               2.0   65.0 49.0                       114.0 106 3 3               2   65 49                 114
491887 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School Not applicable Middle 07 08 2020   pk_12_total 50.0   1.0 1.0                 27.0 25.0                       52.0 50   1 1                 27 25                 52
491888 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School Not applicable Elementary KG 08 2020   pk_12_total 29.0                       13.0 16.0                       29.0 29                       13 16                 29
2966158 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2015   pk_12_total 178.0 3.0 5.0               2.0   105.0 83.0                       188.0 178 3 5               2   105 83                 188
2966159 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No 3 09 12 2015   pk_12_total 97.0   4.0                   49.0 52.0                       101.0 97   4                   49 52                 101
2966160 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No 2 07 08 2015   pk_12_total 50.0 1.0 1.0                   29.0 23.0                       52.0 50 1 1                   29 23                 52
2966161 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No 1 KG 08 2015   pk_12_total 22.0                       8.0 14.0                       22.0 22                       8 14                 22
3010846 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No Elementary KG 06 2017   pk_12_total 180.0 4.0 3.0                   106.0 81.0                       187.0 180 4 3                   106 81                 187
3010847 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No High 09 12 2017   pk_12_total 100.0 1.0 4.0                   49.0 56.0                       105.0 100 1 4                   49 56                 105
3010848 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No Middle 07 08 2017   pk_12_total 39.0   1.0               2.0   25.0 17.0                       42.0 39   1               2   25 17                 42
3010849 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No Elementary KG 08 2017   pk_12_total 29.0                       12.0 17.0                       29.0 29                       12 17                 29
3348742 SD     school 4600025 48003   Howard 48-3 460002500304 2 Howard Elem   Regular School No 1 KG 06 2016   pk_12_total 175.0 4.0 2.0 1.0             2.0   109.0 75.0                       184.0 175 4 2 1             2   109 75                 184
3348743 SD     school 4600025 48003   Howard 48-3 460002500305 1 Howard Hi Sch   Regular School No 3 09 12 2016   pk_12_total 91.0 1.0 5.0                   46.0 51.0                       97.0 91 1 5                   46 51                 97
3348744 SD     school 4600025 48003   Howard 48-3 460002500913 5 Howard Jr Hi   Regular School No 2 07 08 2016   pk_12_total 50.0   1.0                   25.0 26.0                       51.0 50   1                   25 26                 51
3348745 SD     school 4600025 48003   Howard 48-3 460002501161 8 Shannon Colony   Regular School No 1 KG 08 2016   pk_12_total 25.0                       9.0 16.0                       25.0 25                       9 16                 25
250071 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2018   pk_12_total 209.0   13.0     1.0       1.0 6.0   124.0 106.0                       230.0 209   13     1       1 6   124 106                 230
250072 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2018   pk_12_total 89.0   7.0                   45.0 51.0                       96.0 89   7                   45 51                 96
250073 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2018   pk_12_total 34.0   1.0               3.0   18.0 20.0                       38.0 34   1               3   18 20                 38
357314 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2019   pk_12_total 224.0   8.0 1.0   1.0         9.0   124.0 119.0                       243.0 224   8 1   1         9   124 119                 243
357315 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2019   pk_12_total 78.0   7.0               2.0   42.0 45.0                       87.0 78   7               2   42 45                 87
357316 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2019   pk_12_total 51.0   3.0               2.0   28.0 28.0                       56.0 51   3               2   28 28                 56
449176 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2021   pk_12_total 207.0   7.0 2.0   1.0         5.0   112.0 110.0                       222.0 207   7 2   1         5   112 110                 222
449177 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School Not applicable High 09 12 2021   pk_12_total 89.0   4.0               3.0   44.0 52.0                       96.0 89   4               3   44 52                 96
449178 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School Not applicable Middle 07 08 2021   pk_12_total 45.0   3.0               2.0   25.0 25.0                       50.0 45   3               2   25 25                 50
487599 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School Not applicable Elementary PK 06 2020   pk_12_total 225.0   10.0 2.0   1.0         8.0   128.0 118.0                       246.0 225   10 2   1         8   128 118                 246
487600 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School Not applicable High 09 12 2020   pk_12_total 73.0   6.0               3.0   39.0 43.0                       82.0 73   6               3   39 43                 82
487601 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School Not applicable Middle 07 08 2020   pk_12_total 55.0   4.0               1.0   29.0 31.0                       60.0 55   4               1   29 31                 60
2961872 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2015   pk_12_total 186.0 1.0 8.0 2.0           2.0 8.0   104.0 103.0                       207.0 186 1 8 2           2 8   104 103                 207
2961873 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No 3 09 12 2015   pk_12_total 83.0   4.0               1.0   45.0 43.0                       88.0 83   4               1   45 43                 88
2961874 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No 2 07 08 2015   pk_12_total 33.0   1.0                   18.0 16.0                       34.0 33   1                   18 16                 34
3006496 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No Elementary PK 06 2017   pk_12_total 202.0   10.0 1.0   1.0         9.0   106.0 117.0                       223.0 202   10 1   1         9   106 117                 223
3006497 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No High 09 12 2017   pk_12_total 74.0 1.0 3.0     1.0             40.0 39.0                       79.0 74 1 3     1             40 39                 79
3006498 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No Middle 07 08 2017   pk_12_total 45.0   3.0               2.0   24.0 26.0                       50.0 45   3               2   24 26                 50
3344424 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800013 4 Alcester-Hudson Elementary   Regular School No 1 PK 06 2016   pk_12_total 193.0 1.0 7.0 2.0             9.0   104.0 108.0                       212.0 193 1 7 2             9   104 108                 212
3344425 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800014 1 Alcester-Hudson High School   Regular School No 3 09 12 2016   pk_12_total 84.0 1.0 1.0                   44.0 42.0                       86.0 84 1 1                   44 42                 86
3344426 SD     school 4600028 61001   Alcester-Hudson 61-1 460002800874 3 Alcester-Hudson JH   Regular School No 2 07 08 2016   pk_12_total 37.0   2.0 1.0                 22.0 18.0                       40.0 37   2 1                 22 18                 40
252167 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2018   pk_12_total 257.0 2.0 16.0 6.0           1.0     157.0 125.0                       282.0 257 2 16 6           1     157 125                 282
252168 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2018   pk_12_total 105.0 1.0 3.0                   53.0 56.0                       109.0 105 1 3                   53 56                 109
252169 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2018   pk_12_total 130.0   3.0             1.0     71.0 63.0                       134.0 130   3             1     71 63                 134
359426 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School No Elementary PK 05 2019   pk_12_total 250.0 3.0 15.0 10.0           1.0     161.0 118.0                       279.0 250 3 15 10           1     161 118                 279
359427 SD     school 4600036 19004   Deuel 19-4 460003601013 4 Clear Lake Middle School   Regular School No Middle 06 08 2019   pk_12_total 117.0 1.0 4.0 1.0                 62.0 61.0                       123.0 117 1 4 1                 62 61                 123
359428 SD     school 4600036 19004   Deuel 19-4 460003601010 1 Deuel High School   Regular School No High 09 12 2019   pk_12_total 131.0   3.0 1.0                 70.0 65.0                       135.0 131   3 1                 70 65                 135
451272 SD     school 4600036 19004   Deuel 19-4 460003601011 2 Clear Lake Elementary   Regular School Not applicable Elementary PK 05 2021   pk_12_total 237.0 2.0 14.0 2.0             4.0   162.0 97.0                       259.0 237 2 14 2             4   162 97                 259

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