enrollments

Data source: Big Local News · About: Big Local

671 rows where grade = "k_12_total", state = "SD" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 671 ✖

grade ✖

  • k_12_total · 671 ✖
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
254049 254049 SD     school 4632430 10001   Herreid 10-1 463243000277 2 Herreid Elem   Regular School No Elementary KG 05 2018   k_12_total 45.0     1.0             1.0   26.0 21.0       0.0               47.0 45     1             1   26 21                 47
254050 254050 SD     school 4632430 10001   Herreid 10-1 463243000278 1 Herreid Hi Sch   Regular School No High 09 12 2018   k_12_total 41.0   1.0 1.0                 21.0 22.0       0.0               43.0 41   1 1                 21 22                 43
254051 254051 SD     school 4632430 10001   Herreid 10-1 463243000910 3 Herreid Middle Sch   Regular School No Middle 06 08 2018   k_12_total 16.0   1.0 1.0             1.0   13.0 6.0       0.0               19.0 16   1 1             1   13 6                 19
256953 256953 SD     school 4655710 1001   Plankinton 01-1 465571001274 5 Aurora Plains Academy High School   Alternative School No High 09 12 2018   k_12_total 18.0 5.0 3.0 15.0             4.0   25.0 20.0       2.2               45.0 18 5 3 15             4   25 20                 45
256954 256954 SD     school 4655710 1001   Plankinton 01-1 465571001276 4 Aurora Plains Academy Middle School   Alternative School No Middle 04 08 2018   k_12_total 13.0 4.0 2.0 6.0                 22.0 3.0       0.0               25.0 13 4 2 6                 22 3                 25
256955 256955 SD     school 4655710 1001   Plankinton 01-1 465571000507 2 Plankinton Elementary   Regular School No Elementary PK 06 2018   k_12_total 112.0 1.0 30.0 5.0                 80.0 68.0       11.5               148.0 112 1 30 5                 80 68                 148
256956 256956 SD     school 4655710 1001   Plankinton 01-1 465571000508 1 Plankinton High School   Regular School No High 09 12 2018   k_12_total 61.0   14.0                   40.0 35.0       5.3               75.0 61   14                   40 35                 75
256957 256957 SD     school 4655710 1001   Plankinton 01-1 465571000927 3 Plankinton Junior High   Regular School No Middle 07 08 2018   k_12_total 27.0   10.0                   19.0 18.0       5.4               37.0 27   10                   19 18                 37
260097 260097 SD     school 4678510 1003   White Lake 01-3 467851000745 2 White Lake Elementary   Regular School No Elementary PK 06 2018   k_12_total 58.0 1.0 4.0             1.0     38.0 26.0       0.0               64.0 58 1 4             1     38 26                 64
260098 260098 SD     school 4678510 1003   White Lake 01-3 467851000746 1 White Lake High School   Regular School No High 09 12 2018   k_12_total 28.0   4.0                   18.0 14.0       0.0               32.0 28   4                   18 14                 32
260099 260099 SD     school 4678510 1003   White Lake 01-3 467851000950 3 White Lake JH   Regular School No Middle 07 08 2018   k_12_total 16.0 1.0 2.0                   10.0 9.0       0.0               19.0 16 1 2                   10 9                 19
250137 250137 SD     school 4639540 11001   Andes Central 11-1 463954000359 2 Andes Central Elementary   Regular School No Elementary PK 06 2018   k_12_total 34.0   8.0 93.0             21.0   72.0 84.0       0.0               156.0 34   8 93             21   72 84                 156
250138 250138 SD     school 4639540 11001   Andes Central 11-1 463954000360 1 Andes Central High School   Regular School No High 09 12 2018   k_12_total 8.0     49.0             5.0   37.0 25.0       0.0               62.0 8     49             5   37 25                 62
250139 250139 SD     school 4639540 11001   Andes Central 11-1 463954000850 4 Andes Central Jr High   Regular School No Middle 07 08 2018   k_12_total 5.0   4.0 28.0             5.0   26.0 16.0       0.0               42.0 5   4 28             5   26 16                 42
250140 250140 SD     school 4639540 11001   Andes Central 11-1 463954001080 5 Lakeview Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 30.0                       10.0 20.0       36.7               30.0 30                       10 20                 30
250141 250141 SD     school 4639540 11001   Andes Central 11-1 463954001379 6 Pease Creek Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 26.0                       13.0 13.0       50.0               26.0 26                       13 13                 26
259517 259517 SD     school 4675420 11004   Wagner Community 11-4 467542000694 2 Wagner Elementary School   Regular School No Elementary 01 04 2018   k_12_total 77.0   15.0 179.0             37.0   163.0 145.0       0.3               308.0 77   15 179             37   163 145                 308
259518 259518 SD     school 4675420 11004   Wagner Community 11-4 467542000695 1 Wagner High School   Regular School No High 09 12 2018   k_12_total 62.0   7.0 99.0             14.0   83.0 99.0       0.0               182.0 62   7 99             14   83 99                 182
259519 259519 SD     school 4675420 11004   Wagner Community 11-4 467542000942 3 Wagner Middle School   Regular School No Middle 05 08 2018   k_12_total 64.0   9.0 159.0   1.0         26.0   128.0 131.0       0.0               259.0 64   9 159   1         26   128 131                 259
259520 259520 SD     school 4675420 11004   Wagner Community 11-4 467542001278 4 Wagner Primary School   Regular School No Elementary PK KG 2018   k_12_total 26.0   5.0 58.0             9.0   54.0 44.0       0.0               98.0 26   5 58             9   54 44                 98
257033 257033 SD     school 4680438 11005   Platte-Geddes 11-5 468043801252 14 Cedar Grove Colony School   Regular School No Elementary KG 08 2018   k_12_total 42.0                       15.0 27.0       42.9               42.0 42                       15 27                 42
257034 257034 SD     school 4680438 11005   Platte-Geddes 11-5 468043801267 10 Platte Colony School   Regular School No Elementary KG 08 2018   k_12_total 28.0                       15.0 13.0       39.3               28.0 28                       15 13                 28
257035 257035 SD     school 4680438 11005   Platte-Geddes 11-5 468043801244 2 Platte-Geddes Elem   Regular School No Elementary KG 06 2018   k_12_total 211.0 1.0 3.0 13.0             19.0   119.0 128.0       0.0               247.0 211 1 3 13             19   119 128                 247
257036 257036 SD     school 4680438 11005   Platte-Geddes 11-5 468043801248 1 Platte-Geddes H.S   Regular School No High 09 12 2018   k_12_total 112.0   3.0 1.0             4.0   59.0 61.0       0.0               120.0 112   3 1             4   59 61                 120
257037 257037 SD     school 4680438 11005   Platte-Geddes 11-5 468043801250 3 Platte-Geddes Jr. Hi   Regular School No Middle 07 08 2018   k_12_total 58.0 1.0   3.0             3.0   33.0 32.0       1.5               65.0 58 1   3             3   33 32                 65
251637 251637 SD     school 4612940 12002   Clark 12-2 461294000132 2 Clark Elementary School   Regular School No Elementary PK 04 2018   k_12_total 99.0 1.0 10.0               4.0   63.0 51.0       4.4               114.0 99 1 10               4   63 51                 114
251638 251638 SD     school 4612940 12002   Clark 12-2 461294000133 1 Clark High School   Regular School No High 09 12 2018   k_12_total 53.0 2.0 4.0     1.0       1.0     29.0 32.0       1.6               61.0 53 2 4     1       1     29 32                 61
251639 251639 SD     school 4612940 12002   Clark 12-2 461294000890 3 Clark Middle School   Regular School No Middle 05 08 2018   k_12_total 71.0 2.0 5.0                   45.0 33.0       2.6               78.0 71 2 5                   45 33                 78
251640 251640 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 29.0                       8.0 21.0       72.4               29.0 29                       8 21                 29
251641 251641 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 29.0                       17.0 12.0       75.9               29.0 29                       17 12                 29
251642 251642 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2018   k_12_total 43.0                       24.0 19.0       72.1               43.0 43                       24 19                 43
260245 260245 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 22.0                       12.0 10.0       54.6               22.0 22                       12 10                 22
260246 260246 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 16.0                       6.0 10.0       50.0               16.0 16                       6 10                 16
260247 260247 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2018   k_12_total 13.0                       6.0 7.0       53.9               13.0 13                       6 7                 13
260248 260248 SD     school 4679350 12003   Willow Lake 12-3 467935000755 2 Willow Lake Elem   Regular School No Elementary PK 05 2018   k_12_total 86.0 0.0 5.0 3.0                 37.0 57.0       2.1               94.0 86 0 5 3                 37 57                 94
260249 260249 SD     school 4679350 12003   Willow Lake 12-3 467935000756 1 Willow Lake Hi Sch   Regular School No High 09 12 2018   k_12_total 49.0   3.0 1.0                 29.0 24.0       0.0               53.0 49   3 1                 29 24                 53
260250 260250 SD     school 4679350 12003   Willow Lake 12-3 467935000952 3 Willow Lake Middle School   Regular School No Middle 06 08 2018   k_12_total 34.0 1.0 2.0 2.0                 24.0 15.0       0.0               39.0 34 1 2 2                 24 15                 39
259389 259389 SD     school 4674370 13001   Vermillion 13-1 467437000300 3 Austin Elementary School   Regular School No Elementary PK 01 2018   k_12_total 155.0 5.0 5.0 21.0   5.0         11.0   109.0 93.0       1.5               202.0 155 5 5 21   5         11   109 93                 202
259390 259390 SD     school 4674370 13001   Vermillion 13-1 467437000301 4 Jolley Elementary School   Regular School No Elementary 02 05 2018   k_12_total 257.0 5.0 12.0 39.0   7.0       3.0 25.0   182.0 166.0       1.2               348.0 257 5 12 39   7       3 25   182 166                 348
259391 259391 SD     school 4674370 13001   Vermillion 13-1 467437000691 1 Vermillion High School   Regular School No High 09 12 2018   k_12_total 303.0 8.0 19.0 39.0   5.0       2.0 2.0   174.0 204.0       0.3               378.0 303 8 19 39   5       2 2   174 204                 378
259392 259392 SD     school 4674370 13001   Vermillion 13-1 467437000690 2 Vermillion Middle School   Regular School No Middle 06 08 2018   k_12_total 220.0 4.0 13.0 31.0   8.0         12.0   146.0 142.0       1.0               288.0 220 4 13 31   8         12   146 142                 288
254641 254641 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901255 2 Irene-Wakonda Elementary School   Regular School No Elementary PK 06 2018   k_12_total 146.0   2.0 4.0             4.0   80.0 76.0       0.0               156.0 146   2 4             4   80 76                 156
254642 254642 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901254 1 Irene-Wakonda High School   Regular School No High 09 12 2018   k_12_total 84.0 1.0 3.0 2.0                 48.0 42.0       0.0               90.0 84 1 3 2                 48 42                 90
254643 254643 SD     school 4680439 13003   Irene-Wakonda 13-3 468043901253 4 Irene-Wakonda Junior High   Regular School No Middle 07 08 2018   k_12_total 47.0     1.0                 19.0 29.0       0.0               48.0 47     1                 19 29                 48
253153 253153 SD     school 4624540 14001   Florence 14-1 462454000208 2 Florence Elementary School   Regular School No Elementary PK 05 2018   k_12_total 127.0     2.0             1.0   64.0 66.0       0.0               130.0 127     2             1   64 66                 130
253154 253154 SD     school 4624540 14001   Florence 14-1 462454000209 1 Florence High School   Regular School No High 09 12 2018   k_12_total 62.0     3.0   1.0         3.0   36.0 33.0       0.0               69.0 62     3   1         3   36 33                 69
253155 253155 SD     school 4624540 14001   Florence 14-1 462454000589 3 Florence Middle School   Regular School No Middle 06 08 2018   k_12_total 55.0                   1.0   32.0 24.0       0.0               56.0 55                   1   32 24                 56
254001 254001 SD     school 4632340 14002   Henry 14-2 463234000275 2 Henry Elementary   Regular School No Elementary PK 04 2018   k_12_total 52.0 0.0       1.0             21.0 32.0       0.0               53.0 52 0       1             21 32                 53
254002 254002 SD     school 4632340 14002   Henry 14-2 463234000276 1 Henry High School   Regular School No High 09 12 2018   k_12_total 54.0 2.0   1.0                 29.0 28.0       0.0               57.0 54 2   1                 29 28                 57
254003 254003 SD     school 4632340 14002   Henry 14-2 463234001047 3 Henry MS   Regular School No Middle 05 08 2018   k_12_total 52.0 1.0 1.0     1.0             24.0 31.0       0.0               55.0 52 1 1     1             24 31                 55
259741 259741 SD     school 4676620 14004   Watertown 14-4 467662001083 9 Jefferson Elementary   Regular School No Elementary KG 04 2018   k_12_total 341.0 1.0 17.0 6.0   4.0         11.0   195.0 185.0       1.3               380.0 341 1 17 6   4         11   195 185                 380
259742 259742 SD     school 4676620 14004   Watertown 14-4 467662000944 5 Lincoln Elementary School   Regular School No Elementary KG 04 2018   k_12_total 355.0 2.0 11.0 5.0   7.0         6.0   199.0 187.0       2.3               386.0 355 2 11 5   7         6   199 187                 386
259743 259743 SD     school 4676620 14004   Watertown 14-4 467662000713 6 McKinley Elementary School   Regular School No Elementary PK 04 2018   k_12_total 168.0   17.0 22.0             14.0   107.0 114.0       0.0               221.0 168   17 22             14   107 114                 221
259744 259744 SD     school 4676620 14004   Watertown 14-4 467662000714 7 Mellette Elementary School   Regular School No Elementary KG 04 2018   k_12_total 212.0 1.0 3.0 14.0   1.0         7.0   117.0 121.0       0.4               238.0 212 1 3 14   1         7   117 121                 238
259745 259745 SD     school 4676620 14004   Watertown 14-4 467662000716 8 Roosevelt Elementary   Regular School No Elementary PK 04 2018   k_12_total 181.0 3.0 8.0 12.0   1.0       1.0 15.0   126.0 95.0       1.4               221.0 181 3 8 12   1       1 15   126 95                 221
259746 259746 SD     school 4676620 14004   Watertown 14-4 467662000717 1 Watertown High School   Regular School No High 09 12 2018   k_12_total 1086.0 8.0 38.0 45.0   10.0       1.0 23.0   619.0 592.0       0.5               1211.0 1086 8 38 45   10       1 23   619 592                 1211
259747 259747 SD     school 4676620 14004   Watertown 14-4 467662001378 13 Watertown Intermediate   Regular School No Middle 05 06 2018   k_12_total 543.0 3.0 27.0 21.0   8.0         27.0   316.0 313.0       0.8               629.0 543 3 27 21   8         27   316 313                 629
259748 259748 SD     school 4676620 14004   Watertown 14-4 467662000718 2 Watertown Middle School   Regular School No Middle 07 08 2018   k_12_total 550.0 5.0 20.0 32.0   6.0         14.0   313.0 314.0       0.3               627.0 550 5 20 32   6         14   313 314                 627
259857 259857 SD     school 4676740 14005   Waverly 14-5 467674000721 2 Waverly/South Shore Elementary   Regular School No Elementary PK 05 2018   k_12_total 109.0 1.0 1.0 3.0             2.0   70.0 46.0       0.0               116.0 109 1 1 3             2   70 46                 116
259858 259858 SD     school 4676740 14005   Waverly 14-5 467674000722 1 Waverly/South Shore High School   Regular School No High 09 12 2018   k_12_total 68.0   3.0 3.0             2.0   34.0 42.0       0.0               76.0 68   3 3             2   34 42                 76
259859 259859 SD     school 4676740 14005   Waverly 14-5 467674000946 3 Waverly/South Shore Middle School   Regular School No Middle 06 08 2018   k_12_total 51.0     1.0           1.0     27.0 26.0       0.0               53.0 51     1           1     27 26                 53
255601 255601 SD     school 4646260 15001   McIntosh 15-1 464626000410 2 McIntosh Elementary   Regular School No Elementary PK 06 2018   k_12_total 52.0 3.0 3.0 31.0             10.0   49.0 50.0       0.0               99.0 52 3 3 31             10   49 50                 99
255602 255602 SD     school 4646260 15001   McIntosh 15-1 464626000411 1 McIntosh High School   Regular School No High 09 12 2018   k_12_total 34.0 2.0 1.0 14.0   1.0         1.0   26.0 27.0       0.0               53.0 34 2 1 14   1         1   26 27                 53
255603 255603 SD     school 4646260 15001   McIntosh 15-1 464626000921 3 McIntosh Jr High   Regular School No Middle 07 08 2018   k_12_total 16.0     14.0             2.0   17.0 15.0       0.0               32.0 16     14             2   17 15                 32
255649 255649 SD     school 4646380 15002   McLaughlin 15-2 464638000415 2 McLaughlin Elementary   Regular School No Elementary PK 05 2018   k_12_total 2.0   3.0 190.0             1.0   103.0 93.0       0.5               196.0 2   3 190             1   103 93                 196
255650 255650 SD     school 4646380 15002   McLaughlin 15-2 464638000416 1 McLaughlin High School   Regular School No High 09 12 2018   k_12_total 1.0   1.0 146.0             1.0   80.0 69.0       4.0               149.0 1   1 146             1   80 69                 149
255651 255651 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2018   k_12_total 3.0   2.0 92.0                 51.0 46.0       2.1               97.0 3   2 92                 51 46                 97
258625 258625 SD     school 4675600 15003   Smee 15-3 467560000698 2 Wakpala Elementary   Regular School No Elementary KG 05 2018   k_12_total 2.0     85.0             4.0   48.0 43.0       0.0               91.0 2     85             4   48 43                 91
258626 258626 SD     school 4675600 15003   Smee 15-3 467560000699 1 Wakpala High School   Regular School No High 09 12 2018   k_12_total       58.0                 32.0 26.0       10.3               58.0       58                 32 26                 58
258627 258627 SD     school 4675600 15003   Smee 15-3 467560001326 4 Wakpala MS   Regular School No Middle 06 08 2018   k_12_total       51.0                 28.0 23.0       0.0               51.0       51                 28 23                 51
251869 251869 SD     school 4616950 16001   Custer 16-1 461695000154 2 Custer Elementary   Regular School No Elementary PK 06 2018   k_12_total 288.0 1.0 29.0 16.0   2.0         7.0   173.0 170.0       1.2               343.0 288 1 29 16   2         7   173 170                 343
251870 251870 SD     school 4616950 16001   Custer 16-1 461695000155 1 Custer High School   Regular School No High 09 12 2018   k_12_total 214.0 2.0 12.0 7.0           1.0 4.0   115.0 125.0       0.8               240.0 214 2 12 7           1 4   115 125                 240
251871 251871 SD     school 4616950 16001   Custer 16-1 461695000992 5 Custer JH   Regular School No Middle 07 08 2018   k_12_total 92.0 2.0 7.0 5.0             2.0   48.0 60.0       0.0               108.0 92 2 7 5             2   48 60                 108
251872 251872 SD     school 4616950 16001   Custer 16-1 461695000159 4 Hermosa Elem   Regular School No Elementary KG 08 2018   k_12_total 166.0   8.0 13.0           1.0 16.0   98.0 106.0       0.0               204.0 166   8 13           1 16   98 106                 204
252597 252597 SD     school 4621300 16002   Elk Mountain 16-2 462130000899 1 Elk Mountain Elem   Regular School No Elementary PK 08 2018   k_12_total 10.0   2.0                   7.0 5.0       0.0               12.0 10   2                   7 5                 12
252598 252598 SD     school 4621300 16002   Elk Mountain 16-2 462130001371 4 Elk Mountain High School   Regular School No High 09 12 2018   k_12_total 2.0                       1.0 1.0       0.0               2.0 2                       1 1                 2
252817 252817 SD     school 4622500 17001   Ethan 17-1 462250000193 2 Ethan Elementary   Regular School No Elementary PK 06 2018   k_12_total 122.0   3.0 2.0             3.0   60.0 70.0       0.8               130.0 122   3 2             3   60 70                 130
252818 252818 SD     school 4622500 17001   Ethan 17-1 462250000194 1 Ethan High School   Regular School No High 09 12 2018   k_12_total 74.0   3.0               1.0   37.0 41.0       1.3               78.0 74   3               1   37 41                 78
252819 252819 SD     school 4622500 17001   Ethan 17-1 462250000903 3 Ethan Jr. High   Regular School No Middle 07 08 2018   k_12_total 37.0   2.0               1.0   19.0 21.0       2.5               40.0 37   2               1   19 21                 40
256113 256113 SD     school 4648390 17002   Mitchell 17-2 464839000591 4 Gertie Belle Rogers Elem   Regular School No Elementary KG 05 2018   k_12_total 343.0 5.0 18.0 48.0   2.0         8.0   211.0 213.0       1.2               424.0 343 5 18 48   2         8   211 213                 424
256114 256114 SD     school 4648390 17002   Mitchell 17-2 464839000520 3 L B Williams Elementary   Regular School No Elementary KG 05 2018   k_12_total 418.0 8.0 36.0 36.0   1.0         14.0   257.0 256.0       1.8               513.0 418 8 36 36   1         14   257 256                 513
256115 256115 SD     school 4648390 17002   Mitchell 17-2 464839000441 5 Longfellow Elementary   Regular School No Elementary KG 05 2018   k_12_total 269.0 3.0 27.0 33.0             15.0   172.0 175.0       3.5               347.0 269 3 27 33             15   172 175                 347
256116 256116 SD     school 4648390 17002   Mitchell 17-2 464839000442 1 Mitchell High School   Regular School No High 09 12 2018   k_12_total 662.0 8.0 35.0 38.0   8.0         26.0   389.0 388.0       0.9               777.0 662 8 35 38   8         26   389 388                 777
256117 256117 SD     school 4648390 17002   Mitchell 17-2 464839000437 2 Mitchell Middle School   Regular School No Middle 06 08 2018   k_12_total 549.0 5.0 22.0 34.0   9.0       4.0 15.0   343.0 295.0       1.1               638.0 549 5 22 34   9       4 15   343 295                 638
256118 256118 SD     school 4648390 17002   Mitchell 17-2 464839000444 10 Rockport Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 17.0                       6.0 11.0       64.7               17.0 17                       6 11                 17
256119 256119 SD     school 4648390 17002   Mitchell 17-2 464839000445 11 Rosedale Colony Elem   Regular School No Elementary KG 08 2018   k_12_total 23.0                       14.0 9.0       56.5               23.0 23                       14 9                 23
256305 256305 SD     school 4649650 17003   Mount Vernon 17-3 464965000454 2 Mount Vernon Elementary   Regular School No Elementary PK 05 2018   k_12_total 89.0 2.0 1.0 2.0                 50.0 44.0       0.0               94.0 89 2 1 2                 50 44                 94
256306 256306 SD     school 4649650 17003   Mount Vernon 17-3 464965000455 1 Mount Vernon High School   Regular School No High 09 12 2018   k_12_total 55.0   8.0 4.0                 39.0 28.0       1.5               67.0 55   8 4                 39 28                 67
256307 256307 SD     school 4649650 17003   Mount Vernon 17-3 464965000967 3 Mount Vernon MS   Regular School No Middle 06 08 2018   k_12_total 48.0   3.0 2.0                 24.0 29.0       0.0               53.0 48   3 2                 24 29                 53
259809 259809 SD     school 4676680 18003   Waubay 18-3 467668000719 2 Waubay Elem   Regular School No Elementary PK 05 2018   k_12_total 51.0     41.0             1.0   60.0 33.0       0.0               93.0 51     41             1   60 33                 93
259810 259810 SD     school 4676680 18003   Waubay 18-3 467668000720 1 Waubay Hi Sch   Regular School No High 09 12 2018   k_12_total 19.0   3.0 25.0                 25.0 22.0       2.1               47.0 19   3 25                 25 22                 47
259811 259811 SD     school 4676680 18003   Waubay 18-3 467668000945 3 Waubay Middle School   Regular School No Middle 06 08 2018   k_12_total 8.0     20.0                 19.0 9.0       0.0               28.0 8     20                 19 9                 28
259905 259905 SD     school 4676990 18005   Webster Area 467699000723 3 Webster Area Elementary School   Regular School No Elementary PK 05 2018   k_12_total 233.0   8.0 6.0   1.0       1.0 12.0   130.0 131.0       0.4               261.0 233   8 6   1       1 12   130 131                 261
259906 259906 SD     school 4676990 18005   Webster Area 467699000724 1 Webster Area High School   Regular School No High 09 12 2018   k_12_total 140.0   3.0 1.0             2.0   77.0 69.0       0.0               146.0 140   3 1             2   77 69                 146
259907 259907 SD     school 4676990 18005   Webster Area 467699000947 2 Webster Area Middle School   Regular School No Middle 06 08 2018   k_12_total 120.0   2.0 1.0             3.0   63.0 63.0       0.0               126.0 120   2 1             3   63 63                 126
252161 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 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 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
252461 252461 SD     school 4620100 20001   Eagle Butte 20-1 462010000956 1 C-EB High School   Regular School No High 09 12 2018   k_12_total 10.0     1.0                 5.0 6.0       0.0               11.0 10     1                 5 6                 11
252462 252462 SD     school 4620100 20001   Eagle Butte 20-1 462010000898 6 C-EB Junior High   Regular School No Middle 07 08 2018   k_12_total 3.0   1.0 2.0                 2.0 4.0       0.0               6.0 3   1 2                 2 4                 6

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