Data source: Big Local News · About: Big Local

75,136 rows where state = "SD" sorted by ell_percent descending

View and edit SQL

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
457455 SD     school 4666270 49005   Sioux Falls 49-5 466627001175 43 Elem. Immersion Center   Regular School Not applicable Elementary KG 05 2021   k_12_total 5.0 25.0 84.0     2.0       1.0     65.0 52.0       99.2               117.0 5 25 84     2       1     65 52                 117
450745 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 36.0                       15.0 21.0       94.4               36.0 36                       15 21                 36
453659 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School Not applicable Elementary PK 08 2021   k_12_total 18.0                       10.0 8.0       94.4               18.0 18                       10 8                 18
450747 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School Not applicable Elementary KG 08 2021   k_12_total 34.0                       17.0 17.0       94.1               34.0 34                       17 17                 34
459416 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School Not applicable Elementary KG 08 2021   k_12_total 16.0                       8.0 8.0       93.8               16.0 16                       8 8                 16
453559 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 15.0                       8.0 7.0       93.3               15.0 15                       8 7                 15
358800 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2019   k_12_total 14.0                       8.0 6.0       92.9               14.0 14                       8 6                 14
495189 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School Not applicable Elementary KG 08 2020   k_12_total 22.0                       12.0 10.0       90.9               22.0 22                       12 10                 22
453555 SD     school 4635480 2002   Huron 02-2 463548000312 13 Huron Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 21.0                       14.0 7.0       90.5               21.0 21                       14 7                 21
257629 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No Elementary KG 08 2018   k_12_total 20.0                       12.0 8.0       90.0               20.0 20                       12 8                 20
450234 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2021   k_12_total 202.0 8.0 21.0 6.0   7.0         20.0   145.0 119.0       9.9               264.0 202 8 21 6   7         20   145 119                 264
3353291 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No 1 KG 04 2016   k_12_total 49.0 7.0 5.0 1.0   1.0         5.0   37.0 31.0       9.8               68.0 49 7 5 1   1         5   37 31                 68
3015366 SD     school 4600052 41005   Tea Area 41-5 460005201358 5 Tea Area Frontier Elementary   Regular School No Elementary KG 04 2017   k_12_total 62.0 9.0 8.0 1.0   2.0         10.0   53.0 39.0       9.8               92.0 62 9 8 1   2         10   53 39                 92
358796 SD     school 4612300 39001   Chester Area 39-1 461230001269 92 Chester Area Cyber School   Regular School No High 09 12 2019   k_12_total 112.0                       76.0 36.0       9.8               112.0 112                       76 36                 112
359956 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School No Elementary PK 06 2019   k_12_total 125.0   28.0 1.0             9.0   82.0 81.0       9.8               163.0 125   28 1             9   82 81                 163
490226 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School Not applicable High 09 12 2020   k_12_total 91.0 1.0 14.0 2.0             4.0   62.0 50.0       9.8               112.0 91 1 14 2             4   62 50                 112
490597 SD     school 4624390 50003   Flandreau 50-3 462439000207 4 Flandreau Elem   Regular School Not applicable Elementary KG 04 2020   k_12_total 108.0   43.0 76.0   4.0       3.0 31.0   142.0 123.0       9.8               265.0 108   43 76   4       3 31   142 123                 265
452175 SD     school 4624390 50003   Flandreau 50-3 462439000206 1 Flandreau High Sch   Regular School Not applicable High 09 12 2021   k_12_total 88.0   29.0 57.0   2.0       1.0 7.0   111.0 73.0       9.8               184.0 88   29 57   2       1 7   111 73                 184
453008 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School Not applicable Elementary PK 05 2021   k_12_total 323.0 32.0 27.0 7.0   23.0         33.0   210.0 235.0       9.7               445.0 323 32 27 7   23         33   210 235                 445
3352633 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No 4 KG 12 2016   k_12_total 26.0 2.0 1.0     2.0         1.0   21.0 11.0       9.5               32.0 26 2 1     2         1   21 11                 32
3014755 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2017   k_12_total 30.0 2.0 4.0 3.0   2.0         1.0   26.0 16.0       9.5               42.0 30 2 4 3   2         1   26 16                 42
488657 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School Not applicable Elementary KG 03 2020   k_12_total 225.0 12.0 18.0 15.0   10.0       2.0 22.0   169.0 135.0       9.5               304.0 225 12 18 15   10       2 22   169 135                 304
366476 SD     school 4644940 49006   Tri-Valley 49-6 464494000776 2 Tri-Valley Elementary   Regular School No Elementary KG 06 2019   k_12_total 458.0 44.0 33.0 2.0   1.0         13.0   288.0 263.0       9.3               551.0 458 44 33 2   1         13   288 263                 551
457472 SD     school 4666270 49005   Sioux Falls 49-5 466627000813 58 Oscar Howe Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 359.0 64.0 64.0 31.0   7.0         36.0   289.0 272.0       9.3               561.0 359 64 64 31   7         36   289 272                 561
3349956 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No 2 06 08 2016   k_12_total 2.0     96.0           1.0     52.0 47.0       9.2               99.0 2     96           1     52 47                 99
3012092 SD     school 4646380 15002   McLaughlin 15-2 464638000922 3 McLaughlin Middle School   Regular School No Middle 06 08 2017   k_12_total 3.0   2.0 104.0                 56.0 53.0       9.2               109.0 3   2 104                 56 53                 109
358388 SD     school 4608520 5001   Brookings 05-1 460852000085 4 Hillcrest Elem   Regular School No Elementary KG 03 2019   k_12_total 213.0 8.0 16.0 13.0   13.0       1.0 20.0   151.0 133.0       9.2               284.0 213 8 16 13   13       1 20   151 133                 284
258329 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2018   k_12_total 685.0 67.0 65.0 8.0   16.0       1.0 48.0   438.0 452.0       9.1               890.0 685 67 65 8   16       1 48   438 452                 890
451843 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School Not applicable High 09 12 2021   k_12_total 68.0   9.0                   41.0 36.0       9.1               77.0 68   9                   41 36                 77
458271 SD     school 4672090 66001   Todd County 66-1 467209000503 8 Klein Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total     3.0 6.0   1.0         1.0   8.0 3.0       9.1               11.0     3 6   1         1   8 3                 11
365592 SD     school 4666270 49005   Sioux Falls 49-5 466627001238 26 Discovery Elementary   Regular School No Elementary PK 05 2019   k_12_total 681.0 71.0 64.0 5.0   18.0       2.0 44.0   433.0 452.0       9.0               885.0 681 71 64 5   18       2 44   433 452                 885
490225 SD     school 4621390 5003   Elkton 05-3 462139000187 2 Elkton Elementary School   Regular School Not applicable Elementary PK 06 2020   k_12_total 141.0   28.0 1.0           0.0 8.0   90.0 88.0       9.0               178.0 141   28 1           0 8   90 88                 178
450746 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 29.0                       16.0 13.0       89.7               29.0 29                       16 13                 29
3351934 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No 1 KG 08 2016   k_12_total 14.0                       6.0 8.0       89.5               14.0 14                       6 8                 14
3014070 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No Elementary KG 08 2017   k_12_total 19.0                       9.0 10.0       89.5               19.0 19                       9 10                 19
495128 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School Not applicable Elementary KG 08 2020   k_12_total 18.0                       11.0 7.0       88.9               18.0 18                       11 7                 18
452349 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 35.0                       23.0 12.0       88.6               35.0 35                       23 12                 35
488560 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 24.0                       16.0 8.0       87.5               24.0 24                       16 8                 24
489785 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 8.0                       5.0 3.0       87.5               8.0 8                       5 3                 8
459414 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School Not applicable Elementary KG 08 2021   k_12_total 16.0                       8.0 8.0       87.5               16.0 16                       8 8                 16
456766 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School Not applicable Elementary KG 08 2021   k_12_total 23.0                       13.0 10.0       87.0               23.0 23                       13 10                 23
254486 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2018   k_12_total 15.0                       10.0 5.0       86.7               15.0 15                       10 5                 15
361713 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2019   k_12_total 15.0                       8.0 7.0       86.7               15.0 15                       8 7                 15
456705 SD     school 4663360 54004   Rosholt 54-4 466336000558 3 White Rock Colony Elem   Regular School Not applicable Elementary KG 08 2021   k_12_total 22.0                       14.0 8.0       86.4               22.0 22                       14 8                 22
489169 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 29.0                       18.0 11.0       86.2               29.0 29                       18 11                 29
497807 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 14.0                       6.0 8.0       85.7               14.0 14                       6 8                 14
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
489168 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 34.0                       11.0 23.0       85.3               34.0 34                       11 23                 34
358900 SD     school 4612940 12002   Clark 12-2 461294001082 5 Hillcrest Colony Elementary   Regular School No Elementary KG 08 2019   k_12_total 27.0                       17.0 10.0       85.2               27.0 27                       17 10                 27
489170 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 38.0                       20.0 18.0       84.2               38.0 38                       20 18                 38
459415 SD     school 4679350 12003   Willow Lake 12-3 467935001067 4 Mayfield Colony Elem   Regular School Not applicable Elementary KG 08 2021   k_12_total 25.0                       12.0 13.0       84.0               25.0 25                       12 13                 25
367506 SD     school 4679350 12003   Willow Lake 12-3 467935001137 5 Shamrock Colony   Regular School No Elementary KG 08 2019   k_12_total 12.0                       6.0 6.0       83.3               12.0 12                       6 6                 12
458426 SD     school 4672450 33005   Tripp-Delmont 33-5 467245001091 7 Clearfield Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 12.0                       4.0 8.0       83.3               12.0 12                       4 8                 12
251541 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School No Elementary KG 08 2018   k_12_total 16.0                       9.0 7.0       81.3               16.0 16                       9 7                 16
489069 SD     school 4612300 39001   Chester Area 39-1 461230001377 7 Gracevale Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 16.0                       9.0 7.0       81.3               16.0 16                       9 7                 16
491982 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 16.0                       8.0 8.0       81.3               16.0 16                       8 8                 16
455223 SD     school 4648390 17002   Mitchell 17-2 464839000444 10 Rockport Colony Elem   Regular School Not applicable Elementary KG 08 2021   k_12_total 16.0                       8.0 8.0       81.3               16.0 16                       8 8                 16
364904 SD     school 4664140 39004   Rutland 39-4 466414001348 4 Camridge Colony School   Regular School No Elementary KG 08 2019   k_12_total 21.0                       13.0 8.0       81.0               21.0 21                       13 8                 21
490525 SD     school 4624030 24004   Faulkton Area 462403001158 6 Blumengard Colony Elem   Regular School Not applicable Elementary KG 08 2020   k_12_total 31.0                       18.0 13.0       80.7               31.0 31                       18 13                 31
455361 SD     school 4648780 43002   Montrose 43-2 464878001095 4 Orland Colony   Regular School Not applicable Elementary KG 08 2021   k_12_total 31.0                       20.0 11.0       80.7               31.0 31                       20 11                 31
358901 SD     school 4612940 12002   Clark 12-2 461294001319 7 Silver Creek Colony   Regular School No Elementary KG 08 2019   k_12_total 41.0                       22.0 19.0       80.5               41.0 41                       22 19                 41
3350186 SD     school 4647100 33002   Menno 33-2 464710000417 3 Jamesville Colony Elementary   Regular School No 1 PK 08 2016   k_12_total 16.0                       8.0 8.0       80.0               16.0 16                       8 8                 16
3012322 SD     school 4647100 33002   Menno 33-2 464710000417 3 Jamesville Colony Elementary   Regular School No Elementary KG 08 2017   k_12_total 15.0                       9.0 6.0       80.0               15.0 15                       9 6                 15
490772 SD     school 4625500 33001   Freeman 33-1 462550000221 3 Tschetter Colony Elementary   Regular School Not applicable Elementary KG 08 2020   k_12_total 30.0                       19.0 11.0       80.0               30.0 30                       19 11                 30
497805 SD     school 4679350 12003   Willow Lake 12-3 467935001297 6 Collins Colony Elem   Regular School Not applicable Elementary KG 08 2020   k_12_total 15.0                       8.0 7.0       80.0               15.0 15                       8 7                 15
451362 SD     school 4619170 56002   Doland 56-2 461917001299 6 Camrose Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 10.0                       7.0 3.0       80.0               10.0 10                       7 3                 10
453654 SD     school 4636060 22006   Ipswich Public 22-6 463606001085 5 Deerfield Colony Elem   Regular School Not applicable Elementary PK 08 2021   k_12_total 20.0                       12.0 8.0       80.0               20.0 20                       12 8                 20
458427 SD     school 4672450 33005   Tripp-Delmont 33-5 467245000067 5 Greenwood Colony Elementary   Regular School Not applicable Elementary KG 08 2021   k_12_total 5.0                       1.0 4.0       80.0               5.0 5                       1 4                 5
487457 SD     school 4602070 6001   Aberdeen 06-1 460207000008 9 May Overby Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 250.0 14.0 45.0 22.0   17.0       1.0 22.0   182.0 189.0       8.9               371.0 250 14 45 22   17       1 22   182 189                 371
489787 SD     school 4619170 56002   Doland 56-2 461917000170 3 Doland Elementary   Regular School Not applicable Elementary PK 06 2020   k_12_total 51.0   5.0                   33.0 23.0       8.9               56.0 51   5                   33 23                 56
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
451787 SD     school 4621390 5003   Elkton 05-3 462139000188 1 Elkton High School   Regular School Not applicable High 09 12 2021   k_12_total 96.0   13.0 1.0             3.0   62.0 51.0       8.9               113.0 96   13 1             3   62 51                 113
365591 SD     school 4666270 49005   Sioux Falls 49-5 466627001122 41 Community Campus   Special Education School No High 12 12 2019   k_12_total 24.0 5.0 3.0               2.0   23.0 11.0       8.8               34.0 24 5 3               2   23 11                 34
491426 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 425.0 32.0 32.0 9.0   11.0         26.0   269.0 266.0       8.8               535.0 425 32 32 9   11         26   269 266                 535
357256 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School No Elementary KG 05 2019   k_12_total 24.0 1.0 3.0 4.0             3.0   19.0 16.0       8.6               35.0 24 1 3 4             3   19 16                 35
360013 SD     school 4622410 28002   Estelline 28-2 462241000192 1 Estelline High School   Regular School No High 09 12 2019   k_12_total 70.0   10.0               1.0   36.0 45.0       8.6               81.0 70   10               1   36 45                 81
490599 SD     school 4624390 50003   Flandreau 50-3 462439000205 3 Flandreau Middle Sch   Regular School Not applicable Middle 05 08 2020   k_12_total 105.0   35.0 68.0   3.0       1.0 9.0   115.0 106.0       8.6               221.0 105   35 68   3       1 9   115 106                 221
449037 SD     school 4602070 6001   Aberdeen 06-1 460207000009 11 O.M. Tiffany Elementary   Regular School Not applicable Elementary KG 05 2021   k_12_total 226.0 10.0 33.0 15.0   12.0       2.0 26.0   171.0 153.0       8.6               324.0 226 10 33 15   12       2 26   171 153                 324
491431 SD     school 4631350 41002   Harrisburg 41-2 463135001375 9 Horizon Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 244.0 14.0 15.0 3.0   6.0         14.0   147.0 149.0       8.5               296.0 244 14 15 3   6         14   147 149                 296
2970063 SD     school 4666270 49005   Sioux Falls 49-5 466627000587 19 Garfield Elementary   Regular School No 1 PK 05 2015   k_12_total 200.0 42.0 43.0 26.0   1.0       4.0 35.0   177.0 174.0       8.3               351.0 200 42 43 26   1       4 35   177 174                 351
3346798 SD     school 4620100 20001   Eagle Butte 20-1 462010000956 1 C-EB High School   Regular School No 3 09 12 2016   k_12_total 9.0   1.0 5.0                 8.0 7.0       8.3               15.0 9   1 5                 8 7                 15
3007539 SD     school 4608520 5001   Brookings 05-1 460852000086 5 Medary Elem   Regular School No Elementary KG 03 2017   k_12_total 289.0 23.0 23.0 10.0   19.0         11.0   194.0 181.0       8.3               375.0 289 23 23 10   19         11   194 181                 375
3008886 SD     school 4620100 20001   Eagle Butte 20-1 462010000956 1 C-EB High School   Regular School No High 09 12 2017   k_12_total 10.0     2.0                 6.0 6.0       8.3               12.0 10     2                 6 6                 12
258333 SD     school 4666270 49005   Sioux Falls 49-5 466627001123 45 FLEX   Special Education School No High 06 12 2018   k_12_total 16.0 10.0 3.0 5.0             2.0   27.0 9.0       8.3               36.0 16 10 3 5             2   27 9                 36
487458 SD     school 4602070 6001   Aberdeen 06-1 460207001367 7 Mike Miller Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 182.0 7.0 11.0 14.0   14.0       1.0 23.0   132.0 120.0       8.3               252.0 182 7 11 14   14       1 23   132 120                 252
487541 SD     school 4600042 58003   Agar-Blunt-Onida 58-3 460004200855 3 Blunt Elementary   Regular School Not applicable Elementary KG 05 2020   k_12_total 23.0 1.0 3.0 6.0             3.0   15.0 21.0       8.3               36.0 23 1 3 6             3   15 21                 36
490088 SD     school 4634440 22005   Edmunds Central 22-5 463444000032 2 Edmunds Central Middle School   Regular School Not applicable Middle 06 08 2020   k_12_total 19.0   4.0 1.0                 15.0 9.0       8.3               24.0 19   4 1                 15 9                 24
495894 SD     school 4666270 49005   Sioux Falls 49-5 466627001396 47 Odyssey   Alternative School Not applicable Middle 06 08 2020   k_12_total 8.0 6.0 2.0 4.0             4.0   23.0 1.0       8.3               24.0 8 6 2 4             4   23 1                 24
450138 SD     school 4600041 45004   Britton-Hecla 45-4 460004101364 6 Sunset Colony High School   Regular School Not applicable High 09 12 2021   k_12_total 12.0                       7.0 5.0       8.3               12.0 12                       7 5                 12
452346 SD     school 4625500 33001   Freeman 33-1 462550000219 2 Freeman Elem   Regular School Not applicable Elementary KG 05 2021   k_12_total 111.0   16.0 3.0   2.0             70.0 62.0       8.3               132.0 111   16 3   2             70 62                 132
249928 SD     school 4602070 6001   Aberdeen 06-1 460207000007 8 Lincoln Elementary   Regular School No Elementary PK 05 2018   k_12_total 239.0 4.0 33.0 31.0   27.0       3.0 11.0   185.0 163.0       8.1               348.0 239 4 33 31   27       3 11   185 163                 348
491641 SD     school 4633360 51002   Hill City 51-2 463336000279 2 Hill City Elementary   Regular School Not applicable Elementary PK 05 2020   k_12_total 130.0   49.0 7.0   4.0         7.0   93.0 104.0       8.1               197.0 130   49 7   4         7   93 104                 197
361157 SD     school 4631350 41002   Harrisburg 41-2 463135001169 4 Explorer Elementary   Regular School No Elementary PK 05 2019   k_12_total 380.0 21.0 31.0 6.0   7.0         20.0   232.0 233.0       8.0               465.0 380 21 31 6   7         20   232 233                 465
488413 SD     school 4607950 49002   Brandon Valley 49-2 460795001302 6 Fred Assam Elementary   Regular School Not applicable Elementary KG 04 2020   k_12_total 448.0 27.0 23.0     19.0       1.0 20.0   268.0 270.0       8.0               538.0 448 27 23     19       1 20   268 270                 538
362549 SD     school 4641640 44002   Leola 44-2 464164000394 4 Spring Creek Colony Elementary   Regular School No Elementary KG 08 2019   k_12_total 29.0                       18.0 11.0       79.3               29.0 29                       18 11                 29
492082 SD     school 4636060 22006   Ipswich Public 22-6 463606000334 3 Rosette Colony Elem   Regular School Not applicable Elementary PK 08 2020   k_12_total 19.0                       12.0 7.0       79.0               19.0 19                       12 7                 19
3010943 SD     school 4635480 2002   Huron 02-2 463548000318 15 Riverside Colony Elementary   Regular School No Elementary KG 08 2017   k_12_total 18.0                       11.0 7.0       77.8               18.0 18                       11 7                 18
495256 SD     school 4603932 55005   Sanborn Central 55-5 460393200120 5 Upland Colony   Regular School Not applicable Elementary KG 08 2020   k_12_total 27.0                       13.0 14.0       77.8               27.0 27                       13 14                 27
358899 SD     school 4612940 12002   Clark 12-2 461294001081 4 Fordham Colony Elementary   Regular School No Elementary KG 08 2019   k_12_total 31.0                       9.0 22.0       77.4               31.0 31                       9 22                 31
358291 SD     school 4600041 45004   Britton-Hecla 45-4 460004101143 4 Sunset Colony Elementary   Regular School No Elementary KG 08 2019   k_12_total 22.0                       15.0 7.0       77.3               22.0 22                       15 7                 22

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